基于springboot的学生选课系统

项目描述

Springboot+mysql学生选课系统（带后台管理系统）
运行环境

jdk8+mysql+IntelliJ IDEA+maven
项目技术

springboot+mysql+mybatis

效果截图：

Source Server : localhost
Source Server Version : 50515
Source Host : localhost:3306
Source Database : student_ams

Target Server Type : MYSQL
Target Server Version : 50515
File Encoding : 65001

Date: 2017-09-01 22:25:09
*/

SET FOREIGN_KEY_CHECKS=0;

– Table structure for admin

DROP TABLE IF EXISTS ;
CREATE TABLE (
varchar(20) NOT NULL DEFAULT ‘’,
varchar(20) NOT NULL DEFAULT ‘’,
PRIMARY KEY ()
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

– Records of admin

INSERT INTO VALUES (‘admin’, ‘admin’);

– Table structure for course

DROP TABLE IF EXISTS ;
CREATE TABLE (
int(11) unsigned NOT NULL AUTO_INCREMENT,
varchar(100) NOT NULL DEFAULT ‘’,
varchar(20) NOT NULL DEFAULT ‘’,
int(11) NOT NULL,
varchar(100) NOT NULL DEFAULT ‘’,
varchar(30) NOT NULL DEFAULT ‘’,
int(11) NOT NULL,
varchar(200) NOT NULL DEFAULT ‘’,
int(11) NOT NULL,
varchar(200) DEFAULT NULL COMMENT ‘课程形象图’,
PRIMARY KEY ()
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;

– Records of course

– Table structure for student

DROP TABLE IF EXISTS ;
CREATE TABLE (
varchar(20) NOT NULL DEFAULT ‘’,
varchar(20) NOT NULL DEFAULT ‘’,
varchar(20) NOT NULL DEFAULT ‘’,
varchar(2) NOT NULL DEFAULT ‘’,
varchar(4) NOT NULL DEFAULT ‘’,
varchar(100) NOT NULL DEFAULT ‘’,
PRIMARY KEY ()
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

– Records of student

INSERT INTO VALUES (‘201309550103’, ‘123456’, ‘天山童姥1’, ‘女’, ‘2013’, ‘软件工程’);
INSERT INTO VALUES (‘201309550104’, ‘123456’, ‘陈冠希’, ‘男’, ‘2013’, ‘软件工程’);

– Table structure for study

DROP TABLE IF EXISTS ;
CREATE TABLE (
int(11) unsigned NOT NULL AUTO_INCREMENT,
varchar(20) NOT NULL DEFAULT ‘’,
varchar(20) NOT NULL DEFAULT ‘’,
varchar(100) NOT NULL DEFAULT ‘’,
int(11) NOT NULL,
varchar(100) NOT NULL DEFAULT ‘’,
varchar(100) NOT NULL DEFAULT ‘’,
int(11) NOT NULL,
varchar(20) NOT NULL DEFAULT ‘’,
PRIMARY KEY ()
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

– Records of study

文章知识点与官方知识档案匹配，可进一步学习相关知识Java技能树首页概览93625 人正在系统学习中