这篇文章给大家分享的是有关SpringBoot项目中怎么整合MyBatis的内容。小编觉得挺实用的，因此分享给大家做个参考，一起跟随小编过来看看吧。

<!--mybatis整合--><dependency><groupId>org.mybatis.spring.boot</groupId><artifactId>mybatis-spring-boot-starter</artifactId><version>2.1.4</version></dependency>2.连接数据库
3.连接完数据库就去applicaton.yml配置一下数据库

spring:datasource:username:rootpassword:123456url:jdbc:mysql://localhost:3306/mybatis?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8driver-class-name:com.mysql.cj.jdbc.Driver开始整合1.编写与数据库对应的实体类

packagecom.example.pojo;importlombok.AllArgsConstructor;importlombok.Data;importlombok.NoArgsConstructor;@Data@AllArgsConstructor@NoArgsConstructorpublicclassUser{privateIntegerid;privateStringname;privateStringpwd;}

为了偷懒，导入了lombok

<!--lombok--><dependency><groupId>org.projectlombok</groupId><artifactId>lombok</artifactId></dependency>2.编写mapper

packagecom.example.mapper;importcom.example.pojo.User;importorg.apache.ibatis.annotations.Mapper;importorg.springframework.stereotype.Repository;importjava.util.List;@Mapper@RepositorypublicinterfaceUserMapper{//查询用户的全部信息List<User>getUserList();//select找出id=1的用户UsergetUserById(intid);//insert增加一个用户intinsertUser(Useruser);//delete删除id=4的用户intdeleteUser(intid);//update将id=2的用户名字改为小龙intupdateUser(Useruser);}3.编写mapper.xml文件

<?xmlversion="1.0"encoding="UTF-8"?><!DOCTYPEmapperPUBLIC"-//mybatis.org//DTDMapper3.0//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mappernamespace="com.example.mapper.UserMapper"><selectid="getUserList"resultType="user">select*frommybatis.user</select><selectid="getUserById"resultType="user"parameterType="int">select*frommybatis.userwhereid=#{id};</select><insertid="insertUser"parameterType="user">insertintomybatis.user(id,name,pwd)values(#{id},#{name},#{pwd});</insert><deleteid="deleteUser"parameterType="int">deletefrommybatis.userwhereid=#{id};</delete><updateid="updateUser"parameterType="user">updatemybatis.usersetname=#{name},pwd=#{pwd}whereid=#{id};</update></mapper>

这里我们用了别名而且我们把这个mapper.xml文件放在了resources目录下，所以我们要去application.yml配置一下

mybatis:type-aliases-package:com.example.pojomapper-locations:classpath:mybatis/mapper/*.xml

mapper.xml文件编写的位置：

packagecom.example.controller;importcom.example.mapper.UserMapper;importcom.example.pojo.User;importorg.apache.ibatis.annotations.Param;importorg.springframework.beans.factory.annotation.Autowired;importorg.springframework.web.bind.annotation.GetMapping;importorg.springframework.web.bind.annotation.PathVariable;importorg.springframework.web.bind.annotation.RestController;importjava.util.List;@RestControllerpublicclassUserController{@AutowiredprivateUserMapperuserMapper;@GetMapping("/getUserList")publicList<User>getUserList(){returnuserMapper.getUserList();}@GetMapping("/getUserById/{id}")publicUsergetUserById(@PathVariable("id")intid){returnuserMapper.getUserById(id);}@GetMapping("/insertUser")publicStringinsertUser(){userMapper.insertUser(newUser(5,"xiaoming","111"));return"ok";}@GetMapping("/deleteUser")publicStringdeleteUser(){userMapper.deleteUser(5);return"ok";}@GetMapping("/updateUser")publicStringupdateUser(){userMapper.updateUser(newUser(5,"xx","111"));return"ok";}}5.进行测试

感谢各位的阅读！关于“SpringBoot项目中怎么整合MyBatis”这篇文章就分享到这里了，希望以上内容可以对大家有一定的帮助，让大家可以学到更多知识，如果觉得文章不错，可以把它分享出去让更多的人看到吧！