基于SSM的家政服务预约网站设计与实现-计算机毕业设计源码+LW文档
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-03-15 16:51:57');
-- Table structure for baojieyuan
DROP TABLE IF EXISTS baojieyuan;
CREATE TABLE baojieyuan (
id int(11) NOT NULL AUTO_INCREMENT,
yonghuming varchar(50) DEFAULT NULL,
mima varchar(50) DEFAULT NULL,
xingming varchar(50) DEFAULT NULL,
xingbie varchar(50) DEFAULT NULL,
jiatingzhuzhi varchar(50) DEFAULT NULL,
lianxishouji varchar(50) DEFAULT NULL,
shenfenzheng varchar(50) DEFAULT NULL,
touxiang varchar(50) DEFAULT NULL,
beizhu varchar(500) DEFAULT NULL,
issh varchar(10) DEFAULT '否',
dianzan_d int(11) DEFAULT '0',
dianzan_c int(11) DEFAULT '0',
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=gb2312;
-- Records of baojieyuan
INSERT INTO baojieyuan VALUES ('2', '031', '001', '陈贵柏', '女', '解放路73号', '13544655202', '330327198406150488', 'upload/baojieyuan3.jpg', 'abc', '是', '0', '0', '2022-03-15 16:51:38');
INSERT INTO baojieyuan VALUES ('3', '002', '001', '何永康', '女', '复兴街27号', '13910215489', '330327198615482633', 'upload/baojieyuan6.jpg', 'ok', '是', '0', '0', '2022-03-15 16:51:38');
INSERT INTO baojieyuan VALUES ('4', '011', '001', '吴亦凡', '女', '开明路22号', '13186835580', '330327198501020300', 'upload/baojieyuan4.jpg', '无', '是', '0', '0', '2022-03-15 16:51:38');
INSERT INTO baojieyuan VALUES ('5', '025', '001', '冯子杰', '女', '泰兴路22号', '18956482221', '330327198708070789', 'upload/baojieyuan2.jpg', '无', '是', '0', '0', '2022-03-15 16:51:38');
INSERT INTO baojieyuan VALUES ('6', '009', '001', '易建联', '女', '方城丽圆11幢201室', '13025896548', '330327199504059511', 'upload/baojieyuan1.jpg', '暂无', '是', '0', '0', '2022-03-15 16:51:38');
INSERT INTO baojieyuan VALUES ('7', '003', '001', '杨颖', '男', '上江小区2幢', '13052154877', '330327198811020456', 'upload/baojieyuan8.jpg', '暂无', '是', '0', '0', '2022-03-15 16:51:38');
INSERT INTO baojieyuan VALUES ('8', '024', '001', '黄行阳', '女', '东城路99号', '13769548711', '33032719900723568X', 'upload/baojieyuan7.jpg', '无', '是', '0', '0', '2022-03-15 16:51:38');
INSERT INTO baojieyuan VALUES ('9', '001', '001', '鲁艾弈', '女', '鑫和锦园2栋', '13748589658', '330327199005060003', 'upload/baojieyuan5.jpg', '无', '是', '0', '0', '2022-03-15 16:51:38');
INSERT INTO baojieyuan VALUES ('10', '031', '001', '陈贵柏', '女', '解放路73号', '13544655202', '330327198406150488', 'upload/baojieyuan3.jpg', 'abc', '是', '0', '0', '2022-03-15 16:51:57');
INSERT INTO baojieyuan VALUES ('11', '002', '001', '何永康', '女', '复兴街27号', '13910215489', '330327198615482633', 'upload/baojieyuan6.jpg', 'ok', '是', '0', '0', '2022-03-15 16:51:57');
INSERT INTO baojieyuan VALUES ('12', '011', '001', '吴亦凡', '女', '开明路22号', '13186835580', '330327198501020300', 'upload/baojieyuan4.jpg', '无', '是', '0', '0', '2022-03-15 16:51:57');
INSERT INTO baojieyuan VALUES ('13', '025', '001', '冯子杰', '女', '泰兴路22号', '18956482221', '330327198708070789', 'upload/baojieyuan2.jpg', '无', '是', '0', '0', '2022-03-15 16:51:57');
INSERT INTO baojieyuan VALUES ('14', '009', '001', '易建联', '女', '方城丽圆11幢201室', '13025896548', '330327199504059511', 'upload/baojieyuan1.jpg', '暂无', '是', '0', '0', '2022-03-15 16:51:57');
INSERT INTO baojieyuan VALUES ('15', '003', '001', '杨颖', '男', '上江小区2幢', '13052154877', '330327198811020456', 'upload/baojieyuan8.jpg', '暂无', '是', '0', '0', '2022-03-15 16:51:57');
INSERT INTO baojieyuan VALUES ('16', '024', '001', '黄行阳', '女', '东城路99号', '13769548711', '33032719900723568X', 'upload/baojieyuan7.jpg', '无', '是', '0', '0', '2022-03-15 16:51:57');
INSERT INTO baojieyuan VALUES ('17', '001', '001', '鲁艾弈', '女', '鑫和锦园2栋', '13748589658', '330327199005060003', 'upload/baojieyuan5.jpg', '无', '是', '0', '0', '2022-03-15 16:51:57');
-- Table structure for baojieyuyue
DROP TABLE IF EXISTS baojieyuyue;
CREATE TABLE baojieyuyue (
id int(11) NOT NULL AUTO_INCREMENT,
yonghuming varchar(50) DEFAULT NULL,
xingming varchar(50) DEFAULT NULL,
lianxishouji varchar(50) DEFAULT NULL,
jiazhengleibie varchar(50) DEFAULT NULL,
dizhi varchar(50) DEFAULT NULL,
yuyueshijian datetime DEFAULT NULL,
yuyueren varchar(50) DEFAULT NULL,
beizhu varchar(500) DEFAULT NULL,
issh varchar(10) DEFAULT '否',
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=gb2312;
-- Records of baojieyuyue
INSERT INTO baojieyuyue VALUES ('4', '031', '陈贵柏', '13544655202', 'F类', '111', '2022-03-15 17:43:13', '001', '111', '是', '2022-03-15 17:43:17');
INSERT INTO baojieyuyue VALUES ('6', '002', '何永康', '13910215489', 'F类', '111', '2022-03-15 17:52:56', '001', '111', '否', '2022-03-15 17:52:59');
INSERT INTO baojieyuyue VALUES ('7', '002', '何永康', '13910215489', 'F类', '11111', '2022-03-15 17:53:28', '001', '11111', '否', '2022-03-15 17:53:32');
-- Table structure for dx
DROP TABLE IF EXISTS dx;
CREATE TABLE dx (
ID int(11) NOT NULL AUTO_INCREMENT,
leibie varchar(50) DEFAULT NULL,
content longtext,
PRIMARY KEY (ID)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
-- Records of dx
INSERT INTO dx VALUES ('1', '系统公告', '
\r\n 欢迎大家登陆我站，我站主要是为广大朋友精心制作的一个系统，希望大家能够在我站获得一个好心情，谢谢！\r\n
\r\n
\r\n 自强不息，海纳百川，努力学习！fff\r\n
');
INSERT INTO dx VALUES ('2', 'Profile', '系统简介hhrthrrrrr22ggg');
INSERT INTO dx VALUES ('3', 'AboutUs', ' 本公司坚持走:以质量求生存,以科技求发展,重合同守信用的道路,生产经营得到迅速发展。我们将以优质的产品和最完善的售后服务来真诚与各界朋友开展广泛的合作,共同创造一个美好的未来!
公司行为准则:忠信仁义，以人为本。
忠：即忠诚， 包括三重含义：企业忠于国家、忠于民族；企业忠于客户；员工忠于企业。
信：即诚信，做企业要立足根本道德、信义，要诚实、讲信用。
仁：即仁爱，上司对下属要仁爱、体贴，同事之间要关怀、友爱。
义：即大义，公司在与合作伙伴、客户的交往过程中，不做损人利己的事，维护自己利益的前提是不损害他人利益；对民族、社会要共襄义举，要识大义，明是非。
');
INSERT INTO dx VALUES ('4', '联系方式', '联系人：xxxxxxxx
电话：0000-0000000
手机：010000000000
传真：0000-0000000
邮件：xxxxxxxx@163.com
地址：您公司的地址
网址：http://www.xxxx.com');
-- Table structure for jiazhengleibie
DROP TABLE IF EXISTS jiazhengleibie;
CREATE TABLE jiazhengleibie (
id int(11) NOT NULL AUTO_INCREMENT,
leibie varchar(50) DEFAULT NULL,
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=gb2312;
-- Records of jiazhengleibie
INSERT INTO jiazhengleibie VALUES ('2', 'E类', '2022-03-15 16:51:50');
INSERT INTO jiazhengleibie VALUES ('3', 'M类', '2022-03-15 16:51:50');
INSERT INTO jiazhengleibie VALUES ('4', 'P类', '2022-03-15 16:51:50');
INSERT INTO jiazhengleibie VALUES ('5', 'J类', '2022-03-15 16:51:50');
INSERT INTO jiazhengleibie VALUES ('6', 'S类', '2022-03-15 16:51:50');
INSERT INTO jiazhengleibie VALUES ('7', 'C类', '2022-03-15 16:51:50');
INSERT INTO jiazhengleibie VALUES ('8', 'Y类', '2022-03-15 16:51:50');
INSERT INTO jiazhengleibie VALUES ('9', 'F类', '2022-03-15 16:51:50');
-- Table structure for liuyanban
DROP TABLE IF EXISTS liuyanban;
CREATE TABLE liuyanban (
id int(11) NOT NULL AUTO_INCREMENT,
cheng varchar(50) DEFAULT NULL,
xingbie varchar(50) DEFAULT NULL,
QQ varchar(50) DEFAULT NULL,
youxiang varchar(50) DEFAULT NULL,
shouji varchar(50) DEFAULT NULL,
neirong varchar(500) DEFAULT NULL,
huifuneirong varchar(500) DEFAULT NULL,
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;
-- Records of liuyanban
-- Table structure for pinglun
DROP TABLE IF EXISTS pinglun;
CREATE TABLE pinglun (
ID int(11) NOT NULL AUTO_INCREMENT,
xinwenID varchar(10) DEFAULT NULL,
pinglunneirong varchar(500) DEFAULT NULL,
pinglunren varchar(20) DEFAULT NULL,
pingfen varchar(4) DEFAULT NULL,
biao varchar(20) DEFAULT NULL,
addtime timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- Records of pinglun
-- Table structure for shoucangjilu
DROP TABLE IF EXISTS shoucangjilu;
CREATE TABLE shoucangjilu (
id int(11) NOT NULL AUTO_INCREMENT,
username varchar(50) DEFAULT NULL,
xwid varchar(50) DEFAULT NULL,
ziduan varchar(50) DEFAULT NULL,
biao varchar(50) DEFAULT NULL,
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
biaoj varchar(255) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;
-- Records of shoucangjilu
-- Table structure for xinwentongzhi
DROP TABLE IF EXISTS xinwentongzhi;
CREATE TABLE xinwentongzhi (
id int(11) NOT NULL AUTO_INCREMENT,
biaoti varchar(50) DEFAULT NULL,
leibie varchar(50) DEFAULT NULL,
neirong text,
shouyetupian varchar(50) DEFAULT NULL,
dianjilv varchar(50) DEFAULT NULL,
tianjiaren varchar(50) DEFAULT NULL,
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
zhaiyao text,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=gb2312;
-- Records of xinwentongzhi
INSERT INTO xinwentongzhi VALUES ('1', '变幻图1', 'img', '变幻图', 'upload/1.jpg', '3', 'hsg', '2022-03-15 16:51:32', null);
INSERT INTO xinwentongzhi VALUES ('2', '变幻图2', 'img', '变幻图', 'upload/2.jpg', '32', 'hsg', '2022-03-15 16:51:32', null);
INSERT INTO xinwentongzhi VALUES ('3', '变幻图3', 'img', '变幻图', 'upload/3.jpg', '33', 'hsg', '2022-03-15 16:51:32', null);
INSERT INTO xinwentongzhi VALUES ('4', '变幻图4', 'img', '变幻图', 'upload/4.jpg', '35', 'hsg', '2022-03-15 16:51:32', null);
INSERT INTO xinwentongzhi VALUES ('5', '变幻图5', 'img', '变幻图', 'upload/5.jpg', '13', 'hsg', '2022-03-15 16:51:32', null);
