1 package com.teamkonzept.webman.mainint.db.queries.presentation; 2 3 import java.sql.Connection ; 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 [] ORDER = { "PRESENTATION_COMPONENT_IDX", "PRESENTATION_ID", "PRESENTATION_ID" }; 12 13 public final static Object [][] TYPES = null; 14 15 public final static boolean[] RELEVANTS = { true }; 16 17 public final static String SQL_STRING = (new StringBuffer ("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 con) { 27 super.initQuery( 28 con, 29 PREPARED, 30 ORDER, 31 TYPES, 32 RELEVANTS, 33 SQL_STRING ); 34 } 35 36 } 37 | Popular Tags |