常用JDBC连接用字符串

常用JDBC连接用字符串

descript:各种常用数据库的jar，用于Java数据库连接

1) SQLServer2000:驱动包(msbase.jar mssqlserver.jar msutil.jar)
url: jdbc:microsoft:sqlserver://localhost:1433;databasename=pubs
driver: com.microsoft.jdbc.sqlserver.SQLServerDriver

2) SQLServer2005:驱动包(sqljdbc.jar)
url: jdbc:sqlserver://localhost:1433;databasename=pubs
driver: com.microsoft.sqlserver.jdbc.SQLServerDriver


===============================================================================

3) JTDS -----SQLServer(支持SQL2000和SQL2005)
url: jdbc:jtds:sqlserver://localhost:1433/pubs
driver: net.sourceforge.jtds.jdbc.Driver


4) Oracle:驱动包(classes12.jar)
url: jdbc:oracle:thin:@0735jb:1521:aptech
(语法：jdbc:oracle:thin:@[ip]:[port]:[sid])
driver: oracle.jdbc.driver.OracleDriver


5) mysql:驱动包(mysql-connector-java-3.1.12-bin.jar)
url: jdbc:mysql: //127.0.0.1:3306/mysql

driver:org.gjt.mm.mysql.Driver