KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > teamkonzept > webman > mainint > db > queries > sitetree > DrCloneOnSd


1 /*
2  * $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 $
3  *
4  */
5 package com.teamkonzept.webman.mainint.db.queries.sitetree;
6
7 import java.sql.*;
8
9 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 JavaDoc[] PARAMORDER =
20         {
21             NEW_ID,
22             SITE_NODE_DOC_IDX,
23             NODE_ID,
24             NODE_DOC_IDX
25         };
26     
27     public final static Object JavaDoc[][] PARAMTYPES = null;
28     public final static boolean[] SETRELEVANTS = null;
29         
30     public final static String JavaDoc SQLSTRING =
31         
32 /* clone DOCUMENT_REFERENCE */
33   " INSERT INTO DOCUMENT_REFERENCE "
34  + " ( "
35  + " SRC_SITE_NODE_ID, "
36  + " SRC_SITE_NODE_DOC_IDX, "
37  + " SRC_PRESENTATION_COMPONENT_IDX, "
38  + " REFERENCE_TYPE, "
39  + " DEST_SITE_NODE_ID, "
40  + " DEST_SITE_NODE_DOC_SHORTNAME, "
41  + " SELECTION_TYPE, "
42  + " SELECTION_DATA "
43  + " ) "
44  + " SELECT ? , ? ," /* ?NEW_ID *//* ?NEW_IDX */
45  + " SRC_PRESENTATION_COMPONENT_IDX, REFERENCE_TYPE, DEST_SITE_NODE_ID, "
46  + " DEST_SITE_NODE_DOC_SHORTNAME, SELECTION_TYPE, SELECTION_DATA "
47  + " FROM DOCUMENT_REFERENCE "
48  + " WHERE SRC_SITE_NODE_ID = ? " /* OLD_ID */
49  + " AND "
50  + " SRC_SITE_NODE_DOC_IDX = ? " /* OLD_IDX */
51 ;
52         
53     public void initQuery(Connection con) {
54         super.initQuery(
55             con,
56             ISPREPARED,
57             PARAMORDER,
58             PARAMTYPES,
59             SETRELEVANTS,
60             SQLSTRING );
61     }
62 }
63
Popular Tags