KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > teamkonzept > field > db > queries > TKDBContentGet


1 /**
2  * Jedes Selectstatement erhaelt eine eigene Klasse
3  */
4 package com.teamkonzept.field.db.queries;
5
6 import com.teamkonzept.db.*;
7 import java.sql.*;
8
9 public class TKDBContentGet extends TKPrepQuery {
10
11     public final static boolean isPrepared =
12         true;
13     
14     public final static String JavaDoc[] paramOrder =
15         { "VERSION_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.*, CI.NAME FROM CONTENT_VERSION CV, CONTENT_INSTANCE CI, CONTENT C " +
25         "WHERE " +
26         " CV.VERSION_ID = ? AND " +
27         " C.CONTENT_ID = CV.CONTENT_ID AND " +
28         " CI.INSTANCE_ID = CV.INSTANCE_ID ";
29         
30     public void initQuery(Connection con) {
31         super.initQuery(
32             con,
33             isPrepared,
34             paramOrder,
35             paramTypes,
36             setRelevants,
37             sqlString );
38     }
39 }
40
Popular Tags