KickJava   Java API By Example, From Geeks To Geeks.

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


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 TKDBFormGetAll67 extends TKPrepQuery{
13
14     /** prepariert ? */
15     public static final boolean ISPREPARED = true;
16     public static final String JavaDoc[] PARAMORDER = null;
17     public static final Object JavaDoc [][] PARAMTYPES = null;
18     public static final boolean[] SETRELEVANTS = { true };
19     /** die Query */
20     public static final String JavaDoc SQLSTRING =
21         "SELECT FO.FORM_ID, FI.FIELD_SHOW_NAME AS FORM_NAME " +
22         "FROM FORM FO, FIELD FI " +
23         "WHERE FO.FORM_ID = FI.FORM_ID" +
24         " AND FI.FIELD_ID = 0 " +
25         " AND FO.FORM_TYPE = " + TKQuery.DBFRAGMENT_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             ISPREPARED,
33             PARAMORDER,
34             PARAMTYPES,
35             SETRELEVANTS,
36             SQLSTRING );
37     }
38 }
39
40
41
Popular Tags