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