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

avatar
作者
筋斗云
阅读量:1

一、项目效果展示

本项目包含丰富子项目,涵盖增删改查和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表中验证,也确实添加成功了。
在这里插入图片描述

经过多次测试,表明此程序运行成功!

广告一刻

为您即时展示最新活动产品广告消息,让您随时掌握产品活动新动态!