KickJava   Java API By Example, From Geeks To Geeks.

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


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 DeleteFromDocumentContent extends TKPrepQuery
7 {
8
9     public final static boolean PREPARED = true;
10
11     public final static String JavaDoc[] ORDER = { "PRESENTATION_COMPONENT_IDX", "PRESENTATION_ID", "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 SQL_STRING = (new StringBuffer JavaDoc("DELETE FROM DOCUMENT_CONTENT ")
18                                          .append("WHERE ")
19                                          .append("PRESENTATION_COMPONENT_IDX = ? AND ")
20                      .append(" SITE_NODE_ID IN ")
21                      .append(" ( SELECT S.SITE_NODE_ID FROM SITE_DOCUMENT S, DOCUMENT_CONTENT D WHERE PRESENTATION_ID = ? AND S.SITE_NODE_ID = D.SITE_NODE_ID AND S.SITE_NODE_DOC_IDX = D.SITE_NODE_DOC_IDX) ")
22                      .append("AND ")
23                      .append(" SITE_NODE_DOC_IDX IN ")
24                      .append(" ( SELECT S.SITE_NODE_DOC_IDX FROM SITE_DOCUMENT S, DOCUMENT_CONTENT D WHERE PRESENTATION_ID = ? AND S.SITE_NODE_ID = D.SITE_NODE_ID AND S.SITE_NODE_DOC_IDX = D.SITE_NODE_DOC_IDX) ")).toString();
25
26     public void initQuery(Connection JavaDoc con) {
27         super.initQuery(
28             con,
29             PREPARED,
30             ORDER,
31             TYPES,
32             RELEVANTS,
33             SQL_STRING );
34     }
35
36 }
37
Popular Tags