From ec5ab0518e7a5ce3b469f08395a522caacff4a4d Mon Sep 17 00:00:00 2001
From: liulin <lin.liu@88.com>
Date: 星期六, 01 三月 2025 14:51:21 +0800
Subject: [PATCH] 修改配置
---
src/main/java/com/lunhan/xxx/repository/impl/TestInfoMapperImpl.java | 21 ++++++++++++++++-----
1 files changed, 16 insertions(+), 5 deletions(-)
diff --git a/src/main/java/com/lunhan/xxx/repository/impl/TestInfoMapperImpl.java b/src/main/java/com/lunhan/xxx/repository/impl/TestInfoMapperImpl.java
index 7b3a682..22779e5 100644
--- a/src/main/java/com/lunhan/xxx/repository/impl/TestInfoMapperImpl.java
+++ b/src/main/java/com/lunhan/xxx/repository/impl/TestInfoMapperImpl.java
@@ -31,12 +31,14 @@
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;
import com.lunhan.xxx.repository.po.TestInfoPO;
import org.springframework.stereotype.Repository;
+
+import java.util.List;
/**
* 测试信息 数据访问类
@@ -45,7 +47,7 @@
* @date 2021/11/23
*/
@Repository
-public class TestInfoMapperImpl extends BasicMapperImpl<TestInfoPO> {
+public class TestInfoMapperImpl extends BasicMapperImpl<TestInfoPO, TestInfoMapper> {
public TestInfoMapperImpl(TestInfoMapper mapper) {
super(mapper);
}
@@ -54,6 +56,15 @@
public PagerResult<TestInfoPO> search(SearchBasicDTO request) {
// 还原查询条件真实类型
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();
// 非逻辑删除
@@ -100,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;
}
}
--
Gitblit v1.9.3