From 62b6a7fac3f2acde70b578431147c4a01f19c182 Mon Sep 17 00:00:00 2001 From: 黎星凯 <13949086503@163.com> Date: 星期一, 15 四月 2024 09:07:05 +0800 Subject: [PATCH] bug修改 --- consum-model-pojo/src/main/java/com/consum/model/po/BaseCategory_mapper.java | 130 ++++++++++++++++++++++++++++++++++++------ 1 files changed, 110 insertions(+), 20 deletions(-) diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/BaseCategory_mapper.java b/consum-model-pojo/src/main/java/com/consum/model/po/BaseCategory_mapper.java index ca37218..6fd41fc 100644 --- a/consum-model-pojo/src/main/java/com/consum/model/po/BaseCategory_mapper.java +++ b/consum-model-pojo/src/main/java/com/consum/model/po/BaseCategory_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,16 +13,10 @@ 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_CATEGORY * + * * @author genrator */ public class BaseCategory_mapper extends BaseCategory implements BaseMapper<BaseCategory> { @@ -34,6 +34,12 @@ public static final String States = "states"; public static final String Levels = "levels"; public static final String FatherCategoryId = "father_category_id"; + public static final String CreateUserId = "create_user_id"; + public static final String CreateTime = "create_time"; + public static final String CreateUserName = "create_user_name"; + public static final String DTime = "d_time"; + public static final String DUserId = "d_user_id"; + public static final String DUserName = "d_user_name"; /** * 榛樿鏋勯�犲嚱鏁� @@ -42,11 +48,11 @@ if (baseCategory == null) { throw new IllegalArgumentException("po鍙傛暟涓嶅厑璁镐负绌猴紒"); } - //涓婚敭 + // 涓婚敭 if (baseCategory.isset_id) { this.setId(baseCategory.getId()); } - //鏅�氬睘鎬� + // 鏅�氬睘鎬� if (baseCategory.isset_categoryName) { this.setCategoryName(baseCategory.getCategoryName()); } @@ -65,6 +71,24 @@ if (baseCategory.isset_fatherCategoryId) { this.setFatherCategoryId(baseCategory.getFatherCategoryId()); } + if (baseCategory.isset_createUserId) { + this.setCreateUserId(baseCategory.getCreateUserId()); + } + if (baseCategory.isset_createTime) { + this.setCreateTime(baseCategory.getCreateTime()); + } + if (baseCategory.isset_createUserName) { + this.setCreateUserName(baseCategory.getCreateUserName()); + } + if (baseCategory.isset_dTime) { + this.setDTime(baseCategory.getDTime()); + } + if (baseCategory.isset_dUserId) { + this.setDUserId(baseCategory.getDUserId()); + } + if (baseCategory.isset_dUserName) { + this.setDUserName(baseCategory.getDUserName()); + } // 鍘绘帀锛�2022-09-07 // this.setDatabaseName_(base_category.getDatabaseName_()); } @@ -76,12 +100,9 @@ public String getTableName_() { String tableName = "base_category"; /** - 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; } @@ -114,6 +135,12 @@ ib.set(States, this.getStates(), this.isset_states); ib.set(Levels, this.getLevels(), this.isset_levels); ib.set(FatherCategoryId, this.getFatherCategoryId(), this.isset_fatherCategoryId); + ib.set(CreateUserId, this.getCreateUserId(), this.isset_createUserId); + ib.set(CreateTime, this.getCreateTime(), this.isset_createTime); + ib.set(CreateUserName, this.getCreateUserName(), this.isset_createUserName); + ib.set(DTime, this.getDTime(), this.isset_dTime); + ib.set(DUserId, this.getDUserId(), this.isset_dUserId); + ib.set(DUserName, this.getDUserName(), this.isset_dUserName); return ib.genMapSql(); } @@ -129,6 +156,12 @@ ub.set(States, this.getStates(), this.isset_states); ub.set(Levels, this.getLevels(), this.isset_levels); ub.set(FatherCategoryId, this.getFatherCategoryId(), this.isset_fatherCategoryId); + ub.set(CreateUserId, this.getCreateUserId(), this.isset_createUserId); + ub.set(CreateTime, this.getCreateTime(), this.isset_createTime); + ub.set(CreateUserName, this.getCreateUserName(), this.isset_createUserName); + ub.set(DTime, this.getDTime(), this.isset_dTime); + ub.set(DUserId, this.getDUserId(), this.isset_dUserId); + ub.set(DUserName, this.getDUserName(), this.isset_dUserName); ub.where(this.getPkName_(), this.getPkValue_()); return ub.genMapSql(); } @@ -145,6 +178,12 @@ ub.set(States, this.getStates(), this.isset_states); ub.set(Levels, this.getLevels(), this.isset_levels); ub.set(FatherCategoryId, this.getFatherCategoryId(), this.isset_fatherCategoryId); + ub.set(CreateUserId, this.getCreateUserId(), this.isset_createUserId); + ub.set(CreateTime, this.getCreateTime(), this.isset_createTime); + ub.set(CreateUserName, this.getCreateUserName(), this.isset_createUserName); + ub.set(DTime, this.getDTime(), this.isset_dTime); + ub.set(DUserId, this.getDUserId(), this.isset_dUserId); + ub.set(DUserName, this.getDUserName(), this.isset_dUserName); return ub.genMapSql(where, parameters); } @@ -160,6 +199,12 @@ ub.set(States, this.getStates(), this.isset_states); ub.set(Levels, this.getLevels(), this.isset_levels); ub.set(FatherCategoryId, this.getFatherCategoryId(), this.isset_fatherCategoryId); + ub.set(CreateUserId, this.getCreateUserId(), this.isset_createUserId); + ub.set(CreateTime, this.getCreateTime(), this.isset_createTime); + ub.set(CreateUserName, this.getCreateUserName(), this.isset_createUserName); + ub.set(DTime, this.getDTime(), this.isset_dTime); + ub.set(DUserId, this.getDUserId(), this.isset_dUserId); + ub.set(DUserName, this.getDUserName(), this.isset_dUserName); return ub.genArraySql(where, parameters); } @@ -201,13 +246,15 @@ return sb.genMapSql(); } - /** * 鑾峰彇鏌ヨ璇彞鍜屽弬鏁� */ @Override public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) { - return new SqlAndParameters<>("select id, category_name, classification, order_number, states, levels, father_category_id from " + this.getTableName_() + " " + where, parameters); + return new SqlAndParameters<>( + "select id, category_name, classification, order_number, states, levels, father_category_id, create_user_id, create_time, create_user_name, d_time, d_user_id, d_user_name from " + + this.getTableName_() + " " + where, + parameters); } /** @@ -215,7 +262,10 @@ */ @Override public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) { - return new SqlAndParameters<>("select id, category_name, classification, order_number, states, levels, father_category_id from " + this.getTableName_() + " " + where, parameters); + return new SqlAndParameters<>( + "select id, category_name, classification, order_number, states, levels, father_category_id, create_user_id, create_time, create_user_name, d_time, d_user_id, d_user_name from " + + this.getTableName_() + " " + where, + parameters); } /** @@ -246,12 +296,12 @@ ResultSetUtils resultSetUtils = new ResultSetUtils(); BaseCategory base_category = new BaseCategory(); Integer columnIndex; - //涓婚敭 + // 涓婚敭 columnIndex = resultSetUtils.findColumn(rs, BaseCategory_mapper.Id); if (columnIndex > 0) { base_category.setId(rs.getLong(columnIndex)); } - //鏅�氬睘鎬� + // 鏅�氬睘鎬� columnIndex = resultSetUtils.findColumn(rs, BaseCategory_mapper.CategoryName); if (columnIndex > 0) { base_category.setCategoryName(rs.getString(columnIndex)); @@ -292,6 +342,46 @@ base_category.setFatherCategoryId(rs.getLong(columnIndex)); } } + columnIndex = resultSetUtils.findColumn(rs, BaseCategory_mapper.CreateUserId); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + base_category.setCreateUserId(null); + } else { + base_category.setCreateUserId(rs.getLong(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, BaseCategory_mapper.CreateTime); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + base_category.setCreateTime(null); + } else { + base_category.setCreateTime(rs.getLong(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, BaseCategory_mapper.CreateUserName); + if (columnIndex > 0) { + base_category.setCreateUserName(rs.getString(columnIndex)); + } + columnIndex = resultSetUtils.findColumn(rs, BaseCategory_mapper.DTime); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + base_category.setDTime(null); + } else { + base_category.setDTime(rs.getLong(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, BaseCategory_mapper.DUserId); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + base_category.setDUserId(null); + } else { + base_category.setDUserId(rs.getLong(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, BaseCategory_mapper.DUserName); + if (columnIndex > 0) { + base_category.setDUserName(rs.getString(columnIndex)); + } return base_category; } } -- Gitblit v1.9.1