1 package de.webman.form.db.queries; 2 3 import java.sql.Connection ; 4 import com.teamkonzept.db.TKPrepQuery; 5 import de.webman.form.db.FieldAttributeConstants; 6 import de.webman.form.db.FormConstants; 7 8 37 public class SelectReferencedForms 38 extends TKPrepQuery 39 { 40 41 43 46 private final static boolean IS_PREPARED = true; 47 48 51 private final static String [] PARAMETER_ORDER = 52 { 53 FieldAttributeConstants.COLUMN_NAMES[FieldAttributeConstants.VALUE] 54 }; 55 56 59 private final static Object [][] PARAMETER_TYPES = 60 { 61 {FieldAttributeConstants.COLUMN_NAMES[FieldAttributeConstants.VALUE], FieldAttributeConstants.COLUMN_TYPES[FieldAttributeConstants.VALUE]} 62 }; 63 64 67 private final static boolean[] SET_RELEVANTS = 68 { 69 true 70 }; 71 72 75 private final static String SQL_STRING = "SELECT DISTINCT FORM_ID " + 76 "FROM FIELD_ATTRIBUTE " + 77 "WHERE NAME = 'FORM_ID' " + 78 "AND VALUE = ?"; 79 80 81 83 88 public void initQuery (Connection connection) 89 { 90 super.initQuery(connection, 91 IS_PREPARED, 92 PARAMETER_ORDER, 93 PARAMETER_TYPES, 94 SET_RELEVANTS, 95 SQL_STRING); 96 } 97 98 104 public final void setQueryParams (String name, Object value) 105 { 106 if (FormConstants.COLUMN_NAMES[FormConstants.FORM_ID].equals(name)) 107 { 108 super.setQueryParams(FieldAttributeConstants.COLUMN_NAMES[FieldAttributeConstants.VALUE], 109 value != null ? value.toString() : (String ) null); 110 } 111 else 112 { 113 super.setQueryParams(name, value); 114 } 115 } 116 117 } 118 | Popular Tags |