01: package com.teamkonzept.webman.mainint.db.queries;
02:
03: import java.sql.*;
04:
05: import com.teamkonzept.db.*;
06:
07: /**
08: *
09: * @author
10: * @version
11: */
12: public class TKDBFormGetStruct extends TKPrepQuery {
13:
14: public static final boolean ISPREPARED = true;
15: public static final String[] PARAMORDER = null;
16: public static final Object[][] PARAMTYPES = null;
17: public static final boolean[] SETRELEVANTS = { true };
18: /** die Query */
19: public static final String SQLSTRING = "SELECT FO.FORM_ID, FI.FIELD_SHOW_NAME AS FORM_NAME "
20: + "FROM FORM FO, FIELD FI "
21: + "WHERE FO.FORM_ID = FI.FORM_ID"
22: + " AND FI.FIELD_ID = 0 AND FO.FORM_TYPE = "
23: + TKQuery.DBSTRUC_IDENT + " ORDER BY FI.FIELD_SHOW_NAME ";
24:
25: public void initQuery(Connection con) {
26: super.initQuery(con, ISPREPARED, PARAMORDER, PARAMTYPES,
27: SETRELEVANTS, SQLSTRING);
28: }
29: }
|