基础语句
初始化
QueryWrapper<TestEntity> queryWrapper = new QueryWrapper<TestEntity>();
select内容
queryWrapper .select("isnull(sum(amount_total),0) as total ");
where条件
// 等于
queryWrapper.eq("name", "aa");
// like
String name = "aa";
queryWrapper.like("name",name);
// in
List IdList = Arrays.asList(1,2);
queryWrapper.in("id",IdList );
// 不等于null
queryWrapper.isNull("name")
// 排序
queryWrapper.orderByDesc("time");
queryWrapper.orderByAsc("time");
// 分组、过滤
queryWrapper.groupBy("name");
queryWrapper.groupBy("name").having("age > 18");
查询
// 分页
TestMapper.selectPage(new Page<TestEntity>(1,6),queryWrapper);
// 返回list
dataMapper.selectList(queryWrapper);
// 求和
TestMapper.selectCount(queryWrapper);
// 返回map,结果只能单条数据
Map<String, Object> map = TestMapper.getMap(queryWrapper);