KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > teamkonzept > webman > mainint > db > queries > oracle > TKDBSiteDocGet


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/oracle/Attic/TKDBSiteDocGet.java,v 1.4 2001/09/04 09:01:35 ralf Exp $
3  *
4  */
5 package com.teamkonzept.webman.mainint.db.queries.oracle;
6
7 import java.sql.*;
8
9 import com.teamkonzept.db.*;
10
11 /*
12  * TKDBSiteDocGet
13  * input SITE_NODE_ID
14  * ouput alle DS zur NODE_ID und PRESENTATION_NAME
15  * ORDER by SITE_NODE_DOC_IDX
16  */
17 public class TKDBSiteDocGet extends TKPrepQuery
18 {
19
20     public final static boolean IS_PREPARED = true;
21
22     public final static String JavaDoc[] PARAM_ORDER = { "SITE_NODE_ID" };
23
24     public final static Object JavaDoc[][] PARAM_TYPES = null;
25
26     public final static boolean[] SET_RELEVANTS = { true };
27
28     public final static String JavaDoc SQL_STRING =
29     "SELECT " +
30     " SD.*, " +
31     " P.PRESENTATION_NAME " +
32     "FROM " +
33     " SITE_DOCUMENT SD, PRESENTATION P " +
34     "WHERE " +
35     " SITE_NODE_ID = ? " +
36     "AND " +
37     " P.PRESENTATION_ID = SD.PRESENTATION_ID " +
38     "ORDER BY " + " SITE_NODE_DOC_IDX ";
39
40     public void initQuery(Connection con)
41     {
42     super.initQuery(con,
43             IS_PREPARED,
44             PARAM_ORDER, PARAM_TYPES, SET_RELEVANTS, SQL_STRING);
45     }
46 }
47
Popular Tags