From db40d04b8b242c6853f9baa0a8a675d65ecc04f9 Mon Sep 17 00:00:00 2001 From: luqingyang <lqy5492@163.com> Date: 星期四, 26 十月 2023 17:23:58 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/master' --- consum-model-pojo/src/main/java/com/consum/model/po/BaseWarehouseManager_mapper.java | 253 ++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 253 insertions(+), 0 deletions(-) diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/BaseWarehouseManager_mapper.java b/consum-model-pojo/src/main/java/com/consum/model/po/BaseWarehouseManager_mapper.java new file mode 100644 index 0000000..da106ba --- /dev/null +++ b/consum-model-pojo/src/main/java/com/consum/model/po/BaseWarehouseManager_mapper.java @@ -0,0 +1,253 @@ +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; + +/** + * 琛ㄥ悕:BASE_WAREHOUSE_MANAGER * + * @author genrator + */ +public class BaseWarehouseManager_mapper extends BaseWarehouseManager implements BaseMapper<BaseWarehouseManager> { + // 搴忓垪鍖栫増鏈彿 + private static final long serialVersionUID = 1L; + + public static final RowMapper<BaseWarehouseManager> ROW_MAPPER = new BaseWarehouseManagerRowMapper(); + + // 涓婚敭 + public static final String Id = "id"; + // 鏅�氬睘鎬� + public static final String ManagerId = "manager_id"; + public static final String ManagerName = "manager_name"; + public static final String BaseWarehouseId = "base_warehouse_id"; + + /** + * 榛樿鏋勯�犲嚱鏁� + */ + public BaseWarehouseManager_mapper(BaseWarehouseManager baseWarehouseManager) { + if (baseWarehouseManager == null) { + throw new IllegalArgumentException("po鍙傛暟涓嶅厑璁镐负绌猴紒"); + } + //涓婚敭 + if (baseWarehouseManager.isset_id) { + this.setId(baseWarehouseManager.getId()); + } + //鏅�氬睘鎬� + if (baseWarehouseManager.isset_managerId) { + this.setManagerId(baseWarehouseManager.getManagerId()); + } + if (baseWarehouseManager.isset_managerName) { + this.setManagerName(baseWarehouseManager.getManagerName()); + } + if (baseWarehouseManager.isset_baseWarehouseId) { + this.setBaseWarehouseId(baseWarehouseManager.getBaseWarehouseId()); + } + // 鍘绘帀锛�2022-09-07 + // this.setDatabaseName_(base_warehouse_manager.getDatabaseName_()); + } + + /** + * 鑾峰彇琛ㄥ悕 + */ + @Override + public String getTableName_() { + String tableName = "base_warehouse_manager"; + /** + 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(ManagerId, this.getManagerId(), this.isset_managerId); + ib.set(ManagerName, this.getManagerName(), this.isset_managerName); + ib.set(BaseWarehouseId, this.getBaseWarehouseId(), this.isset_baseWarehouseId); + return ib.genMapSql(); + } + + /** + * 鑾峰彇鏇存柊璇彞鍜屽弬鏁� + */ + @Override + public SqlAndParameters<Map<String, Object>> getUpdateSql_() { + UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); + ub.set(ManagerId, this.getManagerId(), this.isset_managerId); + ub.set(ManagerName, this.getManagerName(), this.isset_managerName); + ub.set(BaseWarehouseId, this.getBaseWarehouseId(), this.isset_baseWarehouseId); + 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(ManagerId, this.getManagerId(), this.isset_managerId); + ub.set(ManagerName, this.getManagerName(), this.isset_managerName); + ub.set(BaseWarehouseId, this.getBaseWarehouseId(), this.isset_baseWarehouseId); + return ub.genMapSql(where, parameters); + } + + /** + * 鑾峰彇鏇存柊璇彞鍜屽弬鏁� + */ + @Override + public SqlAndParameters<Object[]> getUpdateSql_(String where, Object[] parameters) { + UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); + ub.set(ManagerId, this.getManagerId(), this.isset_managerId); + ub.set(ManagerName, this.getManagerName(), this.isset_managerName); + ub.set(BaseWarehouseId, this.getBaseWarehouseId(), this.isset_baseWarehouseId); + 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, manager_id, manager_name, base_warehouse_id from " + this.getTableName_() + " " + where, parameters); + } + + /** + * 鑾峰彇鏌ヨ璇彞鍜屽弬鏁� + */ + @Override + public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) { + return new SqlAndParameters<>("select id, manager_id, manager_name, base_warehouse_id from " + this.getTableName_() + " " + where, parameters); + } + + /** + * 灏唕esultset鐨勪竴琛岃浆鍖栦负po + */ + @Override + public BaseWarehouseManager mapRow(ResultSet rs, int i) throws SQLException { + return ROW_MAPPER.mapRow(rs, i); + } + + /** + * 鍏嬮殕 + */ + public BaseWarehouseManager toBaseWarehouseManager() { + return super.$clone(); + } +} + +/** + * base_warehouse_manager RowMapper + * + * @author genrator + */ +class BaseWarehouseManagerRowMapper implements RowMapper<BaseWarehouseManager> { + + @Override + public BaseWarehouseManager mapRow(ResultSet rs, int i) throws SQLException { + ResultSetUtils resultSetUtils = new ResultSetUtils(); + BaseWarehouseManager base_warehouse_manager = new BaseWarehouseManager(); + Integer columnIndex; + //涓婚敭 + columnIndex = resultSetUtils.findColumn(rs, BaseWarehouseManager_mapper.Id); + if (columnIndex > 0) { + base_warehouse_manager.setId(rs.getLong(columnIndex)); + } + //鏅�氬睘鎬� + columnIndex = resultSetUtils.findColumn(rs, BaseWarehouseManager_mapper.ManagerId); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + base_warehouse_manager.setManagerId(null); + } else { + base_warehouse_manager.setManagerId(rs.getLong(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, BaseWarehouseManager_mapper.ManagerName); + if (columnIndex > 0) { + base_warehouse_manager.setManagerName(rs.getString(columnIndex)); + } + columnIndex = resultSetUtils.findColumn(rs, BaseWarehouseManager_mapper.BaseWarehouseId); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + base_warehouse_manager.setBaseWarehouseId(null); + } else { + base_warehouse_manager.setBaseWarehouseId(rs.getLong(columnIndex)); + } + } + return base_warehouse_manager; + } +} -- Gitblit v1.9.1