1、Java中的JDBC常用的連接字符串 1. Microsoft SQLServer()        (SqlServer 2000)            Class.forName( "com.microsoft.jdbc.sqlserver.SQLServerDriver" );   

2、0;        cn = DriverManager.getConnection( "jdbc:microsoft:sqlserver:/localhost:1433;databaseName=pubs", sUsr, sPwd );        (SqlServer 2005)     &#

3、160;      Class.forName( "com.microsoft.sqlserver.jdbc.SQLServerDriver" );            cn = DriverManager.getConnection( "jdbc:sqlserver:/localhost:1433;databaseName=pubs&

4、quot;, sUsr, sPwd );2. Oracle(        Class.forName( "oracle.jdbc.driver.OracleDriver" );        cn = DriverManager.getConnection( "jdbc:oracle:thin:MyDbCompute

5、rNameOrIP:1521:ORCL", sUsr, sPwd );        3. MySQL()mm.mysql-2.0.2-bin.jar        Class.forName( "org.gjt.mm.mysql.Driver" );        c

6、n = DriverManager.getConnection( "jdbc:mysql:/MyDbComputerNameOrIP:3306/myDatabaseName", sUsr, sPwd );4. PostgreSQL()pgjdbc2.jar        Class.forName( "org.postgresql.Driver"

7、; );        cn = DriverManager.getConnection( "jdbc:postgresql:/MyDbComputerNameOrIP/myDatabaseName", sUsr, sPwd );5. Sybase()jconn2.jar        Class.forName( "

8、com.sybase.jdbc2.jdbc.SybDriver" );        cn = DriverManager.getConnection( "jdbc:sybase:Tds:MyDbComputerNameOrIP:2638", sUsr, sPwd );        /(Default-Username/Password

9、: "dba"/"sql")6. Microsoft SQLServer()        Class.forName( "net.sourceforge.jtds.jdbc.Driver" );        cn = DriverManager.getConnection( "jdbc

10、:jtds:sqlserver:/MyDbComputerNameOrIP:1433/master", sUsr, sPwd );7. ODBC        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");        Connection cn = DriverManager.getCon

11、nection( "jdbc:odbc:" + sDsn, sUsr, sPwd );8.DB2(新添加)        Class.forName(".DB2Driver");        String url="jdbc:db2:/08:6789/SAMPLE" 

12、0;      cn = DriverManager.getConnection( url, sUsr, sPwd );9.Microsoft SQL Server series (6.5, 7.x and 2000) and Sybase 10        JDBC Name:

13、0;jTDS        URL:         Version: 0.5.1        Download URL:         語(yǔ)法:       

14、0;Class.forName("net.sourceforge.jtds.jdbc.Driver ");        Connection con = DriverManager.getConnection("jdbc:jtds:sqlserver:/host:port/database","user","password");     

15、60;  or        Connection con = DriverManager.getConnection("jdbc:jtds:sybase:/host:port/database","user","password");10.Postgresql        JDBC Name: Postg

16、reSQL JDBC        URL: /        Version: 7.3.3 build 110        Download URL: /download.html

17、60;       語(yǔ)法:        Class.forName("org.postgresql.Driver");         Connection con=DriverManager.getConnection("jdbc:postgresql:/host:port/database","

18、;user","password");11.IBM AS400主機(jī)在用的JDBC語(yǔ)法        有裝V4R4以上版本的Client Access Express        可以在C:Program FilesIBMClient Accessjt400lib        

19、找到 driver 檔案 jt400.zip，并更改擴(kuò)展名成為 jt400.jar        語(yǔ)法:        java.sql.DriverManager.registerDriver (new com.ibm.as400.access.AS400JDBCDriver ();       

20、 Class.forName("com.ibm.as400.access.AS400JDBCConnection");        con = DriverManager.getConnection("jdbc:as400:/IP","user","password");12.informix        Class.for

21、Name("rmix.jdbc.IfxDriver").newInstance();         String url =         "jdbc:informix-sqli:/9:1533/testDB:INFORMIXSERVER=myserver;      

22、;   user=testuser;password=testpassword"        Lib：jdbcdrv.zip<br><br>Class.forName( "com.sybase.jdbc.SybDriver" )        url="jdbc:sybase:Tds::2638/asad

23、emo"        SybConnection connection= (SybConnection)DriverManager.getConnection(url,"dba","sql");13.SAP DB        Class.forName ("com.sap.dbtech.jdbc.DriverSapDB");

24、        java.sql.Connection connection = java.sql.DriverManager.getConnection ( "jdbc:sapdb:/" + host + "/" + database_name,user_name, password)      

25、          14.InterBase        String url = "jdbc:interbase:/localhost/e:/testbed/database/employee.gdb"        Class.forName("erclient.Driver");        /Driver d = new erclient.Driver (); /* this will also work