各种数据库对应的url 备忘

发布于 2017-07-17  188 次阅读



数据库
驱动类名            
URL格式

Oracle
oracle.jdbc.driver.OracleDriver
jdbc:oracle:thin:@hostip:1521:dbname


Sybase
com.sybase.jdbc2.jdbc.SybDriver
jdbc:sybase:Tds:hostip:4100/dbname


Mysql
com.mysql.jdbc.Driver
jdbc:mysql://hostip:3306/dbname?useUnicode=true&characterEncoding=UTF-8


SQLServer 2000
com.microsoft.jdbc.sqlserver.SQLServerDriver
jdbc:microsoft:sqlserver://hostip:1433;DatabaseName=dbname


SQLServer 2005
com.microsoft.sqlserver.jdbc.SQLServerDriver
jdbc:sqlserver://hostip:1433;DatabaseName=dbname


SQLServer 7.0
net.sourceforge.jtds.jdbc.Driver
jdbc:jtds:sqlserver://hostip:1433/dbname


DB2
com.ibm.db2.jcc.DB2Driver
jdbc:db2://hostip:50000/dbname


Informix
com.informix.jdbc.IfxDriver
jdbc:informix-sqli://hostip:port/dbname:informixserver=<dbservername>

梦想还是要有的,万一实现了呢