|
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
56 public class XMLContentRetrieve
57 extends TKPrepQuery
58 {
59
61
63
66 private final static boolean IS_PREPARED = true;
67
68
71 private final static String [] PARAMETER_ORDER =
72 {
73 ContentConstants.CONTENT_ID
74 };
75
76
79 private final static Object [][] PARAMETER_TYPES =
80 {
81 {ContentConstants.CONTENT_ID, new Integer (Types.INTEGER)}
82 };
83
84
87 private final static boolean[] SET_RELEVANTS =
88 {
89 true
90 };
91
92
95
97 private final static String SQL_STRING = (new StringBuffer ()).append("SELECT CONTENT.XML_TEXT, CONTENT_TREE.CONTENT_FORM, CONTENT_TREE.CONTENT_NODE_SHORTNAME, CONTENT_TREE.CONTENT_NODE_NAME ")
98 .append("FROM CONTENT, CONTENT_VERSION, CONTENT_INSTANCE, CONTENT_TREE ")
99 .append("WHERE CONTENT.CONTENT_ID = ? ")
100 .append("AND CONTENT.CONTENT_ID = CONTENT_VERSION.CONTENT_ID ")
101 .append("AND CONTENT_VERSION.INSTANCE_ID = CONTENT_INSTANCE.INSTANCE_ID ")
102 .append("AND CONTENT_INSTANCE.CONTENT_NODE_ID = CONTENT_TREE.CONTENT_NODE_ID")
103 .toString();
104
105
106
108
113 public void initQuery (Connection connection)
114 {
115 super.initQuery(connection,
116 IS_PREPARED,
117 PARAMETER_ORDER,
118 PARAMETER_TYPES,
119 SET_RELEVANTS,
120 SQL_STRING);
121 }
122
123 }
124 |
Popular Tags |
Java API By Example, From Geeks To Geeks.