基于java的开发源码-宠物市场管理系统源码(jsp+mysql).zip

/* SQLyog Ultimate v11.33 (64 bit) MySQL - 5.5.27 : Database - db_pet_manage ********************************************************************* */ /*!40101 SET NAMES utf8 */; /*!40101 SET SQL_MODE=''*/; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; /*Table structure for table `t_config` */ CREATE TABLE `t_config` ( `id` int(11) NOT NULL AUTO_INCREMENT, `domain_name` varchar(100) DEFAULT NULL, `web_site` varchar(200) DEFAULT NULL, `headStr` text, `layuiStr` text, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*Data for the table `t_config` */ LOCK TABLES `t_config` WRITE; insert into `t_config`(`id`,`domain_name`,`web_site`,`headStr`,`layuiStr`) values (1,'宠物管理系统','http://www.###.com','<!-- 强制 高速模式 渲染网页 -->\n<meta NAME=”renderer” content=”webkit”>\n<!-- 强制 高速模式 渲染网页 -->\n\n<link href=\"/static/favicon.ico\" rel=\"shortcut icon\" />\n\n<!--添加 jq 支持加载-->\n<script src=\"/static/easy-ui/jquery.min.js\"></script>\n<!--添加 jq 支持加载-->','<!--添加 layui 支持加载-->\n<link rel=\"stylesheet\" href=\"/static/layui-v2.2.5/layui/css/layui.css\">\n<script src=\"/static/layui-v2.2.5/layui/layui.js\"></script>\n<!--添加 layui 支持加载-->'); UNLOCK TABLES; /*Table structure for table `t_my_pet` */ CREATE TABLE `t_my_pet` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100) DEFAULT NULL, `state` varchar(100) DEFAULT NULL, `healthy` int(11) DEFAULT NULL, `shopId` int(11) DEFAULT NULL, `createDateTime` datetime DEFAULT NULL, `selectDateTime` datetime DEFAULT NULL, `selectUserId` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8; /*Data for the table `t_my_pet` */ LOCK TABLES `t_my_pet` WRITE; insert into `t_my_pet`(`id`,`name`,`state`,`healthy`,`shopId`,`createDateTime`,`selectDateTime`,`selectUserId`) values (3,'小王','玩耍',55,2,'2018-10-08 17:32:00','2018-10-08 17:32:16',9),(6,'12','玩耍',122,1,'2018-10-08 16:41:15','2018-10-08 17:53:01',10),(7,'小王','玩耍',99,2,'2018-10-08 17:32:00','2018-10-08 17:53:03',10); UNLOCK TABLES; /*Table structure for table `t_pet` */ CREATE TABLE `t_pet` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100) DEFAULT NULL, `state` varchar(100) DEFAULT NULL, `healthy` int(11) DEFAULT NULL, `num` int(11) DEFAULT NULL, `shopId` int(11) DEFAULT NULL, `createDateTime` datetime DEFAULT NULL, `selectDateTime` datetime DEFAULT NULL, `selectUserId` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8; /*Data for the table `t_pet` */ LOCK TABLES `t_pet` WRITE; insert into `t_pet`(`id`,`name`,`state`,`healthy`,`num`,`shopId`,`createDateTime`,`selectDateTime`,`selectUserId`) values (2,'12','玩耍',122,2,1,'2018-10-08 16:41:15',NULL,NULL),(3,'小王','玩耍',99,9,2,'2018-10-08 17:32:00',NULL,NULL); UNLOCK TABLES; /*Table structure for table `t_shop` */ CREATE TABLE `t_shop` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100) DEFAULT NULL, `address` varchar(100) DEFAULT NULL, `orderNo` int(11) DEFAULT NULL, `createDateTime` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; /*Data for the table `t_shop` */ LOCK TABLES `t_shop` WRITE; insert into `t_shop`(`id`,`name`,`address`,`orderNo`,`createDateTime`) values (1,'小明的店','中国路',1,'2018-10-07 18:00:02'),(2,'杂货店','中兴路',2,'2018-10-08 09:18:51'); UNLOCK TABLES; /*Table structure for table `t_tree` */ CREATE TABLE `t_tree` ( `id` int(11) DEFAULT NULL, `text` varchar(46) DEFAULT NULL, `father` int(11) DEFAULT NULL, `url` varchar(500) DEFAULT NULL, `state` varchar(46) DEFAULT NULL, `iconCls` varchar(46) DEFAULT NULL, `permissions` varchar(100) DEFAULT NULL, `dd_id` varchar(46) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*Data for the table `t_tree` */ LOCK TABLES `t_tree` WRITE; insert into `t_tree`(`id`,`text`,`father`,`url`,`state`,`iconCls`,`permissions`,`dd_id`) values (6,'信息管理',-1,NULL,'close',NULL,NULL,NULL),(61010,'门店管理',6,'/houtai/shop/manage','opend','&#xe63c;',NULL,'shop'),(61013,'宠物管理',6,'/houtai/pet/manage','opend','&#xe612;',NULL,'pet'),(61015,'我的宠物',6,'/houtai/my/pet/manage','opend','&#xe612;',NULL,'my_pet'),(61014,'宠物市场',6,'/houtai/pet/shop','opend','&#xe612;',NULL,'pet_shop'),(61006,'用户管理',6,'/houtai/user/manage','opend','&#xe612;',NULL,'user'); UNLOCK TABLES; /*Table structure for table `t_user` */ CREATE TABLE `t_user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `num_` varchar(60) DEFAULT NULL, `trueName` varchar(60) DEFAULT NULL, `phone` varchar(100) DEFAULT NULL, `sex_` varchar(10) DEFAULT NULL, `menuIds` varchar(100) DEFAULT NULL, `createDateTime` datetime DEFAULT NULL, `password` varchar(100) DEFAULT NULL, `remark` varchar(100) DEFAULT NULL, `type` int(5) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `weiyi` (`num_`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8; /*Data for the table `t_user` */ LOCK TABLES `t_user` WRITE; insert into `t_user`(`id`,`num_`,`trueName`,`phone`,`sex_`,`menuIds`,`createDateTime`,`password`,`remark`,`type`) values (9,'admin','管理员','18337537555','男','6,61010,61013,61017,61006','2018-06-23 15:50:59','0680d00353f3555fe7c01f11ed89bf8b','2',1),(10,'001','123','123456123','女','6,61015,61014','2018-10-08 15:20:49','32758081c6d66cdecfcd736128dea25d',NULL,2); UNLOCK TABLES; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;