DB
driverClass/jdbcUrl/jdbc download
Maven dependency
oracle.jdbc.driver.OracleDriver
com.oracle
ojdbc14
10.2.0.4.0
thin模式:
jdbc:oracle:thin:@host:port1521default:dbName
com.mysql.jdbc.Driver
or
org.gjt.mm.mysql.Driver
mysql
mysql-connector-java
5.1.13
jdbc:mysql://host:port3306default/dbName?user=userName&password= password&useUnicode=true&characterEncoding=gb2312
com.sybase.jdbc3.jdbc.SybDriver
or
com.sysbase.jdbc.SybDriver
jdbc:sybase:Tds:host:port5007default/dbName
DB2
com.ibm.db2.jdbc.net.DB2Driver (db2java.zip)
or
com.ibm.db2.jcc.DB2Driver (db2jcc.jar)
or
com.ibm.db2.jdbc.app.DB2Driver
使用db2jcc.jar:
db2jcc
db2jcc
9.0
db2jcc_license_cu
db2jcc_license_cu
9.0
注:
Maven仓库中是没有该驱动的,需先手动添加jar到仓库中。
jdbc:db2://host:port5000default/dbName
Informix
com.informix.jdbc.IfxDriver
jdbc:informix-sqli://host:port1533default/dbName:informixserver=server;user=username;password=password
SQL Server
2005版本及以后:
com.microsoft.sqlserver.jdbc.SQLServerDriver
or
2000版本:
com.microsoft.jdbc.sqlserver.SQLServerDriver
net.sourceforge.jtds
jtds
1.2.4
jdbc:sqlserver://host:port1433default;databasename=dbName
Access
sun.jdbc.odbc.JdbcOdbcDriver
jdbc:odbc:dataSourceName
org.postgresql.Driver
postgresql
postgresql
9.1-901.jdbc3
or
postgresql
postgresql
9.1-901.jdbc4
version可选值:
8.4-702.jdbc3
注:
jdbc3的适用于JDK1.5及以下;
jdbc4的适用于JDK1.6及以上。
jdbc:postgresql://host:port5432default/dbName
org.sqlite.JDBC
org.xerial
sqlite-jdbc
3.7.2
jdbc:sqlite:dbPath.db
org.apache.derby.jdbc.ClientDriver
or
org.apache.derby.jdbc.EmbeddedDriver
org.apache.derby
derby
10.9.1.0
Client模式:
jdbc:derby://localhost:port1527default/dbName
org.hsqldb.jdbcDriver
or
org.hsqldb.jdbc.JDBCDriver
2.0以前版本:
hsqldb
hsqldb
1.8.0.7
2.0及以后版本:
org.hsqldb
hsqldb
2.2.8
jdk5
mem模式:
jdbc:hsqldb:mem:dbName
file模式:
jdbc:hsqldb:file:dbPath
res模式:
jdbc:hsqldb:res:org.my.path.resdb
连接到local hsql Server:
jdbc:hsqldb:hsql://localhost/dbName
连接到local http Server:
jdbc:hsqldb:http://localhost/dbName
org.h2.Driver
com.h2database
h2
1.3.168
mem模式:
jdbc:h2:mem:dbName
连接到local tcp Server:
jdbc:h2:tcp://localhost/~/dbName