插入
userMapper.insert(entity);
@Test
void testInsert(){
User user=new User();
user.setUsername("小阿坤");
user.setPassword("123456");
user.setRole(1);
user.setCtime(new Date());
int rows = userMapper.insert(user);
System.out.println(rows+"行受影响!");
}
删除
⭕根据记录的id进行删除:
userMapper.deleteById(3);
⭕根据Map集合,将符合条件的记录进行删除
userMapper.deleteByMap(map);
java
@Test
void testDeleteById(){
int rows;
// rows= userMapper.deleteById(3);
Map map = new HashMap<>();
map.put("username", "小阿坤");
rows= userMapper.deleteByMap(map);
System.out.println(rows+"行受影响!");
}
修改
user为旧对象,user1为新对象;
BeanUtilCopy为工具类,用于拷贝对象属性值
对象属性拷贝工具类参考此文章链接🖱
userMapper.update(user1,updateWrapper);//第一个参数为新实体对象,第二个参数为需要更新的条件;满足条件的记录将会被修改
@Test
void testUpdate(){
User user=new User();
user.setUsername("小阿坤");
user.setPassword("123456");
user.setRole(1);
user.setCtime(new Date());
System.out.println("user\n"+user);
UpdateWrapper updateWrapper=new UpdateWrapper();
User user1 =new User();
BeanUtilCopy.copyProperties(user,user1);//拷贝对象属性赋值给新对象
user1.setUsername("ikun");
user1.setRole(0);
System.out.println("user\n"+user1);
updateWrapper.eq("username","小阿坤");
userMapper.update(user1,updateWrapper);
}
查找
使用条件构造器:官方文档链接
①使用userMapper.selectByMap(map);查找满足条件的记录
@Test
void testSelectByMap() {
Map map=new HashMap();
map.put("username","刘翠花");
List<User> list = userMapper.selectByMap(map);
for (User u:list) {
System.out.println(u);
}
}
②使用userMapper.selectList(queryWrapper);查找同样是查找满足条件的记录
@Test
void selectList(){
QueryWrapper queryWrapper=new QueryWrapper();
queryWrapper.eq("username","ikun");
Map map=new HashMap();
map.put("role",0);
queryWrapper.allEq(map);//条件查询
queryWrapper.likeRight("password","12");//模糊查询
List<User> userList = userMapper.selectList(queryWrapper);
for (User user: userList ) {
System.out.println(user);
}
}