KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > teamkonzept > field > db > queries > TKDBGetAllFormIds


1 package com.teamkonzept.field.db.queries;
2
3 import java.sql.*;
4 import com.teamkonzept.db.*;
5
6 /**
7  * liefert alle Fragmente für das Formularelement Fragment
8  * @author
9  * @version
10 */

11 public class TKDBGetAllFormIds extends TKPrepQuery{
12
13     /** @see TKPrepQuery */
14     public final static boolean ISPREPARED =
15         true;
16     
17     /** @see TKPrepQuery */
18     public final static String JavaDoc[] PARAMORDER =
19         null;
20     
21     /** @see TKPrepQuery */
22     public final static Object JavaDoc[][] PARAMTYPES =
23         null;
24         
25     /** @see TKPrepQuery */
26     public final static boolean[] SETRELEVANTS =
27         { true };
28     
29     /** @see TKPrepQuery */
30     public final static String JavaDoc SQLSTRING =
31         "SELECT " +
32         " FO.FORM_ID, FI.FIELD_SHOW_NAME " +
33         "FROM " +
34         " FORM FO, FIELD FI "+
35         "WHERE " +
36         " FO.FORM_ID = FI.FORM_ID "+
37         "AND " +
38         " FI.FIELD_ID = 0 "+
39         "AND " +
40         " FO.FORM_TYPE = 67 ORDER BY " + DBStringFactory.upper_order() + " (FI.FIELD_SHOW_NAME)";
41         
42
43     public void initQuery(Connection con) {
44         super.initQuery(
45             con,
46             ISPREPARED,
47             PARAMORDER,
48             PARAMTYPES,
49             SETRELEVANTS,
50             SQLSTRING );
51     }
52 }
53
54
Popular Tags