SpringBoot整合Mybatis

目录

1、导入包

2、编写配置文件，数据库连接和mybatis配置

3、测试数据库配置是否ok

4、连接数据库，mybatis

5、创建pojo文件夹，编写User类，对应数据库中的user表

6、创建mapper文件夹，编写UserMapper类

7、在resources下创建mybatis文件夹，再创建mapper文件夹

8、在mapper文件夹里创建UserMapper.xml，编写增删改查操作

9、在controller文件夹里面编写UserController类，进行操作 

10、效果

10.1、查询

​10.2、增加

10.3、修改

​10.4、删除

整体简单流程：

---

1、导入包

2、编写配置文件，数据库连接和mybatis配置

3、测试数据库配置是否ok

4、连接数据库，mybatis

5、创建pojo文件夹，编写User类，对应数据库中的user表

package com.zhou.pojo;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

@Data
@AllArgsConstructor
@NoArgsConstructor
public class User {
    private int id;
    private String name;
    private String pwd;

}

6、创建mapper文件夹，编写UserMapper类

7、在resources下创建mybatis文件夹，再创建mapper文件夹

8、在mapper文件夹里创建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.zhou.mapper.UserMapper">

    <select id="queryUserList" resultType="user">
        select * from mybatis.user;
    </select>

    <select id="queryUserById" resultType="user">
        select * from mybatis.user where id = #{id}
    </select>
    
    <insert id="addUser" parameterType="user">
        insert into mybatis.user (id, `name`, pwd)
        values (#{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>

9、在controller文件夹里面编写UserController类，进行操作 

package com.zhou.controller;

import com.zhou.mapper.UserMapper;
import com.zhou.pojo.User;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;

@RestController
public class UserController {

    @Autowired
    private UserMapper userMapper;

    @GetMapping("/queryUserList")
    public List<User> queryUserList(){
        List<User> userList = userMapper.queryUserList();
        for (User user : userList) {
            System.out.println(user);
        }
        return userList;
    }

    @GetMapping("/addUser")
    public String addUser(){
        userMapper.addUser(new User(6, "小小", "123321"));
        return "add-ok";
    }

    @GetMapping("/updateUser")
    public String updateUser(){
        userMapper.updateUser(new User(6, "小小2", "111111"));
        return "update-ok";
    }

    @GetMapping("/deleteUser")
    public String deleteUser(){
        userMapper.deleteUser(6);
        return "deleter-ok";
    }


}

10、效果

10.1、查询

10.2、增加

10.3、修改

10.4、删除

 

整体简单流程：