基于SSH框架的高考志愿管理系统，里面有数据库文件

/* Navicat MySQL Data Transfer Source Server : localhost_3306 Source Server Version : 50096 Source Host : localhost:3306 Source Database : gaokaodb2 Target Server Type : MYSQL Target Server Version : 50096 File Encoding : 65001 Date: 2018-08-21 16:45:04 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `baokaozhinan` -- ---------------------------- DROP TABLE IF EXISTS `baokaozhinan`; CREATE TABLE `baokaozhinan` ( `id` varchar(255) collate utf8_unicode_ci NOT NULL, `school_id` varchar(255) collate utf8_unicode_ci default NULL, `baokaozhangcheng` varchar(255) collate utf8_unicode_ci default NULL, `baokaoriqi` varchar(255) collate utf8_unicode_ci default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- ---------------------------- -- Records of baokaozhinan -- ---------------------------- -- ---------------------------- -- Table structure for `department` -- ---------------------------- DROP TABLE IF EXISTS `department`; CREATE TABLE `department` ( `id` varchar(255) collate utf8_unicode_ci NOT NULL, `professional_id` varchar(255) collate utf8_unicode_ci default NULL, `school_id` varchar(255) collate utf8_unicode_ci default NULL, `department_name` varchar(255) collate utf8_unicode_ci default NULL, `zhuanyepingji` varchar(255) collate utf8_unicode_ci default NULL, `jibie` varchar(255) collate utf8_unicode_ci default NULL, `department_id` varchar(255) collate utf8_unicode_ci default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- ---------------------------- -- Records of department -- ---------------------------- INSERT INTO `department` VALUES ('1', '1', '1', '哲学', '3', '本科', null); INSERT INTO `department` VALUES ('10', '10', '9', '工学', '5', '本科', null); INSERT INTO `department` VALUES ('11', '11', '8', '交通运输', '3', '专科', null); INSERT INTO `department` VALUES ('12', '12', '15', '交通运输', '2', '专科', null); INSERT INTO `department` VALUES ('13', '13', '14', '农林牧渔', '3', '专科', null); INSERT INTO `department` VALUES ('14', '14', '18', '电子信息', '3', '专科', null); INSERT INTO `department` VALUES ('15', '15', '12', '农林牧渔', '3', '专科', null); INSERT INTO `department` VALUES ('16', '1', '2', '哲学', '3', '本科', null); INSERT INTO `department` VALUES ('17', '10', '3', '工学', '5', '本科', null); INSERT INTO `department` VALUES ('18', '11', '3', '交通运输', '3', '专科', null); INSERT INTO `department` VALUES ('19', '12', '9', '交通运输', '2', '专科', null); INSERT INTO `department` VALUES ('2', '2', '1', '哲学', '2', '本科', null); INSERT INTO `department` VALUES ('20', '13', '11', '农林牧渔', '3', '专科', null); INSERT INTO `department` VALUES ('21', '14', '3', '电子信息', '3', '专科', null); INSERT INTO `department` VALUES ('22', '15', '1', '农林牧渔', '3', '专科', null); INSERT INTO `department` VALUES ('23', '2', '11', '哲学', '2', '本科', null); INSERT INTO `department` VALUES ('24', '4', '14', '经济学', '4', '本科', null); INSERT INTO `department` VALUES ('25', '5', '13', '经济学', '4', '本科', null); INSERT INTO `department` VALUES ('26', '6', '16', '法学', '3', '本科', null); INSERT INTO `department` VALUES ('27', '7', '15', '法学', '2', '本科', null); INSERT INTO `department` VALUES ('28', '8', '17', '理学', '4', '本科', null); INSERT INTO `department` VALUES ('29', '9', '18', '工学', '5', '本科', null); INSERT INTO `department` VALUES ('3', '3', '2', '经济学', '3', '本科', null); INSERT INTO `department` VALUES ('30', '3', '12', '经济学', '3', '本科', null); INSERT INTO `department` VALUES ('4', '4', '4', '经济学', '4', '本科', null); INSERT INTO `department` VALUES ('5', '5', '3', '经济学', '4', '本科', null); INSERT INTO `department` VALUES ('6', '6', '6', '法学', '3', '本科', null); INSERT INTO `department` VALUES ('7', '7', '5', '法学', '2', '本科', null); INSERT INTO `department` VALUES ('8', '8', '7', '理学', '4', '本科', null); INSERT INTO `department` VALUES ('9', '9', '8', '工学', '5', '本科', null); -- ---------------------------- -- Table structure for `gaoxiaofenshuxian` -- ---------------------------- DROP TABLE IF EXISTS `gaoxiaofenshuxian`; CREATE TABLE `gaoxiaofenshuxian` ( `id` varchar(255) collate utf8_unicode_ci NOT NULL, `school_id` varchar(255) collate utf8_unicode_ci default NULL, `kaoshengleibie` varchar(255) collate utf8_unicode_ci default NULL, `zhaoshengpici` varchar(255) collate utf8_unicode_ci default NULL, `zhaoshengnianfen` varchar(255) collate utf8_unicode_ci default NULL, `low_score` varchar(255) collate utf8_unicode_ci default NULL, `high_score` varchar(255) collate utf8_unicode_ci default NULL, `average_score` varchar(255) collate utf8_unicode_ci default NULL, `shengkongxian` varchar(255) collate utf8_unicode_ci default NULL, `zhaoshengshengfen` varchar(255) collate utf8_unicode_ci default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- ---------------------------- -- Records of gaoxiaofenshuxian -- ---------------------------- INSERT INTO `gaoxiaofenshuxian` VALUES ('1', '1', '理科', '本科第一批次', '2018', '694', '720', '705', '505', '安徽'); INSERT INTO `gaoxiaofenshuxian` VALUES ('2', '1', '理科', '本科第一批次', '2017', '677', '-', '-', '487', '安徽'); INSERT INTO `gaoxiaofenshuxian` VALUES ('3', '1', '理科', '本科第一批次', '2016', '688', '-', '-', '518', '安徽'); INSERT INTO `gaoxiaofenshuxian` VALUES ('4', '1', '理科', '本科第一批次', '2015', '693', '-', '695', '555', '安徽'); INSERT INTO `gaoxiaofenshuxian` VALUES ('5', '1', '理科', '本科第一批次', '2018', '671', '-', '-', '537', '北京'); INSERT INTO `gaoxiaofenshuxian` VALUES ('6', '1', '理科', '本科第一批次', '2017', '678', '-', '-', '548', '北京'); -- ---------------------------- -- Table structure for `professional` -- ---------------------------- DROP TABLE IF EXISTS `professional`; CREATE TABLE `professional` ( `professional_id` varchar(255) collate utf8_unicode_ci NOT NULL, `professional_name` varchar(255) collate utf8_unicode_ci default NULL, `category` varchar(255) collate utf8_unicode_ci default NULL, `xiuyenianxian` varchar(255) collate utf8_unicode_ci default NULL, `shouyuxuewei` varchar(255) collate utf8_unicode_ci default NULL, `zhuyaokecheng` varchar(255) collate utf8_unicode_ci default NULL, `mubiao` varchar(255) collate utf8_unicode_ci default NULL, `jiuyeqianjing` varchar(255) collate utf8_unicode_ci default NULL, `jubeinengli` varchar(255) collate utf8_unicode_ci default NULL, `zhuanyeredu` varchar(255) collate utf8_unicode_ci default NULL, `biyewunianpingjunxinchou` varchar(255) collate utf8_unicode_ci default NULL, PRIMARY KEY (`professional_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- ---------------------------- -- Records of professional -- ---------------------------- INSERT INTO `professional` VALUES ('1', '逻辑学', '哲学类', '4年', '哲学学士', ' 数学分析、高等代数、抽象代数、概率统计、逻辑导论、数理逻辑、集合论、模态逻辑、归纳逻辑、四论导引 ( 公理集合论、模型论、递归论、证明论 ) 、应用逻辑、逻辑史、逻辑哲学、程序语言设计、操作系统等。', '本专业培养具备系统的逻辑学基础知识 , 一定的数学素养以及计算机理论和操作能力 , 能在高等院校、科研单位、国家机关及企事业管理部门从事逻辑学的教学、科研和应用方面的工作 ,并能从事计算机科学和语言学的科研和应用方面相关工作的逻辑学高