| | |
| | | // 还原查询条件真实类型 |
| | | SearchTestInfo search = (SearchTestInfo)request; |
| | | |
| | | //==================== 自定义sql查询方法 调用示例 - begin ==================== |
| | | TestInfoPO model1 = DB.testGet(553261510198173696L); |
| | | TestInfoPO model2 = DB.testGet2("verona.stroman"); |
| | | |
| | | List<TestInfoPO> list1 = DB.testList1(search); |
| | | List<TestInfoPO> list2 = DB.testList2(search); |
| | | //==================== 自定义sql查询方法 调用示例 - end ==================== |
| | | |
| | | // 查询条件 |
| | | LambdaQueryWrapper<TestInfoPO> queryWrapper = this.query(); |
| | |
| | | switch (orderBy) { |
| | | // 主键 |
| | | case ID: |
| | | queryWrapper.orderByAsc(TestInfoPO::getId); |
| | | queryWrapper.orderByDesc(TestInfoPO::getId); |
| | | break; |
| | | // 数据创建时间 |
| | | case CREATE_TIME: |
| | | queryWrapper.orderByAsc(TestInfoPO::getCreateTime); |
| | | queryWrapper.orderByDesc(TestInfoPO::getCreateTime); |
| | | break; |
| | | // 最后更新时间 |
| | | case UPDATE_TIME: |
| | | queryWrapper.orderByAsc(TestInfoPO::getUpdateTime); |
| | | queryWrapper.orderByDesc(TestInfoPO::getUpdateTime); |
| | | break; |
| | | } |
| | | } |