public static List<GlobalParameter> select(DbConn cnx, String query_key, Object... args) { List<GlobalParameter> res = new ArrayList<GlobalParameter>(); try { ResultSet rs = cnx.runSelect(query_key, args); while (rs.next()) { GlobalParameter tmp = new GlobalParameter(); tmp.id = rs.getInt(1); tmp.key = rs.getString(2); tmp.value = rs.getString(3); Calendar c = Calendar.getInstance(); c.setTimeInMillis(rs.getTimestamp(4).getTime()); tmp.lastModified = c; res.add(tmp); } } catch (SQLException e) { throw new DatabaseException(e); } return res; }
public static List<GlobalParameter> select(DbConn cnx, String query_key, Object... args) { List<GlobalParameter> res = new ArrayList<>(); try { ResultSet rs = cnx.runSelect(query_key, args); while (rs.next()) { GlobalParameter tmp = new GlobalParameter(); tmp.id = rs.getInt(1); tmp.key = rs.getString(2); tmp.value = rs.getString(3); Calendar c = Calendar.getInstance(); c.setTimeInMillis(rs.getTimestamp(4).getTime()); tmp.lastModified = c; res.add(tmp); } } catch (SQLException e) { throw new DatabaseException(e); } return res; }
/** * Create a new GP entry in the database. No commit performed. */ public static GlobalParameter create(DbConn cnx, String key, String value) { QueryResult r = cnx.runUpdate("globalprm_insert", key, value); GlobalParameter res = new GlobalParameter(); res.id = r.getGeneratedId(); res.key = key; res.value = value; return res; }
/** * Create a new GP entry in the database. No commit performed. */ public static GlobalParameter create(DbConn cnx, String key, String value) { QueryResult r = cnx.runUpdate("globalprm_insert", key, value); GlobalParameter res = new GlobalParameter(); res.id = r.getGeneratedId(); res.key = key; res.value = value; return res; }