Advertisement
Guest User

Untitled

a guest
Jul 17th, 2016
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.62 KB | None | 0 0
  1. Class.forName("org.postgresql.Driver");
  2. String conString = "jdbc:postgresql://" + host + ":" + port + "/" + DBName +
  3. "?user=" + user + "&pass=" + pass;
  4. String conString1 = "jdbc:postgresql://" + host + ":" + port2 + "/" + DBName2 +
  5. "?user=" + user + "&pass=" + pass;
  6.  
  7. c = DriverManager.getConnection(conString);
  8. c2 = DriverManager.getConnection(conString1);
  9.  
  10. st = c.createStatement();
  11. st2 = c2.createStatement();
  12.  
  13. List<ResultSet> resultSets = new ArrayList<>();
  14. resultSets.add(st.executeQuery(query));
  15. resultSets.add(st2.executeQuery(query2));
  16. ResultSets rs = new ResultSets(resultSets);
  17. while (rs.next()){
  18. for(int i = 1 ; i <= 40 ; i++){
  19. TotalHarmVaArrL.add(rs.getDouble("h",i));
  20. TotalHarmVbArrL.add(rs.getDouble("h",i));
  21. TotalHarmVcArrL.add(rs.getDouble("h",i));
  22. }
  23. }
  24.  
  25. class ResultSets {
  26.  
  27. private java.util.List<java.sql.ResultSet> resultSets;
  28.  
  29. private java.sql.ResultSet current;
  30.  
  31.  
  32. public ResultSets(java.util.List<java.sql.ResultSet> resultSets) {
  33. this.resultSets = new java.util.ArrayList<>(resultSets);
  34. current = resultSets.remove(0);
  35. }
  36.  
  37. public boolean next() throws SQLException {
  38. if (current.next()) {
  39. return true;
  40. }else if (!resultSets.isEmpty()) {
  41. current = resultSets.remove(0);
  42. return next();
  43. }
  44. return false;
  45. }
  46. public Double getDouble(String h, int number) throws SQLException{
  47. return current.getDouble("h" + number);
  48. }
  49.  
  50. void close() throws SQLException {
  51. current.close();
  52. }
  53. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement