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_USER * * * @author genrator */ public class FinSysTenantUser_mapper extends FinSysTenantUser implements BaseMapper { // 序列化版本号 private static final long serialVersionUID = 1L; public static final RowMapper ROW_MAPPER = new FinSysTenantUserRowMapper(); // 主键 public static final String Id = "id"; // 普通属性 public static final String UserName = "user_name"; public static final String Avatar = "avatar"; public static final String Email = "email"; public static final String UserCode = "user_code"; public static final String TenantId = "tenant_id"; 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 Sex = "sex"; public static final String Status = "status"; public static final String Seq = "seq"; public static final String Remark = "remark"; public static final String SysUserId = "sys_user_id"; public static final String SysDeptId = "sys_dept_id"; public static final String TenantCode = "tenant_code"; public static final String UserPhone = "user_phone"; public static final String IsDelete = "is_delete"; public static final String KfStatus = "kf_status"; public static final String AgentJid = "agent_jid"; public static final String WorkgroupJid = "workgroup_jid"; public static final String ClientNumber = "client_number"; public static final String ClientPd = "client_pwd"; public static final String TenantName = "tenant_name"; public static final String Lv = "lv"; public static final String SupplierId = "supplier_Id"; public static final String RoleStr = "roleStr"; public static final String IsOnline = "is_online"; public static final String ParentCode = "parent_code"; /** * 默认构造函数 */ public FinSysTenantUser_mapper(FinSysTenantUser finSysTenantUser) { if (finSysTenantUser == null) { throw new IllegalArgumentException("po参数不允许为空！"); } //主键 if (finSysTenantUser.isset_id) { this.setId(finSysTenantUser.getId()); } //普通属性 if (finSysTenantUser.isset_userName) { this.setUserName(finSysTenantUser.getUserName()); } if (finSysTenantUser.isset_avatar) { this.setAvatar(finSysTenantUser.getAvatar()); } if (finSysTenantUser.isset_email) { this.setEmail(finSysTenantUser.getEmail()); } if (finSysTenantUser.isset_userCode) { this.setUserCode(finSysTenantUser.getUserCode()); } if (finSysTenantUser.isset_tenantId) { this.setTenantId(finSysTenantUser.getTenantId()); } if (finSysTenantUser.isset_createBy) { this.setCreateBy(finSysTenantUser.getCreateBy()); } if (finSysTenantUser.isset_createTime) { this.setCreateTime(finSysTenantUser.getCreateTime()); } if (finSysTenantUser.isset_updateBy) { this.setUpdateBy(finSysTenantUser.getUpdateBy()); } if (finSysTenantUser.isset_updateTime) { this.setUpdateTime(finSysTenantUser.getUpdateTime()); } if (finSysTenantUser.isset_sex) { this.setSex(finSysTenantUser.getSex()); } if (finSysTenantUser.isset_status) { this.setStatus(finSysTenantUser.getStatus()); } if (finSysTenantUser.isset_seq) { this.setSeq(finSysTenantUser.getSeq()); } if (finSysTenantUser.isset_remark) { this.setRemark(finSysTenantUser.getRemark()); } if (finSysTenantUser.isset_sysUserId) { this.setSysUserId(finSysTenantUser.getSysUserId()); } if (finSysTenantUser.isset_sysDeptId) { this.setSysDeptId(finSysTenantUser.getSysDeptId()); } if (finSysTenantUser.isset_tenantCode) { this.setTenantCode(finSysTenantUser.getTenantCode()); } if (finSysTenantUser.isset_userPhone) { this.setUserPhone(finSysTenantUser.getUserPhone()); } if (finSysTenantUser.isset_isDelete) { this.setIsDelete(finSysTenantUser.getIsDelete()); } if (finSysTenantUser.isset_kfStatus) { this.setKfStatus(finSysTenantUser.getKfStatus()); } if (finSysTenantUser.isset_agentJid) { this.setAgentJid(finSysTenantUser.getAgentJid()); } if (finSysTenantUser.isset_workgroupJid) { this.setWorkgroupJid(finSysTenantUser.getWorkgroupJid()); } if (finSysTenantUser.isset_clientNumber) { this.setClientNumber(finSysTenantUser.getClientNumber()); } if (finSysTenantUser.isset_clientPwd) { this.setClientPwd(finSysTenantUser.getClientPwd()); } if (finSysTenantUser.isset_tenantName) { this.setTenantName(finSysTenantUser.getTenantName()); } if (finSysTenantUser.isset_lv) { this.setLv(finSysTenantUser.getLv()); } if (finSysTenantUser.isset_supplierId) { this.setSupplierId(finSysTenantUser.getSupplierId()); } if (finSysTenantUser.isset_roleStr) { this.setRoleStr(finSysTenantUser.getRoleStr()); } if (finSysTenantUser.isset_isOnline) { this.setIsOnline(finSysTenantUser.getIsOnline()); } if (finSysTenantUser.isset_parentCode) { this.setParentCode(finSysTenantUser.getParentCode()); } // 去掉，2022-09-07 // this.setDatabaseName_(fin_sys_tenant_user.getDatabaseName_()); } /** * 获取表名 */ @Override public String getTableName_() { String tableName = "fin_sys_tenant_user"; /** if (StringUtils.isNotEmpty(this.getDatabaseName_())) { return this.getDatabaseName_() + "." + tableName; } else { return tableName; } */ return tableName; } /** * 获取主键名称 */ @Override public String getPkName_() { return Id; } /** * 获取主键值 */ @Override public Object getPkValue_() { return this.getId(); } /** * 获取插入语句和参数 */ @Override public SqlAndParameters> getInsertSql_() { InsertBuilder ib = new InsertBuilder(this.getTableName_()); ib.set(Id, this.getId()); ib.set(UserName, this.getUserName(), this.isset_userName); ib.set(Avatar, this.getAvatar(), this.isset_avatar); ib.set(Email, this.getEmail(), this.isset_email); ib.set(UserCode, this.getUserCode(), this.isset_userCode); ib.set(TenantId, this.getTenantId(), this.isset_tenantId); 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(Sex, this.getSex(), this.isset_sex); ib.set(Status, this.getStatus(), this.isset_status); ib.set(Seq, this.getSeq(), this.isset_seq); ib.set(Remark, this.getRemark(), this.isset_remark); ib.set(SysUserId, this.getSysUserId(), this.isset_sysUserId); ib.set(SysDeptId, this.getSysDeptId(), this.isset_sysDeptId); ib.set(TenantCode, this.getTenantCode(), this.isset_tenantCode); ib.set(UserPhone, this.getUserPhone(), this.isset_userPhone); ib.set(IsDelete, this.getIsDelete(), this.isset_isDelete); ib.set(KfStatus, this.getKfStatus(), this.isset_kfStatus); ib.set(SupplierId, this.getSupplierId(), this.isset_supplierId); ib.set(AgentJid, this.getAgentJid(), this.isset_agentJid); ib.set(WorkgroupJid, this.getWorkgroupJid(), this.isset_workgroupJid); ib.set(ClientNumber, this.getClientNumber(), this.isset_clientNumber); ib.set(ClientPd, this.getClientPwd(), this.isset_clientPwd); return ib.genMapSql(); } /** * 获取更新语句和参数 */ @Override public SqlAndParameters> getUpdateSql_() { UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); ub.set(UserName, this.getUserName(), this.isset_userName); ub.set(Avatar, this.getAvatar(), this.isset_avatar); ub.set(Email, this.getEmail(), this.isset_email); ub.set(UserCode, this.getUserCode(), this.isset_userCode); ub.set(TenantId, this.getTenantId(), this.isset_tenantId); 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(Sex, this.getSex(), this.isset_sex); ub.set(Status, this.getStatus(), this.isset_status); ub.set(Seq, this.getSeq(), this.isset_seq); ub.set(Remark, this.getRemark(), this.isset_remark); ub.set(SysUserId, this.getSysUserId(), this.isset_sysUserId); ub.set(SysDeptId, this.getSysDeptId(), this.isset_sysDeptId); ub.set(TenantCode, this.getTenantCode(), this.isset_tenantCode); ub.set(UserPhone, this.getUserPhone(), this.isset_userPhone); ub.set(IsDelete, this.getIsDelete(), this.isset_isDelete); ub.set(KfStatus, this.getKfStatus(), this.isset_kfStatus); ub.set(SupplierId, this.getSupplierId(), this.isset_supplierId); ub.set(AgentJid, this.getAgentJid(), this.isset_agentJid); ub.set(WorkgroupJid, this.getWorkgroupJid(), this.isset_workgroupJid); ub.set(ClientNumber, this.getClientNumber(), this.isset_clientNumber); ub.set(ClientPd, this.getClientPwd(), this.isset_clientPwd); 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(UserName, this.getUserName(), this.isset_userName); ub.set(Avatar, this.getAvatar(), this.isset_avatar); ub.set(Email, this.getEmail(), this.isset_email); ub.set(UserCode, this.getUserCode(), this.isset_userCode); ub.set(TenantId, this.getTenantId(), this.isset_tenantId); 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(Sex, this.getSex(), this.isset_sex); ub.set(Status, this.getStatus(), this.isset_status); ub.set(Seq, this.getSeq(), this.isset_seq); ub.set(Remark, this.getRemark(), this.isset_remark); ub.set(SysUserId, this.getSysUserId(), this.isset_sysUserId); ub.set(SysDeptId, this.getSysDeptId(), this.isset_sysDeptId); ub.set(TenantCode, this.getTenantCode(), this.isset_tenantCode); ub.set(UserPhone, this.getUserPhone(), this.isset_userPhone); ub.set(IsDelete, this.getIsDelete(), this.isset_isDelete); ub.set(KfStatus, this.getKfStatus(), this.isset_kfStatus); ub.set(SupplierId, this.getSupplierId(), this.isset_supplierId); ub.set(AgentJid, this.getAgentJid(), this.isset_agentJid); ub.set(WorkgroupJid, this.getWorkgroupJid(), this.isset_workgroupJid); ub.set(ClientNumber, this.getClientNumber(), this.isset_clientNumber); ub.set(ClientPd, this.getClientPwd(), this.isset_clientPwd); return ub.genMapSql(where, parameters); } /** * 获取更新语句和参数 */ @Override public SqlAndParameters getUpdateSql_(String where, Object[] parameters) { UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); ub.set(UserName, this.getUserName(), this.isset_userName); ub.set(Avatar, this.getAvatar(), this.isset_avatar); ub.set(Email, this.getEmail(), this.isset_email); ub.set(UserCode, this.getUserCode(), this.isset_userCode); ub.set(TenantId, this.getTenantId(), this.isset_tenantId); 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(Sex, this.getSex(), this.isset_sex); ub.set(Status, this.getStatus(), this.isset_status); ub.set(Seq, this.getSeq(), this.isset_seq); ub.set(Remark, this.getRemark(), this.isset_remark); ub.set(SysUserId, this.getSysUserId(), this.isset_sysUserId); ub.set(SysDeptId, this.getSysDeptId(), this.isset_sysDeptId); ub.set(TenantCode, this.getTenantCode(), this.isset_tenantCode); ub.set(UserPhone, this.getUserPhone(), this.isset_userPhone); ub.set(IsDelete, this.getIsDelete(), this.isset_isDelete); ub.set(KfStatus, this.getKfStatus(), this.isset_kfStatus); ub.set(SupplierId, this.getSupplierId(), this.isset_supplierId); ub.set(AgentJid, this.getAgentJid(), this.isset_agentJid); ub.set(WorkgroupJid, this.getWorkgroupJid(), this.isset_workgroupJid); ub.set(ClientNumber, this.getClientNumber(), this.isset_clientNumber); ub.set(ClientPd, this.getClientPwd(), this.isset_clientPwd); 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 id, user_name, user_code, tenant_id, create_by, create_time, update_by, update_time, sex, status, seq, remark, sys_user_id, sys_dept_id, tenant_code, user_phone, is_delete, kf_status, supplier_id, agent_jid, workgroup_jid, client_number, client_pwd from " + this.getTableName_() + " " + where, parameters); } /** * 获取查询语句和参数 */ @Override public SqlAndParameters getSelectSql_(String where, Object[] parameters) { return new SqlAndParameters<>("select id, user_name, user_code, tenant_id, create_by, create_time, update_by, update_time, sex, status, seq, remark, sys_user_id, sys_dept_id, tenant_code, user_phone, is_delete, kf_status, supplier_id, agent_jid, workgroup_jid, client_number, client_pwd from " + this.getTableName_() + " " + where, parameters); } /** * 将resultset的一行转化为po */ @Override public FinSysTenantUser mapRow(ResultSet rs, int i) throws SQLException { return ROW_MAPPER.mapRow(rs, i); } /** * 克隆 */ public FinSysTenantUser toFinSysTenantUser() { return super.$clone(); } } /** * fin_sys_tenant_user RowMapper * * @author genrator */ class FinSysTenantUserRowMapper implements RowMapper { @Override public FinSysTenantUser mapRow(ResultSet rs, int i) throws SQLException { ResultSetUtils resultSetUtils = new ResultSetUtils(); FinSysTenantUser fin_sys_tenant_user = new FinSysTenantUser(); Integer columnIndex; //主键 columnIndex = resultSetUtils.findColumn(rs, FinSysTenantUser_mapper.Id); if (columnIndex > 0) { fin_sys_tenant_user.setId(rs.getLong(columnIndex)); } //普通属性 columnIndex = resultSetUtils.findColumn(rs, FinSysTenantUser_mapper.UserName); if (columnIndex > 0) { fin_sys_tenant_user.setUserName(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantUser_mapper.Avatar); if (columnIndex > 0) { fin_sys_tenant_user.setAvatar(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantUser_mapper.Email); if (columnIndex > 0) { fin_sys_tenant_user.setEmail(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantUser_mapper.UserCode); if (columnIndex > 0) { fin_sys_tenant_user.setUserCode(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantUser_mapper.TenantId); if (columnIndex > 0) { fin_sys_tenant_user.setTenantId(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantUser_mapper.CreateBy); if (columnIndex > 0) { fin_sys_tenant_user.setCreateBy(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantUser_mapper.CreateTime); if (columnIndex > 0) { if (rs.getBigDecimal(columnIndex) == null) { fin_sys_tenant_user.setCreateTime(null); } else { fin_sys_tenant_user.setCreateTime(rs.getLong(columnIndex)); } } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantUser_mapper.UpdateBy); if (columnIndex > 0) { fin_sys_tenant_user.setUpdateBy(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantUser_mapper.UpdateTime); if (columnIndex > 0) { if (rs.getBigDecimal(columnIndex) == null) { fin_sys_tenant_user.setUpdateTime(null); } else { fin_sys_tenant_user.setUpdateTime(rs.getLong(columnIndex)); } } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantUser_mapper.Sex); if (columnIndex > 0) { if (rs.getBigDecimal(columnIndex) == null) { fin_sys_tenant_user.setSex(null); } else { fin_sys_tenant_user.setSex(rs.getInt(columnIndex)); } } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantUser_mapper.Status); if (columnIndex > 0) { if (rs.getBigDecimal(columnIndex) == null) { fin_sys_tenant_user.setStatus(null); } else { fin_sys_tenant_user.setStatus(rs.getInt(columnIndex)); } } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantUser_mapper.Seq); if (columnIndex > 0) { if (rs.getBigDecimal(columnIndex) == null) { fin_sys_tenant_user.setSeq(null); } else { fin_sys_tenant_user.setSeq(rs.getLong(columnIndex)); } } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantUser_mapper.Remark); if (columnIndex > 0) { fin_sys_tenant_user.setRemark(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantUser_mapper.SysUserId); if (columnIndex > 0) { if (rs.getBigDecimal(columnIndex) == null) { fin_sys_tenant_user.setSysUserId(null); } else { fin_sys_tenant_user.setSysUserId(rs.getLong(columnIndex)); } } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantUser_mapper.SysDeptId); if (columnIndex > 0) { if (rs.getBigDecimal(columnIndex) == null) { fin_sys_tenant_user.setSysDeptId(null); } else { fin_sys_tenant_user.setSysDeptId(rs.getLong(columnIndex)); } } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantUser_mapper.TenantCode); if (columnIndex > 0) { fin_sys_tenant_user.setTenantCode(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantUser_mapper.UserPhone); if (columnIndex > 0) { fin_sys_tenant_user.setUserPhone(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantUser_mapper.IsDelete); if (columnIndex > 0) { if (rs.getBigDecimal(columnIndex) == null) { fin_sys_tenant_user.setIsDelete(null); } else { fin_sys_tenant_user.setIsDelete(rs.getInt(columnIndex)); } } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantUser_mapper.TenantName); if (columnIndex > 0) { fin_sys_tenant_user.setTenantName(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantUser_mapper.Lv); if (columnIndex > 0) { fin_sys_tenant_user.setLv(rs.getInt(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantUser_mapper.RoleStr); if (columnIndex > 0) { fin_sys_tenant_user.setRoleStr(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantUser_mapper.SupplierId); if (columnIndex > 0) { if (rs.getBigDecimal(columnIndex) == null) { fin_sys_tenant_user.setSupplierId(null); } else { fin_sys_tenant_user.setSupplierId(rs.getLong(columnIndex)); } } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantUser_mapper.IsOnline); if (columnIndex > 0) { fin_sys_tenant_user.setIsOnline(rs.getBoolean(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantUser_mapper.ParentCode); if (columnIndex > 0) { fin_sys_tenant_user.setParentCode(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantUser_mapper.KfStatus); if (columnIndex > 0) { if (rs.getBigDecimal(columnIndex) == null) { fin_sys_tenant_user.setKfStatus(null); } else { fin_sys_tenant_user.setKfStatus(rs.getInt(columnIndex)); } } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantUser_mapper.AgentJid); if (columnIndex > 0) { fin_sys_tenant_user.setAgentJid(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantUser_mapper.WorkgroupJid); if (columnIndex > 0) { fin_sys_tenant_user.setWorkgroupJid(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantUser_mapper.ClientNumber); if (columnIndex > 0) { fin_sys_tenant_user.setClientNumber(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, FinSysTenantUser_mapper.ClientPd); if (columnIndex > 0) { fin_sys_tenant_user.setClientPwd(rs.getString(columnIndex)); } return fin_sys_tenant_user; } }