java连接常见数据库的连接字符串

1.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);

2.PostgreSQL(http://www.de.postgresql.org)pgjdbc2.jar

Class.forName("org.postgresql.Driver");

cn=DriverManager.getConnection("jdbc:postgresql://MyDbComputerNameOrIP/myDatabaseName",sUsr,sPwd);

3.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);

4.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")

5.MicrosoftSQLServer(http://jtds.sourceforge.net)

Class.forName("net.sourceforge.jtds.jdbc.Driver");

cn=DriverManager.getConnection("jdbc:jtds:sqlserver://MyDbComputerNameOrIP:1433/master",sUsr,sPwd);

6.MicrosoftSQLServer(http://www.microsoft.com)

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");

cn=DriverManager.getConnection("jdbc:microsoft:sqlserver://MyDbComputerNameOrIP:1433;databaseName=master",sUsr,sPwd);

7.ODBC

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

Connectioncn=DriverManager.getConnection("jdbc:odbc:"+sDsn,sUsr,sPwd);

8.DB2

Class.forName("Com.ibm.db2.jdbc.net.DB2Driver");

Stringurl="jdbc:db2://192.9.200.108:6789/SAMPLE"

cn=DriverManager.getConnection(url,sUsr,sPwd);

• ·Configuringhigh-speeddi
• ·Sun.XVR-1200图形加速器的使用
• ·事件监听器:将JavaBeans接通起来的方法
• ·int与bytearray之间的转换程序
• ·Struts的巨大烦恼 真的不适合大系统？
• ·JavaScript：世界上误解最深的语言
• ·Java安全体系结构
• ·java/vc单点登录的简单实现
• ·学习java安全技术前的准备
• ·TurbineHowto之ActionEven