1 5 package com.teamkonzept.webman.mainint.db.queries.sybase; 6 7 import java.sql.*; 8 9 import com.teamkonzept.db.*; 10 11 16 public class TKDBSiteDocDelete extends TKPrepQuery{ 17 18 public final static boolean isPrepared = 19 true; 20 21 public final static String [] paramOrder = 22 {"SITE_NODE_ID", "SITE_NODE_DOC_IDX" }; 23 24 public final static Object [][] paramTypes = 25 null; 26 27 public final static boolean[] setRelevants = 28 { false }; 29 30 public final static String sqlString = 31 "DECLARE @ID int " + 32 "DECLARE @IDX int " + 33 34 "SELECT @ID = ? " + 35 "SELECT @IDX = ? " + 36 37 "CREATE TABLE #temp (SELECTION_ID int) " + 38 39 "BEGIN TRANSACTION " + 40 41 "DELETE FROM " + 42 " DOCUMENT_REFERENCE " + 43 "WHERE " + 44 " SRC_SITE_NODE_ID = @ID " + 45 "AND " + 46 " SRC_SITE_NODE_DOC_IDX = @IDX " + 47 48 "INSERT INTO " + 49 " #temp " + 50 " (SELECTION_ID) " + 51 "SELECT " + 52 " SELECTION_ID " + 53 "FROM " + 54 " DOCUMENT_CONTENT " + 55 "WHERE " + 56 " SITE_NODE_ID = @ID " + 57 "AND " + 58 " SITE_NODE_DOC_IDX = @IDX " + 59 "AND " + 60 " SELECTION_ID IS NOT NULL " + 61 62 "DELETE FROM " + 63 " DOCUMENT_CONTENT " + 64 "WHERE " + 65 " SITE_NODE_ID = @ID " + 66 "AND " + 67 " SITE_NODE_DOC_IDX = @IDX " + 68 69 "DELETE FROM " + 70 " CONTENT_SELECTION " + 71 "WHERE " + 72 " SELECTION_ID IN ( " + 73 "SELECT " + 74 " SELECTION_ID " + 75 "FROM " + 76 " #temp " + 77 ") " + 78 79 "DELETE FROM " + 80 " SITE_DOCUMENT " + 81 "WHERE " + 82 " SITE_NODE_ID = @ID " + 83 "AND " + 84 " SITE_NODE_DOC_IDX = @IDX " + 85 86 "COMMIT TRANSACTION " + 87 88 "DROP TABLE #temp "; 89 90 public void initQuery(Connection con) { 91 super.initQuery( 92 con, 93 isPrepared, 94 paramOrder, 95 paramTypes, 96 setRelevants, 97 sqlString ); 98 } 99 } 100 101 | Popular Tags |