1 package de.webman.acl.db.queries.sybase; 2 3 import java.sql.Connection ; 4 import java.sql.Types ; 5 import com.teamkonzept.db.TKPrepQuery; 6 7 14 public class UserDelete 15 extends TKPrepQuery 16 { 17 18 20 public static final String [] ORDER = 21 { 22 "WM_USER_ID", 23 "WM_USER_ID", 24 "WM_USER_ID" 25 }; 26 27 public static final Object [][] TYPES = 28 { 29 {"WM_USER_ID", new Integer (Types.INTEGER)}, 30 {"WM_USER_ID", new Integer (Types.INTEGER)}, 31 {"WM_USER_ID", new Integer (Types.INTEGER)} 32 }; 33 34 public static final boolean[] RELEVANTS = 35 { 36 false 37 }; 38 39 public static final String SQL = (new StringBuffer ()).append("DELETE FROM WM_POLICY WHERE WM_USER_ID = ? ") 40 .append("DELETE FROM WM_PROFILE WHERE WM_PROFILE_ID = ? ") 41 .append("DELETE FROM WM_USER WHERE WM_USER_ID = ?") 42 .toString(); 43 44 45 47 public void initQuery (Connection connection) 48 { 49 super.initQuery(connection, 50 true, 51 ORDER, 52 TYPES, 53 RELEVANTS, 54 SQL); 55 } 56 57 } 58 | Popular Tags |