01: package com.teamkonzept.field.db.queries;
02:
03: import java.sql.*;
04: import com.teamkonzept.db.*;
05:
06: /**
07: * liefert alle Fragmente für das Formularelement Fragment
08: * @author
09: * @version
10: */
11: public class TKDBGetAllFormIds extends TKPrepQuery {
12:
13: /** @see TKPrepQuery */
14: public final static boolean ISPREPARED = true;
15:
16: /** @see TKPrepQuery */
17: public final static String[] PARAMORDER = null;
18:
19: /** @see TKPrepQuery */
20: public final static Object[][] PARAMTYPES = null;
21:
22: /** @see TKPrepQuery */
23: public final static boolean[] SETRELEVANTS = { true };
24:
25: /** @see TKPrepQuery */
26: public final static String SQLSTRING = "SELECT "
27: + " FO.FORM_ID, FI.FIELD_SHOW_NAME " + "FROM "
28: + " FORM FO, FIELD FI " + "WHERE "
29: + " FO.FORM_ID = FI.FORM_ID " + "AND "
30: + " FI.FIELD_ID = 0 " + "AND "
31: + " FO.FORM_TYPE = 67 ORDER BY "
32: + DBStringFactory.upper_order() + " (FI.FIELD_SHOW_NAME)";
33:
34: public void initQuery(Connection con) {
35: super.initQuery(con, ISPREPARED, PARAMORDER, PARAMTYPES,
36: SETRELEVANTS, SQLSTRING);
37: }
38: }
|