KickJava   Java API By Example, From Geeks To Geeks.

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


1 package com.teamkonzept.webman.mainint.db.queries.postgresql;
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  * @author
12  * @version
13  */
14 public class TKDBPresCompGetAll extends TKPrepQuery{
15
16     public final static boolean ISPREPARED =
17         true;
18     
19     public final static String JavaDoc[] PARAMORDER =
20         {"PRESENTATION_ID"};
21     
22     public final static Object JavaDoc[][] PARAMTYPES =
23         null;
24         
25     public final static boolean[] SETRELEVANTS =
26         { true };
27         
28     public final static String JavaDoc SQLSTRING =
29         "SELECT " +
30         " PC.PRESENTATION_ID, PC.PRESENTATION_COMPONENT_IDX, " +
31         " PC.COMPONENT_TYPE, PC.INTEGRATION_TYPE, PC.INTEGRATION_NAME, " +
32         " PC.INTEGRATION_SHORTNAME, " +
33         " PT.FORM_ID " +
34         "FROM " +
35         " PRESENTATION_COMPONENT PC LEFT JOIN PRESENTATION_CONTENT PT USING ( PRESENTATION_ID, PRESENTATION_COMPONENT_IDX ) " +
36         "WHERE PC.PRESENTATION_ID = ? " +
37         "ORDER BY PC.PRESENTATION_COMPONENT_IDX ";
38         
39     public void initQuery(Connection con) {
40         super.initQuery(
41             con,
42             ISPREPARED,
43             PARAMORDER,
44             PARAMTYPES,
45             SETRELEVANTS,
46             SQLSTRING );
47     }
48 }
49
50
Popular Tags