驱动器:
* 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: https://www.doczj.com/doc/7911806393.html,rmix.jdbc.IfxDriver
* 6. Sybase: com.sybase.jdbc.SybDriver
* 7. MySQL: com.mysql.jdbc.Driver
* 8. sqlite: org.sqlite.JDBC
数据库类型
* 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:3306/test?user=root&password=root&useUnicode=true&characterEncoding=utf-8"
* 8. sqlite url示例:
"jdbc:sqlite:test.db"
在SQL Server 2000 中加载驱动和URL路径的语句是
String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String dbURL = "jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=sample";
而SQL Server 2005 中加载驱动和URL的语句则为
String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=sample";
sqlserver 2000 driver jar as follow:
msbase.jar
mssqlserver.jar
msutil.jar
sql2005、2008 就一个
sqljdbc.jar
Oracle 用户名：scott 密码：tiger/用户名：System 密码：xgq
MySql 用户名：root 密码：xgq