1 package de.webman.content.workflow.db.queries; 2 3 import com.teamkonzept.db.*; 4 import java.sql.*; 5 6 11 public class UpdateFilterRule extends TKPrepQuery 12 { 13 14 public final static boolean IS_PREPARED = 15 true; 16 17 public final static String [] PARAM_ORDER = 18 { "RULE_TYPE", "FILTER_ID", "STATUS_ID" }; 19 20 public final static Object [][] PARAM_TYPES = 21 null; 22 23 public final static boolean[] SET_RELEVANTS = 24 { true }; 25 26 public final static String SQL_STRING = 27 28 "UPDATE " + 29 " VERSION_STATUS_FILTER_RULE " + 30 " SET RULE_TYPE= ? " + 31 " WHERE FILTER_ID=? AND STATUS_ID=? "; 32 33 public void initQuery(Connection con) { 34 super.initQuery( 35 con, 36 IS_PREPARED, 37 PARAM_ORDER, 38 PARAM_TYPES, 39 SET_RELEVANTS, 40 SQL_STRING ); 41 } 42 } 43 | Popular Tags |