数据库表：

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’, ‘超级管理员’, ‘2020-03-30 15:58:07’);

– Table structure for binglixinxi

DROP TABLE IF EXISTS binglixinxi;

CREATE TABLE binglixinxi (

id int(11) NOT NULL AUTO_INCREMENT,

zhanghao varchar(50) DEFAULT NULL,

xingming varchar(50) DEFAULT NULL,

shenfenzheng varchar(50) DEFAULT NULL,

chushengnianyue varchar(50) DEFAULT NULL,

dianhua varchar(50) DEFAULT NULL,

bingshi varchar(50) DEFAULT NULL,

bingzheng varchar(500) DEFAULT NULL,

zhenduan varchar(50) DEFAULT NULL,

zhiliaofangan varchar(500) DEFAULT NULL,

addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

PRIMARY KEY (id)

) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=gb2312;

– Records of binglixinxi

INSERT INTO binglixinxi VALUES (‘2’, ‘008’, ‘郑亚斌’, ‘330327198406150488’, ‘2020-03-09’, ‘6497512’, ‘’, ‘’, ‘’, ‘’, ‘2020-03-30 15:58:07’);

INSERT INTO binglixinxi VALUES (‘3’, ‘008’, ‘郑亚斌’, ‘330327198406150488’, ‘2020-03-09’, ‘6497512’, ‘’, ‘’, ‘’, ‘’, ‘2020-03-30 15:58:07’);

INSERT INTO binglixinxi VALUES (‘4’, ‘016’, ‘霍建华’, ‘33032719900723568X’, ‘2020-03-08’, ‘4265325’, ‘’, ‘’, ‘’, ‘’, ‘2020-03-30 15:58:07’);

INSERT INTO binglixinxi VALUES (‘5’, ‘033’, ‘姚明’, ‘330327198811020456’, ‘2020-04-24’, ‘8895632’, ‘’, ‘’, ‘’, ‘’, ‘2020-03-30 15:58:07’);

INSERT INTO binglixinxi VALUES (‘6’, ‘032’, ‘王柏弘’, ‘330327185403060589’, ‘2020-03-08’, ‘8945622’, ‘’, ‘’, ‘’, ‘’, ‘2020-03-30 15:58:07’);

INSERT INTO binglixinxi VALUES (‘7’, ‘321123’, ‘陈明希’, ‘440325432176543098’, ‘2020-03-30’, ‘13214535432’, ‘123213123’, ‘13123’, ‘123123’, ‘123123’, ‘2020-03-30 16:15:56’);

– Table structure for bingrenxinxi

DROP TABLE IF EXISTS bingrenxinxi;

CREATE TABLE bingrenxinxi (

id int(11) NOT NULL AUTO_INCREMENT,

zhanghao varchar(50) DEFAULT NULL,

xingming varchar(50) DEFAULT NULL,

xingbie varchar(50) DEFAULT NULL,

shenfenzheng varchar(50) DEFAULT NULL,

最后

作为过来人，小编是整理了很多进阶架构视频资料、面试文档以及PDF的学习资料，针对上面一套系统大纲小编也有对应的相关进阶架构视频资料，如果**‘你’确定好自己未来的道路或者想学习提升自己技术栈、技术知识的小伙伴们可以提升自己（全套面试文档、PDF、进阶架构视频）**

(https://gitee.com/vip204888/java-p7)提升自己（全套面试文档、PDF、进阶架构视频）**

[外链图片转存中…(img-qFaysxop-1628439281757)] [外链图片转存中…(img-fTlYdGGT-1628439281759)]