KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > de > webman > content > workflow > db > queries > VersionStatusTransitionUpdate


1 package de.webman.content.workflow.db.queries;
2
3 import com.teamkonzept.db.*;
4 import java.sql.*;
5
6 /**
7     * @author $Author: alex $
8     * @version $Revision: 1.1 $
9 */
10 public class VersionStatusTransitionUpdate extends TKPrepQuery {
11
12     public final static boolean IS_PREPARED = true;
13     
14     public final static String JavaDoc[] PARAM_ORDER =
15         { "TRANSITION_ATTRIBUTES", "STATUS_ID", "NEW_STATUS_ID" };
16     
17     public final static Object JavaDoc[][] PARAM_TYPES =
18         { {"TRANSITION_ATTRIBUTES", new Integer JavaDoc(Types.VARCHAR)} };
19         
20     public final static boolean[] SET_RELEVANTS =
21         { false };
22         
23     public final static String JavaDoc SQL_STRING =
24         "UPDATE VERSION_STATUS_TRANSITION " +
25         "SET TRANSITION_ATTRIBUTES = ? " +
26         "WHERE STATUS_ID = ? AND NEW_STATUS_ID = ? ";
27
28     public void initQuery(Connection con) {
29         super.initQuery(
30             con,
31             IS_PREPARED,
32             PARAM_ORDER,
33             PARAM_TYPES,
34             SET_RELEVANTS,
35             SQL_STRING );
36     }
37 }
38
Popular Tags