KickJava   Java API By Example, From Geeks To Geeks.

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


1 package com.teamkonzept.webman.mainint.db.queries;
2
3 import java.sql.*;
4
5 import com.teamkonzept.db.*;
6
7 /*
8  * TKDBPresCompGet
9  * input PRESENTATION_ID
10  * output (Alle DS aus PRESENTATION_COMPONENT, _CONTENT, REF)
11  */
12 public class TKDBPresCompGetAll extends TKPrepQuery{
13
14     public final static boolean ISPREPARED =
15         true;
16     
17     public final static String JavaDoc[] PARAMORDER =
18         {"PRESENTATION_ID"};
19     
20     public final static Object JavaDoc[][] PARAMTYPES =
21         null;
22         
23     public final static boolean[] SETRELEVANTS =
24         { true };
25         
26     public final static String JavaDoc SQLSTRING =
27         "SELECT " +
28         " PC.PRESENTATION_ID, PC.PRESENTATION_COMPONENT_IDX, " +
29         " PC.COMPONENT_TYPE, PC.INTEGRATION_TYPE, PC.INTEGRATION_NAME, " +
30         " PC.INTEGRATION_SHORTNAME, " +
31         " PT.FORM_ID " +
32         "FROM " +
33         " PRESENTATION_COMPONENT PC, " +
34         " PRESENTATION_CONTENT PT " +
35         "WHERE " +
36         " PC.PRESENTATION_ID = ? " +
37         "AND " +
38         // " PC.PRESENTATION_ID *= PT.PRESENTATION_ID " +
39 DBStringFactory.leftOuterJoin("PC.PRESENTATION_ID", "PT.PRESENTATION_ID") +
40         " AND " +
41         //" PC.PRESENTATION_COMPONENT_IDX *= PT.PRESENTATION_COMPONENT_IDX " +
42 DBStringFactory.leftOuterJoin("PC.PRESENTATION_COMPONENT_IDX", "PT.PRESENTATION_COMPONENT_IDX") +
43         " ORDER BY " +
44         " PC.PRESENTATION_COMPONENT_IDX ";
45         
46     public void initQuery(Connection con) {
47         super.initQuery(
48             con,
49             ISPREPARED,
50             PARAMORDER,
51             PARAMTYPES,
52             SETRELEVANTS,
53             SQLSTRING );
54     }
55 }
56
57
Popular Tags