16. Spring Boot整合Mybatis

16. Spring Boot 整合Mybatis

1. pom.xml导入依赖

   		<dependency>
   			<groupId>org.mybatis.spring.boot</groupId>
   			<artifactId>mybatis-spring-boot-starter</artifactId>
   			<version>2.1.3</version>
   		</dependency>
   

2. application.yml

   # 整合Mybatis
   mybatis:
     type-aliases-package: com.indi.pojo
     mapper-locations: classpath:mybatis/mapper/*.xml
   

3. 在resources目录下创建mybatis/mapper目录，存放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">
   
   <!-- namespace 绑定一个对应的Mapper-->
   <mapper namespace="com.indi.mapper.UserMapper">
      <select id="queryUserList" resultType="User">
           select * from user;
       </select>
   
      <select id="queryUserById" resultType="User" parameterType="int">
           select * from mybatis.user where id = #{id}
       </select>
   
      <!--对象中的属性，直接写-->
      <insert id="addUser" parameterType="User">
           insert into mybatis.user(id, name, pwd) value (#{id},#{name},#{pwd});
       </insert>
   
      <update id="updateUser" parameterType="User">
           update mybatis.user set name = #{name},pwd=#{pwd} where id =#{id};
       </update>
   
      <delete id="deleteUser" parameterType="int">
           delete from mybatis.user where id = #{id};
       </delete>
   </mapper>
   

4. UserMapper.java

   //代表这是MyBatis的Mapper
   @Mapper
   @Repository
   public interface UserMapper {
   
       List<User> queryUserList();
   
       User queryUserById(int id);
   
       int addUser(User user);
   
       int updateUser(User user);
   
       int deleteUser(int ud);
   }
   

5. UserController.java

   @RestController
   public class UserController {
   
       @Autowired
       private UserMapper userMapper;
   
       @GetMapping("/queryUserList")
       public List<User> queryUserList(){
           List<User> userList = userMapper.queryUserList();
           return userList;
       }
   
       @GetMapping("/addUser")
       public String addUser(){
           userMapper.addUser(new User(9,"ned","123"));
           return "ok";
       }
   
       @GetMapping("updateUser")
       public String updateUser(){
           userMapper.updateUser(new User(9,"nde","321"));
           return "ok";
       }
   
       @GetMapping("/deleteUser")
       public String deleteUser(){
           userMapper.deleteUser(9);
           return "ok";
       }
   }