KickJava   Java API By Example, From Geeks To Geeks.

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


1 package com.teamkonzept.webman.mainint.db.queries;
2
3 import java.sql.*;
4
5 import com.teamkonzept.db.*;
6
7 /**
8  * TKDBStructContGetFreeForm
9  *
10  * Input: SITE_NODE_ID
11  * Output: alle DS zu ID aus FIELD die noch nicht im Structured Content
12  *
13  * @author
14  * @version
15  */

16
17 public class TKDBStructContGetFreeForm extends TKPrepQuery{
18
19     /** prepariert ? */
20     public final static boolean ISPREPARED =
21         true;
22     
23     public final static String JavaDoc[] PARAMORDER =
24         {"SITE_NODE_ID"};
25     
26     public final static Object JavaDoc[][] PARAMTYPES =
27         null;
28         
29     public final static boolean[] SETRELEVANTS =
30         { true };
31     /** die Query */
32     public final static String JavaDoc SQLSTRING =
33         "SELECT " +
34         " FI.FORM_ID, FI.FIELD_SHOW_NAME AS FORM_DESCRIPTION " +
35         "FROM " +
36         " FORM FO, FIELD FI " +
37         "WHERE " +
38          " FO.FORM_ID = FI.FORM_ID " +
39         "AND " +
40         " FI.FIELD_ID = 0 " +
41         "AND " +
42         " FO.FORM_TYPE = " + TKQuery.DBSTRUC_IDENT + " " +
43         "AND " +
44         " FO.FORM_ID NOT IN ( " +
45             "SELECT " +
46             " FORM_ID " +
47             "FROM " +
48             " STRUCTURED_CONTENT " +
49             "WHERE " +
50             " SITE_NODE_ID = ? " +
51             ") " +
52         " ORDER BY " + DBStringFactory.upper_order() + "(FI.FIELD_SHOW_NAME)";
53             
54     /** init query */
55     public void initQuery(Connection con) {
56         super.initQuery(
57             con,
58             ISPREPARED,
59             PARAMORDER,
60             PARAMTYPES,
61             SETRELEVANTS,
62             SQLSTRING );
63     }
64 }
65
66
Popular Tags