KickJava   Java API By Example, From Geeks To Geeks.

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


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 freien Referenzen
11  */
12 public class TKDBPresCompGetFreeRef 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         "FROM " +
32         " PRESENTATION_COMPONENT PC " +
33         "WHERE " +
34         " PC.PRESENTATION_ID = ? " +
35         " AND PC.COMPONENT_TYPE = 1";
36
37     
38     public void initQuery(Connection con) {
39         super.initQuery(
40             con,
41             isPrepared,
42             paramOrder,
43             paramTypes,
44             setRelevants,
45             sqlString );
46     }
47 }
48
49
Popular Tags