数据库脚本：
/*
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’, ‘<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’, ‘星河网络有限公司’, ‘教育行业’, ‘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’);