数据库连接的方法

最新推荐文章于 2024-05-06 11:07:47 发布

打工人在路上

最新推荐文章于 2024-05-06 11:07:47 发布

阅读量317

点赞数

分类专栏：开发文章标签：数据库 mysql java

本文链接：https://blog.csdn.net/Njhbsj/article/details/128064556

版权

开发专栏收录该内容

7 篇文章 0 订阅

订阅专栏

方法1:DriverManager

 Class.forName("com.mysql.jdbc.Driver");
         Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/fruitdb?useSSL=false&useUnicode=true&characterEncoding=utf-8&rewriteBatchedStatements=true","root","123456");

方法2:数据库连接池（Druid）

DruidDataSource dataSource = new DruidDataSource();
dataSource.setDriverClassName("com.mysql.jdbc.Driver");
dataSource.setUrl("jdbc:mysql://localhost:3306/fruitdb?useSSL=false&useUnicode=true&characterEncoding=utf-8");
dataSource.setUsername("root");
dataSource.setPassword("123456");
Connection conn1 = dataSource.getConnection();

方法3:数据库连接池（配置文件）

Properties properties = new Properties();
InputStream is = Demo04Druid.class.getClassLoader().getResourceAsStream("jdbc.properties");
properties.load(is);
DruidDataSource dataSource = new DruidDataSource();
dataSource.setDriverClassName(properties.getProperty("jdbc.driverClassName"));
dataSource.setUrl(properties.getProperty("jdbc.url"));
dataSource.setUsername(properties.getProperty("jdbc.username"));
dataSource.setPassword(properties.getProperty("jdbc.pwd"));

方法四：DruidDataSourceFactory

Properties properties = new Properties();
InputStream is = Demo05Druid.class.getClassLoader().getResourceAsStream("jdbc.properties");
properties.load(is);
DataSource dataSource = DruidDataSourceFactory.createDataSource(properties);
Connection conn1 = dataSource.getConnection();

jdbc.properties文件的定义

driverClassName=com.mysql.Driver
url=jdbc:mysql://localhost:3306/fruitdb?useSSL=false&useUnicode=true&characterEncoding=utf-8
username=root
password=123456