KickJava   Java API By Example, From Geeks To Geeks.

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


1 package de.webman.content.workflow.db.queries;
2
3 import com.teamkonzept.db.*;
4 import java.sql.*;
5 /**
6     * @author $Author: doehling $
7     * @version $Revision: 1.2 $
8 */

9 public class VersionStatusFiltersGetAll extends TKPrepQuery {
10
11     public final static boolean IS_PREPARED = true;
12     
13     public final static String JavaDoc[] PARAM_ORDER = null;
14     
15     public final static Object JavaDoc[][] PARAM_TYPES = null;
16         
17     public final static boolean[] SET_RELEVANTS = { true };
18         
19     public final static String JavaDoc SQL_STRING =
20         "SELECT FR.STATUS_ID, FR.RULE_TYPE, SF.* FROM VERSION_STATUS_FILTER_RULE FR, VERSION_STATUS_FILTER SF " +
21         "WHERE " + DBStringFactory.rightOuterJoin("FR.FILTER_ID", "SF.FILTER_ID") +
22         " ORDER BY FR.FILTER_ID";
23     
24     public void initQuery(Connection con) {
25         super.initQuery(
26             con,
27             IS_PREPARED,
28             PARAM_ORDER,
29             PARAM_TYPES,
30             SET_RELEVANTS,
31             SQL_STRING );
32     }
33 }
34
Popular Tags