常见DB的 驱动类名 和 URL

[b]MySQL： [/b]

 com.mysql.jdbc.Driver 
 jdbc:mysql://localhost:3306/db_name?useUnicode=true&characterEncoding=UTF-8 

[b]Microsoft SQL Server 2.0驱动(sql2000):[/b]

 com.microsoft.jdbc.sqlserver.SQLServerDriver 
 jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=db_name 

[b]Microsoft SQL Server 3.0驱动(sql2005) [/b]

 com.microsoft.sqlserver.jdbc.SQLServerDriver 
 jdbc:sqlserver://localhost:1433;DatabaseName=db_name 

[b]Sysbase: [/b]

 com.sybase.jdbc.SybDriver 
 jdbc:Sysbase://localhost:5007/db_name 

[b]Oracle(用thin模式):[/b]

 oracle.jdbc.driver.OracleDriver 
 jdbc:oracle:thin:@loaclhost:1521:db_name 

[b]PostgreSQL: [/b]

 org.postgresql.Driver 
 jdbc:postgresql://localhost/db_name 

[b]DB2(连接具有DB2客户端的Provider实例)：[/b]

 com.ibm.db2.jdbc.app.DB2.Driver 
 jdbc:db2://localhost:5000/db_name

[b]DB2(连接不具有DB2客户端的Provider实例)：[/b]

 com.ibm.db2.jdbc.net.DB2.Driver 
 jdbc:db2://localhost:5000/db_name 

[b]Informix: [/b]

 com.informix.jdbc.IfxDriver 
 jdbc:Informix-sqli://localhost:1533/db_name:INFORMIXSER=myserver 

[b]JDBC-ODBC: [/b]

 sun.jdbc.odbc.JdbcOdbcDriver 
 jdbc:odbc:dbsource