spring boot自动化配置druid + mybatis

最新推荐文章于 2022-08-15 23:59:40 发布

tszxlzc

最新推荐文章于 2022-08-15 23:59:40 发布

阅读量555

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/tszxlzc/article/details/89089111

spring 同时被 3 个专栏收录

15 篇文章

订阅专栏

spring

13 篇文章

订阅专栏

mybatis

6 篇文章

订阅专栏

本文介绍如何在Spring Boot项目中配置并使用MyBatis框架，包括添加Maven依赖、配置Druid数据源及MyBatis参数，同时展示了如何通过配置文件设置数据库连接属性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

先添加maven配置

        <dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
		</dependency>
		<dependency>
			<groupId>com.alibaba</groupId>
			<artifactId>druid-spring-boot-starter</artifactId>
			<version>1.1.9</version>
		</dependency>
		<dependency>
			<groupId>org.mybatis.spring.boot</groupId>
			<artifactId>mybatis-spring-boot-starter</artifactId>
			<version>1.3.2</version>
		</dependency>

application.properties配置

#druid 数据源
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.driver-class-name= com.mysql.cj.jdbc.Driver
spring.datasource.username=ikukouser
spring.datasource.password=111111
spring.datasource.url=jdbc:mysql://10.0.0.53:3306/test?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull
spring.datasource.druid.initial-size=5
spring.datasource.druid.min-idle=5
spring.datasource.druid.maxActive=20
spring.datasource.druid.maxWait=60000
spring.datasource.druid.timeBetweenEvictionRunsMillis=60000
spring.datasource.druid.minEvictableIdleTimeMillis=300000
spring.datasource.druid.validationQuery=SELECT 1 FROM DUAL
spring.datasource.druid.testWhileIdle=true
spring.datasource.druid.testOnBorrow=false
spring.datasource.druid.testOnReturn=false
spring.datasource.druid.poolPreparedStatements=true
spring.datasource.druid.maxPoolPreparedStatementPerConnectionSize=20
# Spring Boot 默认的日志系统是 logback，并没有依赖 log4j，这里配置的 log4j 可能会报错了，报错的话直接将value 的log4j去除就可以正常运行了
# spring.datasource.druid.filters=stat,wall,log4j
spring.datasource.druid.filters=stat,wall
spring.datasource.druid.connectionProperties=druid.stat.mergeSql\=true;druid.stat.slowSqlMillis\=5000


#mybatis
mybatis.mapperLocations=classpath*:/mapper/*Mapper.xml
mybatis.typeAliasesPackage=lzc.springboot.model
mybatis.configuration.map-underscore-to-camel-case=true
mybatis.configuration.use-generated-keys=false

mybatis-spring 配置要扫描的mapper接口 http://www.mybatis.org/spring/mappers.html#scan

@Configuration
@MapperScan("lzc.springboot.mapper")
public class MapperConfigure {
}

启动spring boot应用，看到druid 的监控页面