KickJava   Java API By Example, From Geeks To Geeks.

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


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 TKDBFormGetAll69 extends TKPrepQuery{
13
14     /** prepariert ? */
15     public static final boolean IS_PREPARED = true;
16     public static final String JavaDoc[] PARAM_ORDER = null;
17     public static final Object JavaDoc[][] PARAM_TYPES = null;
18     public static final boolean[] SET_RELEVANTS = { true };
19     
20     /** die Query */
21     public static final String JavaDoc SQL_STRING =
22         "SELECT FO.FORM_ID, FI.FIELD_SHOW_NAME AS FORM_NAME " +
23         "FROM FORM FO, FIELD FI " +
24         "WHERE FO.FORM_ID = FI.FORM_ID" +
25         " AND FI.FIELD_ID = 0 AND FO.FORM_TYPE = " + TKQuery.DBFORM_IDENT +
26         " ORDER BY " + DBStringFactory.upper_order() + " (FI.FIELD_SHOW_NAME) ";
27     
28     /** init query */
29     public void initQuery(Connection con) {
30         super.initQuery(
31             con,
32             IS_PREPARED,
33             PARAM_ORDER,
34             PARAM_TYPES,
35             SET_RELEVANTS,
36             SQL_STRING );
37     }
38 }
39
40
Popular Tags