Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public static boolean porovnaj(String dopyt1, String dopyt2) throws SQLException {
- try(Connection c = DriverManager.getConnection("jdbc:postgresql://db.dai.fmph.uniba.sk/playground", "gajdosech2@uniba.sk", "datakyseliny")) {
- try(Statement s1 = c.createStatement()) {
- try(Statement s2 = c.createStatement()) {
- ResultSet r1 = s1.executeQuery(dopyt1);
- ResultSet r2 = s2.executeQuery(dopyt2);
- if (r1.next() != r2.next()) return false;
- ResultSetMetaData metaData1 = r1.getMetaData();
- ResultSetMetaData metaData2 = r2.getMetaData();
- if (metaData1.getColumnCount() != metaData2.getColumnCount()) return false;
- for (int i = 1; i <= metaData1.getColumnCount(); ++i) {
- String nazovStlpca1 = metaData1.getColumnName(i);
- String nazovStlpca2 = metaData2.getColumnName(i);
- if (nazovStlpca1.equals(nazovStlpca2) == false) return false;
- }
- while (r1.next()) { //prechadzam riadky
- if (r2.next() == false) return false;
- /*
- for (int i = 1; i <= metaData1.getColumnCount(); ++i) {
- if (r1.getObject(i) != r2.getObject(i)) return false;
- }
- */
- }
- if (r2.next() == true) return false;
- }
- }
- }
- return true;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement