// пока касается только навигаций...
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());
}
}
}
}
}
