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]

posted @ 2012-07-25 09:36  yuanjzweb  阅读(182)  评论(0)  编辑  收藏  举报