Advertisement
Guest User

Untitled

a guest
Feb 22nd, 2018
264
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.60 KB | None | 0 0
  1. public static boolean porovnaj(String dopyt1, String dopyt2) throws SQLException {
  2. try(Connection c = DriverManager.getConnection("jdbc:postgresql://db.dai.fmph.uniba.sk/playground", "gajdosech2@uniba.sk", "datakyseliny")) {
  3. try(Statement s1 = c.createStatement()) {
  4. try(Statement s2 = c.createStatement()) {
  5. ResultSet r1 = s1.executeQuery(dopyt1);
  6. ResultSet r2 = s2.executeQuery(dopyt2);
  7. if (r1.next() != r2.next()) return false;
  8. ResultSetMetaData metaData1 = r1.getMetaData();
  9. ResultSetMetaData metaData2 = r2.getMetaData();
  10. if (metaData1.getColumnCount() != metaData2.getColumnCount()) return false;
  11. for (int i = 1; i <= metaData1.getColumnCount(); ++i) {
  12. String nazovStlpca1 = metaData1.getColumnName(i);
  13. String nazovStlpca2 = metaData2.getColumnName(i);
  14. if (nazovStlpca1.equals(nazovStlpca2) == false) return false;
  15. }
  16. while (r1.next()) { //prechadzam riadky
  17. if (r2.next() == false) return false;
  18. /*
  19. for (int i = 1; i <= metaData1.getColumnCount(); ++i) {
  20. if (r1.getObject(i) != r2.getObject(i)) return false;
  21. }
  22. */
  23. }
  24. if (r2.next() == true) return false;
  25. }
  26. }
  27. }
  28. return true;
  29. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement