java连接各种数据库 代码

1.mysql

dialect:org.hibernate.dialect.MySQLDialect
驱动名称:com.mysql.jdbc.Driver
连接字符串jdbc:mysql://localhost/dbName

2.postgres

dialect:org.hibernate.dialect.PostgreSQLDialect
驱动名称:org.postgresql.Driver
连接字符串:jdbc:postgresql://127.0.0.1:5432/dbName

3.sqlserver

dialect:org.hibernate.dialect.SQLServerDialect
驱动名称:com.microsoft.sqlserver.jdbc.SQLServerDriver
连接字符串:jdbc:sqlserver://localhost:1433;DatabaseName=dbName

4.oracle

dialect:org.hibernate.dialect.Oracle9Dialect
驱动名称:oracle.jdbc.driver.OracleDriver
连接字符串:jdbc:oracle:thin:@localhost:1521:dbName