// пока касается только навигаций... public void getElementFromDB2(String query, String conn, String login, String pass) { if (OnConnection(conn, login, pass)) { el01 = new Element(); Statement stmt = null; try { stmt = connection.createStatement(); ResultSet rs = stmt.executeQuery(query); while (rs.next()) { // el.setArrBody(rs.getString("NAVCODE")); NavStroke stroke = new NavStroke(); stroke.setFLD(rs.getString("PUREFLD")); stroke.setEVENT(rs.getString("PUREEVENT")); stroke.setCOND(rs.getString("PURECOND")); stroke.setACTION(rs.getString("PUREACTION")); stroke.setOP(rs.getString("PURECODE")); stroke.setCOMM(rs.getString("COMM")); stroke.setNAVN(rs.getString("NAVN")); stroke.setFrom(rs.getString("OWNER")); stroke.setCuser(rs.getString("MODNAME")); stroke.setCdate(rs.getString("MODDATE")); stroke.prepareData(); el01.setData(stroke); } } catch (SQLException e) { System.out.println("Ошибка соединения\n" + e.getSQLState() + "\n" + e.toString()); System.out.println(e.toString()); } finally { if (stmt != null) { try { stmt.close(); } catch (SQLException ex) { System.out.println( "Ошибка соединения Statement.close\n" + ex.getSQLState() + "\n" + ex.toString()); System.out.println(ex.toString()); } } } } }