一、系统介绍
系统主要功能学生信息管理、管理员信息管理、核酸信息管理等。
二、功能展示
1.主页
2.用户登陆
3.学生信息
三、数据库
/*
Navicat Premium Data Transfer
Source Server : localhost
Source Server Type : MySQL
Source Server Version : 80021
Source Host : localhost:3306
Source Schema : studentinfo
Target Server Type : MySQL
Target Server Version : 80021
File Encoding : 65001
Date: 23/11/2022 16:47:46
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for admin_login_k
-- ----------------------------
DROP TABLE IF EXISTS `admin_login_k`;
CREATE TABLE `admin_login_k` (
`admin_id` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`admin_pass` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`admin_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of admin_login_k
-- ----------------------------
INSERT INTO `admin_login_k` VALUES ('admin', 'admin');
-- ----------------------------
-- Table structure for stu_login_k
-- ----------------------------
DROP TABLE IF EXISTS `stu_login_k`;
CREATE TABLE `stu_login_k` (
`stu_id` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`stu_pass` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`stu_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of stu_login_k
-- ----------------------------
INSERT INTO `stu_login_k` VALUES ('182085211000', '123456');
-- ----------------------------
-- Table structure for student_k
-- ----------------------------
DROP TABLE IF EXISTS `student_k`;
CREATE TABLE `student_k` (
`id` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`name` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`gender` char(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`age` char(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of student_k
-- ----------------------------
INSERT INTO `student_k` VALUES ('182085211000', 'a', '女', '22');
INSERT INTO `student_k` VALUES ('182085211004', 'b', '女', '18');
INSERT INTO `student_k` VALUES ('182085211005', 'abc', '男', '23');
INSERT INTO `student_k` VALUES ('182085211006', 'abc', '女', '24');
INSERT INTO `student_k` VALUES ('182085211008', 'Tom', '男', '23');
INSERT INTO `student_k` VALUES ('182085211009', 'Tom', '男', '23');
INSERT INTO `student_k` VALUES ('182085211010', 'Tom', '男', '23');
INSERT INTO `student_k` VALUES ('182085211011', 'Tom', '男', '23');
INSERT INTO `student_k` VALUES ('1820852110111', 'Tom', '男', '23');
INSERT INTO `student_k` VALUES ('182085211012', 'Tom', '男', '23');
INSERT INTO `student_k` VALUES ('182085211013', 'Tom', '男', '23');
INSERT INTO `student_k` VALUES ('182085211014', 'Tom2', '男', '23');
INSERT INTO `student_k` VALUES ('182085211015', 'Tom1', '男', '23');
INSERT INTO `student_k` VALUES ('182085211016', 'Tom', '男', '23');
INSERT INTO `student_k` VALUES ('182085211017', 'Tom', '男', '23');
INSERT INTO `student_k` VALUES ('182085211018', 'Tom', '男', '20');
INSERT INTO `student_k` VALUES ('182085211019', 'Tom', '男', '23');
INSERT INTO `student_k` VALUES ('182085211020', 'Tom', '男', '23');
INSERT INTO `student_k` VALUES ('182085211021', 'Tom', '男', '23');
INSERT INTO `student_k` VALUES ('1820852110211', 'Tom', '男', '23');
INSERT INTO `student_k` VALUES ('182085211022', 'Tom1', '男', '23');
INSERT INTO `student_k` VALUES ('182085211023', 'Tom', '男', '23');
INSERT INTO `student_k` VALUES ('182085211024', 'Tom', '男', '23');
INSERT INTO `student_k` VALUES ('182085211034', 'Tom', '男', '23');
-- ----------------------------
-- Table structure for t_course
-- ----------------------------
DROP TABLE IF EXISTS `t_course`;
CREATE TABLE `t_course` (
`SNO` char(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`COURSE` char(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`CREDIT` char(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`GRADE` char(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of t_course
-- ----------------------------
INSERT INTO `t_course` VALUES ('08300205', '程序设计', '4', '88');
INSERT INTO `t_course` VALUES ('08300205', '数据库', '2.5', '90');
INSERT INTO `t_course` VALUES ('08300205', '力学', '5', '92');
INSERT INTO `t_course` VALUES ('08080929', '数据库', '2.5', '85');
INSERT INTO `t_course` VALUES ('09350124', '数据库', '2.5', '92');
INSERT INTO `t_course` VALUES ('09620233', '数据库', '2.5', '80');
INSERT INTO `t_course` VALUES ('09300218', '数据库', '2.5', '78');
INSERT INTO `t_course` VALUES ('09010122', '数据库', '2.5', '87');
INSERT INTO `t_course` VALUES ('08080929', '程序设计', '4', '86');
INSERT INTO `t_course` VALUES ('09010122', '程序设计', '4', '80');
INSERT INTO `t_course` VALUES ('08300516', '程序设计', '4', '76');
-- ----------------------------
-- Table structure for t_st
-- ----------------------------
DROP TABLE IF EXISTS `t_st`;
CREATE TABLE `t_st` (
`SNO` char(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`SNAME` char(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`SSEX` char(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`AGE` char(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`DEPT` char(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`SNO`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of t_st
-- ----------------------------
INSERT INTO `t_st` VALUES ('08080929', '刘超世', '男', '19', '计算机应用技术');
INSERT INTO `t_st` VALUES ('08300205', '李媛媛', '女', '19', '软件工程');
INSERT INTO `t_st` VALUES ('09300218', '王海超', '男', '19', '软件工程');
INSERT INTO `t_st` VALUES ('09350124', '王彤', '女', '19', '通信原理');
INSERT INTO `t_st` VALUES ('09620233', '陈晓丽', '女', '21', '通信工程');
SET FOREIGN_KEY_CHECKS = 1;
四、其它
1.其他系统实现
Java+Swing实现学生选课管理系统
Java+Swing实现学校教务管理系统
Java+Swing+sqlserver学生成绩管理系统
Java+Swing用户信息管理系统
Java+Swing实现的五子棋游戏
基于JavaSwing 银行管理系统
Java+Swing+mysql仿QQ聊天工具
Java+Swing 聊天室
Java+Swing+dat文件存储实现学生选课管理系统
Java+Swing可视化图像处理软件
Java+Swing学生信息管理系统
Java+Swing图书管理系统
Java+Swing图书管理系统2.0
基于java+swing+mysql图书管理系统3.0
大作业-基于java+swing+mysql北方传统民居信息管理系统