简易的成绩管理解决方案

MySQL数据库 /* SQLyog 企业版 - MySQL GUI v8.14 MySQL - 5.5.13 : Database - student ********************************************************************* */ /*!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*/`student` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin */; USE `student`; /*Table structure for table `cour` */ DROP TABLE IF EXISTS `cour`; CREATE TABLE `cour` ( `cour_id` int(11) NOT NULL AUTO_INCREMENT, `cour_name` varchar(255) COLLATE utf8_bin DEFAULT NULL, `cour_addr` varchar(255) COLLATE utf8_bin DEFAULT NULL, `cour_time` varchar(255) COLLATE utf8_bin DEFAULT NULL, `cour_long` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`cour_id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*Data for the table `cour` */ insert into `cour`(`cour_id`,`cour_name`,`cour_addr`,`cour_time`,`cour_long`) values (1,'英语','1-5-502','周一下午','40'),(2,'数学','1-2-202','周二下午','35'); /*Table structure for table `sc` */ DROP TABLE IF EXISTS `sc`; CREATE TABLE `sc` ( `sc_id` int(11) NOT NULL AUTO_INCREMENT, `fk_stu_id` int(11) DEFAULT NULL, `fk_cour_id` int(11) DEFAULT NULL, `sc_score` int(11) DEFAULT NULL, PRIMARY KEY (`sc_id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*Data for the table `sc` */ insert into `sc`(`sc_id`,`fk_stu_id`,`fk_cour_id`,`sc_score`) values (2,1,2,90),(4,2,1,85); /*Table structure for table `stu` */ DROP TABLE IF EXISTS `stu`; CREATE TABLE `stu` ( `stu_id` int(11) NOT NULL AUTO_INCREMENT, `stu_name` varchar(255) COLLATE utf8_bin DEFAULT NULL, `stu_code` varchar(255) COLLATE utf8_bin DEFAULT NULL, `stu_clazz` varchar(255) COLLATE utf8_bin DEFAULT NULL, `stu_tel` varchar(255) COLLATE utf8_bin DEFAULT NULL, `stu_card` varchar(255) COLLATE utf8_bin DEFAULT NULL, `stu_sex` int(11) DEFAULT NULL, `stu_coll` varchar(255) COLLATE utf8_bin DEFAULT NULL, `stu_year` varchar(255) COLLATE utf8_bin DEFAULT NULL, `stu_password` varchar(255) COLLATE utf8_bin DEFAULT '123456', PRIMARY KEY (`stu_id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*Data for the table `stu` */ insert into `stu`(`stu_id`,`stu_name`,`stu_code`,`stu_clazz`,`stu_tel`,`stu_card`,`stu_sex`,`stu_coll`,`stu_year`,`stu_password`) values (1,'张晓明1','20140388','1403','12345678909','2205584412685412258',1,'计算机','2014','123456'),(2,'李晓东','20150655','1506`','256874125681','2205588412655365415',-1,'计算机','2015','123456'),(3,'马晓刚','2060612','1606','12345682415','552658422562145826',1,'计算机','2016','123456'); /*Table structure for table `tea` */ DROP TABLE IF EXISTS `tea`; CREATE TABLE `tea` ( `tea_id` int(11) NOT NULL AUTO_INCREMENT, `tea_name` varchar(255) COLLATE utf8_bin DEFAULT NULL, `account` varchar(255) COLLATE utf8_bin DEFAULT NULL, `password` varchar(255) COLLATE utf8_bin DEFAULT '123456', `status` int(11) DEFAULT NULL, `tea_tel` varchar(255) COLLATE utf8_bin DEFAULT NULL, `tea_card` varchar(255) COLLATE utf8_bin DEFAULT NULL, `tea_coll` varchar(255) COLLATE utf8_bin DEFAULT NULL, `tea_sex` int(11) DEFAULT NULL, `tea_img` varchar(255) COLLATE utf8_bin DEFAULT '1.jpg', PRIMARY KEY (`tea_id`) ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*Data for the table `tea` */ insert into `tea`(`tea_id`,`tea_name`,`account`,`password`,`status`,`tea_tel`,`tea_card`,`tea_coll`,`tea_sex`,`tea_img`) values (1,'孟祥玉','admin','1234',1,'12345678901','112558441255625842','计算机',1,'c50bb77db62d46bc80fad14bc5001b46.jpg'),(4,'1','1','123456',1,'1','1','1',1,'1.jpg'),(5,'1','1','1',1,'1','1','1',1,'1.jpg'),(6,'1','1','1',1,'1','1','1',1,'1.jpg'),(7,'1','1','1',1,'1','1','1',1,'1.jpg'),(8,'1','1','123456',1,'1','1','1',1,'1.jpg'),(9,'1','1','123456',1,'1','1','1',1,'1.jpg'),(10,'1','1','123456',1,'1','1','1',1,'1.jpg'),(11,'1','1','123456',1,'1','1','1',1,'1.jpg'); /*!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 */;