连接各种数据库驱动

来源:互联网 发布:淘宝短信链接 编辑:程序博客网 时间:2024/05/01 17:50
驱动器:
*  1. Oracle: oracle.jdbc.driver.OracleDriver
*  2. Access: sun.jdbc.odbc.JdbcOdbcDriver
*  3. SQL Server: com.microsoft.jdbc.sqlserver.SQLServerDriver
*  4. DB2: com.ibm.db2.jdbc.app.DB2Driver
*  5. Informix: com.informix.jdbc.IfxDriver
*  6. Sybase: com.sybase.jdbc.SybDriver
*  7. MySQL: com.mysql.jdbc.Driver




数据库类型
*  1. Oracle url示例:
"jdbc:oracle:thin:@localhost:1521:orcl"
*  2. Access url示例:
"jdbc:odbc:Access"
*  3. SQLServer url示例:
"jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs"
*  4. DB2 url示例:
"jdbc:db2://localhost:5000/sample"
*  5. Informix url示例:
       "jdbc:informix-sqli://123.45.67.89:1533/testDB:INFORMIXSERVER=myserver"
*  6. Sybase url示例:
"jdbc:sybase:Tds:localhost:5007/tsdata"
*  7. MySQL url示例:
"jdbc:mysql://localhost/test?user=root&password=root&useUnicode=true&characterEncoding=utf-8"