KickJava   Java API By Example, From Geeks To Geeks.

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


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 TKDBContentValueGet 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 " +
25         " CONTENT_ID, CONTENT_NODE_ID, IDX, VALUE, MEDIA_ID " +
26         "FROM " +
27         " CONTENT_VALUE " +
28         "WHERE " +
29         " CONTENT_ID = ? " +
30         "ORDER BY " +
31         " CONTENT_NODE_ID, IDX";
32
33     public void initQuery(Connection con) {
34         super.initQuery(
35             con,
36             isPrepared,
37             paramOrder,
38             paramTypes,
39             setRelevants,
40             sqlString );
41     }
42 }
43
Popular Tags