springboot整合Mybatis

package com.liu.springboot03.pojo;

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

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

package com.liu.springboot03.mapper;

import com.liu.springboot03.pojo.User;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;

import java.util.List;

//这个注解表示是一个mybatis的mapper
@Mapper
@Repository
public interface UserMapper {

    List queryUserList();

    User queryUserById(int id);

    int addUser(User user);

    int deleteUser(int id);

    int updateUser(User user);
}

```xml




    
        select * from user
    

    
        delete from user where id = #{id}
    

    
        update user set name=#{name},pwd=#{pwd} where id = #{id}
    

    
        select *from user where id = #{id}
    

    
        insert into user (id,name,pwd) values (#{id},#{name},#{pwd})
    

spring.datasoure.user=root
spring.datasoure.password="root"
spring.datasource.url=jdbc:mysql://localhost:3306/mybatis?useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone=UTC&rewriteBatchedStatements=true
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver


mybatis.type-aliases-package=com.liu.springboot03.pojo
mybatis.mapper-locations=classpath:mybatis/mapper/*.xml

package com.liu.springboot03.controller;
import com.liu.springboot03.mapper.UserMapper;
import com.liu.springboot03.pojo.User;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;
import java.util.List;

@RestController
public class UserController {

    @Autowired
    private UserMapper userMapper;

    //查询所有用户
    @RequestMapping("/user")
    public List queryUserList(){
        List users = userMapper.queryUserList();
        for (User user:users) {
            System.out.println(users);
        }
        return users;
    }
    //增加一个用户
    @RequestMapping("/add")
    public String addUser(){
        userMapper.addUser(new User(16,"李佳琪","1234422"));
        return "OK";
    }

    //删除一个用户
    @RequestMapping("delete")
    public String deleteUser(@RequestParam("id") int id){
        userMapper.deleteUser(id);
        return "ok";
    }

    //修改一个用户
    @RequestMapping("/update")
    public String updateUser(){
        System.out.println("执行了方法-------");
        userMapper.updateUser(new User(16,"二驴","12345666"));
        return "ok";
    }
}