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= 1 楼 PlayGod1984 昨天 受教了，收藏后备用 2 楼 zz563143188 昨天 PlayGod1984 写道受教了，收藏后备用
受用就帮我支持一下吧 3 楼 foolpig83 昨天 好文章啊 收藏后好好学习 4 楼 zz563143188 昨天 foolpig83 写道好文章啊 收藏后好好学习
项目开发流程详解：http://zz563143188.iteye.com/blog/1825168
这个你也可以去看一下。
