queryWapper使用笔记
queryWrapper常用方法
多条件入参使用and和or加括号的情况下的用法
queryWrapper.nested(wrapper->
wrapper.eq("", "")
.eq("assess_month", jsonObject.getString("assessMonth"))
.eq("", "")
);
queryWrapper.or(wrapper->
wrapper.eq("", "")
.eq("", "")
.eq("assess_month", jsonObject.getString("assessMonth"))
.eq("i", "")
);
使用queryWrapper实现分页 查询可以使用selectOne(selectList)
QueryWrapper<ArtisanAction> queryWrapper = new QueryWrapper<>();
queryWrapper.eq("assess_month", assessMonth);
queryWrapper.orderByAsc("task_id");
IPage<ArtisanAction> page = new Page<>();
page.setCurrent(jsonObject.getInteger("page"));
page.setSize(jsonObject.getInteger("pageSize"));
IPage<ArtisanAction>artisanActions = artisanActionMapper.selectPage(page,queryWrapper);
修改
UpdateWrapper<ArtisanActionScoreRate> resModel = new UpdateWrapper<>();
resModel.set("targeted_value","");
resModel.set("score","");
resModel.eq("id","");
int j = artisanActionScoreMapper.update(null,resModel);
queryWrapper实现取日期范围(待补充)
if(startTime!=null ){
queryWrapper.ge("created_time", startTime);
}
if(endTime!=null ){
queryWrapper.le("created_time", endTime);
}