目录
一、设计数据库表
要在产品里查询分类名称,实现多表分页查询。
有产品表和分类表,产品表里面有一个cid,是classify的外键
二、实体类
分类表:
@Data
@ApiModel(description = "分类表")
@TableName("classify")
public class Classify extends BaseEntity {
private static final long serialVersionUID = 1L;
@ApiModelProperty(value = "分类名称")
@TableField("classify_name")
private String classifyName;
}
产品表:
@Data
@ApiModel(description = "产品表")
@TableName("product")
public class Product extends BaseEntity {
private static final long serialVersionUID = 1L;
@ApiModelProperty(value = "产品名称")
@TableField("product_name")
private String productName;
@ApiModelProperty(value = "单位规格")
@TableField("unit")
private String unit;
@ApiModelProperty(value = "产品单价")
@TableField("unit_price")
private float unitPrice;
@ApiModelProperty(value = "个数")
@TableField("nums")
private float nums;