java Swing实现考试系统

谁借莪１个温暖的怀抱￠ 2023-05-30 13:58 29阅读 0赞

***本文实现该系统的功能截图，和数据库设计SQL语句供大家参考***

## 1.考试系统背景 随着现在科技的发展 ##

，传统考试已经被替代，考试用电脑完成操作已经成为趋势。

## 2.在线考试系统技术架构 ##

主要技术  
Java Swing  
开发工具和环境  
Eclipse  
JDK 1.8  
Mysql 5.6  
Win10 操作系统

## 3.数据库设计 ##

CREATE TABLE `tb_user` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `userType` int(11) NOT NULL,
      `UserName` varchar(100) NOT NULL,
      `passWord` varchar(220) NOT NULL,
      `havaIn` int(11) NOT NULL,
      PRIMARY KEY (`id`)
    ) ENGINE=MyISAM AUTO_INCREMENT=16 ;
    
    CREATE TABLE `tb_stat` (
      `id` int(11) NOT NULL,
      `radio_BL` int(11) NOT NULL,
      `more_BL` int(11) NOT NULL,
      `judge_BL` int(11) NOT NULL,
      `radio_FS` int(11) NOT NULL,
      `more_FS` int(11) NOT NULL,
      `judge_FS` int(11) NOT NULL,
      `exam_time` int(11) NOT NULL
    ) ENGINE=MyISAM;
    
    CREATE TABLE `tb_questiontype` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `qName` varchar(50) NOT NULL,
      PRIMARY KEY (`id`)
    ) ENGINE=MyISAM AUTO_INCREMENT=4 ;
    
    CREATE TABLE `tb_question` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `typeid` int(11) NOT NULL,
      `q_subject` varchar(400) NOT NULL,
      `q_answer` varchar(400) NOT NULL,
      `optionA` varchar(400) NOT NULL,
      `optionB` varchar(400) NOT NULL,
      `optionC` varchar(400) NOT NULL,
      `optionD` varchar(400) NOT NULL,
      `note` varchar(400) NOT NULL,
      PRIMARY KEY (`id`)
    ) ENGINE=MyISAM AUTO_INCREMENT=27;
    
    CREATE TABLE `tb_grade` (
      `id` int(11) NOT NULL,
      `userName` varchar(100) NOT NULL,
      `radioResult` int(11) NOT NULL,
      `fullResule` int(11) NOT NULL,
      `esitResult` int(11) NOT NULL,
      `batsisResult` int(11) NOT NULL,
      `date` varchar(200) NOT NULL,
      PRIMARY KEY (`id`)
    ) ENGINE=MyISAM;

## 4.管理员系统演示 ##

登录界面  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70]  
后台管理功能  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 1]  
用户管理  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 2]  
添加用户  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 3]  
删除用户![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 4]  
题库管理  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 5]  
添加试题  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 6]  
修改删除试题  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 7]

## 5.学生系统演示 ##

学生登录  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 8]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 9]  
考试考试  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 10]  
判断题  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 11]  
多选题  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 12]  
提交考试  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 13]  
Java实现自动阅卷  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 14]  
查看分数，修改密码功能  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 15]  
关于考试  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 16]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20191110185831397.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20191110185920304.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20191110190002225.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/20191110190025759.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 4]: https://img-blog.csdnimg.cn/20191110190058156.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 5]: https://img-blog.csdnimg.cn/20191110190132119.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 6]: https://img-blog.csdnimg.cn/2019111019023962.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 7]: https://img-blog.csdnimg.cn/20191110190154317.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 8]: https://img-blog.csdnimg.cn/20191110190430640.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 9]: https://img-blog.csdnimg.cn/2019111019051458.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 10]: https://img-blog.csdnimg.cn/20191110190625373.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 11]: https://img-blog.csdnimg.cn/2019111019064436.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 12]: https://img-blog.csdnimg.cn/20191110190717996.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 13]: https://img-blog.csdnimg.cn/20191110190735750.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 14]: https://img-blog.csdnimg.cn/20191110190753320.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 15]: https://img-blog.csdnimg.cn/20191110190850962.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5_size_16_color_FFFFFF_t_70 16]: https://img-blog.csdnimg.cn/20191110190916875.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDE3NzQ5,size_16,color_FFFFFF,t_70