JDBC 連接大全 ( SQL Server, ORACLE, MySQL, DB2 )

???????? 引用請注明出處 :http//www.tkk7.com/SINOJAVA

?

1.? JDBC 連接 SQL Server?????????????????????????????????????

?

?

下載 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();?

??? }

?

}

?

2.JDBC 連接 ORACLE- -??????????????????????????????????????

?

?

oracle 自己帶 jdbc 驅動，具體位置在 C:\oracleora92\jdbc\lib\classes12.jar

?

設置 CLASSPATH=.;C:\oracleora92\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();?

?}

}

?

3.JDBC 連接 MySQL????????????????????????????????????

?

?

下載 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();?

?}

}

?

4. JDBC 連接 DB2- -??????????????????????????????????????

?

?

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:\ProgramFiles\IBM\SQLLIB\java\db2jcc.jar;

C:\ProgramFiles\IBM\SQLLIB\java\db2jcc_license_cu.jar;

C:\ProgramFiles\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();?

?}

}

?