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/mapper/TestInfoMapper.java | 11 +++++++---- 1 files changed, 7 insertions(+), 4 deletions(-) diff --git a/src/main/java/com/lunhan/xxx/repository/mapper/TestInfoMapper.java b/src/main/java/com/lunhan/xxx/repository/mapper/TestInfoMapper.java index 583f123..a8017d1 100644 --- a/src/main/java/com/lunhan/xxx/repository/mapper/TestInfoMapper.java +++ b/src/main/java/com/lunhan/xxx/repository/mapper/TestInfoMapper.java @@ -8,8 +8,11 @@ import org.apache.ibatis.annotations.Param; import org.apache.ibatis.annotations.Select; +import java.util.List; + @Mapper public interface TestInfoMapper extends BasicMapper<TestInfoPO> { + //==================== 自定义sql查询方法 声明示例 - begin ==================== // #{param}:会进行预编译,而且进行类型匹配,最后进行变量替换,括号中可以添加映射类型如 // @Select( // "<script>" + @@ -21,13 +24,13 @@ @Select("select * from test_info where id = #{id}") TestInfoPO testGet(Long id); - @Select("select * from test_info where id = #{userName}") + @Select("select * from test_info where name = #{name}") TestInfoPO testGet2(String userName); @Select("select * from test_info where status = #{ew.status}") - TestInfoPO testGet3(@Param(Constants.WRAPPER) SearchTestInfo search); + List<TestInfoPO> testList1(@Param(Constants.WRAPPER) SearchTestInfo search); @Select("select * from test_info where status = #{search.status}") - TestInfoPO testGet4(@Param("search") SearchTestInfo search); - + List<TestInfoPO> testList2(@Param("search") SearchTestInfo search); + //==================== 自定义sql查询方法 声明示例 - end ==================== } -- Gitblit v1.9.3