一、向数据库插入数据
1.1、在UserDAO中添加addUser方法
1.2、在UserMapp.xml中匹配addUser方法,并维护sql语句
<insert id="addUser">
insert into t_user (id, user_name, passwd) values (#{id}, #{name}, #{passwd})
</insert>
复制代码
1.3、在controller中测试
@RequestMapping("/t8")
public int t8(){
int count = dao.addUser(new User(1001L, "mike", "321"));
return count;
}
复制代码
二、从数据库查询数据
2.1、在UserDAO中添加login方法
2.2、在UserMapp.xml中匹配login方法,并维护sql语句
<select id="login" resultType="demo.entity.User">
select * from t_user where user_name=#{userName} and passwd=#{passwd}
</select>
复制代码
2.3、在controller中测试
@RequestMapping("/login")
public String login(String userName, String passwd){
User u = dao.login(userName, passwd);
if(u != null){
return "登录成功";
} else {
return "登录失败";
}
}
复制代码
三、根据id修改数据
3.1、在UserDAO中添加updateUser方法
3.2、在UserMapp.xml中匹配updateUser方\法,并维护sql语句
<update id="updateUser">
update t_user set user_name=#{name} , passwd=#{passwd} where id=#{id}
</update>
复制代码
3.3、在controller中测试
@RequestMapping("/t9")
public int t9(){
int count = dao.updateUser(new User(1001L, "tom10", "123"));
return count;
}
复制代码
四、根据id删除数据
4.1、在UserDAO中添加deleteUser方法
4.2、在UserMapp.xml中匹配deleteUser方法,并维护sql语句
<delete id="deleteUser">
delete from t_user where id=#{id}
</delete>
复制代码
4.3、在controller中测试
@RequestMapping("/t10")
public int t10(){
int count = dao.deleteUser(1001L);
return count;
}
复制代码
五、完整的代码
5.1、UserDAO
package demo.dao;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import demo.entity.User;
public interface UserDAO extends BaseMapper<User> {
public User login(String userName, String passwd);
public int addUser(User user);
public int updateUser(User user);
public int deleteUser(Long id);
}
复制代码
5.2、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>
<insert id="addUser">
insert into t_user (id, user_name, passwd) values (#{id}, #{name}, #{passwd})
</insert>
<update id="updateUser">
update t_user set user_name=#{name} , passwd=#{passwd} where id=#{id}
</update>
<delete id="deleteUser">
delete from t_user where id=#{id}
</delete>
</mapper>
复制代码
5.3、User.java
package demo.entity;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
@Data //生成Get和Set方法,重写toString
@AllArgsConstructor //生成有参构造器
@NoArgsConstructor //生成无参构造器
@TableName("t_user") //设置表名
public class User {
@TableId //指定主键id
private Long id;
@TableField("user_name")
private String name;
private String passwd;
}
作者:大坏蛋_
链接:https://juejin.cn/post/7166177807809118216
来源:稀土掘金
著作权归作者所有。商业转载请联系作者获得授权,非商业转载请注明出处。