KickJava   Java API By Example, From Geeks To Geeks.

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


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 TKDBFormGetStruct 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, 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 AND FO.FORM_TYPE = " + TKQuery.DBSTRUC_IDENT +
24         " ORDER BY FI.FIELD_SHOW_NAME ";
25     
26     public void initQuery(Connection con) {
27         super.initQuery(
28             con,
29             ISPREPARED,
30             PARAMORDER,
31             PARAMTYPES,
32             SETRELEVANTS,
33             SQLSTRING );
34     }
35 }
36
37
Popular Tags