SpringBoot---mybatis配置

最新推荐文章于 2025-06-11 12:56:53 发布

原创最新推荐文章于 2025-06-11 12:56:53 发布 · 1.1k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mybatis #springBoot集成mybatis

SpringBoot 专栏收录该内容

64 篇文章

订阅专栏

本文详细介绍了如何在SpringBoot项目中集成并配置Mybatis，包括添加相关依赖、配置application.properties、编写mybatis-config.xml、User.xml以及UserMapper.java，最后通过REST接口进行启动测试。

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

1、添加依赖

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
	<modelVersion>4.0.0</modelVersion>
	<parent>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-parent</artifactId>
		<version>2.1.3.RELEASE</version>
		<relativePath/> <!-- lookup parent from repository -->
	</parent>
	
	<groupId>com.mooc.house</groupId>
	<artifactId>house</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<name>house</name>
	<description>Demo project for Spring Boot</description>

	<properties>
		<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
		<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
		<java.version>1.8</java.version>
		<mysql.version>6.0.6</mysql.version>
	</properties>

	<dependencies>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-freemarker</artifactId>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-web</artifactId>
		</dependency>

		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-test</artifactId>
			<scope>test</scope>
		</dependency>
		
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-test</artifactId>
		</dependency>
		
		<!-- mybatis封装包 -->
		<dependency>
			<groupId>org.mybatis.spring.boot</groupId>
			<artifactId>mybatis-spring-boot-starter</artifactId>
			<version>1.2.0</version>
		</dependency>
		
		<!-- mysql-jdbc -->
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
		</dependency>
		
		<!-- 引入tomcat容器 -->
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-web</artifactId>
		</dependency>
		<!-- 引入jetty容器 -->
		<!-- <dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-jetty</artifactId>
		</dependency> -->
		
		<!-- 阿里巴巴数据库连接池 -->
		<dependency>
			<groupId>com.alibaba</groupId>
			<artifactId>druid</artifactId>
			<version>1.1.0</version>
		</dependency>
		
	</dependencies>

	<build>
		<plugins>
			<plugin>
				<groupId>org.springframework.boot</groupId>
				<artifactId>spring-boot-maven-plugin</artifactId>
			</plugin>
		</plugins>
	</build>

</project>

2、添加application.properties配置

server.port=8090

#注：以下配置属于tomcat配置使用
#&serverTimezone=UTC（避免Mysql Connector/J 6.x以上的版本，然后就报了时区的错误）
#spring.datasource.url=jdbc:mysql://localhost:3306/houses?characterEncoding=UTF-8&serverTimezone=UTC
#spring.datasource.username=root
#spring.datasource.password=
#spring.datasource.driver-class-name=com.mysql.jdbc.Driver #过期
#spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

#mybatis配置文件的存放路径
mybatis.config-location=classpath:/mybatis/mybatis-config.xml

#配置dirudi数据库连接池
spring.druid.driverClassName=com.mysql.cj.jdbc.Driver
spring.druid.url=jdbc:mysql://localhost:3306/houses?characterEncoding=UTF-8&serverTimezone=UTC
spring.druid.username=root
spring.druid.password=******
#最大连接数
spring.druid.maxActive=30
#最小连接数
spring.druid.minIdle=5
#获取最大的链接等待时间
spring.druid.maxWait=10000
#解决mysql8小时的问题，验证时候正常
spring.druid.validationgQuery=SELECT 'x'
#空闲连接检查间隔
spring.druid.timeBetweenEvictionRunMillis=60000
#空闲连接最小空闲时间
spring.druid.minEvictableIdleTimeMillis=300000

3、创建mybatis-config.xml配置

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
  PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
  "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
	<settings>
		<!-- 配置关闭缓存 -->
		<setting name="cacheEnabled" value="false"/>
		<setting name="mapUnderscoreToCamelCase" value="true"/>
		<setting name="useGeneratedKeys" value="false"/>
		<setting name="defaultExecutorType" value="REUSE"/>
		<!-- 事物超时时间 -->
		<setting name="defaultStatementTimeout" value="600" />
	</settings>
	
	<typeAliases>
		<typeAlias type="com.mooc.house.common.model.User" alias="user"></typeAlias>
	</typeAliases>
	
	<mappers>
		<mapper resource="mapper/User.xml"/>
	</mappers>
	
</configuration>

4、创建User.xml配置

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" 
	"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.mooc.house.mapper.UserMapper">

	<select id="selectUsers" resultType="user">
		select id,name,email,phone from user
	</select>
</mapper>

5、创建UserMapper.java

package com.mooc.house.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;

import com.mooc.house.common.model.User;

@Mapper
public interface UserMapper {

	public List<User> selectUsers();
}

6、编写好rest启动测试