使用SQL语句生成Java实体类并添加Data注解和注释

@Data public class GoodsBase { /** * 商品编码 / private String code; /* * 商品条码 / private String barcode; /* * 商品名称 / private String name; /* * 商品英文名称 / private String engName; /* * 商品规格 / private String specification; /* * 是否单价 / private String isdj; /* * 管理方式 / private String manaMode; /* * 计算方式 / private int accountMeth; /* * 转移日期 / private Date transferDate; /* * 商品单位 / private String unit; /* * 材质成分 / private String textureContent; /* * 商品分类码 / private String classification; /* * 商品品牌ID / private String brandId; /* * 设计颜色 / private String designColor; /* * 商品PLU码 / private String pluCode; /* * 商品质量等级 / private String qualityLevel; /* * 销售店铺 / private String saleShop; /* * 艺术号 / private String artNo; /* * 保质期天数 / private String dayExp; /* * 销售增值税率 / private double saleVatRate; /* * 进项增值税率 / private double inputVatRate; /* * 商品进货价格 / private double purP; /* * 商品最高售价 / private double maxSj; /* * 商品最低售价 / private double minPrice; /* * 区域编码 / private String regionCode; /* * 录入人员 / private String inputPern; /* * 录入日期 / private Date inputDate; /* * 更新人员 / private String updatePern; /* * 更新日期 / private Date updateDate; /* * 税费类型 / private String dutyType; /* * 商品子分类码 / private String subcategoryCode; /* * NCC编码 / private String nccCode; /* * 销售渠道 / private String market; /* * 容量 / private double capacity; /* * 适用人数 / private int suitNum; /* * 商品重量 / private double weight; /* * 市场用途 / private String markUse; /* * HS编码 / private String hsCode; /* * DIY条码 / private String gbarcode; /* * 立即类别ID */ private String immcdatid; }

select * from(
 select A.GBID CODE,GBBARCODE BARCODE,GBCNAME NAME, GBENAME ENG_NAME,GBSPEC SPECIFICATION, GBISDJ,GBMANAMODE,
 case GBWMID when '1' then 0 when '5' then 5 when '4' then 3 else 1 end account_meth, D.TRANSFER_DATE, GBUNIT UNIT,GBBZHL TEXTURE_CONTENT,GBCATCODE CLASSIFICATION,GBPPCODE BRANDID,GBSPHS DESIGN_COLOR,
 GBSPKS PLU_CODE,GBSPDJ QUALITY_LEVEL,GBSPXT SALESHOP,GBCSHH ART_NO,GBBZYJTS DAY_EXP, NVL(GBJXTAX,0) SALE_VAT_RATE, GBNEWHSJJ pur_p_rate,round(NVL(GBLASTJJ,GBNEWHSJJ/(1+NVL(GBJXTAX,0))),4) pur_p,GBMAXSJ ,GBMINSJ min_price,NVL(GBJXTAX,0) INPUT_VAT_RATE,GBCDCODE REGION_CODE,
 GBINPUTOR INPUT_PERN, GBINPUTDATE INPUT_DATE,GBXGR UPDATE_PERN,GBXGDATE UPDATE_DATE,GBFLAG3 DUTY_TYPE, GBSTR4 SUBCATEGORY_CODE,GBSTR5 NCCCODE,MARKET,NVL(GBNUM10,0) CAPACITY,NVL(GBNUM8,1) SUIT_NUM,GBWEIGHT WEIGHT,GBSTR14 MARK_USE,GBSTR6 HS_CODE,A.GBGBDIYBARCODE GBARCODE,A.GBIMMEDCATID
 from DBUSRPUB.goodsbase A,DBUSRNPOS.GOODS_TRANSFER D
 where A.GBSTATUS='Y' and D.GBID=A.GBID
 union
 select GBID CODE,GBBARCODE BARCODE,GBCNAME NAME, GBENAME ENG_NAME,GBSPEC SPECIFICATION, GBISDJ,GBMANAMODE,
 case GBWMID when '1' then 0 when '5' then 5 when '4' then 3 else 1 end account_meth, sysdate TRANSFER_DATE , GBUNIT UNIT,GBBZHL TEXTURE_CONTENT,GBCATCODE CLASSIFICATION,GBPPCODE BRANDID,GBSPHS DESIGN_COLOR,
 GBSPKS PLU_CODE,GBSPDJ QUALITY_LEVEL,GBSPXT SALESHOP,GBCSHH ART_NO,GBBZYJTS DAY_EXP, NVL(GBJXTAX,0) SALE_VAT_RATE, GBNEWHSJJ pur_p_rate,round(NVL(GBLASTJJ,GBNEWHSJJ/(1+NVL(GBJXTAX,0))),4) pur_p,GBMAXSJ ,GBMINSJ min_price,NVL(GBJXTAX,0) INPUT_VAT_RATE,GBCDCODE REGION_CODE,
 GBINPUTOR INPUT_PERN, GBINPUTDATE INPUT_DATE,GBXGR UPDATE_PERN,GBXGDATE UPDATE_DATE,GBFLAG3 DUTY_TYPE, GBSTR4 SUBCATEGORY_CODE,GBSTR5 NCCCODE,MARKET,NVL(GBNUM10,0) CAPACITY,NVL(GBNUM8,1) SUIT_NUM,GBWEIGHT WEIGHT,GBSTR14 MARK_USE,GBSTR6 HS_CODE,A.GBGBDIYBARCODE GBARCODE,A.GBIMMEDCATID
 from DBUSRPUB.goodsbase A
 where A.GBSTATUS='Y' and exists(select 1 from DBUSRPUB.goodsmframe B where A.GBID=B.GMFGDID and B.GMFMARKET in({CHANL_CODE})) and not exists(select 1 from DBUSRNPOS.GOODSTRANSFER C where C.GBID=A.GBID)
)
where ROWNUM<={TerDetail[1]} order by TRANSFER_DATE