DB2自己带jdbc驱动,具体位置在
C:Program FilesIBMSQLLIBjavadb2jcc.jar
C:Program FilesIBMSQLLIBjavadb2jcc_license_cu.jar
设置CLASSPATH=
.;C:ProgramFilesIBMSQLLIBjavadb2jcc.jar;
C:ProgramFilesIBMSQLLIBjavadb2jcc_license_cu.jar;
C:ProgramFilesIBMSQLLIBjavadb2jcc_license_cisuz.jar
注意:在使用jdbc连接db2时,一定要用ibm自己的jdk,否则执行会出现错误,可能是ibm的jdbc驱动和sun的jdk不兼容的问题。
具体位置在C:Program FilesIBMSQLLIBjavajdk
例子:
package db2;
import java.sql.*;
public class BaseConnection {
private final String driver = "com.ibm.db2.jcc.DB2Driver";
private final String url = "jdbc:db2://localhost:50000/sample";
private final String user = "db2admin";
private final String password = "admin";
private Connection conn = null;
public BaseConnection(){
try {
Class.forName(driver);
this.conn = DriverManager.getConnection(url,user,password);
System.out.println("连接成功了");
} catch (Exception e) {
// TODO: handle exception
System.out.println("加载驱动失败......");
}
}
public Connection getConnection(){
return conn;
}
public void close(){
try {
conn.close();
} catch (Exception e) {
// TODO: handle exception
System.out.println("数据库连接关闭失败......");
}
}
public static void main(String args[]){
BaseConnection cd=new BaseConnection();
}
}
收起