JDBC连接数据库的方法汇总

本文实例总结了jdbc连接数据库的方法。分享给大家供大家参考，具体如下：

1. mysql(http://www.mysql.com)

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. microsoft sqlserver(http://jtds.sourceforge.net)

class.forname( "net.sourceforge.jtds.jdbc.driver" );
cn = drivermanager.getconnection( "jdbc:jtds:sqlserver://mydbcomputernameorip:1433/master", susr, spwd );

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

class.forname( "com.microsoft.jdbc.sqlserver.sqlserverdriver" );
cn = drivermanager.getconnection( "jdbc:microsoft:sqlserver://mydbcomputernameorip:1433;databasename=master", susr, spwd );

7.jdbc-odbc(非数据源方式)

new sun.jdbc.odbc.jdbcodbcdriver();
connection conn = drivermanager.getconnection("jdbc:odbc:driver={sql server};server=.;database=pubs;user=sa;pwd=");

8. odbc (普通数据源方式)

class.forname( "sun.jdbc.odbc.jdbcodbcdriver" );
connection cn = drivermanager.getconnection( "jdbc:odbc:" + sdsn, susr, spwd );

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

更多关于java相关内容感兴趣的读者可查看本站专题：《java文件与目录操作技巧汇总》、《java数据结构与算法教程》、《java操作dom节点技巧总结》和《java缓存操作技巧汇总》

希望本文所述对大家java程序设计有所帮助。