【文件属性】：
文件名称：简单的成绩管理系统
文件大小：16.42MB
文件格式：RAR
更新时间：2022-01-28 06:28:31
javaweb
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 */;