1 package com.teamkonzept.webman.mainint.db.queries.accesscontrol; 2 3 import java.sql.Connection ; 4 import java.sql.Types ; 5 import com.teamkonzept.db.*; 6 7 public class InsertWMPolicy extends TKPrepQuery 8 { 9 10 public final static boolean prepared = true; 11 12 public static final String [] order = 13 { 14 "WM_POLICY_ID", 15 "WM_USER_ID", 16 "WM_ROLE_ID", 17 "WM_CONTEXT_ID", 18 "OBJECT_REFERENCE", 19 "OBJECT_TYPE", 20 "POLICY_ACCESS" 21 }; 22 23 public static final Object [][] types = 24 { 25 {"WM_POLICY_ID", new Integer (Types.INTEGER)}, 26 {"WM_USER_ID", new Integer (Types.INTEGER)}, 27 {"WM_ROLE_ID", new Integer (Types.INTEGER)}, 28 {"WM_CONTEXT_ID", new Integer (Types.INTEGER)}, 29 {"OBJECT_REFERENCE", new Integer (Types.INTEGER)}, 30 {"OBJECT_TYPE", new Integer (Types.INTEGER)}, 31 {"POLICY_ACCESS", new Integer (Types.CHAR)} 32 }; 33 34 public final static boolean[] relevants = { true }; 35 36 public final static String sqlString = "INSERT INTO WM_POLICY (WM_POLICY_ID, WM_USER_ID, WM_ROLE_ID, WM_CONTEXT_ID, OBJECT_REFERENCE, OBJECT_TYPE, POLICY_ACCESS) VALUES (?, ?, ?, ?, ?, ?, ?)"; 37 38 public void initQuery(Connection con) { 39 super.initQuery( 40 con, 41 prepared, 42 order, 43 types, 44 relevants, 45 sqlString ); 46 } 47 48 } | Popular Tags |