springboot 配置 mysql druid

131 阅读 0 评论 87 点赞

我是靠谱客的博主狂野毛衣，这篇文章主要介绍springboot 配置 mysql druid，现在分享给大家，希望可以做个参考。

springboot 配置 mysql和druid

如果和很多教程一模一样但就是不行，建议重新开一个项目试一下。

先导入依赖：

复制代码

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
<version>2.2.7.RELEASE</version>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid-spring-boot-starter</artifactId>
<version>1.1.18</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>

然后写yml或者properties, czh是数据库名
yml

复制代码

1
2
3
4
5
6
7
spring:
datasource:
username: root
password: 123456
url: jdbc:mysql://localhost:3306/czh?useUnicode=true&characterEncoding=utf-8&useSSL=true&serverTimezone=UTC
driver-class-name: com.mysql.cj.jdbc.Driver

properties

复制代码

1
2
3
4
5
6
7
8
9
# 数据库连接信息
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/czh?useUnicode=true&characterEncoding=UTF-8&useSSL=false&autoReconnect=true&failOverReadOnly=false&serverTimezone=UTC
# mysql数据库驱动
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
# 用户名
spring.datasource.username=root
# 密码
spring.datasource.password=123456

再写一个User实体类

复制代码

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
package com.example.demo;
public class User {
private
String name ;
private
int id ;
@Override
public String toString() {
return "com.example.demo.User{" +
"name='" + name + ''' +
", id=" + id +
'}';
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
}

再搞一个DAO类，student_1是表名，里面有id, name 两个项

复制代码

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
@Repository
public class DAO {
private final static String TABLE_NAME = "student_1";
// 注入jdbc模板
@Autowired
private JdbcTemplate jdbcTemplate;
public List<User> queryAll() {
final String sql = "SELECT id, name FROM " + TABLE_NAME;
List<User> userList = jdbcTemplate.query(sql, new RowMapper<User>() {
@Override
public User mapRow(ResultSet rs, int rowNum) throws SQLException {
User user = new User();
user.setId(rs.getInt("id"));
user.setName(rs.getString("name"));
return user;
}
});
return userList;
}
}

最后在测试类里测试：冒红就是要导包

复制代码

1
2
3
4
5
6
7
8
9
10
11
12
13

@RunWith(SpringRunner.class)
@SpringBootTest
class DemoApplicationTests {
@Autowired
private DAO userDao;
@Test
public void queryAll() {
List<User> userList = userDao.queryAll();
System.out.println(userList);
}
}

最后效果
在这里插入图片描述

Druid

依赖上面已经导入了
就是在yml里多写点配置

复制代码

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
 type: com.alibaba.druid.pool.DruidDataSource
druid:
initial-size: 5
min-idle: 5
max-active: 20
max-wait: 60000
time-between-eviction-runs-millis: 60000
min-evictable-idle-time-millis: 30000
validation-query: SELECT 1 FROM DUAL
test-while-idle: true
test-on-borrow: false
test-on-return: false
pool-prepared-statements: true
max-pool-prepared-statement-per-connection-size: 20
filters: stat,wall.log4j2
maxPoolPreparedStatementPerConnectionSize: 20
useGlobalDataSourceStat: true
# 通过connectProperties属性来打开mergeSql功能；慢SQL记录
connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500
# 配置StatFilter
web-stat-filter:
#默认为false，设置为true启动
enabled: true
url-pattern: "/*"
exclusions: "*.js,*.gif,*.jpg,*.bmp,*.png,*.css,*.ico,/druid/*"
#配置StatViewServlet
stat-view-servlet:
url-pattern: "/druid/*"
#允许那些ip
allow: 127.0.0.1
login-username: admin
login-password: 123456
#禁止那些ip
deny: 192.168.1.102
#是否可以重置
reset-enable: true
#启用
enabled: true