j2ee不同数据库的驱动和URL写法

1.MSSQL Server2000:
驱动： com.microsoft.jdbc.sqlserver.SQLServerDriver
URL：jdbc:microsoft:sqlserver://[ip]:[port];DatabaseName=[dababase_name]

2.MSSQL Server2005:
驱动：com.microsoft.sqlserver.jdbc.SQLServerDriver
URL：jdbc:sqlserver://[ip]:[port];DatabaseName=[dababase_name]

3.MySQL:
驱动：com.mysql.jdbc.Driver
URL：jdbc:mysql://[ip]:[port]/[database_name]

4.Oracle 9i:
驱动：oracle.jdbc.driver.OracleDriver
URL：jdbc:oracle:thin:@[ip]:[port]:[database_name]
URL：jdbc:oracle:thin:[ip]:[port]:[database_name]

5.Oracle 8i:
驱动：oracle.jdbc.driver.OracleDriver
URL：jdbc:oracle:oci8:@[ip]:[port]:[database_name]
URL：jdbc:oracle:oci8:[ip]:[port]:[database_name]

6.JDBC-ODBC:
驱动：sum.jdbc.odbc.JdbcOdbcDriver
URL：jdbc:odbc:[database_name]

转载于:https://www.cnblogs.com/yuanjunzheng/archive/2012/07/25/2607667.html