KickJava   Java API By Example, From Geeks To Geeks.

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


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