JDBC各种数据库的连接驱动及url、dialect
1.驱动
mysql----->com.mysql.jdbc.Driver
oracle----->oracle.jdbc.driver.OracleDriver
sql server----->
2000----com.microsoft.jdbc.sqlserver.SQLServerDriver
2005----com.microsoft.sqlserver.jdbc.SQLServerDriver
postgre----->org.postgresql.Driver
2.连接url
mysql----->jdbc:mysql://127.0.0.1:3306/test
root
1234
oracle----->jdbc:oracle:thin:@127.0.0.1:1521:test
root
root
sql server----->
2000-----jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=test
2005-----jdbc:sqlserver://localhost:1433; DatabaseName=test
sa
(空字符串)
postgre----->jdbc:postgresql://127.0.0.1:5432/test
postgres
111111
3.dialect
|
DB2 |
org.hibernate.dialect.DB2Dialect |
|
DB2 AS/400 |
org.hibernate.dialect.DB2400Dialect |
|
DB2 OS390 |
org.hibernate.dialect.DB2390Dialect |
|
PostgreSQL |
org.hibernate.dialect.PostgreSQLDialect |
|
MySQL |
org.hibernate.dialect.MySQLDialect |
|
MySQL with InnoDB |
org.hibernate.dialect.MySQLInnoDBDialect |
|
MySQL with MyISAM |
org.hibernate.dialect.MySQLMyISAMDialect |
|
Oracle (any version) |
org.hibernate.dialect.OracleDialect |
|
Oracle 9i/10g |
org.hibernate.dialect.Oracle9Dialect |
|
Sybase |
org.hibernate.dialect.SybaseDialect |
|
Sybase Anywhere |
org.hibernate.dialect.SybaseAnywhereDialect |
|
Microsoft SQL Server |
org.hibernate.dialect.SQLServerDialect |
|
SAP DB |
org.hibernate.dialect.SAPDBDialect |
|
Informix |
org.hibernate.dialect.InformixDialect |
|
HypersonicSQL |
org.hibernate.dialect.HSQLDialect |
|
Ingres |
org.hibernate.dialect.IngresDialect |
|
Progress |
org.hibernate.dialect.ProgressDialect |
|
Mckoi SQL |
org.hibernate.dialect.MckoiDialect |
|
Interbase |
org.hibernate.dialect.InterbaseDialect |
|
Pointbase |
org.hibernate.dialect.PointbaseDialect |
|
FrontBase |
org.hibernate.dialect.FrontbaseDialect |
|
Firebird |
org.hibernate.dialect.FirebirdDialect |
1.驱动
mysql----->com.mysql.jdbc.Driver
oracle----->oracle.jdbc.driver.OracleDriver
sql server----->
2000----com.microsoft.jdbc.sqlserver.SQLServerDriver
2005----com.microsoft.sqlserver.jdbc.SQLServerDriver
postgre----->org.postgresql.Driver
2.连接url
mysql----->jdbc:mysql://127.0.0.1:3306/test
root
1234
oracle----->jdbc:oracle:thin:@127.0.0.1:1521:test
root
root
sql server----->
2000-----jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=test
2005-----jdbc:sqlserver://localhost:1433; DatabaseName=test
sa
(空字符串)
postgre----->jdbc:postgresql://127.0.0.1:5432/test
postgres
111111
3.dialect
|
DB2 |
org.hibernate.dialect.DB2Dialect |
|
DB2 AS/400 |
org.hibernate.dialect.DB2400Dialect |
|
DB2 OS390 |
org.hibernate.dialect.DB2390Dialect |
|
PostgreSQL |
org.hibernate.dialect.PostgreSQLDialect |
|
MySQL |
org.hibernate.dialect.MySQLDialect |
|
MySQL with InnoDB |
org.hibernate.dialect.MySQLInnoDBDialect |
|
MySQL with MyISAM |
org.hibernate.dialect.MySQLMyISAMDialect |
|
Oracle (any version) |
org.hibernate.dialect.OracleDialect |
|
Oracle 9i/10g |
org.hibernate.dialect.Oracle9Dialect |
|
Sybase |
org.hibernate.dialect.SybaseDialect |
|
Sybase Anywhere |
org.hibernate.dialect.SybaseAnywhereDialect |
|
Microsoft SQL Server |
org.hibernate.dialect.SQLServerDialect |
|
SAP DB |
org.hibernate.dialect.SAPDBDialect |
|
Informix |
org.hibernate.dialect.InformixDialect |
|
HypersonicSQL |
org.hibernate.dialect.HSQLDialect |
|
Ingres |
org.hibernate.dialect.IngresDialect |
|
Progress |
org.hibernate.dialect.ProgressDialect |
|
Mckoi SQL |
org.hibernate.dialect.MckoiDialect |
|
Interbase |
org.hibernate.dialect.InterbaseDialect |
|
Pointbase |
org.hibernate.dialect.PointbaseDialect |
|
FrontBase |
org.hibernate.dialect.FrontbaseDialect |
|
Firebird |
org.hibernate.dialect.FirebirdDialect |
浙公网安备 33010602011771号