01: package de.webman.content.db.queries;
02:
03: import java.sql.Connection;
04: import com.teamkonzept.db.*;
05:
06: /**
07: * <pre>
08: * SELECT CV.CONTENT_ID, CA.*, A.NAME, A.TYPE, A.CLASSNAME
09: * FROM CONTENT_ATTRIBUTE_VALUE CV, CONTENT_ATTRIBUTE CA, ATTRIBUTE A
10: * WHERE CV.CONTENT_ID = {"CONTENT_ID"} AND
11: CV.VALUE_ID = {"VALUE_ID"} AND
12: * CA.VALUE_ID = {"VALUE_ID"} AND
13: A.ATTRIBUTE_ID = CA.ATTRIBUTE_ID
14: * </pre>
15: * @author markus
16: * @version 1.0
17: */
18: public class SelectAttributeContentAttribute extends TKPrepQuery {
19: public final static boolean PREPARED = true;
20: public final static String[] ORDER = { "CONTENT_ID", "VALUE_ID",
21: "VALUE_ID" };
22: public final static Object[][] TYPES = null;
23: public final static boolean[] RELEVANTS = { true };
24:
25: public final static String SQLSTRING = (new StringBuffer(
26: "SELECT CV.CONTENT_ID, CA.*, A.NAME, A.TYPE, A.CLASSNAME ")
27: .append(
28: "FROM CONTENT_ATTRIBUTE_VALUE CV, CONTENT_ATTRIBUTE CA, ATTRIBUTE A ")
29: .append(
30: "WHERE CV.CONTENT_ID = ? AND CV.VALUE_ID = ? AND CA.VALUE_ID = ? ")
31: .append("AND A.ATTRIBUTE_ID = CA.ATTRIBUTE_ID")).toString();
32:
33: public void initQuery(Connection con) {
34: super.initQuery(con, PREPARED, ORDER, TYPES, RELEVANTS,
35: SQLSTRING);
36: }
37:
38: }
|