各种数据库MYSQL，ORACLE等， JDBC连接大全

最新推荐文章于 2021-11-07 15:56:13 发布

原创最新推荐文章于 2021-11-07 15:56:13 发布 · 153 阅读

0 ·

CC 4.0 BY-SA版权

Bee 同时被 3 个专栏收录

314 篇文章

订阅专栏

ORM

223 篇文章

订阅专栏

Java

175 篇文章

订阅专栏

本文提供了多种常见数据库（如MySQL、Oracle、SQL Server等）通过JDBC连接的配置示例，并附带了实际可用的连接字符串及用户名密码设置指导。

各种数据库， JDBC连接大全。亲测，都能用（但用户名密码要改为你自己的哦）。

   String MYSQL = "MySQL";
   String MariaDB = "MariaDB";
   String ORACLE = "Oracle";
   String SQLSERVER = "Microsoft SQL Server";

   String H2 = "H2";
   String SQLite = "SQLite";
   String PostgreSQL = "PostgreSQL";

#bee.databaseName=SQLite
#bee.db.driverName =
#bee.db.url =jdbc:sqlite:bee.db
#bee.db.username = 
#bee.db.password =

#bee.databaseName=mysql
#bee.db.driverName = com.mysql.jdbc.Driver
#bee.db.url =jdbc:mysql://localhost:3306/bee?characterEncoding=UTF-8&serverTimezone=Asia/Shanghai
#bee.db.url =jdbc:mysql://localhost:3306/bee?characterEncoding=UTF-8
#bee.db.username = root
#bee.db.password =


bee.databaseName=oracle
bee.db.driverName = oracle.jdbc.driver.OracleDriver
bee.db.url =jdbc:oracle:thin:@localhost:1521:orcl
bee.db.username =scott
bee.db.password =aaa


#bee.databaseName=h2
#bee.db.driverName =org.h2.Driver
#bee.db.url =jdbc:h2:D:/JavaWeb/h2/data/bee
#bee.db.username =sa
#bee.db.password =sa

#bee.databaseName=PostgreSQL
#bee.db.driverName =org.postgresql.Driver
#bee.db.url =jdbc:postgresql://127.0.0.1:5432/bee
#bee.db.username =Administrator
#bee.db.password =

#bee.databaseName=Microsoft SQL Server
#bee.db.driverName =com.microsoft.sqlserver.jdbc.SQLServerDriver
#bee.db.url =jdbc:sqlserver://localhost:1433; databasename=bee
#bee.db.username = sa
#bee.db.password =123456

参考：

https://gitee.com/automvc/bee-exam