KickJava   Java API By Example, From Geeks To Geeks.

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


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/Attic/TKDBSiteDocGet.java,v 1.5 2000/05/22 15:01:49 careck Exp $
3  *
4  */
5 package com.teamkonzept.webman.mainint.db.queries;
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     public final static boolean isPrepared =
20         true;
21     
22     public final static String JavaDoc[] paramOrder =
23         {"SITE_NODE_ID"};
24     
25     public final static Object JavaDoc[][] paramTypes =
26         null;
27         
28     public final static boolean[] setRelevants =
29         { true };
30
31     public final static String JavaDoc sqlString =
32         "SELECT " +
33         " SD.*, " +
34         " P.PRESENTATION_NAME " +
35         "FROM " +
36         " SITE_DOCUMENT SD, PRESENTATION P " +
37         "WHERE " +
38         " SITE_NODE_ID = ? " +
39         "AND " +
40         " P.PRESENTATION_ID = SD.PRESENTATION_ID " +
41         "ORDER BY " +
42         " SITE_NODE_DOC_IDX ";
43     
44     public void initQuery(Connection con) {
45         super.initQuery(
46             con,
47             isPrepared,
48             paramOrder,
49             paramTypes,
50             setRelevants,
51             sqlString );
52     }
53 }
54
55
Popular Tags