|
1 package de.webman.content.db.queries;
2
3 import com.teamkonzept.db.*;
4 import java.sql.*;
5
6 public class GetContentNodeFromContentInstance extends TKPrepQuery {
7
8 public final static boolean IS_PREPARED =
9 true;
10
11 public final static String  [] PARAM_ORDER =
12 { "INSTANCE_ID" };
13
14 public final static Object [][] PARAM_TYPES =
15 null;
16
17 public final static boolean[] SET_RELEVANTS =
18 { true };
19
20 public final static String SQL_STRING =
21 "SELECT * FROM CONTENT_TREE CT , CONTENT_INSTANCE CI " +
22 "WHERE CI.INSTANCE_ID = ? AND CI.CONTENT_NODE_ID = CT.CONTENT_NODE_ID ";
23
24 public void initQuery(Connection con) {
25 super.initQuery(
26 con,
27 IS_PREPARED,
28 PARAM_ORDER,
29 PARAM_TYPES,
30 SET_RELEVANTS,
31 SQL_STRING );
32 }
33 }
34 |
Popular Tags |
Java API By Example, From Geeks To Geeks.