01: /*
02: * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/mainint/db/queries/sitetree/Attic/DrCloneOnSd.java,v 1.3 2001/10/19 13:54:19 markus Exp $
03: *
04: */
05: package com.teamkonzept.webman.mainint.db.queries.sitetree;
06:
07: import java.sql.*;
08:
09: import com.teamkonzept.db.*;
10:
11: /**
12: *
13: * @author
14: * @version
15: */
16: public class DrCloneOnSd extends TKPrepQuery {
17:
18: public final static boolean ISPREPARED = true;
19: public final static String[] PARAMORDER = { NEW_ID,
20: SITE_NODE_DOC_IDX, NODE_ID, NODE_DOC_IDX };
21:
22: public final static Object[][] PARAMTYPES = null;
23: public final static boolean[] SETRELEVANTS = null;
24:
25: public final static String SQLSTRING =
26:
27: /* clone DOCUMENT_REFERENCE */
28: " INSERT INTO DOCUMENT_REFERENCE "
29: + " ( "
30: + " SRC_SITE_NODE_ID, "
31: + " SRC_SITE_NODE_DOC_IDX, "
32: + " SRC_PRESENTATION_COMPONENT_IDX, "
33: + " REFERENCE_TYPE, "
34: + " DEST_SITE_NODE_ID, "
35: + " DEST_SITE_NODE_DOC_SHORTNAME, "
36: + " SELECTION_TYPE, "
37: + " SELECTION_DATA "
38: + " ) "
39: + " SELECT ? , ? ," /* ?NEW_ID *//* ?NEW_IDX */
40: + " SRC_PRESENTATION_COMPONENT_IDX, REFERENCE_TYPE, DEST_SITE_NODE_ID, "
41: + " DEST_SITE_NODE_DOC_SHORTNAME, SELECTION_TYPE, SELECTION_DATA "
42: + " FROM DOCUMENT_REFERENCE "
43: + " WHERE SRC_SITE_NODE_ID = ? " /* OLD_ID */
44: + " AND " + " SRC_SITE_NODE_DOC_IDX = ? " /* OLD_IDX */
45: ;
46:
47: public void initQuery(Connection con) {
48: super.initQuery(con, ISPREPARED, PARAMORDER, PARAMTYPES,
49: SETRELEVANTS, SQLSTRING);
50: }
51: }
|