01: package com.teamkonzept.webman.mainint.db.queries;
02:
03: import java.sql.*;
04:
05: import com.teamkonzept.db.*;
06:
07: /**
08: * TKDBPropGroupGetAll
09: * input none
10: * output (PROPGROUP_ID, PROPGROUP_NAME)
11: * @author
12: * @version
13: */
14: public class TKDBPropGroupGetAll extends TKPrepQuery {
15:
16: public final static boolean ISPREPARED = true;
17:
18: public final static String[] PARAMORDER = null;
19:
20: public final static Object[][] PARAMTYPES = null;
21:
22: public final static boolean[] SETRELEVANTS = { true };
23:
24: public final static String SQLSTRING = "SELECT "
25: + " PROPERTY_GROUP_ID AS PROPGROUP_ID, NAME AS PROPGROUP_NAME "
26: + "FROM " + " PROPERTY_GROUP ";
27:
28: public void initQuery(Connection con) {
29: super.initQuery(con, ISPREPARED, PARAMORDER, PARAMTYPES,
30: SETRELEVANTS, SQLSTRING);
31: }
32: }
|