KickJava   Java API By Example, From Geeks To Geeks.

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


1 package com.teamkonzept.webman.mainint.db.queries;
2
3 import java.sql.*;
4
5 import com.teamkonzept.db.*;
6
7 /*
8  * TKDBPropGroupGetRemainingProps
9  * input (PROPGROUP_ID)
10  * output (PROPERPTY_ID, NAME, VALUE)
11  * selects all properties that belongs not to the specified property group.
12  * @author
13  * @version
14  */
15 public class TKDBPropGroupGetGroupProps extends TKPrepQuery{
16
17     public final static boolean ISPREPARED =
18         true;
19     
20     public final static String JavaDoc[] PARAMORDER =
21         {"PROPGROUP_ID"};
22     
23     public final static Object JavaDoc[][] PARAMTYPES =
24         {{"PROPGROUP_ID", new Integer JavaDoc(Types.INTEGER)}};
25         
26     public final static boolean[] SETRELEVANTS =
27         { true };
28         
29     public final static String JavaDoc SQLSTRING =
30         "SELECT P.PROPERTY_ID AS PROP_ID, P.NAME AS PROP_NAME, P.VALUE AS PROP_VALUE " +
31         " FROM PROPERTY P, PROPERTY_GROUP_MEMBER M " +
32         " WHERE M.PROPERTY_ID = P.PROPERTY_ID " +
33         " AND M.PROPERTY_GROUP_ID = ?";
34         
35     public void initQuery(Connection con) {
36         super.initQuery(
37             con,
38             ISPREPARED,
39             PARAMORDER,
40             PARAMTYPES,
41             SETRELEVANTS,
42             SQLSTRING );
43     }
44 }
45
Popular Tags