JDBC主要接口和类简介及常用JDBC连接code

 

接口或者类	功能描述
Driver接口	驱动器
DriverManager类	驱动管理器
Connection接口	数据库连接
Statement接口	执行SQL语句
PreparedStatement接口	执行预编译的SQL语句
CallableStatement接口	执行SQL的存储过程
ResultSet接口	SQL查询语句返回的结果集

 

 

 

常用数据库的JDBC连接代码：

SqlServer:

Class.forName("com.microsoft.jdbc.sqlserver.SQL ServerDriver");String url = "jdbc:microsoft:sqlserver://localhost;databaseName=libSystem";String user = "xxx";String password = "xxx";Connection conn = DriverManager.getConnection(url,user,password); 

Oracle数据库：

 

Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();String url = "jdbc:oracle:thin:@hostname:1521：SID ";String user = "xxx";String password = "xxx";Connection conn = DriverManager.getConnection(url,user,password); 

 

DB2数据库：

Class.forName("com.ibm.db2.jdbc.app.DB2Driver").newInstance();String url = "jdbc:db2://hostname:5000：SID ";String user = "xxx";String password = "xxx";Connection conn = DriverManager.getConnection(url,user,password); 

Sybase数据库：

Class.forName("com.sybase.jdbc.SybDriver").newInstance();String url = "jdbc:sybase:Tds:hostname:5007/SID ";Properties sysProps = System.getProperties();sysProps.put("user","sa");sysProps.put("password","");Connection conn = DriverManager.getConnection(url,sysProps); 

Informix数据库：

Class.forName("com.infoxmix.jdbc.IfxDriver").newInstance();String url = "jdbc:infoxmix-sqli://hostname:1533/SID: INFORMIXSERVER=myserver;user=Informix;password=Informix ";Connection conn = DriverManager.getConnection(url); 

MySQL数据库：

Class.forName("org.gjt.mm.mysql.Driver").newInstance();String url = "jdbc:mysql://hostname/SID ?user=root&password=root &useUnicode=true &characterEncoding=GB2312";Connection conn = DriverManager.getConnection(url);