From ee5baccab552762e9d57fb3fab04cd099dae018d Mon Sep 17 00:00:00 2001
From: liulin <lin.liu@aliyun.com>
Date: 星期二, 03 九月 2024 23:59:11 +0800
Subject: [PATCH] BasicMapperImpl
---
src/main/java/com/lunhan/xxx/repository/impl/TestInfoMapperImpl.java | 19 +++++++++++++++----
1 files changed, 15 insertions(+), 4 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..193bb4b 100644
--- a/src/main/java/com/lunhan/xxx/repository/impl/TestInfoMapperImpl.java
+++ b/src/main/java/com/lunhan/xxx/repository/impl/TestInfoMapperImpl.java
@@ -38,6 +38,8 @@
import com.lunhan.xxx.repository.po.TestInfoPO;
import org.springframework.stereotype.Repository;
+import java.util.List;
+
/**
* 测试信息 数据访问类
* @author lin.liu
@@ -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