1 package com.teamkonzept.webman.mainint.db.queries; 2 3 import java.sql.*; 4 5 import com.teamkonzept.db.*; 6 7 14 public class TKDBPropGetProp extends TKPrepQuery{ 15 16 public final static boolean ISPREPARED = 17 true; 18 19 public final static String [] PARAMORDER = 20 {"PROP_ID"}; 21 22 public final static Object [][] PARAMTYPES = 23 {{"PROP_ID", new Integer (Types.INTEGER)}}; 24 25 public final static boolean[] SETRELEVANTS = 26 { true }; 27 28 public final static String SQLSTRING = 29 "SELECT " + 30 " PROPERTY_ID AS PROP_ID, NAME AS PROP_NAME, VALUE AS PROP_VALUE " + 31 "FROM " + 32 " PROPERTY WHERE " + 33 " PROPERTY_ID = ? "; 34 35 36 public void initQuery(Connection con) { 37 super.initQuery( 38 con, 39 ISPREPARED, 40 PARAMORDER, 41 PARAMTYPES, 42 SETRELEVANTS, 43 SQLSTRING ); 44 } 45 } 46 47 | Popular Tags |