KickJava   Java API By Example, From Geeks To Geeks.

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


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/Attic/TKDBPresRefSubGet.java,v 1.5 2000/05/22 15:01:48 careck 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  * TKDBPresRefSubGet
16  * input PRESENTATION_ID, PRESENTATION_COMPONENT_IDX
17  * output (Alle DS aus PRESENTATION mit gleicher SUB_PRESENTATION_ID)
18  */
19 public class TKDBPresRefSubGet extends TKPrepQuery{
20
21     public final static boolean isPrepared =
22         true;
23     
24     public final static String JavaDoc[] paramOrder =
25         {"PRESENTATION_ID", "PRESENTATION_COMPONENT_IDX"};
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         " P.* " +
36         "FROM " +
37         " PRESENTATION P, " +
38         " PRESENTATION_REFERENCE PR " +
39         "WHERE " +
40         " PR.PRESENTATION_ID = ? " +
41         "AND " +
42         " PR.PRESENTATION_COMPONENT_IDX = ? " +
43         "AND " +
44         " PR.SUB_PRESENTATION_ID = P.PRESENTATION_ID " +
45         "ORDER BY " +
46         " PR.PRESENTATION_COMPONENT_IDX ";
47
48     
49     public void initQuery(Connection con) {
50         super.initQuery(
51             con,
52             isPrepared,
53             paramOrder,
54             paramTypes,
55             setRelevants,
56             sqlString );
57     }
58 }
59
60
Popular Tags