public int receiptsettle(String esb2ensemble) { this.conn = DbConnection.getConn(); CallableStatement cs = null; int n = -1; try { // ESB收到消息后解析报文 Document doc1 = DocumentHelper.parseText(esb2ensemble); // 获取叶子节点b Node node1 = doc1.selectSingleNode("ROOT/BODY/SVR_MESSAGE_IN/v1"); String v1 = node1.getText(); System.out.println(v1); Node node3 = doc1.selectSingleNode("ROOT/BODY/SVR_MESSAGE_IN/v2"); String v3 = node3.getText(); System.out.println(v3); Node node4 = doc1.selectSingleNode("ROOT/BODY/SVR_MESSAGE_IN/v3"); String v4 = node4.getText(); System.out.println(v4); Node node5 = doc1.selectSingleNode("ROOT/BODY/SVR_MESSAGE_IN/v4"); String v5 = node5.getText(); System.out.println(v5); int vv5 = Integer.parseInt(v5); try { cs = conn.prepareCall("{call sp_receiptsettle(?,?,?,?)}"); cs.setString(1, v1); cs.setString(2, v3); cs.setString(3, v4); cs.setInt(4, vv5); cs.execute(); n = 0; } catch (SQLException e) { e.printStackTrace(); return n; } finally { try { cs.close(); this.conn.close(); } catch (SQLException e) { e.printStackTrace(); } } } catch (DocumentException e) { e.printStackTrace(); } return 0; }
public int settlepay(String esb2ensemble) { this.conn = DbConnection.getConn(); CallableStatement cs = null; int n = -1; try { // ESB收到消息后解析报文 Document doc1 = DocumentHelper.parseText(esb2ensemble); // 获取叶子节点b Node node3 = doc1.selectSingleNode("ROOT/BODY/SVR_MESSAGE_IN/client"); String v3 = node3.getText(); Node node4 = doc1.selectSingleNode("ROOT/BODY/SVR_MESSAGE_IN/acct"); String v4 = node4.getText(); Node node5 = doc1.selectSingleNode("ROOT/BODY/SVR_MESSAGE_IN/payamt"); String v5 = node5.getText(); int vv5 = Integer.parseInt(v5); Node node6 = doc1.selectSingleNode("ROOT/BODY/SVR_MESSAGE_IN/baseacctno"); String v6 = node6.getText(); try { cs = conn.prepareCall("{call sp_settlepay(?,?,?,?)}"); cs.setString(1, v3); cs.setString(2, v4); cs.setInt(3, vv5); cs.setString(4, v6); cs.execute(); n = 0; } catch (SQLException e) { e.printStackTrace(); return n; } finally { try { cs.close(); this.conn.close(); } catch (SQLException e) { e.printStackTrace(); } } } catch (DocumentException e) { e.printStackTrace(); } return 0; }