KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > teamkonzept > webman > mainint > db > queries > TKDBFormGetAll


1 package com.teamkonzept.webman.mainint.db.queries;
2
3 import java.sql.*;
4
5 import com.teamkonzept.db.*;
6
7 /**
8  *
9  * @author
10  * @version
11  */
12 public class TKDBFormGetAll extends TKPrepQuery{
13
14     public static final boolean ISPREPARED = true;
15     public static final String JavaDoc[] PARAMORDER = null;
16     public static final Object JavaDoc[][] PARAMTYPES = null;
17     public static final boolean[] SETRELEVANTS = { true };
18     /** die Query */
19     public static final String JavaDoc SQLSTRING =
20         "SELECT FO.FORM_ID, FO.FORM_TYPE, FI.FIELD_SHOW_NAME AS FORM_NAME " +
21         "FROM FORM FO , FIELD FI " +
22         "WHERE FO.FORM_ID = FI.FORM_ID" +
23         " AND FI.FIELD_ID = 0" +
24         " AND (" +
25             "FO.FORM_TYPE = " + TKQuery.DBFORM_IDENT + " OR " +
26             "FO.FORM_TYPE = " + TKQuery.DBSTRUC_IDENT + " OR " +
27             "FO.FORM_TYPE = " + TKQuery.DBFRAGMENT_IDENT + ")";
28
29     public void initQuery(Connection con) {
30         super.initQuery(
31             con,
32             ISPREPARED,
33             PARAMORDER,
34             PARAMTYPES,
35             SETRELEVANTS,
36             SQLSTRING );
37     }
38 }
39
40
Popular Tags