mybatis plus 链式编程查询

mybatis plus 链式编程查询

通过构造QueryWrapper构造查询语句

HashMap<String, Object> stringObjectHashMap = new HashMap<>();
stringObjectHashMap.put("id", 123);
stringObjectHashMap.put("name", "jack");

//通过构造条件
QueryWrapper QueryWrapper = new QueryWrapper<User>();
QueryWrapper.allEq(stringObjectHashMap);
//获取一个list
List<User> list = userService.list(QueryWrapper);
List<Map<String, Object>> listMaps = userService.listMaps(QueryWrapper);
//获取一个map或者一个实体类
Map map = userService.getMap(QueryWrapper);
User one = userService.getOne(QueryWrapper);

通过QueryChainWrapper链式编程的方式构建查询语句

HashMap<String, Object> stringObjectHashMap = new HashMap<>();
stringObjectHashMap.put("id", 123);
stringObjectHashMap.put("name", "jack");

//链式编程
List<User> userList = userService.query()
	.allEq(stringObjectHashMap)
	.list();

//连续多个查询条件
List<User> userList1 = userService.query()
	.allEq(stringObjectHashMap)
	.orderByAsc("id")
	.list();

通过UpdateWrapper构造跟新条件

//跟新
UpdateWrapper<User> objectUpdateWrapper = new UpdateWrapper<>();
objectUpdateWrapper.eq("id",1);
boolean update = userService.update(new User(), objectUpdateWrapper);

通过UpdateChainWrapper构造条件链

userService.update().eq("id",1).update();