KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > teamkonzept > webman > refsel > TKWMAuntsRS


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/refsel/TKWMAuntsRS.java,v 1.5 2000/05/22 15:01:51 careck Exp $
3  *
4  */
5 package com.teamkonzept.webman.refsel;
6
7 import java.sql.*;
8
9 import com.teamkonzept.db.*;
10 import com.teamkonzept.lib.*;
11 import com.teamkonzept.webman.refsel.db.queries.*;
12
13 public class TKWMAuntsRS extends TKWMAllNodesSelector {
14
15     public boolean checkSelection( ) {
16         return false;
17     }
18
19     public String JavaDoc getSelectionData( TKHashtable params ){
20         return "";
21     }
22
23     public TKVector getSelectionNodes(String JavaDoc selectionData, int siteNodeId )
24         throws SQLException
25     {
26         TKVector nodes= new TKVector();
27         int motherNodeId;
28         TKQuery query;
29         ResultSet rs;
30
31         // Hole den Mutterknoten
32 query = TKDBManager.newQuery(TKWMDBMotherNode.class);
33         query.setQueryParams("SITE_NODE_ID", new Integer JavaDoc(siteNodeId));
34         query.execute();
35         rs = query.fetchResultSet();
36
37         if (rs != null) {
38             if (rs.next()) {
39                 motherNodeId = rs.getInt("SITE_NODE_PARENT");
40             } else {
41                 return nodes;
42             }
43         } else {
44             return nodes;
45         }
46
47         // Mit dem Mutterknoten hole die SisterKnoten
48 query = TKDBManager.newQuery(TKWMDBSisterNodes.class);
49         query.setQueryParams("SITE_NODE_ID", new Integer JavaDoc(motherNodeId));
50         query.execute();
51         rs = query.fetchResultSet();
52
53         if (rs != null) {
54             while (rs.next()) {
55                 nodes.addElement(new Integer JavaDoc(rs.getInt("SITE_NODE_ID")));
56             }
57         }
58         return nodes;
59     }
60
61     public TKDBResult getSelectionValues( String JavaDoc selectionData, int siteNodeId )
62         throws SQLException
63     {
64         TKDBResult values=null;
65         int motherNodeId;
66         TKQuery query;
67         ResultSet rs;
68
69         // Hole den Mutterknoten
70 query = TKDBManager.newQuery(TKWMDBMotherNode.class);
71         query.setQueryParams("SITE_NODE_ID", new Integer JavaDoc(siteNodeId));
72         query.execute();
73         rs = query.fetchResultSet();
74
75         if (rs != null) {
76             if (rs.next()) {
77                 motherNodeId = rs.getInt("SITE_NODE_PARENT");
78             } else {
79                 return values;
80             }
81         } else {
82             return values;
83         }
84
85         query = TKDBManager.newQuery(TKWMDBRSSisters.class);
86         query.setQueryParams("SITE_NODE_ID", new Integer JavaDoc(motherNodeId));
87         query.execute();
88         rs = query.fetchResultSet();
89
90         if (rs != null) {
91             values = new TKDBResult(rs);
92         }
93         return values;
94
95     }
96
97 }
98
99
Popular Tags