使用下列SQL生成Java实体类注解方式加上注释：select from select AGBID CODEGBBARCODE BARCODEGBCNAME NAME GBENAME ENG_NAMEGBSPEC SPECIFICATION GBISDJGBMANAMODE case GBWMID when 1 then 0 when 5 then 5 when 4 then 3 else 1

@Entity @Table(name = "goodsbase") public class GoodsBase {

@Id
@Column(name = "CODE")
private String code; // 商品编码

@Column(name = "BARCODE")
private String barcode; // 商品条形码

@Column(name = "NAME")
private String name; // 商品名称

@Column(name = "ENG_NAME")
private String engName; // 商品英文名称

@Column(name = "SPECIFICATION")
private String specification; // 商品规格

@Column(name = "GBISDJ")
private String gbisdj; // 是否定价

@Column(name = "GBMANAMODE")
private String gbmanamode; // 管理方式

@Column(name = "ACCOUNT_METH")
private Integer accountMeth; // 计价方式

@Column(name = "TRANSFER_DATE")
private Date transferDate; // 调价日期

@Column(name = "UNIT")
private String unit; // 商品单位

@Column(name = "TEXTURE_CONTENT")
private String textureContent; // 商品成份

@Column(name = "CLASSIFICATION")
private String classification; // 商品分类

@Column(name = "BRANDID")
private String brandId; // 商品品牌

@Column(name = "DESIGN_COLOR")
private String designColor; // 商品设计颜色

@Column(name = "PLU_CODE")
private String pluCode; // 商品PLU码

@Column(name = "QUALITY_LEVEL")
private String qualityLevel; // 商品质量等级

@Column(name = "SALESHOP")
private String saleshop; // 商品销售店铺

@Column(name = "ART_NO")
private String artNo; // 商品货号

@Column(name = "DAY_EXP")
private String dayExp; // 商品保质期

@Column(name = "SALE_VAT_RATE")
private Double saleVatRate; // 销售增值税率

@Column(name = "PUR_P_RATE")
private Double purpRate; // 采购价率

@Column(name = "PUR_P")
private Double purp; // 采购价

@Column(name = "GBMAXSJ")
private Double gbmaxsj; // 商品最高售价

@Column(name = "MIN_PRICE")
private Double minPrice; // 商品最低售价

@Column(name = "INPUT_VAT_RATE")
private Double inputVatRate; // 进项税率

@Column(name = "REGION_CODE")
private String regionCode; // 区域编码

@Column(name = "INPUT_PERN")
private String inputPern; // 录入人员

@Column(name = "INPUT_DATE")
private Date inputDate; // 录入日期

@Column(name = "UPDATE_PERN")
private String updatePern; // 修改人员

@Column(name = "UPDATE_DATE")
private Date updateDate; // 修改日期

@Column(name = "DUTY_TYPE")
private String dutyType; // 关税类型

@Column(name = "SUBCATEGORY_CODE")
private String subcategoryCode; // 商品子分类编码

@Column(name = "NCCCODE")
private String nccCode; // NCC编码

@Column(name = "MARKET")
private String market; // 市场

@Column(name = "CAPACITY")
private Integer capacity; // 容量

@Column(name = "SUIT_NUM")
private Integer suitNum; // 适用人数

@Column(name = "WEIGHT")
private Double weight; // 商品重量

@Column(name = "MARK_USE")
private String markUse; // 商品用途

@Column(name = "HS_CODE")
private String hsCode; // 商品海关编码

@Column(name = "GBARCODE")
private String gbarcode; // 商品DIY条形码

@Column(name = "GBIMMEDCATID")
private String gbimmedcatid; // 商品类别ID

// getters and setters