Java MySQL数据库学生选课与成绩管理系统2-可视化图形界面

本篇属于上篇【学生选课与成绩管理系统1】的续。
由于博客字数限制，剩余代码放到这里。

上篇链接：期末大作业【学生选课与成绩管理系统1】Java+MySQL数据库+可视化图形界面

view包一共19个类。
上篇介绍了1至8类，本篇从第9个类开始，介绍9至19类：

view包

类9：Select_coursecteacherPanel1

package cvit.com.view;
import javax.swing.JPanel;
import java.awt.Color;
import javax.swing.JLabel;
import java.awt.Rectangle;
import javax.swing.JTextField;
import javax.swing.JButton;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import cvit.com.manager.CourseManager;
import javax.swing.JOptionPane;
import cvit.com.model.Course;
import javax.swing.JComboBox;
import java.util.Vector;
import java.awt.event.ItemEvent;
import java.awt.event.ItemListener;
//根据任课老师查询
public class Select_coursecteacherPanel1 extends JPanel {
    public Select_coursecteacherPanel1() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }
    private void jbInit() throws Exception {
        this.setLayout(null);
        this.setBackground(new Color(168, 233, 216));
        jLabel1.setText("课程编码");
        jLabel1.setBounds(new Rectangle(192, 46, 65, 15));
        tctype.setEnabled(false);
        tctype.setBounds(new Rectangle(260, 82, 77, 20));
        btn_exit.setBounds(new Rectangle(142, 178, 81, 23));
        btn_exit.setText("退出");
        btn_exit.addActionListener(new
                Select_coursecteacherPanel1_btn_exit_actionAdapter(this));
        tctime.setEnabled(false);
        tctime.setBounds(new Rectangle(260, 120, 77, 20));
        jLabel2.setToolTipText("");
        jLabel2.setText("授课教师");
        jLabel2.setBounds(new Rectangle(11, 41, 53, 15));
        jLabel3.setText("课程名称");
        jLabel3.setBounds(new Rectangle(18, 86, 60, 15));
        tcno.setEnabled(false);
        tcno.setBounds(new Rectangle(260, 42, 77, 20));
        jLabel4.setText("课程类别");
        jLabel4.setBounds(new Rectangle(193, 84, 62, 15));
        tcname.setEnabled(false);
        tcname.setBounds(new Rectangle(81, 83, 77, 20));
        jLabel5.setText("上课地点");
        jLabel5.setBounds(new Rectangle(19, 124, 67, 15));
        tcplace.setEnabled(false);
        tcplace.setBounds(new Rectangle(83, 123, 77, 20));
        jLabel6.setText("上课时间");
        jLabel6.setBounds(new Rectangle(194, 121, 57, 15));
        jcb_teacher.setBounds(new Rectangle(83, 36, 75, 23));
        jcb_teacher.addItemListener(new
                Select_coursecteacherPanel1_jcb_teacher_itemAdapter(this));
        this.add(jLabel5);
        this.add(tcname);
        this.add(jLabel3);
        this.add(jLabel2);
        this.add(jcb_teacher);
        this.add(tcplace);
        this.add(btn_exit);
        this.add(tctype);
        this.add(tctime);
        this.add(jLabel4);
        this.add(jLabel6);
        this.add(jLabel1);
        this.add(tcno);
        Vector v1=cm.selectCourse2();           //调用查询所有任课教师名称方法
        for (int i = 0; i < v1.size(); i++) {
            jcb_teacher.addItem(v1.get(i).toString());
        }
        this.setVisible(true);
        this.setSize(600, 600);
    }
    JLabel jLabel1 = new JLabel();
    JTextField tctype = new JTextField();
    JButton btn_exit = new JButton();
    JTextField tctime = new JTextField();
    JLabel jLabel2 = new JLabel();
    JLabel jLabel3 = new JLabel();
    JTextField tcno = new JTextField();
    JLabel jLabel4 = new JLabel();
    JTextField tcname = new JTextField();
    JLabel jLabel5 = new JLabel();
    JTextField tcplace = new JTextField();
    JLabel jLabel6 = new JLabel();
    JComboBox jcb_teacher = new JComboBox();
    CourseManager cm = new CourseManager();
    public void btn_exit_actionPerformed(ActionEvent e) {
        this.setVisible(false);
    }
    public void btn_select_actionPerformed(ActionEvent e) {
        String cteacher = jcb_teacher.getSelectedItem().toString();
        CourseManager cm = new CourseManager();
        //调用按任课教师查询课程信息方法
        Course c = cm.findCourse_teacher(cteacher);
        if (c == null) {
            JOptionPane.showMessageDialog(this, "没有该课程！", "提示信息",
                    JOptionPane.INFORMATION_MESSAGE);
        } else {
            tcno.setText(c.getCno());
            tcname.setText(c.getCname());
            tctype.setText(c.getCtype());
            tcplace.setText(c.getCplace());
            tctime.setText(c.getCtime());
        }
    }
    public void jcb_teacher_itemStateChanged(ItemEvent e) {
        Course c = cm.findOneCourse2(jcb_teacher.getSelectedItem().toString());
        System.out.println(c.getCno());
        System.out.println(c.getCname());
        System.out.println(c.getCtype());
        System.out.println(c.getCplace());
        System.out.println(c.getCtime());
        tcno.setText(c.getCno());
        tcname.setText(c.getCname());
        tcplace.setText(c.getCplace());
        tctype.setText(c.getCtype());
        tctime.setText(c.getCtime());
    }
}
class Select_coursecteacherPanel1_jcb_teacher_itemAdapter implements
        ItemListener {
    private Select_coursecteacherPanel1 adaptee;
    Select_coursecteacherPanel1_jcb_teacher_itemAdapter(
            Select_coursecteacherPanel1 adaptee) {
        this.adaptee = adaptee;
    }
    public void itemStateChanged(ItemEvent e) {
        adaptee.jcb_teacher_itemStateChanged(e);
    }
}
class Select_coursecteacherPanel1_btn_exit_actionAdapter implements
        ActionListener {
    private Select_coursecteacherPanel1 adaptee;
    Select_coursecteacherPanel1_btn_exit_actionAdapter(
            Select_coursecteacherPanel1 adaptee) {
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
        adaptee.btn_exit_actionPerformed(e);
    }
}

类10：Select_gradestudentPanel1

package cvit.com.view;
import java.awt.BorderLayout;
import cvit.com.manager.StudentManager;
import javax.swing.JPanel;
import java.awt.Color;
import javax.swing.JButton;
import java.awt.Rectangle;
import javax.swing.JTextField;
import javax.swing.JComboBox;
import javax.swing.JLabel;
import javax.swing.JList;
import java.util.Vector;
import java.awt.event.ItemEvent;
import java.awt.event.ItemListener;
import cvit.com.manager.GradeManager;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
public class Select_gradestudentPanel1 extends JPanel {
    public Select_gradestudentPanel1() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }
    private void jbInit() throws Exception {
        this.setLayout(null);
        this.setBackground(new Color(168, 233, 216));
        jcb_sno.setBounds(new Rectangle(93, 20, 101, 23));
        jcb_sno.addItemListener(new
                SelectGradestudentPanel1_jcb_sno_itemAdapter(this));
        jLabel1.setText("学号");
        jLabel1.setBounds(new Rectangle(35, 22, 55, 20));
        list.setBounds(new Rectangle(35, 68, 330, 123));
        btn_exit.setBounds(new Rectangle(237, 21, 81, 23));
        btn_exit.setText("退出");
        btn_exit.addActionListener(new
                SelectGradestudentPanel1_btn_exit_actionAdapter(this));
        this.add(list);
        this.add(jLabel1);
        this.add(jcb_sno);
        this.add(btn_exit);
        Vector v=sm.selectStudent();            //调用查询学号方法
        for (int i = 0; i < v.size(); i++) {
            jcb_sno.addItem(v.get(i).toString());
        }
        this.setVisible(true);
        this.setSize(600, 600);
    }
    JComboBox jcb_sno = new JComboBox();
    JLabel jLabel1 = new JLabel();
    JList list = new JList();
    StudentManager sm=new StudentManager();
    JButton btn_exit = new JButton();
    public void jcb_sno_itemStateChanged(ItemEvent e) {
        String sno = (String) jcb_sno.getSelectedItem();
        GradeManager sm = new GradeManager();
        Vector v = sm.selectGradestudent(sno);//调用某同学所有科目及成绩方法
        list.setListData(v);
    }
    public void btn_exit_actionPerformed(ActionEvent e) {
        this.setVisible(false);
    }
}
class SelectGradestudentPanel1_btn_exit_actionAdapter implements ActionListener {
    private Select_gradestudentPanel1 adaptee;
    SelectGradestudentPanel1_btn_exit_actionAdapter(Select_gradestudentPanel1
                                                            adaptee) {
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
        adaptee.btn_exit_actionPerformed(e);
    }
}
class SelectGradestudentPanel1_jcb_sno_itemAdapter implements ItemListener {
    private Select_gradestudentPanel1 adaptee;
    SelectGradestudentPanel1_jcb_sno_itemAdapter(Select_gradestudentPanel1 adaptee) {
        this.adaptee = adaptee;
    }
    public void itemStateChanged(ItemEvent e) {
        adaptee.jcb_sno_itemStateChanged(e);
    }
}

类11：Select_studentcollegePanel

package cvit.com.view;
import javax.swing.JPanel;
import java.awt.Color;
import javax.swing.JLabel;
import java.awt.Rectangle;
import javax.swing.JButton;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import cvit.com.manager.StudentManager;
import javax.swing.JList;
import java.util.Vector;
import javax.swing.JComboBox;
import java.awt.event.ItemEvent;
import java.awt.event.ItemListener;
import javax.swing.JScrollPane;
//按分院查询
        public class Select_studentcollegePanel extends JPanel {
    public Select_studentcollegePanel() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }
    private void jbInit() throws Exception {
        this.setLayout(null);
        this.setBackground(new Color(168, 233, 216));
        jLabel1.setText("所在分院");
        jLabel1.setBounds(new Rectangle(51, 38, 62, 15));
        list1.setBounds(new Rectangle(16, 78, 446, 172));
        btn_exit.setBounds(new Rectangle(282, 31, 81, 23));
        btn_exit.setText("退出");
        btn_exit.addActionListener(new
                Select_studentcollegePanel_btn_exit_actionAdapter(this));
        jcb_college.setBounds(new Rectangle(136, 34, 102, 23));
        jcb_college.addItemListener(new
                Select_studentcollegePanel_jcb_college_itemAdapter(this));
        this.add(list1);
        this.add(jcb_college);
        this.add(jLabel1);
        this.add(btn_exit);
        this.setVisible(true);
        this.setSize(600, 600);
        Vector v=sm.selectStudentcollege();            //调用查询所有分院方法
        for (int i = 0; i < v.size(); i++) {
            jcb_college.addItem(v.get(i).toString());  //将查询结果显示在下拉列表中
        }
    }
    JLabel jLabel1 = new JLabel();
    Vector v1 = null;
    JList list1 = new JList();
    JButton btn_exit = new JButton();
    JComboBox jcb_college = new JComboBox();
    StudentManager sm = new StudentManager();
    public void btn_actionPerformed(ActionEvent e) {
        String scollege = jcb_college.getSelectedItem().toString();
        StudentManager sm = new StudentManager();
        Vector v1 = sm.findStudentcollege(scollege);
        list1.setListData(v1);
    }
    public void btn_exit_actionPerformed(ActionEvent e) {
        this.setVisible(false);
    }
    public void jcb_college_itemStateChanged(ItemEvent e) {
        String scollege = jcb_college.getSelectedItem().toString();
        StudentManager sm = new StudentManager();
        Vector v1=sm.findStudentcollege(scollege);      //调用按分院查询学生信息方法
        list1.setListData(v1);                          //将查到的学生信息显示在Jlist控件中
    }
}
class Select_studentcollegePanel_jcb_college_itemAdapter implements
        ItemListener {
    private Select_studentcollegePanel adaptee;
    Select_studentcollegePanel_jcb_college_itemAdapter(
            Select_studentcollegePanel adaptee) {
        this.adaptee = adaptee;
    }
    public void itemStateChanged(ItemEvent e) {
        adaptee.jcb_college_itemStateChanged(e);
    }
}
class Select_studentcollegePanel_btn_exit_actionAdapter implements
        ActionListener {
    private Select_studentcollegePanel adaptee;
    Select_studentcollegePanel_btn_exit_actionAdapter(
            Select_studentcollegePanel adaptee) {
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
        adaptee.btn_exit_actionPerformed(e);
    }
}

类12：Select_studentmajorPanel1

package cvit.com.view;
import javax.swing.JPanel;
import java.awt.Color;
import javax.swing.JButton;
import java.awt.Rectangle;
import javax.swing.JLabel;
import javax.swing.JList;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import cvit.com.manager.StudentManager;
import java.util.Vector;
import javax.swing.JComboBox;
import java.awt.event.ItemEvent;
import java.awt.event.ItemListener;
//按专业查询
public class Select_studentmajorPanel1 extends JPanel {
    public Select_studentmajorPanel1() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }
    private void jbInit() throws Exception {
        this.setLayout(null);
        this.setBackground(new Color(168, 233, 216));
        btn_exit.setBounds(new Rectangle(314, 36, 81, 23));
        btn_exit.setText("退出");
        btn_exit.addActionListener(new Select_srudentmajorPanel1_btn_exit_actionAdapter(this));
        jLabel1.setText("所学专业");
        jLabel1.setBounds(new Rectangle(34, 38, 62, 15));
        list1.setBounds(new Rectangle(31, 76, 428, 125));
        jcb_major.setBounds(new Rectangle(119, 31, 100, 23));
        jcb_major.addItemListener(new
                Select_studentmajorPanel1_jcb_major_itemAdapter(this));
        this.add(btn_exit);
        this.add(jLabel1);
        this.add(list1);
        this.add(jcb_major);
        Vector v=sm.selectStudentmajor();             //调用查询所有专业方法
        for (int i = 0; i < v.size(); i++) {
            jcb_major.addItem(v.get(i).toString());   //将查询的所有专业添加到下拉列表中
        }
        this.setVisible(true);
        this.setSize(600, 600);
    }
    JButton btn_exit = new JButton();
    JLabel jLabel1 = new JLabel();
    JList list1 = new JList();
    StudentManager sm = new StudentManager();
    JComboBox jcb_major = new JComboBox();
    public void btn_exit_actionPerformed(ActionEvent e) {
        this.setVisible(false);
    }
    public void jcb_major_itemStateChanged(ItemEvent e) {
        String smajor = jcb_major.getSelectedItem().toString();
        StudentManager sm = new StudentManager();
        Vector v1=sm.findStudentmajor(smajor);         //调用根据专业查询学生信息方法
        list1.setListData(v1);
    }
}
class Select_studentmajorPanel1_jcb_major_itemAdapter implements ItemListener {
    private Select_studentmajorPanel1 adaptee;
    Select_studentmajorPanel1_jcb_major_itemAdapter(Select_studentmajorPanel1
                                                            adaptee) {
        this.adaptee = adaptee;
    }
    public void itemStateChanged(ItemEvent e) {
        adaptee.jcb_major_itemStateChanged(e);
    }
}
class Select_srudentmajorPanel1_btn_exit_actionAdapter implements
        ActionListener {
    private Select_studentmajorPanel1 adaptee;
    Select_srudentmajorPanel1_btn_exit_actionAdapter(Select_studentmajorPanel1 adaptee) {
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
        adaptee.btn_exit_actionPerformed(e);
    }
}

类13：Select_studentnamePanel

package cvit.com.view;
import javax.swing.JPanel;
import java.awt.Color;
import javax.swing.JButton;
import java.awt.Rectangle;
import javax.swing.JLabel;
import javax.swing.JTextField;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.JList;
import cvit.com.manager.StudentManager;
import java.util.Vector;
//按学生名查询
public class Select_studentnamePanel extends JPanel {
    public Select_studentnamePanel() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }
    private void jbInit() throws Exception {
        this.setLayout(null);
        this.setBackground(new Color(168, 233, 216));
        jButton1.setBounds(new Rectangle(314, 36, 81, 23));
        jButton1.setText("退出");
        jButton1.addActionListener(new
                Select_studentnamePanel_jButton1_actionAdapter(this));
        jLabel1.setText("学生姓名");
        jLabel1.setBounds(new Rectangle(25, 38, 71, 15));
        jButton2.setBounds(new Rectangle(246, 38, 64, 23));
        jButton2.setText("查询");
        jButton2.addActionListener(new
                Select_studentnamePanel_jButton2_actionAdapter(this));
        tsname.setBounds(new Rectangle(108, 38, 126, 20));
        list.setBounds(new Rectangle(20, 84, 442, 70));
        this.add(jButton1);
        this.add(jLabel1);
        this.add(jButton2);
        this.add(tsname);
        this.add(list);
        this.setVisible(true);
        this.setSize(600, 600);
    }
    JButton jButton1 = new JButton();
    JLabel jLabel1 = new JLabel();
    JButton jButton2 = new JButton();
    JTextField tsname = new JTextField();
    JList list = new JList();
    public void jButton1_actionPerformed(ActionEvent e) {
        this.setVisible(false);
    }
    public void jButton2_actionPerformed(ActionEvent e) {
        String sname = tsname.getText().trim();
        StudentManager sm = new StudentManager();
        Vector v = sm.find;
//        Student_name(sname); //调用按学生姓名查询学生信息方法
        list.setListData(v);                   //将Vector集合中所有的信息添加到Jlist控件中
    }
}
class Select_studentnamePanel_jButton2_actionAdapter implements ActionListener {
    private Select_studentnamePanel adaptee;
    Select_studentnamePanel_jButton2_actionAdapter(Select_studentnamePanel
                                                           adaptee) {
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
        adaptee.jButton2_actionPerformed(e);
    }
}
class Select_studentnamePanel_jButton1_actionAdapter implements ActionListener {
    private Select_studentnamePanel adaptee;
    Select_studentnamePanel_jButton1_actionAdapter(Select_studentnamePanel
                                                           adaptee) {
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
        adaptee.jButton1_actionPerformed(e);
    }
}

类14：Select_studentnoPanel1

package cvit.com.view;
import javax.swing.JPanel;
import java.awt.Color;
import javax.swing.JLabel;
import java.awt.Rectangle;
import javax.swing.JTextField;
import javax.swing.JButton;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.JOptionPane;
import cvit.com.model.Student;
import cvit.com.manager.StudentManager;
//按学号查询
public class Select_studentnoPanel1 extends JPanel {
    public Select_studentnoPanel1() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }
    private void jbInit() throws Exception {
        this.setLayout(null);
        this.setBackground(new Color(168, 233, 216));
        jLabel1.setText("籍贯");
        jLabel1.setBounds(new Rectangle(16, 197, 42, 15));
        jLabel2.setText("姓名");
        jLabel2.setBounds(new Rectangle(187, 35, 42, 15));
        tsno.setBounds(new Rectangle(79, 33, 77, 20));
        tscollege.setEnabled(false);
        tscollege.setBounds(new Rectangle(79, 153, 77, 20));
        jLabel3.setText("专业");
        jLabel3.setBounds(new Rectangle(188, 154, 42, 15));
        jLabel4.setText("学号");
        jLabel4.setBounds(new Rectangle(15, 36, 42, 15));
        jLabel5.setText("入学时间");
        jLabel5.setBounds(new Rectangle(175, 112, 67, 15));
        tsname.setEnabled(false);
        tsname.setBounds(new Rectangle(250, 32, 77, 20));
        tsmajor.setEnabled(false);
        tsmajor.setBounds(new Rectangle(251, 156, 77, 20));
        jLabel6.setText("民族");
        jLabel6.setBounds(new Rectangle(184, 75, 42, 15));
        tstime.setEnabled(false);
        tstime.setBounds(new Rectangle(251, 111, 77, 20));
        tssex.setEnabled(false);
        tssex.setToolTipText("");
        tssex.setBounds(new Rectangle(77, 73, 77, 20));
        jLabel7.setText("性别");
        jLabel7.setBounds(new Rectangle(14, 74, 42, 15));
        tsbirth.setEnabled(false);
        tsbirth.setBounds(new Rectangle(79, 111, 77, 20));
        jLabel8.setText("出生日期");
        jLabel8.setBounds(new Rectangle(12, 112, 53, 15));
        tsethnix.setEnabled(false);
        tsethnix.setBounds(new Rectangle(251, 73, 77, 20));
        tshome.setEnabled(false);
        tshome.setBounds(new Rectangle(77, 198, 251, 20));
        jLabel9.setText("学院");
        jLabel9.setBounds(new Rectangle(15, 154, 42, 15));
        btn_exit.setBounds(new Rectangle(245, 247, 81, 23));
        btn_exit.setText("退出");
        btn_exit.addActionListener(new
                Select_studentnoPanel1_btn_exit_actionAdapter(this));
        btn_select.setBounds(new Rectangle(44, 245, 81, 23));
        btn_select.setText("查询");
        btn_select.addActionListener(new
                Select_studentnoPanel1_btn_select_actionAdapter(this));
        this.add(jLabel1);
        this.add(jLabel2);
        this.add(tsno);
        this.add(tscollege);
        this.add(jLabel3);
        this.add(jLabel4);
        this.add(jLabel5);
        this.add(tsname);
        this.add(tsmajor);
        this.add(jLabel6);
        this.add(tstime);
        this.add(tssex);
        this.add(jLabel7);
        this.add(tsbirth);
        this.add(jLabel8);
        this.add(tsethnix);
        this.add(tshome);
        this.add(jLabel9);
        this.add(btn_select);
        this.add(btn_exit);
    }
    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JTextField tsno = new JTextField();
    JTextField tscollege = new JTextField();
    JLabel jLabel3 = new JLabel();
    JLabel jLabel4 = new JLabel();
    JLabel jLabel5 = new JLabel();
    JTextField tsname = new JTextField();
    JTextField tsmajor = new JTextField();
    JLabel jLabel6 = new JLabel();
    JTextField tstime = new JTextField();
    JTextField tssex = new JTextField();
    JLabel jLabel7 = new JLabel();
    JTextField tsbirth = new JTextField();
    JLabel jLabel8 = new JLabel();
    JTextField tsethnix = new JTextField();
    JTextField tshome = new JTextField();
    JLabel jLabel9 = new JLabel();
    JButton btn_exit = new JButton();
    JButton btn_select = new JButton();
    public void btn_select_actionPerformed(ActionEvent e) {
        String sno = tsno.getText().trim();
        StudentManager sm = new StudentManager();
        Student s=sm.findStudent(sno);            //调用按学号查询学生信息方法
        if (s == null) {
            JOptionPane.showMessageDialog(this, "没有该名同学！", "提示信息",
                    JOptionPane.INFORMATION_MESSAGE);
            tsno.setText("");
        } else {
            tsno.setText(s.getSno());             //将查询到的信息显示在各文本框中
            tsname.setText(s.getSname());
            tssex.setText(s.getSsex());
            tsethnix.setText(s.getSethnix());
            tsbirth.setText(s.getSbirth());
            tstime.setText(s.getSyear());
            tscollege.setText(s.getScollege());
            tsmajor.setText(s.getSmajor());
            tshome.setText(s.getShome());
        }
    }
    public void btn_exit_actionPerformed(ActionEvent e) {
        this.setVisible(false);
    }
}
class Select_studentnoPanel1_btn_exit_actionAdapter implements ActionListener {
    private Select_studentnoPanel1 adaptee;
    Select_studentnoPanel1_btn_exit_actionAdapter(Select_studentnoPanel1 adaptee) {
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
        adaptee.btn_exit_actionPerformed(e);
    }
}
class Select_studentnoPanel1_btn_select_actionAdapter implements ActionListener {
    private Select_studentnoPanel1 adaptee;
    Select_studentnoPanel1_btn_select_actionAdapter(Select_studentnoPanel1 adaptee) {
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
        adaptee.btn_select_actionPerformed(e);
    }
}

类15：Select_studentsexPanel

package cvit.com.view;
import javax.swing.JPanel;
import java.awt.Color;
import javax.swing.JButton;
import java.awt.Rectangle;
import javax.swing.JLabel;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.JList;
import cvit.com.manager.StudentManager;
import java.util.Vector;
import javax.swing.JComboBox;
import java.awt.event.ItemEvent;
import java.awt.event.ItemListener;
//按学生性别查询
public class Select_studentsexPanel extends JPanel {
    public Select_studentsexPanel() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }
    private void jbInit() throws Exception {
        this.setLayout(null);
        this.setBackground(new Color(168, 233, 216));
        jButton1.setBounds(new Rectangle(257, 40, 81, 23));
        jButton1.setText("退出");
        jButton1.addActionListener(new
                Select_studentsexPanel_jButton1_actionAdapter(this));
        jLabel1.setText("性别");
        jLabel1.setBounds(new Rectangle(84, 46, 49, 15));
        list.setBounds(new Rectangle(37, 104, 421, 112));
        jcb_sex.setBounds(new Rectangle(155, 40, 63, 23));
        jcb_sex.addItemListener(new Select_studentsexPanel_jcb_sex_itemAdapter(this));
        this.add(list);
        this.add(jLabel1);
        this.add(jcb_sex);
        this.add(jButton1);
        jcb_sex.addItem("男");
        jcb_sex.addItem("女");
    }
    JButton jButton1 = new JButton();
    JLabel jLabel1 = new JLabel();
    JList list = new JList();
    JComboBox jcb_sex = new JComboBox();
    public void jButton1_actionPerformed(ActionEvent e) {
        this.setVisible(false);
    }
    public void jcb_sex_itemStateChanged(ItemEvent e) {
        String ssex = jcb_sex.getSelectedItem().toString();
        StudentManager sm = new StudentManager();
        Vector v=sm.findStudentsex1(ssex);           //调用按性别查询学生信息方法
        list.setListData(v);                         //将查询到的信息显示在Jlist控件中
    }
}
class Select_studentsexPanel_jcb_sex_itemAdapter implements ItemListener {
    private Select_studentsexPanel adaptee;
    Select_studentsexPanel_jcb_sex_itemAdapter(Select_studentsexPanel adaptee) {
        this.adaptee = adaptee;
    }
    public void itemStateChanged(ItemEvent e) {
        adaptee.jcb_sex_itemStateChanged(e);
    }
}
class Select_studentsexPanel_jButton1_actionAdapter implements ActionListener {
    private Select_studentsexPanel adaptee;
    Select_studentsexPanel_jButton1_actionAdapter(Select_studentsexPanel adaptee) {
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
        adaptee.jButton1_actionPerformed(e);
    }
}

类16：Student_choosePanel

package cvit.com.view;
import javax.swing.JPanel;
import java.awt.Color;
import javax.swing.JTextField;
import java.awt.Rectangle;
import javax.swing.JComboBox;
import javax.swing.JLabel;
import javax.swing.JButton;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.ItemEvent;
import java.awt.event.ItemListener;
import cvit.com.manager.StudentManager;
import java.util.Vector;
import cvit.com.manager.CourseManager;
import cvit.com.model.Course;
import javax.swing.JOptionPane;
import cvit.com.manager.GradeManager;
//学生选课
public class Student_choosePanel extends JPanel {
    public Student_choosePanel() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }
    private void jbInit() throws Exception {
        this.setLayout(null);
        this.setBackground(new Color(168, 233, 216));
        tsname.setEnabled(false);
        tsname.setBounds(new Rectangle(241, 25, 103, 27));
        jcb_course.setBounds(new Rectangle(63, 78, 102, 26));
        jcb_course.addItemListener(new
                Student_choosePanel_jcb_course_itemAdapter(this));
        jLabel1.setText("学  号");
        jLabel1.setBounds(new Rectangle(11, 34, 42, 15));
        jLabel2.setText("姓  名");
        jLabel2.setBounds(new Rectangle(176, 34, 42, 15));
        jcb_sno.setBounds(new Rectangle(61, 28, 108, 26));
        jcb_sno.addItemListener(new Student_choosePanel_jcb_sno_itemAdapter(this));
        tcno.setEnabled(false);
        tcno.setBounds(new Rectangle(239, 82, 98, 20));
        jLabel3.setText("选择课程");
        jLabel3.setBounds(new Rectangle(6, 87, 55, 15));
        jLabel4.setText("课程编码");
        jLabel4.setBounds(new Rectangle(174, 84, 58, 15));
        jLabel5.setText("授课教师");
        jLabel5.setBounds(new Rectangle(9, 141, 56, 15));
        tcteacher.setEnabled(false);
        tcteacher.setBounds(new Rectangle(80, 136, 77, 20));
        jLabel6.setText("授课地点");
        jLabel6.setBounds(new Rectangle(173, 143, 57, 15));
        tcplace.setEnabled(false);
        tcplace.setBounds(new Rectangle(239, 136, 94, 20));
        btn_choose.setBounds(new Rectangle(63, 202, 81, 23));
        btn_choose.setText("选课");
        btn_choose.addActionListener(new
                Student_choosePanel_btn_choose_actionAdapter(this));
        btn_exit.setBounds(new Rectangle(222, 207, 81, 23));
        btn_exit.setText("退出");
        btn_exit.addActionListener(new
                Student_choosePanel_btn_exit_actionAdapter(this));
        this.add(jLabel1);
        this.add(jLabel2);
        this.add(jLabel3);
        this.add(jcb_course);
        this.add(jcb_sno);
        this.add(jLabel4);
        this.add(tsname);
        this.add(jLabel5);
        this.add(btn_choose);
        this.add(btn_exit);
        this.add(jLabel6);
        this.add(tcplace);
        this.add(tcteacher);
        this.add(tcno);
        Vector v=sm.selectStudent();              //调用查询所有学生学号方法
        for (int i = 0; i < v.size(); i++) {
            jcb_sno.addItem(v.get(i).toString()); //将数据库中所有的学号添加到下拉列表中
        }
        Vector v1 = cm.selectCourse();
        for (int i = 0; i < v1.size(); i++) {
            jcb_course.addItem(v1.get(i).toString()); //将数据库中的所有科目添加到下拉列表中
        }
        this.setVisible(true);                    //窗体可见性
        this.setSize(600, 600);                    //窗体大小
    }
    JTextField tsname = new JTextField();
    JComboBox jcb_course = new JComboBox();
    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JComboBox jcb_sno = new JComboBox();
    JTextField tcno = new JTextField();
    JLabel jLabel3 = new JLabel();
    JLabel jLabel4 = new JLabel();
    JLabel jLabel5 = new JLabel();
    JTextField tcteacher = new JTextField();
    JLabel jLabel6 = new JLabel();
    JTextField tcplace = new JTextField();
    JButton btn_choose = new JButton();
    JButton btn_exit = new JButton();
    StudentManager sm=new StudentManager();       //在程序初始化中定义学生管理对象sm
    CourseManager cm=new CourseManager();         //在初始化中定义课程管理对象cm
    public void btn_exit_actionPerformed(ActionEvent e) {
        this.setVisible(false);
    }
    //所选值改变自动执行查找学生方法
    public void jcb_sno_itemStateChanged(ItemEvent e) {
        //调用按学号查询学生信息方法并将学生姓名显示在文本框中
        tsname.setText(sm.findOneStudent(jcb_sno.getSelectedItem().toString()));
    }
    public void jcb_course_itemStateChanged(ItemEvent e) {
        //调用按课程名称查询课程信息方法并将信息显示在相应文本框中
        Course c = cm.findOneCourse(jcb_course.getSelectedItem().toString());
        tcno.setText(c.getCno());
        tcteacher.setText(c.getCteacher());
        tcplace.setText(c.getCplace());
    }
    public void btn_choose_actionPerformed(ActionEvent e) {
        String sno = (String) jcb_sno.getSelectedItem(); //获得下拉列表中选定的学生学号
        String cno=tcno.getText();                       //获得课程名称文本框中的课程代码
        GradeManager cm=new GradeManager();              //定义成绩管理对象cm
        int i=cm.chooseCourse(sno, cno);                  //调用选课方法
        if (i > 0) {
            JOptionPane.showMessageDialog(this, "选课成功！", "提示信息",
                    JOptionPane.INFORMATION_MESSAGE);
        } else {
            JOptionPane.showMessageDialog(this, "添加失败！", "提示信息",
                    JOptionPane.ERROR_MESSAGE);
        }
    }
}
class Student_choosePanel_btn_choose_actionAdapter implements ActionListener {
    private Student_choosePanel adaptee;
    Student_choosePanel_btn_choose_actionAdapter(Student_choosePanel adaptee) {
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
        adaptee.btn_choose_actionPerformed(e);
    }
}
class Student_choosePanel_jcb_course_itemAdapter implements ItemListener {
    private Student_choosePanel adaptee;
    Student_choosePanel_jcb_course_itemAdapter(Student_choosePanel adaptee) {
        this.adaptee = adaptee;
    }
    public void itemStateChanged(ItemEvent e) {
        adaptee.jcb_course_itemStateChanged(e);
    }
}
class Student_choosePanel_jcb_sno_itemAdapter implements ItemListener {
    private Student_choosePanel adaptee;
    Student_choosePanel_jcb_sno_itemAdapter(Student_choosePanel adaptee) {
        this.adaptee = adaptee;
    }
    public void itemStateChanged(ItemEvent e) {
        adaptee.jcb_sno_itemStateChanged(e);
    }
}
class Student_choosePanel_btn_exit_actionAdapter implements ActionListener {
    private Student_choosePanel adaptee;
    Student_choosePanel_btn_exit_actionAdapter(Student_choosePanel adaptee) {
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
        adaptee.btn_exit_actionPerformed(e);
    }
}

类17：Update_coursePanel

package cvit.com.view;
import javax.swing.JPanel;
import java.awt.Color;
import javax.swing.JLabel;
import java.awt.Rectangle;
import javax.swing.JButton;
import javax.swing.JTextField;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import cvit.com.manager.CourseManager.*;
import cvit.com.model.Course.*;
import cvit.com.manager.CourseManager;
import cvit.com.model.Course;
import javax.swing.JOptionPane;
//修改课程信息
public class Update_coursePanel extends JPanel {
    public Update_coursePanel() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }
    private void jbInit() throws Exception {
        this.setLayout(null);
        this.setBackground(new Color(168, 233, 216));
        jLabel1.setText("课程编码");
        jLabel1.setBounds(new Rectangle(20, 47, 65, 15));
        btn_update.setBounds(new Rectangle(153, 182, 81, 23));
        btn_update.setText("修改");
        btn_update.addActionListener(new
                Update_coursePanel_btn_update_actionAdapter(this));
        tcno.setBounds(new Rectangle(93, 45, 77, 20));
        btn_select.setBounds(new Rectangle(37, 182, 81, 23));
        btn_select.setText("查找");
        btn_select.addActionListener(new
                Update_coursePanel_btn_select_actionAdapter(this));
        jButton3.setBounds(new Rectangle(267, 182, 81, 23));
        jButton3.setText("退出");
        jButton3.addActionListener(new
                Update_coursePanel_jButton3_actionAdapter(this));
        jLabel2.setText("课程类别");
        jLabel2.setBounds(new Rectangle(201, 90, 62, 15));
        jLabel3.setText("上课时间");
        jLabel3.setBounds(new Rectangle(200, 127, 57, 15));
        tcname.setEnabled(false);
        tcname.setBounds(new Rectangle(264, 44, 77, 20));
        jLabel4.setToolTipText("");
        jLabel4.setText("授课教师");
        jLabel4.setBounds(new Rectangle(20, 88, 53, 15));
        tctime.setEnabled(false);
        tctime.setBounds(new Rectangle(265, 123, 77, 20));
        tcteacher.setEnabled(false);
        tcteacher.setBounds(new Rectangle(91, 85, 77, 20));
        jLabel5.setText("上课地点");
        jLabel5.setBounds(new Rectangle(20, 122, 67, 15));
        tcplace.setEnabled(false);
        tcplace.setBounds(new Rectangle(93, 123, 77, 20));
        tctype.setEnabled(false);
        tctype.setBounds(new Rectangle(265, 85, 77, 20));
        jLabel6.setText("课程名称");
        jLabel6.setBounds(new Rectangle(200, 48, 60, 15));
        this.add(jLabel1);
        this.add(btn_update);
        this.add(tcno);
        this.add(btn_select);
        this.add(jButton3);
        this.add(tcname);
        this.add(tctime);
        this.add(tcteacher);
        this.add(tcplace);
        this.add(tctype);
        this.add(jLabel4);
        this.add(jLabel5);
        this.add(jLabel2);
        this.add(jLabel3);
        this.add(jLabel6);
    }
    JLabel jLabel1 = new JLabel();
    JButton btn_update = new JButton();
    JTextField tcno = new JTextField();
    JButton btn_select = new JButton();
    JButton jButton3 = new JButton();
    JLabel jLabel2 = new JLabel();
    JLabel jLabel3 = new JLabel();
    JTextField tcname = new JTextField();
    JLabel jLabel4 = new JLabel();
    JTextField tctime = new JTextField();
    JTextField tcteacher = new JTextField();
    JLabel jLabel5 = new JLabel();
    JTextField tcplace = new JTextField();
    JTextField tctype = new JTextField();
    JLabel jLabel6 = new JLabel();
    public void btn_select_actionPerformed(ActionEvent e) {
        String cno=tcno.getText().trim();          //获得课程编码文本框内容
        CourseManager cm = new CourseManager();
        Course c=cm.findCourse(cno);               //调用按课程编码查询课程信息方法
        if (c == null) {
            JOptionPane.showMessageDialog(this, "没有该课程！", "提示信息",
                    JOptionPane.INFORMATION_MESSAGE);
        } else {
            tcno.setEnabled(false);                //设置文本框是否可用
            tcname.setEnabled(true);
            tcteacher.setEnabled(true);
            tctype.setEnabled(true);
            tcplace.setEnabled(true);
            tctime.setEnabled(true);
            tcno.setText(c.getCno());
            tcname.setText(c.getCname());          //将查询的结果显示在各文本框中
            tcteacher.setText(c.getCteacher());
            tctype.setText(c.getCtype());
            tcplace.setText(c.getCplace());
            tctime.setText(c.getCtime());
        }
    }
    public void btn_update_actionPerformed(ActionEvent e) {
        String cno=tcno.getText();                 //获得各文本框内容
        String cname = tcname.getText();
        String cteacher = tcteacher.getText();
        String ctype = tctype.getText();
        String cplace = tcplace.getText();
        String ctime = tctime.getText();
        CourseManager cm=new CourseManager();     //定义课程管理对象cm
        //调用修改课程信息方法
        int i = cm.update_Course(cno, cname, cteacher, ctype, cplace, ctime);
        if (i > 0) {
            JOptionPane.showMessageDialog(this, "修改成功！", "提示信息",
                    JOptionPane.INFORMATION_MESSAGE);
            tcno.setEnabled(true);
            tcname.setEnabled(false);
            tcteacher.setEnabled(false);
            tctype.setEnabled(false);
            tcplace.setEnabled(false);
            tctime.setEnabled(false);
            tcno.setText("");
            tcname.setText("");
            tctype.setText("");
            tcplace.setText("");
            tcteacher.setText("");
            tctime.setText("");
        } else {
            JOptionPane.showMessageDialog(this, "修改失败！", "提示信息",
                    JOptionPane.ERROR_MESSAGE);
        }
    }
    public void jButton3_actionPerformed(ActionEvent e) {
        this.setVisible(false);
    }
}
class Update_coursePanel_btn_update_actionAdapter implements ActionListener {
    private Update_coursePanel adaptee;
    Update_coursePanel_btn_update_actionAdapter(Update_coursePanel adaptee) {
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
        adaptee.btn_update_actionPerformed(e);
    }
}
class Update_coursePanel_jButton3_actionAdapter implements ActionListener {
    private Update_coursePanel adaptee;
    Update_coursePanel_jButton3_actionAdapter(Update_coursePanel adaptee) {
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
        adaptee.jButton3_actionPerformed(e);
    }
}
class Update_coursePanel_btn_select_actionAdapter implements ActionListener {
    private Update_coursePanel adaptee;
    Update_coursePanel_btn_select_actionAdapter(Update_coursePanel adaptee) {
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
        adaptee.btn_select_actionPerformed(e);
    }
}

类18：Update_grapePanel

package cvit.com.view;
import javax.swing.JPanel;
import java.awt.Color;
import javax.swing.JTextField;
import java.awt.Rectangle;
import javax.swing.JButton;
import javax.swing.JLabel;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.JOptionPane;
import cvit.com.manager.GradeManager;
import cvit.com.model.Grade;
import javax.swing.JComboBox;
import java.util.Vector;
import cvit.com.manager.StudentManager;
import cvit.com.manager.CourseManager;
import java.awt.event.ItemEvent;
import java.awt.event.ItemListener;
import cvit.com.model.Course;
//修改分数
public class Update_gradePanel extends JPanel {
    public Update_gradePanel() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }
    private void jbInit() throws Exception {
        this.setLayout(null);
        this.setBackground(new Color(168, 233, 216));
        btn_update.setBounds(new Rectangle(145, 238, 78, 23));
        btn_update.setText("修改");
        btn_update.addActionListener(new
                Update_gradePanel_btn_update_actionAdapter(this));
        btn_exit.setBounds(new Rectangle(232, 239, 71, 23));
        btn_exit.setText("退出");
        btn_exit.addActionListener(new Update_gradePanel_btn_exit_actionAdapter(this));
        jLabel1.setText("学号");
        jLabel1.setBounds(new Rectangle(62, 45, 42, 15));
        jLabel2.setText("成绩");
        jLabel2.setBounds(new Rectangle(62, 193, 58, 15));
        t2.setEnabled(false);
        t2.setBounds(new Rectangle(136, 144, 77, 20));
        jLabel3.setText("课程编号");
        jLabel3.setBounds(new Rectangle(55, 146, 62, 15));
        t3.setEnabled(false);
        t3.setBounds(new Rectangle(144, 193, 77, 20));
        btn_select.setBounds(new Rectangle(55, 237, 81, 23));
        btn_select.setText("查询");
        btn_select.addActionListener(new
                Update_gradePanel_btn_select_actionAdapter(this));
        jcb_sno.setBounds(new Rectangle(135, 43, 98, 23));
        jcb_sno.addItemListener(new Update_gradePanel_jcb_sno_itemAdapter(this));
        jcb_cname.setBounds(new Rectangle(137, 96, 101, 23));
        jcb_cname.addItemListener(new Update_gradePanel_jcb_cname_itemAdapter(this));
        jLabel4.setText("课程名称");
        jLabel4.setBounds(new Rectangle(60, 99, 56, 15));
        this.add(btn_update);
        this.add(btn_select);
        this.add(btn_exit);
        this.add(t3);
        this.add(jLabel2);
        this.add(jLabel3);
        this.add(t2);
        this.add(jcb_cname);
        this.add(jcb_sno);
        this.add(jLabel1);
        this.add(jLabel4);
        Vector v=sm.selectStudent();                  //获得所有学号
        for (int i = 0; i < v.size(); i++) {
            jcb_sno.addItem(v.get(i).toString());     //将学号添加到下拉列表中
        }
        Vector v1=cm.selectCourse();                  //获得所有课程名称
        for (int i = 0; i < v1.size(); i++) {
            jcb_cname.addItem(v1.get(i).toString());  //将所有课程名称添加到下拉列表中
        }
        this.setVisible(true);
        this.setSize(600, 600);
    }
    JButton btn_update = new JButton();
    JButton btn_exit = new JButton();
    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JTextField t2 = new JTextField();
    JLabel jLabel3 = new JLabel();
    JTextField t3 = new JTextField();
    JButton btn_select = new JButton();
    JComboBox jcb_sno = new JComboBox();
    StudentManager sm = new StudentManager();
    CourseManager cm = new CourseManager();
    JComboBox jcb_cname = new JComboBox();
    JLabel jLabel4 = new JLabel();
    public void btn_exit_actionPerformed(ActionEvent e) {
        this.setVisible(false);
    }
    public void btn_select_actionPerformed(ActionEvent e) {
        String sno = jcb_sno.getSelectedItem().toString();
        String cno = t2.getText();
        GradeManager gm = new GradeManager();
        Grade g=gm.findGrade(sno, cno);                //调用按学号和课程编号查询选课方法
        if (g == null) {
            JOptionPane.showMessageDialog(this, "与学生实际选课不符，请核对！",
                    "提示信息", JOptionPane.INFORMATION_MESSAGE);
        } else {
            t2.setEnabled(false);
            t3.setEnabled(true);
            t2.setText(g.getCno());
            t3.setText(g.getGrade());
        }
    }
    public void btn_update_actionPerformed(ActionEvent e) {
        String sno = jcb_sno.getSelectedItem().toString();
        String cno = t2.getText();
        String grade = t3.getText();
        GradeManager gm = new GradeManager();
        int i=gm.updateGrade(sno, cno, grade);         //调用修改成绩方法
        if (i > 0) {
            JOptionPane.showMessageDialog(this, "修改成功！", "提示信息",
                    JOptionPane.INFORMATION_MESSAGE);
        } else {
            JOptionPane.showMessageDialog(this, "修改失败！", "提示信息",
                    JOptionPane.ERROR_MESSAGE);
        }
    }
    public void jcb_cname_itemStateChanged(ItemEvent e) {
        //调用按课程名称查询课程信息方法
        Course c = cm.findOneCourse(jcb_cname.getSelectedItem().toString());
        t2.setText(c.getCno());
    }
    public void jcb_sno_itemStateChanged(ItemEvent e) {
    }
}
class Update_gradePanel_jcb_sno_itemAdapter implements ItemListener {
    private Update_gradePanel adaptee;
    Update_gradePanel_jcb_sno_itemAdapter(Update_gradePanel adaptee) {
        this.adaptee = adaptee;
    }
    public void itemStateChanged(ItemEvent e) {
        adaptee.jcb_sno_itemStateChanged(e);
    }
}
class Update_gradePanel_jcb_cname_itemAdapter implements ItemListener {
    private Update_gradePanel adaptee;
    Update_gradePanel_jcb_cname_itemAdapter(Update_gradePanel adaptee) {
        this.adaptee = adaptee;
    }
    public void itemStateChanged(ItemEvent e) {
        adaptee.jcb_cname_itemStateChanged(e);
    }
}
class Update_gradePanel_btn_update_actionAdapter implements ActionListener {
    private Update_gradePanel adaptee;
    Update_gradePanel_btn_update_actionAdapter(Update_gradePanel adaptee) {
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
        adaptee.btn_update_actionPerformed(e);
    }
}
class Update_gradePanel_btn_select_actionAdapter implements ActionListener {
    private Update_gradePanel adaptee;
    Update_gradePanel_btn_select_actionAdapter(Update_gradePanel adaptee) {
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
        adaptee.btn_select_actionPerformed(e);
    }
}
class Update_gradePanel_btn_exit_actionAdapter implements ActionListener {
    private Update_gradePanel adaptee;
    Update_gradePanel_btn_exit_actionAdapter(Update_gradePanel adaptee) {
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
        adaptee.btn_exit_actionPerformed(e);
    }
}

类19：Update_studentPanel

package cvit.com.view;
import javax.swing.JPanel;
import javax.swing.JLabel;
import java.awt.Rectangle;
import javax.swing.JTextField;
import java.awt.Color;
import javax.swing.JButton;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import cvit.com.manager.StudentManager;
import cvit.com.model.Student;
import javax.swing.JOptionPane;
//修改学生信息
public class Update_studentPanel extends JPanel {
    public Update_studentPanel() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }
    private void jbInit() throws Exception {
        this.setLayout(null);
        jLabel1.setText("专业");
        jLabel1.setBounds(new Rectangle(188, 154, 42, 15));
        jLabel2.setText("民族");
        jLabel2.setBounds(new Rectangle(184, 75, 42, 15));
        tsno.setBounds(new Rectangle(79, 33, 77, 20));
        tscollege.setEnabled(false);
        tscollege.setBounds(new Rectangle(79, 153, 77, 20));
        jLabel3.setText("学号");
        jLabel3.setBounds(new Rectangle(15, 36, 42, 15));
        jLabel4.setText("姓名");
        jLabel4.setBounds(new Rectangle(187, 35, 42, 15));
        jLabel5.setText("学院");
        jLabel5.setBounds(new Rectangle(15, 154, 42, 15));
        tsmajor.setEnabled(false);
        tsmajor.setBounds(new Rectangle(251, 156, 77, 20));
        tsname.setEnabled(false);
        tsname.setBounds(new Rectangle(250, 32, 77, 20));
        jLabel6.setText("性别");
        jLabel6.setBounds(new Rectangle(14, 74, 42, 15));
        tstime.setEnabled(false);
        tstime.setBounds(new Rectangle(251, 111, 77, 20));
        tssex.setEnabled(false);
        tssex.setBounds(new Rectangle(77, 73, 77, 20));
        jLabel7.setText("入学时间");
        jLabel7.setBounds(new Rectangle(175, 112, 67, 15));
        tsbirth.setEnabled(false);
        tsbirth.setBounds(new Rectangle(79, 111, 77, 20));
        tshome.setEnabled(false);
        tshome.setBounds(new Rectangle(77, 198, 251, 20));
        jLabel8.setText("籍贯");
        jLabel8.setBounds(new Rectangle(16, 197, 42, 15));
        tsethnix.setEnabled(false);
        tsethnix.setBounds(new Rectangle(251, 73, 77, 20));
        jLabel9.setText("出生日期");
        jLabel9.setBounds(new Rectangle(12, 112, 53, 15));
        this.setBackground(new Color(168, 233, 216));
        btn_select.setBounds(new Rectangle(30, 241, 81, 23));
        btn_select.setText("查找");
        btn_select.addActionListener(new Update_studentPanel_btn_select_actionAdapter(this));
        btn_update.setBounds(new Rectangle(140, 240, 81, 23));
        btn_update.setText("修改");
        btn_update.addActionListener(new
                Update_studentPanel_btn_update_actionAdapter(this));
        btn_exit.setBounds(new Rectangle(267, 239, 81, 23));
        btn_exit.setText("退出");
        btn_exit.addActionListener(new
                Update_studentPanel_btn_exit_actionAdapter(this));
        this.add(jLabel1);
        this.add(jLabel2);
        this.add(tsno);
        this.add(tscollege);
        this.add(jLabel3);
        this.add(jLabel4);
        this.add(jLabel5);
        this.add(tsmajor);
        this.add(tsname);
        this.add(jLabel6);
        this.add(tstime);
        this.add(tssex);
        this.add(jLabel7);
        this.add(tsbirth);
        this.add(tshome);
        this.add(jLabel8);
        this.add(tsethnix);
        this.add(jLabel9);
        this.add(btn_select);
        this.add(btn_update);
        this.add(btn_exit);
        this.setVisible(true);                             //设置窗体可见性
        this.setSize(600, 600);                             //设置窗体大小
    }
    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JTextField tsno = new JTextField();
    JTextField tscollege = new JTextField();
    JLabel jLabel3 = new JLabel();
    JLabel jLabel4 = new JLabel();
    JLabel jLabel5 = new JLabel();
    JTextField tsmajor = new JTextField();
    JTextField tsname = new JTextField();
    JLabel jLabel6 = new JLabel();
    JTextField tstime = new JTextField();
    JTextField tssex = new JTextField();
    JLabel jLabel7 = new JLabel();
    JTextField tsbirth = new JTextField();
    JTextField tshome = new JTextField();
    JLabel jLabel8 = new JLabel();
    JTextField tsethnix = new JTextField();
    JLabel jLabel9 = new JLabel();
    JButton btn_select = new JButton();
    JButton btn_update = new JButton();
    JButton btn_exit = new JButton();
    public void btn_select_actionPerformed(ActionEvent e) {
        String sno=tsno.getText().trim();                       //获得学号文本框中的内容
        StudentManager sm=new StudentManager();                 //定义学生管理的对象sm
        Student s=sm.findStudent(sno);                          //调用学生管理中的按学号查询方法
        //对话框
        if (s == null) {
            JOptionPane.showMessageDialog(this, "没有该用同学！", "提示信息",
                    JOptionPane.INFORMATION_MESSAGE);
            tsno.setText("");                                    //清空文本框
        } else {
            //设置文本框是否可用false为不可用、true为可用
            tsno.setEnabled(false);
            tsname.setEnabled(true);
            tssex.setEnabled(true);
            tsethnix.setEnabled(true);
            tshome.setEnabled(true);
            tstime.setEnabled(true);
            tsmajor.setEnabled(true);
            tscollege.setEnabled(true);
            tsbirth.setEnabled(true);
            tsno.setText(s.getSno());
            tsname.setText(s.getSname());
            tssex.setText(s.getSsex());
            tsethnix.setText(s.getSethnix());
            tshome.setText(s.getShome());
            tstime.setText(s.getSyear());
            tsmajor.setText(s.getSmajor());
            tscollege.setText(s.getScollege());
            tsbirth.setText(s.getSbirth());
        }
    }
    public void btn_update_actionPerformed(ActionEvent e) {
        String sno=tsno.getText();                                 //获得学号文本框中的内容作为学号
        String sname = tsname.getText();
        String ssex = tssex.getText();
        String sethnix = tsethnix.getText();
        String shome = tshome.getText();
        String syear = tstime.getText();
        String smajor = tsmajor.getText();
        String scollege = tscollege.getText();
        String sbirth = tsbirth.getText();
        StudentManager sm=new StudentManager();                    //定义学生管理对象sm
        int i=sm.update_Student(sno, sname, ssex, sethnix, shome, syear,    //调用修改学生信息方法
                smajor, scollege, sbirth);
        if (i > 0) {
            JOptionPane.showMessageDialog(this, "修改成功！", "提示信息",
                    JOptionPane.INFORMATION_MESSAGE);
            tsno.setEnabled(true);                                 //设置文本框的可用性
            tsname.setEnabled(false);
            tssex.setEnabled(false);
            tsethnix.setEnabled(false);
            tshome.setEnabled(false);
            tstime.setEnabled(false);
            tsmajor.setEnabled(false);
            tscollege.setEnabled(false);
            tsbirth.setEnabled(false);
            tsno.setText("");                                      //清空文本框内容
            tsname.setText("");
            tssex.setText("");
            tsethnix.setText("");
            tshome.setText("");
            tstime.setText("");
            tsmajor.setText("");
            tscollege.setText("");
            tsbirth.setText("");
        } else {
            JOptionPane.showMessageDialog(this, "修改失败！", "提示信息",
                    JOptionPane.ERROR_MESSAGE);
        }
    }
    //退出按钮关闭窗体
    public void btn_exit_actionPerformed(ActionEvent e) {
        this.setVisible(false);
    }
}
class Update_studentPanel_btn_exit_actionAdapter implements ActionListener {
    private Update_studentPanel adaptee;
    Update_studentPanel_btn_exit_actionAdapter(Update_studentPanel adaptee) {
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
        adaptee.btn_exit_actionPerformed(e);
    }
}
class Update_studentPanel_btn_update_actionAdapter implements ActionListener {
    private Update_studentPanel adaptee;
    Update_studentPanel_btn_update_actionAdapter(Update_studentPanel adaptee) {
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
        adaptee.btn_update_actionPerformed(e);
    }
}
class Update_studentPanel_btn_select_actionAdapter implements ActionListener {
    private Update_studentPanel adaptee;
    Update_studentPanel_btn_select_actionAdapter(Update_studentPanel adaptee) {
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
        adaptee.btn_select_actionPerformed(e);
    }
}

作者：bingo冰冰