数据库脚本：
/* 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
\r\n<p style=\"text-align:left;\">\r\n <table style=\"width:100%;\" cellpadding=\"2\" cellspacing=\"0\" border=\"1\" bordercolor=\"#000000\">\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<span id=\"kindeditor_bookmark_start_4\">\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');
