.java.vm 3.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134
  1. package ${basePackage}.entity.po;
  2. import com.png.jdbc.BasicQuery;
  3. import com.png.jdbc.annotations.*;
  4. import com.png.jdbc.BasicEntity;
  5. import lombok.Data;
  6. import lombok.EqualsAndHashCode;
  7. import java.util.Date;
  8. /**
  9. *${pojoComment}
  10. *@date ${datetime}
  11. */
  12. @Data
  13. @EqualsAndHashCode(callSuper = false)
  14. @Entity(clz = ${pojoName}.class,comment ="${pojoComment}")
  15. public class ${pojoName} implements Serializable{
  16. #foreach($ele in $fields)
  17. #if($ele.dataType=="int")
  18. @DBF(comment = "${ele.columnComment}")
  19. private int $ele.columnName;
  20. #end
  21. #if($ele.dataType=="tinyint"||$ele.dataType=="bool"||$ele.dataType=='int2')
  22. @DBF(comment = "${ele.columnComment}")
  23. private boolean $ele.columnName ;
  24. #end
  25. #if($ele.dataType=="bigint")
  26. @DBF(comment = "${ele.columnComment}")
  27. private long $ele.columnName ;
  28. #end
  29. #if($ele.dataType=="text")
  30. @DBF(comment = "${ele.columnComment}")
  31. #if($ele.columnName.indexOf("IdList")!=-1)
  32. private List<Long> $ele.columnName ;
  33. #else
  34. private List<SimpleVo> $ele.columnName ;
  35. #end
  36. #end
  37. #if($ele.dataType=="varchar")
  38. @DBF(comment = "${ele.columnComment}",max=$ele.dataLength)
  39. private String $ele.columnName ;
  40. #end
  41. #if($ele.dataType=="text")
  42. @DBF(comment = "${ele.columnComment}")
  43. private String $ele.columnName ;
  44. #end
  45. #if($ele.dataType=="char")
  46. @DBF(comment = "${ele.columnComment}",max=$ele.dataLength)
  47. private String $ele.columnName ;
  48. #end
  49. #if($ele.dataType=="date")
  50. @DBF(comment = "${ele.columnComment}")
  51. private Date $ele.columnName;
  52. #end
  53. #if($ele.dataType=="datetime")
  54. @DBF(comment = "${ele.columnComment}")
  55. private Date $ele.columnName;
  56. #end
  57. #if($ele.dataType=="timestamp")
  58. @DBF(comment = "${ele.columnComment}")
  59. private Date $ele.columnName;
  60. #end
  61. #end
  62. @Data
  63. @EqualsAndHashCode(callSuper = true)
  64. public static class ${pojoName}Info extends ${pojoName}{
  65. // @One(mkf = "createBy", tf = "name", comment = "创建人")
  66. // private String createName;
  67. // @One(mkf = "updateBy", tf = "name", comment = "更新人")
  68. // private String updateName;
  69. }
  70. @Data
  71. @EqualsAndHashCode(callSuper = true)
  72. @QE(clz=${pojoName}Info.class)
  73. public static class ${pojoName}BasicQuery extends BasicQuery{
  74. #foreach($ele in $fields)
  75. #if($ele.dataType=="int")
  76. private Integer ${ele.columnName} ;
  77. #end
  78. #if($ele.dataType=="tinyint")
  79. private Boolean $ele.columnName ;
  80. #end
  81. #if($ele.dataType=="bigint")
  82. private Long $ele.columnName ;
  83. #end
  84. #if($ele.dataType=="varchar")
  85. private String $ele.columnName ;
  86. #end
  87. #if($ele.dataType=="text")
  88. private String $ele.columnName ;
  89. #end
  90. #if($ele.dataType=="char")
  91. private String $ele.columnName ;
  92. #end
  93. #end
  94. //region date query
  95. #foreach($ele in $fields)
  96. #if($ele.dataType=="date")
  97. @QF(op=OP.GTE,tf="${ele.columnName}")
  98. private Date ${ele.columnName}Start ;
  99. @QF(op=OP.LTE,tf="${ele.columnName}")
  100. private Date ${ele.columnName}End ;
  101. #end
  102. #if($ele.dataType=="datetime")
  103. @QF(op=OP.GTE,tf="${ele.columnName}")
  104. private Date ${ele.columnName}Start;
  105. @QF(op=OP.LTE,tf="${ele.columnName}")
  106. private Date ${ele.columnName}End ;
  107. #end
  108. #if($ele.dataType=="timestamp")
  109. @QF(op=OP.GTE,tf="${ele.columnName}")
  110. private Date ${ele.columnName}Start ;
  111. @QF(op=OP.LTE,tf="${ele.columnName}")
  112. private Date ${ele.columnName}End ;
  113. #end
  114. #end
  115. //endregion
  116. //region sort query
  117. #foreach($ele in $fields)
  118. #if($ele.dataType=="int"||$ele.dataType=="bigint"||$ele.dataType=="tinyint"||$ele.dataType=="datetime"||$ele.dataType=="timestamp")
  119. private Integer ${ele.columnName}Sort ;
  120. #end
  121. #end
  122. //endregion
  123. }
  124. }