JDBC数据库URL连接字符串大全

最新推荐文章于 2022-09-20 13:00:57 发布

Lucas__liu

最新推荐文章于 2022-09-20 13:00:57 发布

阅读量2.2k

点赞数

CC 4.0 BY-SA版权

分类专栏： Java 随笔文章标签： JDBC 数据库连接字符串 URL 连接数据库

本文链接：https://blog.youkuaiyun.com/lb245557472/article/details/92791146

数据库	JDBC Driver	JDBC Url	Hibernate Dialect
MySQL	com.mysql.jdbc.Driver	jdbc:mysql://localhost/high_performance_java_persistence	org.hibernate.dialect.MySQL57Dialect
Oracle	oracle.jdbc.OracleDriver	jdbc:oracle:thin:@localhost:1521/orclpdb1	org.hibernate.dialect.Oracle12cDialect
SQL Server	com.microsoft.sqlserver.jdbc.SQLServerDriver	jdbc:sqlserver://localhost;DatabaseName=test123	org.hibernate.dialect.SQLServer2012Dialect
PostgreSQL	org.postgresql.Driver	jdbc:postgresql://localhost/high_performance_java_persistence	org.hibernate.dialect.PostgreSQL95Dialect
MariaDB	org.mariadb.jdbc.Driver	jdbc:mariadb://127.0.0.1/high_performance_java_persistence	org.hibernate.dialect.MariaDB53Dialect
Db2 Express-C	com.ibm.db2.jcc.DB2Driver	jdbc:db2://127.0.0.1:50000/hpjp	org.hibernate.dialect.DB2Dialect
SAP HANA	com.sap.db.jdbc.Driver	jdbc:sap://localhost:30015/	org.hibernate.dialect.HANAColumnStoreDialect
Informix	com.informix.jdbc.IfxDriver	jdbc:informix-sqli://127.0.0.1:9088/sysuser:INFORMIXSERVER=hpjp	org.hibernate.dialect.InformixDialect
HSQLDB	org.hsqldb.jdbc.JDBCDriver	jdbc:hsqldb:mem:test	org.hibernate.dialect.HSQLDialect
H2	org.h2.Driver	jdbc:h2:mem:high_performance_java_persistence	org.hibernate.dialect.H2Dialect
Derby	org.apache.derby.jdbc.EmbeddedDriver	jdbc:derby:target/tmp/derby/hpjp;databaseName=test;create=true	org.hibernate.dialect.DerbyTenSevenDialect
Sybase	com.sybase.jdbc.SybDriver	jdbc:sybase:Tds:hostname: port Number/databaseName

maven项目的pom.xml中配置：

<dependency>
    <groupId>com.microsoft.sqlserver</groupId>
    <artifactId>mssql-jdbc</artifactId>
    <version>7.2.2.jre8</version>
    <scope

200万优质内容无限畅学