【Mybatis-plus】：Wapper

【Mybatis-plus】：Wapper

主要方法：

QueryWrapper

各种方法：

	isNotNull  不为空
 *                 ge 大于等于
 *                 gt 大于
 *                 le 小于等于
 *                 lt 小于
 *                 eq 等于   selectOne
 *
 *                 between and
 *
 *                 like  模糊查询   %..%
 *                 likeLeft   %..
 *                 likeRight  ..%
 *                 notLike  not %..%
 *                 inSql (age,"select id from user where id > 3")
 *                          age in ("select id from user where id > 3")
 *
 *
 *                  orderByDesc     id 降序排序

测试：

			   @Test
    public void test1(){
        //查询name不为空，age小于等于 20 的
        QueryWrapper<User> wrapper = new QueryWrapper<> ();
        wrapper.isNotNull ("name");
        wrapper.le ("age",20);
        List<User> list = userMapper.selectList (wrapper);
        for (User user : list) {
            System.out.println (list);
        }
    }

updateWrapper：

	@Test
public void testUpdate1() {
 
    //修改值
    User user = new User();
    user.setAge(99);
    user.setName("Andy");
 
    //修改条件
    UpdateWrapper<User> userUpdateWrapper = new UpdateWrapper<>();
    userUpdateWrapper
        .like("name", "h")
        .or()
        .between("age", 20, 30);
 
    int result = userMapper.update(user, userUpdateWrapper);
    System.out.println(result);

UPDATE user SET name=?, age=?, update_time=? WHERE deleted=0 AND name LIKE ? OR age BETWEEN ? AND ?