服务热线:13616026886

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

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

常用jdbc连接方法


   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. 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. odbc
  class.forname( "sun.jdbc.odbc.jdbcodbcdriver" );
  connection cn = drivermanager.getconnection( "jdbc:odbc:" + sdsn, susr, spwd );

扫描关注微信公众号