springboot+mybatis搭建迷你小程序（一）

表设计与实体类创建

CREATE TABLE tb_area (

area_id int(2) NOT NULL auto_increment,   // NOT NULL  为空的话有默认值

area_name varchar(200) NOT NULL,

priority int(2) NOT NULL DEFAULT'0',

create_time datetime DEFAULT NULL,

last_edit_time datetime DEFAULT NULL,

PRIMARY KEY(area_id),

UNIQUE KEY UK_AREA(area_name)

)ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;


package com.ydcoding.bootshop.entity;

import java.util.Date;

public class Area {
    //主键ID
    private  Integer areaId;
    //名称
    private  String areaNmae;
    //权重，数值越大越靠前
    private  int priority;
    //创建时间
    private Date createTime;
    //更新时间
    private Date lastEditTime;   //alt+enter  快捷键提示  ctrl+n getter ann setter 方法创建

    public Integer getAreaId() {
        return areaId;
    }

    public void setAreaId(Integer areaId) {
        this.areaId = areaId;
    }

    public String getAreaNmae() {
        return areaNmae;
    }

    public void setAreaNmae(String areaNmae) {
        this.areaNmae = areaNmae;
    }

    public int getPriority() {
        return priority;
    }

    public void setPriority(int priority) {
        this.priority = priority;
    }

    public Date getCreateTime() {
        return createTime;
    }

    public void setCreateTime(Date createTime) {
        this.createTime = createTime;
    }

    public Date getLastEditTime() {
        return lastEditTime;
    }

    public void setLastEditTime(Date lastEditTime) {
        this.lastEditTime = lastEditTime;
    }
}