Constant Field Values


Contents
dao.*

dao.DimensionenDaoMysql
public static final java.lang.String B "B"
public static final java.lang.String DELETE_BY_ID "DELETE FROM dimensionen WHERE dimensionen.ID = ?"
public static final java.lang.String H "H"
public static final java.lang.String ID "ID"
public static final java.lang.String INSERT "INSERT INTO dimensionen (L, B, H, Volumen) VALUES (?, ?, ?, ?)"
public static final java.lang.String L "L"
public static final java.lang.String SELECT_ALL "SELECT ID, L, B, H, Volumen FROM dimensionen ORDER BY 1 DESC"
public static final java.lang.String SELECT_BY_ID "SELECT ID, L, B, H, Volumen FROM dimensionen WHERE ID = ?"
public static final java.lang.String UPDATE "UPDATE dimensionen SET L = ?, B = ?, H = ?, Volumen = ? WHERE dimensionen.ID = ?"
public static final java.lang.String Volumen "Volumen"

dao.LebewesenDaoMysql
public static final java.lang.String DELETE "delete from szenarien_lebewesen where lebew_id = ? and szen_id = ?"
public static final java.lang.String EXISTS "select lebew_id from szenarien_lebewesen where lebew_id = ? and szen_id = ?"
public static final java.lang.String FILTER_NOTIN_SZENARIO " where not exists(select 1 from szenarien_lebewesen sl where sl.lebew_id = l.id and sl.szen_id = ?)"
public static final java.lang.String INSERT "insert into szenarien_lebewesen (lebew_id, szen_id,LebewMenge) values (?,?,?)"
public static final java.lang.String ORDERBY " order by t.id, l.name"
public static final java.lang.String SELECT_IN "select l.id, l.name, t.id, l.tempwerte_id, l.phwerte_id, l.info, l.photo, l.kantenab, t.bezeichnung, sl.LebewMenge from lebewesen l join typen t on l.typ_id = t.id join szenarien_lebewesen sl where sl.lebew_id = l.id and sl.szen_id = ?"
public static final java.lang.String SELECT_NOTIN "select l.id, l.name, t.id, l.tempwerte_id, l.phwerte_id, l.info, l.photo, l.kantenab, t.bezeichnung from lebewesen l join typen t on l.typ_id = t.id"
public static final java.lang.String UPDATE "update szenarien_lebewesen set LebewMenge = LebewMenge + ? where lebew_id = ? and szen_id = ?"

dao.PhwerteDaoMysql
public final java.lang.String SELECT "select Von, Bis from phwerte where id = ?"

dao.SzenarienDaoMysql
public static final java.lang.String DELETE_BY_ID "DELETE FROM szenarien WHERE szenarien.ID = ?"
public static final java.lang.String DIM_ID "Dim_ID"
public static final java.lang.String ID "ID"
public static final java.lang.String INSERT "INSERT INTO szenarien (Name, ShortName, TempMin, TempMax, PHMin, PHMax, LichtEin, LichtAus, Dim_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)"
public static final java.lang.String LICHTAUS "LichtAus"
public static final java.lang.String LICHTEIN "LichtEin"
public static final java.lang.String NAME "Name"
public static final java.lang.String PHMAX "PHMax"
public static final java.lang.String PHMIN "PHMin"
public static final java.lang.String SELECT_ALL "SELECT s.ID, s.Name, s.ShortName, s.TempMin, s.TempMax, s.PHMin, s.PHMax, s.LichtEin, s.LichtAus, s.Dim_ID FROM szenarien s ORDER BY 1 DESC"
public static final java.lang.String SELECT_BY_ID "SELECT s.ID, s.Name, s.ShortName, s.TempMin, s.TempMax, s.PHMin, s.PHMax, s.LichtEin, s.LichtAus, s.Dim_ID FROM szenarien s WHERE ID = ?"
public static final java.lang.String SHORTNAME "ShortName"
public static final java.lang.String TEMPMAX "TempMax"
public static final java.lang.String TEMPMIN "TempMin"
public static final java.lang.String UPDATE "UPDATE szenarien SET Name = ?, ShortName = ?, TempMin = ?, TempMax = ?, PHMin = ?, PHMax = ?, LichtEin = ?, LichtAus = ?, Dim_ID = ? WHERE szenarien.ID = ?"

dao.SzenarioFutterzeitDaoMysql
public static final java.lang.String DELETE_BY_ID "DELETE fzs.*,fz.* FROM futterzeit_szenarien fzs INNER JOIN futterzeit fz ON fzs.FutterZeit_ID = fz.ID WHERE fzs.Szenarien_ID=?"
public static final java.lang.String INSERTFZ "INSERT INTO futterzeit (UhrZeit) VALUES (?)"
public static final java.lang.String INSERTSFZ "INSERT INTO futterzeit_szenarien (FutterZeit_ID, Szenarien_ID) VALUES (?, ?)"
public static final java.lang.String SELECT_BY_ID "SELECT fz.UhrZeit FROM futterzeit_szenarien fzs JOIN futterzeit fz ON fzs.FutterZeit_ID = fz.ID WHERE fzs.Szenarien_ID = ? ORDER BY fz.UhrZeit ASC"
public static final java.lang.String UHRZEIT "UhrZeit"

dao.TempwerteDaoMysql
public final java.lang.String SELECT "select Von, Bis from tempwerte where id = ?"

main.*

main.AquaPreferences
public static final java.lang.String COUNTRY_KEY "C"
public static final int DEFAULT_WINDOW_HEIGHT 600
public static final int DEFAULT_WINDOW_STATE 0
public static final int DEFAULT_WINDOW_WIDTH 700
public static final java.lang.String LAF_KEY "LAF"
public static final java.lang.String LANGUAGE_KEY "L"
public static final java.lang.String VARIANT_KEY "V"
public static final java.lang.String WINDOW_HEIGHT_KEY "H"
public static final java.lang.String WINDOW_STATE_KEY "S"
public static final java.lang.String WINDOW_WIDTH_KEY "W"
public static final java.lang.String WINDOW_X_KEY "X"
public static final java.lang.String WINDOW_Y_KEY "Y"

main.ErrorMessage
public static final int CONNECTION 1
public static final int DIMENSION_IN_USE 3
public static final int ERROR 0
public static final int MINIMUM_MAXIMUM 5
public static final int NO_FEED 4
public static final int NOT_VALID 2

main.Resources
public static final java.lang.String PROPERTIES_FILE "resources.aquagui"

model.*

model.SzenarioFutterzeit
public static final java.lang.String DEFAULTZEIT "04:00"
public static final java.lang.String FORMATPATTERN "HH:mm"
public static final long PAUSE 1800000L