KickJava   Java API By Example, From Geeks To Geeks.

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


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/Attic/TKDBPresCompGet.java,v 1.6 2000/10/24 20:22:24 alex Exp $
3  *
4  */
5 /**
6  * Jedes Selectstatement erhaelt eine eigene Klasse
7  */
8 package com.teamkonzept.webman.mainint.db.queries;
9
10 import java.sql.*;
11
12 import com.teamkonzept.db.*;
13
14 /*
15  * TKDBPresCompGet
16  * input PRESENTATION_ID
17  * output (Alle DS aus PRESENTATION_COMPONENT, _CONTENT)
18  */
19 public class TKDBPresCompGet extends TKPrepQuery{
20
21     public final static boolean isPrepared =
22         true;
23     
24     public final static String JavaDoc[] paramOrder =
25         {"PRESENTATION_ID"};
26     
27     public final static Object JavaDoc[][] paramTypes =
28         null;
29         
30     public final static boolean[] setRelevants =
31         { true };
32         
33     public final static String JavaDoc sqlString =
34         "SELECT " +
35         " PC.PRESENTATION_ID, PC.PRESENTATION_COMPONENT_IDX, " +
36         " PC.COMPONENT_TYPE, PC.INTEGRATION_TYPE, PC.INTEGRATION_NAME, " +
37         " PC.INTEGRATION_SHORTNAME, " +
38         " PT.FORM_ID " +
39         "FROM " +
40         " PRESENTATION_COMPONENT PC, " +
41         " PRESENTATION_CONTENT PT " +
42         "WHERE " +
43         " PC.PRESENTATION_ID = ? " +
44         "AND " +
45         " PC.PRESENTATION_ID = PT.PRESENTATION_ID " +
46         "AND " +
47         " PC.PRESENTATION_COMPONENT_IDX = PT.PRESENTATION_COMPONENT_IDX " +
48         "ORDER BY " +
49         " PC.PRESENTATION_COMPONENT_IDX ";
50
51     
52     public void initQuery(Connection con) {
53         super.initQuery(
54             con,
55             isPrepared,
56             paramOrder,
57             paramTypes,
58             setRelevants,
59             sqlString );
60     }
61 }
62
63
Popular Tags