Guest User

Untitled

a guest
May 21st, 2018
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.98 KB | None | 0 0
  1. try {
  2. Connection connection = DataAccess.getConnection();
  3. CallableStatement stmt = connection.prepareCall("{call test(?,?,?)}");
  4. stmt.setInt(1, 10158);
  5. stmt.setInt(2, 10159);
  6. stmt.setInt(3, 10156);
  7.  
  8. boolean isResult = stmt.execute();
  9.  
  10. if(isResult){
  11. ResultSet rs1 = stmt.getResultSet();
  12. while(rs1.next()){
  13. System.out.println("UserId=>"+rs1.getString("userId"));
  14. System.out.println("Company Id=>"+rs1.getString("companyId"));
  15. }
  16. stmt.getMoreResults(Statement.CLOSE_CURRENT_RESULT);
  17. ResultSet rs2 = stmt.getResultSet();
  18. while(rs2.next()){
  19. System.out.println("ContactId=>"+rs2.getString("contactId"));
  20. System.out.println("Email Address=>"+rs2.getString("emailAddress"));
  21. }
  22.  
  23. stmt.getMoreResults(Statement.CLOSE_CURRENT_RESULT);
  24. ResultSet rs3 = stmt.getResultSet();
  25. while(rs3.next()){
  26. System.out.println("Name =>"+rs3.getString("name"));
  27. System.out.println("Legal Name =>"+rs3.getString("legalName"));
  28. }
  29.  
  30. }
  31. } catch (SQLException e) {
  32. e.printStackTrace();
  33. }
Add Comment
Please, Sign In to add comment