teachersearchpanel.java~4~

来自「使用JBuilder基于Oracle数据库的课程作业」· JAVA~4~ 代码 · 共 37 行

package superframe.factionpanels.searchpanel;

import superframe.factionpanels.infopanel.TeacherInfoPanel;
import java.awt.event.ActionEvent;
import java.sql.ResultSet;
import superframe.link.SQLRunner;
import javax.swing.tree.DefaultMutableTreeNode;
import java.sql.SQLException;

public class TeacherSearchPanel extends SearchPanel {
    public TeacherSearchPanel(String cno, boolean e){
        infoPanel=new TeacherInfoPanel(e);
        initialize(cno,e);
    }

    public void addNodes() {
        try {
            if(top!=null)top.removeAllChildren();
            ResultSet rs=SQLRunner.getResult("select * from college where college_no='"+college_no+"'");
            if(!rs.next())return;
            top=new DefaultMutableTreeNode(college_no+rs.getString("coname"));
            ResultSet rdp=SQLRunner.getResult("select * from teacher where teacher.college_no='"+college_no+"'");
            while (rdp.next()) {
               String dno=rdp.getString("teacher_no");
               String dpname=rdp.getString("tname");
               DefaultMutableTreeNode dp=new DefaultMutableTreeNode(dno+'/'+dpname);
               top.add(dp);
          }
        } catch (SQLException ex) {
        }

    }

    public void setView(String s) {
    }
}