使用MyBatis实现基本CRUD

一.在resoures文件夹下创建mappers文件夹

二.在application.yml配合文件中配置mappers文件夹

#mybatisPlus相关配置
mybatis-plus:
  mapper-locations: classpath:mappers/*.xml

三.在mapper中添加登录的方法

public User login(String userName , Stirng passwd);

四.在mappers文件夹中创建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指定mapper路径

<mapper namespace="demo.dao.UserMapper">

</mapper>

五.维护login方法中的sql语句

1.添加select标签,通过id指定方法名,resultType指定返回值类型

<select id="login" resultType="demo.entity.User">
       
    </select>

2.填写sql语句,变量用#{}修饰

 select * from t_user where user_name=#{userName} and passwd=#{passwd}

六.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="demo.dao.UserDAO">

    <select id="login" resultType="demo.entity.User">
        select * from t_user where user_name=#{userName} and passwd=#{passwd}
    </select>
</mapper>

七.7.在controller中测试

@RequestMapping("/login")
public String login(String userName, String passwd){
    User u = dao.login(userName, passwd);
    if(u != null){
        return "登录成功";
    } else {
        return "登录失败";
    }
}

思维导图如下: