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

一、项目效果展示

本项目包含丰富子项目，涵盖增删改查和swing等基础java知识，Java+MySQL数据库+可视化图形界面，适用于初学者实战学习。

功能：①学籍信息管理 ②选课系统 ③教师课程信息管理 ④学生成绩管理。

代码经过精心调试，运行完全无误后发布。一共四个包，27个类，四个数据库表。如不想复制粘贴，也可以在我的Java专栏中下载本资源。

（一）总体功能结构图

本学生成绩管理系统的具体功能为三个模块和十五个子功能模块。下图为系统的总体功能结构图，如图 1-1 所示。

（二）界面演示

（三）项目结构目录

src包下建立四个package，每个package下创建相应的类名：

（四）开发环境

（1）操作系统：Windows 11
（2）数据库：MySQL
（3）开发环境：IDEA
（4）开发语言：Java

（五）项目结构

学生管理模块

• 1 添加学生界面
• 2 修改学生信息
• 3 删除学生信息
• 4 学生选课界面
• 5 查询学生信息

课程管理模块

• 1 添加课程信息
• 2 修改课程信息
• 3 删除课程信息
• 4 课程查询

成绩管理模块

• 1 录入成绩
• 2 修改成
• 3 查询成绩

（六）图形界面

添加界面：

修改界面

删除界面

选课界面

查询界面

添加课程

修改课程

删除课程

课程查询

录入成绩

修改成绩

查询成绩

二、数据库

建库

建立一个名为yybtest的数据库，下面新建4个数据表

建表

course表

grade表

student表

studenttab表

三、源代码

manager包

CourseManager类

package cvit.com.manager;
import cvit.com.manager.*;
import cvit.com.pub.DBConn;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.Connection;
import cvit.com.model.Course;
import java.sql.SQLException;
import java.util.Vector;
//课程管理类
public class CourseManager {
    //添加课程信息
    public int addCourse(Course c) {
        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;
        DBConn db = new DBConn();
        conn = db.getConn();
        int i = 0;
        String sql = "insert into course values('" + c.getCno()+ "', '" +
                c.getCname() + "', '" + c.getCteacher() +"', '" +
                c.getCtype() + "', '" + c.getCplace() +"', '" + c.getCtime() +"')";
        try {
            stmt = conn.createStatement();
            i = stmt.executeUpdate(sql);
            stmt.close();
            conn.close();
        } catch (Exception e1) {
            e1.printStackTrace();
        }
        return i;
    }
    //删除课程信息
    public int deleteCourse(String cno) {
        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;
        DBConn db = new DBConn();
        conn = db.getConn();
        int i = 0;
        String sql = "delete from course where cno='" + cno +"'";
        try {
            stmt = conn.createStatement();
            i = stmt.executeUpdate(sql);
            stmt.close();
            conn.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
        return i;
    }
    //修改课程信息
    public int update_Course(String cno, String cname, String cteacher,
                             String ctype, String cplace, String ctime)
    {
        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;
        DBConn db = new DBConn();
        conn = db.getConn();
        int i = 0;
        String sql = "update course set cname='" + cname +"', cteacher='"+
                cteacher + "', ctype='" + ctype +"', cplace='"+
                cplace + "', ctime='" + ctime + "' wherecno='" + cno +"'";
        try {
            stmt = conn.createStatement();
            i = stmt.executeUpdate(sql);
            stmt.close();
            conn.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
        return i;
    }
    //根据课程编号查询课程信息
    public Course findCourse(String cno) {
        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;
        String sql = "select *from course where cno='" + cno +"'";
        Course c = null;
        DBConn db = new DBConn();
        conn = db.getConn();
        try {
            stmt = conn.createStatement();
            rs = stmt.executeQuery(sql);
            if (rs.next()) {
                c = new Course();
                c.setCno(rs.getString("cno"));
                c.setCname(rs.getString("cname"));
                c.setCteacher(rs.getString("cteacher"));
                c.setCtype(rs.getString("ctype"));
                c.setCplace(rs.getString("cplace"));
                c.setCtime(rs.getString("ctime"));
            }
            rs.close();
            stmt.close();
            conn.close();
        }
        catch (SQLException ex3) {
            ex3.printStackTrace();
        }
        return c;
    }
    //根据课程名称查询课程信息
    public Course findCourse_name(String cname) {
        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;
        String sql = "select *from course where cname='" + cname+"'";
        Course c = null;
        DBConn db = new DBConn();
        conn = db.getConn();
        try {
            stmt = conn.createStatement();
            rs = stmt.executeQuery(sql);
            if (rs.next()) {
                c = new Course();
                c.setCno(rs.getString("cno"));
                c.setCname(rs.getString("cname"));
                c.setCteacher(rs.getString("cteacher"));
                c.setCtype(rs.getString("ctype"));
                c.setCplace(rs.getString("cplace"));
                c.setCtime(rs.getString("ctime"));
            }
            rs.close();
            stmt.close();
            conn.close();
        }
        catch (SQLException ex3) {
            ex3.printStackTrace();
        }
        return c;
    }
    //根据教师名称查询课程信息
    public Course findCourse_teacher(String cteacher) {
        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;
        String sql = "select *from course where cteacher='" +cteacher + "'";
        Course c = null;
        DBConn db = new DBConn();
        conn = db.getConn();
        try {
            stmt = conn.createStatement();
            rs = stmt.executeQuery(sql);
            if (rs.next()) {
                c = new Course();
                c.setCno(rs.getString("cno"));
                c.setCname(rs.getString("cname"));
                c.setCteacher(rs.getString("cteacher"));
                c.setCtype(rs.getString("ctype"));
                c.setCplace(rs.getString("cplace"));
                c.setCtime(rs.getString("ctime"));
            }
            rs.close();
            stmt.close();
            conn.close();
        }
        catch (SQLException ex3) {
            ex3.printStackTrace();
        }
        return c;
    }
    //查询全部课程名称
    public Vector selectCourse() {
        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;
        DBConn db = new DBConn();
        conn = db.getConn();
        String sql = "select cname from course";
        Vector v = new Vector();
        try {
            stmt = conn.createStatement();
            rs = stmt.executeQuery(sql);
            while (rs.next()) {
                v.add(rs.getString("cname"));
            }
            rs.close();
            stmt.close();
            conn.close();
        } catch (Exception em) {
            em.printStackTrace();
            System.out.println("sql有错");
        }
        return v;
    }
    //获得全部教师名称
    public Vector selectCourse2() {
        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;
        DBConn db = new DBConn();
        conn = db.getConn();
        String sql = "select cteacher from course";
        Vector v = new Vector();
        try {
            stmt = conn.createStatement();
            rs = stmt.executeQuery(sql);
            while (rs.next()) {
                v.add(rs.getString("cteacher"));
            }
            rs.close();
            stmt.close();
            conn.close();
        } catch (Exception em) {
            em.printStackTrace();
            System.out.println("sql有错");
        }
        return v;
    }
    //根据课程名称查询
    public Course findOneCourse(String cname) {
        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;
        DBConn db = new DBConn();
        conn = db.getConn();
        String sql ="select cno, cteacher, cplace, ctype, ctime from course where cname='" + cname + "'";
        Course c = null;
        try {
            stmt = conn.createStatement();
            rs = stmt.executeQuery(sql);
            if (rs.next()) {
                c = new Course();
                c.setCno(rs.getString("cno"));
                c.setCteacher(rs.getString("cteacher"));
                c.setCtype(rs.getString("ctype"));
                c.setCplace(rs.getString("cplace"));
                c.setCtime(rs.getString("ctime"));
            }
            rs.close();
            stmt.close();
            conn.close();
        } catch (Exception em) {
            em.printStackTrace();
            System.out.println("sql有错");
        }
        return c;
    }
    //根据教师名称查询
    public Course findOneCourse2(String cteacher) {
        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;
        DBConn db = new DBConn();
        conn = db.getConn();
        String sql ="select cno, cname, cplace, ctype, ctime from course where cteacher='" +cteacher + "'";
        Course c = null;
        try {
            stmt = conn.createStatement();
            rs = stmt.executeQuery(sql);
            if (rs.next()) {
                c = new Course();
                c.setCno(rs.getString("cno"));
                c.setCname(rs.getString("cname"));
                c.setCtype(rs.getString("ctype"));
                c.setCplace(rs.getString("cplace"));
                c.setCtime(rs.getString("ctime"));
            }
            rs.close();
            stmt.close();
            conn.close();
        } catch (Exception em) {
            em.printStackTrace();
            System.out.println("sql有错");
        }
        return c;
    }
}

GradeManager类

package cvit.com.manager;
import cvit.com.model.Grade;
import cvit.com.pub.DBConn;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.Connection;
import cvit.com.model.Grade;
import java.sql.SQLException;
import java.util.Vector;
import cvit.com.model.ZH;
//成绩管理类
public class GradeManager {
    //添加成绩
    public int addGrade(Grade g) {
        Connection conn=null;                    //连接数据库对象
        Statement stmt=null;                     //执行sql语句的对象
        ResultSet rs=null;                       //执行sql语句的返回结果
        DBConn db = new DBConn();
        conn = db.getConn();
        int i = 0;
        String sql = "update grade set grade='" + g.getGrade() + "'where sno='" +
                g.getSno() + "'and cno='" + g.getCno() + "'";
        try {
            stmt = conn.createStatement();
            i = stmt.executeUpdate(sql);
            stmt.close();
            conn.close();
        } catch (Exception e1) {
            e1.printStackTrace();
        }
        return i;   }
    //选课
    public int chooseCourse(String sno, String cno) {
        Connection conn=null;                    //连接数据库对象
        Statement stmt=null;                     //执行sql语句的对象
        ResultSet rs=null;                       //执行sql语句的返回结果
        DBConn db = new DBConn();
        conn = db.getConn();
        int i = 0;
        String sql = "insert into grade values('" + sno + "', '" + cno +"', ' ')";
        try {
            stmt = conn.createStatement();
            i = stmt.executeUpdate(sql);
            stmt.close();
            conn.close();
        } catch (Exception e1) {
            e1.printStackTrace();
        }
        return i;
    }
    //根据学号、课程名查询一个学生成绩
    public Grade findGrade(String sno, String cno) {
        Connection conn=null;                     //连接数据库对象
        Statement stmt=null;                      //执行sql语句的对象
        ResultSet rs=null;                        //执行sql语句的返回结果
        String sql = "select *from grade where sno='" + sno + "'and cno='" + cno + "'";
        Grade g = null;
        DBConn db = new DBConn();
        conn = db.getConn();
        try {
            stmt = conn.createStatement();
            rs = stmt.executeQuery(sql);
            if (rs.next()) {
                g = new Grade();
                g.setSno(rs.getString("sno"));
                g.setCno(rs.getString("cno"));
                g.setGrade(rs.getString("grade"));
            }
            rs.close();
            stmt.close();
            conn.close();
        }
        catch (SQLException ex3) {
            ex3.printStackTrace();
        }
        return g;
    }
    //修改成绩
    public int updateGrade(String sno, String cno, String grade) {
        Connection conn=null;                       //连接数据库对象
        Statement stmt=null;                        //执行sql语句的对象
        ResultSet rs=null;                          //执行sql语句的返回结果
        DBConn db = new DBConn();
        conn = db.getConn();
        int i = 0;
        String sql = "update grade set cno='" + cno + "', grade='" + grade +
                "' where sno='" + sno + "'";
        try {
            stmt = conn.createStatement();
            i = stmt.executeUpdate(sql);
            stmt.close();
            conn.close();
        } catch (Exception e1) {
            e1.printStackTrace();
        }
        return i;
    }
    //查询一个学生全部学科的成绩
    public Vector selectGradestudent(String sno) {

                Vector list = new Vector();
        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;
        DBConn db = new DBConn();
        conn = db.getConn();
        String sql = "select student.sno, sname, course.cno, cname, grade from student, course, grade where grade.sno='" + sno + "'";
        ZH zh = null;
        try {
            stmt = conn.createStatement();
            rs = stmt.executeQuery(sql);
            int i = 0;
            while (rs.next()) {
                zh = new ZH();
                zh.setCno(rs.getString("cno"));
                zh.setCname(rs.getString("cname"));
                zh.setGrade(rs.getString("grade"));
                list.add(zh);
            }
            rs.close();
            stmt.close();
            conn.close();
        } catch (Exception em) {
            em.printStackTrace();
            System.out.println("sql有错");
        }
        return list;
    }
}

StudentManager类

package cvit.com.manager;
import java.sql.ResultSet;
import cvit.com.pub.DBConn;
import java.sql.*;

import cvit.com.model.*;

import java.util.Vector;
//学生信息管理类
public class StudentManager {
    //添加学生信息
    public int addStudent(Student s) {
        Connection conn=null;                        //连接数据库对象
        Statement stmt=null;                         //执行sql语句的对象
        ResultSet rs=null;                           //执行sql语句的返回结果
        DBConn db = new DBConn();
        conn = db.getConn();
        int i = 0;
        String sql = "insert into student values('" + s.getSno() + "', '" +
                s.getSname() + "', '" + s.getSsex() + "', '" + s.getSethnix() +
                "', '" + s.getShome() + "', '" + s.getSyear() + "', '" +
                s.getSmajor() + "', '" + s.getScollege() + "', '" +
                s.getSbirth() + "')";
        try {
            stmt = conn.createStatement();
            i = stmt.executeUpdate(sql);
            stmt.close();
            conn.close();
        } catch (Exception e1) {
            e1.printStackTrace();
        }
        return i;
    }
    //删除学生信息
    public int deleteUser(String sno) {
        Connection conn=null;                        //连接数据库对象
        Statement stmt=null;                         //执行sql语句的对象
        ResultSet rs=null;                           //执行sql语句的返回结果
        DBConn db = new DBConn();
        conn = db.getConn();
        int i = 0;
        String sql = "delete from student where sno='" + sno + "'";
        try {
            stmt = conn.createStatement();
            i = stmt.executeUpdate(sql);
            stmt.close();
            conn.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
        return i;
    }
    //修改学生信息
    public int update_Student(String sno, String sname, String ssex,
                              String sethnix, String shome, String syear,
                              String smajor, String scollege, String sbirth) {
        Connection conn=null;                       //连接数据库对象
        Statement stmt=null;                         //执行sql语句的对象
        ResultSet rs=null;                           //执行sql语句的返回结果
        DBConn db = new DBConn();
        conn = db.getConn();
        int i = 0;
        String sql = "update student set sname='" + sname +"', ssex='" + ssex + "', sethnix='" + sethnix +"', shome='" + shome + "', syear='" + syear +"', smajor='" + smajor + "', scollege='" + scollege +"', sbirth='" + sbirth + "' where sno='" + sno + "'";
        try {
            stmt = conn.createStatement();
            i = stmt.executeUpdate(sql);
            stmt.close();
            conn.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
        return i;
    }
    //根据学号查询学生信息
    public Student findStudent(String sno) {
        Connection conn=null;                        //连接数据库对象
        Statement stmt=null;                         //执行sql语句的对象
        ResultSet rs=null;                           //执行sql语句的返回结果
        String sql = "select *from student where sno='" + sno + "'";
        Student s = null;
        DBConn db = new DBConn();
        conn = db.getConn();
        try {
            stmt = conn.createStatement();
            rs = stmt.executeQuery(sql);
            if (rs.next()) {
                s = new Student();
                s.setSno(rs.getString("sno"));
                s.setSname(rs.getString("sname"));
                s.setSsex(rs.getString("ssex"));
                s.setSethnix(rs.getString("sethnix"));
                s.setShome(rs.getString("shome"));
                s.setSyear(rs.getString("syear"));
                s.setSmajor(rs.getString("smajor"));
                s.setScollege(rs.getString("scollege"));
                s.setSbirth(rs.getString("sbirth"));
            }
            rs.close();
            stmt.close();
            conn.close();
        }
        catch (SQLException ex3) {
            ex3.printStackTrace();
        }
        return s;
    }
    //根据姓名查询学生信息
    public Student findStudentname(String sname) {
        Connection conn=null;                        //连接数据库对象
        Statement stmt=null;                         //执行sql语句的对象
        ResultSet rs=null;                           //执行sql语句的返回结果
        String sql = "select *from student where sname='" + sname + "'";
        Student s = null;
        DBConn db = new DBConn();
        conn = db.getConn();
        try {
            stmt = conn.createStatement();
            rs = stmt.executeQuery(sql);
            if (rs.next()) {
                s = new Student();
                s.setSno(rs.getString("sno"));
                s.setSname(rs.getString("sname"));
                s.setSsex(rs.getString("ssex"));
                s.setSethnix(rs.getString("sethnix"));
                s.setShome(rs.getString("shome"));
                s.setSyear(rs.getString("syear"));
                s.setSmajor(rs.getString("smajor"));
                s.setScollege(rs.getString("scollege"));
                s.setSbirth(rs.getString("sbirth"));
            }
            rs.close();
            stmt.close();
            conn.close();
        }
        catch (SQLException ex3) {
            ex3.printStackTrace();
        }
        return s;
    }
    //根据性别查询学生信息
    public Student findStudentsex(String ssex) {
        Connection conn=null;                        //连接数据库对象
        Statement stmt=null;                         //执行sql语句的对象
        ResultSet rs=null;                           //执行sql语句的返回结果
        String sql = "select *from student where ssex='" + ssex + "'";
        Student s = null;
        DBConn db = new DBConn();
        conn = db.getConn();
        try {
            stmt = conn.createStatement();
            rs = stmt.executeQuery(sql);
            if (rs.next()) {
                s = new Student();
                s.setSno(rs.getString("sno"));
                s.setSname(rs.getString("sname"));
                s.setSsex(rs.getString("ssex"));
                s.setSethnix(rs.getString("sethnix"));
                s.setShome(rs.getString("shome"));
                s.setSyear(rs.getString("syear"));
                s.setSmajor(rs.getString("smajor"));
                s.setScollege(rs.getString("scollege"));
                s.setSbirth(rs.getString("sbirth"));
            }
            rs.close();
            stmt.close();
            conn.close();
        }
        catch (SQLException ex3) {
            ex3.printStackTrace();
        }
        return s;
    }
    //根据专业查询学生信息
    public Student findStudenmajor(String smajor) {
        Connection conn=null;                        //连接数据库对象
        Statement stmt=null;                         //执行sql语句的对象
        ResultSet rs=null;                           //执行sql语句的返回结果
        String sql = "select *from student where smajor='" + smajor + "'";
        Student s = null;
        DBConn db = new DBConn();
        conn = db.getConn();
        try {
            stmt = conn.createStatement();
            rs = stmt.executeQuery(sql);
            if (rs.next()) {
                s = new Student();
                s.setSno(rs.getString("sno"));
                s.setSname(rs.getString("sname"));
                s.setSsex(rs.getString("ssex"));
                s.setSethnix(rs.getString("sethnix"));
                s.setShome(rs.getString("shome"));
                s.setSyear(rs.getString("syear"));
                s.setSmajor(rs.getString("smajor"));
                s.setScollege(rs.getString("scollege"));
                s.setSbirth(rs.getString("sbirth"));
            }
            rs.close();
            stmt.close();
            conn.close();
        }
        catch (SQLException ex3) {
            ex3.printStackTrace();
        }
        return s;
    }
    //按分院查询所有学生信息
    public Vector findStudentcollege(String scollege) {
        Connection conn=null;                        //连接数据库对象
        Statement stmt=null;                         //执行sql语句的对象
        ResultSet rs=null;                           //执行sql语句的返回结果
        Vector list = new Vector();
        DBConn db = new DBConn();
        conn = db.getConn();
        String sql = "select *from student where scollege='" + scollege + "'";
        Student s = null;
        try {
            stmt = conn.createStatement();
            rs = stmt.executeQuery(sql);
            int i = 0;
            while (rs.next()) {
                s = new Student();
                s.setSno(rs.getString("sno"));
                s.setSname(rs.getString("sname"));
                s.setSsex(rs.getString("ssex"));
                s.setSethnix(rs.getString("sethnix"));
                s.setShome(rs.getString("shome"));
                s.setSyear(rs.getString("syear"));
                s.setSmajor(rs.getString("smajor"));
                s.setScollege(rs.getString("scollege"));
                s.setSbirth(rs.getString("sbirth"));
                list.add(i,
                        s.getSno() + " " + s.getSname() + " " + s.getSsex() + " " +
                                s.getSethnix() + " " + s.getShome() + " " + s.getSyear() +
                                " " + s.getSmajor() + " " + s.getScollege() + " " +
                                s.getSbirth());
                i++;
            }
            rs.close();
            stmt.close();
            conn.close();
        } catch (Exception em) {
            em.printStackTrace();
            System.out.println("sql有错");
        }
        return list;
    }
    //获得全部分院名称
    public Vector selectStudentcollege() {
        Connection conn=null;                        //连接数据库对象
        Statement stmt=null;                         //执行sql语句的对象
        ResultSet rs=null;                           //执行sql语句的返回结果
        DBConn db = new DBConn();
        conn = db.getConn();
        String sql = "select scollege from student";
        Vector v = new Vector();
        try {
            stmt = conn.createStatement();
            rs = stmt.executeQuery(sql);
            while (rs.next()) {
                v.add(rs.getString("scollege"));
            }
            rs.close();
            stmt.close();
            conn.close();
        } catch (Exception em) {
            em.printStackTrace();
            System.out.println("sql有错");
        }
        return v;
    }
    //获得全部专业
    public Vector selectStudentmajor() {
        Connection conn=null;                        //连接数据库对象
        Statement stmt=null;                         //执行sql语句的对象
        ResultSet rs=null;                           //执行sql语句的返回结果
        DBConn db = new DBConn();
        conn = db.getConn();
        String sql = "select smajor from student";
        Vector v = new Vector();
        try {
            stmt = conn.createStatement();
            rs = stmt.executeQuery(sql);
            while (rs.next()) {
                v.add(rs.getString("smajor"));
            }
            rs.close();
            stmt.close();
            conn.close();
        } catch (Exception em) {
            em.printStackTrace();
            System.out.println("sql有错");
        }
        return v;
    }
    //按专业查询
    public Vector findStudentmajor(String smajor) {
        Connection conn=null;                        //连接数据库对象
        Statement stmt=null;                         //执行sql语句的对象
        ResultSet rs=null;                           //执行sql语句的返回结果
        Vector list = new Vector();
        DBConn db = new DBConn();
        conn = db.getConn();
        String sql = "select *from student where smajor='" + smajor + "'";
        Student s = null;
        try {
            stmt = conn.createStatement();
            rs = stmt.executeQuery(sql);
            int i = 0;
            while (rs.next()) {
                s = new Student();
                s.setSno(rs.getString("sno"));
                s.setSname(rs.getString("sname"));
                s.setSsex(rs.getString("ssex"));
                s.setSethnix(rs.getString("sethnix"));
                s.setShome(rs.getString("shome"));
                s.setSyear(rs.getString("syear"));
                s.setSmajor(rs.getString("smajor"));
                s.setScollege(rs.getString("scollege"));
                s.setSbirth(rs.getString("sbirth"));
                list.add(i,
                        s.getSno() + " " + s.getSname() + " " + s.getSsex() + " " +
                                s.getSethnix() + " " + s.getShome() + " " + s.getSyear() +
                                " " + s.getSmajor() + " " + s.getScollege() + " " +
                                s.getSbirth());
                i++;
            }
            rs.close();
            stmt.close();
            conn.close();
        } catch (Exception em) {
            em.printStackTrace();
            System.out.println("sql有错");
        }
        return list;
    }
    //按性别查询
    public Vector findStudentsex1(String ssex) {
        Connection conn=null;                        //连接数据库对象
        Statement stmt=null;                         //执行sql语句的对象
        ResultSet rs=null;                           //执行sql语句的返回结果
        Vector list = new Vector();
        DBConn db = new DBConn();
        conn = db.getConn();
        String sql = "select *from student where ssex='" + ssex + "'";
        Student s = null;
        try {
            stmt = conn.createStatement();
            rs = stmt.executeQuery(sql);
            int i = 0;
            while (rs.next()) {
                s = new Student();
                s.setSno(rs.getString("sno"));
                s.setSname(rs.getString("sname"));
                s.setSsex(rs.getString("ssex"));
                s.setSethnix(rs.getString("sethnix"));
                s.setShome(rs.getString("shome"));
                s.setSyear(rs.getString("syear"));
                s.setSmajor(rs.getString("smajor"));
                s.setScollege(rs.getString("scollege"));
                s.setSbirth(rs.getString("sbirth"));
                list.add(i,
                        s.getSno() + " " + s.getSname() + " " + s.getSsex() + " " +
                                s.getSethnix() + " " + s.getShome() + " " + s.getSyear() +
                                " " + s.getSmajor() + " " + s.getScollege() + " " +
                                s.getSbirth());
                i++;
            }
            rs.close();
            stmt.close();
            conn.close();
        } catch (Exception em) {
            em.printStackTrace();
            System.out.println("sql有错");
        }
        return list;
    }
    //按姓名查询
    public Vector find;
    Vector Student_name(String sname) {
        Connection conn=null;                        //连接数据库对象
        Statement stmt=null;                         //执行sql语句的对象
        ResultSet rs=null;                           //执行sql语句的返回结果
        Vector list = new Vector();
        DBConn db = new DBConn();
        conn = db.getConn();
        String sql = "select *from student where sname='" + sname + "'";
        Student s = null;
        try {
            stmt = conn.createStatement();
            rs = stmt.executeQuery(sql);
            int i = 0;
            while (rs.next()) {
                s = new Student();
                s.setSno(rs.getString("sno"));
                s.setSname(rs.getString("sname"));
                s.setSsex(rs.getString("ssex"));
                s.setSethnix(rs.getString("sethnix"));
                s.setShome(rs.getString("shome"));
                s.setSyear(rs.getString("syear"));
                s.setSmajor(rs.getString("smajor"));
                s.setScollege(rs.getString("scollege"));
                s.setSbirth(rs.getString("sbirth"));
                list.add(i,
                        s.getSno() + " " + s.getSname() + " " + s.getSsex() + " " +
                                s.getSethnix() + " " + s.getShome() + " " + s.getSyear() +
                                " " + s.getSmajor() + " " + s.getScollege() + " " +
                                s.getSbirth());
                i++;
            }
            rs.close();
            stmt.close();
            conn.close();
        } catch (Exception em) {
            em.printStackTrace();
            System.out.println("sql有错");
        }
        return list;
    }
    //查询全部
    public Vector selectStudent() {
        Connection conn=null;                        //连接数据库对象
        Statement stmt=null;                         //执行sql语句的对象
        ResultSet rs=null;                           //执行sql语句的返回结果
        DBConn db = new DBConn();
        conn = db.getConn();
        String sql = "select sno from student";
        Vector v = new Vector();
        try {
            stmt = conn.createStatement();
            rs = stmt.executeQuery(sql);
            while (rs.next()) {
                v.add(rs.getString("sno"));
            }
            rs.close();
            stmt.close();
            conn.close();
        } catch (Exception em) {
            em.printStackTrace();
            System.out.println("sql有错");
        }
        return v;
    }
    //通过学号查询全部
    public String findOneStudent(String sno) {
        Connection conn=null;                        //连接数据库对象
        Statement stmt=null;                         //执行sql语句的对象
        ResultSet rs=null;                           //执行sql语句的返回结果
        DBConn db = new DBConn();
        conn = db.getConn();
        String sql = "select sname from student where sno='" + sno + "'";
        String s = "";
        try {
            stmt = conn.createStatement();
            rs = stmt.executeQuery(sql);
            if (rs.next()) {
                s = rs.getString("sname");
            }
            rs.close();
            stmt.close();
            conn.close();
        } catch (Exception em) {
            em.printStackTrace();
            System.out.println("sql有错");
        }
        return s;
    }
}

model包

Course类

package cvit.com.model;    //包
//课程类
public class Course {
    public String cno;     //课程编号
    public String cname;   //课程名称
    public String cteacher;//任课教师
    public String ctype;   //科目类型
    public String cplace;  //上课地点
    public String ctime;   //上课时间
    //以下是set和get方法
    public void setCname(String cname) {
        this.cname = cname;
    }
    public void setCno(String cno) {
        this.cno = cno;
    }
    public void setCplace(String cplace) {
        this.cplace = cplace;
    }
    public void setCteacher(String cteacher) {
        this.cteacher = cteacher;
    }
    public void setCtime(String ctime) {
        this.ctime = ctime;
    }
    public void setCtype(String ctype) {
        this.ctype = ctype;
    }
    public String getCtype() {
        return ctype;
    }
    public String getCtime() {
        return ctime;
    }
    public String getCteacher() {
        return cteacher;
    }
    public String getCplace() {
        return cplace;
    }
    public String getCno() {
        return cno;
    }
    public String getCname() {
        return cname;
    }
}

Grade类

package cvit.com.model;
//成绩类
public class Grade {
    public String sno;    //学生学号
    public String cno;    //课程编号
    public String grade;  //成绩
    //以下是set和get方法
    public String getCno() {
        return cno;
    }
    public String getGrade() {
        return grade;
    }
    public String getSno() {
        return sno;
    }
    public void setCno(String cno) {
        this.cno = cno;
    }
    public void setGrade(String grade) {
        this.grade = grade;
    }
    public void setSno(String sno) {
        this.sno = sno;
    }
}

Student类

package cvit.com.model;//包
//学生类
public class Student {
    public String sno;       //学号
    public String sname;     //学生姓名
    public String ssex;      //学生性别
    public String sethnix;   //民族
    public String shome;     //籍贯
    public String syear;     //入学时间
    public String smajor;    //专业
    public String scollege;  //所在分院
    public String sbirth;    //出生日期
    //以下是set和get方法
    public String getSbirth() {
        return sbirth;
    }
    public String getScollege() {
        return scollege;
    }
    public String getSethnix() {
        return sethnix;
    }
    public String getShome() {
        return shome;
    }
    public String getSmajor() {
        return smajor;
    }
    public String getSname() {
        return sname;
    }
    public String getSno() {
        return sno;
    }
    public String getSsex() {
        return ssex;
    }
    public String getSyear() {
        return syear;
    }
    public void setSbirth(String sbirth) {
        this.sbirth = sbirth;
    }
    public void setScollege(String scollege) {
        this.scollege = scollege;
    }
    public void setSethnix(String sethnix) {
        this.sethnix = sethnix;
    }
    public void setShome(String shome) {
        this.shome = shome;
    }
    public void setSmajor(String smajor) {
        this.smajor = smajor;
    }
    public void setSname(String sname) {
        this.sname = sname;
    }
    public void setSno(String sno) {
        this.sno = sno;
    }
    public void setSsex(String ssex) {
        this.ssex = ssex;
    }
    public void setSyear(String syear) {
        this.syear = syear;
    }
}

ZH类

package cvit.com.model;
//综合查询类
public class ZH {
    public String sno;    //学生学号
    public String sname;  //学生姓名
    public String cno;    //课程编号
    public String cname;                      //课程名称
    public String grade;                      //成绩
    //以下是set和get方法
    public String getCname() {
        return cname;
    }
    public String getCno() {
        return cno;
    }
    public String getGrade() {
        return grade;
    }
    public String getSname() {
        return sname;
    }
    public String getSno() {
        return sno;
    }
    public void setCname(String cname) {
        this.cname = cname;
    }
    public void setCno(String cno) {
        this.cno = cno;
    }
    public void setGrade(String grade) {
        this.grade = grade;
    }
    public void setSname(String sname) {
        this.sname = sname;
    }
    public void setSno(String sno) {
        this.sno = sno;
    }
}

pub包

DBConn类

package cvit.com.pub;
import java.sql.*;
public class DBConn{                        //连接数据库
    private String driver = "com.mysql.jdbc.Driver";
    private String url = "jdbc:mysql://localhost:3306/yybtest";
    private Connection conn=null;           //连接数据库对象
    private String user="root";            //用户名
    private String pwd="x5";             //口令
    public Connection getConn() {
        try {
            Class.forName(driver);
        } catch (ClassNotFoundException ex) {
            System.out.println("加载驱动程序有错误，驱动程序类不存在");
        }
        try {
            conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/yybtest", "root", "x5");
        } catch (SQLException ex1) {
            System.out.print("取得连接的时候有错误，请核对用户名和密码");
        }
        return conn;
    }
    //测试是否连接数据库
    public static void main(String args[]) {
        DBConn db = new DBConn();
        Connection conn = db.getConn();
        System.out.println("Ok");
    }
}

view包

类1：AllgradePanel

package cvit.com.view;

public class AllgradePanel {
}

类2：StuMainFrame

package cvit.com.view;
import java.awt.*;
import java.awt.BorderLayout;
import javax.swing.JFrame;
import javax.swing.*;
import java.awt.event.*;
import java.awt.Dimension;
import java.awt.Font;
import cvit.com.view.*;
//系统主界面
public class StuMainFrame extends JFrame implements ActionListener {
    //定义菜单条
    JMenuBar mb = new JMenuBar();
    //定义菜单
    JMenu systemment = new JMenu("系统管理");
    JMenu studentment = new JMenu("学生管理");
    JMenu coursement = new JMenu("课程管理");
    JMenu gradement = new JMenu("成绩管理");
    JMenu informationment = new JMenu("信息查询");
    JMenu student_select = new JMenu("学生查询");
    JMenu course_select = new JMenu("课程查询");
    JMenu grade_select = new JMenu("成绩查询");
    JMenuItem exit = new JMenuItem("退出");
    JMenuItem student_add = new JMenuItem("增加");
    JMenuItem student_update = new JMenuItem("修改");
    JMenuItem student_delete = new JMenuItem("删除");
    JMenuItem student_choose = new JMenuItem("学生选课");
    JMenuItem course_add = new JMenuItem("课程增加");
    JMenuItem course_update = new JMenuItem("课程修改");
    JMenuItem course_delete = new JMenuItem("课程删除");
    JMenuItem grade_add = new JMenuItem("成绩增加");
    JMenuItem grade_update = new JMenuItem("成绩修改");
    JMenuItem select_no = new JMenuItem("按学号查询");
    JMenuItem select_name = new JMenuItem("按学生姓名查询");
    JMenuItem select_sex = new JMenuItem("按学生性别查询");
    JMenuItem select_major = new JMenuItem("按专业查询");
    JMenuItem select_college = new JMenuItem("按学院查询");
    JMenuItem select_cname = new JMenuItem("按课程名称查询");
    JMenuItem select_cteacher = new JMenuItem("按授课教师查询");
    JMenuItem select_allgrade = new JMenuItem("查询所有科目成绩");
    JPanel p = null;
    JTextField jtf1 = new JTextField();
    BorderLayout borderLayout1 = new BorderLayout();

    public StuMainFrame() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(borderLayout1);
        this.getContentPane().setBackground(new Color(168, 233, 216));
        this.setJMenuBar(mb);
        jtf1.setBackground(SystemColor.control);
        jtf1.setEnabled(false);
        jtf1.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        jtf1.setForeground(Color.cyan);
        jtf1.setSelectionColor(Color.black);
        //以下是向菜单条添加菜单项
        mb.add(systemment);
        mb.add(studentment);
        mb.add(coursement);
        mb.add(gradement);
        mb.add(informationment);
        //以下是向菜单中添加菜单项
        systemment.add(exit); //系统管理退出
        studentment.add(student_add);                //学生管理
        studentment.add(student_update);
        studentment.add(student_delete);
        studentment.add(student_choose);
        coursement.add(course_add);                  //课程管理
        coursement.add(course_update);
        coursement.add(course_delete);
        gradement.add(grade_add);                    //成绩管理
        gradement.add(grade_update);
        informationment.add(student_select);         //信息查询
        informationment.add(course_select);
        informationment.add(grade_select);
        //以下是向二级菜单中添加菜单项
        student_select.add(select_no);
        student_select.add(select_name);
        student_select.add(select_sex);
        student_select.add(select_major);
        student_select.add(select_college);
        course_select.add(select_cname);
        course_select.add(select_cteacher);
        grade_select.add(select_allgrade);
        this.getContentPane().add(jtf1, java.awt.BorderLayout.SOUTH);
        exit.addActionListener(this);
        //注册菜单监听
        student_add.addActionListener(this);          //添加学生信息
        student_update.addActionListener(this);       //修改学生信息
        student_delete.addActionListener(this);       //删除学生信息
        student_choose.addActionListener(this);       //学生选课
        course_add.addActionListener(this);           //添加课程信息
        course_update.addActionListener(this);        //修改课程信息
        course_delete.addActionListener(this);        //删除学生信息
        grade_add.addActionListener(this);            //添加成绩
        grade_update.addActionListener(this);         //修改成绩
        select_no.addActionListener(this);            //按学号查询
        select_major.addActionListener(this);         //按专业查询
        select_cname.addActionListener(this);         //按课程名称查询
        select_cteacher.addActionListener(this);      //按任课教师查询
        select_college.addActionListener(this);       //按学院查询
        select_sex.addActionListener(this);           //按性别查询
        select_name.addActionListener(this);          //按姓名查询
        select_allgrade.addActionListener(this);      //所有成绩
        //版权信息
        jtf1.setText("学生信息管理系统版由CVIT开发, 盗版必究! ");
        jtf1.setHorizontalAlignment(SwingConstants.CENTER);
        this.setTitle("学生信息管理系统");            //窗体名称
        this.setSize(600, 600);                        //大小
        this.setVisible(true);                        //可见性
        //以下为设置窗体居中
        //获得屏幕的宽和高
        Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
        //获得当前窗体的宽和高
        Dimension frameSize = this.getSize();
        //设置窗体居中
        if (frameSize.height > screenSize.height) {
            frameSize.height = screenSize.height;
        }
        if (frameSize.width > screenSize.width) {
            frameSize.width = screenSize.width;
        }
        this.setLocation((screenSize.width - frameSize.width) / 2,
                (screenSize.height - frameSize.height) / 2);
        this.setVisible(true);
    }

    public static void main(String[] args) {
        StuMainFrame sm = new StuMainFrame();
    }

    public void actionPerformed(ActionEvent e) {
        if (e.getSource() == exit) {                   //退出
            this.setVisible(false);
        }
        //添加学生信息
        if (e.getSource() == student_add) {
            if (p != null) {
                this.remove(p);
            }
            //定义一个添加学生信息页面的对象
            p = new Add_studentPanel();
            //将panel放在页面的中间
            this.getContentPane().add(p, java.awt.BorderLayout.CENTER);
            this.setVisible(true);
        }
        //修改学生信息
        if (e.getSource() == student_update) {
            if (p != null) {
                this.remove(p);
            }
            p = new Update_studentPanel();
            this.getContentPane().add(p, java.awt.BorderLayout.CENTER);
            this.setVisible(true);
        }
        //删除学生信息
        if (e.getSource() == student_delete) {
            if (p != null) {
                this.remove(p);
            }
            p = new Delete_studentPanel();
            this.getContentPane().add(p, java.awt.BorderLayout.CENTER);
            this.setVisible(true);
        }
        //学生选课
        if (e.getSource() == student_choose) {
            if (p != null) {
                this.remove(p);
            }
            p = new Student_choosePanel();
            this.getContentPane().add(p, java.awt.BorderLayout.CENTER);
            this.setVisible(true);
        }
        //添加课程信息
        if (e.getSource() == course_add) {
            if (p != null) {
                this.remove(p);
            }
            p = new Add_coursePanel();
            this.getContentPane().add(p, java.awt.BorderLayout.CENTER);
            this.setVisible(true);
        }
        //修改课程信息
        if (e.getSource() == course_update) {
            if (p != null) {
                this.remove(p);
            }
            p = new Update_coursePanel();
            this.getContentPane().add(p, java.awt.BorderLayout.CENTER);
            this.setVisible(true);
        }
        //删除课程信息
        if (e.getSource() == course_delete) {
            if (p != null) {
                this.remove(p);
            }
            p = new Delete_coursePanel();
            this.getContentPane().add(p, java.awt.BorderLayout.CENTER);
            this.setVisible(true);
        }
        //成绩添加
        if (e.getSource() == grade_add) {
            if (p != null) {
                this.remove(p);
            }
            p = new Add_gradePanel();
            this.getContentPane().add(p, java.awt.BorderLayout.CENTER);
            this.setVisible(true);
        }
        //成绩修改
        if (e.getSource() == grade_update) {
            if (p != null) {
                this.remove(p);
            }
            p = new Update_gradePanel();
            this.getContentPane().add(p, java.awt.BorderLayout.CENTER);
            this.setVisible(true);
        }
        //按学号查询
        if (e.getSource() == select_no) {
            if (p != null) {
                this.remove(p);
            }
            p = new Select_studentnoPanel1();
            this.getContentPane().add(p, java.awt.BorderLayout.CENTER);
            this.setVisible(true);
        }
        //按分院查询
        if (e.getSource() == select_college) {
            if (p != null) {
                this.remove(p);
            }
            p = new Select_studentcollegePanel();
            this.getContentPane().add(p, java.awt.BorderLayout.CENTER);
            this.setVisible(true);
        }
        //按专业查询
        if (e.getSource() == select_major) {
            if (p != null) {
                this.remove(p);
            }
            p = new Select_studentmajorPanel1();
            this.getContentPane().add(p, java.awt.BorderLayout.CENTER);
            this.setVisible(true);
        }
        //按课程名称查询
        if (e.getSource() == select_cname) {
            if (p != null) {
                this.remove(p);
            }
            p = new Select_coursecnamePanel();
            this.getContentPane().add(p, java.awt.BorderLayout.CENTER);
            this.setVisible(true);
        }
        //按任课教师查询
        if (e.getSource() == select_cteacher) {
            if (p != null) {
                this.remove(p);
            }
            p = new Select_coursecteacherPanel1();
            this.getContentPane().add(p, java.awt.BorderLayout.CENTER);
            this.setVisible(true);
        }
        //按学生姓名查询
        if (e.getSource() == select_name) {
            if (p != null) {
                this.remove(p);
            }
            p = new Select_studentnamePanel();
            this.getContentPane().add(p, java.awt.BorderLayout.CENTER);
            this.setVisible(true);
        }
        //按性别查询
        if (e.getSource() == select_sex) {
            if (p != null) {
                this.remove(p);
            }
            p = new Select_studentsexPanel();
            this.getContentPane().add(p, java.awt.BorderLayout.CENTER);
            this.setVisible(true);
        }
        //查询所有科目成绩
        if (e.getSource() == select_allgrade) {
            if (p != null) {
                this.remove(p);
            }
            p = new Select_gradestudentPanel1();
            this.getContentPane().add(p, java.awt.BorderLayout.CENTER);
            this.setVisible(true);
        }
    }
}

类3：Add_coursePanel

package cvit.com.view;
import cvit.com.manager.CourseManager;
import cvit.com.model.Course;
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 javax.swing.JOptionPane;
import cvit.com.manager.CourseManager;
//添加课程
public class Add_coursePanel extends JPanel {
    public Add_coursePanel() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }
    private void jbInit() throws Exception {
        this.setLayout(null);
        this.setBackground(new Color(168, 233, 216));
        btn_add.setBounds(new Rectangle(37, 182, 81, 23));
        btn_add.setText("添加");
        btn_add.addActionListener(new Add_coursePanel_btn_add_actionAdapter(this));
        btn_null.setBounds(new Rectangle(153, 182, 81, 23));
        btn_null.setText("清空");
        btn_null.addActionListener(new Add_coursePanel_btn_null_actionAdapter(this));
        btn_exit.setBounds(new Rectangle(267, 182, 81, 23));
        btn_exit.setText("退出");
        btn_exit.addActionListener(new Add_coursePanel_btn_exit_actionAdapter(this));
        jLabel1.setText("课程类别");
        jLabel1.setBounds(new Rectangle(198, 87, 62, 15));
        jLabel2.setToolTipText("");
        jLabel2.setText("授课教师");
        jLabel2.setBounds(new Rectangle(19, 89, 53, 15));
        tctime.setBounds(new Rectangle(265, 123, 77, 20));
        tcno.setBounds(new Rectangle(93, 45, 77, 20));
        tteacher.setBounds(new Rectangle(91, 85, 77, 20));
        jLabel3.setText("上课时间");
        jLabel3.setBounds(new Rectangle(199, 124, 57, 15));
        jLabel4.setText("课程编码");
        jLabel4.setBounds(new Rectangle(20, 47, 65, 15));
        jLabel5.setText("课程名称");
        jLabel5.setBounds(new Rectangle(201, 47, 60, 15));
        tcplace.setBounds(new Rectangle(93, 123, 77, 20));
        tctype.setBounds(new Rectangle(265, 85, 77, 20));
        tcname.setBounds(new Rectangle(264, 44, 77, 20));
        jLabel6.setText("上课地点");
        jLabel6.setBounds(new Rectangle(19, 124, 67, 15));
        this.add(tteacher);
        this.add(jLabel1);
        this.add(tctime);
        this.add(tcno);
        this.add(jLabel3);
        this.add(jLabel5);
        this.add(tcplace);
        this.add(tctype);
        this.add(tcname);
        this.add(jLabel6);
        this.add(jLabel4);
        this.add(btn_null);
        this.add(btn_add);
        this.add(btn_exit);
        this.add(jLabel2);
        this.setVisible(true);               //窗体可见性
        this.setSize(600, 600);               //设置窗体大小
    }
    JButton btn_add = new JButton();
    JButton btn_null = new JButton();
    JButton btn_exit = new JButton();
    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JTextField tctime = new JTextField();
    JTextField tcno = new JTextField();
    JTextField tteacher = new JTextField();
    JLabel jLabel3 = new JLabel();
    JLabel jLabel4 = new JLabel();
    JLabel jLabel5 = new JLabel();
    JTextField tcplace = new JTextField();
    JTextField tctype = new JTextField();
    JTextField tcname = new JTextField();
    JLabel jLabel6 = new JLabel();
    public void btn_add_actionPerformed(ActionEvent e) {
        String cno="";                        //定义空的学生信息属性
        String cname = "";
        String cteacher = "";
        String ctype = "";
        String cplace = "";
        String ctime = "";
        if (!tcno.getText().equals("")) {
            cno=tcno.getText();                //获得课程名称文本框中的内容
        } else {
            JOptionPane.showMessageDialog(this, "课程编码不能为空！", "提示信息",
                    JOptionPane.ERROR_MESSAGE);
            return;
        }
        if (!tcname.getText().equals("")) {
            cname = tcname.getText();
        } else {
            JOptionPane.showMessageDialog(this, "课程名称不能为空！", "提示信息",
                    JOptionPane.ERROR_MESSAGE);
            return;
        }
        if (!tteacher.getText().equals("")) {
            cteacher = tteacher.getText();
        } else {
            JOptionPane.showMessageDialog(this, "授课教师不能为空！", "提示信息",
                    JOptionPane.ERROR_MESSAGE);
            return;
        }
        if (!tctype.getText().equals("")) {
            ctype = tctype.getText();
        } else {
            JOptionPane.showMessageDialog(this, "课程类别不能为空！", "提示信息",
                    JOptionPane.ERROR_MESSAGE);
            return;
        }
        if (!tcplace.getText().equals("")) {
            cplace = tcplace.getText();
        } else {
            JOptionPane.showMessageDialog(this, "上课地点不能为空！", "提示信息",
                    JOptionPane.ERROR_MESSAGE);
            return;
        }
        if (!tctime.getText().equals("")) {
            ctime = tctime.getText();
        } else {
            JOptionPane.showMessageDialog(this, "上课时间不能为空！", "提示信息",
                    JOptionPane.ERROR_MESSAGE);
            return;
        }
        Course c=new Course();                //定义课程信息并对信息封装
        c.setCno(cno);
        c.setCname(cname);
        c.setCteacher(cteacher);
        c.setCtype(ctype);
        c.setCplace(cplace);
        c.setCtime(ctime);
        CourseManager cm = new CourseManager();
        int i=cm.addCourse(c);                //调用添加课程信息方法
        if (i > 0) {
            JOptionPane.showMessageDialog(this, "添加成功！", "提示信息",
                    JOptionPane.INFORMATION_MESSAGE);
            tcno.setText("");                 //清空文本框内容
            tcname.setText("");
            tctype.setText("");
            tcplace.setText("");
            tteacher.setText("");
            tctime.setText("");
        } else {
            JOptionPane.showMessageDialog(this, "添加失败！", "提示信息",
                    JOptionPane.ERROR_MESSAGE);
        }
    }
    public void btn_null_actionPerformed(ActionEvent e) {
        tcno.setText("");                      //清空文本框内容
        tcname.setText("");
        tteacher.setText("");
        tctype.setText("");
        tcplace.setText("");
        tctime.setText("");
    }
    //退出按钮关闭当前页面
    public void btn_exit_actionPerformed(ActionEvent e) {
        this.setVisible(false);
    }
}
class Add_coursePanel_btn_exit_actionAdapter implements ActionListener {
    private Add_coursePanel adaptee;
    Add_coursePanel_btn_exit_actionAdapter(Add_coursePanel adaptee) {
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
        adaptee.btn_exit_actionPerformed(e);
    }
}
class Add_coursePanel_btn_null_actionAdapter implements ActionListener {
    private Add_coursePanel adaptee;
    Add_coursePanel_btn_null_actionAdapter(Add_coursePanel adaptee) {
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
        adaptee.btn_null_actionPerformed(e);
    }
}
class Add_coursePanel_btn_add_actionAdapter implements ActionListener {
    private Add_coursePanel adaptee;
    Add_coursePanel_btn_add_actionAdapter(Add_coursePanel adaptee) {
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
        adaptee.btn_add_actionPerformed(e);
    }
}

类4：Add_gradePanel

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.JComboBox;
import javax.swing.JTextField;
import cvit.com.manager.CourseManager;
import cvit.com.manager.StudentManager;
import java.util.Vector;
import java.awt.event.ItemEvent;
import java.awt.event.ItemListener;
import cvit.com.model.Course;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import cvit.com.model.Grade;
import javax.swing.JOptionPane;
import cvit.com.manager.GradeManager;
//添加分数
public class Add_gradePanel extends JPanel {
    public Add_gradePanel() {
        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(30, 22, 42, 15));
        jLabel2.setText("姓名");
        jLabel2.setBounds(new Rectangle(200, 20, 42, 15));
        jLabel3.setText("课程名称");
        jLabel3.setBounds(new Rectangle(23, 76, 55, 15));
        jLabel4.setText("课程编码");
        jLabel4.setBounds(new Rectangle(201, 74, 57, 15));
        jLabel5.setText("授课教师");
        jLabel5.setBounds(new Rectangle(15, 129, 61, 15));
        jLabel6.setText("成绩");
        jLabel6.setBounds(new Rectangle(202, 129, 42, 15));
        btn_add.setBounds(new Rectangle(76, 176, 81, 23));
        btn_add.setText("增加");
        btn_add.addActionListener(new addcjPanel1_btn_add_actionAdapter(this));
        btn_exit.setBounds(new Rectangle(233, 175, 81, 23));
        btn_exit.setText("退出");
        btn_exit.addActionListener(new addcjPanel1_btn_exit_actionAdapter(this));
        jcb_sno.setBounds(new Rectangle(91, 17, 89, 23));
        jcb_sno.addItemListener(new addcjPanel1_jcb_sno_itemAdapter(this));
        jcb_cname.setBounds(new Rectangle(92, 72, 89, 23));
        jcb_cname.addItemListener(new addcjPanel1_jcb_cname_itemAdapter(this));
        tsname.setEnabled(false);
        tsname.setBounds(new Rectangle(261, 19, 77, 20));
        tcno.setEnabled(false);
        tcno.setBounds(new Rectangle(260, 74, 77, 20));
        tcteacher.setEnabled(false);
        tcteacher.setBounds(new Rectangle(91, 127, 77, 20));
        tgrade.setBounds(new Rectangle(262, 127, 77, 20));
        this.add(jLabel2);
        this.add(jcb_sno);
        this.add(tsname);
        this.add(jLabel1);
        this.add(tcno);
        this.add(jLabel4);
        this.add(jcb_cname);
        this.add(jLabel3);
        this.add(tcteacher);
        this.add(jLabel5);
        this.add(jLabel6);
        this.add(tgrade);
        this.add(btn_exit);
        this.add(btn_add);
        this.setVisible(true);
        this.setSize(600, 600);
        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());    //将数据库中所有的课程名称添加到列表中
        }
    }
    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JLabel jLabel3 = new JLabel();
    JLabel jLabel4 = new JLabel();
    JLabel jLabel5 = new JLabel();
    JLabel jLabel6 = new JLabel();
    JButton btn_add = new JButton();
    JButton btn_exit = new JButton();
    JComboBox jcb_sno = new JComboBox();
    JComboBox jcb_cname = new JComboBox();
    JTextField tsname = new JTextField();
    JTextField tcno = new JTextField();
    JTextField tcteacher = new JTextField();
    JTextField tgrade = new JTextField();
    StudentManager sm=new StudentManager();        //初始化中定义学生管理对象
    CourseManager cm=new CourseManager();          //初始化中定义课程管理对象
    public static void main(String[] args) {Add_gradePanel sm = new Add_gradePanel();
    }
    public void jcb_sno_itemStateChanged(ItemEvent e) {
        //调用按学号查询学生信息方法
        tsname.setText(sm.findOneStudent(jcb_sno.getSelectedItem().toString()));
    }
    public void jcb_cname_itemStateChanged(ItemEvent e) {
        //调用按课程名称查询课程信息方法
        Course c = cm.findOneCourse(jcb_cname.getSelectedItem().toString());
        tcno.setText(c.getCno());
        tcteacher.setText(c.getCteacher());
    }
    public void btn_exit_actionPerformed(ActionEvent e) {
        this.setVisible(false);
    }
    public void btn_add_actionPerformed(ActionEvent e) {
        String sno = (String) jcb_sno.getSelectedItem();
        String cno = tcno.getText();
        String grade = tgrade.getText();
        Grade g = new Grade();
        g.setSno(sno);
        g.setCno(cno);
        g.setGrade(grade);
        GradeManager gm = new GradeManager();
        int i=gm.addGrade(g);                      //调用添加成绩方法
        if (i > 0) {
            JOptionPane.showMessageDialog(this, "添加成功！", "提示信息",
                    JOptionPane.INFORMATION_MESSAGE);
        } else {
            JOptionPane.showMessageDialog(this, "学生与实际选课科目不符，请核对！",
                    "提示信息", JOptionPane.ERROR_MESSAGE);
        }
    }
}
class addcjPanel1_btn_add_actionAdapter implements ActionListener {
    private Add_gradePanel adaptee;
    addcjPanel1_btn_add_actionAdapter(Add_gradePanel adaptee) {
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
        adaptee.btn_add_actionPerformed(e);
    }
}
class addcjPanel1_btn_exit_actionAdapter implements ActionListener {
    private Add_gradePanel adaptee;
    addcjPanel1_btn_exit_actionAdapter(Add_gradePanel adaptee) {
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
        adaptee.btn_exit_actionPerformed(e);
    }
}
class addcjPanel1_jcb_cname_itemAdapter implements ItemListener {
    private Add_gradePanel adaptee;
    addcjPanel1_jcb_cname_itemAdapter(Add_gradePanel adaptee) {
        this.adaptee = adaptee;
    }
    public void itemStateChanged(ItemEvent e) {
        adaptee.jcb_cname_itemStateChanged(e);
    }
}
class addcjPanel1_jcb_sno_itemAdapter implements ItemListener {
    private Add_gradePanel adaptee;
    addcjPanel1_jcb_sno_itemAdapter(Add_gradePanel adaptee) {
        this.adaptee = adaptee;
    }
    public void itemStateChanged(ItemEvent e) {
        adaptee.jcb_sno_itemStateChanged(e);
    }
}

类5：Add_studentPanel

package cvit.com.view;
import cvit.com.manager.StudentManager;
import cvit.com.model.Student;
import javax.swing.JPanel;
import javax.swing.JButton;
import java.awt.Rectangle;
import javax.swing.JLabel;
import javax.swing.JTextField;
import java.awt.Color;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.JOptionPane;
import javax.swing.JComboBox;
//添加学生信息
public class Add_studentPanel extends JPanel {
    public Add_studentPanel() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }
    private void jbInit() throws Exception {
        this.setLayout(null);
        this.setSize(600, 600);
        this.setBackground(new Color(168, 233, 216));
        this.setVisible(true);
        jLabel1.setText("学号");
        jLabel1.setBounds(new Rectangle(15, 36, 42, 15));
        jLabel2.setText("性别");
        jLabel2.setBounds(new Rectangle(14, 74, 42, 15));
        tsno.setBounds(new Rectangle(79, 33, 77, 20));
        jLabel3.setText("姓名");
        jLabel3.setBounds(new Rectangle(187, 35, 42, 15));
        jLabel4.setText("民族");
        jLabel4.setBounds(new Rectangle(184, 75, 42, 15));
        tsname.setBounds(new Rectangle(250, 32, 77, 20));
        jLabel5.setText("出生日期");
        jLabel5.setBounds(new Rectangle(5, 112, 67, 15));
        jLabel6.setText("入学时间");
        jLabel6.setBounds(new Rectangle(185, 112, 57, 15));
        tsbirth.setBounds(new Rectangle(79, 111, 77, 20));
        tstime.setBounds(new Rectangle(251, 111, 77, 20));
        jLabel7.setText("学院");
        jLabel7.setBounds(new Rectangle(15, 154, 42, 15));
        tscollege.setBounds(new Rectangle(79, 153, 77, 20));
        jLabel8.setText("专业");
        jLabel8.setBounds(new Rectangle(188, 154, 42, 15));
        tsmajor.setBounds(new Rectangle(251, 156, 77, 20));
        jLabel9.setText("籍贯");
        jLabel9.setBounds(new Rectangle(16, 197, 42, 15));
        tsplace.setBounds(new Rectangle(77, 198, 251, 20));
        btn1.setBounds(new Rectangle(35, 247, 81, 23));
        btn1.setText("添加");
        btn1.addActionListener(new Add_studentPanel_btn1_actionAdapter(this));
        btn2.setBounds(new Rectangle(151, 247, 81, 23));
        btn2.setText("清空");
        btn2.addActionListener(new Add_studentPanel_btn2_actionAdapter(this));
        btn3.setBounds(new Rectangle(265, 247, 81, 23));
        btn3.setText("退出");
        btn3.addActionListener(new Add_studentPanel_btn3_actionAdapter(this));
        jcb_sex.setBounds(new Rectangle(77, 66, 43, 23));
        jcb_ethnix.setBounds(new Rectangle(253, 66, 58, 23));
        this.add(tsno);
        this.add(jLabel3);
        this.add(tsname);
        this.add(btn1);
        this.add(btn2);
        this.add(jLabel5);
        this.add(jLabel1);
        this.add(tscollege);
        this.add(tsbirth);
        this.add(tstime);
        this.add(jLabel6);
        this.add(jLabel4);
        this.add(jLabel2);
        this.add(jLabel7);
        this.add(jLabel8);
        this.add(tsmajor);
        this.add(jLabel9);
        this.add(tsplace);
        this.add(btn3);
        this.add(jcb_ethnix);
        this.add(jcb_sex);
        jcb_sex.addItem("男");                                  //向性别的列表中添加内容
        jcb_sex.addItem("女");
        jcb_ethnix.addItem("汉族");                             //向民族的列表中添加内容
        jcb_ethnix.addItem("蒙族");
        jcb_ethnix.addItem("回族");
        jcb_ethnix.addItem("满族");
    }
    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JTextField tsno = new JTextField();
    JLabel jLabel3 = new JLabel();
    JLabel jLabel4 = new JLabel();
    JTextField tsname = new JTextField();
    JLabel jLabel5 = new JLabel();
    JLabel jLabel6 = new JLabel();
    JTextField tsbirth = new JTextField();
    JTextField tstime = new JTextField();
    JLabel jLabel7 = new JLabel();
    JTextField tscollege = new JTextField();
    JLabel jLabel8 = new JLabel();
    JTextField tsmajor = new JTextField();
    JLabel jLabel9 = new JLabel();
    JTextField tsplace = new JTextField();
    JButton btn1 = new JButton();
    JButton btn2 = new JButton();
    JButton btn3 = new JButton();
    JComboBox jcb_sex = new JComboBox();
    JComboBox jcb_ethnix = new JComboBox();
    public void btn1_actionPerformed(ActionEvent actionEvent) {
        //定义空的学生信息属性
        String sno = "";
        String sname = "";
        String ssex = "";
        String sbirth = "";
        String syear = "";
        String shome = "";
        String smajor = "";
        String scollege = "";
        if (!tsno.getText().equals("")) {
            sno = tsno.getText();
        } else {
            //弹出对话框信息
            JOptionPane.showMessageDialog(this, "学号不能为空！", "提示信息",
                    JOptionPane.ERROR_MESSAGE);
            return;
        }
        if (!tsname.getText().equals("")) {
            sname = tsname.getText();
        } else {
            JOptionPane.showMessageDialog(this, "姓名不能为空！", "提示信息",
                    JOptionPane.ERROR_MESSAGE);
            return;
        }
        if (!tsbirth.getText().equals("")) {
            sbirth = tsbirth.getText();
        } else {
            JOptionPane.showMessageDialog(this, "出生日期不能为空！", "提示信息",
                    JOptionPane.ERROR_MESSAGE);
            return;
        }
        if (!tstime.getText().equals("")) {
            syear = tstime.getText();
        } else {
            JOptionPane.showMessageDialog(this, "入学时间不能为空！", "提示信息",
                    JOptionPane.ERROR_MESSAGE);
            return;
        }
        if (!tscollege.getText().equals("")) {
            scollege = tscollege.getText();
        } else {
            JOptionPane.showMessageDialog(this, "学院不能为空！", "提示信息",
                    JOptionPane.ERROR_MESSAGE);
            return;
        }
        if (!tsmajor.getText().equals("")) {
            smajor = tsmajor.getText();
        } else {
            JOptionPane.showMessageDialog(this, "专业不能为空！", "提示信息",
                    JOptionPane.ERROR_MESSAGE);
            return;
        }
        if (!tsplace.getText().equals("")) {
            shome = tsplace.getText();
        } else {
            JOptionPane.showMessageDialog(this, "籍贯不能为空！", "提示信息",
                    JOptionPane.ERROR_MESSAGE);
            return;
        }
        ssex=jcb_sex.getSelectedItem().toString();               //获得列表中选定的性别信息
        String sethnix=jcb_ethnix.getSelectedItem().toString();  //获得民族列表总选到的信息
        Student s=new Student();                                 //定义学生对象s进行封装学生信息
        s.setSno(sno);
        s.setSname(sname);
        s.setSsex(ssex);
        s.setSethnix(sethnix);
        s.setShome(shome);
        s.setSyear(syear);
        s.setSmajor(smajor);
        s.setScollege(scollege);
        s.setSbirth(sbirth);
        StudentManager sm=new StudentManager();                  //定义学生管理对象sm
        int i=sm.addStudent(s);                                  //调用添加学生信息方法
        if (i > 0) {
            JOptionPane.showMessageDialog(this, "添加成功！", "提示信息",
                    JOptionPane.INFORMATION_MESSAGE);
            tsno.setText("");
            tsname.setText("");
            tsplace.setText("");
            tstime.setText("");
            tsmajor.setText("");
            tscollege.setText("");
            tsbirth.setText("");
        } else {
            JOptionPane.showMessageDialog(this, "添加失败！", "提示信息",
                    JOptionPane.ERROR_MESSAGE);
        }
    }
    //退出按钮关闭当前页面
    public void btn3_actionPerformed(ActionEvent e) {
        this.setVisible(false);
    }
    //清空按钮清空各文本框中的内容
    public void btn2_actionPerformed(ActionEvent e) {
        tsno.setText("");
        tsname.setText("");
        tsplace.setText("");
        tstime.setText("");
        tsmajor.setText("");
        tscollege.setText("");
        tsbirth.setText("");
    }
}
//监听
class Add_studentPanel_btn2_actionAdapter implements ActionListener {
    private Add_studentPanel adaptee;                            //编码时双击添加按钮自动生成代码
    Add_studentPanel_btn2_actionAdapter(Add_studentPanel adaptee) {
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
        adaptee.btn2_actionPerformed(e);
    }
}
class Add_studentPanel_btn3_actionAdapter implements ActionListener {
    private Add_studentPanel adaptee;
    Add_studentPanel_btn3_actionAdapter(Add_studentPanel adaptee) {
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
        adaptee.btn3_actionPerformed(e);
    }
}
class Add_studentPanel_btn1_actionAdapter implements ActionListener {
    private Add_studentPanel adaptee;
    Add_studentPanel_btn1_actionAdapter(Add_studentPanel adaptee) {
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent actionEvent) {
        adaptee.btn1_actionPerformed(actionEvent);
    }
}

类6：Delete_CoursePanel

package cvit.com.view;
import cvit.com.manager.CourseManager;
import javax.swing.JPanel;
import java.awt.Color;
import javax.swing.JTextField;
import java.awt.Rectangle;
import javax.swing.JLabel;
import javax.swing.JButton;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.JOptionPane;
//删除科目
public class Delete_coursePanel extends JPanel {
    public Delete_coursePanel() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }
    private void jbInit() throws Exception {
        this.setLayout(null);
        this.setBackground(new Color(168, 233, 216));
        tcno.setBounds(new Rectangle(78, 76, 130, 20));
        jLabel1.setText("课程编号");
        jLabel1.setBounds(new Rectangle(8, 81, 66, 15));
        btn_delete.setBounds(new Rectangle(228, 72, 71, 23));
        btn_delete.setText("删除");
        btn_delete.addActionListener(new
                Delete_coursePanel_btn_delete_actionAdapter(this));
        btn_exit.setBounds(new Rectangle(320, 72, 69, 23));
        btn_exit.setText("退出");
        btn_exit.addActionListener(new
                Delete_coursePanel_btn_exit_actionAdapter(this));
        this.add(tcno);
        this.add(jLabel1);
        this.add(btn_delete);
        this.add(btn_exit);
        this.setVisible(true);               //可见性
        this.setSize(600, 600);               //窗体大小
    }
    JTextField tcno = new JTextField();
    JLabel jLabel1 = new JLabel();
    JButton btn_delete = new JButton();
    JButton btn_exit = new JButton();
    public void btn_delete_actionPerformed(ActionEvent e) {
        String cno=tcno.getText();            //获得课程编码
        CourseManager cm = new CourseManager();
        int ok = JOptionPane.showConfirmDialog(this,
                "是否删除" + tcno.getText() + "课程？", "提示信息", JOptionPane.OK_CANCEL_OPTION);
        if (ok == JOptionPane.OK_OPTION) {
            int i=cm.deleteCourse(cno);        //调用删除课程信息方法
            if (i > 0) {
                JOptionPane.showMessageDialog(this, "删除成功！", "提示信息",
                        JOptionPane.INFORMATION_MESSAGE);
            } else {
                JOptionPane.showMessageDialog(this, "你要删除的课程不存在！",
                        "提示信息", JOptionPane.ERROR_MESSAGE);
                tcno.setText("");
            }
            tcno.setText("");
        }
    }
    public void btn_exit_actionPerformed(ActionEvent e) {
        this.setVisible(false);
    }
    class Delete_coursePanel_btn_delete_actionAdapter implements ActionListener {
        private Delete_coursePanel adaptee;
        Delete_coursePanel_btn_delete_actionAdapter(Delete_coursePanel adaptee) {
            this.adaptee = adaptee;
        }
        public void actionPerformed(ActionEvent e) {
            adaptee.btn_delete_actionPerformed(e);
        }
    }
}
class Delete_coursePanel_btn_exit_actionAdapter implements ActionListener {
    private Delete_coursePanel adaptee;
    Delete_coursePanel_btn_exit_actionAdapter(Delete_coursePanel adaptee) {
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
        adaptee.btn_exit_actionPerformed(e);
    }
}

类7：Delete_studentPanel

package cvit.com.view;
import cvit.com.manager.StudentManager;
import javax.swing.JPanel;
import java.awt.Color;
import javax.swing.JTextField;
import java.awt.Rectangle;
import javax.swing.JLabel;
import javax.swing.JButton;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.JOptionPane;
//删除学生信息
public class Delete_studentPanel extends JPanel {
    public Delete_studentPanel() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }
    private void jbInit() throws Exception {
        this.setLayout(null);
        this.setBackground(new Color(168, 233, 216));
        tsno.setBounds(new Rectangle(78, 76, 130, 20));
        jLabel1.setText("学号");
        jLabel1.setBounds(new Rectangle(32, 81, 42, 15));
        btn_delete.setBounds(new Rectangle(235, 76, 81, 23));
        btn_delete.setText("删除");
        btn_delete.addActionListener(new Delete_studentPanel_btn_delete_actionAdapter(this));
        btn_exit.setBounds(new Rectangle(233, 111, 81, 23));
        btn_exit.setText("退出");
        btn_exit.addActionListener(new
                Delete_studentPanel_btn_exit_actionAdapter(this));
        this.add(tsno);
        this.add(jLabel1);
        this.add(btn_delete);
        this.add(btn_exit);
        this.setVisible(true);                   //可见性
        this.setSize(600, 600);                   //窗体大小
    }
    JTextField tsno = new JTextField();
    JLabel jLabel1 = new JLabel();
    JButton btn_delete = new JButton();
    JButton btn_exit = new JButton();
    public void btn_delete_actionPerformed(ActionEvent e) {
        String sno=tsno.getText();               //获得学号文本框中的学号
        StudentManager sm=new StudentManager();  //定义学生管理对象sm
        int ok = JOptionPane.showConfirmDialog(this, "是否删除" + tsno.getText() + "同学？ ", "提示信息",
                JOptionPane.OK_CANCEL_OPTION);
        if (ok == JOptionPane.OK_OPTION) {
            int i=sm.deleteUser(sno);            //调用删除学生方法
            if (i > 0) {
                JOptionPane.showMessageDialog(this, "删除成功！", "提示信息",
                        JOptionPane.INFORMATION_MESSAGE);
            } else {
                JOptionPane.showMessageDialog(this, "你要删除的同学不存在！",
                        "提示信息", JOptionPane.ERROR_MESSAGE);
            }
            tsno.setText("");
        }
    }
    //退出按钮关闭页面
    public void btn_exit_actionPerformed(ActionEvent e) {
        this.setVisible(false);
    }
}
class Delete_studentPanel_btn_exit_actionAdapter implements ActionListener {
    private Delete_studentPanel adaptee;
    Delete_studentPanel_btn_exit_actionAdapter(Delete_studentPanel adaptee) {
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
        adaptee.btn_exit_actionPerformed(e);
    }
}
class Delete_studentPanel_btn_delete_actionAdapter implements ActionListener {
    private Delete_studentPanel adaptee;
    Delete_studentPanel_btn_delete_actionAdapter(Delete_studentPanel adaptee) {
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
        adaptee.btn_delete_actionPerformed(e);
    }
}

类8：Select_coursecnamePanel

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 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_coursecnamePanel extends JPanel {
    public Select_coursecnamePanel() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }
    private void jbInit() throws Exception {
        this.setLayout(null);
        this.setBackground(new Color(168, 233, 216));
        jLabel1.setToolTipText("");
        jLabel1.setText("授课教师");
        jLabel1.setBounds(new Rectangle(18, 86, 53, 15));
        jLabel2.setText("课程类别");
        jLabel2.setBounds(new Rectangle(198, 87, 62, 15));
        tctime.setEnabled(false);
        tctime.setBounds(new Rectangle(265, 123, 77, 20));
        tcno.setEnabled(false);
        tcno.setBounds(new Rectangle(266, 40, 77, 20));
        tcteacher.setEnabled(false);
        tcteacher.setBounds(new Rectangle(91, 85, 93, 20));
        jLabel3.setText("课程名称");
        jLabel3.setBounds(new Rectangle(20, 45, 60, 15));
        jLabel4.setText("课程编码");
        jLabel4.setBounds(new Rectangle(193, 42, 65, 15));
        jLabel5.setText("上课时间");
        jLabel5.setBounds(new Rectangle(199, 124, 57, 15));
        tctype.setEnabled(false);
        tctype.setBounds(new Rectangle(265, 85, 77, 20));
        tcplace.setEnabled(false);
        tcplace.setBounds(new Rectangle(93, 123, 90, 20));
        jLabel6.setText("上课地点");
        jLabel6.setBounds(new Rectangle(19, 124, 67, 15));
        btn_exit.setBounds(new Rectangle(22, 172, 81, 23));
        btn_exit.setText("退出");
        btn_exit.addActionListener(new
                Select_coursePanel_btn_exit_actionAdapter(this));
        jcb_cname.setBounds(new Rectangle(89, 41, 97, 23));
        jcb_cname.addItemListener(new
                Select_coursecnamePanel_jcb_cname_itemAdapter(this));
        this.add(jLabel2);
        this.add(tctime);
        this.add(tcteacher);
        this.add(jLabel5);
        this.add(tctype);
        this.add(tcplace);
        this.add(jLabel6);
        this.add(tcno);
        this.add(jLabel4);
        this.add(jLabel3);
        this.add(jLabel1);
        this.add(jcb_cname);
        this.add(btn_exit);
        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);
    }
    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JTextField tctime = new JTextField();
    JTextField tcno = new JTextField();
    JTextField tcteacher = new JTextField();
    JLabel jLabel3 = new JLabel();
    JLabel jLabel4 = new JLabel();
    JLabel jLabel5 = new JLabel();
    JTextField tctype = new JTextField();
    JTextField tcplace = new JTextField();
    JLabel jLabel6 = new JLabel();
    JButton btn_exit = new JButton();
    JComboBox jcb_cname = new JComboBox();
    CourseManager cm = new CourseManager();
    public void btn_exit_actionPerformed(ActionEvent e) {
        this.setVisible(false);
    }
    public void jcb_cname_itemStateChanged(ItemEvent e) {
        //调用按课程名称查询课程信息
        Course c = cm.findOneCourse(jcb_cname.getSelectedItem().toString());
        tcno.setText(c.getCno());
        tcteacher.setText(c.getCteacher());
        tcplace.setText(c.getCplace());
        tctype.setText(c.getCtype());
        tcplace.setText(c.getCplace());
        tctime.setText(c.getCtime());
    }
}
class Select_coursecnamePanel_jcb_cname_itemAdapter implements ItemListener {
    private Select_coursecnamePanel adaptee;
    Select_coursecnamePanel_jcb_cname_itemAdapter(Select_coursecnamePanel adaptee) {
        this.adaptee = adaptee;
    }
    public void itemStateChanged(ItemEvent e) {
        adaptee.jcb_cname_itemStateChanged(e);
    }
}
class Select_coursePanel_btn_exit_actionAdapter implements ActionListener {
    private Select_coursecnamePanel adaptee;
    Select_coursePanel_btn_exit_actionAdapter(Select_coursecnamePanel adaptee) {
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
        adaptee.btn_exit_actionPerformed(e);
    }
}

view包一共19个类。

本篇介绍了1至8类，由于博客字数限制，后半部分代码放到下篇。
下篇从第9个类开始，介绍9至19类：
下篇：学生选课与成绩管理系统2（剩余代码）

四、运行

连接好数据库之后，在view包下的StuviewFrame右键点击运行。通过IDEA的图形界面，进行增删改查等操作。
以增加学生信息为例：
1：增加学生信息
2：在IDEA中的数据库表中验证，确实添加成功。

3：回到mysql数据库中的student表中验证，也确实添加成功了。

经过多次测试，表明此程序运行成功！