KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > teamkonzept > webman > mainint > db > queries > presentation > UpdateDocumentContent


1 package com.teamkonzept.webman.mainint.db.queries.presentation;
2
3 import java.sql.Connection JavaDoc;
4 import com.teamkonzept.db.*;
5
6 public class UpdateDocumentContent extends TKPrepQuery
7 {
8
9     public final static boolean PREPARED = true;
10
11     public final static String JavaDoc[] ORDER = { "PRESENTATION_COMPONENT_IDX", "PRESENTATION_ID" };
12
13     public final static Object JavaDoc[][] TYPES = null;
14
15     public final static boolean[] RELEVANTS = { true };
16
17     public final static String JavaDoc SQLSTRING = (new StringBuffer JavaDoc("UPDATE DOCUMENT_CONTENT ")
18                                          .append("SET PRESENTATION_COMPONENT_IDX =PRESENTATION_COMPONENT_IDX - 1 ")
19                                          .append("WHERE ")
20                                          .append("PRESENTATION_COMPONENT_IDX > ? AND SITE_NODE_ID IN ")
21                                          .append("(SELECT SITE_NODE_ID FROM SITE_DOCUMENT WHERE PRESENTATION_ID = ?)")).toString();
22 // .append("PRESENTATION_COMPONENT_IDX > ? AND PRESENTATION_ID = ?")).toString();
23
24     public void initQuery(Connection JavaDoc con) {
25         super.initQuery(
26             con,
27             PREPARED,
28             ORDER,
29             TYPES,
30             RELEVANTS,
31             SQLSTRING );
32     }
33
34 }
35
Popular Tags