KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > teamkonzept > lib > db > queries > TKDBPropGroupGetPropsByName


1 package com.teamkonzept.lib.db.queries;
2
3 import java.sql.*;
4
5 import com.teamkonzept.db.*;
6
7 /**
8  * TKDBPropGetGroupsByName
9  * input (PROP_ID)
10  * output (PROPGROUP_ID, PROPGROUP_NAME, PROP_ID)
11  * @author
12  * @version
13  */
14 public class TKDBPropGroupGetPropsByName extends TKPrepQuery{
15
16     /** prepared querie ?*/
17     public final static boolean ISPREPARED =
18         true;
19     
20     public final static String JavaDoc[] PARAMORDER =
21         {"PROPGROUP_NAME"};
22     
23     public final static Object JavaDoc[][] PARAMTYPES =
24         {{"PROPGROUP_NAME", new Integer JavaDoc(Types.VARCHAR)}};
25         
26     public final static boolean[] SETRELEVANTS =
27         { true };
28         
29     /** die sql-Query */
30     public final static String JavaDoc SQLSTRING =
31
32         "select a.NAME, " +
33         " a.VALUE " +
34         "from PROPERTY a, PROPERTY_GROUP_MEMBER b, PROPERTY_GROUP c " +
35         "where b.PROPERTY_ID = a.PROPERTY_ID " +
36         " and b.PROPERTY_GROUP_ID = c.PROPERTY_GROUP_ID " +
37         " and c.NAME = ? " +
38         "order by " + DBStringFactory.upper_order() + " (a.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