1 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 getSelectionData( TKHashtable params ){ 22 return ""; 23 } 24 25 public TKVector getSelectionNodes(String 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 (siteNodeId)); 32 query.execute(); 33 ResultSet rs = query.fetchResultSet(); 34 35 if (rs != null) { 36 while (rs.next()) { 37 nodes.addElement(new Integer (rs.getInt("SITE_NODE_ID"))); 38 } 39 } 40 return nodes; 41 } 42 43 public TKDBResult getSelectionValues( String 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 (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 |