| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134 |
- package ${basePackage}.entity.po;
- import com.png.jdbc.BasicQuery;
- import com.png.jdbc.annotations.*;
- import com.png.jdbc.BasicEntity;
- import lombok.Data;
- import lombok.EqualsAndHashCode;
- import java.util.Date;
- /**
- *${pojoComment}
- *@date ${datetime}
- */
- @Data
- @EqualsAndHashCode(callSuper = false)
- @Entity(clz = ${pojoName}.class,comment ="${pojoComment}")
- public class ${pojoName} implements Serializable{
- #foreach($ele in $fields)
- #if($ele.dataType=="int")
- @DBF(comment = "${ele.columnComment}")
- private int $ele.columnName;
- #end
- #if($ele.dataType=="tinyint"||$ele.dataType=="bool"||$ele.dataType=='int2')
- @DBF(comment = "${ele.columnComment}")
- private boolean $ele.columnName ;
- #end
- #if($ele.dataType=="bigint")
- @DBF(comment = "${ele.columnComment}")
- private long $ele.columnName ;
- #end
- #if($ele.dataType=="text")
- @DBF(comment = "${ele.columnComment}")
- #if($ele.columnName.indexOf("IdList")!=-1)
- private List<Long> $ele.columnName ;
- #else
- private List<SimpleVo> $ele.columnName ;
- #end
- #end
- #if($ele.dataType=="varchar")
- @DBF(comment = "${ele.columnComment}",max=$ele.dataLength)
- private String $ele.columnName ;
- #end
- #if($ele.dataType=="text")
- @DBF(comment = "${ele.columnComment}")
- private String $ele.columnName ;
- #end
- #if($ele.dataType=="char")
- @DBF(comment = "${ele.columnComment}",max=$ele.dataLength)
- private String $ele.columnName ;
- #end
- #if($ele.dataType=="date")
- @DBF(comment = "${ele.columnComment}")
- private Date $ele.columnName;
- #end
- #if($ele.dataType=="datetime")
- @DBF(comment = "${ele.columnComment}")
- private Date $ele.columnName;
- #end
- #if($ele.dataType=="timestamp")
- @DBF(comment = "${ele.columnComment}")
- private Date $ele.columnName;
- #end
- #end
- @Data
- @EqualsAndHashCode(callSuper = true)
- public static class ${pojoName}Info extends ${pojoName}{
- // @One(mkf = "createBy", tf = "name", comment = "创建人")
- // private String createName;
- // @One(mkf = "updateBy", tf = "name", comment = "更新人")
- // private String updateName;
- }
- @Data
- @EqualsAndHashCode(callSuper = true)
- @QE(clz=${pojoName}Info.class)
- public static class ${pojoName}BasicQuery extends BasicQuery{
- #foreach($ele in $fields)
- #if($ele.dataType=="int")
- private Integer ${ele.columnName} ;
- #end
- #if($ele.dataType=="tinyint")
- private Boolean $ele.columnName ;
- #end
- #if($ele.dataType=="bigint")
- private Long $ele.columnName ;
- #end
- #if($ele.dataType=="varchar")
- private String $ele.columnName ;
- #end
- #if($ele.dataType=="text")
- private String $ele.columnName ;
- #end
- #if($ele.dataType=="char")
- private String $ele.columnName ;
- #end
- #end
- //region date query
- #foreach($ele in $fields)
- #if($ele.dataType=="date")
- @QF(op=OP.GTE,tf="${ele.columnName}")
- private Date ${ele.columnName}Start ;
- @QF(op=OP.LTE,tf="${ele.columnName}")
- private Date ${ele.columnName}End ;
- #end
- #if($ele.dataType=="datetime")
- @QF(op=OP.GTE,tf="${ele.columnName}")
- private Date ${ele.columnName}Start;
- @QF(op=OP.LTE,tf="${ele.columnName}")
- private Date ${ele.columnName}End ;
- #end
- #if($ele.dataType=="timestamp")
- @QF(op=OP.GTE,tf="${ele.columnName}")
- private Date ${ele.columnName}Start ;
- @QF(op=OP.LTE,tf="${ele.columnName}")
- private Date ${ele.columnName}End ;
- #end
- #end
- //endregion
- //region sort query
- #foreach($ele in $fields)
- #if($ele.dataType=="int"||$ele.dataType=="bigint"||$ele.dataType=="tinyint"||$ele.dataType=="datetime"||$ele.dataType=="timestamp")
- private Integer ${ele.columnName}Sort ;
- #end
- #end
- //endregion
- }
- }
|