KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > teamkonzept > webman > mainint > db > queries > field > SelectFromContentVersion


1 package com.teamkonzept.webman.mainint.db.queries.field;
2
3 import java.sql.Connection JavaDoc;
4 import com.teamkonzept.db.*;
5
6 public class SelectFromContentVersion extends TKPrepQuery
7 {
8
9     public final static boolean prepared = true;
10
11     public final static String JavaDoc[] order =
12   {
13     "VERS_ID",
14     "INST_ID"
15   };
16
17     public final static Object JavaDoc[][] types = null;
18
19     public final static boolean[] relevants = { true };
20
21     public final static String JavaDoc sqlString = "SELECT CV.*, CI.NAME FROM CONTENT_VERSION CV, CONTENT_INSTANCE CI WHERE CV.VERSION_ID = ? AND CI.INSTANCE_ID = ?";
22
23     public void initQuery(Connection JavaDoc con) {
24         super.initQuery(
25             con,
26             prepared,
27             order,
28             types,
29             relevants,
30             sqlString );
31     }
32
33 }
Popular Tags