数据库教学管理系统

用递归、非递归两种方法遍历二叉树数据库原理课程设计专业：计算机科学与技术班级：计算机（2）班指导教师：****名：**学号：************目录一、概述 (01)二、需求分析 (02)三、数据逻辑设计 (05)四、软件功能设计 (06)五、程序源代码 (07)六、结束语 (41)一、概述1：项目背景教学管理作为学校管理的一个重要方面，其可变因素多，管理方面繁琐复杂，时间跨度大，再加上其固有的基数大，因而形成了巨大的数据量。

这些数据就是有用的信息，信息化对学生个人提出了驾驭和掌握最新信息技术的素质要求；信息技术提供了对教学进行重大革新的新手段;信息化也为提高教学质量,提高管理水平,工作效率创造了有效途径. 校园网信息系统建设的重要性越来越为成人高校所重视。

2：编写目的该文档编写的目的主要有以下几点：（1）、为软件的编码提供参考（2）、为软件的使用者提供参考（3）、为软件测试提供参考3：软件定义该软件是一款用于学校相关人员对学校日常教学的管理，其中包括对课程、选课、学生、班级、教师、成绩等相关内容的管理，具有学生管理、成绩管理、班级管理、教师管理、课程管理等相关功能的小型数据库管理应用系统。

4：开发环境数据库：SQL Server 2005代码编写工具：Eclipse绘图工具：Microsoft Word二、需求分析1.需求分析的任务需求分析的任务是调查应用领域，对应用领域中的信息要求和操作要求进行详细分析，形成需求分析说明书。

重点是调查，收集与分析用户在数据管理中的信息要求，处理要求，数据的安全性与完整性要求。

为了完成需求分析的任务，要详细调查待开发的数据库应用部门的情况，了解原系统工作概况，分析用户的各种需求，在此基础上确定新系统的功能。

[4]新系统必须考虑今后的扩充和改变，不能仅仅按当前应用需求来设计数据库。

2.需要完成的功能1)反映教学组织机构的总体状况。

本教学管理系统主要由教师管理系统，学生管理系统以及领导管理系统等组成。

2)使管理者熟悉各部门的业务活动状况。

调查各部门的业务活动情况，对现行管理信息有一个明确的认识。

3)使管理者可以完成对学生成绩表的浏览、查询和修改。

4)使管理者可以完成对教师授课情况等个方面的详细信息的修改和查询。

5)使管理者可以完成对各部门领导相关信息的查询和修改。

3.数据字典4. E-R模型图三、数据库逻辑设计E-R图转换成的关系图四、软件功能设计五、程序源代码（注：实际应用系统为英文版，java语言编写）1.程序中类的设计：Course_Frame：这个是学生信息系统添加信息框架类courseBean：实现基本方法的课程类coursemanageframe：学生课程表信息系统的入口框架类From_course：课程表存储类From_Leader：领导存储类From_mark：学生表存储类From_student：学生存储类From_Teacher：教师存储类Leader_Frame：领导添加信息框架类leaderBean：领导类模型leadermanageframe：领导信息系统的入口框架类login：登陆界面类Mark_Frame：学生分数添加信息框架类markBean：实现基本方法的分数表类markmanageframe：学生分数表信息系统入口框架类PDA_Frame：主界面类，实现各个系统界面Show_Course：学生课程系统框架类Show_Leader：领导信息系统框架类Show_Mark：学生分数系统框架类Show_Student：学生信息系统框架类Show_Teacher：教师信息系统框架类Student_Frame：学生添加信息框架类studentBean：学生类模型studentmanageframe：学生信息系统的入口框架类Teacher_Frame：教师添加信息框架类teacherBean：教师类模型teachermanageframe：教师信息系统的入口框架类2.程序中各个类的核心代码（由于代码比较多，所以在此只写出了一些核心代码，由于有些类大同小异，比如学生类，老师类和领导类等，其中一些类以学生类为例子）：1.程序中类的设计：public class login extends JPanel {static final int WIDTH = 400;static final int HEIGHT = 250;JFrame loginframe;public static void main(String[] args) {login log = new login();}public void add(Component c, GridBagConstraints constraints, int x, int y, int w, int h) {constraints.gridx = x;constraints.gridy = y;constraints.gridwidth = w;constraints.gridheight = h;add(c, constraints);}login() {loginframe = new JFrame("HeBei United University Teaching Management System");loginframe.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);GridBagLayout lay = new GridBagLayout();setLayout(lay);loginframe.add(this, BorderLayout.WEST);loginframe.setSize(WIDTH, HEIGHT);Toolkit kit = Toolkit.getDefaultToolkit();Dimension screenSize = kit.getScreenSize();int width = screenSize.width;int height = screenSize.height;int x = (width - WIDTH) / 2;int y = (height - HEIGHT) / 2;loginframe.setLocation(x, y);JButton ok = new JButton("Login");JButton cancel = new JButton("Give up");JLabel title = new JLabel("Administrator login");JLabel name = new JLabel("Administrator name");JLabel password = new JLabel("Password");final JTextField nameinput = new JTextField(15);final JTextField passwordinput = new JPasswordField(15);GridBagConstraints constraints = new GridBagConstraints();constraints.fill = GridBagConstraints.NONE;constraints.anchor = GridBagConstraints.EAST;constraints.weightx = 3;constraints.weighty = 4;add(title, constraints, 0, 0, 4, 1); // 使用网格组布局添加控件add(name, constraints, 0, 1, 1, 1);add(password, constraints, 0, 2, 1, 1);add(nameinput, constraints, 2, 1, 1, 1);add(passwordinput, constraints, 2, 2, 1, 1);add(ok, constraints, 1, 3, 1, 1);add(cancel, constraints, 2, 3, 1, 1);loginframe.setResizable(true);loginframe.setVisible(true);ok.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent Event) {String nametext = nameinput.getText();String passwordtext = passwordinput.getText();String str = new String(passwordtext);boolean x = (nametext.equals("张江"));boolean y = (str.equals("333")); // 在此设置密码和用户名boolean z = (x && y);if (z == true) {loginframe.dispose();PDA_Frame main = new PDA_Frame(); // 此界面就是后面的主界面System.out.println("welcome to Teaching Management System!");} else if (z == false) {nameinput.setText("");passwordinput.setText("");}}});cancel.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent Event) {loginframe.dispose();}});}}class PDA_Frame extends JFrame {static final int WIDTH = 400;static final int HEIGHT = 200;JFrame buttonframe;public PDA_Frame() {buttonframe = new JFrame();buttonframe.setTitle("Teaching Management System");buttonframe.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);buttonframe.setSize(WIDTH, HEIGHT);Toolkit kit = Toolkit.getDefaultToolkit();Dimension screenSize = kit.getScreenSize();int width = screenSize.width;int height = screenSize.height;int x = (width - WIDTH) / 2;int y = (height - HEIGHT) / 2;this.setBackground(Color.red);buttonframe.setLocation(x, y);buttonframe.setVisible(true);buttonframe.setForeground(Color.blue);JButton student = new JButton("Student information management system");JButton mark = new JButton("Student mark system");JButton course = new JButton("Student course system");JButton teacher = new JButton("Teacher information system");JButton leader = new JButton("Leader information system");buttonframe.add(student);buttonframe.add(mark);buttonframe.add(course);buttonframe.add(teacher);buttonframe.add(leader);buttonframe.setLayout(new GridLayout(5, 1));student.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent Event) {studentmanageframe studentframe = new studentmanageframe();}});teacher.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent Event) {teachermanageframe teacherframe = new teachermanageframe();}});leader.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent Event) {leadermanageframe leaderframe = new leadermanageframe();}});mark.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent Event) {markmanageframe markframe = new markmanageframe();}});course.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent Event) {coursemanageframe courseframe = new coursemanageframe();}});}}class studentmanageframe extends JPanel {private static final long serialVersionUID = 1L;static final int WIDTH = 400;static final int HEIGHT = 200;JFrame studentframe;public studentmanageframe() {studentframe = new JFrame();studentframe.setBackground(Color.black);studentframe.setTitle("Student informatin management system");studentframe.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);studentframe.setSize(WIDTH, HEIGHT);Toolkit kit = Toolkit.getDefaultToolkit();Dimension screenSize = kit.getScreenSize();int width = screenSize.width;int height = screenSize.height;int x = (width - WIDTH) / 2;int y = (height - HEIGHT) / 2;studentframe.setLocation(x, y);studentframe.setVisible(true);studentframe.setResizable(false);studentframe.add(this, BorderLayout.CENTER);JButton computerone = new JButton("Computer No.1");JButton computertwo = new JButton("Computer No.2");JButton computerthree = new JButton("Computer No.3");JButton bioone = new JButton("Legal No.1");JButton mechone = new JButton("Legal No.2");JButton mechtwo = new JButton("Mathematics No.1");JButton mechthree = new JButton("Mathematics No.2");JLabel banket1 = new JLabel();JLabel banket2 = new JLabel();GridBagLayout lay = new GridBagLayout();setLayout(lay);GridBagConstraints constraints = new GridBagConstraints();constraints.fill = GridBagConstraints.NONE;constraints.anchor = GridBagConstraints.EAST;constraints.weightx = 2;constraints.weighty = 5;JPanel jp = new JPanel();jp.setLayout(new GridLayout(1, 3));jp.add(banket1);jp.add(banket2);studentframe.add(jp, BorderLayout.NORTH);add(computerone, constraints, 0, 1, 1, 1);add(computertwo, constraints, 0, 2, 1, 1);add(computerthree, constraints, 0, 3, 1, 1);add(bioone, constraints, 0, 4, 1, 1);add(mechone, constraints, 1, 1, 1, 1);add(mechtwo, constraints, 1, 2, 1, 1);add(mechthree, constraints, 1, 3, 1, 1);/ /单击这个按钮，进入到计算机系二班学生信息系统computerone.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent Event) {String sql = "select * from studentinfo where grade='一班' and major='计算机系'";Show_Student info = new Show_Student("sutdent basic information 0f computer No.1 ", sql);}});/ /单击这个按钮，进入到计算机系二班学生信息系统computertwo.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent Event) {String sql = "select * from studentinfo where grade='二班'and major='计算机系'";Show_Student studentinformation = new Show_Student("sutdent basic information 0f computer No.2",sql);}});/ /单击这个按钮，进入到计算机系三班学生信息系统computerthree.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent Event) {String sql = "select * from studentinfo where grade='三班' and major='计算机系'";Show_Student studentinformation = new Show_Student("sutdent basic information 0f computer No.3",sql);}});/ /单击这个按钮，进入到法律系一班学生信息系统bioone.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent Event) {String sql = "select * from studentinfo where grade ='一班'and major='法律系'";Show_Student studentinformation = new Show_Student("sutdent basic information 0f legal No.1",sql);}});/ /单击这个按钮，进入到法律系二班学生信息系统mechone.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent Event) {String sql = "select * from studentinfo where grade='二班'and major='法律系'";Show_Student studentinformation = new Show_Student("sutdent basic information 0f legal No.2",sql);}});/ /单击这个按钮，进入数学系一班学生信息系统mechtwo.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent Event) {String sql = "select * from studentinfo where grade='一班'and major='数学系'";Show_Student studentinformation = new Show_Student("sutdent basic information 0f mathematics No.1",sql);}});/ /单击这个按钮，数学系二班学生信息系统mechthree.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent Event) {String sql = "select * from studentinfo where grade='二班'and major='数学系'";Show_Student studentinformation = new Show_Student("sutdent basic information 0f mathematics No.2",sql);}});}public void add(Component c, GridBagConstraints constraints, int x, int y, int w, int h) {constraints.gridx = x;constraints.gridy = y;constraints.gridwidth = w;constraints.gridheight = h;add(c, constraints);}}class teachermanageframe extends JPanel {private static final long serialVersionUID = 1L;static final int WIDTH = 400;static final int HEIGHT = 200;JFrame teacherframe;public teachermanageframe() {teacherframe = new JFrame();teacherframe.setTitle("Teacher information management system");teacherframe.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);teacherframe.setSize(WIDTH, HEIGHT);Toolkit kit = Toolkit.getDefaultToolkit();Dimension screenSize = kit.getScreenSize();int width = screenSize.width;int height = screenSize.height;int x = (width - WIDTH) / 2;int y = (height - HEIGHT) / 2;teacherframe.setLocation(x, y);teacherframe.setVisible(true);teacherframe.setResizable(false);teacherframe.add(this, BorderLayout.CENTER);JButton computerteacher = new JButton("Computer department");JButton bioteacher = new JButton("Legal department");JButton mechteacher = new JButton("Mathematics department");JButton beretun = new JButton("Return");JLabel banket1 = new JLabel();JLabel banket2 = new JLabel();GridBagLayout lay = new GridBagLayout();setLayout(lay);GridBagConstraints constraints = new GridBagConstraints();constraints.fill = GridBagConstraints.NONE;constraints.anchor = GridBagConstraints.EAST;constraints.weightx = 1;constraints.weighty = 4;JPanel jp = new JPanel();jp.setLayout(new GridLayout(1, 3));jp.add(banket1);jp.add(banket2);teacherframe.add(jp, BorderLayout.NORTH);add(computerteacher, constraints, 0, 1, 1, 1);add(bioteacher, constraints, 0, 4, 1, 1);add(mechteacher, constraints, 1, 1, 1, 1);/ /单击这个按钮，进入到计算机系教师信息系统computerteacher.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent Event) {String sql = "select * from teacherinfo where duty = '教师' and major='计算机系'";// String sql="select * from teacherinfo where duty='教师'and// major='英语系'";Show_Teacher teacherinformation = new Show_Teacher("Computer department teacher information system",sql);}});/ /单击这个按钮，进入到法律系教师信息系统bioteacher.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent Event) {String sql = "select * from teacherinfo where duty = '教师' and major='法律系'";Show_Teacher teacherinformation = new Show_Teacher("Legal department teacher information system",sql);}});/ /单击这个按钮，进入到数学系教师信息系统mechteacher.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent Event) {String sql = "select * from teacherinfo where duty = '教师' and major='数学系'";Show_Teacher teacherinformation = new Show_Teacher("Mathematics department teacher information system",sql);}});}public void add(Component c, GridBagConstraints constraints, int x, int y, int w, int h) {constraints.gridx = x;constraints.gridy = y;constraints.gridwidth = w;constraints.gridheight = h;add(c, constraints);}}class leadermanageframe extends JPanel {private static final long serialVersionUID = 1L;static final int WIDTH = 400;static final int HEIGHT = 200;JFrame leaderframe;public leadermanageframe() {leaderframe = new JFrame();leaderframe.setTitle("Department leader information management system");leaderframe.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);leaderframe.setSize(WIDTH, HEIGHT);Toolkit kit = Toolkit.getDefaultToolkit();Dimension screenSize = kit.getScreenSize();int width = screenSize.width;int height = screenSize.height;int x = (width - WIDTH) / 2;int y = (height - HEIGHT) / 2;leaderframe.setLocation(x, y);leaderframe.setVisible(true);leaderframe.setResizable(false);leaderframe.add(this, BorderLayout.CENTER);JButton computerleader = new JButton("Computer department");JButton bioleader = new JButton("Legal department");JButton mechleader = new JButton("Mathematics department");JButton schoolleader = new JButton("School leadership");JLabel banket1 = new JLabel();JLabel banket2 = new JLabel();GridBagLayout lay = new GridBagLayout();setLayout(lay);GridBagConstraints constraints = new GridBagConstraints();constraints.fill = GridBagConstraints.NONE;constraints.anchor = GridBagConstraints.EAST;constraints.weightx = 2;constraints.weighty = 2;JPanel jp = new JPanel();jp.setLayout(new GridLayout(1, 3));jp.add(banket1);jp.add(banket2);leaderframe.add(jp, BorderLayout.NORTH);add(computerleader, constraints, 0, 0, 1, 1); // 使用网格组布局添加控件add(bioleader, constraints, 0, 1, 1, 1);add(mechleader, constraints, 1, 0, 1, 1);add(schoolleader, constraints, 1, 1, 1, 1);/ /单击这个按钮，进入到计算机系领导信息系统computerleader.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent Event) {String sql = "select * from leaderinfo where duty='主任'and major='计算机系'";Show_Leader leaderinformation = new Show_Leader("Computer department leader information system", sql);}});/ /单击这个按钮，进入到法律系领导信息系统bioleader.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent Event) {String sql = "select * from leaderinfo where duty='主任' and major='法律系'";Show_Leader leaderinformation = new Show_Leader("Legal department leader information system", sql);}});/ /单击这个按钮，进入到数学系领导信息系统mechleader.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent Event) {String sql = "select * from leaderinfo where duty='主任'and major='数学系'";Show_Leader leaderinformation = new Show_Leader("Mathematics department leader information system", sql);}});/ /单击这个按钮，进入到学校领导信息系统schoolleader.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent Event) {String sql = "select * from leaderinfo where duty='主任'and major='学校'";Show_Leader leaderinformation = new Show_Leader("学校领导信息系统", sql);}});}public void add(Component c, GridBagConstraints constraints, int x, int y, int w, int h) {constraints.gridx = x;constraints.gridy = y;constraints.gridwidth = w;constraints.gridheight = h;add(c, constraints);}}class markmanageframe extends JPanel {private static final long serialVersionUID = 1L;static final int WIDTH = 400;static final int HEIGHT = 200;JFrame markframe;public markmanageframe() {markframe = new JFrame();markframe.setBackground(Color.black);markframe.setTitle("Student mark management system");markframe.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);markframe.setSize(WIDTH, HEIGHT);Toolkit kit = Toolkit.getDefaultToolkit();Dimension screenSize = kit.getScreenSize();int width = screenSize.width;int height = screenSize.height;int x = (width - WIDTH) / 2;int y = (height - HEIGHT) / 2;markframe.setLocation(x, y);markframe.setVisible(true);markframe.setResizable(false);markframe.add(this, BorderLayout.CENTER);JButton computerone = new JButton("Mark of computer No.1");JButton computertwo = new JButton("Mark of computer No.2");JButton computerthree = new JButton("Mark of computer No.3");JButton bioone = new JButton("Mark of legal No.1");JButton mechone = new JButton("Mark of legal No.2");JButton mechtwo = new JButton("Mark of mathematics No.1");JButton mechthree = new JButton("Mark of mathematics No.2");JLabel banket1 = new JLabel();JLabel banket2 = new JLabel();GridBagLayout lay = new GridBagLayout();setLayout(lay);GridBagConstraints constraints = new GridBagConstraints();constraints.fill = GridBagConstraints.NONE;constraints.anchor = GridBagConstraints.EAST;constraints.weightx = 2;constraints.weighty = 5;JPanel jp = new JPanel();jp.setLayout(new GridLayout(1, 3));jp.add(banket1);jp.add(banket2);markframe.add(jp, BorderLayout.NORTH);add(computerone, constraints, 0, 1, 1, 1); // 使用网格组布局添加控件add(computertwo, constraints, 0, 2, 1, 1);add(computerthree, constraints, 0, 3, 1, 1);add(bioone, constraints, 0, 4, 1, 1);add(mechone, constraints, 1, 1, 1, 1);add(mechtwo, constraints, 1, 2, 1, 1);add(mechthree, constraints, 1, 3, 1, 1);/ /单击这个按钮，进入到计算机系一班学生分数信息系统computerone.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent Event) {String sql = "select * from markinfo where grade='一班' and major='计算机系'";Show_Mark info = new Show_Mark("Mark system of computerNo.1", sql);}});/ /单击这个按钮，进入到计算机系二班学生分数信息系统computertwo.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent Event) {String sql = "select * from markinfo where grade='二班'and major='计算机系'";Show_Mark markinformation = new Show_Mark("Mark system of computer No.2",sql);}});/ /单击这个按钮，进入到计算机系三班学生分数信息系统computerthree.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent Event) {String sql = "select * from markinfo where grade='三班' and major='计算机系'";Show_Mark markinformation = new Show_Mark("Mark system of computer No.3",sql);}});/ /单击这个按钮，进入到法律系一班学生分数信息系统bioone.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent Event) {String sql = "select * from markinfo where grade ='一班'and major='法律系'";Show_Mark markinformation = new Show_Mark("Mark system of Legal No.1",sql);}});/ /单击这个按钮，进入到法律系二班学生分数信息系统mechone.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent Event) {String sql = "select * from markinfo where grade='二班'and major='法律系'";Show_Mark markinformation = new Show_Mark("Mark system of legal No.2",sql);}});/ /单击这个按钮，进入数学系一班学生分数信息系统mechtwo.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent Event) {String sql = "select * from markinfo where grade='一班'and major='数学系'";Show_Mark markinformation = new Show_Mark("Mark system of Mathematics No.1",sql);}});/ /单击这个按钮，数学系二班学生分数信息系统mechthree.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent Event) {String sql = "select * from markinfo where grade='二班'and major='数学系'";Show_Mark markinformation = new Show_Mark("Mark system of mathematics No.1",sql);}});}public void add(Component c, GridBagConstraints constraints, int x, int y, int w, int h) {constraints.gridx = x;constraints.gridy = y;constraints.gridwidth = w;constraints.gridheight = h;add(c, constraints);}}class coursemanageframe extends JPanel {private static final long serialVersionUID = 1L;static final int WIDTH = 400;static final int HEIGHT = 200;JFrame courseframe;public coursemanageframe() {courseframe = new JFrame();courseframe.setBackground(Color.black);courseframe.setTitle("Student Course Management System"); courseframe.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); courseframe.setSize(WIDTH, HEIGHT);Toolkit kit = Toolkit.getDefaultToolkit();Dimension screenSize = kit.getScreenSize();int width = screenSize.width;int height = screenSize.height;int x = (width - WIDTH) / 2;int y = (height - HEIGHT) / 2;courseframe.setLocation(x, y);courseframe.setVisible(true);courseframe.setResizable(false);courseframe.add(this, BorderLayout.CENTER);JButton computerone = new JButton("Computer No.1");JButton computertwo = new JButton("Computer No.2");JButton computerthree = new JButton("Computer No.3");JButton bioone = new JButton("Legal No.1");JButton mechone = new JButton("Legal No.2");JButton mechtwo = new JButton("Mathematics No.1");JButton mechthree = new JButton("Mathematics No.2");JLabel banket1 = new JLabel();JLabel banket2 = new JLabel();GridBagLayout lay = new GridBagLayout();setLayout(lay);GridBagConstraints constraints = new GridBagConstraints(); constraints.fill = GridBagConstraints.NONE;constraints.anchor = GridBagConstraints.EAST;constraints.weightx = 2;constraints.weighty = 5;JPanel jp = new JPanel();jp.setLayout(new GridLayout(1, 3));jp.add(banket1);jp.add(banket2);courseframe.add(jp, BorderLayout.NORTH);add(computerone, constraints, 0, 1, 1, 1); // 使用网格组布局添加控件add(computertwo, constraints, 0, 2, 1, 1);add(computerthree, constraints, 0, 3, 1, 1);add(bioone, constraints, 0, 4, 1, 1);add(mechone, constraints, 1, 1, 1, 1);add(mechtwo, constraints, 1, 2, 1, 1);add(mechthree, constraints, 1, 3, 1, 1);/ /单击这个按钮，进入到计算机系一班学生课程信息系统computerone.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent Event) {String sql = "select * from courseinfo where grade='一班' and major='计算机系'";Show_Course info = new Show_Course("Student course information system of computer No.1", sql);}});/ /单击这个按钮，进入到计算机系二班学生课程信息系统computertwo.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent Event) {String sql = "select * from courseinfo where grade='二班'and major='计算机系'";Show_Course courseinformation = new Show_Course("Student course information system of computer No.2",sql);}});// /单击这个按钮，进入到计算机系三班学生课程信息系统computerthree.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent Event) {String sql = "select * from courseinfo where grade='三班' and major='计算机系'";Show_Course courseinformation = new Show_Course("Student course information system of computer No.3",sql);}});// /单击这个按钮，进入到法律系一班学生课程信息系统bioone.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent Event) {String sql = "select * from courseinfo where grade ='一班'and major='法律系'";Show_Course courseinformation = new Show_Course("Student course information system of legal No.1",sql);}});// /单击这个按钮，进入到法律系二班学生课程信息系统mechone.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent Event) {String sql = "select * from courseinfo where grade='二班'and major='法律系'";Show_Course courseinformation = new Show_Course("Studentcourse information system of legal No.2",sql);}});// /单击这个按钮，进入数学系一班学生课程信息系统mechtwo.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent Event) {String sql = "select * from courseinfo where grade='一班'and major='数学系'";Show_Course courseinformation = new Show_Course("Student course information system of mathematics No.1",sql);}});// /单击这个按钮，数学系二班学生课程信息系统mechthree.addActionListener(new ActionListener() {public void actionPerformed(ActionEvent Event) {String sql = "select * from courseinfo where grade='二班'and major='数学系'";Show_Course courseinformation = new Show_Course("Student course information system of mathematics No.2",sql);}});}public void add(Component c, GridBagConstraints constraints, int x, int y, int w, int h) {constraints.gridx = x;constraints.gridy = y;constraints.gridwidth = w;constraints.gridheight = h;add(c, constraints);}}class From_student {public Vector getstudent(Connection con, String sql) {Vector v = new Vector();try {Statement st = con.createStatement();ResultSet rs = st.executeQuery(sql);。