JAVA中10六种主流数据库的JDBC连接字符串

JAVA中十六种主流数据库的JDBC连接字符串

JAVA中十六种主流数据库的JDBC连接字符串，方便大家查询。1?.?Microsoft?SQLServer(?http:?//?www.microsoft.com)?

?????????(SqlServer?2000)?
????????????Class.forName(?"?com.microsoft.jdbc.sqlserver.SQLServerDriver"?);?
????????????cn?=?DriverManager.getConnection(?"?jdbc:microsoft:sqlserver://localhost:1433;databaseName=pubs",?sUsr,?sPwd?);?

?????????(SqlServer?2005)?
????????????Class.forName(?"?com.microsoft.sqlserver.jdbc.SQLServerDriver"?);?
????????????cn?=?DriverManager.getConnection(?"?jdbc:sqlserver://localhost:1433;databaseName=pubs",?sUsr,?sPwd?);项目开发流程详解：?http://zz563143188.iteye.com/blog/1825168?
2.?Oracle(?http:?//?www.oracle.com/ip/deploy/database/oracle9i/)classes12.zip?
????????Class.forName(?"?oracle.jdbc.driver.OracleDriver"?);?
????????cn?=?DriverManager.getConnection(?"?jdbc:oracle:thin:@MyDbComputerNameOrIP:1521:ORCL",?sUsr,?sPwd?);?
?????????
3.?MySQL(?http:?//?www.mysql.com)mm.mysql-2.0.2-bin.jar?
????????Class.forName(?"org.gjt.mm.mysql.Driver"?);?
????????cn?=?DriverManager.getConnection(?"jdbc:mysql://MyDbComputerNameOrIP:3306/myDatabaseName",?sUsr,?sPwd?);?

4?.?PostgreSQL(?http:?//?www.de.postgresql.org)pgjdbc2.jar?
????????Class.forName(?"org.postgresql.Driver"?);?
????????cn?=?DriverManager.getConnection(?"jdbc:postgresql://MyDbComputerNameOrIP/myDatabaseName",?sUsr,?sPwd?);?

5?.?Sybase(?http:?//?jtds.sourceforge.net)jconn2.jar?
????????Class.forName(?"com.sybase.jdbc2.jdbc.SybDriver"?);?
????????cn?=?DriverManager.getConnection(?"jdbc:sybase:Tds:MyDbComputerNameOrIP:2638",?sUsr,?sPwd?);?
?????????//?(Default-Username/Password:?"dba"/"sql")?

6?.?Microsoft?SQLServer(?http:?//?jtds.sourceforge.net)?
????????Class.forName(?"net.sourceforge.jtds.jdbc.Driver"?);?
????????cn?=?DriverManager.getConnection(?"jdbc:jtds:sqlserver://MyDbComputerNameOrIP:1433/master",?sUsr,?sPwd?);?

7?.?ODBC?
????????Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");?
????????Connection?cn?=?DriverManager.getConnection(?"jdbc:odbc:"?+?sDsn,?sUsr,?sPwd?);?

8.DB2(新添加)?
????????Class.forName("com.ibm.db2.jdbc.net.DB2Driver");?
????????String?url="jdbc:db2://192.9.200.108:6789/SAMPLE"?
????????cn?=?DriverManager.getConnection(?url,?sUsr,?sPwd?);?

9.Microsoft?SQL?Server?series?(6.5,?7.x?and?2000)?and?Sybase?10?

????????JDBC?Name:?jTDS?
????????URL:?http:?//?jtds.sourceforge.net/?
????????Version:?0.5.1?
????????Download?URL:?http:?//?sourceforge.net/project/showfiles.php?group_id=33291?

????????语法:?
????????Class.forName("net.sourceforge.jtds.jdbc.Driver?");?
????????Connection?con?=?DriverManager.getConnection("jdbc:jtds:sqlserver://host:port/database","user","password");?
????????or?
????????Connection?con?=?DriverManager.getConnection("jdbc:jtds:sybase://host:port/database","user","password");?

10?.Postgresql?
????????JDBC?Name:?PostgreSQL?JDBC?
????????URL:?http:?//?jdbc.postgresql.org/?
????????Version:?7.3.3?build?110?
????????Download?URL:?http:?//?jdbc.postgresql.org/download.html?
????????语法:?
????????Class.forName("org.postgresql.Driver");??
????????Connection?con=DriverManager.getConnection("jdbc:postgresql://host:port/database","user","password");?

11.IBM?AS400主机在用的JDBC语法?
????????有装V4R4以上版本的Client?Access?Express?
????????可以在C:\Program?Files\IBM\Client?Access\jt400\lib?
????????找到?driver?档案?jt400.zip，并更改扩展名成为?jt400.jar?
????????语法:?
????????java.sql.DriverManager.registerDriver?(?new?com.ibm.as400.access.AS400JDBCDriver?());?
????????Class.forName("com.ibm.as400.access.AS400JDBCConnection");?
????????con?=?DriverManager.getConnection("jdbc:as400://IP","user","password");?

12?.informix?
????????Class.forName("com.informix.jdbc.IfxDriver").newInstance();??
????????String?url?=??
????????"jdbc:informix-sqli://123.45.67.89:1533/testDB:INFORMIXSERVER=myserver;??
????????user=testuser;password=testpassword";?
????????Lib：jdbcdrv.zip<br><br>Class.forName(?"com.sybase.jdbc.SybDriver"?)?
????????url="jdbc:sybase:Tds:127.0.0.1:2638/asademo";?
????????SybConnection?connection=?(SybConnection)DriverManager.getConnection(url,"dba","sql");?

13?.SAP?DB?
????????Class.forName?("com.sap.dbtech.jdbc.DriverSapDB");?
????????java.sql.Connection?connection?=?java.sql.DriverManager.getConnection?(?"jdbc:sapdb://"?+?host?+?"/"?+?database_name,user_name,?password)?
?????????
????????14.InterBase?
????????String?url?=?"jdbc:interbase://localhost/e:/testbed/database/employee.gdb";?
????????Class.forName("interbase.interclient.Driver");?
?????????//?Driver?d?=?new?interbase.interclient.Driver?();?/*?this?will?also?work?if?you?do?not?want?the?line?above?*/?
????????Connection?conn?=?DriverManager.getConnection(?url,?"sysdba",?"masterkey"?);?

15?.HSqlDB?
????????url:?????http:?//?hsqldb.sourceforge.net/?
????????driver:??org.hsqldb.jdbcDriver?
????????连接方式有4种，分别为：?
????????con-str（内存）:?jdbc:hsqldb.?
????????con-str（本地）:?jdbc:hsqldb:/path/to/the/db/dir?
????????con-str（http）:?jdbc:hsqldb:http:?//?dbsrv?
????????con-str（hsql）:?jdbc:hsqldb:hsql:?//?dbsrv?16.Accrss#Aceess----------------------------------jdbc.driver=?sun.jdbc.odbc.JdbcOdbcDriver#jdbc.url=jdbc:odbc:anydatajdbc.url=?jdbc\?:??odbc\:driver\={Microsoft??Access??Driver??(*.mdb)};DBQ\=E\:\\workspace\\anyData003.mdbjdbc.username=jdbc.password=