KickJava   Java API By Example, From Geeks To Geeks.

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


1 /**
2  * Jedes Selectstatement erhaelt eine eigene Klasse
3  */
4 package de.webman.content.db.queries;
5
6 import com.teamkonzept.db.*;
7 import java.sql.*;
8
9 public class TKDBContentAttributeGet extends TKPrepQuery {
10
11     public final static boolean ISPREPARED =
12         true;
13     
14     public final static String JavaDoc[] PARAMORDER =
15         { "CONTENT_ID" };
16     
17     public final static Object JavaDoc[][] PARAMTYPES =
18         null;
19         
20     public final static boolean[] SETRELEVANTS =
21         { true };
22         
23     public final static String JavaDoc SQLSTRING =
24         "SELECT CV.CONTENT_ID, CA.*, A.NAME, A.TYPE, A.CLASSNAME " +
25         " FROM CONTENT_ATTRIBUTE_VALUE CV, CONTENT_ATTRIBUTE CA, ATTRIBUTE A " +
26         "WHERE CV.CONTENT_ID = ? AND CA.VALUE_ID = CV.VALUE_ID AND " +
27         " A.ATTRIBUTE_ID = CA.ATTRIBUTE_ID ";
28     
29     public void initQuery(Connection con) {
30         super.initQuery(
31             con,
32             ISPREPARED,
33             PARAMORDER,
34             PARAMTYPES,
35             SETRELEVANTS,
36             SQLSTRING );
37     }
38 }
39
Popular Tags