From a1b85ef72062ca80db35546e4216dd564f3e0f57 Mon Sep 17 00:00:00 2001
From: WangHan <wwh_work@126,com>
Date: 星期四, 03 四月 2025 15:58:19 +0800
Subject: [PATCH] 问题与漏洞修改
---
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