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 TKMarkupParamCallPut extends TKPrepQuery { 16 17 public final static boolean ISPREPARED = true; 18 19 public final static String [] PARAMORDER = 20 { "ATTRIBUTE_ID", "PARAMETER_ID", "NAME", "IS_OPTIONAL", "USE_DEFAULT" , 21 "EDIT", "DEFAULT_VALUE" }; 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 "INSERT INTO TEXT_ATTRIBUTE_SYNTAX " + 32 "( " + 33 " ATTRIBUTE_ID, " + 34 " PARAMETER_ID, " + 35 " NAME, " + 36 " IS_OPTIONAL, " + 37 " USE_DEFAULT, " + 38 " EDIT, " + 39 " DEFAULT_VALUE " + 40 ") " + 41 "VALUES (?,?,?,?,?,?,?)"; 42 43 public void initQuery(Connection con) { 44 super.initQuery(con,ISPREPARED,PARAMORDER,PARAMTYPES,SETRELEVANTS,SQLSTRING ); 45 } 46 } 47 48 | Popular Tags |