Java实体类：
public class GoodsBase {
private String code;
private String barcode;
private String name;
private String engName;
private String specification;
private String gbisdj;
private String gbmanamode;
private int accountMeth;
private Date transferDate;
private String unit;
private String textureContent;
private String classification;
private String brandid;
private String designColor;
private String pluCode;
private String qualityLevel;
private String saleshop;
private String artNo;
private int dayExp;
private double saleVatRate;
private double purPRate;
private double purP;
private double gbmaxsj;
private double minPrice;
private double inputVatRate;
private String regionCode;
private String inputPern;
private Date inputDate;
private String updatePern;
private Date updateDate;
private String dutyType;
private String subcategoryCode;
private String ncccode;
private String market;
private int capacity;
private int suitNum;
private double weight;
private String markUse;
private String hsCode;
private String gbarcode;
private String gbimmedcatid;
// getter and setter methods
}
Mybatis查询语句及结果映射：