Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- try {
- Connection connection = DataAccess.getConnection();
- CallableStatement stmt = connection.prepareCall("{call test(?,?,?)}");
- stmt.setInt(1, 10158);
- stmt.setInt(2, 10159);
- stmt.setInt(3, 10156);
- boolean isResult = stmt.execute();
- if(isResult){
- ResultSet rs1 = stmt.getResultSet();
- while(rs1.next()){
- System.out.println("UserId=>"+rs1.getString("userId"));
- System.out.println("Company Id=>"+rs1.getString("companyId"));
- }
- stmt.getMoreResults(Statement.CLOSE_CURRENT_RESULT);
- ResultSet rs2 = stmt.getResultSet();
- while(rs2.next()){
- System.out.println("ContactId=>"+rs2.getString("contactId"));
- System.out.println("Email Address=>"+rs2.getString("emailAddress"));
- }
- stmt.getMoreResults(Statement.CLOSE_CURRENT_RESULT);
- ResultSet rs3 = stmt.getResultSet();
- while(rs3.next()){
- System.out.println("Name =>"+rs3.getString("name"));
- System.out.println("Legal Name =>"+rs3.getString("legalName"));
- }
- }
- } catch (SQLException e) {
- e.printStackTrace();
- }
Add Comment
Please, Sign In to add comment