KickJava   Java API By Example, From Geeks To Geeks.

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


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, _REFERENCE)
11  */
12 public class TKDBPresCompGetRef 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         " PR.SUB_PRESENTATION_ID " +
32         "FROM " +
33         " PRESENTATION_COMPONENT PC, " +
34         " PRESENTATION_REFERENCE PR " +
35         "WHERE " +
36         " PC.PRESENTATION_ID = ? " +
37         "AND " +
38         " PC.PRESENTATION_ID = PR.PRESENTATION_ID " +
39         "AND " +
40         " PC.PRESENTATION_COMPONENT_IDX = PR.PRESENTATION_COMPONENT_IDX " +
41         "ORDER BY " +
42         " PC.PRESENTATION_COMPONENT_IDX ";
43
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