mysql database.dialect_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

5、连接db2驱动类：com.ibm.db2.jdbc.app.db2driver连接字符串：jdbc:db2://192.168.1.10/50000:rdb(这里192.168.1.10为数据库所在服务器ip地址，而50000为db2连接服务的端口号)6、链接sybase驱动类：com.sybase.jdbc3.jdbc.sybdriver连接字符串：jdbc:sybase:tds:192.168.100.252:4500/mydb(这里192.168.100.252为数据库所在服务器ip地址，而4500为sybase连接服务的端口号mydb为数据库的名字)7、链接informix驱动类：com.informix.jdbc.ifxdriver

3.dialect

DB2org.hibernate.dialect.DB2Dialect

DB2 AS/400org.hibernate.dialect.DB2400Dialect

DB2 OS390org.hibernate.dialect.DB2390Dialect

PostgreSQLorg.hibernate.dialect.PostgreSQLDialect

MySQLorg.hibernate.dialect.MySQLDialect

MySQL with InnoDBorg.hibernate.dialect.MySQLInnoDBDialect

MySQL with MyISAMorg.hibernate.dialect.MySQLMyISAMDialect

Oracle (any version)org.hibernate.dialect.OracleDialect

Oracle 9i/10gorg.hibernate.dialect.Oracle9Dialect

Sybaseorg.hibernate.dialect.SybaseDialect

Sybase Anywhereorg.hibernate.dialect.SybaseAnywhereDialect

Microsoft SQL Serverorg.hibernate.dialect.SQLServerDialect

SAP DBorg.hibernate.dialect.SAPDBDialect

Informixorg.hibernate.dialect.InformixDialect

HypersonicSQLorg.hibernate.dialect.HSQLDialect

Ingresorg.hibernate.dialect.IngresDialect

Progressorg.hibernate.dialect.ProgressDialect

Mckoi SQLorg.hibernate.dialect.MckoiDialect

Interbaseorg.hibernate.dialect.InterbaseDialect

Pointbaseorg.hibernate.dialect.PointbaseDialect

FrontBaseorg.hibernate.dialect.FrontbaseDialect

Firebirdorg.hibernate.dialect.FirebirdDialect