KickJava   Java API By Example, From Geeks To Geeks.

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


1 package com.teamkonzept.webman.mainint.db.queries;
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     /** prepariert ? */
17     public final static boolean ISPREPARED =
18         true;
19
20     public final static String JavaDoc[] PARAMORDER =
21         {"PROP_ID"};
22
23     public final static Object JavaDoc[][] PARAMTYPES =
24         {{"PROP_ID", new Integer JavaDoc(Types.INTEGER)}};
25
26     public final static boolean[] SETRELEVANTS =
27         { true };
28     
29     /** die sql-Query */
30     public final static String JavaDoc SQLSTRING =
31
32         "SELECT PG.NAME AS PROPGROUP_NAME, " +
33         " PG.PROPERTY_GROUP_ID AS PROPGROUP_ID, " +
34         DBStringFactory.nvl() + "(PGM.PROPERTY_ID,-1) AS PROP_ID " +
35         "FROM PROPERTY_GROUP PG, PROPERTY_GROUP_MEMBER PGM " +
36         "WHERE " + DBStringFactory.rightOuterJoin("PGM.PROPERTY_GROUP_ID", "PG.PROPERTY_GROUP_ID") +
37         " AND PGM.PROPERTY_ID = ? " +
38         "ORDER BY " + DBStringFactory.upper_order() + " (PG.NAME) ";
39
40     public void initQuery(Connection con) {
41         super.initQuery(
42             con,
43             ISPREPARED,
44             PARAMORDER,
45             PARAMTYPES,
46             SETRELEVANTS,
47             SQLSTRING );
48     }
49 }
50
51
Popular Tags