| | |
| | | import org.apache.ibatis.annotations.Param; |
| | | import org.apache.ibatis.annotations.Select; |
| | | |
| | | import java.util.List; |
| | | |
| | | @Mapper |
| | | public interface TestInfoMapper extends BasicMapper<TestInfoPO> { |
| | | // #{param}:会进行预编译,而且进行类型匹配,最后进行变量替换,括号中可以添加映射类型如 |
| | |
| | | @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); |
| | | |
| | | } |