java连接各种数据库及配各种服务器数据池（更新中）

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