KickJava   Java API By Example, From Geeks To Geeks.

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


1 package com.teamkonzept.webman.mainint.db.queries.content;
2
3 import java.sql.Connection JavaDoc;
4 import com.teamkonzept.db.*;
5
6 public class SelectContentVersionContentInstance extends TKPrepQuery
7 {
8
9     public final static boolean PREPARED = true;
10
11     public final static String JavaDoc[] ORDER = { "VERSION_ID", "INSTANCE_ID" };
12
13     public final static Object JavaDoc[][] TYPES = null;
14
15     public final static boolean[] RELEVANTS = { true };
16
17     public final static String JavaDoc SQLSTRING = (new StringBuffer JavaDoc("SELECT CV.*, CI.NAME FROM CONTENT_VERSION CV, CONTENT_INSTANCE CI ")
18                                          .append("WHERE CV.VERSION_ID = ? AND CI.INSTANCE_ID = ?")).toString();
19
20     public void initQuery(Connection JavaDoc con) {
21         super.initQuery(
22             con,
23             PREPARED,
24             ORDER,
25             TYPES,
26             RELEVANTS,
27             SQLSTRING );
28     }
29
30 }
31
Popular Tags