KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > teamkonzept > webman > mainint > db > queries > oracle > TKDBSiteTreeInsertNode


1 package com.teamkonzept.webman.mainint.db.queries.oracle;
2
3 import java.sql.*;
4
5 import com.teamkonzept.db.*;
6 import com.teamkonzept.lib.*;
7 import com.teamkonzept.webman.mainint.db.queries.sitetree.*;
8
9 /**
10     required parameters:
11         NODE_ID
12         SITE_NODE_TYPE
13         SITE_NODE_NAME
14         SITE_NODE_SHORTNAME
15         PG_CONTENT_NODE
16         
17     optional parameters:
18         SELECTION_TYPE
19         SELECTION_DATA
20         
21         
22         
23         
24      TKDBSiteTreeInsertNode
25      Fuegt einen neuen Knoten ueber/unterhalb eines Nodes ein
26      Input: NODE_ID (Knoten des Parents ) und die neuen Werte
27      "SITE_NODE_TYPE, SITE_NODE_NAME, SITE_NODE_SHORTNAME "
28      Output: kompletter Datensatz (des neue erzeugtes DS)
29             
30             
31 */
32
33 public class TKDBSiteTreeInsertNode extends CompositeQuery
34 {
35
36
37     // conditional execution
38 TKQuery contSelNextID;
39     TKQuery contSelInsert;
40
41     protected void initConcreteCompositeQuery() throws SQLException
42     {
43     TKQuery getLR;
44     TKQuery shiftLeftNrs;
45     TKQuery shiftRightNrs;
46     TKQuery selectNextID;
47     TKQuery insertSiteNode;
48     TKQuery stSelect;
49
50       getLR = registerQuery(StGetLeftRight.class);
51       contSelNextID = registerQuery(ContSelNextID.class);
52       contSelInsert = registerQuery(ContSelInsert.class);
53       shiftLeftNrs = registerQuery(StShiftLeftNrs.class);
54       shiftRightNrs = registerQuery(StShiftRightNrs.class);
55       selectNextID = registerQuery(StNextID.class);
56       insertSiteNode = registerQuery(StInsert.class);
57       stSelect = registerQuery(StSelect.class);
58
59
60       setRequiredParam(contSelNextID, SELECTION_TYPE);
61       setRequiredParam(contSelInsert, SELECTION_TYPE);
62
63       setDefaultParameterPropagation();
64
65
66
67     }
68 }
69
Popular Tags