sql脚本quartz

liulin

2024-11-24 0005dc22db405e69f07fd9a1d9b01fb87bd4e8f9

 src/main/java/com/lunhan/xxx/repository/impl/TestInfoMapperImpl.java

@@ -31,7 +31,7 @@
import com.lunhan.xxx.common.util.StringUtil;
import com.lunhan.xxx.entity.dto.OrderByDTO;
import com.lunhan.xxx.entity.dto.SearchBasicDTO;
import com.lunhan.xxx.entity.dto.search.SearchTestInfo;
import com.lunhan.xxx.entity.search.SearchTestInfo;
import com.lunhan.xxx.entity.enums.EOrderBy;
import com.lunhan.xxx.repository.BasicMapperImpl;
import com.lunhan.xxx.repository.mapper.TestInfoMapper;
@@ -57,11 +57,13 @@
      // 还原查询条件真实类型
      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();
@@ -109,15 +111,15 @@
               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;
               }
            }