1 package com.teamkonzept.webman.mainint.db.queries.markups; 2 3 import com.teamkonzept.db.*; 4 import java.sql.Connection ; 5 import java.sql.Types ; 6 7 public class InsertTextAttributeParam extends TKPrepQuery { 8 9 public final static boolean isPrepared = true; 10 11 public final static String [] paramOrder = 12 { "PARAMETER_ID", "NAME", "SELECTION_DATA", "SELECTION_CLASS_ID", "IS_CASE_SENSITIVE", "DEFAULT_VALUE" }; 13 14 public final static Object [][] paramTypes = 15 {{ "NAME", new Integer (Types.VARCHAR) }, 16 { "DEFAULT_VALUE", new Integer (Types.VARCHAR) }}; 17 18 public final static boolean[] setRelevants = { true }; 19 20 public final static String sqlString = 21 "INSERT INTO TEXT_ATTRIBUTE_PARAM " + 22 "( " + 23 " PARAMETER_ID, " + 24 " NAME, " + 25 " SELECTION_DATA, " + 26 " SELECTION_CLASS_ID, " + 27 " IS_CASE_SENSITIVE, " + 28 " DEFAULT_VALUE " + 29 ") " + 30 "VALUES (?,?,?,?,?, ?)"; 31 32 public void initQuery(Connection con) { 33 super.initQuery(con,isPrepared,paramOrder,paramTypes,setRelevants,sqlString ); 34 } 35 } 36 | Popular Tags |