|
||||||||||
PREV NEXT | FRAMES NO FRAMES |
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 |
|
||||||||||
PREV NEXT | FRAMES NO FRAMES |