From fd95223d9703b9c038ed3c782474c885052dda08 Mon Sep 17 00:00:00 2001 From: futian.liu <liufutianyoo@163.com> Date: 星期五, 22 十二月 2023 17:05:25 +0800 Subject: [PATCH] 代码整理 --- consum-model-pojo/src/main/java/com/consum/model/po/DepFormScrappedModel_mapper.java | 99 +++++++++++++++++++++++++------------------------ 1 files changed, 50 insertions(+), 49 deletions(-) diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/DepFormScrappedModel_mapper.java b/consum-model-pojo/src/main/java/com/consum/model/po/DepFormScrappedModel_mapper.java index e00bfe2..09597cf 100644 --- a/consum-model-pojo/src/main/java/com/consum/model/po/DepFormScrappedModel_mapper.java +++ b/consum-model-pojo/src/main/java/com/consum/model/po/DepFormScrappedModel_mapper.java @@ -1,5 +1,11 @@ package com.consum.model.po; +import java.sql.ResultSet; +import java.sql.SQLException; +import java.util.Map; + +import org.springframework.jdbc.core.RowMapper; + import com.walker.jdbc.BaseMapper; import com.walker.jdbc.ResultSetUtils; import com.walker.jdbc.SqlAndParameters; @@ -7,13 +13,6 @@ 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; /** * 琛ㄥ悕:DEP_FORM_SCRAPPED_MODEL @@ -54,11 +53,11 @@ if (depFormScrappedModel == null) { throw new IllegalArgumentException("po鍙傛暟涓嶅厑璁镐负绌猴紒"); } - //涓婚敭 + // 涓婚敭 if (depFormScrappedModel.isset_id) { this.setId(depFormScrappedModel.getId()); } - //鏅�氬睘鎬� + // 鏅�氬睘鎬� if (depFormScrappedModel.isset_depFormScrappedId) { this.setDepFormScrappedId(depFormScrappedModel.getDepFormScrappedId()); } @@ -121,12 +120,9 @@ public String getTableName_() { String tableName = "dep_form_scrapped_model"; /** - if (StringUtils.isNotEmpty(this.getDatabaseName_())) { - return this.getDatabaseName_() + "." + tableName; - } else { - return tableName; - } - */ + * if (StringUtils.isNotEmpty(this.getDatabaseName_())) { return this.getDatabaseName_() + "." + tableName; } + * else { return tableName; } + */ return tableName; } @@ -290,13 +286,15 @@ return sb.genMapSql(); } - /** * 鑾峰彇鏌ヨ璇彞鍜屽弬鏁� */ @Override public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) { - return new SqlAndParameters<>("select id, dep_form_scrapped_id, dep_form_scrapped_goods_id, scrapped_code, scrapped_name, base_goods_template_id, base_goods_template_name, classification, unit, base_goods_models_id, base_goods_models_name, procure_model_user_id, initial_count, use_count, counts, goods_user_name, beiz, total_amount from " + this.getTableName_() + " " + where, parameters); + return new SqlAndParameters<>( + "select id, dep_form_scrapped_id, dep_form_scrapped_goods_id, scrapped_code, scrapped_name, base_goods_template_id, base_goods_template_name, classification, unit, base_goods_models_id, base_goods_models_name, procure_model_user_id, initial_count, use_count, counts, goods_user_name, beiz, total_amount from " + + this.getTableName_() + " " + where, + parameters); } /** @@ -304,7 +302,10 @@ */ @Override public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) { - return new SqlAndParameters<>("select id, dep_form_scrapped_id, dep_form_scrapped_goods_id, scrapped_code, scrapped_name, base_goods_template_id, base_goods_template_name, classification, unit, base_goods_models_id, base_goods_models_name, procure_model_user_id, initial_count, use_count, counts, goods_user_name, beiz, total_amount from " + this.getTableName_() + " " + where, parameters); + return new SqlAndParameters<>( + "select id, dep_form_scrapped_id, dep_form_scrapped_goods_id, scrapped_code, scrapped_name, base_goods_template_id, base_goods_template_name, classification, unit, base_goods_models_id, base_goods_models_name, procure_model_user_id, initial_count, use_count, counts, goods_user_name, beiz, total_amount from " + + this.getTableName_() + " " + where, + parameters); } /** @@ -333,120 +334,120 @@ @Override public DepFormScrappedModel mapRow(ResultSet rs, int i) throws SQLException { ResultSetUtils resultSetUtils = new ResultSetUtils(); -DepFormScrappedModel dep_form_scrapped_model = new DepFormScrappedModel(); + DepFormScrappedModel dep_form_scrapped_model = new DepFormScrappedModel(); Integer columnIndex; - //涓婚敭 + // 涓婚敭 columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedModel_mapper.Id); if (columnIndex > 0) { -dep_form_scrapped_model.setId(rs.getLong(columnIndex)); + dep_form_scrapped_model.setId(rs.getLong(columnIndex)); } - //鏅�氬睘鎬� + // 鏅�氬睘鎬� columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedModel_mapper.DepFormScrappedId); if (columnIndex > 0) { if (rs.getBigDecimal(columnIndex) == null) { -dep_form_scrapped_model.setDepFormScrappedId(null); + dep_form_scrapped_model.setDepFormScrappedId(null); } else { -dep_form_scrapped_model.setDepFormScrappedId(rs.getLong(columnIndex)); + dep_form_scrapped_model.setDepFormScrappedId(rs.getLong(columnIndex)); } } columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedModel_mapper.DepFormScrappedGoodsId); if (columnIndex > 0) { if (rs.getBigDecimal(columnIndex) == null) { -dep_form_scrapped_model.setDepFormScrappedGoodsId(null); + dep_form_scrapped_model.setDepFormScrappedGoodsId(null); } else { -dep_form_scrapped_model.setDepFormScrappedGoodsId(rs.getLong(columnIndex)); + dep_form_scrapped_model.setDepFormScrappedGoodsId(rs.getLong(columnIndex)); } } columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedModel_mapper.ScrappedCode); if (columnIndex > 0) { if (rs.getBigDecimal(columnIndex) == null) { -dep_form_scrapped_model.setScrappedCode(null); + dep_form_scrapped_model.setScrappedCode(null); } else { -dep_form_scrapped_model.setScrappedCode(rs.getLong(columnIndex)); + dep_form_scrapped_model.setScrappedCode(rs.getLong(columnIndex)); } } columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedModel_mapper.ScrappedName); if (columnIndex > 0) { -dep_form_scrapped_model.setScrappedName(rs.getString(columnIndex)); + dep_form_scrapped_model.setScrappedName(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedModel_mapper.BaseGoodsTemplateId); if (columnIndex > 0) { if (rs.getBigDecimal(columnIndex) == null) { -dep_form_scrapped_model.setBaseGoodsTemplateId(null); + dep_form_scrapped_model.setBaseGoodsTemplateId(null); } else { -dep_form_scrapped_model.setBaseGoodsTemplateId(rs.getLong(columnIndex)); + dep_form_scrapped_model.setBaseGoodsTemplateId(rs.getLong(columnIndex)); } } columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedModel_mapper.BaseGoodsTemplateName); if (columnIndex > 0) { -dep_form_scrapped_model.setBaseGoodsTemplateName(rs.getString(columnIndex)); + dep_form_scrapped_model.setBaseGoodsTemplateName(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedModel_mapper.Classification); if (columnIndex > 0) { -dep_form_scrapped_model.setClassification(rs.getString(columnIndex)); + dep_form_scrapped_model.setClassification(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedModel_mapper.Unit); if (columnIndex > 0) { -dep_form_scrapped_model.setUnit(rs.getString(columnIndex)); + dep_form_scrapped_model.setUnit(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedModel_mapper.BaseGoodsModelsId); if (columnIndex > 0) { if (rs.getBigDecimal(columnIndex) == null) { -dep_form_scrapped_model.setBaseGoodsModelsId(null); + dep_form_scrapped_model.setBaseGoodsModelsId(null); } else { -dep_form_scrapped_model.setBaseGoodsModelsId(rs.getLong(columnIndex)); + dep_form_scrapped_model.setBaseGoodsModelsId(rs.getLong(columnIndex)); } } columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedModel_mapper.BaseGoodsModelsName); if (columnIndex > 0) { -dep_form_scrapped_model.setBaseGoodsModelsName(rs.getString(columnIndex)); + dep_form_scrapped_model.setBaseGoodsModelsName(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedModel_mapper.ProcureModelUserId); if (columnIndex > 0) { if (rs.getBigDecimal(columnIndex) == null) { -dep_form_scrapped_model.setProcureModelUserId(null); + dep_form_scrapped_model.setProcureModelUserId(null); } else { -dep_form_scrapped_model.setProcureModelUserId(rs.getLong(columnIndex)); + dep_form_scrapped_model.setProcureModelUserId(rs.getLong(columnIndex)); } } columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedModel_mapper.InitialCount); if (columnIndex > 0) { if (rs.getBigDecimal(columnIndex) == null) { -dep_form_scrapped_model.setInitialCount(null); + dep_form_scrapped_model.setInitialCount(null); } else { -dep_form_scrapped_model.setInitialCount(rs.getInt(columnIndex)); + dep_form_scrapped_model.setInitialCount(rs.getInt(columnIndex)); } } columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedModel_mapper.UseCount); if (columnIndex > 0) { if (rs.getBigDecimal(columnIndex) == null) { -dep_form_scrapped_model.setUseCount(null); + dep_form_scrapped_model.setUseCount(null); } else { -dep_form_scrapped_model.setUseCount(rs.getInt(columnIndex)); + dep_form_scrapped_model.setUseCount(rs.getInt(columnIndex)); } } columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedModel_mapper.Counts); if (columnIndex > 0) { if (rs.getBigDecimal(columnIndex) == null) { -dep_form_scrapped_model.setCounts(null); + dep_form_scrapped_model.setCounts(null); } else { -dep_form_scrapped_model.setCounts(rs.getInt(columnIndex)); + dep_form_scrapped_model.setCounts(rs.getInt(columnIndex)); } } columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedModel_mapper.GoodsUserName); if (columnIndex > 0) { -dep_form_scrapped_model.setGoodsUserName(rs.getString(columnIndex)); + dep_form_scrapped_model.setGoodsUserName(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedModel_mapper.Beiz); if (columnIndex > 0) { -dep_form_scrapped_model.setBeiz(rs.getString(columnIndex)); + dep_form_scrapped_model.setBeiz(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedModel_mapper.TotalAmount); if (columnIndex > 0) { if (rs.getBigDecimal(columnIndex) == null) { -dep_form_scrapped_model.setTotalAmount(null); + dep_form_scrapped_model.setTotalAmount(null); } else { -dep_form_scrapped_model.setTotalAmount(rs.getInt(columnIndex)); + dep_form_scrapped_model.setTotalAmount(rs.getInt(columnIndex)); } } return dep_form_scrapped_model; -- Gitblit v1.9.1