/** 插入父单信息 */ private void insertParentSo(Connection con, JumpMQOrderVo jumpMQOrderVo) { PreparedStatement st = null; String sql = "insert into edw1_dev.REALTIME_METADATA_SO (ID, ENDUSERID, ORDERCODE, ORDERCREATETIME, ORDERTYPE, ORDERSTATUS, BIZTYPE, ORDERSOURCE, PARENTSOID, SITETYPE, ORDERAMOUNT, PRODUCTAMOUNT, ISLEAF, PAYSERVICETYPE, MSGSENDTIME, UPDT_TIME) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"; try { st = con.prepareStatement(sql); st.setLong(1, jumpMQOrderVo.getId()); st.setLong(2, jumpMQOrderVo.getEndUserId()); st.setString(3, jumpMQOrderVo.getOrderCode()); // st.setDate(4, new java.sql.Date(jumpMQOrderVo.getOrderCreateTime().getTime())); if (jumpMQOrderVo.getOrderCreateTime() != null) { st.setTimestamp(4, new Timestamp(jumpMQOrderVo.getOrderCreateTime().getTime())); } else { st.setTimestamp(4, new Timestamp(new Date().getTime())); } st.setInt(5, jumpMQOrderVo.getOrderType()); st.setInt(6, jumpMQOrderVo.getOrderStatus()); st.setInt(7, jumpMQOrderVo.getBizType()); st.setInt(8, jumpMQOrderVo.getOrderSource()); st.setLong(9, jumpMQOrderVo.getParentSoId()); st.setInt(10, jumpMQOrderVo.getSiteType()); if (jumpMQOrderVo.getOrderAmount() != null) { st.setDouble(11, jumpMQOrderVo.getOrderAmount().doubleValue()); } else { st.setDouble(11, 0.0); } if (jumpMQOrderVo.getProductAmount() != null) { st.setDouble(12, jumpMQOrderVo.getProductAmount().doubleValue()); } else { st.setDouble(12, 0.0); } st.setInt(13, jumpMQOrderVo.getIsLeaf()); st.setInt(14, jumpMQOrderVo.getPayServiceType()); // st.setDate(15, new java.sql.Date(jumpMQOrderVo.getMsgSendTime().getTime())); if (jumpMQOrderVo.getMsgSendTime() != null) { st.setTimestamp(15, new Timestamp(jumpMQOrderVo.getMsgSendTime().getTime())); } else { st.setTimestamp(15, new Timestamp(new Date().getTime())); } st.setTimestamp(16, new Timestamp(new Date().getTime())); st.executeQuery(); } catch (Exception e) { logger.info("error: Metadata insert error ! "); } finally { try { st.close(); } catch (SQLException e) { e.printStackTrace(); } } }