public boolean ShowRightTree(JTree tree) throws SQLException{
boolean Result=false;
CheckTree ct =new CheckTree(tree);
ResultSet rs1=null,rs2=null;
int i=1,j=0;
String sql="select count(*) ROW_COUNT from MENU_TREE_MAST where ACTIVE_IND='Y'";
rs1=global.OpenSQL(sql);
//CheckNode[] nodes = null;
if(rs1.next()){
gbl_RightNodes = new CheckNode[Integer.parseInt(rs1.getString("ROW_COUNT"))+1];//创建rs1.getRow()个节点
}
sql="select * from MENU_TREE_MAST WHERE ACTIVE_IND='Y' AND NODE_LEVEL='1' ORDER BY MENU_SERIAL";
rs1=global.OpenSQL(sql);
gbl_RightNodes[0]=new CheckNode("资金管理系统"); //作为跟节点
while(rs1.next()){
gbl_RightNodes[i]=new CheckNode(rs1.getString("NODE_VALUE").trim()); //添加一个一级节点
gbl_RightNodes[0].add(gbl_RightNodes[i]);
j=i; //j用于记录当前节点的位置,方便添加子节点
i++;
sql="select * from MENU_TREE_MAST WHERE ACTIVE_IND='Y' AND PARENT_NO='"+ rs1.getString("NODE_NO").trim() +"' AND NODE_LEVEL='2' ORDER BY MENU_SERIAL";
rs2=global.OpenSQL(sql);
while(rs2.next()){
gbl_RightNodes[i]=new CheckNode(rs2.getString("NODE_VALUE").trim());
gbl_RightNodes[j].add(gbl_RightNodes[i]);
i++;
}
}
tree.setModel(new DefaultTreeModel(gbl_RightNodes[0])); //显示刚构造好的树
tree.setCellRenderer(new CheckRenderer()); //添加复选框
tree.getSelectionModel().setSelectionMode(TreeSelectionModel.DISCONTIGUOUS_TREE_SELECTION); //添加对复选框的响应
tree.addMouseListener(new NodeSelectionListener(tree));//添加监听器
tree.setVisible(true);
return Result;
}