基于ssm+mysql+jsp学生成绩管理系统&学生信息管理系统

一、系统介绍二、功能展示1.登陆2.主页3.个人中心(学生)4.课程信息（学生）5.成绩信息（学生）6.学生信息（系统管理员）6.课程信息（系统管理员）7.成绩信息（系统管理员）三、数据库四、获取源码

一、系统介绍

系统主要功能：

学生：首页、个人中心、课程信息、成绩信息

系统管理员：首页、学生信息、课程信息、成绩信息

运行环境：idea+mysql8.0

二、功能展示

1.登陆

2.主页

3.个人中心(学生)

4.课程信息（学生）

5.成绩信息（学生）

6.学生信息（系统管理员）

6.课程信息（系统管理员）

7.成绩信息（系统管理员）

三、数据库

/*SQLyog Ultimate v12.09 (64 bit)MySQL - 8.0.22 : Database - studentinfo**********************************************************************//*!40101 SET NAMES utf8 */;/*!40101 SET SQL_MODE=''*/;/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;CREATE DATABASE /*!32312 IF NOT EXISTS*/`studentinfo` /*!40100 DEFAULT CHARACTER SET utf8 */ /*!80016 DEFAULT ENCRYPTION='N' */;USE `studentinfo`;/*Table structure for table `course` */DROP TABLE IF EXISTS `course`;CREATE TABLE `course` (`id` int NOT NULL AUTO_INCREMENT,`courseId` varchar(10) NOT NULL COMMENT '课程号',`courseName` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '课程名',`schoolYear` varchar(255) NOT NULL COMMENT '学年',`creditHour` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '学分',`teacher` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '任课老师',PRIMARY KEY (`id`,`courseId`,`courseName`) USING BTREE) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8;/*Data for the table `course` */insert into `course`(`id`,`courseId`,`courseName`,`schoolYear`,`creditHour`,`teacher`) values (1,'101','高等数学','-','2',' 亓健'),(2,'102','马克思主义原理','-','2','张天佑'),(3,'103','线性代数','-','2','邵宏飞'),(4,'104','大学语文','-','2','李雪'),(5,'105','思想道德修养','-','2','黄奕'),(6,'201','软件工程','-','2','李欣'),(7,'202','C语言基础','-','2','曾戟'),(8,'203','Java语言基础','-','2','陈思琪'),(9,'301','会计学','-','2','赵小露'),(10,'302','管理经济学','-','2','杨恩'),(11,'303','应用统计学','-','2','钱红'),(12,'401','基础英语','-','2','刘明'),(13,'402','商务英语','-','2','陈忠均'),(14,'403','英语写作','-','2','王曼思'),(15,'501','设计概论','-','2','周亦双'),(16,'502','设计素描','-','2','李双'),(17,'503','平面构成','-','2','赵晓雅'),(18,'601','机械制造技术','-','2','陈晓'),(19,'602','电机拖动与控制','-','2','王家琪'),(20,'603','机械制图','-','2','陆子玲'),(21,'701','体育心理学','-','2','田虹'),(22,'702','运动生理学','-','2','游亮'),(23,'703','体育概论','-','2','陈明'),(24,'801','理论力学','-','2','王泽毅'),(25,'802','建筑材料','-','2','司马炎平'),(26,'803','材料力学','-','2','马嵩'),(33,'111','python','-','1','徐天');/*Table structure for table `data_dictionary` */DROP TABLE IF EXISTS `data_dictionary`;CREATE TABLE `data_dictionary` (`id` int NOT NULL AUTO_INCREMENT,`collegeId` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '编号',`college` varchar(20) NOT NULL COMMENT '学院',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;/*Data for the table `data_dictionary` */insert into `data_dictionary`(`id`,`collegeId`,`college`) values (1,'1','学校'),(2,'2','信息工程学院'),(3,'3','商学院'),(4,'4','外国语学院'),(5,'5','艺术设计与传媒学院'),(6,'6','机电工程学院'),(7,'7','体育学院'),(8,'8','土木建筑学院');/*Table structure for table `score` */DROP TABLE IF EXISTS `score`;CREATE TABLE `score` (`id` int NOT NULL AUTO_INCREMENT,`studentId` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '学号',`courseId` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '课程号',`score` varchar(20) NOT NULL COMMENT '成绩',PRIMARY KEY (`id`,`studentId`,`courseId`) USING BTREE) ENGINE=InnoDB AUTO_INCREMENT=173 DEFAULT CHARSET=utf8;/*Data for the table `score` */insert into `score`(`id`,`studentId`,`courseId`,`score`) values (1,'200201','101','96'),(2,'200201','102','83'),(3,'200201','103','86'),(4,'200201','104','88'),(5,'200201','105','92'),(6,'200201','201','75'),(7,'200201','202','87'),(8,'200201','203','91'),(9,'200202','101','85'),(10,'200202','102','86'),(11,'200202','103','91'),(12,'200202','104','79'),(13,'200202','105','88'),(14,'200202','201','76'),(15,'200202','202','97'),(16,'200202','203','84'),(17,'200203','101','92'),(18,'200203','102','88'),(19,'200203','103','89'),(20,'200203','104','92'),(21,'200203','105','75'),(22,'200203','201','81'),(23,'200203','202','86'),(24,'200203','203','90'),(25,'200301','101','91'),(26,'200301','102','76'),(27,'200301','103','89'),(28,'200301','104','83'),(29,'200301','105','86'),(30,'200301','301','91'),(31,'200301','302','89'),(32,'200301','303','89'),(33,'200302','101','85'),(34,'200302','102','83'),(35,'200302','103','77'),(36,'200302','104','93'),(37,'200302','105','89'),(38,'200302','301','93'),(39,'200302','302','87'),(40,'200302','303','93'),(41,'200303','101','82'),(42,'200303','102','89'),(43,'200303','103','79'),(44,'200303','104','93'),(45,'200303','105','80'),(46,'200303','301','93'),(47,'200303','302','84'),(48,'200303','303','95'),(49,'200401','101','90'),(50,'200401','102','89'),(51,'200401','103','83'),(52,'200401','104','91'),(53,'200401','105','82'),(54,'200401','401','85'),(55,'200401','402','89'),(56,'200401','403','92'),(57,'200402','101','80'),(58,'200402','102','81'),(59,'200402','103','89'),(60,'200402','104','93'),(61,'200402','105','90'),(62,'200402','401','89'),(63,'200402','402','79'),(64,'200402','403','92'),(65,'200403','101','85'),(66,'200403','102','86'),(67,'200403','103','79'),(68,'200403','104','83'),(69,'200403','105','92'),(70,'200403','401','96'),(71,'200403','402','82'),(72,'200403','403','90'),(73,'200501','101','86'),(74,'200501','102','90'),(75,'200501','103','91'),(76,'200501','104','85'),(77,'200501','105','89'),(78,'200501','501','81'),(79,'200501','502','79'),(80,'200501','503','90'),(81,'200502','101','88'),(82,'200502','102','79'),(83,'200502','103','89'),(84,'200502','104','91'),(85,'200502','105','89'),(86,'200502','501','90'),(87,'200502','502','83'),(88,'200502','503','91'),(89,'200503','101','85'),(90,'200503','102','86'),(91,'200503','103','79'),(92,'200503','104','83'),(93,'200503','105','92'),(94,'200503','501','72'),(95,'200503','502','88'),(96,'200503','503','77'),(97,'200601','101','89'),(98,'200601','102','81'),(99,'200601','103','93'),(100,'200601','104','88'),(101,'200601','105','92'),(102,'200601','601','89'),(103,'200601','602','78'),(104,'200601','603','81'),(105,'200602','101','79'),(106,'200602','102','86'),(107,'200602','103','89'),(108,'200602','104','90'),(109,'200602','105','91'),(110,'200602','601','89'),(111,'200602','602','91'),(112,'200602','603','77'),(113,'200603','101','91'),(114,'200603','102','87'),(115,'200603','103','86'),(116,'200603','104','90'),(117,'200603','105','88'),(118,'200603','601','82'),(119,'200603','602','85'),(120,'200603','603','93'),(121,'200701','101','82'),(122,'200701','102','86'),(123,'200701','103','82'),(124,'200701','104','74'),(125,'200701','105','90'),(126,'200701','701','89'),(127,'200701','702','78'),(128,'200701','703','86'),(129,'200702','101','92'),(130,'200702','102','76'),(131,'200702','103','86'),(132,'200702','104','91'),(133,'200702','105','89'),(134,'200702','701','82'),(135,'200702','702','79'),(136,'200702','703','88'),(137,'200703','101','92'),(138,'200703','102','86'),(139,'200703','103','76'),(140,'200703','104','93'),(141,'200703','105','79'),(142,'200703','701','89'),(143,'200703','702','85'),(144,'200703','703','92'),(145,'200801','101','81'),(146,'200801','102','93'),(147,'200801','103','86'),(148,'200801','104','83'),(149,'200801','105','79'),(150,'200801','801','84'),(151,'200801','802','83'),(152,'200801','803','92'),(153,'200802','101','91'),(154,'200802','102','91'),(155,'200802','103','76'),(156,'200802','104','83'),(157,'200802','105','79'),(158,'200802','801','94'),(159,'200802','802','76'),(160,'200802','803','82'),(171,'200201','101','56');/*Table structure for table `student` */DROP TABLE IF EXISTS `student`;CREATE TABLE `student` (`studentId` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`studentName` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`studentSex` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`studentAge` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '',`studentBifthday` date DEFAULT NULL,`studentDept` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`studentMajor` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`studentClassId` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`studentCellPhone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,`studentpad` varchar(20) DEFAULT '123456',PRIMARY KEY (`studentId`) USING BTREE) ENGINE=InnoDB DEFAULT CHARSET=utf8;/*Data for the table `student` */insert into `student`(`studentId`,`studentName`,`studentSex`,`studentAge`,`studentBifthday`,`studentDept`,`studentMajor`,`studentClassId`,`studentCellPhone`,`studentpad`) values ('200201','陈韵竹','女','21','1998-12-03','信息工程学院','软件工程','软件1181','13423564652','123456'),('200202','杨兵','男','19','2001-05-12','信息工程学院','计算机科学与技术','计科1181','13425026258','123456'),('200203','余小艳','女','19','2001-02-18','信息工程学院','物联网','物联网1181','13523846595','123456'),('200301','黄佳','女','20','2000-01-04','商学院','电子商务','电商1181','13235262145','123456'),('200302','吴希泽','男','19','2001-03-06','商学院','财务管理','财管1181','15623659125','123456'),('200303','赵高','男','18','2002-06-03','商学院','金融','金融1181','15123652545','123456'),('200401','张嘉','女','19','2001-03-06','外国语学院','日语','英日1181','15539102356','123456'),('200402','李欢','女','20','2000-03-21','外国语学院','韩语','韩语1181','13526535248','123456'),('200403','徐韵芝','女','20','2000-11-06','外国语学院','日语','日语1182','13648569726','123456'),('200501','钱红','女','20','2000-02-19','艺术设计与传媒学院','广告设计','广告1181','13442356985','123456'),('200502','于爱雪','女','19','2002-12-06','艺术设计与传媒学院','网媒','网媒1181','13497773201','123456'),('200503','李江龙','男','20','2000-08-03','艺术设计与传媒学院','舞蹈','舞蹈1181','17723568542','123456'),('200601','余小艳','女','19','2001-05-14','机电工程学院','机电工程','机电1181','17738254365','123456'),('200602','于爱梅','女','21','2001-06-03','机电工程学院','车辆工程','车辆1181','17763249654','123456'),('200603','李淑芳','女','20','2000-09-15','机电工程学院','机电工程','机电1181','15696352489','123456'),('200701','段奕宏','男','20','2000-06-23','体育学院','休闲体育','体育1182','15623568541','123456'),('200702','周天','男','18','2002-01-01','体育学院','体育管理学','体管1181','13456982395','123456'),('200703','张雷','男','19','2001-03-19','体育学院','体育管理学','体管1182','18965234586','123456'),('200801','赵锦卿','男','21','1999-07-15','土木建筑学院','建筑工程','建工1181','13597753215','123456'),('200802','龚子航','男','19','2001-03-06','土木建筑学院','建筑工程','建工1181','15527499525','123456'),('515165656','6516166','男','51','-03-13','外国语学院','西班牙语','','','123456');/*Table structure for table `user` */DROP TABLE IF EXISTS `user`;CREATE TABLE `user` (`name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`password` varchar(20) DEFAULT NULL,PRIMARY KEY (`name`) USING BTREE) ENGINE=InnoDB DEFAULT CHARSET=utf8;/*Data for the table `user` */insert into `user`(`name`,`password`) values ('admin','123456'),('ctf','123456');/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

四、获取源码

点击下载

基于ssm+mysql+jsp学生成绩管理系统&学生信息管理系统