各种数据库的url和driver_db的url,driver, password ,port

 MySql
driverClassName = com.mysql.jdbc.Driver
url = jdbc:mysql://localhost:3306/test?autoReconnect=true&useUnicode=true&                                                   characterEncoding=utf-8&mysqlEncoding=utf8

Oracle
driverClassName = oracle.jdbc.driver.OracleDriver
url = jdbc:oracle:thin:@localhost:1521:xe

SQLServer
driverClassName = com.microsoft.jdbc.sqlserver.SQLServerDriver

//以下为理论，没有实践使用
1.Oracle8/8i/9i(thin模式) 

Class.forName("oracle.jdbc.driver.OracleDriver");
String URL = "jdbc:oracle:thin:@localhost:1521:orcl"; //orcl为数据库的SID
String user = "test";
String password = "test";
Connection conn = DriverManager.getConnection(URL,user,password);

2.DB2
Class.forName("com.ibm.db2.jdbc.app.DB2Driver");
String URL = "jdbc:db2://localhost:5000/sample"; //sample为数据库名
String user = "test";
String password = "test";
Connection conn = DriverManager.getConnection(URL,user,password);

3.SQL Server7.0/2000

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String URL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydb"; //mydb为数据库名
String user = "test";
String password = "test";
Connection conn = DriverManager.getConnection(URL,user,password);

4.Sybase

Class.forName("com.sybase.jdbc.SybDriver");
String URL = "jdbc:sybase:Tds:localhost:5007/myDB";//myDB为你的数据库名
Properties sysProps = System.getProperties();
sysProps.put("user","test");
sysProps.put("password","test");
Connection conn = DriverManager.getConnection(URL,sysProps);

5.Informix

Class.forName("com.informix.jdbc.IfxDriver");
String URL = "jdbc:informix-
sql://123.45.67.89:1533/myDB:INFORMIXSERVER=myserver;user=test;password=test"; //myDB为你的数据库名
Connection conn = DriverManager.getConnection(URL);

6.MySQL

Class.forName("org.gjt.mm.mysql.Driver");
String URL = "jdbc:mysql://localhost/myDB?user=sa password=sa"; //myDB为你的数据库名
Connection conn = DriverManager.getConnection(URL);

7.PostgreSQL

CLass.forName("org.postgresql.Driver");
String URL = "jdbc:postgresql://localhost/myDB"; //myDB为你的数据库名
String user = "test";
String password = "test";
Connection conn = DriverManager.getConnection(URL,user,password);