KickJava   Java API By Example, From Geeks To Geeks.

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


1 package com.teamkonzept.webman.mainint.db.queries;
2
3 import java.sql.*;
4
5 import com.teamkonzept.db.*;
6
7 /**
8  * TKDBStructContGet
9  *
10  * Input: SITE_NODE_ID
11  * Output: alle DS zu ID aus FIELD und SC
12  * @author $Author: alex $
13  * @version $Revision: 1.11 $
14  */
15 public class TKDBStructContGet extends TKPrepQuery{
16
17     public static boolean isPrepared =
18         true;
19     
20     public static String JavaDoc[] paramOrder =
21         {"SITE_NODE_ID"};
22     
23     public static Object JavaDoc[][] paramTypes =
24         null;
25         
26     public static boolean[] setRelevants =
27         { true };
28     /** die Query */
29     public static String JavaDoc sqlString =
30         "SELECT " +
31         " SC.SITE_NODE_ID, SC.CONTENT_ID, FI.* " +
32         "FROM " +
33         " STRUCTURED_CONTENT SC, FORM FO, FIELD FI " +
34         "WHERE " +
35          " FO.FORM_ID = FI.FORM_ID " +
36         "AND " +
37         " FI.FIELD_ID = 0 " +
38         "AND " +
39         " SC.SITE_NODE_ID = ? " +
40         "AND " +
41         " SC.FORM_ID = FO.FORM_ID " +
42         "AND " +
43         " FO.FORM_TYPE = " + TKQuery.DBSTRUC_IDENT + " ";
44     
45     public void initQuery(Connection con) {
46         super.initQuery(
47             con,
48             isPrepared,
49             paramOrder,
50             paramTypes,
51             setRelevants,
52             sqlString );
53     }
54 }
55
56
Popular Tags