条件构造器
1.Wrapper介绍
-
Wrapper
: 条件构造抽象类,最顶端父类-
AbstractWrapper
: 用于查询条件封装,生成 sql 的 where 条件-
QueryWrapper
: 查询条件封装 -
UpdateWrapper
: Update 条件封装 -
AbstractLambdaWrapper
: 使用Lambda 语法-
LambdaQueryWrapper
:用于Lambda语法使用的查询Wrapper -
LambdaUpdateWrapper
: Lambda 更新封装Wrapper
-
-
-
2.QueryWrapper
-
组装查询条件
**执行SQL:**SELECT uid AS id,username AS name,age,email,is_deleted FROM t_user WHERE is_deleted=0 AND (username LIKE ? AND age BETWEEN ? AND ? AND email IS NOT NULL)
public void test01(){ //查询用户名包含a,年龄在20到30之间,邮箱信息不为null的用户信息 QueryWrapper<User> queryWrapper = new QueryWrapper<>(); queryWrapper.like("username","a").between("age",20,30).isNotNull("email"); List<User> users = userMapper.selectList(queryWrapper); users.forEach(System.out::println); }
-
组装排序条件
**执行SQL:**SELECT uid AS id,username AS name,age,email,is_deleted FROM t_user WHERE is_deleted=0 ORDER BY age DESC,id ASC
public void test02(){ //查询用户信息,按照年龄的降序排序,若年龄相同,则按照id升序排序 QueryWrapper<User> queryWrapper = new QueryWrapper<>(); queryWrapper.orderByDesc("age").orderByAsc("id"); List<User> users = userMapper.selectList(queryWrapper); users.forEach(System.out::println); }
-
组装删除条件
**执行SQL:**UPDATE t_user SET is_deleted=1 WHERE is_deleted=0 AND (email IS NULL)
public void test03(){ //删除邮箱地址为null的用户信息 QueryWrapper<User> queryWrapper = new QueryWrapper<>(); queryWrapper.isNull("email"); int result = userMapper.delete(queryWrapper); System.out.println(result > 0 ? "删除成功!" : "删除失败!"); System.out.println("受影响的行数