KickJava   Java API By Example, From Geeks To Geeks.

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


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