KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > teamkonzept > webman > mainint > db > queries > postgresql > TKDBPropGetGroups


1 package com.teamkonzept.webman.mainint.db.queries.postgresql;
2
3 import java.sql.*;
4
5 import com.teamkonzept.db.*;
6
7 /*
8  * TKDBPropGetGroups
9  * input (PROP_ID)
10  * output (PROPGROUP_ID, PROPGROUP_NAME, PROP_ID)
11  * @author
12  * @version
13  */
14 public class TKDBPropGetGroups extends TKPrepQuery{
15
16     public final static boolean ISPREPARED =
17         true;
18     
19     public final static String JavaDoc[] PARAMORDER =
20         {"PROP_ID"};
21     
22     public final static Object JavaDoc[][] PARAMTYPES =
23         {{"PROP_ID", new Integer JavaDoc(Types.INTEGER)}};
24         
25     public final static boolean[] SETRELEVANTS =
26         { true };
27         
28     public final static String JavaDoc SQLSTRING =
29
30         "SELECT PG.NAME AS \"PROPGROUP_NAME\", " +
31         " PG.PROPERTY_GROUP_ID AS \"PROPGROUP_ID\", " +
32             DBStringFactory.nvl() + "(PGM.PROPERTY_ID,-1) AS \"PROP_ID\" " +
33         "FROM PROPERTY_GROUP_MEMBER PGM RIGHT JOIN PROPERTY_GROUP PG USING ( PROPERTY_GROUP_ID ) " +
34         "WHERE PGM.PROPERTY_ID = ? " +
35         "ORDER BY PG.NAME ";
36     
37     public void initQuery(Connection con) {
38         super.initQuery(
39             con,
40             ISPREPARED,
41             PARAMORDER,
42             PARAMTYPES,
43             SETRELEVANTS,
44             SQLSTRING );
45     }
46 }
47
48
Popular Tags