| | |
| | | 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"; |
| | | |
| | | /** |
| | | * 默认构造函数 |
| | |
| | | } |
| | | 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_()); |
| | |
| | | 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(); |
| | | } |
| | | |
| | |
| | | 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(); |
| | | } |
| | |
| | | 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); |
| | | } |
| | | |
| | |
| | | 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); |
| | | } |
| | | |
| | |
| | | */ |
| | | @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); |
| | | } |
| | | |
| | | /** |
| | |
| | | */ |
| | | @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); |
| | | } |
| | | |
| | | /** |
| | |
| | | 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; |
| | | } |
| | | } |