Springboot整合mybatis的步骤

这篇文章主要介绍了Springboot整合mybatis的步骤，帮助大家更好的理解和学习使用

前期工作

1.导入mybatis整合依赖

  org.mybatis.spring.bootmybatis-spring-boot-starter2.1.4

2.连接数据库

3.连接完数据库就去applicaton.yml配置一下数据库

 spring: datasource: username: root password: 123456 url: jdbc:mysql://localhost:3306/mybatis?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8 driver-class-name: com.mysql.cj.jdbc.Driver

开始整合

1.编写与数据库对应的实体类

 package com.example.pojo; import lombok.AllArgsConstructor; import lombok.Data; import lombok.NoArgsConstructor; @Data @AllArgsConstructor @NoArgsConstructor public class User { private Integer id; private String name; private String pwd; }

为了偷懒，导入了lombok

  org.projectlomboklombok

2.编写mapper

 package com.example.mapper; import com.example.pojo.User; import org.apache.ibatis.annotations.Mapper; import org.springframework.stereotype.Repository; import java.util.List; @Mapper @Repository public interface UserMapper { //查询用户的全部信息 List getUserList(); //select 找出id=1的用户 User getUserById(int id); //insert 增加一个用户 int insertUser(User user); //delete 删除id=4的用户 int deleteUser(int id); //update 将id=2的用户名字改为小龙 int updateUser(User user); }

3.编写mapper.xml文件

    insert into mybatis.user (id, name, pwd) values (#{id}, #{name}, #{pwd});  delete from mybatis.user where id = #{id};  update mybatis.user set name = #{name}, pwd = #{pwd} where id = #{id};

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

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

mapper.xml文件编写的位置：

4.编写controller

 package com.example.controller; import com.example.mapper.UserMapper; import com.example.pojo.User; import org.apache.ibatis.annotations.Param; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.GetMapping; import org.springframework.web.bind.annotation.PathVariable; import org.springframework.web.bind.annotation.RestController; import java.util.List; @RestController public class UserController { @Autowired private UserMapper userMapper; @GetMapping("/getUserList") public List getUserList(){ return userMapper.getUserList(); } @GetMapping("/getUserById/{id}") public User getUserById(@PathVariable("id") int id){ return userMapper.getUserById(id); } @GetMapping("/insertUser") public String insertUser(){ userMapper.insertUser(new User(5,"xiaoming","111")); return "ok"; } @GetMapping("/deleteUser") public String deleteUser(){ userMapper.deleteUser(5); return "ok"; } @GetMapping("/updateUser") public String updateUser(){ userMapper.updateUser(new User(5,"xx","111")); return "ok"; } }