mapper.vm 1.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142
  1. package ${basePackage}.${table.moduleName}.dal.mysql.dao.${table.businessName};
  2. import com.baomidou.mybatisplus.core.mapper.BaseMapper;
  3. import ${pageResultClassName};
  4. import ${QueryWrapperClassName};
  5. import ${BaseMapperClassName};
  6. import ${basePackage}.${table.moduleName}.dal.mysql.dataobject.${table.businessName}DO;
  7. import org.apache.ibatis.annotations.Mapper;
  8. @Mapper
  9. public interface ${table.className}Mapper extends BaseMapperX<${table.className}DO> {
  10. default PageResult<${table.className}DO> selectPage(${table.className}PageReqVO reqVO) {
  11. return selectPage(reqVO, new QueryWrapperX<${table.className}DO>()
  12. #foreach ($column in $columns)
  13. #if (${column.listOperation})
  14. #set ($JavaField = $column.javaField.substring(0,1).toUpperCase() + ${column.javaField.substring(1)})##首字母大写
  15. #if (${column.listOperationCondition} == "=")##情况一,= 的时候
  16. .eqIfPresent("${column.column_name}", reqVO.get${JavaField}())
  17. #end
  18. #if (${column.listOperationCondition} == "!=")##情况二,!= 的时候
  19. .neIfPresent("${column.column_name}", reqVO.get${JavaField}())
  20. #end
  21. #if (${column.listOperationCondition} == ">")##情况三,> 的时候
  22. .gtIfPresent("${column.column_name}", reqVO.get${JavaField}())
  23. #end
  24. #if (${column.listOperationCondition} == ">=")##情况四,>= 的时候
  25. .geIfPresent("${column.column_name}", reqVO.get${JavaField}())
  26. #end
  27. #if (${column.listOperationCondition} == "<")##情况五,< 的时候
  28. .gtIfPresent("${column.column_name}", reqVO.get${JavaField}())
  29. #end
  30. #if (${column.listOperationCondition} == "<=")##情况六,<= 的时候
  31. .geIfPresent("${column.column_name}", reqVO.get${JavaField}())
  32. #end
  33. #end
  34. #end
  35. );
  36. }
  37. }