MyBtis的处理流程图
1、在resources文件夹下创建mappers文件夹和application.yml文件
2、在application.yml配置文件中配置mapper文件夹
内容为:
#mybatisPlus相关配置
mybatis-plus:
mapper-locations: classpath:mappers/*.xml
3、浅试一下,在mapper中添加登录的方法
4、在mappers文件夹中创建UserMapper.xml文件
上面的内容为
5、维护login方法的sql语句
6、在controller中测试
下面我们把增也写一下
测试代码如下
完整的增上代码如下
package demo.dao;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import demo.entity.User;
public interface UserDao extends BaseMapper<User> {
/**
* 登录
* @param userName
* @param passwad
* @return
*/
public User login(String userName,String passwad);
/**
* 新增
* @param user
* @return
*/
public int inUser(User user);
/**
* 根据id删除
* @param id
* @return
*/
public int deUser(Long id);
/**
* 根据id修改
* @param user
* @return
*/
public int upUser(User user);
}
<?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">
<!-- 此处的demo.dao为接口那路径-->
<mapper namespace="demo.dao.UserDao">
<!-- 此处的demo.entity为实体类那边的路径-->
<select id="login" resultType="demo.entity.User">
select * from t_user where user_name=#{userName} and passwad =#{passwad}
</select>
<!-- 增-->
<insert id="inUser">
insert into t_user values (#{id},#{userName},#{passwad})
</insert>
<!-- 删-->
<delete id="deUser">
delete from t_user where id=#{id}
</delete>
<!-- 改-->
<update id="upUser">
update t_user set user_name=#{userName},passwad=#{passwad} where id=#{id}
</update>
</mapper>
package demo.controller;
import demo.dao.UserDao;
import demo.entity.User;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
@Slf4j
@RestController
public class TestController {
@Autowired(required = false) //固定格式
private UserDao dao; //实列化dao接口
@RequestMapping("/login")
public String login(String userName, String passwad){
User user = dao.login(userName, passwad);
if(user != null){
return "登陆成功";
}else{
return "登录失败";
}
}
@RequestMapping("/t2")
public int t2(){
return dao.inUser(new User(null,"小猴","555"));
}
@RequestMapping("t3")
public int t3(){
return dao.deUser(1592509969174822914l);
}
@RequestMapping("t4")
public int t4(){
return dao.upUser(new User(1592420668395134977l,"逆苍天","9955"));
}
}