高校校企合作平台设计与实现-计算机毕业设计源码+LW文档

数据库脚本：

/*
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', '计算机一班', '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', '线性代数', '我确认', '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', '', '数学', '', '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', '', '线性代数', '', '2022-02-28 15:30:39');
INSERT INTO `kaikejihua` VALUES ('6', '', '软件工程', '', '2022-02-28 15:30:39');
INSERT INTO `kaikejihua` VALUES ('7', '', '计算机', '', '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完全', '线性代数', '我确认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', '线性代数', '001', '马庆炳', '计算机一班', '55', '2022上半学期', '我确认', '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', '计算机', '', '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', '计算机', '', '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', '线性代数', '我去热武器', '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', '计算机', '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', '数学', '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', '线性代数', '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', '我确认我确认w\'q', '

\r\n 请问人情味\r\n

\r\n

\r\n 

\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n 

\r\n  \r\n	\r\n  \r\n
\r\n  \r\n	\r\n  \r\n
\r\n  \r\n	\r\n  \r\n

\r\n
\r\n\r\n

', '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', '星河网络有限公司', '教育行业', '005', '13623256544', '鑫和锦园2栋', '2022-02-28 15:30:39');
INSERT INTO `qiye` VALUES ('3', '009', '001', '南京医药股份有限公司', '餐饮行业', '011', '13025896548', '人民路57号', '2022-02-28 15:30:39');
INSERT INTO `qiye` VALUES ('4', '013', '001', '苍南仪表有限公司', '行政行业', '034', '13748589658', '方城丽圆11幢201室', '2022-02-28 15:30:39');
INSERT INTO `qiye` VALUES ('5', '011', '001', '华莱士有限公司', '服务行业', '032', '13587835380', '上江小区2幢', '2022-02-28 15:30:39');
INSERT INTO `qiye` VALUES ('6', '020', '001', '九州通医药集团股份有限公司', '教育行业', '027', '18956482221', '龙翔路11号', '2022-02-28 15:30:39');
INSERT INTO `qiye` VALUES ('7', '021', '001', '广州医药有限公司', '餐饮行业', '033', '13910215489', '复兴街27号', '2022-02-28 15:30:39');
INSERT INTO `qiye` VALUES ('8', '023', '001', '上海市医药股份有限公司', '医药行业', '010', '17505772420', '泰兴路22号', '2022-02-28 15:30:39');
INSERT INTO `qiye` VALUES ('9', '001', '001', '中国医药集团总公司', '行政行业', '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', '课程学分', '001', '马庆炳', 'B03', 'fudaoyuan温宗达', '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', '课程学分', '001', '马庆炳', '计算机一班', 'fudaoyuan马庆炳', '5', '', '2022-02-28 15:43:09');
INSERT INTO `xuefenzhihuan` VALUES ('11', '华为考证', '001', '马庆炳', '计算机一班', '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', '马庆炳', '女', '计算机一班', 'fudaoyuan马庆炳', 'upload/xuesheng5.jpg', '2022-02-28 15:30:39');

 

 

 

 

​