KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > de > webman > content > workflow > db > queries > sybase > DeleteFilter


1 package de.webman.content.workflow.db.queries.sybase;
2
3 import com.teamkonzept.db.*;
4 import java.sql.*;
5
6 /**
7     loescht Filter
8     * @author $Author: markus $
9     * @version $Revision: 1.1 $
10 */
11 public class DeleteFilter extends TKPrepQuery
12 {
13
14     public final static boolean IS_PREPARED =
15         true;
16     
17     public final static String JavaDoc[] PARAM_ORDER =
18         { "FILTER_ID" };
19     
20     public final static Object JavaDoc[][] PARAM_TYPES =
21         null;
22         
23     public final static boolean[] SET_RELEVANTS =
24         { true };
25         
26     public final static String JavaDoc SQL_STRING =
27         
28         "DECLARE @N_ID int " +
29         "SELECT @N_ID = ? " +
30         
31         "DELETE FROM " +
32         "VERSION_STATUS_FILTER_RULE " +
33         " WHERE FILTER_ID = @N_ID " +
34         
35         "DELETE FROM " +
36         " VERSION_STATUS_FILTER " +
37         "WHERE FILTER_ID = @N_ID ";
38         
39         
40     public void initQuery(Connection con) {
41         super.initQuery(
42             con,
43             IS_PREPARED,
44             PARAM_ORDER,
45             PARAM_TYPES,
46             SET_RELEVANTS,
47             SQL_STRING );
48     }
49 }
50
Popular Tags