服务热线:13616026886

技术文档 欢迎使用技术文档,我们为你提供从新手到专业开发者的所有资源,你也可以通过它日益精进

位置:首页 > 技术文档 > JAVA > 新手入门 > 基础入门 > 查看文档

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

扫描关注微信公众号