Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Class.forName("org.postgresql.Driver");
- String conString = "jdbc:postgresql://" + host + ":" + port + "/" + DBName +
- "?user=" + user + "&pass=" + pass;
- String conString1 = "jdbc:postgresql://" + host + ":" + port2 + "/" + DBName2 +
- "?user=" + user + "&pass=" + pass;
- c = DriverManager.getConnection(conString);
- c2 = DriverManager.getConnection(conString1);
- st = c.createStatement();
- st2 = c2.createStatement();
- List<ResultSet> resultSets = new ArrayList<>();
- resultSets.add(st.executeQuery(query));
- resultSets.add(st2.executeQuery(query2));
- ResultSets rs = new ResultSets(resultSets);
- while (rs.next()){
- for(int i = 1 ; i <= 40 ; i++){
- TotalHarmVaArrL.add(rs.getDouble("h",i));
- TotalHarmVbArrL.add(rs.getDouble("h",i));
- TotalHarmVcArrL.add(rs.getDouble("h",i));
- }
- }
- class ResultSets {
- private java.util.List<java.sql.ResultSet> resultSets;
- private java.sql.ResultSet current;
- public ResultSets(java.util.List<java.sql.ResultSet> resultSets) {
- this.resultSets = new java.util.ArrayList<>(resultSets);
- current = resultSets.remove(0);
- }
- public boolean next() throws SQLException {
- if (current.next()) {
- return true;
- }else if (!resultSets.isEmpty()) {
- current = resultSets.remove(0);
- return next();
- }
- return false;
- }
- public Double getDouble(String h, int number) throws SQLException{
- return current.getDouble("h" + number);
- }
- void close() throws SQLException {
- current.close();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement