01: package com.teamkonzept.webman.mainint.db.queries.content;
02:
03: import java.sql.Connection;
04: import com.teamkonzept.db.*;
05:
06: public class SelectContentVersionContentInstance extends TKPrepQuery {
07:
08: public final static boolean PREPARED = true;
09:
10: public final static String[] ORDER = { "VERSION_ID", "INSTANCE_ID" };
11:
12: public final static Object[][] TYPES = null;
13:
14: public final static boolean[] RELEVANTS = { true };
15:
16: public final static String SQLSTRING = (new StringBuffer(
17: "SELECT CV.*, CI.NAME FROM CONTENT_VERSION CV, CONTENT_INSTANCE CI ")
18: .append("WHERE CV.VERSION_ID = ? AND CI.INSTANCE_ID = ?"))
19: .toString();
20:
21: public void initQuery(Connection con) {
22: super.initQuery(con, PREPARED, ORDER, TYPES, RELEVANTS,
23: SQLSTRING);
24: }
25:
26: }
|