JDBC连接 各数据库 记录备份

JDBC连接 JDBC连接DB2.txt
DB2自己带jdbc驱动，具体位置在C:\Program Files\IBM\SQLLIB\java\db2jcc.jar
C:\Program Files\IBM\SQLLIB\java\db2jcc_license_cu.jar
C:\Program Files\IBM\SQLLIB\java\db2jcc_license_cisuz.jar

设置CLASSPATH=.;C:\Program Files\IBM\SQLLIB\java\db2jcc.jar;C:\Program Files\IBM\SQLLIB\java\db2jcc_license_cu.jar;C:\Program Files\IBM\SQLLIB\java\db2jcc_license_cisuz.jar

注意：在使用jdbc连接db2时，一定要用ibm自己的jdk，否则执行会出现错误，可能是ibm的jdbc驱动和sun的jdk不兼容的问题
具体位置在C:\Program Files\IBM\SQLLIB\java\jdk

例子：
import java.sql.*;
public class ConDB2{
Connection con;
Statement st;
ResultSet rs;
public ConDB2(){
try{
String name="com.ibm.db2.jcc.DB2Driver";
String url="jdbc:db2://localhost:50000/database";
Class.forName(name);
con=DriverManager.getConnection(url,"user","password");
System.out.println("连接成功!");
con.close();
}catch(Exception e){
e.printStackTrace();
}
}

public static void main(String args[]){
ConDB2 cd=new ConDB2();
}
}
JDBC连接MySQL.txt
下载MySQLJDBC驱动

设置CLASSPATH=.;C:\Program Files\MySQL\mysql-connector-java-3.2.0-alpha\mysql-connector-java-3.2.0-alpha\mysql-connector-java-3.2.0-alpha-bin.jar

例子：
import java.sql.*;
public class ConMysql{
Connection con;
Statement st;
ResultSet rs;
public ConMysql(){
try{
String name="com.mysql.jdbc.Driver";
String url="jdbc:mysql://localhost/database?user=user&password=password";
Class.forName(name);
con=DriverManager.getConnection(url);
System.out.println("连接成功!");
con.close();
}catch(Exception e){
e.printStackTrace();
}
}

public static void main(String args[]){
ConMysql cms=new ConMysql();
}

}
JDBC连接ORACLE.txt
oracle自己带jdbc驱动，具体位置在C:\oracle\ora92\jdbc\lib\classes12.jar

设置CLASSPATH=.;C:\oracle\ora92\jdbc\lib\classes12.jar

例子：
import java.sql.*;
public class ConOracle{
Connection con;
Statement st;
ResultSet rs;
public ConOracle(){
try{
String name="oracle.jdbc.driver.OracleDriver";
String url="jdbc:oracle:thin@localhost:1521:database";
Class.forName(name);
con=DriverManager.getConnection(url,"user","password");
System.out.println("连接成功!");
con.close();
}catch(Exception e){
e.printStackTrace();
}


public static void main(String args[]){
ConOracle co=new ConOracle();
}

}
JDBC连接SQL Server.txt
下载SQL Server JDBC驱动

设置CLASSPATH=.;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar

例子：
import java.sql.*;
public class ConSqlserver{
Connection con;
Statement st;
ResultSet rs;
public ConSqlserver(){
try{
String name="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=northwind;User=user;Password=password"; Class.forName(name);
con=DriverManager.getConnection(url,"user","password");
System.out.println("连接成功!");
con.close();
}catch(Exception e){
e.printStackTrace();
}
}

public static void main(String args[]){
ConSqlserver cs=new ConSqlserver();
}

}