高校校企合作平臺設(shè)計(jì)與實(shí)現(xiàn)-計(jì)算機(jī)畢業(yè)設(shè)計(jì)源碼+LW文檔
數(shù)據(jù)庫腳本：
/*
Navicat MySQL Data Transfer
Source Server? ? ? ? ?: localhost_3306
Source Server Version : 50561
Source Host? ? ? ? ? ?: localhost:3306
Source Database? ? ? ?: ssmgxxqhzpthsg2825cg
Target Server Type? ? : MYSQL
Target Server Version : 50561
File Encoding? ? ? ? ?: 65001
Date: 2022-02-28 16:04:44
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `allusers`
-- ----------------------------
DROP TABLE IF EXISTS `allusers`;
CREATE TABLE `allusers` (
? `id` int(11) NOT NULL AUTO_INCREMENT,
? `username` varchar(50) DEFAULT NULL,
? `pwd` varchar(50) DEFAULT NULL,
? `cx` varchar(50) DEFAULT '普通管理員',
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312;
-- ----------------------------
-- Records of allusers
-- ----------------------------
INSERT INTO `allusers` VALUES ('2', 'hsg', 'hsg', '超級管理員', '2022-02-28 15:30:39');
-- ----------------------------
-- Table structure for `banjixinxi`
-- ----------------------------
DROP TABLE IF EXISTS `banjixinxi`;
CREATE TABLE `banjixinxi` (
? `id` int(11) NOT NULL AUTO_INCREMENT,
? `banji` varchar(50) DEFAULT NULL,
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=gb2312;
-- ----------------------------
-- Records of banjixinxi
-- ----------------------------
INSERT INTO `banjixinxi` VALUES ('2', 'A02', '2022-02-28 15:30:39');
INSERT INTO `banjixinxi` VALUES ('3', 'A03', '2022-02-28 15:30:39');
INSERT INTO `banjixinxi` VALUES ('4', 'E02', '2022-02-28 15:30:39');
INSERT INTO `banjixinxi` VALUES ('5', 'E01', '2022-02-28 15:30:39');
INSERT INTO `banjixinxi` VALUES ('6', 'C01', '2022-02-28 15:30:39');
INSERT INTO `banjixinxi` VALUES ('7', 'B02', '2022-02-28 15:30:39');
INSERT INTO `banjixinxi` VALUES ('8', 'B01', '2022-02-28 15:30:39');
INSERT INTO `banjixinxi` VALUES ('9', '計(jì)算機(jī)一班', '2022-02-28 15:30:39');
-- ----------------------------
-- Table structure for `jiaoxuedagang`
-- ----------------------------
DROP TABLE IF EXISTS `jiaoxuedagang`;
CREATE TABLE `jiaoxuedagang` (
? `id` int(11) NOT NULL AUTO_INCREMENT,
? `kecheng` varchar(50) DEFAULT NULL,
? `jiaoxuemubiao` text,
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=gb2312;
-- ----------------------------
-- Records of jiaoxuedagang
-- ----------------------------
INSERT INTO `jiaoxuedagang` VALUES ('2', '法律', '', '2022-02-28 15:30:39');
INSERT INTO `jiaoxuedagang` VALUES ('3', '法律', '', '2022-02-28 15:30:39');
INSERT INTO `jiaoxuedagang` VALUES ('4', '軟件工程', '', '2022-02-28 15:30:39');
INSERT INTO `jiaoxuedagang` VALUES ('5', '軟件工程', '', '2022-02-28 15:30:39');
INSERT INTO `jiaoxuedagang` VALUES ('6', '軟件工程', '', '2022-02-28 15:30:39');
INSERT INTO `jiaoxuedagang` VALUES ('7', '法律', '', '2022-02-28 15:30:39');
INSERT INTO `jiaoxuedagang` VALUES ('8', '政治', '', '2022-02-28 15:30:39');
INSERT INTO `jiaoxuedagang` VALUES ('9', '政治', '', '2022-02-28 15:30:39');
INSERT INTO `jiaoxuedagang` VALUES ('10', '線性代數(shù)', '我確認(rèn)', '2022-02-28 15:39:35');
-- ----------------------------
-- Table structure for `kaikejihua`
-- ----------------------------
DROP TABLE IF EXISTS `kaikejihua`;
CREATE TABLE `kaikejihua` (
? `id` int(11) NOT NULL AUTO_INCREMENT,
? `zhuti` varchar(50) DEFAULT NULL,
? `kecheng` varchar(50) DEFAULT NULL,
? `jihua` text,
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=gb2312;
-- ----------------------------
-- Records of kaikejihua
-- ----------------------------
INSERT INTO `kaikejihua` VALUES ('2', '', '數(shù)學(xué)', '', '2022-02-28 15:30:39');
INSERT INTO `kaikejihua` VALUES ('3', '', '法律', '', '2022-02-28 15:30:39');
INSERT INTO `kaikejihua` VALUES ('4', '', '語文', '', '2022-02-28 15:30:39');
INSERT INTO `kaikejihua` VALUES ('5', '', '線性代數(shù)', '', '2022-02-28 15:30:39');
INSERT INTO `kaikejihua` VALUES ('6', '', '軟件工程', '', '2022-02-28 15:30:39');
INSERT INTO `kaikejihua` VALUES ('7', '', '計(jì)算機(jī)', '', '2022-02-28 15:30:39');
INSERT INTO `kaikejihua` VALUES ('8', '', '法律', '', '2022-02-28 15:30:39');
INSERT INTO `kaikejihua` VALUES ('9', '', '法律', '', '2022-02-28 15:30:39');
INSERT INTO `kaikejihua` VALUES ('10', 'rwr完全', '線性代數(shù)', '我確認(rèn)w\'q', '2022-02-28 15:39:40');
-- ----------------------------
-- Table structure for `kechengchengjidan`
-- ----------------------------
DROP TABLE IF EXISTS `kechengchengjidan`;
CREATE TABLE `kechengchengjidan` (
? `id` int(11) NOT NULL AUTO_INCREMENT,
? `kecheng` varchar(50) DEFAULT NULL,
? `xuehao` varchar(50) DEFAULT NULL,
? `xingming` varchar(50) DEFAULT NULL,
? `banji` varchar(50) DEFAULT NULL,
? `chengji` varchar(50) DEFAULT NULL,
? `xueqi` varchar(50) DEFAULT NULL,
? `beizhu` varchar(500) DEFAULT NULL,
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312;
-- ----------------------------
-- Records of kechengchengjidan
-- ----------------------------
INSERT INTO `kechengchengjidan` VALUES ('2', '線性代數(shù)', '001', '馬慶炳', '計(jì)算機(jī)一班', '55', '2022上半學(xué)期', '我確認(rèn)', '2022-02-28 15:39:49');
-- ----------------------------
-- Table structure for `kechengxiaojie`
-- ----------------------------
DROP TABLE IF EXISTS `kechengxiaojie`;
CREATE TABLE `kechengxiaojie` (
? `id` int(11) NOT NULL AUTO_INCREMENT,
? `kecheng` varchar(50) DEFAULT NULL,
? `zongjie` text,
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=gb2312;
-- ----------------------------
-- Records of kechengxiaojie
-- ----------------------------
INSERT INTO `kechengxiaojie` VALUES ('2', '計(jì)算機(jī)', '', '2022-02-28 15:30:39');
INSERT INTO `kechengxiaojie` VALUES ('3', '政治', '', '2022-02-28 15:30:39');
INSERT INTO `kechengxiaojie` VALUES ('4', '英語', '', '2022-02-28 15:30:39');
INSERT INTO `kechengxiaojie` VALUES ('5', '政治', '', '2022-02-28 15:30:39');
INSERT INTO `kechengxiaojie` VALUES ('6', '計(jì)算機(jī)', '', '2022-02-28 15:30:39');
INSERT INTO `kechengxiaojie` VALUES ('7', '語文', '', '2022-02-28 15:30:39');
INSERT INTO `kechengxiaojie` VALUES ('8', '法律', '', '2022-02-28 15:30:39');
INSERT INTO `kechengxiaojie` VALUES ('9', '英語', '', '2022-02-28 15:30:39');
INSERT INTO `kechengxiaojie` VALUES ('10', '線性代數(shù)', '我去熱武器', '2022-02-28 15:39:58');
-- ----------------------------
-- Table structure for `kechengxinxi`
-- ----------------------------
DROP TABLE IF EXISTS `kechengxinxi`;
CREATE TABLE `kechengxinxi` (
? `id` int(11) NOT NULL AUTO_INCREMENT,
? `kecheng` varchar(50) DEFAULT NULL,
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=gb2312;
-- ----------------------------
-- Records of kechengxinxi
-- ----------------------------
INSERT INTO `kechengxinxi` VALUES ('2', '計(jì)算機(jī)', '2022-02-28 15:30:39');
INSERT INTO `kechengxinxi` VALUES ('3', '軟件工程', '2022-02-28 15:30:39');
INSERT INTO `kechengxinxi` VALUES ('4', '法律', '2022-02-28 15:30:39');
INSERT INTO `kechengxinxi` VALUES ('5', '數(shù)學(xué)', '2022-02-28 15:30:39');
INSERT INTO `kechengxinxi` VALUES ('6', '政治', '2022-02-28 15:30:39');
INSERT INTO `kechengxinxi` VALUES ('7', '語文', '2022-02-28 15:30:39');
INSERT INTO `kechengxinxi` VALUES ('8', '英語', '2022-02-28 15:30:39');
INSERT INTO `kechengxinxi` VALUES ('9', '線性代數(shù)', '2022-02-28 15:30:39');
-- ----------------------------
-- Table structure for `peiyangfangan`
-- ----------------------------
DROP TABLE IF EXISTS `peiyangfangan`;
CREATE TABLE `peiyangfangan` (
? `id` int(11) NOT NULL AUTO_INCREMENT,
? `zhuti` varchar(50) DEFAULT NULL,
? `fangan` text,
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=gb2312;
-- ----------------------------
-- Records of peiyangfangan
-- ----------------------------
INSERT INTO `peiyangfangan` VALUES ('2', '', '', '2022-02-28 15:30:39');
INSERT INTO `peiyangfangan` VALUES ('3', '', '', '2022-02-28 15:30:39');
INSERT INTO `peiyangfangan` VALUES ('4', '', '', '2022-02-28 15:30:39');
INSERT INTO `peiyangfangan` VALUES ('5', '', '', '2022-02-28 15:30:39');
INSERT INTO `peiyangfangan` VALUES ('6', '', '', '2022-02-28 15:30:39');
INSERT INTO `peiyangfangan` VALUES ('7', '', '', '2022-02-28 15:30:39');
INSERT INTO `peiyangfangan` VALUES ('8', '', '', '2022-02-28 15:30:39');
INSERT INTO `peiyangfangan` VALUES ('9', '', '', '2022-02-28 15:30:39');
INSERT INTO `peiyangfangan` VALUES ('10', '我確認(rèn)我確認(rèn)w\'q', '<p style=\"text-align:center;\">\r\n?請問人情味\r\n</p>\r\n<p style=\"text-align:left;\">\r\n?<table style=\"width:100%;\" cellpadding=\"2\" cellspacing=\"0\" border=\"1\" bordercolor=\"#000000\">\r\n?<tbody>\r\n?<tr>\r\n?<td>\r\n?<br />\r\n?</td>\r\n?<td>\r\n?<br />\r\n?</td>\r\n?</tr>\r\n?<tr>\r\n?<td>\r\n?<br />\r\n?</td>\r\n?<td>\r\n?<br />\r\n?</td>\r\n?</tr>\r\n?<tr>\r\n?<td>\r\n?<br />\r\n?</td>\r\n?<td>\r\n?<br />\r\n?</td>\r\n?</tr>\r\n?</tbody>\r\n?</table>\r\n<br />\r\n<span id=\"__kindeditor_bookmark_start_4__\"></span>\r\n</p>', '2022-02-28 15:39:27');
-- ----------------------------
-- Table structure for `qiye`
-- ----------------------------
DROP TABLE IF EXISTS `qiye`;
CREATE TABLE `qiye` (
? `id` int(11) NOT NULL AUTO_INCREMENT,
? `qiyehao` varchar(50) DEFAULT NULL,
? `mima` varchar(50) DEFAULT NULL,
? `qiyemingcheng` varchar(50) DEFAULT NULL,
? `suoshuxingye` varchar(50) DEFAULT NULL,
? `fuzeren` varchar(50) DEFAULT NULL,
? `lianxidianhua` varchar(50) DEFAULT NULL,
? `qiyedizhi` varchar(50) DEFAULT NULL,
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=gb2312;
-- ----------------------------
-- Records of qiye
-- ----------------------------
INSERT INTO `qiye` VALUES ('2', '006', '001', '星河網(wǎng)絡(luò)有限公司', '教育行業(yè)', '005', '13623256544', '鑫和錦園2棟', '2022-02-28 15:30:39');
INSERT INTO `qiye` VALUES ('3', '009', '001', '南京醫(yī)藥股份有限公司', '餐飲行業(yè)', '011', '13025896548', '人民路57號', '2022-02-28 15:30:39');
INSERT INTO `qiye` VALUES ('4', '013', '001', '蒼南儀表有限公司', '行政行業(yè)', '034', '13748589658', '方城麗圓11幢201室', '2022-02-28 15:30:39');
INSERT INTO `qiye` VALUES ('5', '011', '001', '華萊士有限公司', '服務(wù)行業(yè)', '032', '13587835380', '上江小區(qū)2幢', '2022-02-28 15:30:39');
INSERT INTO `qiye` VALUES ('6', '020', '001', '九州通醫(yī)藥集團(tuán)股份有限公司', '教育行業(yè)', '027', '18956482221', '龍翔路11號', '2022-02-28 15:30:39');
INSERT INTO `qiye` VALUES ('7', '021', '001', '廣州醫(yī)藥有限公司', '餐飲行業(yè)', '033', '13910215489', '復(fù)興街27號', '2022-02-28 15:30:39');
INSERT INTO `qiye` VALUES ('8', '023', '001', '上海市醫(yī)藥股份有限公司', '醫(yī)藥行業(yè)', '010', '17505772420', '泰興路22號', '2022-02-28 15:30:39');
INSERT INTO `qiye` VALUES ('9', '001', '001', '中國醫(yī)藥集團(tuán)總公司', '行政行業(yè)', '001', '13052154877', '河濱東路139號', '2022-02-28 15:30:39');
-- ----------------------------
-- Table structure for `xuefenzhihuan`
-- ----------------------------
DROP TABLE IF EXISTS `xuefenzhihuan`;
CREATE TABLE `xuefenzhihuan` (
? `id` int(11) NOT NULL AUTO_INCREMENT,
? `leixing` varchar(50) DEFAULT NULL,
? `xuehao` varchar(50) DEFAULT NULL,
? `xingming` varchar(50) DEFAULT NULL,
? `banji` varchar(50) DEFAULT NULL,
? `fudaoyuanxingming` varchar(50) DEFAULT NULL,
? `xuefen` varchar(50) DEFAULT NULL,
? `beizhu` varchar(500) DEFAULT NULL,
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=gb2312;
-- ----------------------------
-- Records of xuefenzhihuan
-- ----------------------------
INSERT INTO `xuefenzhihuan` VALUES ('2', '華為考證', '008', '喬維', 'A02', 'fudaoyuan趙小型', '1', '沒問題', '2022-02-28 15:30:39');
INSERT INTO `xuefenzhihuan` VALUES ('3', '華為考證', '027', '梅西', 'B02', 'fudaoyuan連小云', '5', 'abc', '2022-02-28 15:30:39');
INSERT INTO `xuefenzhihuan` VALUES ('4', '華為考證', '001', '馬慶炳', 'B03', 'fudaoyuan科比', '5', '無', '2022-02-28 15:30:39');
INSERT INTO `xuefenzhihuan` VALUES ('5', '華為考證', '006', '趙小型', 'A02', 'fudaoyuan黃行陽', '4', 'abc', '2022-02-28 15:30:39');
INSERT INTO `xuefenzhihuan` VALUES ('6', '華為考證', '019', '魯艾弈', 'C01', 'fudaoyuan吳官本', '1', 'ok', '2022-02-28 15:30:39');
INSERT INTO `xuefenzhihuan` VALUES ('7', '華為考證', '013', '邱建彰', 'E02', 'fudaoyuan詹姆斯', '4', 'abc', '2022-02-28 15:30:39');
INSERT INTO `xuefenzhihuan` VALUES ('8', '課程學(xué)分', '001', '馬慶炳', 'B03', 'fudaoyuan溫宗達(dá)', '4', '無', '2022-02-28 15:30:39');
INSERT INTO `xuefenzhihuan` VALUES ('9', '華為考證', '001', '馬慶炳', 'B03', 'fudaoyuan陳小巧', '4', '沒問題', '2022-02-28 15:30:39');
INSERT INTO `xuefenzhihuan` VALUES ('10', '課程學(xué)分', '001', '馬慶炳', '計(jì)算機(jī)一班', 'fudaoyuan馬慶炳', '5', '', '2022-02-28 15:43:09');
INSERT INTO `xuefenzhihuan` VALUES ('11', '華為考證', '001', '馬慶炳', '計(jì)算機(jī)一班', 'fudaoyuan馬慶炳', '10', 'qwrwq', '2022-02-28 15:43:15');
-- ----------------------------
-- Table structure for `xuesheng`
-- ----------------------------
DROP TABLE IF EXISTS `xuesheng`;
CREATE TABLE `xuesheng` (
? `id` int(11) NOT NULL AUTO_INCREMENT,
? `xuehao` varchar(50) DEFAULT NULL,
? `mima` varchar(50) DEFAULT NULL,
? `xingming` varchar(50) DEFAULT NULL,
? `xingbie` varchar(50) DEFAULT NULL,
? `banji` varchar(50) DEFAULT NULL,
? `fudaoyuanxingming` varchar(50) DEFAULT NULL,
? `zhaopian` varchar(50) DEFAULT NULL,
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=gb2312;
-- ----------------------------
-- Records of xuesheng
-- ----------------------------
INSERT INTO `xuesheng` VALUES ('2', '008', '001', '喬維', '女', 'A02', 'fudaoyuan喬維', 'upload/xuesheng3.jpg', '2022-02-28 15:30:39');
INSERT INTO `xuesheng` VALUES ('3', '006', '001', '趙小型', '女', 'A02', 'fudaoyuan趙小型', 'upload/xuesheng7.jpg', '2022-02-28 15:30:39');
INSERT INTO `xuesheng` VALUES ('4', '019', '001', '魯艾弈', '女', 'C01', 'fudaoyuan魯艾弈', 'upload/xuesheng3.jpg', '2022-02-28 15:30:39');
INSERT INTO `xuesheng` VALUES ('5', '027', '001', '梅西', '男', 'B02', 'fudaoyuan梅西', 'upload/xuesheng3.jpg', '2022-02-28 15:30:39');
INSERT INTO `xuesheng` VALUES ('6', '016', '001', '方之明', '女', 'C01', 'fudaoyuan方之明', 'upload/xuesheng4.jpg', '2022-02-28 15:30:39');
INSERT INTO `xuesheng` VALUES ('7', '012', '001', '霍建華', '女', 'B03', 'fudaoyuan霍建華', 'upload/xuesheng1.jpg', '2022-02-28 15:30:39');
INSERT INTO `xuesheng` VALUES ('8', '013', '001', '邱建彰', '女', 'E02', 'fudaoyuan邱建彰', 'upload/xuesheng5.jpg', '2022-02-28 15:30:39');
INSERT INTO `xuesheng` VALUES ('9', '001', '001', '馬慶炳', '女', '計(jì)算機(jī)一班', 'fudaoyuan馬慶炳', 'upload/xuesheng5.jpg', '2022-02-28 15:30:39');
