java连接各种数据库及配各种服务器数据池（更新中）-优快云博客

本文提供了使用JDBC连接多种数据库（包括MS SQL Server、Oracle、MySQL、DB2、Sybase及PostgreSQL）的示例代码。展示了不同数据库驱动的加载方式、URL配置以及连接建立的过程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

jdbcodbj桥接Microsoft SQL Server 2000

private Connection con = null;
private static final String DBUSER = "sa";//账号
private static final String DBPASS = "sa";//密码
private static final String DBURL = "jdbc:odbc:LocalServer";//LocalServer为配的数据源
public static final String DBDRIVER = "sun.jdbc.odbc.JdbcOdbcDriver";
Class.forName(DBDRIVER).newInstance();
con = DriverManager.getConnection(DBURL, DBUSER, DBPASS);

jdbc连接oracle10g

  private Connection con = null 
  public static final String DBUSER = "scott" ;
  public static final String DBPASS = "tiger" ;
  public static final String DBDRIVER = "oracle.jdbc.driver.OracleDriver" ;
  public static final String DBURL = "jdbc:oracle:thin:@localhost:1521:databaseName" ;
  Class.forName(DBDRIVER)。newInstance();
  con = DriverManager.getConnection(DBURL,DBUSER,DBPASS) ;

jdbc连接Mysql

  private Connection con = null 
  public static final String DBUSER = "scott" ;
  public static final String DBPASS = "tiger" ;
  public static final String DBDRIVER = "com.mysql.jdbc.Driver" ;
  public static final String DBURL = "jdbc:mysql://localhost/databaseName?useUnicode=true&characterEncoding=UTF-8" ;
  Class.forName(DBDRIVER)。newInstance();
  con = DriverManager.getConnection(DBURL,DBUSER,DBPASS) ;

DB2

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

String url="jdbc:db2://dburl:port/DBname"

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

Sybase(jconn2.jar)

Class.forName( "com.sybase.jdbc2.jdbc.SybDriver" );

cn = DriverManager.getConnection( "jdbc:sybase:Tds:DBServerIP:2638", sUsr, sPwd );

PostgreSQL(pgjdbc2.jar)

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

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