Spring Boot整合MyBatis

最新推荐文章于 2025-04-03 15:24:05 发布

原创最新推荐文章于 2025-04-03 15:24:05 发布 · 265 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#springboot #mybatis

Spring Boot 专栏收录该内容

3 篇文章

订阅专栏

这篇博客详细介绍了如何将Spring Boot与MyBatis整合。首先新建Spring Boot项目，接着创建user数据表，然后逐步整合MyBatis，包括添加依赖、配置文件设置和创建Mapper、Service等组件。最后启动项目并验证集成效果。

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

一、新建Spring Boot项目

1、在此我就不重复新建Spring Boot项目的步骤，读者可以参考我另外一篇博客进行参考：https://blog.youkuaiyun.com/weixin_41178230/article/details/84404058

2、在com.example.demo目录下创建com.example.demo.po包，并且在该包下创建User.java：

package com.example.demo.po;

public class User {
	private Integer userId;
	private String userName;
	private String password;
	private String email;
	private Integer grade;
	
	public Integer getUserId() {
		return userId;
	}
	public void setUserId(Integer userId) {
		this.userId = userId;
	}
	public String getUserName() {
		return userName;
	}
	public void setUserName(String userName) {
		this.userName = userName;
	}
	public String getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}
	public String getEmail() {
		return email;
	}
	public void setEmail(String email) {
		this.email = email;
	}
	public Integer getGrade() {
		return grade;
	}
	public void setGrade(Integer grade) {
		this.grade = grade;
	}
	
	
}

3、同理，在com.example.demo目录下分别创建com.example.demo.mapper、com.example.demo.service、com.example.demo.serviceImpl和com.example.demo.controller：

UserMapper.java：

package com.example.demo.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;

import com.example.demo.po.User;

@Mapper
public interface UserMapper {
	public List<User> findUserAll();
}

UserService.java：

package com.example.demo.service;

import java.util.List;

import com.example.demo.po.User;

public interface UserService {
	public List<User> findUserAll();
}

UserServiceImpl.java：

package com.example.demo.service.impl;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.example.demo.mapper.UserMapper;
import com.example.demo.po.User;
import com.example.demo.service.UserService;

@Service
public class UserServiceImpl implements UserService{

	//注入Mapper接口代理对象
	@Autowired
	private UserMapper userMapper;
	
	@Override
	public List<User> findUserAll() {
		// TODO Auto-generated method stub
		List<User> list = userMapper.findUserAll();
		return list;
	}

}

UserController.java：

package com.example.demo.controller;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RestController;

import com.example.demo.po.User;
import com.example.demo.service.impl.UserServiceImpl;

@RestController
public class UserController {
	
	//注入Service代理对象
	@Autowired
	private UserServiceImpl userService;
	
	@RequestMapping("ssm")
	public List<User> findUserAll(){
		List<User> list = userService.findUserAll();
		return list;
	}
	
}

4、项目最终结构：

二、创建user数据表：

/*
Navicat MySQL Data Transfer

Source Server         : mysql
Source Server Version : 50536
Source Host           : localhost:3306
Source Database       : mysql_test

Target Server Type    : MYSQL
Target Server Version : 50536
File Encoding         : 65001

Date: 2019-01-07 21:22:47
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `userid` int(10) NOT NULL,
  `username` varchar(20) NOT NULL,
  `password` varchar(20) NOT NULL,
  `email` varchar(20) NOT NULL,
  `grade` int(10) NOT NULL,
  PRIMARY KEY (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', 'admin', 'admin', 'xc@163.com', '1');
INSERT INTO `user` VALUES ('2', 'xc', 'xc', 'xc@163.com', '2');
INSERT INTO `user` VALUES ('3', 't1', 't1', 'xc@163.com', '3');
INSERT INTO `user` VALUES ('4', 't2', 't2', 'xc@163.com', '4');
INSERT INTO `user` VALUES ('5', 't3', 't3', 'xc@163.com', '5');
INSERT INTO `user` VALUES ('6', 't4', 't4', 'xc@163.com', '6');
INSERT INTO `user` VALUES ('7', 't5', 't5', 'xc@163.com', '7');
INSERT INTO `user` VALUES ('8', 't6', 't6', 'xc@163.com', '8');

三、整合MyBatis

1、在pom.xml内的标签<dependencies></dependencies>内添加以下：

<!-- Spring Boot整合MyBatis -->
<dependency>
	<groupId>org.mybatis.spring.boot</groupId>
	<artifactId>mybatis-spring-boot-starter</artifactId>
	<version>1.3.0</version>
</dependency>

<dependency>
	<groupId>mysql</groupId>
	<artifactId>mysql-connector-java</artifactId>
	<version>5.1.35</version>
</dependency>

2、在/demo/src/main/resources目录下的application.properties配置文件内添加以下：

#Spring Boot整合MyBatis框架
#加载MyBatis配置文件
mybatis.config-location=classpath:mapper/config/sqlMapConfig.xml
mybatis.mapper-locations=classpath:mapper/*Mapper.xml
#定义别名
mybatis.type-aliases-package=com.example.demo.po
#数据源
spring.datasource.url=jdbc:mysql://localhost:3306/mysql_test
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.username=root
spring.datasource.password=123

3、在/demo/src/main/resources目录下创建mapper目录，并在mapper目录下再创建一个config目录，如下图所示：

sqlMapConfig.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="callSettersOnNulls" value="true"/>
 
        <setting name="cacheEnabled" value="true"/>
 
        <setting name="lazyLoadingEnabled" value="true"/>
 
        <setting name="aggressiveLazyLoading" value="true"/>
 
        <setting name="multipleResultSetsEnabled" value="true"/>
 
        <setting name="useColumnLabel" value="true"/>
 
        <setting name="useGeneratedKeys" value="false"/>
 
        <setting name="autoMappingBehavior" value="PARTIAL"/>
 
        <setting name="defaultExecutorType" value="SIMPLE"/>
 
        <setting name="mapUnderscoreToCamelCase" value="true"/>
 
        <setting name="localCacheScope" value="SESSION"/>
 
        <setting name="jdbcTypeForNull" value="NULL"/>
 
    </settings>
 
    <!-- 省略包名 -->
    <typeAliases>
        <typeAlias alias="Integer" type="java.lang.Integer" />
        <typeAlias alias="Long" type="java.lang.Long" />
        <typeAlias alias="HashMap" type="java.util.HashMap" />
        <typeAlias alias="LinkedHashMap" type="java.util.LinkedHashMap" />
        <typeAlias alias="ArrayList" type="java.util.ArrayList" />
        <typeAlias alias="LinkedList" type="java.util.LinkedList" />
    </typeAliases>
 
</configuration>

UserMapper.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.example.demo.mapper.UserMapper">
    <!-- 根据类别代码查询  -->
    <select id="findUserAll" resultType="user">
        select * from user
    </select>
</mapper>