KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > de > webman > content > db > queries > SelectAttributeContentAttribute


1 package de.webman.content.db.queries;
2
3 import java.sql.Connection JavaDoc;
4 import com.teamkonzept.db.*;
5
6 /**
7  * <pre>
8  * SELECT CV.CONTENT_ID, CA.*, A.NAME, A.TYPE, A.CLASSNAME
9  * 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 {
20     public final static boolean PREPARED = true;
21     public final static String JavaDoc[] ORDER = { "CONTENT_ID", "VALUE_ID", "VALUE_ID" };
22     public final static Object JavaDoc[][] TYPES = null;
23     public final static boolean[] RELEVANTS = { true };
24
25     public final static String JavaDoc SQLSTRING = (new StringBuffer JavaDoc("SELECT CV.CONTENT_ID, CA.*, A.NAME, A.TYPE, A.CLASSNAME ")
26                         .append("FROM CONTENT_ATTRIBUTE_VALUE CV, CONTENT_ATTRIBUTE CA, ATTRIBUTE A ")
27                         .append("WHERE CV.CONTENT_ID = ? AND CV.VALUE_ID = ? AND CA.VALUE_ID = ? ")
28                         .append("AND A.ATTRIBUTE_ID = CA.ATTRIBUTE_ID")).toString();
29
30     public void initQuery(Connection JavaDoc con) {
31     super.initQuery(
32             con,
33             PREPARED,
34             ORDER,
35             TYPES,
36             RELEVANTS,
37             SQLSTRING );
38     }
39
40 }
41
Popular Tags