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 TKDBContentValueGet extends TKPrepQuery {
09:
10: public final static boolean isPrepared = true;
11:
12: public final static String[] paramOrder = { "CONTENT_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 "
19: + " CONTENT_ID, CONTENT_NODE_ID, IDX, VALUE, MEDIA_ID "
20: + "FROM " + " CONTENT_VALUE " + "WHERE "
21: + " CONTENT_ID = ? " + "ORDER BY "
22: + " CONTENT_NODE_ID, IDX";
23:
24: public void initQuery(Connection con) {
25: super.initQuery(con, isPrepared, paramOrder, paramTypes,
26: setRelevants, sqlString);
27: }
28: }
|