@TestpublicvoidtestUpdateById(){User user =newUser();
user.setId(1L);
user.setAge(19);int i =this.userMapper.updateById(user);System.out.println("受影响条数:"+ i);}
根据条件更新
使用实体类 QueryWrapper
@TestpublicvoidtestUpdateByCondition(){User user =newUser();
user.setAge(20);
user.setPassword("888888");QueryWrapper<User> wrapper =newQueryWrapper<>();
wrapper.eq("user_name","zhangsan");// 匹配user_name = "zhangsan" 的条件int i =this.userMapper.update(user, wrapper);System.out.println("受影响条数:"+ i);}
不用实体类 UpdateWrapper
@TestpublicvoidtestUpdateByCondition1(){UpdateWrapper<User> wrapper =newUpdateWrapper<>();
wrapper.set("age",21).set("password","999999")// 更新的字段.eq("user_name","zhangsan");// 更新的条件int i =this.userMapper.update(null, wrapper);System.out.println("受影响条数:"+ i);}
删除操作
根据id删除
@TestpublicvoidtestDeleteById(){int i =this.userMapper.deleteById(8);System.out.println("受影响条数:"+ i);}
根据columnMap条件,删除
@TestpublicvoidtestDeleteByMap(){Map<String,Object> map =newHashMap<>();
map.put("user_name","ssc");
map.put("password","123456");int i =this.userMapper.deleteByMap(map);System.out.println("受影响条数:"+ i);}
根据entity条件,删除
用法一
@TestpublicvoidtestDeleteByWrapper(){QueryWrapper<User> wrapper =newQueryWrapper<>();
wrapper.eq("user_name","ssc").eq("password","123456");int i =this.userMapper.delete(wrapper);System.out.println("受影响条数:"+ i);}
用法二
@TestpublicvoidtestDeleteByWrapper(){User user =newUser();
user.setUserName("ssc1");
user.setPassword("123456");QueryWrapper<User> wrapper =newQueryWrapper<>(user);// wraper根据user来包装自己的的参数int i =this.userMapper.delete(wrapper);System.out.println("受影响条数:"+ i);}
根据id,批量删除
@TestpublicvoidtestDeleteBatchId(){int i =this.userMapper.deleteBatchIds(Arrays.asList(8L,9L));System.out.println("受影响条数:"+ i);}
DELETE FROM tb_user WHERE id IN (?,?)
查询操作
id查询
@TestpublicvoidtestSelectById(){User user =this.userMapper.selectById(1);System.out.println(user);}