KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > teamkonzept > webman > mainint > db > queries > content > ContentTreeID


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/content/ContentTreeID.java,v 1.1 2001/01/31 16:23:13 marwan Exp $
3  *
4  */
5 package com.teamkonzept.webman.mainint.db.queries.content;
6
7 import java.sql.*;
8
9 import com.teamkonzept.db.*;
10
11
12 public class ContentTreeID extends TKPrepQuery{
13
14     public final static boolean isPrepared =true;
15     
16     public final static String JavaDoc[] paramOrder =
17     {CONTENT_ID};
18         
19     public final static Object JavaDoc[][] paramTypes = null;
20         
21     public final static boolean[] setRelevants = {true};
22         
23         
24     public final static String JavaDoc sqlString =
25         
26         " SELECT DISTINCT C_I.CONTENT_NODE_ID "+
27         " FROM CONTENT_INSTANCE C_I, CONTENT_VERSION C_V "+
28         " WHERE C_I.INSTANCE_ID = C_V.INSTANCE_ID "+
29         " AND "+
30         " C_V.CONTENT_ID = ? "
31       ;
32         
33         
34
35     public void initQuery(Connection con) {
36         super.initQuery(
37             con,
38             isPrepared,
39             paramOrder,
40             paramTypes,
41             setRelevants,
42             sqlString );
43     }
44 }
45
Popular Tags