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 org.springframework.jdbc.core.RowMapper; import java.sql.ResultSet; import java.sql.SQLException; import java.util.Map; /** * 表名:FIN_SYS_TENANT_REGION * * @author genrator */ public class FinSysTenantRegion_mapper extends FinSysTenantRegion implements BaseMapper { // 序列化版本号 private static final long serialVersionUID = 1L; public static final RowMapper ROW_MAPPER = new FinSysTenantRegionRowMapper(); // 主键 public static final String TempId = "temp_id"; // 普通属性 public static final String Id = "id"; public static final String ParentId = "parent_id"; public static final String Code = "code"; public static final String FinanceOrgCode = "finance_org_code"; public static final String Name = "name"; public static final String Lv1Id = "lv1_id"; public static final String Lv1Name = "lv1_name"; public static final String Lv2Id = "lv2_id"; public static final String Lv2Name = "lv2_name"; public static final String Lv3Id = "lv3_id"; public static final String Lv3Name = "lv3_name"; public static final String Lv4Id = "lv4_id"; public static final String Lv4Name = "lv4_name"; public static final String Lv5Id = "lv5_id"; public static final String Lv5Name = "lv5_name"; public static final String Lv = "lv"; public static final String OrderNum = "order_num"; public static final String CreateTime3 = "create_time3"; public static final String Modified = "modified"; public static final String Summary = "summary"; public static final String Address = "address"; public static final String Lng = "lng"; public static final String Lat = "lat"; public static final String OpenStatus = "open_status"; public static final String OpenTime = "open_time"; public static final String Status = "status"; public static final String IsDelete = "is_delete"; public static final String Path = "path"; public static final String VenueName = "venue_name"; public static final String CityId = "city_id"; public static final String OrgPhoto = "org_photo"; public static final String ShortName = "short_name"; public static final String TenantType = "tenant_type"; public static final String CreateBy = "create_by"; public static final String CreateTime = "create_time"; public static final String UpdateBy = "update_by"; public static final String UpdateTime = "update_time"; public static final String BelongProvince = "belong_province"; /** * 默认构造函数 */ public FinSysTenantRegion_mapper(FinSysTenantRegion finSysTenantRegion) { if (finSysTenantRegion == null) { throw new IllegalArgumentException("po参数不允许为空！"); } //主键 if (finSysTenantRegion.isset_tempId) { this.setTempId(finSysTenantRegion.getTempId()); } //普通属性 if (finSysTenantRegion.isset_id) { this.setId(finSysTenantRegion.getId()); } if (finSysTenantRegion.isset_parentId) { this.setParentId(finSysTenantRegion.getParentId()); } if (finSysTenantRegion.isset_code) { this.setCode(finSysTenantRegion.getCode()); } if (finSysTenantRegion.isset_financeOrgCode) { this.setFinanceOrgCode(finSysTenantRegion.getFinanceOrgCode()); } if (finSysTenantRegion.isset_name) { this.setName(finSysTenantRegion.getName()); } if (finSysTenantRegion.isset_lv1Id) { this.setLv1Id(finSysTenantRegion.getLv1Id()); } if (finSysTenantRegion.isset_lv1Name) { this.setLv1Name(finSysTenantRegion.getLv1Name()); } if (finSysTenantRegion.isset_lv2Id) { this.setLv2Id(finSysTenantRegion.getLv2Id()); } if (finSysTenantRegion.isset_lv2Name) { this.setLv2Name(finSysTenantRegion.getLv2Name()); } if (finSysTenantRegion.isset_lv3Id) { this.setLv3Id(finSysTenantRegion.getLv3Id()); } if (finSysTenantRegion.isset_lv3Name) { this.setLv3Name(finSysTenantRegion.getLv3Name()); } if (finSysTenantRegion.isset_lv4Id) { this.setLv4Id(finSysTenantRegion.getLv4Id()); } if (finSysTenantRegion.isset_lv4Name) { this.setLv4Name(finSysTenantRegion.getLv4Name()); } if (finSysTenantRegion.isset_lv5Id) { this.setLv5Id(finSysTenantRegion.getLv5Id()); } if (finSysTenantRegion.isset_lv5Name) { this.setLv5Name(finSysTenantRegion.getLv5Name()); } if (finSysTenantRegion.isset_lv) { this.setLv(finSysTenantRegion.getLv()); } if (finSysTenantRegion.isset_orderNum) { this.setOrderNum(finSysTenantRegion.getOrderNum()); } if (finSysTenantRegion.isset_createTime3) { this.setCreateTime3(finSysTenantRegion.getCreateTime3()); } if (finSysTenantRegion.isset_modified) { this.setModified(finSysTenantRegion.getModified()); } if (finSysTenantRegion.isset_summary) { this.setSummary(finSysTenantRegion.getSummary()); } if (finSysTenantRegion.isset_address) { this.setAddress(finSysTenantRegion.getAddress()); } if (finSysTenantRegion.isset_lng) { this.setLng(finSysTenantRegion.getLng()); } if (finSysTenantRegion.isset_lat) { this.setLat(finSysTenantRegion.getLat()); } if (finSysTenantRegion.isset_openStatus) { this.setOpenStatus(finSysTenantRegion.getOpenStatus()); } if (finSysTenantRegion.isset_openTime) { this.setOpenTime(finSysTenantRegion.getOpenTime()); } if (finSysTenantRegion.isset_status) { this.setStatus(finSysTenantRegion.getStatus()); } if (finSysTenantRegion.isset_isDelete) { this.setIsDelete(finSysTenantRegion.getIsDelete()); } if (finSysTenantRegion.isset_path) { this.setPath(finSysTenantRegion.getPath()); } if (finSysTenantRegion.isset_venueName) { this.setVenueName(finSysTenantRegion.getVenueName()); } if (finSysTenantRegion.isset_cityId) { this.setCityId(finSysTenantRegion.getCityId()); } if (finSysTenantRegion.isset_orgPhoto) { this.setOrgPhoto(finSysTenantRegion.getOrgPhoto()); } if (finSysTenantRegion.isset_shortName) { this.setShortName(finSysTenantRegion.getShortName()); } if (finSysTenantRegion.isset_tenantType) { this.setTenantType(finSysTenantRegion.getTenantType()); } if (finSysTenantRegion.isset_createBy) { this.setCreateBy(finSysTenantRegion.getCreateBy()); } if (finSysTenantRegion.isset_createTime) { this.setCreateTime(finSysTenantRegion.getCreateTime()); } if (finSysTenantRegion.isset_updateBy) { this.setUpdateBy(finSysTenantRegion.getUpdateBy()); } if (finSysTenantRegion.isset_updateTime) { this.setUpdateTime(finSysTenantRegion.getUpdateTime()); } if (finSysTenantRegion.isset_belongProvince) { this.setBelongProvince(finSysTenantRegion.getBelongProvince()); } // 去掉，2022-09-07 // this.setDatabaseName_(fin_sys_tenant_region.getDatabaseName_()); } /** * 获取表名 */ @Override public String getTableName_() { String tableName = "fin_sys_tenant_region"; /** if (StringUtils.isNotEmpty(this.getDatabaseName_())) { return this.getDatabaseName_() + "." + tableName; } else { return tableName; } */ return tableName; } /** * 获取主键名称 */ @Override public String getPkName_() { return TempId; } /** * 获取主键值 */ @Override public Object getPkValue_() { return this.getTempId(); } /** * 获取插入语句和参数 */ @Override public SqlAndParameters> getInsertSql_() { InsertBuilder ib = new InsertBuilder(this.getTableName_()); ib.set(TempId, this.getTempId()); ib.set(Id, this.getId(), this.isset_id); ib.set(ParentId, this.getParentId(), this.isset_parentId); ib.set(Code, this.getCode(), this.isset_code); ib.set(FinanceOrgCode, this.getFinanceOrgCode(), this.isset_financeOrgCode); ib.set(Name, this.getName(), this.isset_name); ib.set(Lv1Id, this.getLv1Id(), this.isset_lv1Id); ib.set(Lv1Name, this.getLv1Name(), this.isset_lv1Name); ib.set(Lv2Id, this.getLv2Id(), this.isset_lv2Id); ib.set(Lv2Name, this.getLv2Name(), this.isset_lv2Name); ib.set(Lv3Id, this.getLv3Id(), this.isset_lv3Id); ib.set(Lv3Name, this.getLv3Name(), this.isset_lv3Name); ib.set(Lv4Id, this.getLv4Id(), this.isset_lv4Id); ib.set(Lv4Name, this.getLv4Name(), this.isset_lv4Name); ib.set(Lv5Id, this.getLv5Id(), this.isset_lv5Id); ib.set(Lv5Name, this.getLv5Name(), this.isset_lv5Name); ib.set(Lv, this.getLv(), this.isset_lv); ib.set(OrderNum, this.getOrderNum(), this.isset_orderNum); ib.set(CreateTime3, this.getCreateTime3(), this.isset_createTime3); ib.set(Modified, this.getModified(), this.isset_modified); ib.set(Summary, this.getSummary(), this.isset_summary); ib.set(Address, this.getAddress(), this.isset_address); ib.set(Lng, this.getLng(), this.isset_lng); ib.set(Lat, this.getLat(), this.isset_lat); ib.set(OpenStatus, this.getOpenStatus(), this.isset_openStatus); ib.set(OpenTime, this.getOpenTime(), this.isset_openTime); ib.set(Status, this.getStatus(), this.isset_status); ib.set(IsDelete, this.getIsDelete(), this.isset_isDelete); ib.set(Path, this.getPath(), this.isset_path); ib.set(VenueName, this.getVenueName(), this.isset_venueName); ib.set(CityId, this.getCityId(), this.isset_cityId); ib.set(OrgPhoto, this.getOrgPhoto(), this.isset_orgPhoto); ib.set(ShortName, this.getShortName(), this.isset_shortName); ib.set(TenantType, this.getTenantType(), this.isset_tenantType); ib.set(CreateBy, this.getCreateBy(), this.isset_createBy); ib.set(CreateTime, this.getCreateTime(), this.isset_createTime); ib.set(UpdateBy, this.getUpdateBy(), this.isset_updateBy); ib.set(UpdateTime, this.getUpdateTime(), this.isset_updateTime); ib.set(BelongProvince, this.getBelongProvince(), this.isset_belongProvince); return ib.genMapSql(); } /** * 获取更新语句和参数 */ @Override public SqlAndParameters> getUpdateSql_() { UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); ub.set(Id, this.getId(), this.isset_id); ub.set(ParentId, this.getParentId(), this.isset_parentId); ub.set(Code, this.getCode(), this.isset_code); ub.set(FinanceOrgCode, this.getFinanceOrgCode(), this.isset_financeOrgCode); ub.set(Name, this.getName(), this.isset_name); ub.set(Lv1Id, this.getLv1Id(), this.isset_lv1Id); ub.set(Lv1Name, this.getLv1Name(), this.isset_lv1Name); ub.set(Lv2Id, this.getLv2Id(), this.isset_lv2Id); ub.set(Lv2Name, this.getLv2Name(), this.isset_lv2Name); ub.set(Lv3Id, this.getLv3Id(), this.isset_lv3Id); ub.set(Lv3Name, this.getLv3Name(), this.isset_lv3Name); ub.set(Lv4Id, this.getLv4Id(), this.isset_lv4Id); ub.set(Lv4Name, this.getLv4Name(), this.isset_lv4Name); ub.set(Lv5Id, this.getLv5Id(), this.isset_lv5Id); ub.set(Lv5Name, this.getLv5Name(), this.isset_lv5Name); ub.set(Lv, this.getLv(), this.isset_lv); ub.set(OrderNum, this.getOrderNum(), this.isset_orderNum); ub.set(CreateTime3, this.getCreateTime3(), this.isset_createTime3); ub.set(Modified, this.getModified(), this.isset_modified); ub.set(Summary, this.getSummary(), this.isset_summary); ub.set(Address, this.getAddress(), this.isset_address); ub.set(Lng, this.getLng(), this.isset_lng); ub.set(Lat, this.getLat(), this.isset_lat); ub.set(OpenStatus, this.getOpenStatus(), this.isset_openStatus); ub.set(OpenTime, this.getOpenTime(), this.isset_openTime); ub.set(Status, this.getStatus(), this.isset_status); ub.set(IsDelete, this.getIsDelete(), this.isset_isDelete); ub.set(Path, this.getPath(), this.isset_path); ub.set(VenueName, this.getVenueName(), this.isset_venueName); ub.set(CityId, this.getCityId(), this.isset_cityId); ub.set(OrgPhoto, this.getOrgPhoto(), this.isset_orgPhoto); ub.set(ShortName, this.getShortName(), this.isset_shortName); ub.set(TenantType, this.getTenantType(), this.isset_tenantType); ub.set(CreateBy, this.getCreateBy(), this.isset_createBy); ub.set(CreateTime, this.getCreateTime(), this.isset_createTime); ub.set(UpdateBy, this.getUpdateBy(), this.isset_updateBy); ub.set(UpdateTime, this.getUpdateTime(), this.isset_updateTime); ub.set(BelongProvince, this.getBelongProvince(), this.isset_belongProvince); ub.where(this.getPkName_(), this.getPkValue_()); return ub.genMapSql(); } /** * 获取更新语句和参数 */ @Override public SqlAndParameters> getUpdateSql_(String where, Map parameters) { UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); ub.set(Id, this.getId(), this.isset_id); ub.set(ParentId, this.getParentId(), this.isset_parentId); ub.set(Code, this.getCode(), this.isset_code); ub.set(FinanceOrgCode, this.getFinanceOrgCode(), this.isset_financeOrgCode); ub.set(Name, this.getName(), this.isset_name); ub.set(Lv1Id, this.getLv1Id(), this.isset_lv1Id); ub.set(Lv1Name, this.getLv1Name(), this.isset_lv1Name); ub.set(Lv2Id, this.getLv2Id(), this.isset_lv2Id); ub.set(Lv2Name, this.getLv2Name(), this.isset_lv2Name); ub.set(Lv3Id, this.getLv3Id(), this.isset_lv3Id); ub.set(Lv3Name, this.getLv3Name(), this.isset_lv3Name); ub.set(Lv4Id, this.getLv4Id(), this.isset_lv4Id); ub.set(Lv4Name, this.getLv4Name(), this.isset_lv4Name); ub.set(Lv5Id, this.getLv5Id(), this.isset_lv5Id); ub.set(Lv5Name, this.getLv5Name(), this.isset_lv5Name); ub.set(Lv, this.getLv(), this.isset_lv); ub.set(OrderNum, this.getOrderNum(), this.isset_orderNum); ub.set(CreateTime3, this.getCreateTime3(), this.isset_createTime3); ub.set(Modified, this.getModified(), this.isset_modified); ub.set(Summary, this.getSummary(), this.isset_summary); ub.set(Address, this.getAddress(), this.isset_address); ub.set(Lng, this.getLng(), this.isset_lng); ub.set(Lat, this.getLat(), this.isset_lat); ub.set(OpenStatus, this.getOpenStatus(), this.isset_openStatus); ub.set(OpenTime, this.getOpenTime(), this.isset_openTime); ub.set(Status, this.getStatus(), this.isset_status); ub.set(IsDelete, this.getIsDelete(), this.isset_isDelete); ub.set(Path, this.getPath(), this.isset_path); ub.set(VenueName, this.getVenueName(), this.isset_venueName); ub.set(CityId, this.getCityId(), this.isset_cityId); ub.set(OrgPhoto, this.getOrgPhoto(), this.isset_orgPhoto); ub.set(ShortName, this.getShortName(), this.isset_shortName); ub.set(TenantType, this.getTenantType(), this.isset_tenantType); ub.set(CreateBy, this.getCreateBy(), this.isset_createBy); ub.set(CreateTime, this.getCreateTime(), this.isset_createTime); ub.set(UpdateBy, this.getUpdateBy(), this.isset_updateBy); ub.set(UpdateTime, this.getUpdateTime(), this.isset_updateTime); ub.set(BelongProvince, this.getBelongProvince(), this.isset_belongProvince); return ub.genMapSql(where, parameters); } /** * 获取更新语句和参数 */ @Override public SqlAndParameters getUpdateSql_(String where, Object[] parameters) { UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); ub.set(Id, this.getId(), this.isset_id); ub.set(ParentId, this.getParentId(), this.isset_parentId); ub.set(Code, this.getCode(), this.isset_code); ub.set(FinanceOrgCode, this.getFinanceOrgCode(), this.isset_financeOrgCode); ub.set(Name, this.getName(), this.isset_name); ub.set(Lv1Id, this.getLv1Id(), this.isset_lv1Id); ub.set(Lv1Name, this.getLv1Name(), this.isset_lv1Name); ub.set(Lv2Id, this.getLv2Id(), this.isset_lv2Id); ub.set(Lv2Name, this.getLv2Name(), this.isset_lv2Name); ub.set(Lv3Id, this.getLv3Id(), this.isset_lv3Id); ub.set(Lv3Name, this.getLv3Name(), this.isset_lv3Name); ub.set(Lv4Id, this.getLv4Id(), this.isset_lv4Id); ub.set(Lv4Name, this.getLv4Name(), this.isset_lv4Name); ub.set(Lv5Id, this.getLv5Id(), this.isset_lv5Id); ub.set(Lv5Name, this.getLv5Name(), this.isset_lv5Name); ub.set(Lv, this.getLv(), this.isset_lv); ub.set(OrderNum, this.getOrderNum(), this.isset_orderNum); ub.set(CreateTime3, this.getCreateTime3(), this.isset_createTime3); ub.set(Modified, this.getModified(), this.isset_modified); ub.set(Summary, this.getSummary(), this.isset_summary); ub.set(Address, this.getAddress(), this.isset_address); ub.set(Lng, this.getLng(), this.isset_lng); ub.set(Lat, this.getLat(), this.isset_lat); ub.set(OpenStatus, this.getOpenStatus(), this.isset_openStatus); ub.set(OpenTime, this.getOpenTime(), this.isset_openTime); ub.set(Status, this.getStatus(), this.isset_status); ub.set(IsDelete, this.getIsDelete(), this.isset_isDelete); ub.set(Path, this.getPath(), this.isset_path); ub.set(VenueName, this.getVenueName(), this.isset_venueName); ub.set(CityId, this.getCityId(), this.isset_cityId); ub.set(OrgPhoto, this.getOrgPhoto(), this.isset_orgPhoto); ub.set(ShortName, this.getShortName(), this.isset_shortName); ub.set(TenantType, this.getTenantType(), this.isset_tenantType); ub.set(CreateBy, this.getCreateBy(), this.isset_createBy); ub.set(CreateTime, this.getCreateTime(), this.isset_createTime); ub.set(UpdateBy, this.getUpdateBy(), this.isset_updateBy); ub.set(UpdateTime, this.getUpdateTime(), this.isset_updateTime); ub.set(BelongProvince, this.getBelongProvince(), this.isset_belongProvince); return ub.genArraySql(where, parameters); } /** * 获取删除语句和参数 */ @Override public SqlAndParameters> getDeleteSql_() { DeleteBuilder db = new DeleteBuilder(this.getTableName_()); db.where(this.getPkName_(), this.getPkValue_()); return db.genMapSql(); } /** * 获取删除语句和参数 */ @Override public SqlAndParameters> getDeleteSql_(String where, Map parameters) { DeleteBuilder db = new DeleteBuilder(this.getTableName_()); return db.genMapSql(where, parameters); } /** * 获取删除语句和参数 */ @Override public SqlAndParameters getDeleteSql_(String where, Object[] parameters) { DeleteBuilder db = new DeleteBuilder(this.getTableName_()); return db.genArraySql(where, parameters); } /** * 获取单行查询语句和参数 */ @Override public SqlAndParameters> getSingleSql_() { SelectBuilder sb = new SelectBuilder(this.getTableName_()); sb.where(this.getPkName_(), this.getPkValue_()); return sb.genMapSql(); } /** * 获取查询语句和参数 */ @Override public SqlAndParameters> getSelectSql_(String where, Map parameters) { return new SqlAndParameters<>("select temp_id, id, parent_id, code, finance_org_code, name, lv1_id, lv1_name, lv2_id, lv2_name, lv3_id, lv3_name, lv4_id, lv4_name, lv5_id, lv5_name, lv, order_num, create_time3, modified, summary, address, lng, lat, open_status, open_time, status, is_delete, path, venue_name, city_id, org_photo, short_name, tenant_type, create_by, create_time, update_by, update_time, belong_province from " + this.getTableName_() + " " + where, parameters); } /** * 获取查询语句和参数 */ @Override public SqlAndParameters getSelectSql_(String where, Object[] parameters) { return new SqlAndParameters<>("select temp_id, id, parent_id, code, finance_org_code, name, lv1_id, lv1_name, lv2_id, lv2_name, lv3_id, lv3_name, lv4_id, lv4_name, lv5_id, lv5_name, lv, order_num, create_time3, modified, summary, address, lng, lat, open_status, open_time, status, is_delete, path, venue_name, city_id, org_photo, short_name, tenant_type, create_by, create_time, update_by, update_time, belong_province from " + this.getTableName_() + " " + where, parameters); } /** * 将resultset的一行转化为po */ @Override public FinSysTenantRegion mapRow(ResultSet rs, int i) throws SQLException { return ROW_MAPPER.mapRow(rs, i); } /** * 克隆 */ public FinSysTenantRegion toFinSysTenantRegion() { return super.$clone(); } } /** * fin_sys_tenant_region RowMapper * * @author genrator */ class FinSysTenantRegionRowMapper implements RowMapper { @Override public FinSysTenantRegion mapRow(ResultSet rs, int i) throws SQLException { ResultSetUtils resultSetUtils = new ResultSetUtils(); FinSysTenantRegion fin_sys_tenant_region = new FinSysTenantRegion(); Integer columnIndex; //主键 columnIndex = resultSetUtils.findColumn(rs, FinSysTenantRegion_mapper.TempId); if (columnIndex > 0) { fin_sys_tenant_region.setTempId(rs.getLong(columnIndex)); } //普通属性 columnIndex = resultSetUtils.findColumn(rs, FinSysTenantRegion_mapper.Id); if (columnIndex > 0) { if (rs.getBigDecimal(columnIndex) == null) { fin_sys_tenant_region.setId(null); } else { fin_sys_tenant_region.setId(rs.getLong(columnIndex)); } } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantRegion_mapper.ParentId); if (columnIndex > 0) { if (rs.getBigDecimal(columnIndex) == null) { fin_sys_tenant_region.setParentId(null); } else { fin_sys_tenant_region.setParentId(rs.getLong(columnIndex)); } } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantRegion_mapper.Code); if (columnIndex > 0) { fin_sys_tenant_region.setCode(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantRegion_mapper.FinanceOrgCode); if (columnIndex > 0) { fin_sys_tenant_region.setFinanceOrgCode(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantRegion_mapper.Name); if (columnIndex > 0) { fin_sys_tenant_region.setName(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantRegion_mapper.Lv1Id); if (columnIndex > 0) { if (rs.getBigDecimal(columnIndex) == null) { fin_sys_tenant_region.setLv1Id(null); } else { fin_sys_tenant_region.setLv1Id(rs.getLong(columnIndex)); } } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantRegion_mapper.Lv1Name); if (columnIndex > 0) { fin_sys_tenant_region.setLv1Name(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantRegion_mapper.Lv2Id); if (columnIndex > 0) { if (rs.getBigDecimal(columnIndex) == null) { fin_sys_tenant_region.setLv2Id(null); } else { fin_sys_tenant_region.setLv2Id(rs.getLong(columnIndex)); } } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantRegion_mapper.Lv2Name); if (columnIndex > 0) { fin_sys_tenant_region.setLv2Name(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantRegion_mapper.Lv3Id); if (columnIndex > 0) { if (rs.getBigDecimal(columnIndex) == null) { fin_sys_tenant_region.setLv3Id(null); } else { fin_sys_tenant_region.setLv3Id(rs.getLong(columnIndex)); } } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantRegion_mapper.Lv3Name); if (columnIndex > 0) { fin_sys_tenant_region.setLv3Name(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantRegion_mapper.Lv4Id); if (columnIndex > 0) { if (rs.getBigDecimal(columnIndex) == null) { fin_sys_tenant_region.setLv4Id(null); } else { fin_sys_tenant_region.setLv4Id(rs.getLong(columnIndex)); } } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantRegion_mapper.Lv4Name); if (columnIndex > 0) { fin_sys_tenant_region.setLv4Name(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantRegion_mapper.Lv5Id); if (columnIndex > 0) { if (rs.getBigDecimal(columnIndex) == null) { fin_sys_tenant_region.setLv5Id(null); } else { fin_sys_tenant_region.setLv5Id(rs.getLong(columnIndex)); } } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantRegion_mapper.Lv5Name); if (columnIndex > 0) { fin_sys_tenant_region.setLv5Name(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantRegion_mapper.Lv); if (columnIndex > 0) { if (rs.getBigDecimal(columnIndex) == null) { fin_sys_tenant_region.setLv(null); } else { fin_sys_tenant_region.setLv(rs.getInt(columnIndex)); } } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantRegion_mapper.OrderNum); if (columnIndex > 0) { if (rs.getBigDecimal(columnIndex) == null) { fin_sys_tenant_region.setOrderNum(null); } else { fin_sys_tenant_region.setOrderNum(rs.getInt(columnIndex)); } } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantRegion_mapper.CreateTime3); if (columnIndex > 0) { fin_sys_tenant_region.setCreateTime3(rs.getDate(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantRegion_mapper.Modified); if (columnIndex > 0) { fin_sys_tenant_region.setModified(rs.getDate(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantRegion_mapper.Summary); if (columnIndex > 0) { fin_sys_tenant_region.setSummary(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantRegion_mapper.Address); if (columnIndex > 0) { fin_sys_tenant_region.setAddress(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantRegion_mapper.Lng); if (columnIndex > 0) { fin_sys_tenant_region.setLng(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantRegion_mapper.Lat); if (columnIndex > 0) { fin_sys_tenant_region.setLat(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantRegion_mapper.OpenStatus); if (columnIndex > 0) { if (rs.getBigDecimal(columnIndex) == null) { fin_sys_tenant_region.setOpenStatus(null); } else { fin_sys_tenant_region.setOpenStatus(rs.getInt(columnIndex)); } } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantRegion_mapper.OpenTime); if (columnIndex > 0) { fin_sys_tenant_region.setOpenTime(rs.getDate(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantRegion_mapper.Status); if (columnIndex > 0) { if (rs.getBigDecimal(columnIndex) == null) { fin_sys_tenant_region.setStatus(null); } else { fin_sys_tenant_region.setStatus(rs.getInt(columnIndex)); } } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantRegion_mapper.IsDelete); if (columnIndex > 0) { if (rs.getBigDecimal(columnIndex) == null) { fin_sys_tenant_region.setIsDelete(null); } else { fin_sys_tenant_region.setIsDelete(rs.getInt(columnIndex)); } } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantRegion_mapper.Path); if (columnIndex > 0) { fin_sys_tenant_region.setPath(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantRegion_mapper.VenueName); if (columnIndex > 0) { fin_sys_tenant_region.setVenueName(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantRegion_mapper.CityId); if (columnIndex > 0) { if (rs.getBigDecimal(columnIndex) == null) { fin_sys_tenant_region.setCityId(null); } else { fin_sys_tenant_region.setCityId(rs.getLong(columnIndex)); } } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantRegion_mapper.OrgPhoto); if (columnIndex > 0) { fin_sys_tenant_region.setOrgPhoto(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantRegion_mapper.ShortName); if (columnIndex > 0) { fin_sys_tenant_region.setShortName(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantRegion_mapper.TenantType); if (columnIndex > 0) { if (rs.getBigDecimal(columnIndex) == null) { fin_sys_tenant_region.setTenantType(null); } else { fin_sys_tenant_region.setTenantType(rs.getInt(columnIndex)); } } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantRegion_mapper.CreateBy); if (columnIndex > 0) { fin_sys_tenant_region.setCreateBy(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantRegion_mapper.CreateTime); if (columnIndex > 0) { if (rs.getBigDecimal(columnIndex) == null) { fin_sys_tenant_region.setCreateTime(null); } else { fin_sys_tenant_region.setCreateTime(rs.getLong(columnIndex)); } } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantRegion_mapper.UpdateBy); if (columnIndex > 0) { fin_sys_tenant_region.setUpdateBy(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantRegion_mapper.UpdateTime); if (columnIndex > 0) { if (rs.getBigDecimal(columnIndex) == null) { fin_sys_tenant_region.setUpdateTime(null); } else { fin_sys_tenant_region.setUpdateTime(rs.getLong(columnIndex)); } } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantRegion_mapper.BelongProvince); if (columnIndex > 0) { if (rs.getBigDecimal(columnIndex) == null) { fin_sys_tenant_region.setBelongProvince(null); } else { fin_sys_tenant_region.setBelongProvince(rs.getInt(columnIndex)); } } return fin_sys_tenant_region; } }