KickJava   Java API By Example, From Geeks To Geeks.

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


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 VersionStatusTransitionGetAll extends TKPrepQuery {
11
12     public final static boolean IS_PREPARED = true;
13     
14     public final static String JavaDoc[] PARAM_ORDER = null;
15     
16     public final static Object JavaDoc[][] PARAM_TYPES = null;
17         
18     public final static boolean[] SET_RELEVANTS = { true };
19         
20     public final static String JavaDoc SQL_STRING =
21         "SELECT TR.*, ST.STATUS, NST.STATUS AS NEW_STATUS "+
22         " FROM VERSION_STATUS_TRANSITION TR, VERSION_STATUS ST, VERSION_STATUS NST " +
23         "WHERE ST.STATUS_ID = TR.STATUS_ID AND NST.STATUS_ID = TR.NEW_STATUS_ID ";
24     
25     public void initQuery(Connection con) {
26         super.initQuery(
27             con,
28             IS_PREPARED,
29             PARAM_ORDER,
30             PARAM_TYPES,
31             SET_RELEVANTS,
32             SQL_STRING );
33     }
34 }
35
Popular Tags