01: /**
02: * Jedes Selectstatement erhaelt eine eigene Klasse
03: */package com.teamkonzept.field.db.queries;
04:
05: import com.teamkonzept.db.*;
06: import java.sql.*;
07:
08: public class TKDBContentGet extends TKPrepQuery {
09:
10: public final static boolean isPrepared = true;
11:
12: public final static String[] paramOrder = { "VERSION_ID" };
13:
14: public final static Object[][] paramTypes = null;
15:
16: public final static boolean[] setRelevants = { true };
17:
18: public final static String sqlString = "SELECT CV.*, CI.NAME FROM CONTENT_VERSION CV, CONTENT_INSTANCE CI, CONTENT C "
19: + "WHERE "
20: + " CV.VERSION_ID = ? AND "
21: + " C.CONTENT_ID = CV.CONTENT_ID AND "
22: + " CI.INSTANCE_ID = CV.INSTANCE_ID ";
23:
24: public void initQuery(Connection con) {
25: super.initQuery(con, isPrepared, paramOrder, paramTypes,
26: setRelevants, sqlString);
27: }
28: }
|