/* Navicat Premium Data Transfer Source Server : localhost_3306 Source Server Type : MySQL Source Server Version : 80011 Source Host : localhost:3306 Source Schema : mycourse2 Target Server Type : MySQL Target Server Version : 80011 File Encoding : 65001 Date: 04/07/2020 22:51:58 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for course -- ---------------------------- DROP TABLE IF EXISTS `course`; CREATE TABLE `course` ( `id` int(6) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '课程id 自动增长', `code` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '课程邀请码 唯一', `name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '课程名称 默认为空', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '课程创建时间', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `unique_course_code`(`code`) USING BTREE COMMENT '课程邀请码 唯一索引' ) ENGINE = InnoDB AUTO_INCREMENT = 38 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of course -- ---------------------------- INSERT INTO `course` VALUES (26, 'DFFA23', '操作系统', '2019-06-26 16:10:47'); INSERT INTO `course` VALUES (27, '23FFAA', '数据结构', '2019-06-26 16:11:03'); INSERT INTO `course` VALUES (28, '343FFF', '计算机网络', '2019-06-27 16:11:18'); INSERT INTO `course` VALUES (29, 'FDFF23', '计算机组成原理', '2019-06-26 16:11:35'); INSERT INTO `course` VALUES (32, '9A5EFD', '信息安全', '2019-06-26 20:57:09'); INSERT INTO `course` VALUES (33, '241B08', '软件体系结构', '2019-06-26 21:01:03'); INSERT INTO `course` VALUES (34, '9D963A', 'test', '2019-06-26 21:31:00'); INSERT INTO `course` VALUES (35, 'F2000D', '1111', '2019-06-28 14:43:12'); INSERT INTO `course` VALUES (37, '04429F', '222', '2019-07-02 16:10:07'); INSERT INTO `course` VALUES (38, '52784E', '222', '2020-07-04 22:26:39'); -- ---------------------------- -- Table structure for course_student -- ---------------------------- DROP TABLE IF EXISTS `course_student`; CREATE TABLE `course_student` ( `course_id` int(6) UNSIGNED NOT NULL COMMENT '课程id', `user_id` int(6) UNSIGNED NOT NULL COMMENT '学生（用户）id', `enter_time` datetime(0) NOT NULL COMMENT '加入时间', PRIMARY KEY (`course_id`, `user_id`) USING BTREE, INDEX `student_id`(`user_id`) USING BTREE, CONSTRAINT `course_student_ibfk_1` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `course_student_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of course_student -- ---------------------------- INSERT INTO `course_student` VALUES (28, 10, '2019-06-28 13:40:18'); INSERT INTO `course_student` VALUES (29, 10, '2019-06-28 14:37:52'); INSERT INTO `course_student` VALUES (33, 10, '2019-06-28 14:07:31'); INSERT INTO `course_student` VALUES (34, 10, '2019-06-28 13:49:27'); INSERT INTO `course_student` VALUES (35, 10, '2019-06-28 14:43:21'); INSERT INTO `course_student` VALUES (35, 15, '2019-06-30 15:01:49'); INSERT INTO `course_student` VALUES (35, 26, '2019-07-02 16:07:49'); -- ---------------------------- -- Table structure for course_teacher -- ---------------------------- DROP TABLE IF EXISTS `course_teacher`; CREATE TABLE `course_teacher` ( `course_id` int(6) UNSIGNED NOT NULL COMMENT '课程Id', `user_id` int(6) UNSIGNED NOT NULL COMMENT '教师（用户）id', PRIMARY KEY (`course_id`, `user_id`) USING BTREE, INDEX `user_id`(`user_id`) USING BTREE, CONSTRAINT `course_teacher_ibfk_1` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `course_teacher_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of course_teacher -- ---------------------------- INSERT INTO `course_teacher` VALUES (26, 11); INSERT INTO `course_teacher` VALUES (27, 11); INSERT INTO `course_teacher` VALUES (28, 11); INSERT INTO `course_teacher` VALUES (29, 11); INSERT INTO `course_teacher` VALUES (32, 11); INSERT INTO `course_teacher` VALUES (33, 11); INSERT INTO `course_teacher` VALUES (34, 11); INSERT INTO `course_teacher` VALUES (35, 11); INSERT INTO `course_teacher` VALUES (38, 11); INSERT INTO `course_teacher` VALUES (37, 27); -- ---------------------------- -- Table structure for notice -- ---------------------------- DROP TABLE IF EXISTS `notice`; CREATE TABLE `notice` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '公告id 自动增长', `course_id` int(6) UNSIGNED NOT NULL COMMENT '课程id 外键', `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '公告标题 默认为‘’', `content` varchar(10000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '公告内容 默认为\'\'', `writer_id` int(6) UNSIGNED NOT NULL COMMENT '公告书写写 用户id 外键', `create_time` datetime(0) NOT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '公告发布日期', `update_time` datetime(0) NOT NULL COMMENT '公告更新时间', PRIMARY KEY (`id`) USING BTREE, INDEX `course_id`(`course_id`) USING BTREE, INDEX `notice_ibfk_1`(`writer_id`) USING BTREE, CONSTRAINT `notice_ibfk_1` FOREIGN KEY (`writer_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE, CONSTRAINT `notice_ibfk_2` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE = InnoDB AUTO_INCREMENT = 25 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of notice -- ---------------------------- INSERT INTO `notice` VALUES (7, 34, '今天中文检查课设', '

今天中文检查课设

请及时到场

                                罗辑老师

', 11, '2019-06-27 18:01:36', '2019-06-27 18:01:36'); INSERT INTO `notice` VALUES (11, 34, 'Java交作业啊', '

    Java是一种广泛使用的计算机编程语言，拥有跨平台、面向对象、泛型编程的特性，广泛应用于企业级Web应用开发和移动应用开发。

    任职于太阳微系统的詹姆斯·高斯林等人于1990年代初开发Java语言的雏形，最初被命名为Oak，目标设置在家用电器等小型系统的编程语言，应用在电视机、电话、闹钟、烤面包机等家用电器的控制和通信。由于这些智能化家电的市场需求没有预期的高，Sun公司放弃了该项计划。随着1990年代互联网的发展，Sun公司看见Oak在互联网上应用的前景，于是改造了Oak，于1995年5月以Java的名称正式发布。Java伴随着互联网的迅猛发展而发展，逐渐成为重要的网络编程语言。

    Java编程语言的风格十分接近C++语言。继承了C++语言面向对象技术的核心，舍弃了容易引起错误的指针，以引用取代；移除了C++中的运算符重载和多重继承特性，用接口取代；增加垃圾回收器功能。在Java SE 1.5版本中引入了泛型编程、类型安全的枚举、不定长参数和自动装/拆箱特性。太阳微系统对Java语言的解释是：“Java编程语言是个简单、面向对象、分布式、解释性、健壮、安全与系统无关、可移植、高性能、多线程和动态的语言”

    Java不同于一般的编译语言或解释型语言。它首先将源代码编译成字节码，再依赖各种不同平台上的虚拟机来解释执行字节码，从而具有“一次编写，到处运行”的跨平台特性。在早期JVM中，这在一定程度上降低了Java程序的运行效率。但在J2SE1.4.2发布后，Java的运行速度有了大幅提升。

    与传统类型不同，Sun公司在推出Java时就将其作为开放的技术。全球的Java开发公司被要求所设计的Java软件必须相互兼容。“Java语言靠群体的力量而非公司的力量”是Sun公司的口号之一，并获得了广大软件开发商的认同。这与微软公司所倡导的注重精英和封闭式的模式完全不同，此外，微软公司后来推出了与之竞争的.NET平台以及模仿Java的C#语言。后来Sun公司被甲骨文公司并购，Java也随之成为甲骨文公司的产品。

    现时，移动操作系统Android大部分的代码采用Java编程语言编程。

import java.util.UUID;

public class GenerateCode {
    public static String generate() {
        String code;
        UUID uuid = UUID.randomUUID();
        code = uuid.toString().substring(0, 6).toUpperCase();
        return code;
    }

    public static void main(String[] args) {
        for (int i = 0; i < 10; i++)
            System.out.println(GenerateCode.generate());
    }
}


', 11, '2019-06-27 20:13:51', '2019-06-27 20:13:51'); INSERT INTO `notice` VALUES (20, 28, '测试', '

测试测试测试测试测试测试测试 测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试 


测试测试测试测试测试测试测试 测试测试测试测试测试测试测试

 测试测试测试测试测试测试测试 测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试 


测试测试测试测试测试测试测试 测试测试测试测试测试测试测试

 测试测试测试测试测试测试测试 测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试测试 


测试测试测试测试测试测试测试 测试测试测试测试测试测试测试

 

', 11, '2019-06-28 08:34:54', '2019-06-28 08:34:54'); INSERT INTO `notice` VALUES (22, 35, '测试代码', '

测试 测试

测试测测试

private final StuCourseMapper stuCourseMapper;

    @Autowired
    public StuCourseListServiceImpl(StuCourseMapper stuCourseMapper) {
        this.stuCourseMapper = stuCourseMapper;
    }


    public List<StuCourse> findSCourses(User user) {
        List<StuCourse> stuCourses = stuCourseMapper.selectByStudentId(user.getId());

        for (StuCourse stuCourse : stuCourses) {
            stuCourse.setStudentCount(stuCourseMapper.selectStudentCount(stuCourse.getId()));
            stuCourse.setTeacher(stuCourseMapper.selectTeacherByCourseId(stuCourse.getId()));
        }

        return stuCourses;
    }

    public int enterCourse(StuCourse course, User student) {
        StuCourse old = stuCourseMapper.selectByCode(course.getCode());
        if (old == null)
            return ENTER_COURSE_NOT_EXISTS;
        course.setId(old.getId());
        course.setName(old.getName());
        if (stuCourseMapper.selectEnterTimeByStudentId(course.getId(), student.getId()) != null)
            return ENTER_HAS_ENTERED;
        boolean ret = stuCourseMapper.insertCourseStudent(course.getId(), student.getId(), course.getEnterTime()) > 0;
        if (ret)
            return ENTER_SUCC;
        else
            return ENTER_FAIL;
    }


', 11, '2019-06-28 15:10:23', '2019-06-28 15:10:23'); -- ---------------------------- -- Table structure for resource -- ---------------------------- DROP TABLE IF EXISTS `resource`; CREATE TABLE `resource` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '资源id', `course_id` int(10) NOT NULL COMMENT '课程id', `file_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '文件名', `file_path` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '文件保存路径', `upload_time` datetime(0) NOT NULL COMMENT '上传时间', PRIMARY KEY (`id`) USING BTREE, INDEX `course_id`(`course_id`) USING BTREE COMMENT '课程id索引' ) ENGINE = InnoDB AUTO_INCREMENT = 45 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of resource -- ---------------------------- -- ---------------------------- -- Table structure for task -- ---------------------------- DROP TABLE IF EXISTS `task`; CREATE TABLE `task` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '作业id 自动增长', `course_id` int(6) UNSIGNED NOT NULL COMMENT '课程id', `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '作业标题 默认为\'\'', `content` varchar(10000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '作业内容 默认为\'\'', `deadline` datetime(0) NULL DEFAULT NULL COMMENT '作业截止日期', `writer_id` int(6) UNSIGNED NOT NULL COMMENT '作业布置者 用户id 外键', `create_time` datetime(0) NOT NULL COMMENT '作业布置日期', `update_time` datetime(0) NOT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE, INDEX `course_id`(`course_id`) USING BTREE, INDEX `task_writer`(`writer_id`) USING BTREE, CONSTRAINT `task_ibfk_1` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `task_ibfk_2` FOREIGN KEY (`writer_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE ) ENGINE = InnoDB AUTO_INCREMENT = 22 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of task -- ---------------------------- -- ---------------------------- -- Table structure for task_file -- ---------------------------- DROP TABLE IF EXISTS `task_file`; CREATE TABLE `task_file` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '作业', `task_id` int(10) NOT NULL COMMENT '作业id', `user_id` int(10) NOT NULL COMMENT '学生id', `upload_time` datetime(0) NOT NULL COMMENT '作业提交时间', `file_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '文件名', `file_path` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '文件路径', PRIMARY KEY (`id`) USING BTREE, INDEX `task_id`(`task_id`) USING BTREE COMMENT '作业号索引' ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of task_file -- ---------------------------- -- ---------------------------- -- Table structure for user -- ---------------------------- DROP TABLE IF EXISTS `user`; CREATE TABLE `user` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '用户姓名 自动增长', `email` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户邮箱', `password` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户密码', `role` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 's' COMMENT '用户角色 s-学生 t-教师 a-管理员 默认为s', `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用户名字 默认为\'\'', `school_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用户学号/教工号 默认为\'\'', `school` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用户学校 默认为\'\'', `dept` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用户院系 默认为\'\'', `major` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用户专业 默认为\'\'', `class` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用户班级 默认为\'\'', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `unique_user_email`(`email`) USING BTREE COMMENT '邮箱的唯一索引' ) ENGINE = InnoDB AUTO_INCREMENT = 31 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of user -- ---------------------------- INSERT INTO `user` VALUES (10, 'gt110@qq.com', '123456', 's', '高天', '20161603013', '河南工业大学', '信息科学与工程学院', '软件工程', '软件1601'); INSERT INTO `user` VALUES (11, 'teacher@qq.com', '123456', 't', '罗辑', '', '', '', '', ''); INSERT INTO `user` VALUES (15, 'test@qq.com', '123456', 's', '测试学生', '', '', '', '', ''); INSERT INTO `user` VALUES (26, '111@qq.com', '111111', 's', '111', '', '', '', '', ''); INSERT INTO `user` VALUES (27, '222@qq.com', '222222', 't', '222', '', '', '', '', ''); INSERT INTO `user` VALUES (28, 'test22@qq.com', '12343', 's', 'test', '', '', '', '', ''); SET FOREIGN_KEY_CHECKS = 1;