KickJava   Java API By Example, From Geeks To Geeks.

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


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

10 public class VersionStatusFiltersGetAll 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     /**
19      * Returns this query results?
20      */

21     public final static boolean[] SET_RELEVANTS = { true };
22         
23     /**
24      * Query to execute
25      */

26     public final static String JavaDoc SQL_STRING =
27         "SELECT FR.STATUS_ID, FR.RULE_TYPE, SF.* FROM VERSION_STATUS_FILTER_RULE FR RIGHT JOIN VERSION_STATUS_FILTER SF " +
28         "ON (FR.FILTER_ID = SF.FILTER_ID) " +
29         " ORDER BY FR.FILTER_ID";
30     
31     public void initQuery(Connection con) {
32         super.initQuery(
33             con,
34             IS_PREPARED,
35             PARAM_ORDER,
36             PARAM_TYPES,
37             SET_RELEVANTS,
38             SQL_STRING );
39     }
40 }
41
Popular Tags