1 package com.teamkonzept.webman.mainint.db.queries; 2 3 import java.sql.*; 4 5 import com.teamkonzept.db.*; 6 7 14 public class TKDBPropGetGroups extends TKPrepQuery{ 15 16 17 public final static boolean ISPREPARED = 18 true; 19 20 public final static String [] PARAMORDER = 21 {"PROP_ID"}; 22 23 public final static Object [][] PARAMTYPES = 24 {{"PROP_ID", new Integer (Types.INTEGER)}}; 25 26 public final static boolean[] SETRELEVANTS = 27 { true }; 28 29 30 public final static String 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 |