mapper.vm 1.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748
  1. package ${basePackage}.${table.moduleName}.dal.mysql.dao.${table.businessName};
  2. import ${PageResultClassName};
  3. import ${QueryWrapperClassName};
  4. import ${BaseMapperClassName};
  5. import ${basePackage}.${table.moduleName}.dal.mysql.dataobject.${table.businessName}.${table.className}DO;
  6. import org.apache.ibatis.annotations.Mapper;
  7. /**
  8. * ${table.classComment} Mapper
  9. *
  10. * @author ${table.author}
  11. */
  12. @Mapper
  13. public interface ${table.className}Mapper extends BaseMapperX<${table.className}DO> {
  14. default PageResult<${table.className}DO> selectPage(${table.className}PageReqVO reqVO) {
  15. return selectPage(reqVO, new QueryWrapperX<${table.className}DO>()
  16. #foreach ($column in $columns)
  17. #if (${column.listOperation})
  18. #set ($JavaField = $column.javaField.substring(0,1).toUpperCase() + ${column.javaField.substring(1)})##首字母大写
  19. #if (${column.listOperationCondition} == "=")##情况一,= 的时候
  20. .eqIfPresent("${column.columnName}", reqVO.get${JavaField}())
  21. #end
  22. #if (${column.listOperationCondition} == "!=")##情况二,!= 的时候
  23. .neIfPresent("${column.columnName}", reqVO.get${JavaField}())
  24. #end
  25. #if (${column.listOperationCondition} == ">")##情况三,> 的时候
  26. .gtIfPresent("${column.columnName}", reqVO.get${JavaField}())
  27. #end
  28. #if (${column.listOperationCondition} == ">=")##情况四,>= 的时候
  29. .geIfPresent("${column.columnName}", reqVO.get${JavaField}())
  30. #end
  31. #if (${column.listOperationCondition} == "<")##情况五,< 的时候
  32. .gtIfPresent("${column.columnName}", reqVO.get${JavaField}())
  33. #end
  34. #if (${column.listOperationCondition} == "LIKE")##情况七,Like 的时候
  35. .likeIfPresent("${column.columnName}", reqVO.get${JavaField}())
  36. #end
  37. #if (${column.listOperationCondition} == "BETWEEN")##情况八,Between 的时候
  38. .betweenIfPresent("${column.columnName}", reqVO.getBegin${JavaField}(), reqVO.getEnd${JavaField}())
  39. #end
  40. #end
  41. #end
  42. );
  43. }
  44. }