01: /*
02: * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/refsel/TKWMGranddaughtersRS.java,v 1.2 2001/08/06 14:34:37 alex Exp $
03: *
04: */
05: package com.teamkonzept.webman.refsel;
06:
07: import java.sql.*;
08: import java.util.*;
09:
10: import com.teamkonzept.db.*;
11: import com.teamkonzept.webman.*;
12: import de.webman.generator.*;
13: import com.teamkonzept.lib.*;
14: import com.teamkonzept.webman.refsel.db.queries.*;
15:
16: public class TKWMGranddaughtersRS extends TKWMAllNodesSelector {
17: public boolean checkSelection() {
18: return false;
19: }
20:
21: public String getSelectionData(TKHashtable params) {
22: return "";
23: }
24:
25: public TKVector getSelectionNodes(String selectionData,
26: int siteNodeId) throws SQLException {
27: TKVector nodes = new TKVector();
28:
29: TKQuery query = TKDBManager
30: .newQuery(TKWMDBGranddaughterNodes.class);
31: query.setQueryParams("SITE_NODE_ID", new Integer(siteNodeId));
32: query.execute();
33: ResultSet rs = query.fetchResultSet();
34:
35: if (rs != null) {
36: while (rs.next()) {
37: nodes
38: .addElement(new Integer(rs
39: .getInt("SITE_NODE_ID")));
40: }
41: }
42: return nodes;
43: }
44:
45: public TKDBResult getSelectionValues(String selectionData,
46: int siteNodeId) throws SQLException {
47: TKDBResult values = null;
48:
49: TKQuery query = TKDBManager.newQuery(TKWMDBRSSisters.class);
50: query.setQueryParams("SITE_NODE_ID", new Integer(siteNodeId));
51: query.execute();
52: ResultSet rs = query.fetchResultSet();
53:
54: if (rs != null) {
55: values = new TKDBResult(rs);
56: }
57: return values;
58: }
59:
60: }
|