1 5 8 package com.teamkonzept.field.db.queries; 9 10 import java.sql.*; 11 12 import com.teamkonzept.db.*; 13 14 public class TKDBFormSubFieldGet extends TKPrepQuery{ 15 16 public final static boolean isPrepared = 17 true; 18 19 public final static String [] paramOrder = 20 { "FORM_ID" }; 21 22 public final static Object [][] paramTypes = 23 null; 24 25 public final static boolean[] setRelevants = 26 { true }; 27 28 public final static String sqlString = 29 "SELECT " + 30 " FORM_ID, FIELD_ID, SUB_FIELD_ID, NAME, IDX " + 31 "FROM " + 32 " SUB_FIELD " + 33 "WHERE " + 34 " FORM_ID = ? " + 35 "ORDER BY " + 36 " POS"; 37 38 public void initQuery(Connection con) { 39 super.initQuery( 40 con, 41 isPrepared, 42 paramOrder, 43 paramTypes, 44 setRelevants, 45 sqlString ); 46 } 47 } 48 49 | Popular Tags |