SPRINGBOOT配置MYSQL,MYBATIS,DRUID
2023-09-11 14:22:44 时间
配置
DRUID连接池
MYSQL数据库
MYBATIS持久层框架
添加依赖
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.30</version>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.1.1</version>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid-spring-boot-starter</artifactId>
<version>1.1.10</version>
</dependency>
application.propertise文件添加一下配置
#druid数据源配置
spring.datasource.druid.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.druid.url=jdbc:mysql://localhost:3306/web1?useUnicode=true&characterEncoding=utf-8
spring.datasource.druid.username=root
spring.datasource.druid.password=root
#连接池参数,初始数、最大数、最小数、获取连接等待超时时间(毫秒)
spring.datasource.druid.initial-size=5
spring.datasource.druid.max-active=20
spring.datasource.druid.min-idle=5
spring.datasource.druid.max-wait=60000
#指定mapper*.xml加载位置
mybatis.mapper-locations=classpath:mapper/*.xml
相关文章
- Mac-brew install mysql
- MySQL-- Entity Framework Code First(EF Code First)
- Mysql授权允许远程访问解决Navicat for MySQL连接mysql提示客户端不支持服务器请求的身份验证协议;考虑升级MySQL客户端
- 【C/C++学院】(23)Mysql数据库编程--C语言编程实现mysql客户端
- 【MySQL】解决mysql的 1594 错误
- 【MySQL】常见的mysql 进程state
- 【MySql】开机自动启动mysql服务
- 【异常】ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock
- XtraBackup出现 Can't connect to local MySQL server through socket '/tmp/mysql.sock'
- MySQL--执行mysql脚本及其脚本编写
- mysql 必知必会整理—sql 排序与过滤[三]
- mysql订单表如何设计?
- MySQL内核月报 2015.01-MySQL · 捉虫动态· mysql client crash一例
- Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result
- PHP连接MySQL数据库的三种方式(mysql、mysqli、pdo)--续
- 一文了解MySQL的Buffer Pool
- mysql中utf8和utf8mb4区别
- MySQL Study之--Mysql无法启动“mysql.host”
- file /usr/share/mysql/charsets/README from install of MySQL-server-5.1.73-1.glibc23.i386 conflicts with file from package mysql-libs-5.1.73-8.el6_8.i686
- MySQL技术内幕读书笔记(一)——Mysql体系结构和存储引擎
- mysql select into outfile默认文件保存路径是C:ProgramDataMySQLMySQL Server 8.0Data
- mysql_10 _ MySQL为什么有时候会选错索引?
- mysql设置远程访问权限
- Mysql报错:Can't connect to local MySQL server through socket '/tmp/mysql.sock'
- Mysql之mysql工具
- 【MySql】MySQL数据库--什么是MySQL的回表 ?
- Mysql mysqldump命令使用之 --single-transaction --hex-blob
- CentOS 三分钟快速安装MySQL