JDBC连接

来源：互联网发布：学为贵封闭班知乎编辑：程序博客网时间：2024/05/22 10:34

JDBC的编程步骤:

连接:

Oracle的连接:

Class.forName("oracle.jdbc.OracleDriver");conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE", "scott", "tiger");

mysql的连接:

Class.forName("com.mysql.jdbc.Driver");conn = DriverManager.getConnection("jdbc:mysql://localhost/mydata?user=root&password=123456");

实例

程序名:TestJDBC.java

程序内容:

package jdbc;import java.sql.*;public class TestJDBC {public static void main(String[] args)  {Connection conn = null;Statement stmt = null;ResultSet rs = null;try {//oracle 连接Class.forName("oracle.jdbc.OracleDriver");conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE", "scott", "tiger");/*//mysql 连接Class.forName("com.mysql.jdbc.Driver");conn = DriverManager.getConnection("jdbc:mysql://localhost/mydata?user=root&password=123456");*/stmt = conn.createStatement();rs = stmt.executeQuery("select * from dept2");while(rs.next()) {System.out.println(rs.getString("deptno") +" " + rs.getString("dname") + " " + rs.getString("loc"));}} catch (ClassNotFoundException e) {e.printStackTrace();} catch (SQLException e) {e.printStackTrace();} finally {try {if(rs != null) {rs.close();rs = null;}if(stmt != null) {stmt.close();stmt = null;}if(conn != null) {conn.close();conn = null;}} catch (SQLException e) {e.printStackTrace();}}}}

0 0