1 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 TKWMMotherRS extends TKWMAllNodesSelector { 14 15 public boolean checkSelection( ) { 16 return false; 17 } 18 public String getSelectionData( TKHashtable params ){ 19 return ""; 20 } 21 22 public TKVector getSelectionNodes(String selectionData, int siteNodeId ) 23 throws SQLException 24 { 25 TKVector nodes= new TKVector(); 26 27 TKQuery query = TKDBManager.newQuery(TKWMDBMotherNode.class); 28 query.setQueryParams("SITE_NODE_ID", new Integer (siteNodeId)); 29 query.execute(); 30 ResultSet rs = query.fetchResultSet(); 31 32 if (rs != null) { 33 while (rs.next()) { 34 nodes.addElement(new Integer (rs.getInt("SITE_NODE_PARENT"))); 35 } 36 } 37 return nodes; 38 } 39 40 public TKDBResult getSelectionValues( String selectionData, int siteNodeId ) 41 throws SQLException 42 { 43 TKDBResult values=null; 44 45 46 TKQuery query = TKDBManager.newQuery(TKWMDBRSMother.class); 47 48 query.setQueryParams("SITE_NODE_ID", new Integer (siteNodeId)); 49 query.execute(); 50 ResultSet rs = query.fetchResultSet(); 51 52 if (rs != null) { 53 values = new TKDBResult(rs); 54 } 55 return values; 56 57 } 58 } 59 60 | Popular Tags |