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