package com.iplatform.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 com.walker.jdbc.util.StringUtils; import org.springframework.jdbc.core.RowMapper; import java.sql.ResultSet; import java.sql.SQLException; import java.util.Map; /** * 表名:S_PAY_ORDER * * @author genrator */ public class S_pay_order_mapper extends S_pay_order implements BaseMapper { // 序列化版本号 private static final long serialVersionUID = 1L; public static final RowMapper ROW_MAPPER = new S_pay_orderRowMapper(); // 主键 public static final String ID = "id"; // 普通属性 public static final String CREATE_TIME = "create_time"; public static final String ORG_ID = "org_id"; public static final String PAY_DEFINITION_ID = "pay_definition_id"; public static final String SERVICE_PROVIDER = "service_provider"; public static final String VERSION = "version"; public static final String PAY_TYPE = "pay_type"; public static final String PAY_STATUS = "pay_status"; public static final String PAY_STATUS_MSG = "pay_status_msg"; public static final String PAY_SUCCESS_TIME = "pay_success_time"; public static final String TRADE_NO = "trade_no"; public static final String PAY_CHANNEL = "pay_channel"; public static final String TITLE = "title"; public static final String ATTACH = "attach"; public static final String TOTAL_MONEY = "total_money"; public static final String FEE = "fee"; public static final String NONCE = "nonce"; public static final String IP = "ip"; public static final String DEVICE_INFO = "device_info"; public static final String BUYER_ID = "buyer_id"; public static final String RECEIVER_ID = "receiver_id"; public static final String THIRD_PAY_ACCT = "third_pay_acct"; public static final String THIRD_PAY_INFO = "third_pay_info"; public static final String THIRD_PAY_TIME = "third_pay_time"; public static final String THIRD_TRADE_NO = "third_trade_no"; public static final String THIRD_NOTIFY_ID = "third_notify_id"; /** * 默认构造函数 */ public S_pay_order_mapper(S_pay_order s_pay_order) { if (s_pay_order == null) { throw new IllegalArgumentException("po参数不允许为空!"); } //主键 if (s_pay_order.isset_id) { this.setId(s_pay_order.getId()); } //普通属性 if (s_pay_order.isset_create_time) { this.setCreate_time(s_pay_order.getCreate_time()); } if (s_pay_order.isset_org_id) { this.setOrg_id(s_pay_order.getOrg_id()); } if (s_pay_order.isset_pay_definition_id) { this.setPay_definition_id(s_pay_order.getPay_definition_id()); } if (s_pay_order.isset_service_provider) { this.setService_provider(s_pay_order.getService_provider()); } if (s_pay_order.isset_version) { this.setVersion(s_pay_order.getVersion()); } if (s_pay_order.isset_pay_type) { this.setPay_type(s_pay_order.getPay_type()); } if (s_pay_order.isset_pay_status) { this.setPay_status(s_pay_order.getPay_status()); } if (s_pay_order.isset_pay_status_msg) { this.setPay_status_msg(s_pay_order.getPay_status_msg()); } if (s_pay_order.isset_pay_success_time) { this.setPay_success_time(s_pay_order.getPay_success_time()); } if (s_pay_order.isset_trade_no) { this.setTrade_no(s_pay_order.getTrade_no()); } if (s_pay_order.isset_pay_channel) { this.setPay_channel(s_pay_order.getPay_channel()); } if (s_pay_order.isset_title) { this.setTitle(s_pay_order.getTitle()); } if (s_pay_order.isset_attach) { this.setAttach(s_pay_order.getAttach()); } if (s_pay_order.isset_total_money) { this.setTotal_money(s_pay_order.getTotal_money()); } if (s_pay_order.isset_fee) { this.setFee(s_pay_order.getFee()); } if (s_pay_order.isset_nonce) { this.setNonce(s_pay_order.getNonce()); } if (s_pay_order.isset_ip) { this.setIp(s_pay_order.getIp()); } if (s_pay_order.isset_device_info) { this.setDevice_info(s_pay_order.getDevice_info()); } if (s_pay_order.isset_buyer_id) { this.setBuyer_id(s_pay_order.getBuyer_id()); } if (s_pay_order.isset_receiver_id) { this.setReceiver_id(s_pay_order.getReceiver_id()); } if (s_pay_order.isset_third_pay_acct) { this.setThird_pay_acct(s_pay_order.getThird_pay_acct()); } if (s_pay_order.isset_third_pay_info) { this.setThird_pay_info(s_pay_order.getThird_pay_info()); } if (s_pay_order.isset_third_pay_time) { this.setThird_pay_time(s_pay_order.getThird_pay_time()); } if (s_pay_order.isset_third_trade_no) { this.setThird_trade_no(s_pay_order.getThird_trade_no()); } if (s_pay_order.isset_third_notify_id) { this.setThird_notify_id(s_pay_order.getThird_notify_id()); } // 去掉,2022-09-07 // this.setDatabaseName_(s_pay_order.getDatabaseName_()); } /** * 获取表名 */ @Override public String getTableName_() { String tableName = "s_pay_order"; /** 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(CREATE_TIME, this.getCreate_time(), this.isset_create_time); ib.set(ORG_ID, this.getOrg_id(), this.isset_org_id); ib.set(PAY_DEFINITION_ID, this.getPay_definition_id(), this.isset_pay_definition_id); ib.set(SERVICE_PROVIDER, this.getService_provider(), this.isset_service_provider); ib.set(VERSION, this.getVersion(), this.isset_version); ib.set(PAY_TYPE, this.getPay_type(), this.isset_pay_type); ib.set(PAY_STATUS, this.getPay_status(), this.isset_pay_status); ib.set(PAY_STATUS_MSG, this.getPay_status_msg(), this.isset_pay_status_msg); ib.set(PAY_SUCCESS_TIME, this.getPay_success_time(), this.isset_pay_success_time); ib.set(TRADE_NO, this.getTrade_no(), this.isset_trade_no); ib.set(PAY_CHANNEL, this.getPay_channel(), this.isset_pay_channel); ib.set(TITLE, this.getTitle(), this.isset_title); ib.set(ATTACH, this.getAttach(), this.isset_attach); ib.set(TOTAL_MONEY, this.getTotal_money(), this.isset_total_money); ib.set(FEE, this.getFee(), this.isset_fee); ib.set(NONCE, this.getNonce(), this.isset_nonce); ib.set(IP, this.getIp(), this.isset_ip); ib.set(DEVICE_INFO, this.getDevice_info(), this.isset_device_info); ib.set(BUYER_ID, this.getBuyer_id(), this.isset_buyer_id); ib.set(RECEIVER_ID, this.getReceiver_id(), this.isset_receiver_id); ib.set(THIRD_PAY_ACCT, this.getThird_pay_acct(), this.isset_third_pay_acct); ib.set(THIRD_PAY_INFO, this.getThird_pay_info(), this.isset_third_pay_info); ib.set(THIRD_PAY_TIME, this.getThird_pay_time(), this.isset_third_pay_time); ib.set(THIRD_TRADE_NO, this.getThird_trade_no(), this.isset_third_trade_no); ib.set(THIRD_NOTIFY_ID, this.getThird_notify_id(), this.isset_third_notify_id); return ib.genMapSql(); } /** * 获取更新语句和参数 */ @Override public SqlAndParameters> getUpdateSql_() { UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); ub.set(CREATE_TIME, this.getCreate_time(), this.isset_create_time); ub.set(ORG_ID, this.getOrg_id(), this.isset_org_id); ub.set(PAY_DEFINITION_ID, this.getPay_definition_id(), this.isset_pay_definition_id); ub.set(SERVICE_PROVIDER, this.getService_provider(), this.isset_service_provider); ub.set(VERSION, this.getVersion(), this.isset_version); ub.set(PAY_TYPE, this.getPay_type(), this.isset_pay_type); ub.set(PAY_STATUS, this.getPay_status(), this.isset_pay_status); ub.set(PAY_STATUS_MSG, this.getPay_status_msg(), this.isset_pay_status_msg); ub.set(PAY_SUCCESS_TIME, this.getPay_success_time(), this.isset_pay_success_time); ub.set(TRADE_NO, this.getTrade_no(), this.isset_trade_no); ub.set(PAY_CHANNEL, this.getPay_channel(), this.isset_pay_channel); ub.set(TITLE, this.getTitle(), this.isset_title); ub.set(ATTACH, this.getAttach(), this.isset_attach); ub.set(TOTAL_MONEY, this.getTotal_money(), this.isset_total_money); ub.set(FEE, this.getFee(), this.isset_fee); ub.set(NONCE, this.getNonce(), this.isset_nonce); ub.set(IP, this.getIp(), this.isset_ip); ub.set(DEVICE_INFO, this.getDevice_info(), this.isset_device_info); ub.set(BUYER_ID, this.getBuyer_id(), this.isset_buyer_id); ub.set(RECEIVER_ID, this.getReceiver_id(), this.isset_receiver_id); ub.set(THIRD_PAY_ACCT, this.getThird_pay_acct(), this.isset_third_pay_acct); ub.set(THIRD_PAY_INFO, this.getThird_pay_info(), this.isset_third_pay_info); ub.set(THIRD_PAY_TIME, this.getThird_pay_time(), this.isset_third_pay_time); ub.set(THIRD_TRADE_NO, this.getThird_trade_no(), this.isset_third_trade_no); ub.set(THIRD_NOTIFY_ID, this.getThird_notify_id(), this.isset_third_notify_id); 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(CREATE_TIME, this.getCreate_time(), this.isset_create_time); ub.set(ORG_ID, this.getOrg_id(), this.isset_org_id); ub.set(PAY_DEFINITION_ID, this.getPay_definition_id(), this.isset_pay_definition_id); ub.set(SERVICE_PROVIDER, this.getService_provider(), this.isset_service_provider); ub.set(VERSION, this.getVersion(), this.isset_version); ub.set(PAY_TYPE, this.getPay_type(), this.isset_pay_type); ub.set(PAY_STATUS, this.getPay_status(), this.isset_pay_status); ub.set(PAY_STATUS_MSG, this.getPay_status_msg(), this.isset_pay_status_msg); ub.set(PAY_SUCCESS_TIME, this.getPay_success_time(), this.isset_pay_success_time); ub.set(TRADE_NO, this.getTrade_no(), this.isset_trade_no); ub.set(PAY_CHANNEL, this.getPay_channel(), this.isset_pay_channel); ub.set(TITLE, this.getTitle(), this.isset_title); ub.set(ATTACH, this.getAttach(), this.isset_attach); ub.set(TOTAL_MONEY, this.getTotal_money(), this.isset_total_money); ub.set(FEE, this.getFee(), this.isset_fee); ub.set(NONCE, this.getNonce(), this.isset_nonce); ub.set(IP, this.getIp(), this.isset_ip); ub.set(DEVICE_INFO, this.getDevice_info(), this.isset_device_info); ub.set(BUYER_ID, this.getBuyer_id(), this.isset_buyer_id); ub.set(RECEIVER_ID, this.getReceiver_id(), this.isset_receiver_id); ub.set(THIRD_PAY_ACCT, this.getThird_pay_acct(), this.isset_third_pay_acct); ub.set(THIRD_PAY_INFO, this.getThird_pay_info(), this.isset_third_pay_info); ub.set(THIRD_PAY_TIME, this.getThird_pay_time(), this.isset_third_pay_time); ub.set(THIRD_TRADE_NO, this.getThird_trade_no(), this.isset_third_trade_no); ub.set(THIRD_NOTIFY_ID, this.getThird_notify_id(), this.isset_third_notify_id); return ub.genMapSql(where, parameters); } /** * 获取更新语句和参数 */ @Override public SqlAndParameters getUpdateSql_(String where, Object[] parameters) { UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); ub.set(CREATE_TIME, this.getCreate_time(), this.isset_create_time); ub.set(ORG_ID, this.getOrg_id(), this.isset_org_id); ub.set(PAY_DEFINITION_ID, this.getPay_definition_id(), this.isset_pay_definition_id); ub.set(SERVICE_PROVIDER, this.getService_provider(), this.isset_service_provider); ub.set(VERSION, this.getVersion(), this.isset_version); ub.set(PAY_TYPE, this.getPay_type(), this.isset_pay_type); ub.set(PAY_STATUS, this.getPay_status(), this.isset_pay_status); ub.set(PAY_STATUS_MSG, this.getPay_status_msg(), this.isset_pay_status_msg); ub.set(PAY_SUCCESS_TIME, this.getPay_success_time(), this.isset_pay_success_time); ub.set(TRADE_NO, this.getTrade_no(), this.isset_trade_no); ub.set(PAY_CHANNEL, this.getPay_channel(), this.isset_pay_channel); ub.set(TITLE, this.getTitle(), this.isset_title); ub.set(ATTACH, this.getAttach(), this.isset_attach); ub.set(TOTAL_MONEY, this.getTotal_money(), this.isset_total_money); ub.set(FEE, this.getFee(), this.isset_fee); ub.set(NONCE, this.getNonce(), this.isset_nonce); ub.set(IP, this.getIp(), this.isset_ip); ub.set(DEVICE_INFO, this.getDevice_info(), this.isset_device_info); ub.set(BUYER_ID, this.getBuyer_id(), this.isset_buyer_id); ub.set(RECEIVER_ID, this.getReceiver_id(), this.isset_receiver_id); ub.set(THIRD_PAY_ACCT, this.getThird_pay_acct(), this.isset_third_pay_acct); ub.set(THIRD_PAY_INFO, this.getThird_pay_info(), this.isset_third_pay_info); ub.set(THIRD_PAY_TIME, this.getThird_pay_time(), this.isset_third_pay_time); ub.set(THIRD_TRADE_NO, this.getThird_trade_no(), this.isset_third_trade_no); ub.set(THIRD_NOTIFY_ID, this.getThird_notify_id(), this.isset_third_notify_id); 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, create_time, org_id, pay_definition_id, service_provider, version, pay_type, pay_status, pay_status_msg, pay_success_time, trade_no, pay_channel, title, attach, total_money, fee, nonce, ip, device_info, buyer_id, receiver_id, third_pay_acct, third_pay_info, third_pay_time, third_trade_no, third_notify_id from " + this.getTableName_() + " " + where, parameters); } /** * 获取查询语句和参数 */ @Override public SqlAndParameters getSelectSql_(String where, Object[] parameters) { return new SqlAndParameters<>("select id, create_time, org_id, pay_definition_id, service_provider, version, pay_type, pay_status, pay_status_msg, pay_success_time, trade_no, pay_channel, title, attach, total_money, fee, nonce, ip, device_info, buyer_id, receiver_id, third_pay_acct, third_pay_info, third_pay_time, third_trade_no, third_notify_id from " + this.getTableName_() + " " + where, parameters); } /** * 将resultset的一行转化为po */ @Override public S_pay_order mapRow(ResultSet rs, int i) throws SQLException { return ROW_MAPPER.mapRow(rs, i); } /** * 克隆 */ public S_pay_order toS_pay_order() { return super.$clone(); } } /** * s_pay_order RowMapper * * @author genrator */ class S_pay_orderRowMapper implements RowMapper { @Override public S_pay_order mapRow(ResultSet rs, int i) throws SQLException { ResultSetUtils resultSetUtils = new ResultSetUtils(); S_pay_order s_pay_order = new S_pay_order(); Integer columnIndex; //主键 columnIndex = resultSetUtils.findColumn(rs, S_pay_order_mapper.ID); if (columnIndex > 0) { s_pay_order.setId(rs.getLong(columnIndex)); } //普通属性 columnIndex = resultSetUtils.findColumn(rs, S_pay_order_mapper.CREATE_TIME); if (columnIndex > 0) { if (rs.getBigDecimal(columnIndex) == null) { s_pay_order.setCreate_time(null); } else { s_pay_order.setCreate_time(rs.getLong(columnIndex)); } } columnIndex = resultSetUtils.findColumn(rs, S_pay_order_mapper.ORG_ID); if (columnIndex > 0) { if (rs.getBigDecimal(columnIndex) == null) { s_pay_order.setOrg_id(null); } else { s_pay_order.setOrg_id(rs.getLong(columnIndex)); } } columnIndex = resultSetUtils.findColumn(rs, S_pay_order_mapper.PAY_DEFINITION_ID); if (columnIndex > 0) { s_pay_order.setPay_definition_id(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, S_pay_order_mapper.SERVICE_PROVIDER); if (columnIndex > 0) { s_pay_order.setService_provider(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, S_pay_order_mapper.VERSION); if (columnIndex > 0) { s_pay_order.setVersion(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, S_pay_order_mapper.PAY_TYPE); if (columnIndex > 0) { if (rs.getBigDecimal(columnIndex) == null) { s_pay_order.setPay_type(null); } else { s_pay_order.setPay_type(rs.getInt(columnIndex)); } } columnIndex = resultSetUtils.findColumn(rs, S_pay_order_mapper.PAY_STATUS); if (columnIndex > 0) { s_pay_order.setPay_status(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, S_pay_order_mapper.PAY_STATUS_MSG); if (columnIndex > 0) { s_pay_order.setPay_status_msg(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, S_pay_order_mapper.PAY_SUCCESS_TIME); if (columnIndex > 0) { if (rs.getBigDecimal(columnIndex) == null) { s_pay_order.setPay_success_time(null); } else { s_pay_order.setPay_success_time(rs.getLong(columnIndex)); } } columnIndex = resultSetUtils.findColumn(rs, S_pay_order_mapper.TRADE_NO); if (columnIndex > 0) { s_pay_order.setTrade_no(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, S_pay_order_mapper.PAY_CHANNEL); if (columnIndex > 0) { if (rs.getBigDecimal(columnIndex) == null) { s_pay_order.setPay_channel(null); } else { s_pay_order.setPay_channel(rs.getInt(columnIndex)); } } columnIndex = resultSetUtils.findColumn(rs, S_pay_order_mapper.TITLE); if (columnIndex > 0) { s_pay_order.setTitle(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, S_pay_order_mapper.ATTACH); if (columnIndex > 0) { s_pay_order.setAttach(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, S_pay_order_mapper.TOTAL_MONEY); if (columnIndex > 0) { if (rs.getBigDecimal(columnIndex) == null) { s_pay_order.setTotal_money(null); } else { s_pay_order.setTotal_money(rs.getLong(columnIndex)); } } columnIndex = resultSetUtils.findColumn(rs, S_pay_order_mapper.FEE); if (columnIndex > 0) { if (rs.getBigDecimal(columnIndex) == null) { s_pay_order.setFee(null); } else { s_pay_order.setFee(rs.getLong(columnIndex)); } } columnIndex = resultSetUtils.findColumn(rs, S_pay_order_mapper.NONCE); if (columnIndex > 0) { s_pay_order.setNonce(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, S_pay_order_mapper.IP); if (columnIndex > 0) { s_pay_order.setIp(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, S_pay_order_mapper.DEVICE_INFO); if (columnIndex > 0) { s_pay_order.setDevice_info(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, S_pay_order_mapper.BUYER_ID); if (columnIndex > 0) { s_pay_order.setBuyer_id(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, S_pay_order_mapper.RECEIVER_ID); if (columnIndex > 0) { s_pay_order.setReceiver_id(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, S_pay_order_mapper.THIRD_PAY_ACCT); if (columnIndex > 0) { s_pay_order.setThird_pay_acct(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, S_pay_order_mapper.THIRD_PAY_INFO); if (columnIndex > 0) { s_pay_order.setThird_pay_info(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, S_pay_order_mapper.THIRD_PAY_TIME); if (columnIndex > 0) { s_pay_order.setThird_pay_time(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, S_pay_order_mapper.THIRD_TRADE_NO); if (columnIndex > 0) { s_pay_order.setThird_trade_no(rs.getString(columnIndex)); } columnIndex = resultSetUtils.findColumn(rs, S_pay_order_mapper.THIRD_NOTIFY_ID); if (columnIndex > 0) { s_pay_order.setThird_notify_id(rs.getString(columnIndex)); } return s_pay_order; } }