feat: 更改数据库设计

cy

2023-10-24 27c29767c6426b60866a49b8be0f88744dbeef6f

feat: 更改数据库设计

 consum-base/doc/ÏîÄ¿×ÊÁÏ/ºÓÄÏÓÊÕþµÍÖµÒ׺ÄÆ·V20231023.pdm

Diff too large

 consum-model-pojo/src/main/java/com/consum/model/po/LGoodsUserRecord.java

New file
@@ -0,0 +1,260 @@

package com.consum.model.po;

import com.fasterxml.jackson.annotation.JsonAutoDetect;
import com.fasterxml.jackson.annotation.JsonIgnore;
import com.walker.jdbc.BasePo;

/**
 * è¡¨å:L_GOODS_USER_RECORD *
 * @author genrator
 */
@JsonAutoDetect(fieldVisibility = JsonAutoDetect.Visibility.ANY)
public class LGoodsUserRecord extends BasePo<LGoodsUserRecord> {
    // åºåˆ—化版本号
    private static final long serialVersionUID = 1L;

    // ä¸»é”®
    private Long id = null;
    @JsonIgnore
    protected boolean isset_id = false;

    // å±žæ€§åˆ—表
    private Long goodsUserPhone = null;
    @JsonIgnore
    protected boolean isset_goodsUserPhone = false;

    private Integer recordType = null;
    @JsonIgnore
    protected boolean isset_recordType = false;

    private Long lastRecordId = null;
    @JsonIgnore
    protected boolean isset_lastRecordId = false;

    private Long nowUserPhone = null;
    @JsonIgnore
    protected boolean isset_nowUserPhone = false;

    private String nowUserName = null;
    @JsonIgnore
    protected boolean isset_nowUserName = false;

    private Long operatorId = null;
    @JsonIgnore
    protected boolean isset_operatorId = false;

    private String operatorName = null;
    @JsonIgnore
    protected boolean isset_operatorName = false;

    private Long dealTime = null;
    @JsonIgnore
    protected boolean isset_dealTime = false;

    /**
     * é»˜è®¤æž„造函数
     */
    public LGoodsUserRecord() {
    }

    /**
     * æ ¹æ®ä¸»é”®æž„造对象
     */
    public LGoodsUserRecord(Long id) {
        this.setId(id);
    }

    /**
     * è®¾ç½®ä¸»é”®å€¼
     */
    @Override
    public void setPkValue(Object value) {
        this.setId((Long) value);
    }

    public Long getId() {
        return this.id;
    }

    public void setId(Long id) {
        this.id = id;
        this.isset_id = true;
    }

    @JsonIgnore
    public boolean isEmptyId() {
        return this.id == null;
    }

    public Long getGoodsUserPhone() {
        return this.goodsUserPhone;
    }

    public void setGoodsUserPhone(Long goodsUserPhone) {
        this.goodsUserPhone = goodsUserPhone;
        this.isset_goodsUserPhone = true;
    }

    @JsonIgnore
    public boolean isEmptyGoodsUserPhone() {
        return this.goodsUserPhone == null;
    }

    public Integer getRecordType() {
        return this.recordType;
    }

    public void setRecordType(Integer recordType) {
        this.recordType = recordType;
        this.isset_recordType = true;
    }

    @JsonIgnore
    public boolean isEmptyRecordType() {
        return this.recordType == null;
    }

    public Long getLastRecordId() {
        return this.lastRecordId;
    }

    public void setLastRecordId(Long lastRecordId) {
        this.lastRecordId = lastRecordId;
        this.isset_lastRecordId = true;
    }

    @JsonIgnore
    public boolean isEmptyLastRecordId() {
        return this.lastRecordId == null;
    }

    public Long getNowUserPhone() {
        return this.nowUserPhone;
    }

    public void setNowUserPhone(Long nowUserPhone) {
        this.nowUserPhone = nowUserPhone;
        this.isset_nowUserPhone = true;
    }

    @JsonIgnore
    public boolean isEmptyNowUserPhone() {
        return this.nowUserPhone == null;
    }

    public String getNowUserName() {
        return this.nowUserName;
    }

    public void setNowUserName(String nowUserName) {
        this.nowUserName = nowUserName;
        this.isset_nowUserName = true;
    }

    @JsonIgnore
    public boolean isEmptyNowUserName() {
        return this.nowUserName == null || this.nowUserName.length() == 0;
    }

    public Long getOperatorId() {
        return this.operatorId;
    }

    public void setOperatorId(Long operatorId) {
        this.operatorId = operatorId;
        this.isset_operatorId = true;
    }

    @JsonIgnore
    public boolean isEmptyOperatorId() {
        return this.operatorId == null;
    }

    public String getOperatorName() {
        return this.operatorName;
    }

    public void setOperatorName(String operatorName) {
        this.operatorName = operatorName;
        this.isset_operatorName = true;
    }

    @JsonIgnore
    public boolean isEmptyOperatorName() {
        return this.operatorName == null || this.operatorName.length() == 0;
    }

    public Long getDealTime() {
        return this.dealTime;
    }

    public void setDealTime(Long dealTime) {
        this.dealTime = dealTime;
        this.isset_dealTime = true;
    }

    @JsonIgnore
    public boolean isEmptyDealTime() {
        return this.dealTime == null;
    }

    /**
     * é‡å†™ toString() æ–¹æ³•
     */
    @Override
    public String toString() {
        return new StringBuilder()
                .append("id=").append(this.id)
                .append("goodsUserPhone=").append(this.goodsUserPhone)
                .append("recordType=").append(this.recordType)
                .append("lastRecordId=").append(this.lastRecordId)
                .append("nowUserPhone=").append(this.nowUserPhone)
                .append("nowUserName=").append(this.nowUserName)
                .append("operatorId=").append(this.operatorId)
                .append("operatorName=").append(this.operatorName)
                .append("dealTime=").append(this.dealTime)
                .toString();
    }

    /**
     * å…‹éš†
     */
    public LGoodsUserRecord $clone() {
        LGoodsUserRecord l_goods_user_record = new LGoodsUserRecord();

        // æ•°æ®åº“名称
        //l_goods_user_record.setDatabaseName_(this.getDatabaseName_());

        // ä¸»é”®
        if (this.isset_id) {
            l_goods_user_record.setId(this.getId());
        }
        // æ™®é€šå±žæ€§
        if (this.isset_goodsUserPhone) {
            l_goods_user_record.setGoodsUserPhone(this.getGoodsUserPhone());
        }
        if (this.isset_recordType) {
            l_goods_user_record.setRecordType(this.getRecordType());
        }
        if (this.isset_lastRecordId) {
            l_goods_user_record.setLastRecordId(this.getLastRecordId());
        }
        if (this.isset_nowUserPhone) {
            l_goods_user_record.setNowUserPhone(this.getNowUserPhone());
        }
        if (this.isset_nowUserName) {
            l_goods_user_record.setNowUserName(this.getNowUserName());
        }
        if (this.isset_operatorId) {
            l_goods_user_record.setOperatorId(this.getOperatorId());
        }
        if (this.isset_operatorName) {
            l_goods_user_record.setOperatorName(this.getOperatorName());
        }
        if (this.isset_dealTime) {
            l_goods_user_record.setDealTime(this.getDealTime());
        }
        return l_goods_user_record;
    }
}

 consum-model-pojo/src/main/java/com/consum/model/po/LGoodsUserRecord_mapper.java

New file
@@ -0,0 +1,329 @@
package com.consum.model.po;

import com.walker.jdbc.BaseMapper;
import com.walker.jdbc.ResultSetUtils;
import com.walker.jdbc.SqlAndParameters;
import com.walker.jdbc.sqlgen.DeleteBuilder;
import com.walker.jdbc.sqlgen.InsertBuilder;
import com.walker.jdbc.sqlgen.SelectBuilder;
import com.walker.jdbc.sqlgen.UpdateBuilder;
import com.walker.jdbc.util.StringUtils;

import org.springframework.jdbc.core.RowMapper;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Map;

/**
 * è¡¨å:L_GOODS_USER_RECORD *
 * @author genrator
 */
public class LGoodsUserRecord_mapper extends LGoodsUserRecord implements BaseMapper<LGoodsUserRecord> {
    // åºåˆ—化版本号
    private static final long serialVersionUID = 1L;

    public static final RowMapper<LGoodsUserRecord> ROW_MAPPER = new LGoodsUserRecordRowMapper();

    // ä¸»é”®
    public static final String Id = "id";
    // æ™®é€šå±žæ€§
    public static final String GoodsUserPhone = "goods_user_phone";
    public static final String RecordType = "record_type";
    public static final String LastRecordId = "last_record_id";
    public static final String NowUserPhone = "now_user_phone";
    public static final String NowUserName = "now_user_name";
    public static final String OperatorId = "operator_id";
    public static final String OperatorName = "operator_name";
    public static final String DealTime = "deal_time";

    /**
     * é»˜è®¤æž„造函数
     */
    public LGoodsUserRecord_mapper(LGoodsUserRecord lGoodsUserRecord) {
        if (lGoodsUserRecord == null) {
            throw new IllegalArgumentException("po参数不允许为空！");
        }
        //主键
        if (lGoodsUserRecord.isset_id) {
            this.setId(lGoodsUserRecord.getId());
        }
        //普通属性
        if (lGoodsUserRecord.isset_goodsUserPhone) {
            this.setGoodsUserPhone(lGoodsUserRecord.getGoodsUserPhone());
        }
        if (lGoodsUserRecord.isset_recordType) {
            this.setRecordType(lGoodsUserRecord.getRecordType());
        }
        if (lGoodsUserRecord.isset_lastRecordId) {
            this.setLastRecordId(lGoodsUserRecord.getLastRecordId());
        }
        if (lGoodsUserRecord.isset_nowUserPhone) {
            this.setNowUserPhone(lGoodsUserRecord.getNowUserPhone());
        }
        if (lGoodsUserRecord.isset_nowUserName) {
            this.setNowUserName(lGoodsUserRecord.getNowUserName());
        }
        if (lGoodsUserRecord.isset_operatorId) {
            this.setOperatorId(lGoodsUserRecord.getOperatorId());
        }
        if (lGoodsUserRecord.isset_operatorName) {
            this.setOperatorName(lGoodsUserRecord.getOperatorName());
        }
        if (lGoodsUserRecord.isset_dealTime) {
            this.setDealTime(lGoodsUserRecord.getDealTime());
        }
        // åŽ»æŽ‰ï¼Œ2022-09-07
        // this.setDatabaseName_(l_goods_user_record.getDatabaseName_());
    }

    /**
     * èŽ·å–表名
     */
    @Override
    public String getTableName_() {
        String tableName = "l_goods_user_record";
        /**
        if (StringUtils.isNotEmpty(this.getDatabaseName_())) {
            return this.getDatabaseName_() + "." + tableName;
        } else {
            return tableName;
        }
        */
        return tableName;
    }

    /**
     * èŽ·å–主键名称
     */
    @Override
    public String getPkName_() {
        return Id;
    }

    /**
     * èŽ·å–主键值
     */
    @Override
    public Object getPkValue_() {
        return this.getId();
    }

    /**
     * èŽ·å–插入语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getInsertSql_() {
        InsertBuilder ib = new InsertBuilder(this.getTableName_());
        ib.set(Id, this.getId());
        ib.set(GoodsUserPhone, this.getGoodsUserPhone(), this.isset_goodsUserPhone);
        ib.set(RecordType, this.getRecordType(), this.isset_recordType);
        ib.set(LastRecordId, this.getLastRecordId(), this.isset_lastRecordId);
        ib.set(NowUserPhone, this.getNowUserPhone(), this.isset_nowUserPhone);
        ib.set(NowUserName, this.getNowUserName(), this.isset_nowUserName);
        ib.set(OperatorId, this.getOperatorId(), this.isset_operatorId);
        ib.set(OperatorName, this.getOperatorName(), this.isset_operatorName);
        ib.set(DealTime, this.getDealTime(), this.isset_dealTime);
        return ib.genMapSql();
    }

    /**
     * èŽ·å–更新语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getUpdateSql_() {
        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
        ub.set(GoodsUserPhone, this.getGoodsUserPhone(), this.isset_goodsUserPhone);
        ub.set(RecordType, this.getRecordType(), this.isset_recordType);
        ub.set(LastRecordId, this.getLastRecordId(), this.isset_lastRecordId);
        ub.set(NowUserPhone, this.getNowUserPhone(), this.isset_nowUserPhone);
        ub.set(NowUserName, this.getNowUserName(), this.isset_nowUserName);
        ub.set(OperatorId, this.getOperatorId(), this.isset_operatorId);
        ub.set(OperatorName, this.getOperatorName(), this.isset_operatorName);
        ub.set(DealTime, this.getDealTime(), this.isset_dealTime);
        ub.where(this.getPkName_(), this.getPkValue_());
        return ub.genMapSql();
    }

    /**
     * èŽ·å–更新语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getUpdateSql_(String where, Map<String, Object> parameters) {
        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
        ub.set(GoodsUserPhone, this.getGoodsUserPhone(), this.isset_goodsUserPhone);
        ub.set(RecordType, this.getRecordType(), this.isset_recordType);
        ub.set(LastRecordId, this.getLastRecordId(), this.isset_lastRecordId);
        ub.set(NowUserPhone, this.getNowUserPhone(), this.isset_nowUserPhone);
        ub.set(NowUserName, this.getNowUserName(), this.isset_nowUserName);
        ub.set(OperatorId, this.getOperatorId(), this.isset_operatorId);
        ub.set(OperatorName, this.getOperatorName(), this.isset_operatorName);
        ub.set(DealTime, this.getDealTime(), this.isset_dealTime);
        return ub.genMapSql(where, parameters);
    }

    /**
     * èŽ·å–更新语句和参数
     */
    @Override
    public SqlAndParameters<Object[]> getUpdateSql_(String where, Object[] parameters) {
        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
        ub.set(GoodsUserPhone, this.getGoodsUserPhone(), this.isset_goodsUserPhone);
        ub.set(RecordType, this.getRecordType(), this.isset_recordType);
        ub.set(LastRecordId, this.getLastRecordId(), this.isset_lastRecordId);
        ub.set(NowUserPhone, this.getNowUserPhone(), this.isset_nowUserPhone);
        ub.set(NowUserName, this.getNowUserName(), this.isset_nowUserName);
        ub.set(OperatorId, this.getOperatorId(), this.isset_operatorId);
        ub.set(OperatorName, this.getOperatorName(), this.isset_operatorName);
        ub.set(DealTime, this.getDealTime(), this.isset_dealTime);
        return ub.genArraySql(where, parameters);
    }

    /**
     * èŽ·å–删除语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getDeleteSql_() {
        DeleteBuilder db = new DeleteBuilder(this.getTableName_());
        db.where(this.getPkName_(), this.getPkValue_());
        return db.genMapSql();
    }

    /**
     * èŽ·å–删除语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getDeleteSql_(String where, Map<String, Object> parameters) {
        DeleteBuilder db = new DeleteBuilder(this.getTableName_());
        return db.genMapSql(where, parameters);
    }

    /**
     * èŽ·å–删除语句和参数
     */
    @Override
    public SqlAndParameters<Object[]> getDeleteSql_(String where, Object[] parameters) {
        DeleteBuilder db = new DeleteBuilder(this.getTableName_());
        return db.genArraySql(where, parameters);
    }

    /**
     * èŽ·å–单行查询语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getSingleSql_() {
        SelectBuilder sb = new SelectBuilder(this.getTableName_());
        sb.where(this.getPkName_(), this.getPkValue_());
        return sb.genMapSql();
    }


    /**
     * èŽ·å–查询语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) {
        return new SqlAndParameters<>("select id, goods_user_phone, record_type, last_record_id, now_user_phone, now_user_name, operator_id, operator_name, deal_time from " + this.getTableName_() + " " + where, parameters);
    }

    /**
     * èŽ·å–查询语句和参数
     */
    @Override
    public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) {
        return new SqlAndParameters<>("select id, goods_user_phone, record_type, last_record_id, now_user_phone, now_user_name, operator_id, operator_name, deal_time from " + this.getTableName_() + " " + where, parameters);
    }

    /**
     * å°†resultset的一行转化为po
     */
    @Override
    public LGoodsUserRecord mapRow(ResultSet rs, int i) throws SQLException {
        return ROW_MAPPER.mapRow(rs, i);
    }

    /**
     * å…‹éš†
     */
    public LGoodsUserRecord toLGoodsUserRecord() {
        return super.$clone();
    }
}

/**
 * l_goods_user_record RowMapper
 *
 * @author genrator
 */
class LGoodsUserRecordRowMapper implements RowMapper<LGoodsUserRecord> {

    @Override
    public LGoodsUserRecord mapRow(ResultSet rs, int i) throws SQLException {
        ResultSetUtils resultSetUtils = new ResultSetUtils();
        LGoodsUserRecord l_goods_user_record = new LGoodsUserRecord();
        Integer columnIndex;
        //主键
        columnIndex = resultSetUtils.findColumn(rs, LGoodsUserRecord_mapper.Id);
        if (columnIndex > 0) {
            l_goods_user_record.setId(rs.getLong(columnIndex));
        }
        //普通属性
        columnIndex = resultSetUtils.findColumn(rs, LGoodsUserRecord_mapper.GoodsUserPhone);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_goods_user_record.setGoodsUserPhone(null);
            } else {
                l_goods_user_record.setGoodsUserPhone(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LGoodsUserRecord_mapper.RecordType);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_goods_user_record.setRecordType(null);
            } else {
                l_goods_user_record.setRecordType(rs.getInt(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LGoodsUserRecord_mapper.LastRecordId);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_goods_user_record.setLastRecordId(null);
            } else {
                l_goods_user_record.setLastRecordId(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LGoodsUserRecord_mapper.NowUserPhone);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_goods_user_record.setNowUserPhone(null);
            } else {
                l_goods_user_record.setNowUserPhone(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LGoodsUserRecord_mapper.NowUserName);
        if (columnIndex > 0) {
            l_goods_user_record.setNowUserName(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, LGoodsUserRecord_mapper.OperatorId);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_goods_user_record.setOperatorId(null);
            } else {
                l_goods_user_record.setOperatorId(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LGoodsUserRecord_mapper.OperatorName);
        if (columnIndex > 0) {
            l_goods_user_record.setOperatorName(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, LGoodsUserRecord_mapper.DealTime);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_goods_user_record.setDealTime(null);
            } else {
                l_goods_user_record.setDealTime(rs.getLong(columnIndex));
            }
        }
        return l_goods_user_record;
    }
}

 consum-model-pojo/src/main/java/com/consum/model/po/LGoodsWhRecord.java

New file
@@ -0,0 +1,194 @@

package com.consum.model.po;

import com.fasterxml.jackson.annotation.JsonAutoDetect;
import com.fasterxml.jackson.annotation.JsonIgnore;
import com.walker.jdbc.BasePo;

/**
 * è¡¨å:L_GOODS_WH_RECORD *
 * @author genrator
 */
@JsonAutoDetect(fieldVisibility = JsonAutoDetect.Visibility.ANY)
public class LGoodsWhRecord extends BasePo<LGoodsWhRecord> {
    // åºåˆ—化版本号
    private static final long serialVersionUID = 1L;

    // ä¸»é”®
    private Long id = null;
    @JsonIgnore
    protected boolean isset_id = false;

    // å±žæ€§åˆ—表
    private Long lWarehouseFlowId = null;
    @JsonIgnore
    protected boolean isset_lWarehouseFlowId = false;

    private Long lWhGoodsId = null;
    @JsonIgnore
    protected boolean isset_lWhGoodsId = false;

    private Long warehouseId = null;
    @JsonIgnore
    protected boolean isset_warehouseId = false;

    private Integer parentId = null;
    @JsonIgnore
    protected boolean isset_parentId = false;

    private Long dealTime = null;
    @JsonIgnore
    protected boolean isset_dealTime = false;

    /**
     * é»˜è®¤æž„造函数
     */
    public LGoodsWhRecord() {
    }

    /**
     * æ ¹æ®ä¸»é”®æž„造对象
     */
    public LGoodsWhRecord(Long id) {
        this.setId(id);
    }

    /**
     * è®¾ç½®ä¸»é”®å€¼
     */
    @Override
    public void setPkValue(Object value) {
        this.setId((Long) value);
    }

    public Long getId() {
        return this.id;
    }

    public void setId(Long id) {
        this.id = id;
        this.isset_id = true;
    }

    @JsonIgnore
    public boolean isEmptyId() {
        return this.id == null;
    }

    public Long getLWarehouseFlowId() {
        return this.lWarehouseFlowId;
    }

    public void setLWarehouseFlowId(Long lWarehouseFlowId) {
        this.lWarehouseFlowId = lWarehouseFlowId;
        this.isset_lWarehouseFlowId = true;
    }

    @JsonIgnore
    public boolean isEmptyLWarehouseFlowId() {
        return this.lWarehouseFlowId == null;
    }

    public Long getLWhGoodsId() {
        return this.lWhGoodsId;
    }

    public void setLWhGoodsId(Long lWhGoodsId) {
        this.lWhGoodsId = lWhGoodsId;
        this.isset_lWhGoodsId = true;
    }

    @JsonIgnore
    public boolean isEmptyLWhGoodsId() {
        return this.lWhGoodsId == null;
    }

    public Long getWarehouseId() {
        return this.warehouseId;
    }

    public void setWarehouseId(Long warehouseId) {
        this.warehouseId = warehouseId;
        this.isset_warehouseId = true;
    }

    @JsonIgnore
    public boolean isEmptyWarehouseId() {
        return this.warehouseId == null;
    }

    public Integer getParentId() {
        return this.parentId;
    }

    public void setParentId(Integer parentId) {
        this.parentId = parentId;
        this.isset_parentId = true;
    }

    @JsonIgnore
    public boolean isEmptyParentId() {
        return this.parentId == null;
    }

    public Long getDealTime() {
        return this.dealTime;
    }

    public void setDealTime(Long dealTime) {
        this.dealTime = dealTime;
        this.isset_dealTime = true;
    }

    @JsonIgnore
    public boolean isEmptyDealTime() {
        return this.dealTime == null;
    }

    /**
     * é‡å†™ toString() æ–¹æ³•
     */
    @Override
    public String toString() {
        return new StringBuilder()
                .append("id=").append(this.id)
                .append("lWarehouseFlowId=").append(this.lWarehouseFlowId)
                .append("lWhGoodsId=").append(this.lWhGoodsId)
                .append("warehouseId=").append(this.warehouseId)
                .append("parentId=").append(this.parentId)
                .append("dealTime=").append(this.dealTime)
                .toString();
    }

    /**
     * å…‹éš†
     */
    public LGoodsWhRecord $clone() {
        LGoodsWhRecord l_goods_wh_record = new LGoodsWhRecord();

        // æ•°æ®åº“名称
        //l_goods_wh_record.setDatabaseName_(this.getDatabaseName_());

        // ä¸»é”®
        if (this.isset_id) {
            l_goods_wh_record.setId(this.getId());
        }
        // æ™®é€šå±žæ€§
        if (this.isset_lWarehouseFlowId) {
            l_goods_wh_record.setLWarehouseFlowId(this.getLWarehouseFlowId());
        }
        if (this.isset_lWhGoodsId) {
            l_goods_wh_record.setLWhGoodsId(this.getLWhGoodsId());
        }
        if (this.isset_warehouseId) {
            l_goods_wh_record.setWarehouseId(this.getWarehouseId());
        }
        if (this.isset_parentId) {
            l_goods_wh_record.setParentId(this.getParentId());
        }
        if (this.isset_dealTime) {
            l_goods_wh_record.setDealTime(this.getDealTime());
        }
        return l_goods_wh_record;
    }
}

 consum-model-pojo/src/main/java/com/consum/model/po/LGoodsWhRecord_mapper.java

New file
@@ -0,0 +1,289 @@
package com.consum.model.po;

import com.walker.jdbc.BaseMapper;
import com.walker.jdbc.ResultSetUtils;
import com.walker.jdbc.SqlAndParameters;
import com.walker.jdbc.sqlgen.DeleteBuilder;
import com.walker.jdbc.sqlgen.InsertBuilder;
import com.walker.jdbc.sqlgen.SelectBuilder;
import com.walker.jdbc.sqlgen.UpdateBuilder;
import com.walker.jdbc.util.StringUtils;

import org.springframework.jdbc.core.RowMapper;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Map;

/**
 * è¡¨å:L_GOODS_WH_RECORD *
 * @author genrator
 */
public class LGoodsWhRecord_mapper extends LGoodsWhRecord implements BaseMapper<LGoodsWhRecord> {
    // åºåˆ—化版本号
    private static final long serialVersionUID = 1L;

    public static final RowMapper<LGoodsWhRecord> ROW_MAPPER = new LGoodsWhRecordRowMapper();

    // ä¸»é”®
    public static final String Id = "id";
    // æ™®é€šå±žæ€§
    public static final String LWarehouseFlowId = "l_warehouse_flow_id";
    public static final String LWhGoodsId = "l_wh_goods_id";
    public static final String WarehouseId = "warehouse_id";
    public static final String ParentId = "parent_id";
    public static final String DealTime = "deal_time";

    /**
     * é»˜è®¤æž„造函数
     */
    public LGoodsWhRecord_mapper(LGoodsWhRecord lGoodsWhRecord) {
        if (lGoodsWhRecord == null) {
            throw new IllegalArgumentException("po参数不允许为空！");
        }
        //主键
        if (lGoodsWhRecord.isset_id) {
            this.setId(lGoodsWhRecord.getId());
        }
        //普通属性
        if (lGoodsWhRecord.isset_lWarehouseFlowId) {
            this.setLWarehouseFlowId(lGoodsWhRecord.getLWarehouseFlowId());
        }
        if (lGoodsWhRecord.isset_lWhGoodsId) {
            this.setLWhGoodsId(lGoodsWhRecord.getLWhGoodsId());
        }
        if (lGoodsWhRecord.isset_warehouseId) {
            this.setWarehouseId(lGoodsWhRecord.getWarehouseId());
        }
        if (lGoodsWhRecord.isset_parentId) {
            this.setParentId(lGoodsWhRecord.getParentId());
        }
        if (lGoodsWhRecord.isset_dealTime) {
            this.setDealTime(lGoodsWhRecord.getDealTime());
        }
        // åŽ»æŽ‰ï¼Œ2022-09-07
        // this.setDatabaseName_(l_goods_wh_record.getDatabaseName_());
    }

    /**
     * èŽ·å–表名
     */
    @Override
    public String getTableName_() {
        String tableName = "l_goods_wh_record";
        /**
        if (StringUtils.isNotEmpty(this.getDatabaseName_())) {
            return this.getDatabaseName_() + "." + tableName;
        } else {
            return tableName;
        }
        */
        return tableName;
    }

    /**
     * èŽ·å–主键名称
     */
    @Override
    public String getPkName_() {
        return Id;
    }

    /**
     * èŽ·å–主键值
     */
    @Override
    public Object getPkValue_() {
        return this.getId();
    }

    /**
     * èŽ·å–插入语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getInsertSql_() {
        InsertBuilder ib = new InsertBuilder(this.getTableName_());
        ib.set(Id, this.getId());
        ib.set(LWarehouseFlowId, this.getLWarehouseFlowId(), this.isset_lWarehouseFlowId);
        ib.set(LWhGoodsId, this.getLWhGoodsId(), this.isset_lWhGoodsId);
        ib.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
        ib.set(ParentId, this.getParentId(), this.isset_parentId);
        ib.set(DealTime, this.getDealTime(), this.isset_dealTime);
        return ib.genMapSql();
    }

    /**
     * èŽ·å–更新语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getUpdateSql_() {
        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
        ub.set(LWarehouseFlowId, this.getLWarehouseFlowId(), this.isset_lWarehouseFlowId);
        ub.set(LWhGoodsId, this.getLWhGoodsId(), this.isset_lWhGoodsId);
        ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
        ub.set(ParentId, this.getParentId(), this.isset_parentId);
        ub.set(DealTime, this.getDealTime(), this.isset_dealTime);
        ub.where(this.getPkName_(), this.getPkValue_());
        return ub.genMapSql();
    }

    /**
     * èŽ·å–更新语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getUpdateSql_(String where, Map<String, Object> parameters) {
        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
        ub.set(LWarehouseFlowId, this.getLWarehouseFlowId(), this.isset_lWarehouseFlowId);
        ub.set(LWhGoodsId, this.getLWhGoodsId(), this.isset_lWhGoodsId);
        ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
        ub.set(ParentId, this.getParentId(), this.isset_parentId);
        ub.set(DealTime, this.getDealTime(), this.isset_dealTime);
        return ub.genMapSql(where, parameters);
    }

    /**
     * èŽ·å–更新语句和参数
     */
    @Override
    public SqlAndParameters<Object[]> getUpdateSql_(String where, Object[] parameters) {
        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
        ub.set(LWarehouseFlowId, this.getLWarehouseFlowId(), this.isset_lWarehouseFlowId);
        ub.set(LWhGoodsId, this.getLWhGoodsId(), this.isset_lWhGoodsId);
        ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
        ub.set(ParentId, this.getParentId(), this.isset_parentId);
        ub.set(DealTime, this.getDealTime(), this.isset_dealTime);
        return ub.genArraySql(where, parameters);
    }

    /**
     * èŽ·å–删除语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getDeleteSql_() {
        DeleteBuilder db = new DeleteBuilder(this.getTableName_());
        db.where(this.getPkName_(), this.getPkValue_());
        return db.genMapSql();
    }

    /**
     * èŽ·å–删除语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getDeleteSql_(String where, Map<String, Object> parameters) {
        DeleteBuilder db = new DeleteBuilder(this.getTableName_());
        return db.genMapSql(where, parameters);
    }

    /**
     * èŽ·å–删除语句和参数
     */
    @Override
    public SqlAndParameters<Object[]> getDeleteSql_(String where, Object[] parameters) {
        DeleteBuilder db = new DeleteBuilder(this.getTableName_());
        return db.genArraySql(where, parameters);
    }

    /**
     * èŽ·å–单行查询语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getSingleSql_() {
        SelectBuilder sb = new SelectBuilder(this.getTableName_());
        sb.where(this.getPkName_(), this.getPkValue_());
        return sb.genMapSql();
    }


    /**
     * èŽ·å–查询语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) {
        return new SqlAndParameters<>("select id, l_warehouse_flow_id, l_wh_goods_id, warehouse_id, parent_id, deal_time from " + this.getTableName_() + " " + where, parameters);
    }

    /**
     * èŽ·å–查询语句和参数
     */
    @Override
    public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) {
        return new SqlAndParameters<>("select id, l_warehouse_flow_id, l_wh_goods_id, warehouse_id, parent_id, deal_time from " + this.getTableName_() + " " + where, parameters);
    }

    /**
     * å°†resultset的一行转化为po
     */
    @Override
    public LGoodsWhRecord mapRow(ResultSet rs, int i) throws SQLException {
        return ROW_MAPPER.mapRow(rs, i);
    }

    /**
     * å…‹éš†
     */
    public LGoodsWhRecord toLGoodsWhRecord() {
        return super.$clone();
    }
}

/**
 * l_goods_wh_record RowMapper
 *
 * @author genrator
 */
class LGoodsWhRecordRowMapper implements RowMapper<LGoodsWhRecord> {

    @Override
    public LGoodsWhRecord mapRow(ResultSet rs, int i) throws SQLException {
        ResultSetUtils resultSetUtils = new ResultSetUtils();
        LGoodsWhRecord l_goods_wh_record = new LGoodsWhRecord();
        Integer columnIndex;
        //主键
        columnIndex = resultSetUtils.findColumn(rs, LGoodsWhRecord_mapper.Id);
        if (columnIndex > 0) {
            l_goods_wh_record.setId(rs.getLong(columnIndex));
        }
        //普通属性
        columnIndex = resultSetUtils.findColumn(rs, LGoodsWhRecord_mapper.LWarehouseFlowId);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_goods_wh_record.setLWarehouseFlowId(null);
            } else {
                l_goods_wh_record.setLWarehouseFlowId(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LGoodsWhRecord_mapper.LWhGoodsId);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_goods_wh_record.setLWhGoodsId(null);
            } else {
                l_goods_wh_record.setLWhGoodsId(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LGoodsWhRecord_mapper.WarehouseId);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_goods_wh_record.setWarehouseId(null);
            } else {
                l_goods_wh_record.setWarehouseId(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LGoodsWhRecord_mapper.ParentId);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_goods_wh_record.setParentId(null);
            } else {
                l_goods_wh_record.setParentId(rs.getInt(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LGoodsWhRecord_mapper.DealTime);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_goods_wh_record.setDealTime(null);
            } else {
                l_goods_wh_record.setDealTime(rs.getLong(columnIndex));
            }
        }
        return l_goods_wh_record;
    }
}

 consum-model-pojo/src/main/java/com/consum/model/po/LWarehouseFlow.java

New file
@@ -0,0 +1,260 @@

package com.consum.model.po;

import com.fasterxml.jackson.annotation.JsonAutoDetect;
import com.fasterxml.jackson.annotation.JsonIgnore;
import com.walker.jdbc.BasePo;

/**
 * è¡¨å:L_WAREHOUSE_FLOW *
 * @author genrator
 */
@JsonAutoDetect(fieldVisibility = JsonAutoDetect.Visibility.ANY)
public class LWarehouseFlow extends BasePo<LWarehouseFlow> {
    // åºåˆ—化版本号
    private static final long serialVersionUID = 1L;

    // ä¸»é”®
    private Long id = null;
    @JsonIgnore
    protected boolean isset_id = false;

    // å±žæ€§åˆ—表
    private Long warehouseId = null;
    @JsonIgnore
    protected boolean isset_warehouseId = false;

    private String warehouseName = null;
    @JsonIgnore
    protected boolean isset_warehouseName = false;

    private Integer lastRecord = null;
    @JsonIgnore
    protected boolean isset_lastRecord = false;

    private Integer businessType = null;
    @JsonIgnore
    protected boolean isset_businessType = false;

    private Long businessFormId = null;
    @JsonIgnore
    protected boolean isset_businessFormId = false;

    private Long operatorId = null;
    @JsonIgnore
    protected boolean isset_operatorId = false;

    private String operatorName = null;
    @JsonIgnore
    protected boolean isset_operatorName = false;

    private Long dealTime = null;
    @JsonIgnore
    protected boolean isset_dealTime = false;

    /**
     * é»˜è®¤æž„造函数
     */
    public LWarehouseFlow() {
    }

    /**
     * æ ¹æ®ä¸»é”®æž„造对象
     */
    public LWarehouseFlow(Long id) {
        this.setId(id);
    }

    /**
     * è®¾ç½®ä¸»é”®å€¼
     */
    @Override
    public void setPkValue(Object value) {
        this.setId((Long) value);
    }

    public Long getId() {
        return this.id;
    }

    public void setId(Long id) {
        this.id = id;
        this.isset_id = true;
    }

    @JsonIgnore
    public boolean isEmptyId() {
        return this.id == null;
    }

    public Long getWarehouseId() {
        return this.warehouseId;
    }

    public void setWarehouseId(Long warehouseId) {
        this.warehouseId = warehouseId;
        this.isset_warehouseId = true;
    }

    @JsonIgnore
    public boolean isEmptyWarehouseId() {
        return this.warehouseId == null;
    }

    public String getWarehouseName() {
        return this.warehouseName;
    }

    public void setWarehouseName(String warehouseName) {
        this.warehouseName = warehouseName;
        this.isset_warehouseName = true;
    }

    @JsonIgnore
    public boolean isEmptyWarehouseName() {
        return this.warehouseName == null || this.warehouseName.length() == 0;
    }

    public Integer getLastRecord() {
        return this.lastRecord;
    }

    public void setLastRecord(Integer lastRecord) {
        this.lastRecord = lastRecord;
        this.isset_lastRecord = true;
    }

    @JsonIgnore
    public boolean isEmptyLastRecord() {
        return this.lastRecord == null;
    }

    public Integer getBusinessType() {
        return this.businessType;
    }

    public void setBusinessType(Integer businessType) {
        this.businessType = businessType;
        this.isset_businessType = true;
    }

    @JsonIgnore
    public boolean isEmptyBusinessType() {
        return this.businessType == null;
    }

    public Long getBusinessFormId() {
        return this.businessFormId;
    }

    public void setBusinessFormId(Long businessFormId) {
        this.businessFormId = businessFormId;
        this.isset_businessFormId = true;
    }

    @JsonIgnore
    public boolean isEmptyBusinessFormId() {
        return this.businessFormId == null;
    }

    public Long getOperatorId() {
        return this.operatorId;
    }

    public void setOperatorId(Long operatorId) {
        this.operatorId = operatorId;
        this.isset_operatorId = true;
    }

    @JsonIgnore
    public boolean isEmptyOperatorId() {
        return this.operatorId == null;
    }

    public String getOperatorName() {
        return this.operatorName;
    }

    public void setOperatorName(String operatorName) {
        this.operatorName = operatorName;
        this.isset_operatorName = true;
    }

    @JsonIgnore
    public boolean isEmptyOperatorName() {
        return this.operatorName == null || this.operatorName.length() == 0;
    }

    public Long getDealTime() {
        return this.dealTime;
    }

    public void setDealTime(Long dealTime) {
        this.dealTime = dealTime;
        this.isset_dealTime = true;
    }

    @JsonIgnore
    public boolean isEmptyDealTime() {
        return this.dealTime == null;
    }

    /**
     * é‡å†™ toString() æ–¹æ³•
     */
    @Override
    public String toString() {
        return new StringBuilder()
                .append("id=").append(this.id)
                .append("warehouseId=").append(this.warehouseId)
                .append("warehouseName=").append(this.warehouseName)
                .append("lastRecord=").append(this.lastRecord)
                .append("businessType=").append(this.businessType)
                .append("businessFormId=").append(this.businessFormId)
                .append("operatorId=").append(this.operatorId)
                .append("operatorName=").append(this.operatorName)
                .append("dealTime=").append(this.dealTime)
                .toString();
    }

    /**
     * å…‹éš†
     */
    public LWarehouseFlow $clone() {
        LWarehouseFlow l_warehouse_flow = new LWarehouseFlow();

        // æ•°æ®åº“名称
        //l_warehouse_flow.setDatabaseName_(this.getDatabaseName_());

        // ä¸»é”®
        if (this.isset_id) {
            l_warehouse_flow.setId(this.getId());
        }
        // æ™®é€šå±žæ€§
        if (this.isset_warehouseId) {
            l_warehouse_flow.setWarehouseId(this.getWarehouseId());
        }
        if (this.isset_warehouseName) {
            l_warehouse_flow.setWarehouseName(this.getWarehouseName());
        }
        if (this.isset_lastRecord) {
            l_warehouse_flow.setLastRecord(this.getLastRecord());
        }
        if (this.isset_businessType) {
            l_warehouse_flow.setBusinessType(this.getBusinessType());
        }
        if (this.isset_businessFormId) {
            l_warehouse_flow.setBusinessFormId(this.getBusinessFormId());
        }
        if (this.isset_operatorId) {
            l_warehouse_flow.setOperatorId(this.getOperatorId());
        }
        if (this.isset_operatorName) {
            l_warehouse_flow.setOperatorName(this.getOperatorName());
        }
        if (this.isset_dealTime) {
            l_warehouse_flow.setDealTime(this.getDealTime());
        }
        return l_warehouse_flow;
    }
}

 consum-model-pojo/src/main/java/com/consum/model/po/LWarehouseFlow_mapper.java

New file
@@ -0,0 +1,329 @@
package com.consum.model.po;

import com.walker.jdbc.BaseMapper;
import com.walker.jdbc.ResultSetUtils;
import com.walker.jdbc.SqlAndParameters;
import com.walker.jdbc.sqlgen.DeleteBuilder;
import com.walker.jdbc.sqlgen.InsertBuilder;
import com.walker.jdbc.sqlgen.SelectBuilder;
import com.walker.jdbc.sqlgen.UpdateBuilder;
import com.walker.jdbc.util.StringUtils;

import org.springframework.jdbc.core.RowMapper;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Map;

/**
 * è¡¨å:L_WAREHOUSE_FLOW *
 * @author genrator
 */
public class LWarehouseFlow_mapper extends LWarehouseFlow implements BaseMapper<LWarehouseFlow> {
    // åºåˆ—化版本号
    private static final long serialVersionUID = 1L;

    public static final RowMapper<LWarehouseFlow> ROW_MAPPER = new LWarehouseFlowRowMapper();

    // ä¸»é”®
    public static final String Id = "id";
    // æ™®é€šå±žæ€§
    public static final String WarehouseId = "warehouse_id";
    public static final String WarehouseName = "warehouse_name";
    public static final String LastRecord = "last_record";
    public static final String BusinessType = "business_type";
    public static final String BusinessFormId = "business_form_id";
    public static final String OperatorId = "operator_id";
    public static final String OperatorName = "operator_name";
    public static final String DealTime = "deal_time";

    /**
     * é»˜è®¤æž„造函数
     */
    public LWarehouseFlow_mapper(LWarehouseFlow lWarehouseFlow) {
        if (lWarehouseFlow == null) {
            throw new IllegalArgumentException("po参数不允许为空！");
        }
        //主键
        if (lWarehouseFlow.isset_id) {
            this.setId(lWarehouseFlow.getId());
        }
        //普通属性
        if (lWarehouseFlow.isset_warehouseId) {
            this.setWarehouseId(lWarehouseFlow.getWarehouseId());
        }
        if (lWarehouseFlow.isset_warehouseName) {
            this.setWarehouseName(lWarehouseFlow.getWarehouseName());
        }
        if (lWarehouseFlow.isset_lastRecord) {
            this.setLastRecord(lWarehouseFlow.getLastRecord());
        }
        if (lWarehouseFlow.isset_businessType) {
            this.setBusinessType(lWarehouseFlow.getBusinessType());
        }
        if (lWarehouseFlow.isset_businessFormId) {
            this.setBusinessFormId(lWarehouseFlow.getBusinessFormId());
        }
        if (lWarehouseFlow.isset_operatorId) {
            this.setOperatorId(lWarehouseFlow.getOperatorId());
        }
        if (lWarehouseFlow.isset_operatorName) {
            this.setOperatorName(lWarehouseFlow.getOperatorName());
        }
        if (lWarehouseFlow.isset_dealTime) {
            this.setDealTime(lWarehouseFlow.getDealTime());
        }
        // åŽ»æŽ‰ï¼Œ2022-09-07
        // this.setDatabaseName_(l_warehouse_flow.getDatabaseName_());
    }

    /**
     * èŽ·å–表名
     */
    @Override
    public String getTableName_() {
        String tableName = "l_warehouse_flow";
        /**
        if (StringUtils.isNotEmpty(this.getDatabaseName_())) {
            return this.getDatabaseName_() + "." + tableName;
        } else {
            return tableName;
        }
        */
        return tableName;
    }

    /**
     * èŽ·å–主键名称
     */
    @Override
    public String getPkName_() {
        return Id;
    }

    /**
     * èŽ·å–主键值
     */
    @Override
    public Object getPkValue_() {
        return this.getId();
    }

    /**
     * èŽ·å–插入语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getInsertSql_() {
        InsertBuilder ib = new InsertBuilder(this.getTableName_());
        ib.set(Id, this.getId());
        ib.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
        ib.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
        ib.set(LastRecord, this.getLastRecord(), this.isset_lastRecord);
        ib.set(BusinessType, this.getBusinessType(), this.isset_businessType);
        ib.set(BusinessFormId, this.getBusinessFormId(), this.isset_businessFormId);
        ib.set(OperatorId, this.getOperatorId(), this.isset_operatorId);
        ib.set(OperatorName, this.getOperatorName(), this.isset_operatorName);
        ib.set(DealTime, this.getDealTime(), this.isset_dealTime);
        return ib.genMapSql();
    }

    /**
     * èŽ·å–更新语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getUpdateSql_() {
        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
        ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
        ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
        ub.set(LastRecord, this.getLastRecord(), this.isset_lastRecord);
        ub.set(BusinessType, this.getBusinessType(), this.isset_businessType);
        ub.set(BusinessFormId, this.getBusinessFormId(), this.isset_businessFormId);
        ub.set(OperatorId, this.getOperatorId(), this.isset_operatorId);
        ub.set(OperatorName, this.getOperatorName(), this.isset_operatorName);
        ub.set(DealTime, this.getDealTime(), this.isset_dealTime);
        ub.where(this.getPkName_(), this.getPkValue_());
        return ub.genMapSql();
    }

    /**
     * èŽ·å–更新语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getUpdateSql_(String where, Map<String, Object> parameters) {
        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
        ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
        ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
        ub.set(LastRecord, this.getLastRecord(), this.isset_lastRecord);
        ub.set(BusinessType, this.getBusinessType(), this.isset_businessType);
        ub.set(BusinessFormId, this.getBusinessFormId(), this.isset_businessFormId);
        ub.set(OperatorId, this.getOperatorId(), this.isset_operatorId);
        ub.set(OperatorName, this.getOperatorName(), this.isset_operatorName);
        ub.set(DealTime, this.getDealTime(), this.isset_dealTime);
        return ub.genMapSql(where, parameters);
    }

    /**
     * èŽ·å–更新语句和参数
     */
    @Override
    public SqlAndParameters<Object[]> getUpdateSql_(String where, Object[] parameters) {
        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
        ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
        ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
        ub.set(LastRecord, this.getLastRecord(), this.isset_lastRecord);
        ub.set(BusinessType, this.getBusinessType(), this.isset_businessType);
        ub.set(BusinessFormId, this.getBusinessFormId(), this.isset_businessFormId);
        ub.set(OperatorId, this.getOperatorId(), this.isset_operatorId);
        ub.set(OperatorName, this.getOperatorName(), this.isset_operatorName);
        ub.set(DealTime, this.getDealTime(), this.isset_dealTime);
        return ub.genArraySql(where, parameters);
    }

    /**
     * èŽ·å–删除语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getDeleteSql_() {
        DeleteBuilder db = new DeleteBuilder(this.getTableName_());
        db.where(this.getPkName_(), this.getPkValue_());
        return db.genMapSql();
    }

    /**
     * èŽ·å–删除语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getDeleteSql_(String where, Map<String, Object> parameters) {
        DeleteBuilder db = new DeleteBuilder(this.getTableName_());
        return db.genMapSql(where, parameters);
    }

    /**
     * èŽ·å–删除语句和参数
     */
    @Override
    public SqlAndParameters<Object[]> getDeleteSql_(String where, Object[] parameters) {
        DeleteBuilder db = new DeleteBuilder(this.getTableName_());
        return db.genArraySql(where, parameters);
    }

    /**
     * èŽ·å–单行查询语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getSingleSql_() {
        SelectBuilder sb = new SelectBuilder(this.getTableName_());
        sb.where(this.getPkName_(), this.getPkValue_());
        return sb.genMapSql();
    }


    /**
     * èŽ·å–查询语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) {
        return new SqlAndParameters<>("select id, warehouse_id, warehouse_name, last_record, business_type, business_form_id, operator_id, operator_name, deal_time from " + this.getTableName_() + " " + where, parameters);
    }

    /**
     * èŽ·å–查询语句和参数
     */
    @Override
    public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) {
        return new SqlAndParameters<>("select id, warehouse_id, warehouse_name, last_record, business_type, business_form_id, operator_id, operator_name, deal_time from " + this.getTableName_() + " " + where, parameters);
    }

    /**
     * å°†resultset的一行转化为po
     */
    @Override
    public LWarehouseFlow mapRow(ResultSet rs, int i) throws SQLException {
        return ROW_MAPPER.mapRow(rs, i);
    }

    /**
     * å…‹éš†
     */
    public LWarehouseFlow toLWarehouseFlow() {
        return super.$clone();
    }
}

/**
 * l_warehouse_flow RowMapper
 *
 * @author genrator
 */
class LWarehouseFlowRowMapper implements RowMapper<LWarehouseFlow> {

    @Override
    public LWarehouseFlow mapRow(ResultSet rs, int i) throws SQLException {
        ResultSetUtils resultSetUtils = new ResultSetUtils();
        LWarehouseFlow l_warehouse_flow = new LWarehouseFlow();
        Integer columnIndex;
        //主键
        columnIndex = resultSetUtils.findColumn(rs, LWarehouseFlow_mapper.Id);
        if (columnIndex > 0) {
            l_warehouse_flow.setId(rs.getLong(columnIndex));
        }
        //普通属性
        columnIndex = resultSetUtils.findColumn(rs, LWarehouseFlow_mapper.WarehouseId);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_warehouse_flow.setWarehouseId(null);
            } else {
                l_warehouse_flow.setWarehouseId(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWarehouseFlow_mapper.WarehouseName);
        if (columnIndex > 0) {
            l_warehouse_flow.setWarehouseName(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, LWarehouseFlow_mapper.LastRecord);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_warehouse_flow.setLastRecord(null);
            } else {
                l_warehouse_flow.setLastRecord(rs.getInt(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWarehouseFlow_mapper.BusinessType);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_warehouse_flow.setBusinessType(null);
            } else {
                l_warehouse_flow.setBusinessType(rs.getInt(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWarehouseFlow_mapper.BusinessFormId);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_warehouse_flow.setBusinessFormId(null);
            } else {
                l_warehouse_flow.setBusinessFormId(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWarehouseFlow_mapper.OperatorId);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_warehouse_flow.setOperatorId(null);
            } else {
                l_warehouse_flow.setOperatorId(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWarehouseFlow_mapper.OperatorName);
        if (columnIndex > 0) {
            l_warehouse_flow.setOperatorName(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, LWarehouseFlow_mapper.DealTime);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_warehouse_flow.setDealTime(null);
            } else {
                l_warehouse_flow.setDealTime(rs.getLong(columnIndex));
            }
        }
        return l_warehouse_flow;
    }
}

 consum-model-pojo/src/main/java/com/consum/model/po/LWhFormProcure.java

New file
@@ -0,0 +1,436 @@

package com.consum.model.po;

import com.fasterxml.jackson.annotation.JsonAutoDetect;
import com.fasterxml.jackson.annotation.JsonIgnore;
import com.walker.jdbc.BasePo;

/**
 * è¡¨å:L_WH_FORM_PROCURE *
 * @author genrator
 */
@JsonAutoDetect(fieldVisibility = JsonAutoDetect.Visibility.ANY)
public class LWhFormProcure extends BasePo<LWhFormProcure> {
    // åºåˆ—化版本号
    private static final long serialVersionUID = 1L;

    // ä¸»é”®
    private Long id = null;
    @JsonIgnore
    protected boolean isset_id = false;

    // å±žæ€§åˆ—表
    private String businessFormCode = null;
    @JsonIgnore
    protected boolean isset_businessFormCode = false;

    private String warehouseName = null;
    @JsonIgnore
    protected boolean isset_warehouseName = false;

    private Long buyerId = null;
    @JsonIgnore
    protected boolean isset_buyerId = false;

    private String buyerName = null;
    @JsonIgnore
    protected boolean isset_buyerName = false;

    private Long procureTime = null;
    @JsonIgnore
    protected boolean isset_procureTime = false;

    private String procureDoc = null;
    @JsonIgnore
    protected boolean isset_procureDoc = false;

    private Integer buyType = null;
    @JsonIgnore
    protected boolean isset_buyType = false;

    private Integer states = null;
    @JsonIgnore
    protected boolean isset_states = false;

    private Long agencyId = null;
    @JsonIgnore
    protected boolean isset_agencyId = false;

    private String agencyName = null;
    @JsonIgnore
    protected boolean isset_agencyName = false;

    private Long incomeId = null;
    @JsonIgnore
    protected boolean isset_incomeId = false;

    private String incomeName = null;
    @JsonIgnore
    protected boolean isset_incomeName = false;

    private Long incomeTime = null;
    @JsonIgnore
    protected boolean isset_incomeTime = false;

    private Long warehouseId = null;
    @JsonIgnore
    protected boolean isset_warehouseId = false;

    private String beiz = null;
    @JsonIgnore
    protected boolean isset_beiz = false;

    private Long lWarehouseFlowId = null;
    @JsonIgnore
    protected boolean isset_lWarehouseFlowId = false;

    /**
     * é»˜è®¤æž„造函数
     */
    public LWhFormProcure() {
    }

    /**
     * æ ¹æ®ä¸»é”®æž„造对象
     */
    public LWhFormProcure(Long id) {
        this.setId(id);
    }

    /**
     * è®¾ç½®ä¸»é”®å€¼
     */
    @Override
    public void setPkValue(Object value) {
        this.setId((Long) value);
    }

    public Long getId() {
        return this.id;
    }

    public void setId(Long id) {
        this.id = id;
        this.isset_id = true;
    }

    @JsonIgnore
    public boolean isEmptyId() {
        return this.id == null;
    }

    public String getBusinessFormCode() {
        return this.businessFormCode;
    }

    public void setBusinessFormCode(String businessFormCode) {
        this.businessFormCode = businessFormCode;
        this.isset_businessFormCode = true;
    }

    @JsonIgnore
    public boolean isEmptyBusinessFormCode() {
        return this.businessFormCode == null || this.businessFormCode.length() == 0;
    }

    public String getWarehouseName() {
        return this.warehouseName;
    }

    public void setWarehouseName(String warehouseName) {
        this.warehouseName = warehouseName;
        this.isset_warehouseName = true;
    }

    @JsonIgnore
    public boolean isEmptyWarehouseName() {
        return this.warehouseName == null || this.warehouseName.length() == 0;
    }

    public Long getBuyerId() {
        return this.buyerId;
    }

    public void setBuyerId(Long buyerId) {
        this.buyerId = buyerId;
        this.isset_buyerId = true;
    }

    @JsonIgnore
    public boolean isEmptyBuyerId() {
        return this.buyerId == null;
    }

    public String getBuyerName() {
        return this.buyerName;
    }

    public void setBuyerName(String buyerName) {
        this.buyerName = buyerName;
        this.isset_buyerName = true;
    }

    @JsonIgnore
    public boolean isEmptyBuyerName() {
        return this.buyerName == null || this.buyerName.length() == 0;
    }

    public Long getProcureTime() {
        return this.procureTime;
    }

    public void setProcureTime(Long procureTime) {
        this.procureTime = procureTime;
        this.isset_procureTime = true;
    }

    @JsonIgnore
    public boolean isEmptyProcureTime() {
        return this.procureTime == null;
    }

    public String getProcureDoc() {
        return this.procureDoc;
    }

    public void setProcureDoc(String procureDoc) {
        this.procureDoc = procureDoc;
        this.isset_procureDoc = true;
    }

    @JsonIgnore
    public boolean isEmptyProcureDoc() {
        return this.procureDoc == null || this.procureDoc.length() == 0;
    }

    public Integer getBuyType() {
        return this.buyType;
    }

    public void setBuyType(Integer buyType) {
        this.buyType = buyType;
        this.isset_buyType = true;
    }

    @JsonIgnore
    public boolean isEmptyBuyType() {
        return this.buyType == null;
    }

    public Integer getStates() {
        return this.states;
    }

    public void setStates(Integer states) {
        this.states = states;
        this.isset_states = true;
    }

    @JsonIgnore
    public boolean isEmptyStates() {
        return this.states == null;
    }

    public Long getAgencyId() {
        return this.agencyId;
    }

    public void setAgencyId(Long agencyId) {
        this.agencyId = agencyId;
        this.isset_agencyId = true;
    }

    @JsonIgnore
    public boolean isEmptyAgencyId() {
        return this.agencyId == null;
    }

    public String getAgencyName() {
        return this.agencyName;
    }

    public void setAgencyName(String agencyName) {
        this.agencyName = agencyName;
        this.isset_agencyName = true;
    }

    @JsonIgnore
    public boolean isEmptyAgencyName() {
        return this.agencyName == null || this.agencyName.length() == 0;
    }

    public Long getIncomeId() {
        return this.incomeId;
    }

    public void setIncomeId(Long incomeId) {
        this.incomeId = incomeId;
        this.isset_incomeId = true;
    }

    @JsonIgnore
    public boolean isEmptyIncomeId() {
        return this.incomeId == null;
    }

    public String getIncomeName() {
        return this.incomeName;
    }

    public void setIncomeName(String incomeName) {
        this.incomeName = incomeName;
        this.isset_incomeName = true;
    }

    @JsonIgnore
    public boolean isEmptyIncomeName() {
        return this.incomeName == null || this.incomeName.length() == 0;
    }

    public Long getIncomeTime() {
        return this.incomeTime;
    }

    public void setIncomeTime(Long incomeTime) {
        this.incomeTime = incomeTime;
        this.isset_incomeTime = true;
    }

    @JsonIgnore
    public boolean isEmptyIncomeTime() {
        return this.incomeTime == null;
    }

    public Long getWarehouseId() {
        return this.warehouseId;
    }

    public void setWarehouseId(Long warehouseId) {
        this.warehouseId = warehouseId;
        this.isset_warehouseId = true;
    }

    @JsonIgnore
    public boolean isEmptyWarehouseId() {
        return this.warehouseId == null;
    }

    public String getBeiz() {
        return this.beiz;
    }

    public void setBeiz(String beiz) {
        this.beiz = beiz;
        this.isset_beiz = true;
    }

    @JsonIgnore
    public boolean isEmptyBeiz() {
        return this.beiz == null || this.beiz.length() == 0;
    }

    public Long getLWarehouseFlowId() {
        return this.lWarehouseFlowId;
    }

    public void setLWarehouseFlowId(Long lWarehouseFlowId) {
        this.lWarehouseFlowId = lWarehouseFlowId;
        this.isset_lWarehouseFlowId = true;
    }

    @JsonIgnore
    public boolean isEmptyLWarehouseFlowId() {
        return this.lWarehouseFlowId == null;
    }

    /**
     * é‡å†™ toString() æ–¹æ³•
     */
    @Override
    public String toString() {
        return new StringBuilder()
                .append("id=").append(this.id)
                .append("businessFormCode=").append(this.businessFormCode)
                .append("warehouseName=").append(this.warehouseName)
                .append("buyerId=").append(this.buyerId)
                .append("buyerName=").append(this.buyerName)
                .append("procureTime=").append(this.procureTime)
                .append("procureDoc=").append(this.procureDoc)
                .append("buyType=").append(this.buyType)
                .append("states=").append(this.states)
                .append("agencyId=").append(this.agencyId)
                .append("agencyName=").append(this.agencyName)
                .append("incomeId=").append(this.incomeId)
                .append("incomeName=").append(this.incomeName)
                .append("incomeTime=").append(this.incomeTime)
                .append("warehouseId=").append(this.warehouseId)
                .append("beiz=").append(this.beiz)
                .append("lWarehouseFlowId=").append(this.lWarehouseFlowId)
                .toString();
    }

    /**
     * å…‹éš†
     */
    public LWhFormProcure $clone() {
        LWhFormProcure l_wh_form_procure = new LWhFormProcure();

        // æ•°æ®åº“名称
        //l_wh_form_procure.setDatabaseName_(this.getDatabaseName_());

        // ä¸»é”®
        if (this.isset_id) {
            l_wh_form_procure.setId(this.getId());
        }
        // æ™®é€šå±žæ€§
        if (this.isset_businessFormCode) {
            l_wh_form_procure.setBusinessFormCode(this.getBusinessFormCode());
        }
        if (this.isset_warehouseName) {
            l_wh_form_procure.setWarehouseName(this.getWarehouseName());
        }
        if (this.isset_buyerId) {
            l_wh_form_procure.setBuyerId(this.getBuyerId());
        }
        if (this.isset_buyerName) {
            l_wh_form_procure.setBuyerName(this.getBuyerName());
        }
        if (this.isset_procureTime) {
            l_wh_form_procure.setProcureTime(this.getProcureTime());
        }
        if (this.isset_procureDoc) {
            l_wh_form_procure.setProcureDoc(this.getProcureDoc());
        }
        if (this.isset_buyType) {
            l_wh_form_procure.setBuyType(this.getBuyType());
        }
        if (this.isset_states) {
            l_wh_form_procure.setStates(this.getStates());
        }
        if (this.isset_agencyId) {
            l_wh_form_procure.setAgencyId(this.getAgencyId());
        }
        if (this.isset_agencyName) {
            l_wh_form_procure.setAgencyName(this.getAgencyName());
        }
        if (this.isset_incomeId) {
            l_wh_form_procure.setIncomeId(this.getIncomeId());
        }
        if (this.isset_incomeName) {
            l_wh_form_procure.setIncomeName(this.getIncomeName());
        }
        if (this.isset_incomeTime) {
            l_wh_form_procure.setIncomeTime(this.getIncomeTime());
        }
        if (this.isset_warehouseId) {
            l_wh_form_procure.setWarehouseId(this.getWarehouseId());
        }
        if (this.isset_beiz) {
            l_wh_form_procure.setBeiz(this.getBeiz());
        }
        if (this.isset_lWarehouseFlowId) {
            l_wh_form_procure.setLWarehouseFlowId(this.getLWarehouseFlowId());
        }
        return l_wh_form_procure;
    }
}

 consum-model-pojo/src/main/java/com/consum/model/po/LWhFormProcureGoods.java

New file
@@ -0,0 +1,216 @@

package com.consum.model.po;

import com.fasterxml.jackson.annotation.JsonAutoDetect;
import com.fasterxml.jackson.annotation.JsonIgnore;
import com.walker.jdbc.BasePo;

/**
 * è¡¨å:L_WH_FORM_PROCURE_GOODS *
 * @author genrator
 */
@JsonAutoDetect(fieldVisibility = JsonAutoDetect.Visibility.ANY)
public class LWhFormProcureGoods extends BasePo<LWhFormProcureGoods> {
    // åºåˆ—化版本号
    private static final long serialVersionUID = 1L;

    // ä¸»é”®
    private Long id = null;
    @JsonIgnore
    protected boolean isset_id = false;

    // å±žæ€§åˆ—表
    private Long whFormProcureId = null;
    @JsonIgnore
    protected boolean isset_whFormProcureId = false;

    private Long baseCategoryId = null;
    @JsonIgnore
    protected boolean isset_baseCategoryId = false;

    private Long baseGoodsTemplateId = null;
    @JsonIgnore
    protected boolean isset_baseGoodsTemplateId = false;

    private String goodsTemplateName = null;
    @JsonIgnore
    protected boolean isset_goodsTemplateName = false;

    private String supplier = null;
    @JsonIgnore
    protected boolean isset_supplier = false;

    private Integer sort = null;
    @JsonIgnore
    protected boolean isset_sort = false;

    /**
     * é»˜è®¤æž„造函数
     */
    public LWhFormProcureGoods() {
    }

    /**
     * æ ¹æ®ä¸»é”®æž„造对象
     */
    public LWhFormProcureGoods(Long id) {
        this.setId(id);
    }

    /**
     * è®¾ç½®ä¸»é”®å€¼
     */
    @Override
    public void setPkValue(Object value) {
        this.setId((Long) value);
    }

    public Long getId() {
        return this.id;
    }

    public void setId(Long id) {
        this.id = id;
        this.isset_id = true;
    }

    @JsonIgnore
    public boolean isEmptyId() {
        return this.id == null;
    }

    public Long getWhFormProcureId() {
        return this.whFormProcureId;
    }

    public void setWhFormProcureId(Long whFormProcureId) {
        this.whFormProcureId = whFormProcureId;
        this.isset_whFormProcureId = true;
    }

    @JsonIgnore
    public boolean isEmptyWhFormProcureId() {
        return this.whFormProcureId == null;
    }

    public Long getBaseCategoryId() {
        return this.baseCategoryId;
    }

    public void setBaseCategoryId(Long baseCategoryId) {
        this.baseCategoryId = baseCategoryId;
        this.isset_baseCategoryId = true;
    }

    @JsonIgnore
    public boolean isEmptyBaseCategoryId() {
        return this.baseCategoryId == null;
    }

    public Long getBaseGoodsTemplateId() {
        return this.baseGoodsTemplateId;
    }

    public void setBaseGoodsTemplateId(Long baseGoodsTemplateId) {
        this.baseGoodsTemplateId = baseGoodsTemplateId;
        this.isset_baseGoodsTemplateId = true;
    }

    @JsonIgnore
    public boolean isEmptyBaseGoodsTemplateId() {
        return this.baseGoodsTemplateId == null;
    }

    public String getGoodsTemplateName() {
        return this.goodsTemplateName;
    }

    public void setGoodsTemplateName(String goodsTemplateName) {
        this.goodsTemplateName = goodsTemplateName;
        this.isset_goodsTemplateName = true;
    }

    @JsonIgnore
    public boolean isEmptyGoodsTemplateName() {
        return this.goodsTemplateName == null || this.goodsTemplateName.length() == 0;
    }

    public String getSupplier() {
        return this.supplier;
    }

    public void setSupplier(String supplier) {
        this.supplier = supplier;
        this.isset_supplier = true;
    }

    @JsonIgnore
    public boolean isEmptySupplier() {
        return this.supplier == null || this.supplier.length() == 0;
    }

    public Integer getSort() {
        return this.sort;
    }

    public void setSort(Integer sort) {
        this.sort = sort;
        this.isset_sort = true;
    }

    @JsonIgnore
    public boolean isEmptySort() {
        return this.sort == null;
    }

    /**
     * é‡å†™ toString() æ–¹æ³•
     */
    @Override
    public String toString() {
        return new StringBuilder()
                .append("id=").append(this.id)
                .append("whFormProcureId=").append(this.whFormProcureId)
                .append("baseCategoryId=").append(this.baseCategoryId)
                .append("baseGoodsTemplateId=").append(this.baseGoodsTemplateId)
                .append("goodsTemplateName=").append(this.goodsTemplateName)
                .append("supplier=").append(this.supplier)
                .append("sort=").append(this.sort)
                .toString();
    }

    /**
     * å…‹éš†
     */
    public LWhFormProcureGoods $clone() {
        LWhFormProcureGoods l_wh_form_procure_goods = new LWhFormProcureGoods();

        // æ•°æ®åº“名称
        //l_wh_form_procure_goods.setDatabaseName_(this.getDatabaseName_());

        // ä¸»é”®
        if (this.isset_id) {
            l_wh_form_procure_goods.setId(this.getId());
        }
        // æ™®é€šå±žæ€§
        if (this.isset_whFormProcureId) {
            l_wh_form_procure_goods.setWhFormProcureId(this.getWhFormProcureId());
        }
        if (this.isset_baseCategoryId) {
            l_wh_form_procure_goods.setBaseCategoryId(this.getBaseCategoryId());
        }
        if (this.isset_baseGoodsTemplateId) {
            l_wh_form_procure_goods.setBaseGoodsTemplateId(this.getBaseGoodsTemplateId());
        }
        if (this.isset_goodsTemplateName) {
            l_wh_form_procure_goods.setGoodsTemplateName(this.getGoodsTemplateName());
        }
        if (this.isset_supplier) {
            l_wh_form_procure_goods.setSupplier(this.getSupplier());
        }
        if (this.isset_sort) {
            l_wh_form_procure_goods.setSort(this.getSort());
        }
        return l_wh_form_procure_goods;
    }
}

 consum-model-pojo/src/main/java/com/consum/model/po/LWhFormProcureGoods_mapper.java

New file
@@ -0,0 +1,297 @@
package com.consum.model.po;

import com.walker.jdbc.BaseMapper;
import com.walker.jdbc.ResultSetUtils;
import com.walker.jdbc.SqlAndParameters;
import com.walker.jdbc.sqlgen.DeleteBuilder;
import com.walker.jdbc.sqlgen.InsertBuilder;
import com.walker.jdbc.sqlgen.SelectBuilder;
import com.walker.jdbc.sqlgen.UpdateBuilder;
import com.walker.jdbc.util.StringUtils;

import org.springframework.jdbc.core.RowMapper;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Map;

/**
 * è¡¨å:L_WH_FORM_PROCURE_GOODS *
 * @author genrator
 */
public class LWhFormProcureGoods_mapper extends LWhFormProcureGoods implements BaseMapper<LWhFormProcureGoods> {
    // åºåˆ—化版本号
    private static final long serialVersionUID = 1L;

    public static final RowMapper<LWhFormProcureGoods> ROW_MAPPER = new LWhFormProcureGoodsRowMapper();

    // ä¸»é”®
    public static final String Id = "id";
    // æ™®é€šå±žæ€§
    public static final String WhFormProcureId = "wh_form_procure_id";
    public static final String BaseCategoryId = "base_category_id";
    public static final String BaseGoodsTemplateId = "base_goods_template_id";
    public static final String GoodsTemplateName = "goods_template_name";
    public static final String Supplier = "supplier";
    public static final String Sort = "sort";

    /**
     * é»˜è®¤æž„造函数
     */
    public LWhFormProcureGoods_mapper(LWhFormProcureGoods lWhFormProcureGoods) {
        if (lWhFormProcureGoods == null) {
            throw new IllegalArgumentException("po参数不允许为空！");
        }
        //主键
        if (lWhFormProcureGoods.isset_id) {
            this.setId(lWhFormProcureGoods.getId());
        }
        //普通属性
        if (lWhFormProcureGoods.isset_whFormProcureId) {
            this.setWhFormProcureId(lWhFormProcureGoods.getWhFormProcureId());
        }
        if (lWhFormProcureGoods.isset_baseCategoryId) {
            this.setBaseCategoryId(lWhFormProcureGoods.getBaseCategoryId());
        }
        if (lWhFormProcureGoods.isset_baseGoodsTemplateId) {
            this.setBaseGoodsTemplateId(lWhFormProcureGoods.getBaseGoodsTemplateId());
        }
        if (lWhFormProcureGoods.isset_goodsTemplateName) {
            this.setGoodsTemplateName(lWhFormProcureGoods.getGoodsTemplateName());
        }
        if (lWhFormProcureGoods.isset_supplier) {
            this.setSupplier(lWhFormProcureGoods.getSupplier());
        }
        if (lWhFormProcureGoods.isset_sort) {
            this.setSort(lWhFormProcureGoods.getSort());
        }
        // åŽ»æŽ‰ï¼Œ2022-09-07
        // this.setDatabaseName_(l_wh_form_procure_goods.getDatabaseName_());
    }

    /**
     * èŽ·å–表名
     */
    @Override
    public String getTableName_() {
        String tableName = "l_wh_form_procure_goods";
        /**
        if (StringUtils.isNotEmpty(this.getDatabaseName_())) {
            return this.getDatabaseName_() + "." + tableName;
        } else {
            return tableName;
        }
        */
        return tableName;
    }

    /**
     * èŽ·å–主键名称
     */
    @Override
    public String getPkName_() {
        return Id;
    }

    /**
     * èŽ·å–主键值
     */
    @Override
    public Object getPkValue_() {
        return this.getId();
    }

    /**
     * èŽ·å–插入语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getInsertSql_() {
        InsertBuilder ib = new InsertBuilder(this.getTableName_());
        ib.set(Id, this.getId());
        ib.set(WhFormProcureId, this.getWhFormProcureId(), this.isset_whFormProcureId);
        ib.set(BaseCategoryId, this.getBaseCategoryId(), this.isset_baseCategoryId);
        ib.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId);
        ib.set(GoodsTemplateName, this.getGoodsTemplateName(), this.isset_goodsTemplateName);
        ib.set(Supplier, this.getSupplier(), this.isset_supplier);
        ib.set(Sort, this.getSort(), this.isset_sort);
        return ib.genMapSql();
    }

    /**
     * èŽ·å–更新语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getUpdateSql_() {
        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
        ub.set(WhFormProcureId, this.getWhFormProcureId(), this.isset_whFormProcureId);
        ub.set(BaseCategoryId, this.getBaseCategoryId(), this.isset_baseCategoryId);
        ub.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId);
        ub.set(GoodsTemplateName, this.getGoodsTemplateName(), this.isset_goodsTemplateName);
        ub.set(Supplier, this.getSupplier(), this.isset_supplier);
        ub.set(Sort, this.getSort(), this.isset_sort);
        ub.where(this.getPkName_(), this.getPkValue_());
        return ub.genMapSql();
    }

    /**
     * èŽ·å–更新语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getUpdateSql_(String where, Map<String, Object> parameters) {
        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
        ub.set(WhFormProcureId, this.getWhFormProcureId(), this.isset_whFormProcureId);
        ub.set(BaseCategoryId, this.getBaseCategoryId(), this.isset_baseCategoryId);
        ub.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId);
        ub.set(GoodsTemplateName, this.getGoodsTemplateName(), this.isset_goodsTemplateName);
        ub.set(Supplier, this.getSupplier(), this.isset_supplier);
        ub.set(Sort, this.getSort(), this.isset_sort);
        return ub.genMapSql(where, parameters);
    }

    /**
     * èŽ·å–更新语句和参数
     */
    @Override
    public SqlAndParameters<Object[]> getUpdateSql_(String where, Object[] parameters) {
        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
        ub.set(WhFormProcureId, this.getWhFormProcureId(), this.isset_whFormProcureId);
        ub.set(BaseCategoryId, this.getBaseCategoryId(), this.isset_baseCategoryId);
        ub.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId);
        ub.set(GoodsTemplateName, this.getGoodsTemplateName(), this.isset_goodsTemplateName);
        ub.set(Supplier, this.getSupplier(), this.isset_supplier);
        ub.set(Sort, this.getSort(), this.isset_sort);
        return ub.genArraySql(where, parameters);
    }

    /**
     * èŽ·å–删除语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getDeleteSql_() {
        DeleteBuilder db = new DeleteBuilder(this.getTableName_());
        db.where(this.getPkName_(), this.getPkValue_());
        return db.genMapSql();
    }

    /**
     * èŽ·å–删除语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getDeleteSql_(String where, Map<String, Object> parameters) {
        DeleteBuilder db = new DeleteBuilder(this.getTableName_());
        return db.genMapSql(where, parameters);
    }

    /**
     * èŽ·å–删除语句和参数
     */
    @Override
    public SqlAndParameters<Object[]> getDeleteSql_(String where, Object[] parameters) {
        DeleteBuilder db = new DeleteBuilder(this.getTableName_());
        return db.genArraySql(where, parameters);
    }

    /**
     * èŽ·å–单行查询语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getSingleSql_() {
        SelectBuilder sb = new SelectBuilder(this.getTableName_());
        sb.where(this.getPkName_(), this.getPkValue_());
        return sb.genMapSql();
    }


    /**
     * èŽ·å–查询语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) {
        return new SqlAndParameters<>("select id, wh_form_procure_id, base_category_id, base_goods_template_id, goods_template_name, supplier, sort from " + this.getTableName_() + " " + where, parameters);
    }

    /**
     * èŽ·å–查询语句和参数
     */
    @Override
    public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) {
        return new SqlAndParameters<>("select id, wh_form_procure_id, base_category_id, base_goods_template_id, goods_template_name, supplier, sort from " + this.getTableName_() + " " + where, parameters);
    }

    /**
     * å°†resultset的一行转化为po
     */
    @Override
    public LWhFormProcureGoods mapRow(ResultSet rs, int i) throws SQLException {
        return ROW_MAPPER.mapRow(rs, i);
    }

    /**
     * å…‹éš†
     */
    public LWhFormProcureGoods toLWhFormProcureGoods() {
        return super.$clone();
    }
}

/**
 * l_wh_form_procure_goods RowMapper
 *
 * @author genrator
 */
class LWhFormProcureGoodsRowMapper implements RowMapper<LWhFormProcureGoods> {

    @Override
    public LWhFormProcureGoods mapRow(ResultSet rs, int i) throws SQLException {
        ResultSetUtils resultSetUtils = new ResultSetUtils();
        LWhFormProcureGoods l_wh_form_procure_goods = new LWhFormProcureGoods();
        Integer columnIndex;
        //主键
        columnIndex = resultSetUtils.findColumn(rs, LWhFormProcureGoods_mapper.Id);
        if (columnIndex > 0) {
            l_wh_form_procure_goods.setId(rs.getLong(columnIndex));
        }
        //普通属性
        columnIndex = resultSetUtils.findColumn(rs, LWhFormProcureGoods_mapper.WhFormProcureId);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_form_procure_goods.setWhFormProcureId(null);
            } else {
                l_wh_form_procure_goods.setWhFormProcureId(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormProcureGoods_mapper.BaseCategoryId);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_form_procure_goods.setBaseCategoryId(null);
            } else {
                l_wh_form_procure_goods.setBaseCategoryId(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormProcureGoods_mapper.BaseGoodsTemplateId);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_form_procure_goods.setBaseGoodsTemplateId(null);
            } else {
                l_wh_form_procure_goods.setBaseGoodsTemplateId(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormProcureGoods_mapper.GoodsTemplateName);
        if (columnIndex > 0) {
            l_wh_form_procure_goods.setGoodsTemplateName(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormProcureGoods_mapper.Supplier);
        if (columnIndex > 0) {
            l_wh_form_procure_goods.setSupplier(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormProcureGoods_mapper.Sort);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_form_procure_goods.setSort(null);
            } else {
                l_wh_form_procure_goods.setSort(rs.getInt(columnIndex));
            }
        }
        return l_wh_form_procure_goods;
    }
}

 consum-model-pojo/src/main/java/com/consum/model/po/LWhFormProcure_mapper.java

New file
@@ -0,0 +1,437 @@
package com.consum.model.po;

import com.walker.jdbc.BaseMapper;
import com.walker.jdbc.ResultSetUtils;
import com.walker.jdbc.SqlAndParameters;
import com.walker.jdbc.sqlgen.DeleteBuilder;
import com.walker.jdbc.sqlgen.InsertBuilder;
import com.walker.jdbc.sqlgen.SelectBuilder;
import com.walker.jdbc.sqlgen.UpdateBuilder;
import com.walker.jdbc.util.StringUtils;

import org.springframework.jdbc.core.RowMapper;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Map;

/**
 * è¡¨å:L_WH_FORM_PROCURE *
 * @author genrator
 */
public class LWhFormProcure_mapper extends LWhFormProcure implements BaseMapper<LWhFormProcure> {
    // åºåˆ—化版本号
    private static final long serialVersionUID = 1L;

    public static final RowMapper<LWhFormProcure> ROW_MAPPER = new LWhFormProcureRowMapper();

    // ä¸»é”®
    public static final String Id = "id";
    // æ™®é€šå±žæ€§
    public static final String BusinessFormCode = "business_form_code";
    public static final String WarehouseName = "warehouse_name";
    public static final String BuyerId = "buyer_id";
    public static final String BuyerName = "buyer_name";
    public static final String ProcureTime = "procure_time";
    public static final String ProcureDoc = "procure_doc";
    public static final String BuyType = "buy_type";
    public static final String States = "states";
    public static final String AgencyId = "agency_id";
    public static final String AgencyName = "agency_name";
    public static final String IncomeId = "income_id";
    public static final String IncomeName = "income_name";
    public static final String IncomeTime = "income_time";
    public static final String WarehouseId = "warehouse_id";
    public static final String Beiz = "beiz";
    public static final String LWarehouseFlowId = "l_warehouse_flow_id";

    /**
     * é»˜è®¤æž„造函数
     */
    public LWhFormProcure_mapper(LWhFormProcure lWhFormProcure) {
        if (lWhFormProcure == null) {
            throw new IllegalArgumentException("po参数不允许为空！");
        }
        //主键
        if (lWhFormProcure.isset_id) {
            this.setId(lWhFormProcure.getId());
        }
        //普通属性
        if (lWhFormProcure.isset_businessFormCode) {
            this.setBusinessFormCode(lWhFormProcure.getBusinessFormCode());
        }
        if (lWhFormProcure.isset_warehouseName) {
            this.setWarehouseName(lWhFormProcure.getWarehouseName());
        }
        if (lWhFormProcure.isset_buyerId) {
            this.setBuyerId(lWhFormProcure.getBuyerId());
        }
        if (lWhFormProcure.isset_buyerName) {
            this.setBuyerName(lWhFormProcure.getBuyerName());
        }
        if (lWhFormProcure.isset_procureTime) {
            this.setProcureTime(lWhFormProcure.getProcureTime());
        }
        if (lWhFormProcure.isset_procureDoc) {
            this.setProcureDoc(lWhFormProcure.getProcureDoc());
        }
        if (lWhFormProcure.isset_buyType) {
            this.setBuyType(lWhFormProcure.getBuyType());
        }
        if (lWhFormProcure.isset_states) {
            this.setStates(lWhFormProcure.getStates());
        }
        if (lWhFormProcure.isset_agencyId) {
            this.setAgencyId(lWhFormProcure.getAgencyId());
        }
        if (lWhFormProcure.isset_agencyName) {
            this.setAgencyName(lWhFormProcure.getAgencyName());
        }
        if (lWhFormProcure.isset_incomeId) {
            this.setIncomeId(lWhFormProcure.getIncomeId());
        }
        if (lWhFormProcure.isset_incomeName) {
            this.setIncomeName(lWhFormProcure.getIncomeName());
        }
        if (lWhFormProcure.isset_incomeTime) {
            this.setIncomeTime(lWhFormProcure.getIncomeTime());
        }
        if (lWhFormProcure.isset_warehouseId) {
            this.setWarehouseId(lWhFormProcure.getWarehouseId());
        }
        if (lWhFormProcure.isset_beiz) {
            this.setBeiz(lWhFormProcure.getBeiz());
        }
        if (lWhFormProcure.isset_lWarehouseFlowId) {
            this.setLWarehouseFlowId(lWhFormProcure.getLWarehouseFlowId());
        }
        // åŽ»æŽ‰ï¼Œ2022-09-07
        // this.setDatabaseName_(l_wh_form_procure.getDatabaseName_());
    }

    /**
     * èŽ·å–表名
     */
    @Override
    public String getTableName_() {
        String tableName = "l_wh_form_procure";
        /**
        if (StringUtils.isNotEmpty(this.getDatabaseName_())) {
            return this.getDatabaseName_() + "." + tableName;
        } else {
            return tableName;
        }
        */
        return tableName;
    }

    /**
     * èŽ·å–主键名称
     */
    @Override
    public String getPkName_() {
        return Id;
    }

    /**
     * èŽ·å–主键值
     */
    @Override
    public Object getPkValue_() {
        return this.getId();
    }

    /**
     * èŽ·å–插入语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getInsertSql_() {
        InsertBuilder ib = new InsertBuilder(this.getTableName_());
        ib.set(Id, this.getId());
        ib.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode);
        ib.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
        ib.set(BuyerId, this.getBuyerId(), this.isset_buyerId);
        ib.set(BuyerName, this.getBuyerName(), this.isset_buyerName);
        ib.set(ProcureTime, this.getProcureTime(), this.isset_procureTime);
        ib.set(ProcureDoc, this.getProcureDoc(), this.isset_procureDoc);
        ib.set(BuyType, this.getBuyType(), this.isset_buyType);
        ib.set(States, this.getStates(), this.isset_states);
        ib.set(AgencyId, this.getAgencyId(), this.isset_agencyId);
        ib.set(AgencyName, this.getAgencyName(), this.isset_agencyName);
        ib.set(IncomeId, this.getIncomeId(), this.isset_incomeId);
        ib.set(IncomeName, this.getIncomeName(), this.isset_incomeName);
        ib.set(IncomeTime, this.getIncomeTime(), this.isset_incomeTime);
        ib.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
        ib.set(Beiz, this.getBeiz(), this.isset_beiz);
        ib.set(LWarehouseFlowId, this.getLWarehouseFlowId(), this.isset_lWarehouseFlowId);
        return ib.genMapSql();
    }

    /**
     * èŽ·å–更新语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getUpdateSql_() {
        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
        ub.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode);
        ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
        ub.set(BuyerId, this.getBuyerId(), this.isset_buyerId);
        ub.set(BuyerName, this.getBuyerName(), this.isset_buyerName);
        ub.set(ProcureTime, this.getProcureTime(), this.isset_procureTime);
        ub.set(ProcureDoc, this.getProcureDoc(), this.isset_procureDoc);
        ub.set(BuyType, this.getBuyType(), this.isset_buyType);
        ub.set(States, this.getStates(), this.isset_states);
        ub.set(AgencyId, this.getAgencyId(), this.isset_agencyId);
        ub.set(AgencyName, this.getAgencyName(), this.isset_agencyName);
        ub.set(IncomeId, this.getIncomeId(), this.isset_incomeId);
        ub.set(IncomeName, this.getIncomeName(), this.isset_incomeName);
        ub.set(IncomeTime, this.getIncomeTime(), this.isset_incomeTime);
        ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
        ub.set(Beiz, this.getBeiz(), this.isset_beiz);
        ub.set(LWarehouseFlowId, this.getLWarehouseFlowId(), this.isset_lWarehouseFlowId);
        ub.where(this.getPkName_(), this.getPkValue_());
        return ub.genMapSql();
    }

    /**
     * èŽ·å–更新语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getUpdateSql_(String where, Map<String, Object> parameters) {
        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
        ub.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode);
        ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
        ub.set(BuyerId, this.getBuyerId(), this.isset_buyerId);
        ub.set(BuyerName, this.getBuyerName(), this.isset_buyerName);
        ub.set(ProcureTime, this.getProcureTime(), this.isset_procureTime);
        ub.set(ProcureDoc, this.getProcureDoc(), this.isset_procureDoc);
        ub.set(BuyType, this.getBuyType(), this.isset_buyType);
        ub.set(States, this.getStates(), this.isset_states);
        ub.set(AgencyId, this.getAgencyId(), this.isset_agencyId);
        ub.set(AgencyName, this.getAgencyName(), this.isset_agencyName);
        ub.set(IncomeId, this.getIncomeId(), this.isset_incomeId);
        ub.set(IncomeName, this.getIncomeName(), this.isset_incomeName);
        ub.set(IncomeTime, this.getIncomeTime(), this.isset_incomeTime);
        ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
        ub.set(Beiz, this.getBeiz(), this.isset_beiz);
        ub.set(LWarehouseFlowId, this.getLWarehouseFlowId(), this.isset_lWarehouseFlowId);
        return ub.genMapSql(where, parameters);
    }

    /**
     * èŽ·å–更新语句和参数
     */
    @Override
    public SqlAndParameters<Object[]> getUpdateSql_(String where, Object[] parameters) {
        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
        ub.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode);
        ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
        ub.set(BuyerId, this.getBuyerId(), this.isset_buyerId);
        ub.set(BuyerName, this.getBuyerName(), this.isset_buyerName);
        ub.set(ProcureTime, this.getProcureTime(), this.isset_procureTime);
        ub.set(ProcureDoc, this.getProcureDoc(), this.isset_procureDoc);
        ub.set(BuyType, this.getBuyType(), this.isset_buyType);
        ub.set(States, this.getStates(), this.isset_states);
        ub.set(AgencyId, this.getAgencyId(), this.isset_agencyId);
        ub.set(AgencyName, this.getAgencyName(), this.isset_agencyName);
        ub.set(IncomeId, this.getIncomeId(), this.isset_incomeId);
        ub.set(IncomeName, this.getIncomeName(), this.isset_incomeName);
        ub.set(IncomeTime, this.getIncomeTime(), this.isset_incomeTime);
        ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
        ub.set(Beiz, this.getBeiz(), this.isset_beiz);
        ub.set(LWarehouseFlowId, this.getLWarehouseFlowId(), this.isset_lWarehouseFlowId);
        return ub.genArraySql(where, parameters);
    }

    /**
     * èŽ·å–删除语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getDeleteSql_() {
        DeleteBuilder db = new DeleteBuilder(this.getTableName_());
        db.where(this.getPkName_(), this.getPkValue_());
        return db.genMapSql();
    }

    /**
     * èŽ·å–删除语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getDeleteSql_(String where, Map<String, Object> parameters) {
        DeleteBuilder db = new DeleteBuilder(this.getTableName_());
        return db.genMapSql(where, parameters);
    }

    /**
     * èŽ·å–删除语句和参数
     */
    @Override
    public SqlAndParameters<Object[]> getDeleteSql_(String where, Object[] parameters) {
        DeleteBuilder db = new DeleteBuilder(this.getTableName_());
        return db.genArraySql(where, parameters);
    }

    /**
     * èŽ·å–单行查询语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getSingleSql_() {
        SelectBuilder sb = new SelectBuilder(this.getTableName_());
        sb.where(this.getPkName_(), this.getPkValue_());
        return sb.genMapSql();
    }


    /**
     * èŽ·å–查询语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) {
        return new SqlAndParameters<>("select id, business_form_code, warehouse_name, buyer_id, buyer_name, procure_time, procure_doc, buy_type, states, agency_id, agency_name, income_id, income_name, income_time, warehouse_id, beiz, l_warehouse_flow_id from " + this.getTableName_() + " " + where, parameters);
    }

    /**
     * èŽ·å–查询语句和参数
     */
    @Override
    public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) {
        return new SqlAndParameters<>("select id, business_form_code, warehouse_name, buyer_id, buyer_name, procure_time, procure_doc, buy_type, states, agency_id, agency_name, income_id, income_name, income_time, warehouse_id, beiz, l_warehouse_flow_id from " + this.getTableName_() + " " + where, parameters);
    }

    /**
     * å°†resultset的一行转化为po
     */
    @Override
    public LWhFormProcure mapRow(ResultSet rs, int i) throws SQLException {
        return ROW_MAPPER.mapRow(rs, i);
    }

    /**
     * å…‹éš†
     */
    public LWhFormProcure toLWhFormProcure() {
        return super.$clone();
    }
}

/**
 * l_wh_form_procure RowMapper
 *
 * @author genrator
 */
class LWhFormProcureRowMapper implements RowMapper<LWhFormProcure> {

    @Override
    public LWhFormProcure mapRow(ResultSet rs, int i) throws SQLException {
        ResultSetUtils resultSetUtils = new ResultSetUtils();
        LWhFormProcure l_wh_form_procure = new LWhFormProcure();
        Integer columnIndex;
        //主键
        columnIndex = resultSetUtils.findColumn(rs, LWhFormProcure_mapper.Id);
        if (columnIndex > 0) {
            l_wh_form_procure.setId(rs.getLong(columnIndex));
        }
        //普通属性
        columnIndex = resultSetUtils.findColumn(rs, LWhFormProcure_mapper.BusinessFormCode);
        if (columnIndex > 0) {
            l_wh_form_procure.setBusinessFormCode(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormProcure_mapper.WarehouseName);
        if (columnIndex > 0) {
            l_wh_form_procure.setWarehouseName(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormProcure_mapper.BuyerId);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_form_procure.setBuyerId(null);
            } else {
                l_wh_form_procure.setBuyerId(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormProcure_mapper.BuyerName);
        if (columnIndex > 0) {
            l_wh_form_procure.setBuyerName(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormProcure_mapper.ProcureTime);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_form_procure.setProcureTime(null);
            } else {
                l_wh_form_procure.setProcureTime(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormProcure_mapper.ProcureDoc);
        if (columnIndex > 0) {
            l_wh_form_procure.setProcureDoc(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormProcure_mapper.BuyType);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_form_procure.setBuyType(null);
            } else {
                l_wh_form_procure.setBuyType(rs.getInt(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormProcure_mapper.States);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_form_procure.setStates(null);
            } else {
                l_wh_form_procure.setStates(rs.getInt(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormProcure_mapper.AgencyId);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_form_procure.setAgencyId(null);
            } else {
                l_wh_form_procure.setAgencyId(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormProcure_mapper.AgencyName);
        if (columnIndex > 0) {
            l_wh_form_procure.setAgencyName(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormProcure_mapper.IncomeId);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_form_procure.setIncomeId(null);
            } else {
                l_wh_form_procure.setIncomeId(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormProcure_mapper.IncomeName);
        if (columnIndex > 0) {
            l_wh_form_procure.setIncomeName(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormProcure_mapper.IncomeTime);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_form_procure.setIncomeTime(null);
            } else {
                l_wh_form_procure.setIncomeTime(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormProcure_mapper.WarehouseId);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_form_procure.setWarehouseId(null);
            } else {
                l_wh_form_procure.setWarehouseId(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormProcure_mapper.Beiz);
        if (columnIndex > 0) {
            l_wh_form_procure.setBeiz(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormProcure_mapper.LWarehouseFlowId);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_form_procure.setLWarehouseFlowId(null);
            } else {
                l_wh_form_procure.setLWarehouseFlowId(rs.getLong(columnIndex));
            }
        }
        return l_wh_form_procure;
    }
}

 consum-model-pojo/src/main/java/com/consum/model/po/LWhGoods.java

New file
@@ -0,0 +1,370 @@

package com.consum.model.po;

import com.fasterxml.jackson.annotation.JsonAutoDetect;
import com.fasterxml.jackson.annotation.JsonIgnore;
import com.walker.jdbc.BasePo;

/**
 * è¡¨å:L_WH_GOODS *
 * @author genrator
 */
@JsonAutoDetect(fieldVisibility = JsonAutoDetect.Visibility.ANY)
public class LWhGoods extends BasePo<LWhGoods> {
    // åºåˆ—化版本号
    private static final long serialVersionUID = 1L;

    // ä¸»é”®
    private Long id = null;
    @JsonIgnore
    protected boolean isset_id = false;

    // å±žæ€§åˆ—表
    private Long warehouseId = null;
    @JsonIgnore
    protected boolean isset_warehouseId = false;

    private String warehouseName = null;
    @JsonIgnore
    protected boolean isset_warehouseName = false;

    private Integer costType = null;
    @JsonIgnore
    protected boolean isset_costType = false;

    private Long baseGoodsTemplateId = null;
    @JsonIgnore
    protected boolean isset_baseGoodsTemplateId = false;

    private String goodsTemplateName = null;
    @JsonIgnore
    protected boolean isset_goodsTemplateName = false;

    private Long baseGoodsModelsId = null;
    @JsonIgnore
    protected boolean isset_baseGoodsModelsId = false;

    private String baseGoodsModelsName = null;
    @JsonIgnore
    protected boolean isset_baseGoodsModelsName = false;

    private String supplier = null;
    @JsonIgnore
    protected boolean isset_supplier = false;

    private Integer buyType = null;
    @JsonIgnore
    protected boolean isset_buyType = false;

    private String unit = null;
    @JsonIgnore
    protected boolean isset_unit = false;

    private Double price = null;
    @JsonIgnore
    protected boolean isset_price = false;

    private Long procureDate = null;
    @JsonIgnore
    protected boolean isset_procureDate = false;

    private Integer states = null;
    @JsonIgnore
    protected boolean isset_states = false;

    /**
     * é»˜è®¤æž„造函数
     */
    public LWhGoods() {
    }

    /**
     * æ ¹æ®ä¸»é”®æž„造对象
     */
    public LWhGoods(Long id) {
        this.setId(id);
    }

    /**
     * è®¾ç½®ä¸»é”®å€¼
     */
    @Override
    public void setPkValue(Object value) {
        this.setId((Long) value);
    }

    public Long getId() {
        return this.id;
    }

    public void setId(Long id) {
        this.id = id;
        this.isset_id = true;
    }

    @JsonIgnore
    public boolean isEmptyId() {
        return this.id == null;
    }

    public Long getWarehouseId() {
        return this.warehouseId;
    }

    public void setWarehouseId(Long warehouseId) {
        this.warehouseId = warehouseId;
        this.isset_warehouseId = true;
    }

    @JsonIgnore
    public boolean isEmptyWarehouseId() {
        return this.warehouseId == null;
    }

    public String getWarehouseName() {
        return this.warehouseName;
    }

    public void setWarehouseName(String warehouseName) {
        this.warehouseName = warehouseName;
        this.isset_warehouseName = true;
    }

    @JsonIgnore
    public boolean isEmptyWarehouseName() {
        return this.warehouseName == null || this.warehouseName.length() == 0;
    }

    public Integer getCostType() {
        return this.costType;
    }

    public void setCostType(Integer costType) {
        this.costType = costType;
        this.isset_costType = true;
    }

    @JsonIgnore
    public boolean isEmptyCostType() {
        return this.costType == null;
    }

    public Long getBaseGoodsTemplateId() {
        return this.baseGoodsTemplateId;
    }

    public void setBaseGoodsTemplateId(Long baseGoodsTemplateId) {
        this.baseGoodsTemplateId = baseGoodsTemplateId;
        this.isset_baseGoodsTemplateId = true;
    }

    @JsonIgnore
    public boolean isEmptyBaseGoodsTemplateId() {
        return this.baseGoodsTemplateId == null;
    }

    public String getGoodsTemplateName() {
        return this.goodsTemplateName;
    }

    public void setGoodsTemplateName(String goodsTemplateName) {
        this.goodsTemplateName = goodsTemplateName;
        this.isset_goodsTemplateName = true;
    }

    @JsonIgnore
    public boolean isEmptyGoodsTemplateName() {
        return this.goodsTemplateName == null || this.goodsTemplateName.length() == 0;
    }

    public Long getBaseGoodsModelsId() {
        return this.baseGoodsModelsId;
    }

    public void setBaseGoodsModelsId(Long baseGoodsModelsId) {
        this.baseGoodsModelsId = baseGoodsModelsId;
        this.isset_baseGoodsModelsId = true;
    }

    @JsonIgnore
    public boolean isEmptyBaseGoodsModelsId() {
        return this.baseGoodsModelsId == null;
    }

    public String getBaseGoodsModelsName() {
        return this.baseGoodsModelsName;
    }

    public void setBaseGoodsModelsName(String baseGoodsModelsName) {
        this.baseGoodsModelsName = baseGoodsModelsName;
        this.isset_baseGoodsModelsName = true;
    }

    @JsonIgnore
    public boolean isEmptyBaseGoodsModelsName() {
        return this.baseGoodsModelsName == null || this.baseGoodsModelsName.length() == 0;
    }

    public String getSupplier() {
        return this.supplier;
    }

    public void setSupplier(String supplier) {
        this.supplier = supplier;
        this.isset_supplier = true;
    }

    @JsonIgnore
    public boolean isEmptySupplier() {
        return this.supplier == null || this.supplier.length() == 0;
    }

    public Integer getBuyType() {
        return this.buyType;
    }

    public void setBuyType(Integer buyType) {
        this.buyType = buyType;
        this.isset_buyType = true;
    }

    @JsonIgnore
    public boolean isEmptyBuyType() {
        return this.buyType == null;
    }

    public String getUnit() {
        return this.unit;
    }

    public void setUnit(String unit) {
        this.unit = unit;
        this.isset_unit = true;
    }

    @JsonIgnore
    public boolean isEmptyUnit() {
        return this.unit == null || this.unit.length() == 0;
    }

    public Double getPrice() {
        return this.price;
    }

    public void setPrice(Double price) {
        this.price = price;
        this.isset_price = true;
    }

    @JsonIgnore
    public boolean isEmptyPrice() {
        return this.price == null;
    }

    public Long getProcureDate() {
        return this.procureDate;
    }

    public void setProcureDate(Long procureDate) {
        this.procureDate = procureDate;
        this.isset_procureDate = true;
    }

    @JsonIgnore
    public boolean isEmptyProcureDate() {
        return this.procureDate == null;
    }

    public Integer getStates() {
        return this.states;
    }

    public void setStates(Integer states) {
        this.states = states;
        this.isset_states = true;
    }

    @JsonIgnore
    public boolean isEmptyStates() {
        return this.states == null;
    }

    /**
     * é‡å†™ toString() æ–¹æ³•
     */
    @Override
    public String toString() {
        return new StringBuilder()
                .append("id=").append(this.id)
                .append("warehouseId=").append(this.warehouseId)
                .append("warehouseName=").append(this.warehouseName)
                .append("costType=").append(this.costType)
                .append("baseGoodsTemplateId=").append(this.baseGoodsTemplateId)
                .append("goodsTemplateName=").append(this.goodsTemplateName)
                .append("baseGoodsModelsId=").append(this.baseGoodsModelsId)
                .append("baseGoodsModelsName=").append(this.baseGoodsModelsName)
                .append("supplier=").append(this.supplier)
                .append("buyType=").append(this.buyType)
                .append("unit=").append(this.unit)
                .append("price=").append(this.price)
                .append("procureDate=").append(this.procureDate)
                .append("states=").append(this.states)
                .toString();
    }

    /**
     * å…‹éš†
     */
    public LWhGoods $clone() {
        LWhGoods l_wh_goods = new LWhGoods();

        // æ•°æ®åº“名称
        //l_wh_goods.setDatabaseName_(this.getDatabaseName_());

        // ä¸»é”®
        if (this.isset_id) {
            l_wh_goods.setId(this.getId());
        }
        // æ™®é€šå±žæ€§
        if (this.isset_warehouseId) {
            l_wh_goods.setWarehouseId(this.getWarehouseId());
        }
        if (this.isset_warehouseName) {
            l_wh_goods.setWarehouseName(this.getWarehouseName());
        }
        if (this.isset_costType) {
            l_wh_goods.setCostType(this.getCostType());
        }
        if (this.isset_baseGoodsTemplateId) {
            l_wh_goods.setBaseGoodsTemplateId(this.getBaseGoodsTemplateId());
        }
        if (this.isset_goodsTemplateName) {
            l_wh_goods.setGoodsTemplateName(this.getGoodsTemplateName());
        }
        if (this.isset_baseGoodsModelsId) {
            l_wh_goods.setBaseGoodsModelsId(this.getBaseGoodsModelsId());
        }
        if (this.isset_baseGoodsModelsName) {
            l_wh_goods.setBaseGoodsModelsName(this.getBaseGoodsModelsName());
        }
        if (this.isset_supplier) {
            l_wh_goods.setSupplier(this.getSupplier());
        }
        if (this.isset_buyType) {
            l_wh_goods.setBuyType(this.getBuyType());
        }
        if (this.isset_unit) {
            l_wh_goods.setUnit(this.getUnit());
        }
        if (this.isset_price) {
            l_wh_goods.setPrice(this.getPrice());
        }
        if (this.isset_procureDate) {
            l_wh_goods.setProcureDate(this.getProcureDate());
        }
        if (this.isset_states) {
            l_wh_goods.setStates(this.getStates());
        }
        return l_wh_goods;
    }
}

 consum-model-pojo/src/main/java/com/consum/model/po/LWhGoodsRecord.java

New file
@@ -0,0 +1,304 @@

package com.consum.model.po;

import com.fasterxml.jackson.annotation.JsonAutoDetect;
import com.fasterxml.jackson.annotation.JsonIgnore;
import com.walker.jdbc.BasePo;

/**
 * è¡¨å:L_WH_GOODS_RECORD *
 * @author genrator
 */
@JsonAutoDetect(fieldVisibility = JsonAutoDetect.Visibility.ANY)
public class LWhGoodsRecord extends BasePo<LWhGoodsRecord> {
    // åºåˆ—化版本号
    private static final long serialVersionUID = 1L;

    // ä¸»é”®
    private Long id = null;
    @JsonIgnore
    protected boolean isset_id = false;

    // å±žæ€§åˆ—表
    private Long lWarehouseFlowId = null;
    @JsonIgnore
    protected boolean isset_lWarehouseFlowId = false;

    private Long warehouseFlowId = null;
    @JsonIgnore
    protected boolean isset_warehouseFlowId = false;

    private Integer initialCount = null;
    @JsonIgnore
    protected boolean isset_initialCount = false;

    private Integer thisType = null;
    @JsonIgnore
    protected boolean isset_thisType = false;

    private Integer thisCount = null;
    @JsonIgnore
    protected boolean isset_thisCount = false;

    private Integer endCount = null;
    @JsonIgnore
    protected boolean isset_endCount = false;

    private Long baseGoodsTemplateId = null;
    @JsonIgnore
    protected boolean isset_baseGoodsTemplateId = false;

    private String goodsTemplateName = null;
    @JsonIgnore
    protected boolean isset_goodsTemplateName = false;

    private Long baseGoodsModelsId = null;
    @JsonIgnore
    protected boolean isset_baseGoodsModelsId = false;

    private String baseGoodsModelsName = null;
    @JsonIgnore
    protected boolean isset_baseGoodsModelsName = false;

    /**
     * é»˜è®¤æž„造函数
     */
    public LWhGoodsRecord() {
    }

    /**
     * æ ¹æ®ä¸»é”®æž„造对象
     */
    public LWhGoodsRecord(Long id) {
        this.setId(id);
    }

    /**
     * è®¾ç½®ä¸»é”®å€¼
     */
    @Override
    public void setPkValue(Object value) {
        this.setId((Long) value);
    }

    public Long getId() {
        return this.id;
    }

    public void setId(Long id) {
        this.id = id;
        this.isset_id = true;
    }

    @JsonIgnore
    public boolean isEmptyId() {
        return this.id == null;
    }

    public Long getLWarehouseFlowId() {
        return this.lWarehouseFlowId;
    }

    public void setLWarehouseFlowId(Long lWarehouseFlowId) {
        this.lWarehouseFlowId = lWarehouseFlowId;
        this.isset_lWarehouseFlowId = true;
    }

    @JsonIgnore
    public boolean isEmptyLWarehouseFlowId() {
        return this.lWarehouseFlowId == null;
    }

    public Long getWarehouseFlowId() {
        return this.warehouseFlowId;
    }

    public void setWarehouseFlowId(Long warehouseFlowId) {
        this.warehouseFlowId = warehouseFlowId;
        this.isset_warehouseFlowId = true;
    }

    @JsonIgnore
    public boolean isEmptyWarehouseFlowId() {
        return this.warehouseFlowId == null;
    }

    public Integer getInitialCount() {
        return this.initialCount;
    }

    public void setInitialCount(Integer initialCount) {
        this.initialCount = initialCount;
        this.isset_initialCount = true;
    }

    @JsonIgnore
    public boolean isEmptyInitialCount() {
        return this.initialCount == null;
    }

    public Integer getThisType() {
        return this.thisType;
    }

    public void setThisType(Integer thisType) {
        this.thisType = thisType;
        this.isset_thisType = true;
    }

    @JsonIgnore
    public boolean isEmptyThisType() {
        return this.thisType == null;
    }

    public Integer getThisCount() {
        return this.thisCount;
    }

    public void setThisCount(Integer thisCount) {
        this.thisCount = thisCount;
        this.isset_thisCount = true;
    }

    @JsonIgnore
    public boolean isEmptyThisCount() {
        return this.thisCount == null;
    }

    public Integer getEndCount() {
        return this.endCount;
    }

    public void setEndCount(Integer endCount) {
        this.endCount = endCount;
        this.isset_endCount = true;
    }

    @JsonIgnore
    public boolean isEmptyEndCount() {
        return this.endCount == null;
    }

    public Long getBaseGoodsTemplateId() {
        return this.baseGoodsTemplateId;
    }

    public void setBaseGoodsTemplateId(Long baseGoodsTemplateId) {
        this.baseGoodsTemplateId = baseGoodsTemplateId;
        this.isset_baseGoodsTemplateId = true;
    }

    @JsonIgnore
    public boolean isEmptyBaseGoodsTemplateId() {
        return this.baseGoodsTemplateId == null;
    }

    public String getGoodsTemplateName() {
        return this.goodsTemplateName;
    }

    public void setGoodsTemplateName(String goodsTemplateName) {
        this.goodsTemplateName = goodsTemplateName;
        this.isset_goodsTemplateName = true;
    }

    @JsonIgnore
    public boolean isEmptyGoodsTemplateName() {
        return this.goodsTemplateName == null || this.goodsTemplateName.length() == 0;
    }

    public Long getBaseGoodsModelsId() {
        return this.baseGoodsModelsId;
    }

    public void setBaseGoodsModelsId(Long baseGoodsModelsId) {
        this.baseGoodsModelsId = baseGoodsModelsId;
        this.isset_baseGoodsModelsId = true;
    }

    @JsonIgnore
    public boolean isEmptyBaseGoodsModelsId() {
        return this.baseGoodsModelsId == null;
    }

    public String getBaseGoodsModelsName() {
        return this.baseGoodsModelsName;
    }

    public void setBaseGoodsModelsName(String baseGoodsModelsName) {
        this.baseGoodsModelsName = baseGoodsModelsName;
        this.isset_baseGoodsModelsName = true;
    }

    @JsonIgnore
    public boolean isEmptyBaseGoodsModelsName() {
        return this.baseGoodsModelsName == null || this.baseGoodsModelsName.length() == 0;
    }

    /**
     * é‡å†™ toString() æ–¹æ³•
     */
    @Override
    public String toString() {
        return new StringBuilder()
                .append("id=").append(this.id)
                .append("lWarehouseFlowId=").append(this.lWarehouseFlowId)
                .append("warehouseFlowId=").append(this.warehouseFlowId)
                .append("initialCount=").append(this.initialCount)
                .append("thisType=").append(this.thisType)
                .append("thisCount=").append(this.thisCount)
                .append("endCount=").append(this.endCount)
                .append("baseGoodsTemplateId=").append(this.baseGoodsTemplateId)
                .append("goodsTemplateName=").append(this.goodsTemplateName)
                .append("baseGoodsModelsId=").append(this.baseGoodsModelsId)
                .append("baseGoodsModelsName=").append(this.baseGoodsModelsName)
                .toString();
    }

    /**
     * å…‹éš†
     */
    public LWhGoodsRecord $clone() {
        LWhGoodsRecord l_wh_goods_record = new LWhGoodsRecord();

        // æ•°æ®åº“名称
        //l_wh_goods_record.setDatabaseName_(this.getDatabaseName_());

        // ä¸»é”®
        if (this.isset_id) {
            l_wh_goods_record.setId(this.getId());
        }
        // æ™®é€šå±žæ€§
        if (this.isset_lWarehouseFlowId) {
            l_wh_goods_record.setLWarehouseFlowId(this.getLWarehouseFlowId());
        }
        if (this.isset_warehouseFlowId) {
            l_wh_goods_record.setWarehouseFlowId(this.getWarehouseFlowId());
        }
        if (this.isset_initialCount) {
            l_wh_goods_record.setInitialCount(this.getInitialCount());
        }
        if (this.isset_thisType) {
            l_wh_goods_record.setThisType(this.getThisType());
        }
        if (this.isset_thisCount) {
            l_wh_goods_record.setThisCount(this.getThisCount());
        }
        if (this.isset_endCount) {
            l_wh_goods_record.setEndCount(this.getEndCount());
        }
        if (this.isset_baseGoodsTemplateId) {
            l_wh_goods_record.setBaseGoodsTemplateId(this.getBaseGoodsTemplateId());
        }
        if (this.isset_goodsTemplateName) {
            l_wh_goods_record.setGoodsTemplateName(this.getGoodsTemplateName());
        }
        if (this.isset_baseGoodsModelsId) {
            l_wh_goods_record.setBaseGoodsModelsId(this.getBaseGoodsModelsId());
        }
        if (this.isset_baseGoodsModelsName) {
            l_wh_goods_record.setBaseGoodsModelsName(this.getBaseGoodsModelsName());
        }
        return l_wh_goods_record;
    }
}

 consum-model-pojo/src/main/java/com/consum/model/po/LWhGoodsRecordDetails.java

New file
@@ -0,0 +1,150 @@

package com.consum.model.po;

import com.fasterxml.jackson.annotation.JsonAutoDetect;
import com.fasterxml.jackson.annotation.JsonIgnore;
import com.walker.jdbc.BasePo;

/**
 * è¡¨å:L_WH_GOODS_RECORD_DETAILS *
 * @author genrator
 */
@JsonAutoDetect(fieldVisibility = JsonAutoDetect.Visibility.ANY)
public class LWhGoodsRecordDetails extends BasePo<LWhGoodsRecordDetails> {
    // åºåˆ—化版本号
    private static final long serialVersionUID = 1L;

    // ä¸»é”®
    private Long id = null;
    @JsonIgnore
    protected boolean isset_id = false;

    // å±žæ€§åˆ—表
    private Long lWhGoodsRecordId = null;
    @JsonIgnore
    protected boolean isset_lWhGoodsRecordId = false;

    private Long lWhGoodsId = null;
    @JsonIgnore
    protected boolean isset_lWhGoodsId = false;

    private Integer thisType = null;
    @JsonIgnore
    protected boolean isset_thisType = false;

    /**
     * é»˜è®¤æž„造函数
     */
    public LWhGoodsRecordDetails() {
    }

    /**
     * æ ¹æ®ä¸»é”®æž„造对象
     */
    public LWhGoodsRecordDetails(Long id) {
        this.setId(id);
    }

    /**
     * è®¾ç½®ä¸»é”®å€¼
     */
    @Override
    public void setPkValue(Object value) {
        this.setId((Long) value);
    }

    public Long getId() {
        return this.id;
    }

    public void setId(Long id) {
        this.id = id;
        this.isset_id = true;
    }

    @JsonIgnore
    public boolean isEmptyId() {
        return this.id == null;
    }

    public Long getLWhGoodsRecordId() {
        return this.lWhGoodsRecordId;
    }

    public void setLWhGoodsRecordId(Long lWhGoodsRecordId) {
        this.lWhGoodsRecordId = lWhGoodsRecordId;
        this.isset_lWhGoodsRecordId = true;
    }

    @JsonIgnore
    public boolean isEmptyLWhGoodsRecordId() {
        return this.lWhGoodsRecordId == null;
    }

    public Long getLWhGoodsId() {
        return this.lWhGoodsId;
    }

    public void setLWhGoodsId(Long lWhGoodsId) {
        this.lWhGoodsId = lWhGoodsId;
        this.isset_lWhGoodsId = true;
    }

    @JsonIgnore
    public boolean isEmptyLWhGoodsId() {
        return this.lWhGoodsId == null;
    }

    public Integer getThisType() {
        return this.thisType;
    }

    public void setThisType(Integer thisType) {
        this.thisType = thisType;
        this.isset_thisType = true;
    }

    @JsonIgnore
    public boolean isEmptyThisType() {
        return this.thisType == null;
    }

    /**
     * é‡å†™ toString() æ–¹æ³•
     */
    @Override
    public String toString() {
        return new StringBuilder()
                .append("id=").append(this.id)
                .append("lWhGoodsRecordId=").append(this.lWhGoodsRecordId)
                .append("lWhGoodsId=").append(this.lWhGoodsId)
                .append("thisType=").append(this.thisType)
                .toString();
    }

    /**
     * å…‹éš†
     */
    public LWhGoodsRecordDetails $clone() {
        LWhGoodsRecordDetails l_wh_goods_record_details = new LWhGoodsRecordDetails();

        // æ•°æ®åº“名称
        //l_wh_goods_record_details.setDatabaseName_(this.getDatabaseName_());

        // ä¸»é”®
        if (this.isset_id) {
            l_wh_goods_record_details.setId(this.getId());
        }
        // æ™®é€šå±žæ€§
        if (this.isset_lWhGoodsRecordId) {
            l_wh_goods_record_details.setLWhGoodsRecordId(this.getLWhGoodsRecordId());
        }
        if (this.isset_lWhGoodsId) {
            l_wh_goods_record_details.setLWhGoodsId(this.getLWhGoodsId());
        }
        if (this.isset_thisType) {
            l_wh_goods_record_details.setThisType(this.getThisType());
        }
        return l_wh_goods_record_details;
    }
}

 consum-model-pojo/src/main/java/com/consum/model/po/LWhGoodsRecordDetails_mapper.java

New file
@@ -0,0 +1,255 @@
package com.consum.model.po;

import com.walker.jdbc.BaseMapper;
import com.walker.jdbc.ResultSetUtils;
import com.walker.jdbc.SqlAndParameters;
import com.walker.jdbc.sqlgen.DeleteBuilder;
import com.walker.jdbc.sqlgen.InsertBuilder;
import com.walker.jdbc.sqlgen.SelectBuilder;
import com.walker.jdbc.sqlgen.UpdateBuilder;
import org.springframework.jdbc.core.RowMapper;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Map;

/**
 * è¡¨å:L_WH_GOODS_RECORD_DETAILS *
 * @author genrator
 */
public class LWhGoodsRecordDetails_mapper extends LWhGoodsRecordDetails implements BaseMapper<LWhGoodsRecordDetails> {
    // åºåˆ—化版本号
    private static final long serialVersionUID = 1L;

    public static final RowMapper<LWhGoodsRecordDetails> ROW_MAPPER = new LWhGoodsRecordDetailsRowMapper();

    // ä¸»é”®
    public static final String Id = "id";
    // æ™®é€šå±žæ€§
    public static final String LWhGoodsRecordId = "l_wh_goods_record_id";
    public static final String LWhGoodsId = "l_wh_goods_id";
    public static final String ThisType = "this_type";

    /**
     * é»˜è®¤æž„造函数
     */
    public LWhGoodsRecordDetails_mapper(LWhGoodsRecordDetails lWhGoodsRecordDetails) {
        if (lWhGoodsRecordDetails == null) {
            throw new IllegalArgumentException("po参数不允许为空！");
        }
        //主键
        if (lWhGoodsRecordDetails.isset_id) {
            this.setId(lWhGoodsRecordDetails.getId());
        }
        //普通属性
        if (lWhGoodsRecordDetails.isset_lWhGoodsRecordId) {
            this.setLWhGoodsRecordId(lWhGoodsRecordDetails.getLWhGoodsRecordId());
        }
        if (lWhGoodsRecordDetails.isset_lWhGoodsId) {
            this.setLWhGoodsId(lWhGoodsRecordDetails.getLWhGoodsId());
        }
        if (lWhGoodsRecordDetails.isset_thisType) {
            this.setThisType(lWhGoodsRecordDetails.getThisType());
        }
        // åŽ»æŽ‰ï¼Œ2022-09-07
        // this.setDatabaseName_(l_wh_goods_record_details.getDatabaseName_());
    }

    /**
     * èŽ·å–表名
     */
    @Override
    public String getTableName_() {
        String tableName = "l_wh_goods_record_details";
        /**
        if (StringUtils.isNotEmpty(this.getDatabaseName_())) {
            return this.getDatabaseName_() + "." + tableName;
        } else {
            return tableName;
        }
        */
        return tableName;
    }

    /**
     * èŽ·å–主键名称
     */
    @Override
    public String getPkName_() {
        return Id;
    }

    /**
     * èŽ·å–主键值
     */
    @Override
    public Object getPkValue_() {
        return this.getId();
    }

    /**
     * èŽ·å–插入语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getInsertSql_() {
        InsertBuilder ib = new InsertBuilder(this.getTableName_());
        ib.set(Id, this.getId());
        ib.set(LWhGoodsRecordId, this.getLWhGoodsRecordId(), this.isset_lWhGoodsRecordId);
        ib.set(LWhGoodsId, this.getLWhGoodsId(), this.isset_lWhGoodsId);
        ib.set(ThisType, this.getThisType(), this.isset_thisType);
        return ib.genMapSql();
    }

    /**
     * èŽ·å–更新语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getUpdateSql_() {
        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
        ub.set(LWhGoodsRecordId, this.getLWhGoodsRecordId(), this.isset_lWhGoodsRecordId);
        ub.set(LWhGoodsId, this.getLWhGoodsId(), this.isset_lWhGoodsId);
        ub.set(ThisType, this.getThisType(), this.isset_thisType);
        ub.where(this.getPkName_(), this.getPkValue_());
        return ub.genMapSql();
    }

    /**
     * èŽ·å–更新语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getUpdateSql_(String where, Map<String, Object> parameters) {
        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
        ub.set(LWhGoodsRecordId, this.getLWhGoodsRecordId(), this.isset_lWhGoodsRecordId);
        ub.set(LWhGoodsId, this.getLWhGoodsId(), this.isset_lWhGoodsId);
        ub.set(ThisType, this.getThisType(), this.isset_thisType);
        return ub.genMapSql(where, parameters);
    }

    /**
     * èŽ·å–更新语句和参数
     */
    @Override
    public SqlAndParameters<Object[]> getUpdateSql_(String where, Object[] parameters) {
        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
        ub.set(LWhGoodsRecordId, this.getLWhGoodsRecordId(), this.isset_lWhGoodsRecordId);
        ub.set(LWhGoodsId, this.getLWhGoodsId(), this.isset_lWhGoodsId);
        ub.set(ThisType, this.getThisType(), this.isset_thisType);
        return ub.genArraySql(where, parameters);
    }

    /**
     * èŽ·å–删除语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getDeleteSql_() {
        DeleteBuilder db = new DeleteBuilder(this.getTableName_());
        db.where(this.getPkName_(), this.getPkValue_());
        return db.genMapSql();
    }

    /**
     * èŽ·å–删除语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getDeleteSql_(String where, Map<String, Object> parameters) {
        DeleteBuilder db = new DeleteBuilder(this.getTableName_());
        return db.genMapSql(where, parameters);
    }

    /**
     * èŽ·å–删除语句和参数
     */
    @Override
    public SqlAndParameters<Object[]> getDeleteSql_(String where, Object[] parameters) {
        DeleteBuilder db = new DeleteBuilder(this.getTableName_());
        return db.genArraySql(where, parameters);
    }

    /**
     * èŽ·å–单行查询语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getSingleSql_() {
        SelectBuilder sb = new SelectBuilder(this.getTableName_());
        sb.where(this.getPkName_(), this.getPkValue_());
        return sb.genMapSql();
    }


    /**
     * èŽ·å–查询语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) {
        return new SqlAndParameters<>("select id, l_wh_goods_record_id, l_wh_goods_id, this_type from " + this.getTableName_() + " " + where, parameters);
    }

    /**
     * èŽ·å–查询语句和参数
     */
    @Override
    public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) {
        return new SqlAndParameters<>("select id, l_wh_goods_record_id, l_wh_goods_id, this_type from " + this.getTableName_() + " " + where, parameters);
    }

    /**
     * å°†resultset的一行转化为po
     */
    @Override
    public LWhGoodsRecordDetails mapRow(ResultSet rs, int i) throws SQLException {
        return ROW_MAPPER.mapRow(rs, i);
    }

    /**
     * å…‹éš†
     */
    public LWhGoodsRecordDetails toLWhGoodsRecordDetails() {
        return super.$clone();
    }
}

/**
 * l_wh_goods_record_details RowMapper
 *
 * @author genrator
 */
class LWhGoodsRecordDetailsRowMapper implements RowMapper<LWhGoodsRecordDetails> {

    @Override
    public LWhGoodsRecordDetails mapRow(ResultSet rs, int i) throws SQLException {
        ResultSetUtils resultSetUtils = new ResultSetUtils();
        LWhGoodsRecordDetails l_wh_goods_record_details = new LWhGoodsRecordDetails();
        Integer columnIndex;
        //主键
        columnIndex = resultSetUtils.findColumn(rs, LWhGoodsRecordDetails_mapper.Id);
        if (columnIndex > 0) {
            l_wh_goods_record_details.setId(rs.getLong(columnIndex));
        }
        //普通属性
        columnIndex = resultSetUtils.findColumn(rs, LWhGoodsRecordDetails_mapper.LWhGoodsRecordId);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_goods_record_details.setLWhGoodsRecordId(null);
            } else {
                l_wh_goods_record_details.setLWhGoodsRecordId(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhGoodsRecordDetails_mapper.LWhGoodsId);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_goods_record_details.setLWhGoodsId(null);
            } else {
                l_wh_goods_record_details.setLWhGoodsId(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhGoodsRecordDetails_mapper.ThisType);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_goods_record_details.setThisType(null);
            } else {
                l_wh_goods_record_details.setThisType(rs.getInt(columnIndex));
            }
        }
        return l_wh_goods_record_details;
    }
}

 consum-model-pojo/src/main/java/com/consum/model/po/LWhGoodsRecord_mapper.java

New file
@@ -0,0 +1,361 @@
package com.consum.model.po;

import com.walker.jdbc.BaseMapper;
import com.walker.jdbc.ResultSetUtils;
import com.walker.jdbc.SqlAndParameters;
import com.walker.jdbc.sqlgen.DeleteBuilder;
import com.walker.jdbc.sqlgen.InsertBuilder;
import com.walker.jdbc.sqlgen.SelectBuilder;
import com.walker.jdbc.sqlgen.UpdateBuilder;
import com.walker.jdbc.util.StringUtils;

import org.springframework.jdbc.core.RowMapper;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Map;

/**
 * è¡¨å:L_WH_GOODS_RECORD *
 * @author genrator
 */
public class LWhGoodsRecord_mapper extends LWhGoodsRecord implements BaseMapper<LWhGoodsRecord> {
    // åºåˆ—化版本号
    private static final long serialVersionUID = 1L;

    public static final RowMapper<LWhGoodsRecord> ROW_MAPPER = new LWhGoodsRecordRowMapper();

    // ä¸»é”®
    public static final String Id = "id";
    // æ™®é€šå±žæ€§
    public static final String LWarehouseFlowId = "l_warehouse_flow_id";
    public static final String WarehouseFlowId = "warehouse_flow_id";
    public static final String InitialCount = "initial_count";
    public static final String ThisType = "this_type";
    public static final String ThisCount = "this_count";
    public static final String EndCount = "end_count";
    public static final String BaseGoodsTemplateId = "base_goods_template_id";
    public static final String GoodsTemplateName = "goods_template_name";
    public static final String BaseGoodsModelsId = "base_goods_models_id";
    public static final String BaseGoodsModelsName = "base_goods_models_name";

    /**
     * é»˜è®¤æž„造函数
     */
    public LWhGoodsRecord_mapper(LWhGoodsRecord lWhGoodsRecord) {
        if (lWhGoodsRecord == null) {
            throw new IllegalArgumentException("po参数不允许为空！");
        }
        //主键
        if (lWhGoodsRecord.isset_id) {
            this.setId(lWhGoodsRecord.getId());
        }
        //普通属性
        if (lWhGoodsRecord.isset_lWarehouseFlowId) {
            this.setLWarehouseFlowId(lWhGoodsRecord.getLWarehouseFlowId());
        }
        if (lWhGoodsRecord.isset_warehouseFlowId) {
            this.setWarehouseFlowId(lWhGoodsRecord.getWarehouseFlowId());
        }
        if (lWhGoodsRecord.isset_initialCount) {
            this.setInitialCount(lWhGoodsRecord.getInitialCount());
        }
        if (lWhGoodsRecord.isset_thisType) {
            this.setThisType(lWhGoodsRecord.getThisType());
        }
        if (lWhGoodsRecord.isset_thisCount) {
            this.setThisCount(lWhGoodsRecord.getThisCount());
        }
        if (lWhGoodsRecord.isset_endCount) {
            this.setEndCount(lWhGoodsRecord.getEndCount());
        }
        if (lWhGoodsRecord.isset_baseGoodsTemplateId) {
            this.setBaseGoodsTemplateId(lWhGoodsRecord.getBaseGoodsTemplateId());
        }
        if (lWhGoodsRecord.isset_goodsTemplateName) {
            this.setGoodsTemplateName(lWhGoodsRecord.getGoodsTemplateName());
        }
        if (lWhGoodsRecord.isset_baseGoodsModelsId) {
            this.setBaseGoodsModelsId(lWhGoodsRecord.getBaseGoodsModelsId());
        }
        if (lWhGoodsRecord.isset_baseGoodsModelsName) {
            this.setBaseGoodsModelsName(lWhGoodsRecord.getBaseGoodsModelsName());
        }
        // åŽ»æŽ‰ï¼Œ2022-09-07
        // this.setDatabaseName_(l_wh_goods_record.getDatabaseName_());
    }

    /**
     * èŽ·å–表名
     */
    @Override
    public String getTableName_() {
        String tableName = "l_wh_goods_record";
        /**
        if (StringUtils.isNotEmpty(this.getDatabaseName_())) {
            return this.getDatabaseName_() + "." + tableName;
        } else {
            return tableName;
        }
        */
        return tableName;
    }

    /**
     * èŽ·å–主键名称
     */
    @Override
    public String getPkName_() {
        return Id;
    }

    /**
     * èŽ·å–主键值
     */
    @Override
    public Object getPkValue_() {
        return this.getId();
    }

    /**
     * èŽ·å–插入语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getInsertSql_() {
        InsertBuilder ib = new InsertBuilder(this.getTableName_());
        ib.set(Id, this.getId());
        ib.set(LWarehouseFlowId, this.getLWarehouseFlowId(), this.isset_lWarehouseFlowId);
        ib.set(WarehouseFlowId, this.getWarehouseFlowId(), this.isset_warehouseFlowId);
        ib.set(InitialCount, this.getInitialCount(), this.isset_initialCount);
        ib.set(ThisType, this.getThisType(), this.isset_thisType);
        ib.set(ThisCount, this.getThisCount(), this.isset_thisCount);
        ib.set(EndCount, this.getEndCount(), this.isset_endCount);
        ib.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId);
        ib.set(GoodsTemplateName, this.getGoodsTemplateName(), this.isset_goodsTemplateName);
        ib.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId);
        ib.set(BaseGoodsModelsName, this.getBaseGoodsModelsName(), this.isset_baseGoodsModelsName);
        return ib.genMapSql();
    }

    /**
     * èŽ·å–更新语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getUpdateSql_() {
        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
        ub.set(LWarehouseFlowId, this.getLWarehouseFlowId(), this.isset_lWarehouseFlowId);
        ub.set(WarehouseFlowId, this.getWarehouseFlowId(), this.isset_warehouseFlowId);
        ub.set(InitialCount, this.getInitialCount(), this.isset_initialCount);
        ub.set(ThisType, this.getThisType(), this.isset_thisType);
        ub.set(ThisCount, this.getThisCount(), this.isset_thisCount);
        ub.set(EndCount, this.getEndCount(), this.isset_endCount);
        ub.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId);
        ub.set(GoodsTemplateName, this.getGoodsTemplateName(), this.isset_goodsTemplateName);
        ub.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId);
        ub.set(BaseGoodsModelsName, this.getBaseGoodsModelsName(), this.isset_baseGoodsModelsName);
        ub.where(this.getPkName_(), this.getPkValue_());
        return ub.genMapSql();
    }

    /**
     * èŽ·å–更新语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getUpdateSql_(String where, Map<String, Object> parameters) {
        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
        ub.set(LWarehouseFlowId, this.getLWarehouseFlowId(), this.isset_lWarehouseFlowId);
        ub.set(WarehouseFlowId, this.getWarehouseFlowId(), this.isset_warehouseFlowId);
        ub.set(InitialCount, this.getInitialCount(), this.isset_initialCount);
        ub.set(ThisType, this.getThisType(), this.isset_thisType);
        ub.set(ThisCount, this.getThisCount(), this.isset_thisCount);
        ub.set(EndCount, this.getEndCount(), this.isset_endCount);
        ub.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId);
        ub.set(GoodsTemplateName, this.getGoodsTemplateName(), this.isset_goodsTemplateName);
        ub.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId);
        ub.set(BaseGoodsModelsName, this.getBaseGoodsModelsName(), this.isset_baseGoodsModelsName);
        return ub.genMapSql(where, parameters);
    }

    /**
     * èŽ·å–更新语句和参数
     */
    @Override
    public SqlAndParameters<Object[]> getUpdateSql_(String where, Object[] parameters) {
        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
        ub.set(LWarehouseFlowId, this.getLWarehouseFlowId(), this.isset_lWarehouseFlowId);
        ub.set(WarehouseFlowId, this.getWarehouseFlowId(), this.isset_warehouseFlowId);
        ub.set(InitialCount, this.getInitialCount(), this.isset_initialCount);
        ub.set(ThisType, this.getThisType(), this.isset_thisType);
        ub.set(ThisCount, this.getThisCount(), this.isset_thisCount);
        ub.set(EndCount, this.getEndCount(), this.isset_endCount);
        ub.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId);
        ub.set(GoodsTemplateName, this.getGoodsTemplateName(), this.isset_goodsTemplateName);
        ub.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId);
        ub.set(BaseGoodsModelsName, this.getBaseGoodsModelsName(), this.isset_baseGoodsModelsName);
        return ub.genArraySql(where, parameters);
    }

    /**
     * èŽ·å–删除语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getDeleteSql_() {
        DeleteBuilder db = new DeleteBuilder(this.getTableName_());
        db.where(this.getPkName_(), this.getPkValue_());
        return db.genMapSql();
    }

    /**
     * èŽ·å–删除语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getDeleteSql_(String where, Map<String, Object> parameters) {
        DeleteBuilder db = new DeleteBuilder(this.getTableName_());
        return db.genMapSql(where, parameters);
    }

    /**
     * èŽ·å–删除语句和参数
     */
    @Override
    public SqlAndParameters<Object[]> getDeleteSql_(String where, Object[] parameters) {
        DeleteBuilder db = new DeleteBuilder(this.getTableName_());
        return db.genArraySql(where, parameters);
    }

    /**
     * èŽ·å–单行查询语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getSingleSql_() {
        SelectBuilder sb = new SelectBuilder(this.getTableName_());
        sb.where(this.getPkName_(), this.getPkValue_());
        return sb.genMapSql();
    }


    /**
     * èŽ·å–查询语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) {
        return new SqlAndParameters<>("select id, l_warehouse_flow_id, warehouse_flow_id, initial_count, this_type, this_count, end_count, base_goods_template_id, goods_template_name, base_goods_models_id, base_goods_models_name from " + this.getTableName_() + " " + where, parameters);
    }

    /**
     * èŽ·å–查询语句和参数
     */
    @Override
    public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) {
        return new SqlAndParameters<>("select id, l_warehouse_flow_id, warehouse_flow_id, initial_count, this_type, this_count, end_count, base_goods_template_id, goods_template_name, base_goods_models_id, base_goods_models_name from " + this.getTableName_() + " " + where, parameters);
    }

    /**
     * å°†resultset的一行转化为po
     */
    @Override
    public LWhGoodsRecord mapRow(ResultSet rs, int i) throws SQLException {
        return ROW_MAPPER.mapRow(rs, i);
    }

    /**
     * å…‹éš†
     */
    public LWhGoodsRecord toLWhGoodsRecord() {
        return super.$clone();
    }
}

/**
 * l_wh_goods_record RowMapper
 *
 * @author genrator
 */
class LWhGoodsRecordRowMapper implements RowMapper<LWhGoodsRecord> {

    @Override
    public LWhGoodsRecord mapRow(ResultSet rs, int i) throws SQLException {
        ResultSetUtils resultSetUtils = new ResultSetUtils();
        LWhGoodsRecord l_wh_goods_record = new LWhGoodsRecord();
        Integer columnIndex;
        //主键
        columnIndex = resultSetUtils.findColumn(rs, LWhGoodsRecord_mapper.Id);
        if (columnIndex > 0) {
            l_wh_goods_record.setId(rs.getLong(columnIndex));
        }
        //普通属性
        columnIndex = resultSetUtils.findColumn(rs, LWhGoodsRecord_mapper.LWarehouseFlowId);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_goods_record.setLWarehouseFlowId(null);
            } else {
                l_wh_goods_record.setLWarehouseFlowId(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhGoodsRecord_mapper.WarehouseFlowId);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_goods_record.setWarehouseFlowId(null);
            } else {
                l_wh_goods_record.setWarehouseFlowId(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhGoodsRecord_mapper.InitialCount);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_goods_record.setInitialCount(null);
            } else {
                l_wh_goods_record.setInitialCount(rs.getInt(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhGoodsRecord_mapper.ThisType);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_goods_record.setThisType(null);
            } else {
                l_wh_goods_record.setThisType(rs.getInt(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhGoodsRecord_mapper.ThisCount);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_goods_record.setThisCount(null);
            } else {
                l_wh_goods_record.setThisCount(rs.getInt(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhGoodsRecord_mapper.EndCount);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_goods_record.setEndCount(null);
            } else {
                l_wh_goods_record.setEndCount(rs.getInt(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhGoodsRecord_mapper.BaseGoodsTemplateId);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_goods_record.setBaseGoodsTemplateId(null);
            } else {
                l_wh_goods_record.setBaseGoodsTemplateId(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhGoodsRecord_mapper.GoodsTemplateName);
        if (columnIndex > 0) {
            l_wh_goods_record.setGoodsTemplateName(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhGoodsRecord_mapper.BaseGoodsModelsId);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_goods_record.setBaseGoodsModelsId(null);
            } else {
                l_wh_goods_record.setBaseGoodsModelsId(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhGoodsRecord_mapper.BaseGoodsModelsName);
        if (columnIndex > 0) {
            l_wh_goods_record.setBaseGoodsModelsName(rs.getString(columnIndex));
        }
        return l_wh_goods_record;
    }
}

 consum-model-pojo/src/main/java/com/consum/model/po/LWhGoods_mapper.java

New file
@@ -0,0 +1,397 @@
package com.consum.model.po;

import com.walker.jdbc.BaseMapper;
import com.walker.jdbc.ResultSetUtils;
import com.walker.jdbc.SqlAndParameters;
import com.walker.jdbc.sqlgen.DeleteBuilder;
import com.walker.jdbc.sqlgen.InsertBuilder;
import com.walker.jdbc.sqlgen.SelectBuilder;
import com.walker.jdbc.sqlgen.UpdateBuilder;
import com.walker.jdbc.util.StringUtils;

import org.springframework.jdbc.core.RowMapper;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Map;

/**
 * è¡¨å:L_WH_GOODS *
 * @author genrator
 */
public class LWhGoods_mapper extends LWhGoods implements BaseMapper<LWhGoods> {
    // åºåˆ—化版本号
    private static final long serialVersionUID = 1L;

    public static final RowMapper<LWhGoods> ROW_MAPPER = new LWhGoodsRowMapper();

    // ä¸»é”®
    public static final String Id = "id";
    // æ™®é€šå±žæ€§
    public static final String WarehouseId = "warehouse_id";
    public static final String WarehouseName = "warehouse_name";
    public static final String CostType = "cost_type";
    public static final String BaseGoodsTemplateId = "base_goods_template_id";
    public static final String GoodsTemplateName = "goods_template_name";
    public static final String BaseGoodsModelsId = "base_goods_models_id";
    public static final String BaseGoodsModelsName = "base_goods_models_name";
    public static final String Supplier = "supplier";
    public static final String BuyType = "buy_type";
    public static final String Unit = "unit";
    public static final String Price = "price";
    public static final String ProcureDate = "procure_date";
    public static final String States = "states";

    /**
     * é»˜è®¤æž„造函数
     */
    public LWhGoods_mapper(LWhGoods lWhGoods) {
        if (lWhGoods == null) {
            throw new IllegalArgumentException("po参数不允许为空！");
        }
        //主键
        if (lWhGoods.isset_id) {
            this.setId(lWhGoods.getId());
        }
        //普通属性
        if (lWhGoods.isset_warehouseId) {
            this.setWarehouseId(lWhGoods.getWarehouseId());
        }
        if (lWhGoods.isset_warehouseName) {
            this.setWarehouseName(lWhGoods.getWarehouseName());
        }
        if (lWhGoods.isset_costType) {
            this.setCostType(lWhGoods.getCostType());
        }
        if (lWhGoods.isset_baseGoodsTemplateId) {
            this.setBaseGoodsTemplateId(lWhGoods.getBaseGoodsTemplateId());
        }
        if (lWhGoods.isset_goodsTemplateName) {
            this.setGoodsTemplateName(lWhGoods.getGoodsTemplateName());
        }
        if (lWhGoods.isset_baseGoodsModelsId) {
            this.setBaseGoodsModelsId(lWhGoods.getBaseGoodsModelsId());
        }
        if (lWhGoods.isset_baseGoodsModelsName) {
            this.setBaseGoodsModelsName(lWhGoods.getBaseGoodsModelsName());
        }
        if (lWhGoods.isset_supplier) {
            this.setSupplier(lWhGoods.getSupplier());
        }
        if (lWhGoods.isset_buyType) {
            this.setBuyType(lWhGoods.getBuyType());
        }
        if (lWhGoods.isset_unit) {
            this.setUnit(lWhGoods.getUnit());
        }
        if (lWhGoods.isset_price) {
            this.setPrice(lWhGoods.getPrice());
        }
        if (lWhGoods.isset_procureDate) {
            this.setProcureDate(lWhGoods.getProcureDate());
        }
        if (lWhGoods.isset_states) {
            this.setStates(lWhGoods.getStates());
        }
        // åŽ»æŽ‰ï¼Œ2022-09-07
        // this.setDatabaseName_(l_wh_goods.getDatabaseName_());
    }

    /**
     * èŽ·å–表名
     */
    @Override
    public String getTableName_() {
        String tableName = "l_wh_goods";
        /**
        if (StringUtils.isNotEmpty(this.getDatabaseName_())) {
            return this.getDatabaseName_() + "." + tableName;
        } else {
            return tableName;
        }
        */
        return tableName;
    }

    /**
     * èŽ·å–主键名称
     */
    @Override
    public String getPkName_() {
        return Id;
    }

    /**
     * èŽ·å–主键值
     */
    @Override
    public Object getPkValue_() {
        return this.getId();
    }

    /**
     * èŽ·å–插入语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getInsertSql_() {
        InsertBuilder ib = new InsertBuilder(this.getTableName_());
        ib.set(Id, this.getId());
        ib.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
        ib.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
        ib.set(CostType, this.getCostType(), this.isset_costType);
        ib.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId);
        ib.set(GoodsTemplateName, this.getGoodsTemplateName(), this.isset_goodsTemplateName);
        ib.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId);
        ib.set(BaseGoodsModelsName, this.getBaseGoodsModelsName(), this.isset_baseGoodsModelsName);
        ib.set(Supplier, this.getSupplier(), this.isset_supplier);
        ib.set(BuyType, this.getBuyType(), this.isset_buyType);
        ib.set(Unit, this.getUnit(), this.isset_unit);
        ib.set(Price, this.getPrice(), this.isset_price);
        ib.set(ProcureDate, this.getProcureDate(), this.isset_procureDate);
        ib.set(States, this.getStates(), this.isset_states);
        return ib.genMapSql();
    }

    /**
     * èŽ·å–更新语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getUpdateSql_() {
        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
        ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
        ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
        ub.set(CostType, this.getCostType(), this.isset_costType);
        ub.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId);
        ub.set(GoodsTemplateName, this.getGoodsTemplateName(), this.isset_goodsTemplateName);
        ub.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId);
        ub.set(BaseGoodsModelsName, this.getBaseGoodsModelsName(), this.isset_baseGoodsModelsName);
        ub.set(Supplier, this.getSupplier(), this.isset_supplier);
        ub.set(BuyType, this.getBuyType(), this.isset_buyType);
        ub.set(Unit, this.getUnit(), this.isset_unit);
        ub.set(Price, this.getPrice(), this.isset_price);
        ub.set(ProcureDate, this.getProcureDate(), this.isset_procureDate);
        ub.set(States, this.getStates(), this.isset_states);
        ub.where(this.getPkName_(), this.getPkValue_());
        return ub.genMapSql();
    }

    /**
     * èŽ·å–更新语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getUpdateSql_(String where, Map<String, Object> parameters) {
        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
        ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
        ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
        ub.set(CostType, this.getCostType(), this.isset_costType);
        ub.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId);
        ub.set(GoodsTemplateName, this.getGoodsTemplateName(), this.isset_goodsTemplateName);
        ub.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId);
        ub.set(BaseGoodsModelsName, this.getBaseGoodsModelsName(), this.isset_baseGoodsModelsName);
        ub.set(Supplier, this.getSupplier(), this.isset_supplier);
        ub.set(BuyType, this.getBuyType(), this.isset_buyType);
        ub.set(Unit, this.getUnit(), this.isset_unit);
        ub.set(Price, this.getPrice(), this.isset_price);
        ub.set(ProcureDate, this.getProcureDate(), this.isset_procureDate);
        ub.set(States, this.getStates(), this.isset_states);
        return ub.genMapSql(where, parameters);
    }

    /**
     * èŽ·å–更新语句和参数
     */
    @Override
    public SqlAndParameters<Object[]> getUpdateSql_(String where, Object[] parameters) {
        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
        ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
        ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
        ub.set(CostType, this.getCostType(), this.isset_costType);
        ub.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId);
        ub.set(GoodsTemplateName, this.getGoodsTemplateName(), this.isset_goodsTemplateName);
        ub.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId);
        ub.set(BaseGoodsModelsName, this.getBaseGoodsModelsName(), this.isset_baseGoodsModelsName);
        ub.set(Supplier, this.getSupplier(), this.isset_supplier);
        ub.set(BuyType, this.getBuyType(), this.isset_buyType);
        ub.set(Unit, this.getUnit(), this.isset_unit);
        ub.set(Price, this.getPrice(), this.isset_price);
        ub.set(ProcureDate, this.getProcureDate(), this.isset_procureDate);
        ub.set(States, this.getStates(), this.isset_states);
        return ub.genArraySql(where, parameters);
    }

    /**
     * èŽ·å–删除语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getDeleteSql_() {
        DeleteBuilder db = new DeleteBuilder(this.getTableName_());
        db.where(this.getPkName_(), this.getPkValue_());
        return db.genMapSql();
    }

    /**
     * èŽ·å–删除语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getDeleteSql_(String where, Map<String, Object> parameters) {
        DeleteBuilder db = new DeleteBuilder(this.getTableName_());
        return db.genMapSql(where, parameters);
    }

    /**
     * èŽ·å–删除语句和参数
     */
    @Override
    public SqlAndParameters<Object[]> getDeleteSql_(String where, Object[] parameters) {
        DeleteBuilder db = new DeleteBuilder(this.getTableName_());
        return db.genArraySql(where, parameters);
    }

    /**
     * èŽ·å–单行查询语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getSingleSql_() {
        SelectBuilder sb = new SelectBuilder(this.getTableName_());
        sb.where(this.getPkName_(), this.getPkValue_());
        return sb.genMapSql();
    }


    /**
     * èŽ·å–查询语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) {
        return new SqlAndParameters<>("select id, warehouse_id, warehouse_name, cost_type, base_goods_template_id, goods_template_name, base_goods_models_id, base_goods_models_name, supplier, buy_type, unit, price, procure_date, states from " + this.getTableName_() + " " + where, parameters);
    }

    /**
     * èŽ·å–查询语句和参数
     */
    @Override
    public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) {
        return new SqlAndParameters<>("select id, warehouse_id, warehouse_name, cost_type, base_goods_template_id, goods_template_name, base_goods_models_id, base_goods_models_name, supplier, buy_type, unit, price, procure_date, states from " + this.getTableName_() + " " + where, parameters);
    }

    /**
     * å°†resultset的一行转化为po
     */
    @Override
    public LWhGoods mapRow(ResultSet rs, int i) throws SQLException {
        return ROW_MAPPER.mapRow(rs, i);
    }

    /**
     * å…‹éš†
     */
    public LWhGoods toLWhGoods() {
        return super.$clone();
    }
}

/**
 * l_wh_goods RowMapper
 *
 * @author genrator
 */
class LWhGoodsRowMapper implements RowMapper<LWhGoods> {

    @Override
    public LWhGoods mapRow(ResultSet rs, int i) throws SQLException {
        ResultSetUtils resultSetUtils = new ResultSetUtils();
        LWhGoods l_wh_goods = new LWhGoods();
        Integer columnIndex;
        //主键
        columnIndex = resultSetUtils.findColumn(rs, LWhGoods_mapper.Id);
        if (columnIndex > 0) {
            l_wh_goods.setId(rs.getLong(columnIndex));
        }
        //普通属性
        columnIndex = resultSetUtils.findColumn(rs, LWhGoods_mapper.WarehouseId);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_goods.setWarehouseId(null);
            } else {
                l_wh_goods.setWarehouseId(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhGoods_mapper.WarehouseName);
        if (columnIndex > 0) {
            l_wh_goods.setWarehouseName(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhGoods_mapper.CostType);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_goods.setCostType(null);
            } else {
                l_wh_goods.setCostType(rs.getInt(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhGoods_mapper.BaseGoodsTemplateId);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_goods.setBaseGoodsTemplateId(null);
            } else {
                l_wh_goods.setBaseGoodsTemplateId(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhGoods_mapper.GoodsTemplateName);
        if (columnIndex > 0) {
            l_wh_goods.setGoodsTemplateName(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhGoods_mapper.BaseGoodsModelsId);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_goods.setBaseGoodsModelsId(null);
            } else {
                l_wh_goods.setBaseGoodsModelsId(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhGoods_mapper.BaseGoodsModelsName);
        if (columnIndex > 0) {
            l_wh_goods.setBaseGoodsModelsName(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhGoods_mapper.Supplier);
        if (columnIndex > 0) {
            l_wh_goods.setSupplier(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhGoods_mapper.BuyType);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_goods.setBuyType(null);
            } else {
                l_wh_goods.setBuyType(rs.getInt(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhGoods_mapper.Unit);
        if (columnIndex > 0) {
            l_wh_goods.setUnit(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhGoods_mapper.Price);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_goods.setPrice(null);
            } else {
                l_wh_goods.setPrice(rs.getDouble(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhGoods_mapper.ProcureDate);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_goods.setProcureDate(null);
            } else {
                l_wh_goods.setProcureDate(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhGoods_mapper.States);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_goods.setStates(null);
            } else {
                l_wh_goods.setStates(rs.getInt(columnIndex));
            }
        }
        return l_wh_goods;
    }
}

 consum-model-pojo/src/main/java/com/consum/model/po/LWhProcureModel.java

New file
@@ -0,0 +1,304 @@

package com.consum.model.po;

import com.fasterxml.jackson.annotation.JsonAutoDetect;
import com.fasterxml.jackson.annotation.JsonIgnore;
import com.walker.jdbc.BasePo;

/**
 * è¡¨å:L_WH_PROCURE_MODEL *
 * @author genrator
 */
@JsonAutoDetect(fieldVisibility = JsonAutoDetect.Visibility.ANY)
public class LWhProcureModel extends BasePo<LWhProcureModel> {
    // åºåˆ—化版本号
    private static final long serialVersionUID = 1L;

    // ä¸»é”®
    private Long id = null;
    @JsonIgnore
    protected boolean isset_id = false;

    // å±žæ€§åˆ—表
    private Long fromProcureGoodsId = null;
    @JsonIgnore
    protected boolean isset_fromProcureGoodsId = false;

    private Integer businessType = null;
    @JsonIgnore
    protected boolean isset_businessType = false;

    private Long businessId = null;
    @JsonIgnore
    protected boolean isset_businessId = false;

    private Long baseGoodsModelsId = null;
    @JsonIgnore
    protected boolean isset_baseGoodsModelsId = false;

    private String baseGoodsModelsName = null;
    @JsonIgnore
    protected boolean isset_baseGoodsModelsName = false;

    private String unit = null;
    @JsonIgnore
    protected boolean isset_unit = false;

    private Double price = null;
    @JsonIgnore
    protected boolean isset_price = false;

    private Integer counts = null;
    @JsonIgnore
    protected boolean isset_counts = false;

    private Integer worehouseCount = null;
    @JsonIgnore
    protected boolean isset_worehouseCount = false;

    private String supplier = null;
    @JsonIgnore
    protected boolean isset_supplier = false;

    /**
     * é»˜è®¤æž„造函数
     */
    public LWhProcureModel() {
    }

    /**
     * æ ¹æ®ä¸»é”®æž„造对象
     */
    public LWhProcureModel(Long id) {
        this.setId(id);
    }

    /**
     * è®¾ç½®ä¸»é”®å€¼
     */
    @Override
    public void setPkValue(Object value) {
        this.setId((Long) value);
    }

    public Long getId() {
        return this.id;
    }

    public void setId(Long id) {
        this.id = id;
        this.isset_id = true;
    }

    @JsonIgnore
    public boolean isEmptyId() {
        return this.id == null;
    }

    public Long getFromProcureGoodsId() {
        return this.fromProcureGoodsId;
    }

    public void setFromProcureGoodsId(Long fromProcureGoodsId) {
        this.fromProcureGoodsId = fromProcureGoodsId;
        this.isset_fromProcureGoodsId = true;
    }

    @JsonIgnore
    public boolean isEmptyFromProcureGoodsId() {
        return this.fromProcureGoodsId == null;
    }

    public Integer getBusinessType() {
        return this.businessType;
    }

    public void setBusinessType(Integer businessType) {
        this.businessType = businessType;
        this.isset_businessType = true;
    }

    @JsonIgnore
    public boolean isEmptyBusinessType() {
        return this.businessType == null;
    }

    public Long getBusinessId() {
        return this.businessId;
    }

    public void setBusinessId(Long businessId) {
        this.businessId = businessId;
        this.isset_businessId = true;
    }

    @JsonIgnore
    public boolean isEmptyBusinessId() {
        return this.businessId == null;
    }

    public Long getBaseGoodsModelsId() {
        return this.baseGoodsModelsId;
    }

    public void setBaseGoodsModelsId(Long baseGoodsModelsId) {
        this.baseGoodsModelsId = baseGoodsModelsId;
        this.isset_baseGoodsModelsId = true;
    }

    @JsonIgnore
    public boolean isEmptyBaseGoodsModelsId() {
        return this.baseGoodsModelsId == null;
    }

    public String getBaseGoodsModelsName() {
        return this.baseGoodsModelsName;
    }

    public void setBaseGoodsModelsName(String baseGoodsModelsName) {
        this.baseGoodsModelsName = baseGoodsModelsName;
        this.isset_baseGoodsModelsName = true;
    }

    @JsonIgnore
    public boolean isEmptyBaseGoodsModelsName() {
        return this.baseGoodsModelsName == null || this.baseGoodsModelsName.length() == 0;
    }

    public String getUnit() {
        return this.unit;
    }

    public void setUnit(String unit) {
        this.unit = unit;
        this.isset_unit = true;
    }

    @JsonIgnore
    public boolean isEmptyUnit() {
        return this.unit == null || this.unit.length() == 0;
    }

    public Double getPrice() {
        return this.price;
    }

    public void setPrice(Double price) {
        this.price = price;
        this.isset_price = true;
    }

    @JsonIgnore
    public boolean isEmptyPrice() {
        return this.price == null;
    }

    public Integer getCounts() {
        return this.counts;
    }

    public void setCounts(Integer counts) {
        this.counts = counts;
        this.isset_counts = true;
    }

    @JsonIgnore
    public boolean isEmptyCounts() {
        return this.counts == null;
    }

    public Integer getWorehouseCount() {
        return this.worehouseCount;
    }

    public void setWorehouseCount(Integer worehouseCount) {
        this.worehouseCount = worehouseCount;
        this.isset_worehouseCount = true;
    }

    @JsonIgnore
    public boolean isEmptyWorehouseCount() {
        return this.worehouseCount == null;
    }

    public String getSupplier() {
        return this.supplier;
    }

    public void setSupplier(String supplier) {
        this.supplier = supplier;
        this.isset_supplier = true;
    }

    @JsonIgnore
    public boolean isEmptySupplier() {
        return this.supplier == null || this.supplier.length() == 0;
    }

    /**
     * é‡å†™ toString() æ–¹æ³•
     */
    @Override
    public String toString() {
        return new StringBuilder()
                .append("id=").append(this.id)
                .append("fromProcureGoodsId=").append(this.fromProcureGoodsId)
                .append("businessType=").append(this.businessType)
                .append("businessId=").append(this.businessId)
                .append("baseGoodsModelsId=").append(this.baseGoodsModelsId)
                .append("baseGoodsModelsName=").append(this.baseGoodsModelsName)
                .append("unit=").append(this.unit)
                .append("price=").append(this.price)
                .append("counts=").append(this.counts)
                .append("worehouseCount=").append(this.worehouseCount)
                .append("supplier=").append(this.supplier)
                .toString();
    }

    /**
     * å…‹éš†
     */
    public LWhProcureModel $clone() {
        LWhProcureModel l_wh_procure_model = new LWhProcureModel();

        // æ•°æ®åº“名称
        //l_wh_procure_model.setDatabaseName_(this.getDatabaseName_());

        // ä¸»é”®
        if (this.isset_id) {
            l_wh_procure_model.setId(this.getId());
        }
        // æ™®é€šå±žæ€§
        if (this.isset_fromProcureGoodsId) {
            l_wh_procure_model.setFromProcureGoodsId(this.getFromProcureGoodsId());
        }
        if (this.isset_businessType) {
            l_wh_procure_model.setBusinessType(this.getBusinessType());
        }
        if (this.isset_businessId) {
            l_wh_procure_model.setBusinessId(this.getBusinessId());
        }
        if (this.isset_baseGoodsModelsId) {
            l_wh_procure_model.setBaseGoodsModelsId(this.getBaseGoodsModelsId());
        }
        if (this.isset_baseGoodsModelsName) {
            l_wh_procure_model.setBaseGoodsModelsName(this.getBaseGoodsModelsName());
        }
        if (this.isset_unit) {
            l_wh_procure_model.setUnit(this.getUnit());
        }
        if (this.isset_price) {
            l_wh_procure_model.setPrice(this.getPrice());
        }
        if (this.isset_counts) {
            l_wh_procure_model.setCounts(this.getCounts());
        }
        if (this.isset_worehouseCount) {
            l_wh_procure_model.setWorehouseCount(this.getWorehouseCount());
        }
        if (this.isset_supplier) {
            l_wh_procure_model.setSupplier(this.getSupplier());
        }
        return l_wh_procure_model;
    }
}

 consum-model-pojo/src/main/java/com/consum/model/po/LWhProcureModel_mapper.java

New file
@@ -0,0 +1,355 @@
package com.consum.model.po;

import com.walker.jdbc.BaseMapper;
import com.walker.jdbc.ResultSetUtils;
import com.walker.jdbc.SqlAndParameters;
import com.walker.jdbc.sqlgen.DeleteBuilder;
import com.walker.jdbc.sqlgen.InsertBuilder;
import com.walker.jdbc.sqlgen.SelectBuilder;
import com.walker.jdbc.sqlgen.UpdateBuilder;
import org.springframework.jdbc.core.RowMapper;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Map;

/**
 * è¡¨å:L_WH_PROCURE_MODEL *
 * @author genrator
 */
public class LWhProcureModel_mapper extends LWhProcureModel implements BaseMapper<LWhProcureModel> {
    // åºåˆ—化版本号
    private static final long serialVersionUID = 1L;

    public static final RowMapper<LWhProcureModel> ROW_MAPPER = new LWhProcureModelRowMapper();

    // ä¸»é”®
    public static final String Id = "id";
    // æ™®é€šå±žæ€§
    public static final String FromProcureGoodsId = "from_procure_goods_id";
    public static final String BusinessType = "business_type";
    public static final String BusinessId = "business_id";
    public static final String BaseGoodsModelsId = "base_goods_models_id";
    public static final String BaseGoodsModelsName = "base_goods_models_name";
    public static final String Unit = "unit";
    public static final String Price = "price";
    public static final String Counts = "counts";
    public static final String WorehouseCount = "worehouse_count";
    public static final String Supplier = "supplier";

    /**
     * é»˜è®¤æž„造函数
     */
    public LWhProcureModel_mapper(LWhProcureModel lWhProcureModel) {
        if (lWhProcureModel == null) {
            throw new IllegalArgumentException("po参数不允许为空！");
        }
        //主键
        if (lWhProcureModel.isset_id) {
            this.setId(lWhProcureModel.getId());
        }
        //普通属性
        if (lWhProcureModel.isset_fromProcureGoodsId) {
            this.setFromProcureGoodsId(lWhProcureModel.getFromProcureGoodsId());
        }
        if (lWhProcureModel.isset_businessType) {
            this.setBusinessType(lWhProcureModel.getBusinessType());
        }
        if (lWhProcureModel.isset_businessId) {
            this.setBusinessId(lWhProcureModel.getBusinessId());
        }
        if (lWhProcureModel.isset_baseGoodsModelsId) {
            this.setBaseGoodsModelsId(lWhProcureModel.getBaseGoodsModelsId());
        }
        if (lWhProcureModel.isset_baseGoodsModelsName) {
            this.setBaseGoodsModelsName(lWhProcureModel.getBaseGoodsModelsName());
        }
        if (lWhProcureModel.isset_unit) {
            this.setUnit(lWhProcureModel.getUnit());
        }
        if (lWhProcureModel.isset_price) {
            this.setPrice(lWhProcureModel.getPrice());
        }
        if (lWhProcureModel.isset_counts) {
            this.setCounts(lWhProcureModel.getCounts());
        }
        if (lWhProcureModel.isset_worehouseCount) {
            this.setWorehouseCount(lWhProcureModel.getWorehouseCount());
        }
        if (lWhProcureModel.isset_supplier) {
            this.setSupplier(lWhProcureModel.getSupplier());
        }
        // åŽ»æŽ‰ï¼Œ2022-09-07
        // this.setDatabaseName_(l_wh_procure_model.getDatabaseName_());
    }

    /**
     * èŽ·å–表名
     */
    @Override
    public String getTableName_() {
        String tableName = "l_wh_procure_model";
        /**
        if (StringUtils.isNotEmpty(this.getDatabaseName_())) {
            return this.getDatabaseName_() + "." + tableName;
        } else {
            return tableName;
        }
        */
        return tableName;
    }

    /**
     * èŽ·å–主键名称
     */
    @Override
    public String getPkName_() {
        return Id;
    }

    /**
     * èŽ·å–主键值
     */
    @Override
    public Object getPkValue_() {
        return this.getId();
    }

    /**
     * èŽ·å–插入语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getInsertSql_() {
        InsertBuilder ib = new InsertBuilder(this.getTableName_());
        ib.set(Id, this.getId());
        ib.set(FromProcureGoodsId, this.getFromProcureGoodsId(), this.isset_fromProcureGoodsId);
        ib.set(BusinessType, this.getBusinessType(), this.isset_businessType);
        ib.set(BusinessId, this.getBusinessId(), this.isset_businessId);
        ib.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId);
        ib.set(BaseGoodsModelsName, this.getBaseGoodsModelsName(), this.isset_baseGoodsModelsName);
        ib.set(Unit, this.getUnit(), this.isset_unit);
        ib.set(Price, this.getPrice(), this.isset_price);
        ib.set(Counts, this.getCounts(), this.isset_counts);
        ib.set(WorehouseCount, this.getWorehouseCount(), this.isset_worehouseCount);
        ib.set(Supplier, this.getSupplier(), this.isset_supplier);
        return ib.genMapSql();
    }

    /**
     * èŽ·å–更新语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getUpdateSql_() {
        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
        ub.set(FromProcureGoodsId, this.getFromProcureGoodsId(), this.isset_fromProcureGoodsId);
        ub.set(BusinessType, this.getBusinessType(), this.isset_businessType);
        ub.set(BusinessId, this.getBusinessId(), this.isset_businessId);
        ub.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId);
        ub.set(BaseGoodsModelsName, this.getBaseGoodsModelsName(), this.isset_baseGoodsModelsName);
        ub.set(Unit, this.getUnit(), this.isset_unit);
        ub.set(Price, this.getPrice(), this.isset_price);
        ub.set(Counts, this.getCounts(), this.isset_counts);
        ub.set(WorehouseCount, this.getWorehouseCount(), this.isset_worehouseCount);
        ub.set(Supplier, this.getSupplier(), this.isset_supplier);
        ub.where(this.getPkName_(), this.getPkValue_());
        return ub.genMapSql();
    }

    /**
     * èŽ·å–更新语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getUpdateSql_(String where, Map<String, Object> parameters) {
        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
        ub.set(FromProcureGoodsId, this.getFromProcureGoodsId(), this.isset_fromProcureGoodsId);
        ub.set(BusinessType, this.getBusinessType(), this.isset_businessType);
        ub.set(BusinessId, this.getBusinessId(), this.isset_businessId);
        ub.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId);
        ub.set(BaseGoodsModelsName, this.getBaseGoodsModelsName(), this.isset_baseGoodsModelsName);
        ub.set(Unit, this.getUnit(), this.isset_unit);
        ub.set(Price, this.getPrice(), this.isset_price);
        ub.set(Counts, this.getCounts(), this.isset_counts);
        ub.set(WorehouseCount, this.getWorehouseCount(), this.isset_worehouseCount);
        ub.set(Supplier, this.getSupplier(), this.isset_supplier);
        return ub.genMapSql(where, parameters);
    }

    /**
     * èŽ·å–更新语句和参数
     */
    @Override
    public SqlAndParameters<Object[]> getUpdateSql_(String where, Object[] parameters) {
        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
        ub.set(FromProcureGoodsId, this.getFromProcureGoodsId(), this.isset_fromProcureGoodsId);
        ub.set(BusinessType, this.getBusinessType(), this.isset_businessType);
        ub.set(BusinessId, this.getBusinessId(), this.isset_businessId);
        ub.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId);
        ub.set(BaseGoodsModelsName, this.getBaseGoodsModelsName(), this.isset_baseGoodsModelsName);
        ub.set(Unit, this.getUnit(), this.isset_unit);
        ub.set(Price, this.getPrice(), this.isset_price);
        ub.set(Counts, this.getCounts(), this.isset_counts);
        ub.set(WorehouseCount, this.getWorehouseCount(), this.isset_worehouseCount);
        ub.set(Supplier, this.getSupplier(), this.isset_supplier);
        return ub.genArraySql(where, parameters);
    }

    /**
     * èŽ·å–删除语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getDeleteSql_() {
        DeleteBuilder db = new DeleteBuilder(this.getTableName_());
        db.where(this.getPkName_(), this.getPkValue_());
        return db.genMapSql();
    }

    /**
     * èŽ·å–删除语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getDeleteSql_(String where, Map<String, Object> parameters) {
        DeleteBuilder db = new DeleteBuilder(this.getTableName_());
        return db.genMapSql(where, parameters);
    }

    /**
     * èŽ·å–删除语句和参数
     */
    @Override
    public SqlAndParameters<Object[]> getDeleteSql_(String where, Object[] parameters) {
        DeleteBuilder db = new DeleteBuilder(this.getTableName_());
        return db.genArraySql(where, parameters);
    }

    /**
     * èŽ·å–单行查询语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getSingleSql_() {
        SelectBuilder sb = new SelectBuilder(this.getTableName_());
        sb.where(this.getPkName_(), this.getPkValue_());
        return sb.genMapSql();
    }


    /**
     * èŽ·å–查询语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) {
        return new SqlAndParameters<>("select id, from_procure_goods_id, business_type, business_id, base_goods_models_id, base_goods_models_name, unit, price, counts, worehouse_count, supplier from " + this.getTableName_() + " " + where, parameters);
    }

    /**
     * èŽ·å–查询语句和参数
     */
    @Override
    public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) {
        return new SqlAndParameters<>("select id, from_procure_goods_id, business_type, business_id, base_goods_models_id, base_goods_models_name, unit, price, counts, worehouse_count, supplier from " + this.getTableName_() + " " + where, parameters);
    }

    /**
     * å°†resultset的一行转化为po
     */
    @Override
    public LWhProcureModel mapRow(ResultSet rs, int i) throws SQLException {
        return ROW_MAPPER.mapRow(rs, i);
    }

    /**
     * å…‹éš†
     */
    public LWhProcureModel toLWhProcureModel() {
        return super.$clone();
    }
}

/**
 * l_wh_procure_model RowMapper
 *
 * @author genrator
 */
class LWhProcureModelRowMapper implements RowMapper<LWhProcureModel> {

    @Override
    public LWhProcureModel mapRow(ResultSet rs, int i) throws SQLException {
        ResultSetUtils resultSetUtils = new ResultSetUtils();
        LWhProcureModel l_wh_procure_model = new LWhProcureModel();
        Integer columnIndex;
        //主键
        columnIndex = resultSetUtils.findColumn(rs, LWhProcureModel_mapper.Id);
        if (columnIndex > 0) {
            l_wh_procure_model.setId(rs.getLong(columnIndex));
        }
        //普通属性
        columnIndex = resultSetUtils.findColumn(rs, LWhProcureModel_mapper.FromProcureGoodsId);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_procure_model.setFromProcureGoodsId(null);
            } else {
                l_wh_procure_model.setFromProcureGoodsId(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhProcureModel_mapper.BusinessType);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_procure_model.setBusinessType(null);
            } else {
                l_wh_procure_model.setBusinessType(rs.getInt(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhProcureModel_mapper.BusinessId);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_procure_model.setBusinessId(null);
            } else {
                l_wh_procure_model.setBusinessId(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhProcureModel_mapper.BaseGoodsModelsId);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_procure_model.setBaseGoodsModelsId(null);
            } else {
                l_wh_procure_model.setBaseGoodsModelsId(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhProcureModel_mapper.BaseGoodsModelsName);
        if (columnIndex > 0) {
            l_wh_procure_model.setBaseGoodsModelsName(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhProcureModel_mapper.Unit);
        if (columnIndex > 0) {
            l_wh_procure_model.setUnit(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhProcureModel_mapper.Price);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_procure_model.setPrice(null);
            } else {
                l_wh_procure_model.setPrice(rs.getDouble(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhProcureModel_mapper.Counts);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_procure_model.setCounts(null);
            } else {
                l_wh_procure_model.setCounts(rs.getInt(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhProcureModel_mapper.WorehouseCount);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_procure_model.setWorehouseCount(null);
            } else {
                l_wh_procure_model.setWorehouseCount(rs.getInt(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhProcureModel_mapper.Supplier);
        if (columnIndex > 0) {
            l_wh_procure_model.setSupplier(rs.getString(columnIndex));
        }
        return l_wh_procure_model;
    }
}