KickJava   Java API By Example, From Geeks To Geeks.

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


1 /*
2  * $Header: /cvsroot/webman-cms/source/webman/com/teamkonzept/webman/refsel/TKWMFirstCousinsRS.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 TKWMFirstCousinsRS extends TKWMFirstGranddaughtersRS {
14
15     public TKVector getSelectionNodes(String JavaDoc selectionData, int siteNodeId )
16         throws SQLException
17     {
18         TKVector nodes= new TKVector();
19
20         TKQuery query = TKDBManager.newQuery(TKWMDBCousinsNodes.class);
21         query.setQueryParams("SITE_NODE_ID", new Integer JavaDoc(siteNodeId));
22         query.execute();
23         ResultSet rs = query.fetchResultSet();
24
25         if (rs != null) {
26             while (rs.next()) {
27                 nodes.addElement(new Integer JavaDoc(rs.getInt("SITE_NODE_ID")));
28             }
29         }
30         return nodes;
31     }
32
33 }
34
35
Popular Tags