mapper.vm 2.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566
  1. package ${basePackage}.modules.${table.moduleName}.dal.mysql.${table.businessName};
  2. import java.util.*;
  3. import ${PageResultClassName};
  4. import ${QueryWrapperClassName};
  5. import ${BaseMapperClassName};
  6. import ${basePackage}.modules.${table.moduleName}.dal.dataobject.${table.businessName}.${table.className}DO;
  7. import org.apache.ibatis.annotations.Mapper;
  8. import ${basePackage}.modules.${table.moduleName}.controller.${table.businessName}.vo.*;
  9. ## 字段模板
  10. #macro(listCondition)
  11. #foreach ($column in $columns)
  12. #if (${column.listOperation})
  13. #set ($JavaField = $column.javaField.substring(0,1).toUpperCase() + ${column.javaField.substring(1)})##首字母大写
  14. #if (${column.listOperationCondition} == "=")##情况一,= 的时候
  15. .eqIfPresent("${column.columnName}", reqVO.get${JavaField}())
  16. #end
  17. #if (${column.listOperationCondition} == "!=")##情况二,!= 的时候
  18. .neIfPresent("${column.columnName}", reqVO.get${JavaField}())
  19. #end
  20. #if (${column.listOperationCondition} == ">")##情况三,> 的时候
  21. .gtIfPresent("${column.columnName}", reqVO.get${JavaField}())
  22. #end
  23. #if (${column.listOperationCondition} == ">=")##情况四,>= 的时候
  24. .geIfPresent("${column.columnName}", reqVO.get${JavaField}())
  25. #end
  26. #if (${column.listOperationCondition} == "<")##情况五,< 的时候
  27. .ltIfPresent("${column.columnName}", reqVO.get${JavaField}())
  28. #end
  29. #if (${column.listOperationCondition} == "<=")##情况五,<= 的时候
  30. .leIfPresent("${column.columnName}", reqVO.get${JavaField}())
  31. #end
  32. #if (${column.listOperationCondition} == "LIKE")##情况七,Like 的时候
  33. .likeIfPresent("${column.columnName}", reqVO.get${JavaField}())
  34. #end
  35. #if (${column.listOperationCondition} == "BETWEEN")##情况八,Between 的时候
  36. .betweenIfPresent("${column.columnName}", reqVO.getBegin${JavaField}(), reqVO.getEnd${JavaField}())
  37. #end
  38. #end
  39. #end
  40. #end
  41. /**
  42. * ${table.classComment} Mapper
  43. *
  44. * @author ${table.author}
  45. */
  46. @Mapper
  47. public interface ${table.className}Mapper extends BaseMapperX<${table.className}DO> {
  48. default PageResult<${table.className}DO> selectPage(${table.className}PageReqVO reqVO) {
  49. return selectPage(reqVO, new QueryWrapperX<${table.className}DO>()
  50. #listCondition()
  51. .orderByDesc("id")## 大多数情况下,id 倒序
  52. );
  53. }
  54. default List<${table.className}DO> selectList(${table.className}ExportReqVO reqVO) {
  55. return selectList(new QueryWrapperX<${table.className}DO>()
  56. #listCondition()
  57. .orderByDesc("id")## 大多数情况下,id 倒序
  58. );
  59. }
  60. }