|
1 package de.webman.content.db.queries;
2
3 import java.sql.Connection  ;
4 import java.sql.Types ;
5 import com.teamkonzept.db.TKPrepQuery;
6 import de.webman.content.db.ContentConstants;
7 import de.webman.content.db.ContentInstanceConstants;
8 import de.webman.content.db.ContentTreeConstants;
9 import de.webman.content.db.ContentVersionConstants;
10
11
51 public class XMLContentDescribe
52 extends TKPrepQuery
53 {
54
56
58
61 private final static boolean IS_PREPARED = true;
62
63
66 private final static String [] PARAMETER_ORDER =
67 {
68 ContentConstants.CONTENT_ID
69 };
70
71
74 private final static Object [][] PARAMETER_TYPES =
75 {
76 {ContentConstants.CONTENT_ID, new Integer (Types.INTEGER)}
77 };
78
79
82 private final static boolean[] SET_RELEVANTS =
83 {
84 true
85 };
86
87
90 private final static String SQL_STRING = (new StringBuffer ()).append("SELECT CONTENT_TREE.CONTENT_FORM, CONTENT_TREE.CONTENT_NODE_SHORTNAME, CONTENT_TREE.CONTENT_NODE_NAME ")
91 .append("FROM CONTENT, CONTENT_VERSION, CONTENT_INSTANCE, CONTENT_TREE ")
92 .append("WHERE CONTENT.CONTENT_ID = ? ")
93 .append("AND CONTENT.CONTENT_ID = CONTENT_VERSION.CONTENT_ID ")
94 .append("AND CONTENT_VERSION.INSTANCE_ID = CONTENT_INSTANCE.INSTANCE_ID ")
95 .append("AND CONTENT_INSTANCE.CONTENT_NODE_ID = CONTENT_TREE.CONTENT_NODE_ID")
96 .toString();
97
98
99
101
106 public void initQuery (Connection connection)
107 {
108 super.initQuery(connection,
109 IS_PREPARED,
110 PARAMETER_ORDER,
111 PARAMETER_TYPES,
112 SET_RELEVANTS,
113 SQL_STRING);
114 }
115
116 }
117 |
Popular Tags |
Java API By Example, From Geeks To Geeks.