淺析JAVA常用JDBC連接數據庫的方法總結

　　一JDBC連接DB

復制代碼 代碼如下:
ClassforName("ComibmdbjdbcnetDBDriver");  
String url="jdbc:db://dburl:port/DBname"  
cn = DriverManagergetConnection( url sUsr sPwd ); 
ClassforName("ComibmdbjdbcnetDBDriver");
String url="jdbc:db://dburl:port/DBname"
cn = DriverManagergetConnection( url sUsr sPwd );

　　
二JDBC連接Microsoft SQLServer(microsoft)

復制代碼 代碼如下:
ClassforName( "commicrosoftjdbcsqlserverSQLServerDriver" );  
cn = DriverManagergetConnection( "jdbc:microsoft:sqlserver://DBServerIP:;databaseName=master" sUsr sPwd );  
ClassforName( "commicrosoftjdbcsqlserverSQLServerDriver" );
cn = DriverManagergetConnection( "jdbc:microsoft:sqlserver://DBServerIP:;databaseName=master" sUsr sPwd );

　　
三JDBC連接Sybase(jconnjar)

復制代碼 代碼如下:
ClassforName( "comsybasejdbcjdbcSybDriver" );  
cn = DriverManagergetConnection( "jdbc:sybase:Tds:DBServerIP:" sUsr sPwd );  
ClassforName( "comsybasejdbcjdbcSybDriver" );
cn = DriverManagergetConnection( "jdbc:sybase:Tds:DBServerIP:" sUsr sPwd );

　　
四JDBC連接MySQL(mmmysqlbinjar)

復制代碼 代碼如下:
ClassforName( "orggjtmmmysqlDriver" );  
cn = DriverManagergetConnection( "jdbc:mysql://DBServerIP:/myDatabaseName" sUsr sPwd );  
ClassforName( "orggjtmmmysqlDriver" );
cn = DriverManagergetConnection( "jdbc:mysql://DBServerIP:/myDatabaseName" sUsr sPwd );

　　
五JDBC連接PostgreSQL(pgjdbcjar)

復制代碼 代碼如下:
ClassforName( "orgpostgresqlDriver" );  
cn = DriverManagergetConnection( "jdbc:postgresql://DBServerIP/myDatabaseName" sUsr sPwd );  
ClassforName( "orgpostgresqlDriver" );
cn = DriverManagergetConnection( "jdbc:postgresql://DBServerIP/myDatabaseName" sUsr sPwd );

　　
六JDBC連接Oracle(classesjar)

復制代碼 代碼如下:
ClassforName( "oraclejdbcdriverOracleDriver" );  
cn = DriverManagergetConnection( "jdbc:oracle:thin:@MyDbComputerNameOrIP::ORCL" sUsr sPwd );  
ClassforName( "oraclejdbcdriverOracleDriver" );
cn = DriverManagergetConnection( "jdbc:oracle:thin:@MyDbComputerNameOrIP::ORCL" sUsr sPwd );

　　
七JDBC連接ODBC

復制代碼 代碼如下:

　　
ClassforName( "sunjdbcodbcJdbcOdbcDriver" );  
Connection cn = DriverManagergetConnection( "jdbc:odbc:" + sDsn sUsr sPwd );  

From:http://tw.wingwit.com/Article/program/Java/JSP/201311/19892.html