| | |
| | | * 根据区块地址获取充值订单 |
| | | */ |
| | | public RechargeBlockchain getAddress(String address) { |
| | | List<RechargeBlockchain> list = jdbcTemplate.query("SELECT * FROM T_RECHARGE_BLOCKCHAIN_ORDER WHERE CHANNEL_ADDRESS=?", RecordObjectMapper.newInstance(RechargeBlockchain.class), address); |
| | | List<RechargeBlockchain> list = jdbcTemplate.query("SELECT * FROM T_RECHARGE_BLOCKCHAIN_ORDER WHERE succeeded = 0 and CHANNEL_ADDRESS=?", RecordObjectMapper.newInstance(RechargeBlockchain.class), address); |
| | | if (null != list && list.size() > 0) { |
| | | return list.get(0); |
| | | } |
| | |
| | | } |
| | | } |
| | | |
| | | @Override |
| | | public List<RechargeBlockchain> getByAddressUndone(String channelAddress) { |
| | | return getUndone(channelAddress); |
| | | } |
| | | public List<RechargeBlockchain> getUndone(String channelAddress){ |
| | | List<RechargeBlockchain> list = jdbcTemplate.query("SELECT * FROM T_RECHARGE_BLOCKCHAIN_ORDER WHERE succeeded = 0 and CHANNEL_ADDRESS=?", RecordObjectMapper.newInstance(RechargeBlockchain.class), channelAddress); |
| | | return list; |
| | | } |
| | | |
| | | |
| | | |
| | | public void insertRechargeBlockchain(RechargeBlockchain rechargeBlockchain) { |
| | | Object[] jdbcParams = ApplicationUtil.getInsertStatement(rechargeBlockchain); |
| | | String insertUserSql = (String)jdbcParams[0]; |