整合mybatis

正常业务需要service业务层，这里没用，直接用了controller

依赖

<!--        mybatis  整合-->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.1</version>
        </dependency>
<!--    数据库驱动 官方的-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>
<!--    数据库驱动-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>

配置

#连接数据库
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.url=jdbc:mysql://localhost:3306/emps?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

#整合mybatis
#设置别名的包
mybatis.type-aliases-package=com.li.springbootmybatis.pojo 
#地址
mybatis.mapper-locations=classpath:mybatis/*.xml

1.参照数据库创建实体类

2.Mapper接口（及其配置）

1）创建接口类（负责方法 如查询，增删改查）

2）整合mybatis

3）mapper配置xml文件（注意对应关系，需要mapper文件位置）

<?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-->
<mapper namespace="com.li.springbootmybatis.mapper.UserMapper">

    
    <select id="queryUserList" resultType="User">
        select * from user
    </select>

    <select id="queryUserById" resultType="User">
        select * from user where id = #{id}
    </select>

    <insert id="addUser" parameterType="User">
        insert into user (id,name,pwd) values (#{id},#{name},#{pwd})
    </insert>

    <update id="updateUser" parameterType="User">
        update user set name=#{name},pwd=#{pwd} where id = #{id}
    </update>

    <delete id="deleteUser" parameterType="int">
        delete from user where id = #{id}
    </delete>

</mapper>

没写service业务层直接调用Controller

Controller

UserController.java代码

package com.li.springbootmybatis.controller;

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

import java.util.List;

@RestController
public class UserContrllor {

    @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("/queryUserById")
    public User queryUserById(int id){
        User userList = userMapper.queryUserById(101);
        return userList;
    }

    @GetMapping("/addUser")
    public String addUser(User user){
        userMapper.addUser(new User(102,"wang","123456"));
        return "add,ok";
    }

    @GetMapping("/updateUser")
    public String updateUser(User user){
        userMapper.updateUser(new User(102,"wang","123456"));
        return "update,ok";
    }

    public String deleteUser(int id){
        userMapper.deleteUser(5);
        return "delete,ok";
    }

}