基于SSM的家政服务预约网站设计与实现-计算机毕业设计源码+LW文档

qq_375279829

已于 2022-11-22 21:01:36 修改

阅读量183

点赞数

分类专栏：微信小程序计算机毕业设计程序源码文章标签：数据库 java 服务器

于 2022-11-22 21:01:29 首次发布

本文链接：https://blog.csdn.net/qq_375279829/article/details/127989913

版权

计算机毕业设计程序源码同时被 2 个专栏收录

311 篇文章 75 订阅

订阅专栏

微信小程序

146 篇文章 9 订阅

订阅专栏

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);

qq_375279829

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
基于SSM的家政服务预约网站设计与实现-计算机毕业设计源码+LW文档

br /> 忠：即忠诚，包括三重含义：企业忠于国家、忠于民族；信：即诚信，做企业要立足根本道德、信义，要诚实、讲信用。INSERT INTO `baojieyuan` VALUES ('2', '031', '001', '陈贵柏', '女', '解放路73号', '13544655202', '330327198406150488', 'upload/baojieyuan3.jpg', 'abc', '是', '0', '0', '2022-03-15 16:51:38');
复制链接

扫一扫

专栏目录