KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > teamkonzept > webman > db > queries > TKDBContentDir


1 /**
2  * Jedes Selectstatement erhaelt eine eigene Klasse
3  */
4 package com.teamkonzept.webman.db.queries;
5
6 import com.teamkonzept.db.*;
7 import java.sql.*;
8
9 public class TKDBContentDir extends TKPrepQuery {
10
11     public final static boolean isPrepared =
12         true;
13     
14     public final static String JavaDoc[] paramOrder =
15         { };
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         "FROM CONTENT_TREE CT, CONTENT_INSTANCE CI " +
26         "WHERE CI.CONTENT_NODE_ID = CT.CONTENT_NODE_ID " +
27         "ORDER BY CT.LEFT_NR";
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