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

已于 2024-01-12 16:06:29 修改
阅读量480 收藏 11
点赞数 8
分类专栏： Java 文章标签： 数据库 课程设计 java mysql 大作业 用户界面
于 2024-01-12 15:58:43 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_72986432/article/details/135554989
版权

本篇属于上篇【学生选课与成绩管理系统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冰冰
关注
  • 8
    点赞
  • 踩
  • 11
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 1
    评论
专栏目录
期末大作业【学生选课与成绩管理系统1】Java+MySQL数据库+可视化图形界面
weixin_72986432的博客
01-11 598
此项目包含学生信息管理、成绩管理、学生选课、教师课程信息管理等丰富功能
数据库大作业（学生信息管理系统）PHP+MySQL实现增删改查
热门推荐
weixin_45631954的博客
05-19 1万+
提示：文章写完后，目录可以自动生成，如何生成可参考右边的帮助文档 文章目录前言一、文件目录二、管理员界面相关代码（PHP+CSS）1.admin.php2.admin.css三、增加功能四、删除功能(delete.php)五、多选删除功能（checkdelete.php）六、修改功能（insert.php）七、查询功能（search.php）八、数据库内容 前言 提示：本文采用PHP对数据库进行操作： 本文就介绍了PHP实现对MySQL数据库的增删改查操作基础内容。 提示：以下是本篇文章正文内容，下面
基于Eclipse+Java+Swing+Mysql实现学生成绩管理系统
Timi2019的博客
06-17 472
学生：登陆、成绩浏览管理员：登陆、班级添加、班级维护、学生添加、学生维护。
基于Java+Swing+mysql实现图书借阅管理系统--期末大作业（含实训报告）
Timi2019的博客
12-27 4340
图书借阅与归还也是系统中较为关键的业务，读者需要根据自己的需求借阅自己想要阅读的图书，此时就需要图书的借阅功能，功能展开，我们需要最为关键的读者信息、借阅的图书信息，以及借书的日期，然后增加到借书的数据库中。当读者阅读完这本书或者到达了阅读的最长期限，用户必须要归还图书，当前模块需要一个归还功能，根据借阅图书的ISBN或者图书id进行归还，具体就是在借阅的书籍列表中进行删除，把书籍的借阅信息删除。图书信息管理是图书借阅系统最核心的功能，因为图书是最关键的要素， 在系统中有着所有图书的相关信息。
基于JavaWeb的学生成绩管理系统设计与实现
毕业作品网站
10-04 3222
该系统主要建立一个基于B/S模式的学生成绩信息管理系统，用户和管理员不需要下载客户端就可以通过浏览器访问学生管理系统，快捷方便，从网页获取当前的学生信息，及时的更新信息，修改信息，保证信息的正确性和时效性，从而更好、更快捷、更便利的管理学 生信息，本文转载自http://www.biyezuopin.vip/onews.asp?本课题为学校成绩管理系统，目的在于可以让教师更方便、快捷的增添、删除、修改学生的相关信息，让学生能够更加方便的查询自己的选课及课程成绩情况，并且支持管理员的后台信息管理。
javaweb基于ssm框架学生信息管理(成绩)系统设计与实现（项目源码+报告设计说明）
weixin_40228600的博客
06-20 1667
1 开发环境及所用知识体系 4 1.1 开发平台、开发工具、应用服务器的介绍 4 2 系统需求 4 2.1 系统总体需求说明 4 2.2 系统流程图 4 2.3 功能结构图 5 3 技术选型 6 3.1 所使用技术的简要介绍 6 4 功能模块 8 4.1 学生信息维护 8 4.1.1 数据库设计 8 4.1.2 模块功能及流程图 8 4.1.3 程序层次结构 9 4.1.4 程序界面截图及说明 12 4.1.5 主要代码及说明 13 4.2 教师信息维护 17 4.2.1 数据库设计 17 4.2.2 模块
基于spring+springmvc+mybatis+mysql学生成绩管理系统
Timi2019的博客
12-29 156
系统主要功能：学生：课程列表、已选课程、已修课程老师：我的课程、课程打分系统管理员：课程管理、学生管理、教师管理。
基于Java+Swing+Mysql实现人事管理信息系统
Timi2019的博客
06-18 969
系统功能：用户登陆、用户注册、员工信息添加、员工信息删除、员工信息查询、员工信息修改、部门管理、员工考核运行环境：idea/eclipse/mysql5.7以上。
Java+Swing可视化图像处理软件
qq_33037637的博客
05-20 1615
Java+Swing可视化图像处理软件一、系统介绍二、功能展示1.图片裁剪2.图片缩放3.图片旋转4.图像灰度处理5.图像变形6.图像扭曲7.图像移动三、系统实现1.ImageProcessing.java四、其它1.其他系统实现2.获取源码 一、系统介绍 该系统实现了图片裁剪、缩放、旋转、图像灰度处理、变形、扭曲、保存、移动。 二、功能展示 1.图片裁剪 2.图片缩放 3.图片旋转 4.图像灰度处理 5.图像变形 6.图像扭曲 7.图像移动 三、系统实现 1.ImageProcessing.
期末大作业【学生选课与成绩管理系统】Java+MySQL数据库+可视化图形界面
01-12
期末大作业【学生选课与成绩管理系统】Java+MySQL数据库+可视化图形界面
webjsp期末大作业-教务选课管理系统.zip
07-07
网站很好看，风格蓝色简洁大方，网页上还带有echarts图表(柱状图和饼图)，动态可视化，网站完整，可注册用户，查看用户信息，学生可选课并查看课程信息，还带有统计本人课程的图表。教师用户可查看所有的课程，查看...
基于微信小程序的学生选课系统（包括源码，数据库，教程）.zip
07-21
毕业设计、期末大作业、课程设计、高分必看，下载下来，简单部署，就可以使用。 包含：项目源码、数据库脚本、软件工具等，该项目可以作为毕设、课程设计使用，前后端代码都在里面。 该系统功能完善、界面美观、...
【MySQL精通之路】SQL优化(1)-查询优化(1)-WHERE子句
Anakki的博客
05-22 643
与PRIMARY KEY或UNIQUE索引上的WHERE子句一起使用的表，其中所有索引部分都与常量表达式进行比较，并定义为NOT NULL。由于MySQL会自动进行类似的优化，因此您通常可以避免这项工作，并将查询保留为更易于理解和维护的形式。因为MySQL优化器的开发工作还在进行中，所以这里并没有记录MySQL优化器所有的优化。您可能会试图重写查询以加快算术运算，同时牺牲可读性。，这有助于简化join连接。有关更多信息和示例，请参见“有关更多信息，请参见“空表或只有一行的表。
Linux文件操作——实现cp指令以及模拟修改配置文件
shion1114的博客
05-23 342
cp 1.c 2.c功能是将(内容相同，实现拷贝)main函数的参数由编译结果可知，总共有三个输入参数，同时输出每个参数字符串内容。
Mongodb分布式id
最新发布
littleschemer的博客
05-25 669
分布式ID是指在分布式系统中用于唯一标识每个元素的数字或字符串。本文主要讲解mongodb分布式id的解决方案，并从实际测试代码验证产生的id在不同集合是否也是保证全局唯一。
《Python编程从入门到实践》day36
m0_37565294的博客
05-22 1770
我们要编写一个名为“学习笔记”的Web应用程序，让用户能够记录感兴趣的主题，并在学习每个主题的过程中添加日志条目。django-admin startproject learning_log . # 新建一个名为learning_log的项目，末尾的句点让新项目使用合适的目录结构。运行命令ls，其输出表明Django有创建一个db.sqlite3.SQLite使用一种使用单个文件的数据库。# 包含4个文件（settings.py、urls.py、wsgi.py、__init__.py）
Redis 完整
m0_73173239的博客
05-24 828
什么是 redis?是一种基于键值对的 NoSql 型数据库。与 hashMap 不同的是，Redis 中的 value 支持 string（字符串）、hash（哈希）、 list（列表）、set（集合）、zset（有序集合）、Bitmaps（位图）、GEO（地理信息定位）等多种数据结构。而 HashMap 只是 redis 中的 hash ，他们俩结构是相同的。
数据访问与Spring Data JPA
无远弗届
05-25 523
假设我们要处理一个用户表（users），可以创建一个User@Entity // 标识这是一个实体类 public class User {@Id // 标识这是主键字段 @GeneratedValue(strategy = GenerationType . AUTO) // 主键生成策略 private Long id;// Getter 和 Setter ... }@Entity // 标识这是一个实体类 public class User {
java数据库课程设计学生选课管理系统
05-12
Java数据库课程设计学生选课管理系统是一种基于Java语言和数据库技术的选课管理系统，旨在方便学校进行学生选课管理，并优化学生选课体验。该系统主要由前端和后端两部分构成，前端采用了Java Swing技术，实现了界面的设计和用户交互；后端则采用了Java Servlet + MySQL技术，实现了数据的存储和管理。 该系统的基本功能包括学生选课，教师授课管理，课程信息管理等。在学生选课方面，学生可以在系统中浏览课程列表，查看课程详情，并进行选课操作；在教师授课管理方面，教师可以在系统中管理自己教授的课程信息，进行成绩录入等操作；在课程信息管理方面，管理员可以对课程信息进行添加、修改、删除等操作，以保证课程信息的及时、准确、完整。 该系统的设计具有良好的可扩展性和可维护性，可以根据学校的需求进行二次开发和定制化。同时，该系统的运行效率高，操作简单易懂，提高了选课管理的效率和精度，为学生选择适合自己的课程提供了便利，为教师授课和成绩管理提供了实时的监控和支持。总之，Java数据库课程设计学生选课管理系统是一种现代化、高效率、可靠性和易用性的选课管理系统，是学校信息化建设的重要组成部分。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

bingo冰冰

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值