| | |
| | | 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; |
| | |
| | | // 主键 |
| | | public static final String Id = "id"; |
| | | // 普通属性 |
| | | public static final String GoodsUserPhone = "goods_user_phone"; |
| | | public static final String WhGoodsId = "wh_goods_id"; |
| | | public static final String RecordType = "record_type"; |
| | | public static final String LastRecordId = "last_record_id"; |
| | | public static final String TransBusinessId = "trans_business_id"; |
| | | public static final String NowUserPhone = "now_user_phone"; |
| | | public static final String NowUserName = "now_user_name"; |
| | | public static final String OperatorId = "operator_id"; |
| | |
| | | this.setId(lGoodsUserRecord.getId()); |
| | | } |
| | | //普通属性 |
| | | if (lGoodsUserRecord.isset_goodsUserPhone) { |
| | | this.setGoodsUserPhone(lGoodsUserRecord.getGoodsUserPhone()); |
| | | if (lGoodsUserRecord.isset_whGoodsId) { |
| | | this.setWhGoodsId(lGoodsUserRecord.getWhGoodsId()); |
| | | } |
| | | if (lGoodsUserRecord.isset_recordType) { |
| | | this.setRecordType(lGoodsUserRecord.getRecordType()); |
| | | } |
| | | if (lGoodsUserRecord.isset_lastRecordId) { |
| | | this.setLastRecordId(lGoodsUserRecord.getLastRecordId()); |
| | | if (lGoodsUserRecord.isset_transBusinessId) { |
| | | this.setTransBusinessId(lGoodsUserRecord.getTransBusinessId()); |
| | | } |
| | | if (lGoodsUserRecord.isset_nowUserPhone) { |
| | | this.setNowUserPhone(lGoodsUserRecord.getNowUserPhone()); |
| | |
| | | public SqlAndParameters<Map<String, Object>> getInsertSql_() { |
| | | InsertBuilder ib = new InsertBuilder(this.getTableName_()); |
| | | ib.set(Id, this.getId()); |
| | | ib.set(GoodsUserPhone, this.getGoodsUserPhone(), this.isset_goodsUserPhone); |
| | | ib.set(WhGoodsId, this.getWhGoodsId(), this.isset_whGoodsId); |
| | | ib.set(RecordType, this.getRecordType(), this.isset_recordType); |
| | | ib.set(LastRecordId, this.getLastRecordId(), this.isset_lastRecordId); |
| | | ib.set(TransBusinessId, this.getTransBusinessId(), this.isset_transBusinessId); |
| | | ib.set(NowUserPhone, this.getNowUserPhone(), this.isset_nowUserPhone); |
| | | ib.set(NowUserName, this.getNowUserName(), this.isset_nowUserName); |
| | | ib.set(OperatorId, this.getOperatorId(), this.isset_operatorId); |
| | |
| | | @Override |
| | | public SqlAndParameters<Map<String, Object>> getUpdateSql_() { |
| | | UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); |
| | | ub.set(GoodsUserPhone, this.getGoodsUserPhone(), this.isset_goodsUserPhone); |
| | | ub.set(WhGoodsId, this.getWhGoodsId(), this.isset_whGoodsId); |
| | | ub.set(RecordType, this.getRecordType(), this.isset_recordType); |
| | | ub.set(LastRecordId, this.getLastRecordId(), this.isset_lastRecordId); |
| | | ub.set(TransBusinessId, this.getTransBusinessId(), this.isset_transBusinessId); |
| | | ub.set(NowUserPhone, this.getNowUserPhone(), this.isset_nowUserPhone); |
| | | ub.set(NowUserName, this.getNowUserName(), this.isset_nowUserName); |
| | | ub.set(OperatorId, this.getOperatorId(), this.isset_operatorId); |
| | |
| | | @Override |
| | | public SqlAndParameters<Map<String, Object>> getUpdateSql_(String where, Map<String, Object> parameters) { |
| | | UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); |
| | | ub.set(GoodsUserPhone, this.getGoodsUserPhone(), this.isset_goodsUserPhone); |
| | | ub.set(WhGoodsId, this.getWhGoodsId(), this.isset_whGoodsId); |
| | | ub.set(RecordType, this.getRecordType(), this.isset_recordType); |
| | | ub.set(LastRecordId, this.getLastRecordId(), this.isset_lastRecordId); |
| | | ub.set(TransBusinessId, this.getTransBusinessId(), this.isset_transBusinessId); |
| | | ub.set(NowUserPhone, this.getNowUserPhone(), this.isset_nowUserPhone); |
| | | ub.set(NowUserName, this.getNowUserName(), this.isset_nowUserName); |
| | | ub.set(OperatorId, this.getOperatorId(), this.isset_operatorId); |
| | |
| | | @Override |
| | | public SqlAndParameters<Object[]> getUpdateSql_(String where, Object[] parameters) { |
| | | UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); |
| | | ub.set(GoodsUserPhone, this.getGoodsUserPhone(), this.isset_goodsUserPhone); |
| | | ub.set(WhGoodsId, this.getWhGoodsId(), this.isset_whGoodsId); |
| | | ub.set(RecordType, this.getRecordType(), this.isset_recordType); |
| | | ub.set(LastRecordId, this.getLastRecordId(), this.isset_lastRecordId); |
| | | ub.set(TransBusinessId, this.getTransBusinessId(), this.isset_transBusinessId); |
| | | ub.set(NowUserPhone, this.getNowUserPhone(), this.isset_nowUserPhone); |
| | | ub.set(NowUserName, this.getNowUserName(), this.isset_nowUserName); |
| | | ub.set(OperatorId, this.getOperatorId(), this.isset_operatorId); |
| | |
| | | */ |
| | | @Override |
| | | public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) { |
| | | return new SqlAndParameters<>("select id, goods_user_phone, record_type, last_record_id, now_user_phone, now_user_name, operator_id, operator_name, deal_time from " + this.getTableName_() + " " + where, parameters); |
| | | return new SqlAndParameters<>("select id, wh_goods_id, record_type, trans_business_id, now_user_phone, now_user_name, operator_id, operator_name, deal_time from " + this.getTableName_() + " " + where, parameters); |
| | | } |
| | | |
| | | /** |
| | |
| | | */ |
| | | @Override |
| | | public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) { |
| | | return new SqlAndParameters<>("select id, goods_user_phone, record_type, last_record_id, now_user_phone, now_user_name, operator_id, operator_name, deal_time from " + this.getTableName_() + " " + where, parameters); |
| | | return new SqlAndParameters<>("select id, wh_goods_id, record_type, trans_business_id, now_user_phone, now_user_name, operator_id, operator_name, deal_time from " + this.getTableName_() + " " + where, parameters); |
| | | } |
| | | |
| | | /** |
| | |
| | | l_goods_user_record.setId(rs.getLong(columnIndex)); |
| | | } |
| | | //普通属性 |
| | | columnIndex = resultSetUtils.findColumn(rs, LGoodsUserRecord_mapper.GoodsUserPhone); |
| | | columnIndex = resultSetUtils.findColumn(rs, LGoodsUserRecord_mapper.WhGoodsId); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | l_goods_user_record.setGoodsUserPhone(null); |
| | | l_goods_user_record.setWhGoodsId(null); |
| | | } else { |
| | | l_goods_user_record.setGoodsUserPhone(rs.getLong(columnIndex)); |
| | | l_goods_user_record.setWhGoodsId(rs.getLong(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LGoodsUserRecord_mapper.RecordType); |
| | |
| | | l_goods_user_record.setRecordType(rs.getInt(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LGoodsUserRecord_mapper.LastRecordId); |
| | | columnIndex = resultSetUtils.findColumn(rs, LGoodsUserRecord_mapper.TransBusinessId); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | l_goods_user_record.setLastRecordId(null); |
| | | l_goods_user_record.setTransBusinessId(null); |
| | | } else { |
| | | l_goods_user_record.setLastRecordId(rs.getLong(columnIndex)); |
| | | l_goods_user_record.setTransBusinessId(rs.getLong(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, LGoodsUserRecord_mapper.NowUserPhone); |