JDBC连接DB2实例

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();
   }
}