KickJava   Java API By Example, From Geeks To Geeks.

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


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/refsel/TKWMGranddaughtersRS.java,v 1.2 2001/08/06 14:34:37 alex Exp $
3  *
4  */

5 package com.teamkonzept.webman.refsel;
6
7 import java.sql.*;
8 import java.util.*;
9
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 {
18     public boolean checkSelection( ) {
19         return false;
20     }
21     public String JavaDoc getSelectionData( TKHashtable params ){
22         return "";
23     }
24
25     public TKVector getSelectionNodes(String JavaDoc selectionData, int siteNodeId )
26         throws SQLException
27     {
28         TKVector nodes= new TKVector();
29
30         TKQuery query = TKDBManager.newQuery(TKWMDBGranddaughterNodes.class);
31         query.setQueryParams("SITE_NODE_ID", new Integer JavaDoc(siteNodeId));
32         query.execute();
33         ResultSet rs = query.fetchResultSet();
34
35         if (rs != null) {
36             while (rs.next()) {
37                 nodes.addElement(new Integer JavaDoc(rs.getInt("SITE_NODE_ID")));
38             }
39         }
40         return nodes;
41     }
42
43     public TKDBResult getSelectionValues( String JavaDoc selectionData, int siteNodeId )
44         throws SQLException
45     {
46         TKDBResult values=null;
47
48         TKQuery query = TKDBManager.newQuery(TKWMDBRSSisters.class);
49         query.setQueryParams("SITE_NODE_ID", new Integer JavaDoc(siteNodeId));
50         query.execute();
51         ResultSet rs = query.fetchResultSet();
52
53         if (rs != null) {
54             values = new TKDBResult(rs);
55         }
56         return values;
57     }
58
59 }
60
61
Popular Tags