前期工作
1.導入mybatis整合依賴
|
1
2
3
4
5
6
|
<!-- mybatis整合 --><dependency><groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>2.1.4</version></dependency> |
2.連接數據庫
3.連接完數據庫就去applicaton.yml配置一下數據庫
|
1
2
3
4
5
6
|
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.編寫與數據庫對應的實體類
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
package com.example.pojo;import lombok.AllArgsConstructor;import lombok.Data;import lombok.NoArgsConstructor;@Data@AllArgsConstructor@NoArgsConstructorpublic class User { private Integer id; private String name; private String pwd;} |
為了偷懶，導入了lombok
|
1
2
3
4
5
|
<!-- lombok --><dependency> <groupId>org.projectlombok</groupId> <artifactId>lombok</artifactId></dependency> |
2.編寫mapper
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
|
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@Repositorypublic interface UserMapper { //查詢用戶的全部信息 List<User> 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文件
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
|
<?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.mapper.UserMapper"> <select id="getUserList" resultType="user"> select * from mybatis.user </select> <select id="getUserById" resultType="user" parameterType="int"> select * from mybatis.user where id = #{id}; </select> <insert id="insertUser" parameterType="user"> insert into mybatis.user (id, name, pwd) values (#{id}, #{name}, #{pwd}); </insert> <delete id="deleteUser" parameterType="int"> delete from mybatis.user where id = #{id}; </delete> <update id="updateUser" parameterType="user"> update mybatis.user set name = #{name}, pwd = #{pwd} where id = #{id}; </update></mapper> |
這里我們用了別名而且我們把這個mapper.xml文件放在了resources目錄下，所以我們要去application.yml配置一下
|
1
2
3
|
mybatis: type-aliases-package: com.example.pojo mapper-locations: classpath:mybatis/mapper/*.xml |
mapper.xml文件編寫的位置：
4.編寫controller
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
|
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;@RestControllerpublic class UserController { @Autowired private UserMapper userMapper; @GetMapping("/getUserList") public List<User> 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"; }} |
5.進行測試
以上就是Springboot整合mybatis的步驟的詳細內容，更多關于Springboot整合mybatis的資料請關注服務器之家其它相關文章！
原文鏈接：https://juejin.cn/post/6949443343780675620
