KickJava   Java API By Example, From Geeks To Geeks.

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


1 package com.teamkonzept.webman.mainint.db.queries;
2
3 import com.teamkonzept.db.*;
4 import java.sql.*;
5
6 /*
7  * TKDBGetAllInstanceVersions
8  * Holt alle versionen aller aktuellen Contents eines Content-Tree-Knotens
9  *
10  * Input: CONTENT_NODE_ID
11  * Output: CONTENT_ID, CONTENT_NAME, CONTENT_SHORTNAME
12  */

13 public class TKDBGetAllInstanceVersions extends TKPrepQuery {
14
15     public final static boolean isPrepared =
16         true;
17     
18     public final static String JavaDoc[] paramOrder =
19         { "INSTANCE_ID" };
20     
21     public final static Object JavaDoc[][] paramTypes =
22         null;
23                 
24     public final static boolean[] setRelevants =
25         { true };
26         
27     public final static String JavaDoc sqlString =
28         "SELECT CV.VERSION_ID, CV.STATUS_ID, CV.CONTENT_ID " +
29         "FROM CONTENT_VERSION CV " +
30         "WHERE CV.INSTANCE_ID = ? " +
31         "ORDER BY CV.CONTENT_ID, CV.VERSION_ID ";
32
33     public void initQuery(Connection con) {
34         super.initQuery(
35             con,
36             isPrepared,
37             paramOrder,
38             paramTypes,
39             setRelevants,
40             sqlString );
41     }
42 }
43
Popular Tags