KickJava   Java API By Example, From Geeks To Geeks.

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


1 package de.webman.content.workflow.db.queries.sybase;
2
3
4 import com.teamkonzept.db.*;
5 import java.sql.*;
6
7 /**
8     fuegt neuen Filter ein
9     * @author $Author: markus $
10     * @version $Revision: 1.2 $
11 */
12 public class InsertFilter extends TKPrepQuery
13 {
14
15     public final static boolean IS_PREPARED =
16         true;
17     
18     public final static String JavaDoc[] PARAM_ORDER =
19         { "FILTER_NAME", "FILTER_MODE" };
20     
21     public final static Object JavaDoc[][] PARAM_TYPES =
22         null;
23         
24     public final static boolean[] SET_RELEVANTS =
25         { true };
26         
27     public final static String JavaDoc SQL_STRING =
28         "DECLARE @ID INT " +
29         
30         "BEGIN TRANSACTION " +
31         
32         "SELECT " +
33         " @ID=ISNULL(MAX(FILTER_ID)+1, 1) " +
34         "FROM " +
35         " VERSION_STATUS_FILTER " +
36         
37         "INSERT INTO " +
38         "VERSION_STATUS_FILTER " +
39         " (FILTER_ID, FILTER_NAME, FILTER_MODE) " +
40         "VALUES(@ID, ?, ?) " +
41         
42         "COMMIT TRANSACTION " +
43         
44         "SELECT " +
45         " * " +
46         "FROM " +
47         " VERSION_STATUS_FILTER " +
48         "WHERE " +
49         " FILTER_ID = @ID ";
50         
51     public void initQuery(Connection con) {
52         super.initQuery(
53             con,
54             IS_PREPARED,
55             PARAM_ORDER,
56             PARAM_TYPES,
57             SET_RELEVANTS,
58             SQL_STRING );
59     }
60 }
61
Popular Tags