常用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

 

转载于:https://www.cnblogs.com/lixin19890127/archive/2009/01/11/1373612.html