1 5 package com.teamkonzept.publishing.markups.db.queries; 6 7 import java.sql.*; 8 9 import com.teamkonzept.db.*; 10 11 15 public class TKMarkupParamDefinitionUpdate extends TKPrepQuery { 16 17 public final static boolean ISPREPARED = true; 18 19 public final static String [] PARAMORDER = 20 { "NAME", "SELECTION_DATA", "SELECTION_CLASS_ID", "IS_CASE_SENSITIVE", 21 "DEFAULT_VALUE", "PARAMETER_ID" }; 22 23 public final static Object [][] PARAMTYPES = 24 {{ "NAME", new Integer (Types.VARCHAR) }, 25 { "DEFAULT_VALUE", new Integer (Types.VARCHAR) }}; 26 27 public final static boolean[] SETRELEVANTS = { false }; 28 29 public final static String SQLSTRING = 30 31 "UPDATE TEXT_ATTRIBUTE_PARAM " + 32 "SET " + 33 " NAME = ?, " + 34 " SELECTION_DATA = ?, " + 35 " SELECTION_CLASS_ID = ?, " + 36 " IS_CASE_SENSITIVE = ?, " + 37 " DEFAULT_VALUE = ? " + 38 "WHERE "+ 39 " PARAMETER_ID = ? "; 40 41 public void initQuery(Connection con) { 42 super.initQuery(con,ISPREPARED,PARAMORDER,PARAMTYPES,SETRELEVANTS,SQLSTRING ); 43 } 44 } 45 46 | Popular Tags |