大型电商系统:SpringBoot+SpringJPA+Solr+MySQL+Redis+layui+JWT+shiro+Thymeleaf+ajax
发布日期:2021-07-01 04:04:46
浏览次数:2
分类:技术文章
本文共 41069 字,大约阅读时间需要 136 分钟。
0、运行截图:
后台截图就不截了… 源码:1、功能介绍:
系统主要包括首页、商品、用户、购物车、订单、订单支付(微信 支付宝)、积分商品兑换、个人中心等功能模块;后台管理系统涵盖了用户管理、商品管理、品牌管理等功能模块,首页有轮播图。商品推荐。热销商品。
2、项目技术:
SpringBoot+SpringJPA+Solr+MySQL+Redis+layui+JWT+shiro+Thymeleaf+ajax
3、运行必读:
如果是在windows部署的话首先要安装必要的环境,除了一般Springbootweb使用到的环境之外,我们还需要配置redis ,solr等。
配置qq邮箱的smtp授权服务用以邮箱找回密码验证。 还需要配置支付宝环境,这个自行百度一下,过程比较多,有需要的也可以联系我qq 2439644676。4、说明:
此电商系统只可用于学习,不可用于商业途径,出现其他的后果概不负责。
5、部分代码解析:
Pom文件导入一些必要的依赖:
4.0.0 org.springframework.boot spring-boot-starter-parent 1.5.20.RELEASE com.java1234bishe shop 0.0.1-SNAPSHOT war shop Demo project for Spring Boot 1.8 org.springframework.boot spring-boot-starter-web org.springframework.boot spring-boot-starter-tomcat provided org.springframework.boot spring-boot-starter-test test org.springframework.boot spring-boot-starter-data-solr org.springframework.boot spring-boot-starter-amqp io.springfox springfox-swagger2 2.4.0 io.springfox springfox-swagger-ui 2.4.0 net.sourceforge.nekohtml nekohtml 1.9.22 com.google.zxing core 3.3.2 com.google.code.gson gson jdom jdom 1.1 net.oschina.zcx7878 fastdfs-client-java 1.27.0.0 com.alipay sdk-java 20171123203126 commons-lang commons-lang 2.6 org.springframework.boot spring-boot-starter-data-jpa org.springframework.boot spring-boot-starter-thymeleaf org.springframework.boot spring-boot-starter-web org.springframework spring-context-support mysql mysql-connector-java runtime org.springframework.boot spring-boot-starter-tomcat provided com.alibaba fastjson 1.2.38 org.springframework.boot spring-boot-starter-test test org.springframework.boot spring-boot-starter-jdbc org.springframework.boot spring-boot-starter-data-redis com.alibaba druid 1.1.10 org.apache.shiro shiro-core 1.4.0 org.apache.shiro shiro-spring 1.4.0 commons-io commons-io 2.3 com.auth0 java-jwt 3.2.0 io.jsonwebtoken jjwt 0.7.0 org.apache.httpcomponents httpclient javax.mail 1.4.7 com.auth0 java-jwt 3.2.0 org.projectlombok lombok provided org.springframework.boot spring-boot-devtools runtime org.springframework.boot spring-boot-maven-plugin
登陆过滤器:
import java.io.IOException;import java.util.List;import javax.servlet.Filter;import javax.servlet.FilterChain;import javax.servlet.FilterConfig;import javax.servlet.ServletException;import javax.servlet.ServletRequest;import javax.servlet.ServletResponse;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import com.javabishe1234.entity.User;import com.javabishe1234.repository.UserRepository;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.boot.context.properties.EnableConfigurationProperties;import org.springframework.boot.web.servlet.ServletComponentScan;import org.springframework.data.redis.core.StringRedisTemplate;import org.springframework.stereotype.Component;import com.javabishe1234.entity.UserJwt;import com.javabishe1234.properties.FilterProperties;import com.javabishe1234.properties.JwtProperties;import com.javabishe1234.util.CookieUtils;/** * 登录过滤器 * @author 东东 * @site javabishe1234.com * @company Java毕设1234 */@Component@ServletComponentScan@EnableConfigurationProperties({ JwtProperties.class, FilterProperties.class })public class LoginFilter implements Filter { @Autowired private JwtProperties prop; @Autowired private FilterProperties filterProperties; @Override public void init(FilterConfig filterConfig) throws ServletException { } @Autowired private UserRepository userRepository; @Autowired private StringRedisTemplate stringRedisTemplate; public void doFilter(ServletRequest request, ServletResponse response, FilterChain chain) throws IOException, ServletException { HttpServletRequest req = (HttpServletRequest) request; HttpServletResponse resp = (HttpServletResponse) response; // if(req.getRequestURI().contains("favicon.ico")) {chain.doFilter(request, // response);} String token = CookieUtils.getCookieValue(req, prop.getCookieName()); User user = null; if(token!=null){ String userId =stringRedisTemplate.opsForValue().get(token); user = userRepository.getOne(Integer.parseInt(userId)); } if (req.getRequestURL().toString().contains("/user/login.aspx")) { chain.doFilter(request, response); } // 解析token失败 拦截 String requestUri = req.getRequestURI(); // 4.判断白名单 if (!isAllowPath(requestUri)) { chain.doFilter(request, response); } request.getRequestDispatcher(req.getContextPath() + "/adminLogin.html"); chain.doFilter(request, response); } private boolean isAllowPath(String requestUri) { // 1.定义一个标记 boolean flag = false; System.out.println(this.filterProperties); Listlist = this.filterProperties.getAllowPaths(); // 2.遍历允许访问的路径 for (String path : list) { if (requestUri.startsWith(path)) { flag = true; break; } } return flag; } @Override public void destroy() { }}
登陆首页控制层:
import javax.annotation.Resource;import javax.servlet.http.HttpSession;import org.apache.shiro.SecurityUtils;import org.springframework.stereotype.Controller;import org.springframework.web.bind.annotation.GetMapping;import org.springframework.web.bind.annotation.RequestMapping;import com.javabishe1234.service.OrderDetailService;import com.javabishe1234.service.OrderService;import com.javabishe1234.service.ProductService;@Controllerpublic class IndexController { @Resource private OrderService orderService; @Resource private OrderDetailService orderDetailService; @Resource private ProductService productService; // 首页请求 @GetMapping("/") public String root() { return "index"; } // 去管理员登录页面(layui) @RequestMapping("admin/adminLogin") public String adminLogin() { return "admin/adminLogin"; } // 跳转到管理员主页页面 @RequestMapping("admin/toAdminCenterPage") public String toAdminCenterPage() { return "admin/index"; } // 安全退出 @GetMapping("admin/logout") public String logout(HttpSession session) { SecurityUtils.getSubject().logout(); return "admin/adminLogin"; }}
初始化加载数据:
package com.javabishe1234.init;import java.util.HashMap;import java.util.List;import java.util.Map;import javax.annotation.Resource;import javax.servlet.ServletContext;import javax.servlet.ServletContextEvent;import javax.servlet.ServletContextListener;import com.javabishe1234.entity.product.Brand;import com.javabishe1234.entity.product.Product;import com.javabishe1234.entity.product.ProductType;import org.springframework.beans.BeansException;import org.springframework.context.ApplicationContext;import org.springframework.context.ApplicationContextAware;import org.springframework.data.domain.Sort;import org.springframework.stereotype.Component;import com.javabishe1234.service.BrandService;import com.javabishe1234.service.ProductService;import com.javabishe1234.service.ProductTypeService;@Component("initSystem")public class InitSystem implements ServletContextListener,ApplicationContextAware{ @SuppressWarnings("unused") private static ApplicationContext applicationContext; public static MapbrandMap=new HashMap (); @Resource private BrandService brandService; @Resource private ProductTypeService productTypeService; @Resource private ProductService productService; /** * 加载数据到application缓存中 * @param application */ public void loadData(ServletContext application){ List productTypeList = productTypeService.findProductTypeList(); application.setAttribute("productTypeList", productTypeList); // // 销量排行 Product s_product = new Product(); s_product.setIs_del(0); List productListBySale = productService.list(s_product , 1, 3, Sort.Direction.DESC, "sale"); application.setAttribute("productListBySale", productListBySale); // 所有类别 // 搜索页店铺热销 Product searchProduct = new Product(); searchProduct.setIs_del(0); List searchProductList = productService.list(searchProduct , 1, 4, Sort.Direction.DESC, "sale"); application.setAttribute("searchProductList", searchProductList); // 所有类别 Product product = new Product(); product.setIs_del(0); product.setProductType(productTypeService.getById(3)); List productListByTypeId3 = productService.list(product , 1, 6, Sort.Direction.DESC, "sale"); application.setAttribute("productListByTypeId3", productListByTypeId3); // 商城超市 Product product2 = new Product(); product2.setIs_del(0); product2.setProductType(productTypeService.getById(2)); List productListByTypeId2 = productService.list(product2 , 1, 6, Sort.Direction.DESC, "sale"); application.setAttribute("productListByTypeId2", productListByTypeId2); // 服饰 Product sproduct = new Product(); sproduct.setIs_del(0); sproduct.setProductType(productTypeService.getById(1)); List productListByTypeId1 = productService.list(sproduct , 1, 6, Sort.Direction.DESC, "sale"); application.setAttribute("productListByTypeId1", productListByTypeId1); //3c数码 Product ssproduct = new Product(); ssproduct.setIs_del(0); ssproduct.setProductType(productTypeService.getById(4)); List productListByTypeId4 = productService.list(ssproduct , 1, 6, Sort.Direction.DESC, "sale"); application.setAttribute("productListByTypeId4", productListByTypeId4); //家用电器 Product sxproduct = new Product(); sxproduct.setIs_del(0); sxproduct.setProductType(productTypeService.getById(5)); List productListByTypeId5 = productService.list(sxproduct , 1, 6, Sort.Direction.DESC, "sale"); application.setAttribute("productListByTypeId5", productListByTypeId5); //家用电器 Brand brand = new Brand(); brand.setIs_display(1); List brandList = brandService.list(brand, 1, 18, Sort.Direction.DESC, "sort"); application.setAttribute("brandList", brandList); // 品牌盛宴 // 3c数码 品牌 List brandNumericalList = brandService.getBrandListByTypeId(1); application.setAttribute("brandNumericalList", brandNumericalList); // 服饰品牌 List brandCostumeList = brandService.getBrandListByTypeId(2); application.setAttribute("brandCostumeList", brandCostumeList); // 商城超市品牌 List brandShopList = brandService.getBrandListByTypeId(3); application.setAttribute("brandShopList", brandShopList); // 家用电器品牌 List brandElectricalList = brandService.getBrandListByTypeId(4); application.setAttribute("brandElectricalList", brandElectricalList); //今日特惠 List productlList = productService.list(s_product, 1, 12, Sort.Direction.ASC, "productPrice"); application.setAttribute("productlList", productlList); } @Override public void contextInitialized(ServletContextEvent sce) { loadData(sce.getServletContext()); } @Override public void contextDestroyed(ServletContextEvent sce) { } @Override public void setApplicationContext(ApplicationContext applicationContext) throws BeansException { InitSystem.applicationContext=applicationContext; }}
6、数据库脚本:
/*SQLyog Ultimate v11.33 (64 bit)MySQL - 5.1.49-community : Database - shop**********************************************************************//*!40101 SET NAMES utf8 */;/*!40101 SET SQL_MODE=''*/;/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_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 */;CREATE DATABASE /*!32312 IF NOT EXISTS*/`shop` /*!40100 DEFAULT CHARACTER SET latin1 */;USE `shop`;/*Table structure for table `t_address` */DROP TABLE IF EXISTS `t_address`;CREATE TABLE `t_address` ( `id` int(11) NOT NULL AUTO_INCREMENT, `address` varchar(1000) DEFAULT NULL, `is_default` int(11) DEFAULT NULL, `phone` varchar(200) DEFAULT NULL, `user_name` varchar(200) DEFAULT NULL, `user_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `FKib1tav6peo3hd297p0bw4qng9` (`user_id`), CONSTRAINT `FKib1tav6peo3hd297p0bw4qng9` FOREIGN KEY (`user_id`) REFERENCES `t_user` (`id`)) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;/*Data for the table `t_address` */insert into `t_address`(`id`,`address`,`is_default`,`phone`,`user_name`,`user_id`) values (1,'1',2,'3','4',1),(13,'1',0,'1','1',1),(14,'4',0,'4','4',1);/*Table structure for table `t_admin` */DROP TABLE IF EXISTS `t_admin`;CREATE TABLE `t_admin` ( `id` int(11) NOT NULL AUTO_INCREMENT, `admin_name` varchar(50) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `ip` varchar(255) DEFAULT NULL, `login_date` datetime DEFAULT NULL, `password` varchar(50) DEFAULT NULL, `phone` varchar(255) DEFAULT NULL, `remarks` varchar(1000) DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;/*Data for the table `t_admin` */insert into `t_admin`(`id`,`admin_name`,`email`,`ip`,`login_date`,`password`,`phone`,`remarks`) values (1,'1',NULL,NULL,NULL,'1',NULL,NULL),(2,'3',NULL,NULL,NULL,'3','3','3');/*Table structure for table `t_admin_role` */DROP TABLE IF EXISTS `t_admin_role`;CREATE TABLE `t_admin_role` ( `id` int(11) NOT NULL AUTO_INCREMENT, `admin_id` int(11) DEFAULT NULL, `role_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `FKo3402higugj7os2awjwmm3qwr` (`admin_id`), KEY `FKaoi3te4qg9ghbkyp74no195n8` (`role_id`), CONSTRAINT `FKaoi3te4qg9ghbkyp74no195n8` FOREIGN KEY (`role_id`) REFERENCES `t_role` (`id`), CONSTRAINT `FKo3402higugj7os2awjwmm3qwr` FOREIGN KEY (`admin_id`) REFERENCES `t_admin` (`id`)) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;/*Data for the table `t_admin_role` */insert into `t_admin_role`(`id`,`admin_id`,`role_id`) values (1,1,1),(2,1,2),(4,2,2);/*Table structure for table `t_brand` */DROP TABLE IF EXISTS `t_brand`;CREATE TABLE `t_brand` ( `id` int(11) NOT NULL AUTO_INCREMENT, `brand_desc` varchar(1000) DEFAULT NULL, `brand_name` varchar(100) DEFAULT NULL, `is_display` int(11) DEFAULT NULL, `sort` int(11) DEFAULT NULL, `type_id` int(11) DEFAULT NULL, `image` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`), KEY `FKrpnhht4xuhtvwr4rl2l6dt0o` (`type_id`), CONSTRAINT `FKrpnhht4xuhtvwr4rl2l6dt0o` FOREIGN KEY (`type_id`) REFERENCES `t_product_type` (`id`)) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8;/*Data for the table `t_brand` */insert into `t_brand`(`id`,`brand_desc`,`brand_name`,`is_display`,`sort`,`type_id`,`image`) values (1,'1','海尔',1,1,4,'https://click.mz.simba.taobao.com/brand?e=3eisO5iaLm1%2Bo4tjs1emnDGlZfurdDYi233bWMi%2FB4NaDWFlXbTCJ51rMtIRnTbFLsdtWD%2FK6jxqtsZTksZxmREkdsuPsCamr8WVqNcfHdhVdOCq6IIdOCZMxKbtd687JNyGU%2BdxQarNjtVEEsn1NljiFK2TNRGnqUROINEJiaTa%2FcggAULBJzTTzSGB35D8EgUOoHmJZNA'),(2,NULL,'美的',1,2,4,'/static/qiantai/uploads/2.jpg'),(3,NULL,'美的',1,3,4,'/static/qiantai/uploads/3.jpg'),(21,NULL,'牛奶冲调',1,21,3,NULL),(22,NULL,'家居日用',1,22,3,NULL),(23,NULL,'保健滋补',1,23,3,NULL),(25,'','花花公子1',NULL,25,NULL,NULL);/*Table structure for table `t_code` */DROP TABLE IF EXISTS `t_code`;CREATE TABLE `t_code` ( `id` int(11) NOT NULL AUTO_INCREMENT, `count` int(11) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `time` datetime DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;/*Data for the table `t_code` *//*Table structure for table `t_comment` */DROP TABLE IF EXISTS `t_comment`;CREATE TABLE `t_comment` ( `id` int(11) NOT NULL AUTO_INCREMENT, `comment_date` datetime DEFAULT NULL, `content` varchar(1000) DEFAULT NULL, `state` int(11) DEFAULT NULL, `product_id` int(11) DEFAULT NULL, `user_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `FK5xx32wa9nnh0d62eok1kn6cfe` (`product_id`), KEY `FKtamaoacctq4qpko6bvtv0ke1p` (`user_id`), CONSTRAINT `FK5xx32wa9nnh0d62eok1kn6cfe` FOREIGN KEY (`product_id`) REFERENCES `t_product` (`id`), CONSTRAINT `FKtamaoacctq4qpko6bvtv0ke1p` FOREIGN KEY (`user_id`) REFERENCES `t_user` (`id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;/*Data for the table `t_comment` *//*Table structure for table `t_log` */DROP TABLE IF EXISTS `t_log`;CREATE TABLE `t_log` ( `id` int(11) NOT NULL AUTO_INCREMENT, `content` varchar(1000) DEFAULT NULL, `time` datetime DEFAULT NULL, `type` varchar(100) DEFAULT NULL, `admin_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `FK3s9vvya248pev81avq0g75xaf` (`admin_id`), CONSTRAINT `FK3s9vvya248pev81avq0g75xaf` FOREIGN KEY (`admin_id`) REFERENCES `t_admin` (`id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;/*Data for the table `t_log` *//*Table structure for table `t_menu` */DROP TABLE IF EXISTS `t_menu`;CREATE TABLE `t_menu` ( `id` int(11) NOT NULL AUTO_INCREMENT, `icon` varchar(100) DEFAULT NULL, `name` varchar(50) DEFAULT NULL, `p_id` int(11) DEFAULT NULL, `state` int(11) DEFAULT NULL, `url` varchar(200) DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=6051 DEFAULT CHARSET=utf8;/*Data for the table `t_menu` */insert into `t_menu`(`id`,`icon`,`name`,`p_id`,`state`,`url`) values (1,'menu-plugin','系统菜单',-1,1,NULL),(10,'menu-1','商品管理',1,1,NULL),(20,'menu-2','品牌管理',1,1,NULL),(30,'menu-3','订单管理',1,1,NULL),(40,'menu-4','统计报表',1,1,NULL),(50,'menu-5','基础资料',1,1,NULL),(60,'menu-6','系统管理',1,1,NULL),(1010,'menu-11','添加商品',10,0,'/product/addProduct.html'),(1020,'menu-12','商品列表',10,0,'/product/productManage.html'),(2010,'menu-21','品牌列表',20,0,'/brand/brandManage.html'),(3010,'menu-31','订单列表',30,0,'/order/orderManage.html'),(3020,'menu-32','商品报溢',30,0,'/stock/overflow.html'),(3030,'menu-33','库存报警',30,0,'/stock/alarm.html'),(3040,'menu-34','报损报溢查询',30,0,'/stock/damageOverflowSearch.html'),(3050,'menu-35','当前库存查询',30,0,'/common/stockSearch.html'),(4010,'menu-41','供应商统计',40,0,'/count/supplier.html'),(4020,'menu-42','客户统计',40,0,'/count/customer.html'),(4030,'menu-43','商品采购统计',40,0,'/count/purchase.html'),(4040,'menu-44','商品销售统计',40,0,'/count/sale.html'),(4050,'menu-45','按日统计分析',40,0,'/count/saleDay.html'),(4060,'menu-46','按月统计分析',40,0,'/count/saleMonth.html'),(5010,'menu-51','供应商管理',50,0,'/basicData/supplier.html'),(5020,'menu-52','客户管理',50,0,'/basicData/customer.html'),(5030,'menu-53','商品管理',50,0,'/basicData/goods.html'),(5040,'menu-54','期初库存',50,0,'/basicData/stock.html'),(6010,'menu-61','角色管理',60,0,'/power/role.html'),(6020,'menu-62','管理员管理',60,0,'/power/user.html'),(6030,'menu-65','系统日志',60,0,'/power/log.html'),(6040,'menu-63','修改密码',60,0,NULL),(6050,'menu-64','安全退出',60,0,NULL);/*Table structure for table `t_message` */DROP TABLE IF EXISTS `t_message`;CREATE TABLE `t_message` ( `id` int(11) NOT NULL AUTO_INCREMENT, `content` varchar(100) DEFAULT NULL, `is_see` bit(1) NOT NULL, `publish_date` datetime DEFAULT NULL, `user_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `FK8bywht7ktfktx8qeysmlk5kv2` (`user_id`), CONSTRAINT `FK8bywht7ktfktx8qeysmlk5kv2` FOREIGN KEY (`user_id`) REFERENCES `t_user` (`id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;/*Data for the table `t_message` *//*Table structure for table `t_my_point_product` */DROP TABLE IF EXISTS `t_my_point_product`;CREATE TABLE `t_my_point_product` ( `id` int(11) NOT NULL AUTO_INCREMENT, `pid` int(11) DEFAULT NULL, `uid` int(11) DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;/*Data for the table `t_my_point_product` *//*Table structure for table `t_order` */DROP TABLE IF EXISTS `t_order`;CREATE TABLE `t_order` ( `actual_pay` double NOT NULL, `order_id` bigint(20) NOT NULL, `create_time` datetime DEFAULT NULL, `order_no` varchar(255) NOT NULL, `point_pay` double DEFAULT NULL, `receiver` varchar(255) DEFAULT NULL, `receiver_address` varchar(255) DEFAULT NULL, `receiver_mobile` varchar(255) DEFAULT NULL, `status` int(11) DEFAULT NULL, `total_pay` double NOT NULL, `user_id` bigint(20) DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8;/*Data for the table `t_order` */insert into `t_order`(`actual_pay`,`order_id`,`create_time`,`order_no`,`point_pay`,`receiver`,`receiver_address`,`receiver_mobile`,`status`,`total_pay`,`user_id`) values (0,1203736884560326656,'2019-12-09 02:03:32','1203736884560326656',NULL,'1','1','1',0,2,1),(0,1203737105210077184,'2019-12-09 02:04:24','1203737105210077184',NULL,'4','4','4',0,2670.9,1),(0,1203902422913712128,'2019-12-09 13:01:19','1203902422913712128',NULL,'1','1','1',0,2000,1);/*Table structure for table `t_order_detail` */DROP TABLE IF EXISTS `t_order_detail`;CREATE TABLE `t_order_detail` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `image` varchar(255) DEFAULT NULL, `num` int(11) DEFAULT NULL, `order_id` bigint(20) DEFAULT NULL, `own_spec` varchar(255) DEFAULT NULL, `p_id` int(11) DEFAULT NULL, `price` double DEFAULT NULL, `title` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8;/*Data for the table `t_order_detail` */insert into `t_order_detail`(`id`,`image`,`num`,`order_id`,`own_spec`,`p_id`,`price`,`title`) values (23,'https://g-search3.alicdn.com/img/bao/uploaded/i4/i2/2616970884/O1CN01v2Xz2x1IOudQkhK7Q_!!0-item_pic.jpg_250x250.jpg_.webp',2,1203736884560326656,NULL,28,1,'【64GB限时优惠100元】华为HONOR荣耀8X全面大屏幕指纹解锁智能游戏青春学生新手机老年人电话机官方网旗舰店'),(24,'https://img.alicdn.com/imgextra/i1/1714128138/O1CN01SdO4xd29zFhPNK3gM_!!1714128138.jpg_430x430q90.jpg',1,1203737105210077184,NULL,14,649,'【爆款直降】Xiaomi/小米 红米6a智能老人学生青春拍照手机小米8周年官方旗舰店正'),(25,'https://g-search3.alicdn.com/img/bao/uploaded/i4/i2/2616970884/O1CN01v2Xz2x1IOudQkhK7Q_!!0-item_pic.jpg_250x250.jpg_.webp',1,1203737105210077184,NULL,23,22.9,'三只松鼠碧根果120g零食小吃每日坚果山核桃长寿果 '),(26,'/static/qiantai/uploads/17.jpg',1,1203737105210077184,NULL,15,1999,'【64GB限时优惠100元】华为HONOR荣耀8X全面大屏幕指纹解锁智能游戏青春学生新手机老年人电话机官方网旗舰店'),(27,'/static/qiantai/uploads/17.jpg',1,1203902422913712128,NULL,15,1999,'【64GB限时优惠100元】华为HONOR荣耀8X全面大屏幕指纹解锁智能游戏青春学生新手机老年人电话机官方网旗舰店'),(28,'https://g-search3.alicdn.com/img/bao/uploaded/i4/i2/2616970884/O1CN01v2Xz2x1IOudQkhK7Q_!!0-item_pic.jpg_250x250.jpg_.webp',1,1203902422913712128,NULL,28,1,'【64GB限时优惠100元】华为HONOR荣耀8X全面大屏幕指纹解锁智能游戏青春学生新手机老年人电话机官方网旗舰店');/*Table structure for table `t_order_status` */DROP TABLE IF EXISTS `t_order_status`;CREATE TABLE `t_order_status` ( `order_id` bigint(20) NOT NULL, `close_time` datetime DEFAULT NULL, `comment_time` datetime DEFAULT NULL, `consign_time` datetime DEFAULT NULL, `create_time` datetime DEFAULT NULL, `end_time` datetime DEFAULT NULL, `payment_time` datetime DEFAULT NULL, `status` int(11) DEFAULT NULL, PRIMARY KEY (`order_id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;/*Data for the table `t_order_status` *//*Table structure for table `t_point` */DROP TABLE IF EXISTS `t_point`;CREATE TABLE `t_point` ( `id` int(11) NOT NULL AUTO_INCREMENT, `point` int(11) DEFAULT NULL, `point_name` varchar(200) DEFAULT NULL, `state` int(11) DEFAULT NULL, `time` datetime DEFAULT NULL, `user_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `FK8ncdwy2ow0vo5tgl73x4skq7s` (`user_id`), CONSTRAINT `FK8ncdwy2ow0vo5tgl73x4skq7s` FOREIGN KEY (`user_id`) REFERENCES `t_user` (`id`)) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;/*Data for the table `t_point` */insert into `t_point`(`id`,`point`,`point_name`,`state`,`time`,`user_id`) values (1,1,'每日签到',1,'2019-04-11 22:15:09',1),(2,1,'每日签到',1,'2019-12-02 02:27:36',1);/*Table structure for table `t_point_product` */DROP TABLE IF EXISTS `t_point_product`;CREATE TABLE `t_point_product` ( `id` int(11) NOT NULL AUTO_INCREMENT, `image` varchar(1000) DEFAULT NULL, `point` int(11) DEFAULT NULL, `title` varchar(500) DEFAULT NULL, `num` int(11) DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;/*Data for the table `t_point_product` */insert into `t_point_product`(`id`,`image`,`point`,`title`,`num`) values (1,'https://img.alicdn.com/imgextra/https://img.alicdn.com/imgextra/i2/1860270913/O1CN01bwrUKu1IcC5LR8qEm_!!1860270913.jpg_430x430q90.jpg',1,'2019新款男士外套春秋款夹克男潮薄款韩版潮流帅气修身休闲衣服wt ',100),(2,'https://img.alicdn.com/bao/uploaded/i2/196993935/O1CN01k2OjF01ewH1Hilm15_!!0-item_pic.jpg',2,'2019新款男士外套春秋款夹克男潮薄款韩版潮流帅气修身休闲衣服wt ',100),(3,'https://img.alicdn.com/imgextra/https://img.alicdn.com/imgextra/i2/1860270913/O1CN01bwrUKu1IcC5LR8qEm_!!1860270913.jpg_430x430q90.jpg',1,'2019新款男士外套春秋款夹克男潮薄款韩版潮流帅气修身休闲衣服wt ',100),(4,'https://img.alicdn.com/imgextra/https://img.alicdn.com/imgextra/i2/1860270913/O1CN01bwrUKu1IcC5LR8qEm_!!1860270913.jpg_430x430q90.jpg',1,'2019新款男士外套春秋款夹克男潮薄款韩版潮流帅气修身休闲衣服wt ',5),(5,'https://img.alicdn.com/imgextra/https://img.alicdn.com/imgextra/i2/1860270913/O1CN01bwrUKu1IcC5LR8qEm_!!1860270913.jpg_430x430q90.jpg',1,'2019新款男士外套春秋款夹克男潮薄款韩版潮流帅气修身休闲衣服wt ',5),(6,'https://img.alicdn.com/imgextra/https://img.alicdn.com/imgextra/i2/1860270913/O1CN01bwrUKu1IcC5LR8qEm_!!1860270913.jpg_430x430q90.jpg',1,'2019新款男士外套春秋款夹克男潮薄款韩版潮流帅气修身休闲衣服wt ',5),(7,'https://img.alicdn.com/imgextra/https://img.alicdn.com/imgextra/i2/1860270913/O1CN01bwrUKu1IcC5LR8qEm_!!1860270913.jpg_430x430q90.jpg',1,'2019新款男士外套春秋款夹克男潮薄款韩版潮流帅气修身休闲衣服wt ',5),(8,'https://img.alicdn.com/imgextra/https://img.alicdn.com/imgextra/i2/1860270913/O1CN01bwrUKu1IcC5LR8qEm_!!1860270913.jpg_430x430q90.jpg',1,'2019新款男士外套春秋款夹克男潮薄款韩版潮流帅气修身休闲衣服wt ',5);/*Table structure for table `t_product` */DROP TABLE IF EXISTS `t_product`;CREATE TABLE `t_product` ( `id` int(11) NOT NULL AUTO_INCREMENT, `is_del` int(11) DEFAULT NULL, `is_show` int(11) DEFAULT NULL, `product_desc` varchar(2000) DEFAULT NULL, `product_image` varchar(1000) DEFAULT NULL, `product_price` float DEFAULT NULL, `product_title` varchar(500) DEFAULT NULL, `sale` int(11) DEFAULT NULL, `brand_id` int(11) DEFAULT NULL, `type_id` int(11) DEFAULT NULL, `tj` int(11) DEFAULT NULL, `total_count` int(11) DEFAULT NULL, `current_count` int(11) DEFAULT NULL, `create_date` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `FKmf17uifjs7g0rx37mmy18rt0q` (`brand_id`), KEY `FK4ked148rrl9mhq0t1fmvtw05p` (`type_id`), CONSTRAINT `FK4ked148rrl9mhq0t1fmvtw05p` FOREIGN KEY (`type_id`) REFERENCES `t_product_type` (`id`), CONSTRAINT `FKmf17uifjs7g0rx37mmy18rt0q` FOREIGN KEY (`brand_id`) REFERENCES `t_brand` (`id`)) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=utf8;/*Data for the table `t_product` */insert into `t_product`(`id`,`is_del`,`is_show`,`product_desc`,`product_image`,`product_price`,`product_title`,`sale`,`brand_id`,`type_id`,`tj`,`total_count`,`current_count`,`create_date`) values (1,0,0,'1','https://img.alicdn.com/bao/uploaded/i2/1610222843/O1CN01gh0fdE1Ws8WZS9gsb_!!0-item_pic.jpg',299,'2019春季新款休闲西装外套格子小西服韩版新款潮流修身帅气单西xz ',1,25,2,1,10,1,'2019-12-08 19:13:45'),(2,0,0,'2','https://img.alicdn.com/bao/uploaded/i2/196993935/O1CN01k2OjF01ewH1Hilm15_!!0-item_pic.jpg',12,'2019新款男士外套春秋款夹克男潮薄款韩版潮流帅气修身休闲衣服wt ',2,2,2,1,10,10,'2019-12-08 19:13:45'),(3,1,1,NULL,'https://item.taobao.com/item.htm?spm=a219r.lm895.14.1.1e40515fZJmUTc&id=574883517110&ns=1&abbucket=17',453,'英爵伦 2019春秋新款 外套男 男士春季 男装流行韩版夹克潮流衣服',3,2,2,1,10,1,'2019-12-08 19:13:45'),(4,0,0,NULL,'https://g-search1.alicdn.com/img/bao/uploaded/i4/i1/372751031/O1CN011JUEntuGLjimzjD_!!372751031.jpg_250x250.jpg_.webp',453,'春季新款日系套头圆领卫衣男士休闲百搭拼接男生青年纯色上衣外套',4,2,2,1,10,1,'2019-12-08 19:13:45'),(5,0,0,NULL,'https://img.alicdn.com/imgextra/https://img.alicdn.com/imgextra/i2/1860270913/O1CN01bwrUKu1IcC5LR8qEm_!!1860270913.jpg_430x430q90.jpg',458,'英爵伦 2019春秋新款 外套男 男士春季 男装流行韩版夹克潮流衣服',5,2,2,1,10,1,'2019-12-08 19:13:45'),(6,0,0,NULL,'https://g-search3.alicdn.com/img/bao/uploaded/i4/i4/109270110/O1CN011CgQ16rA4a7I19Z_!!109270110.jpg_250x250.jpg_.webp',453,'Bytehare玩藥局×镖局 W16水洗磨白落肩工装情侣牛仔夹克男士外套',6,2,2,1,10,1,'2019-12-08 19:13:45'),(7,0,0,NULL,'https://g-search1.alicdn.com/img/bao/uploaded/i4/i1/1122110005/O1CN01I4sVb81BuKUKwE3Ob_!!1122110005.jpg_250x250.jpg_.webp',45,'SELECTED思莱德春装新品男长袖短款夹克外套S|418221504 ',7,2,4,1,10,0,'2019-12-08 19:13:45'),(8,0,1,NULL,'https://g-search2.alicdn.com/img/bao/uploaded/i4/i4/3003074244/TB2DusoazfguuRjSszcXXbb7FXa_!!3003074244.jpg_250x250.jpg_.webp',67,'2018春秋装日系立领休闲牛仔夹克男青年修身外套水洗磨白潮流上衣 ',4,2,4,1,10,1,'2019-12-08 19:13:45'),(9,0,1,NULL,'https://img.alicdn.com/imgextra/https://img.alicdn.com/imgextra/i2/1860270913/O1CN01bwrUKu1IcC5LR8qEm_!!1860270913.jpg_430x430q90.jpg',199,'英爵伦 2019春秋新款 外套男 男士春季 男装流行韩版夹克潮流衣服',10,2,4,1,10,1,'2019-12-08 19:13:45'),(10,0,1,NULL,'https://g-search2.alicdn.com/img/bao/uploaded/i4/i1/1714128138/O1CN01NSUpcV29zFhNnz02g_!!0-item_pic.jpg_250x250.jpg_.webp',1399,'Xiaomi/小米 Redmi 红米Note7 大屏幕智能4800万现货老人机新手机9官方旗舰店正品5学生note7pro',12,1,1,1,10,0,'2019-12-08 19:13:45'),(11,0,1,NULL,'https://g-search3.alicdn.com/img/bao/uploaded/i4/i2/2616970884/O1CN01v2Xz2x1IOudQkhK7Q_!!0-item_pic.jpg_250x250.jpg_.webp',5299,'【128G到手价低至5388元】Apple/苹果 iPhone XR 移动联通电信4G手机双卡双待 苹果iPhoneXR 苹果XR 苹果xr',21,1,1,1,10,0,'2019-12-08 19:13:45'),(12,1,1,NULL,'https://img.alicdn.com/imgextra/i3/2838892713/O1CN01uxV4eQ1Vub2FbOE8M_!!2838892713.jpg_430x430q90.jpg',1399,'【64G直降100元 128G买赠华为耳机】Huawei/华为 畅享9 Plus 全面屏超清大屏四摄学生老人机智能手机畅享9p',213,1,1,1,10,0,'2019-12-08 19:13:45'),(13,0,1,NULL,'https://img.alicdn.com/imgextra/i3/883737303/O1CN01T6saG623ooz2RrsIP_!!883737303.jpg_430x430q90.jpg',2988,'【3期免息顺丰速发】vivo iQOO生而强悍高通骁龙855处理器水滴全面屏智能游戏手机官网正品 vivoiQOO iqoo',123,1,1,1,10,0,'2019-12-08 19:13:45'),(14,0,1,NULL,'https://img.alicdn.com/imgextra/i1/1714128138/O1CN01SdO4xd29zFhPNK3gM_!!1714128138.jpg_430x430q90.jpg',649,'【爆款直降】Xiaomi/小米 红米6a智能老人学生青春拍照手机小米8周年官方旗舰店正',153,1,1,1,110,0,'2019-12-08 19:13:45'),(15,0,1,NULL,'/static/qiantai/uploads/17.jpg',1999,'【64GB限时优惠100元】华为HONOR荣耀8X全面大屏幕指纹解锁智能游戏青春学生新手机老年人电话机官方网旗舰店',453,1,1,1,10,0,'2019-12-08 19:13:45'),(16,0,1,NULL,'https://g-search1.alicdn.com/img/bao/uploaded/i4/imgextra/i2/29720206/O1CN015oAwOn1DOO5WT1niT_!!0-saturn_solar.jpg_250x250.jpg_.webp',47.9,'亿滋奥利奥十全食美礼盒767g超值10小盒多种口味 网红零食大礼包 ',1,21,3,1,10,0,'2019-12-08 19:13:45'),(17,0,1,NULL,'https://g-search3.alicdn.com/img/bao/uploaded/i4/i2/TB11oJlNXXXXXaEaXXXXXXXXXXX_!!0-item_pic.jpg_250x250.jpg_.webp',169.9,'【天猫超市】 圣牧 全程沙漠有全脂纯牛奶200ml*24盒组合2提装 ',2,21,3,1,10,0,'2019-12-08 19:13:45'),(18,0,1,NULL,'https://g-search1.alicdn.com/img/bao/uploaded/i4/i1/725677994/O1CN01EZylr228vIf2gZqBq_!!0-item_pic.jpg_250x250.jpg_.webp',38,'金龙鱼 盘锦大米 蟹稻共生5kg 东北大米 人气爆款 ',3,21,3,1,10,0,'2019-12-08 19:13:45'),(19,0,1,NULL,'https://g-search1.alicdn.com/img/bao/uploaded/i4/i2/725677994/O1CN01FWuV7a28vIfFjtpGn_!!0-item_pic.jpg_250x250.jpg_.webp',69.9,'御泥坊三合一黑面膜20片收缩毛孔补水面膜补水保湿提亮肤色女正品 ',12,21,3,1,10,0,'2019-12-08 19:13:45'),(20,0,1,NULL,'https://g-search2.alicdn.com/img/bao/uploaded/i4/i1/725677994/O1CN01h9GyTZ28vIfF2ZGln_!!0-item_pic.jpg_250x250.jpg_.webp',19.9,'三只松鼠 猪肉脯210g休闲小吃网红肉脯零食特产美食靖江风味 ',54,21,3,1,10,0,'2019-12-08 19:13:45'),(21,0,1,NULL,'https://g-search1.alicdn.com/img/bao/uploaded/i4/i4/725677994/TB2dm0pdcfpK1RjSZFOXXa6nFXa_!!725677994-0-sm.jpg_250x250.jpg_.webp',39.8,'蜜诺达法式咸芝士棒西饼32g/袋曲奇早餐饼干曲奇休闲零食小包装 ',45,21,3,1,10,0,'2019-12-08 19:13:45'),(22,0,1,NULL,'https://g-search2.alicdn.com/img/bao/uploaded/i4/i1/725677994/O1CN0199KoRV28vIfKT2qkQ_!!0-item_pic.jpg_250x250.jpg_.webp',39.8,'金龙鱼 纯正 玉米油4L 食用油 非转基因 压榨 ',11,21,4,1,10,0,'2019-12-08 19:13:45'),(23,0,1,NULL,'https://g-search3.alicdn.com/img/bao/uploaded/i4/i2/2616970884/O1CN01v2Xz2x1IOudQkhK7Q_!!0-item_pic.jpg_250x250.jpg_.webp',22.9,'三只松鼠碧根果120g零食小吃每日坚果山核桃长寿果 ',11,21,4,1,10,0,'2019-12-08 19:13:45'),(24,0,1,NULL,'https://g-search3.alicdn.com/img/bao/uploaded/i4/i2/2616970884/O1CN01v2Xz2x1IOudQkhK7Q_!!0-item_pic.jpg_250x250.jpg_.webp',699,'【64GB限时优惠100元】华为HONOR荣耀8X全面大屏幕指纹解锁智能游戏青春学生新手机老年人电话机官方网旗舰店',12,1,4,1,100,0,'2019-12-08 19:13:45'),(25,0,1,NULL,'https://g-search3.alicdn.com/img/bao/uploaded/i4/i2/2616970884/O1CN01v2Xz2x1IOudQkhK7Q_!!0-item_pic.jpg_250x250.jpg_.webp',899,'【64GB限时优惠100元】华为HONOR荣耀8X全面大屏幕指纹解锁智能游戏青春学生新手机老年人电话机官方网旗舰店',24,1,5,1,100,0,'2019-12-08 19:13:45'),(26,0,1,NULL,'https://g-search3.alicdn.com/img/bao/uploaded/i4/i2/2616970884/O1CN01v2Xz2x1IOudQkhK7Q_!!0-item_pic.jpg_250x250.jpg_.webp',10,'【64GB限时优惠100元】华为HONOR荣耀8X全面大屏幕指纹解锁智能游戏青春学生新手机老年人电话机官方网旗舰店',55,3,5,1,4,0,'2019-12-08 19:13:45'),(27,0,1,NULL,'https://g-search3.alicdn.com/img/bao/uploaded/i4/i2/2616970884/O1CN01v2Xz2x1IOudQkhK7Q_!!0-item_pic.jpg_250x250.jpg_.webp',1,'【64GB限时优惠100元】华为HONOR荣耀8X全面大屏幕指纹解锁智能游戏青春学生新手机老年人电话机官方网旗舰店',45,1,5,1,4,0,'2019-12-08 19:13:45'),(28,0,1,NULL,'https://g-search3.alicdn.com/img/bao/uploaded/i4/i2/2616970884/O1CN01v2Xz2x1IOudQkhK7Q_!!0-item_pic.jpg_250x250.jpg_.webp',1,'【64GB限时优惠100元】华为HONOR荣耀8X全面大屏幕指纹解锁智能游戏青春学生新手机老年人电话机官方网旗舰店',546,1,5,1,4,0,'2019-12-08 19:13:45'),(29,0,1,NULL,'https://g-search3.alicdn.com/img/bao/uploaded/i4/i2/2616970884/O1CN01v2Xz2x1IOudQkhK7Q_!!0-item_pic.jpg_250x250.jpg_.webp',1,'【64GB限时优惠100元】华为HONOR荣耀8X全面大屏幕指纹解锁智能游戏青春学生新手机老年人电话机官方网旗舰店',786,1,5,1,4,0,'2019-12-08 19:13:45'),(30,0,1,NULL,'https://g-search3.alicdn.com/img/bao/uploaded/i4/i2/2616970884/O1CN01v2Xz2x1IOudQkhK7Q_!!0-item_pic.jpg_250x250.jpg_.webp',1,'【64GB限时优惠100元】华为HONOR荣耀8X全面大屏幕指纹解锁智能游戏青春学生新手机老年人电话机官方网旗舰店',54,1,5,1,4,0,'2019-12-08 19:13:45'),(56,0,0,'2
\r\n',NULL,2,'2',0,2,1,0,2,NULL,'2019-12-09 02:50:43'),(57,0,0,'333
\r\n','20191209104845.png',3,'3',0,2,3,0,3,NULL,'2019-12-09 10:48:45'),(58,0,0,'444
\r\n','20191209105218.png',4,'444',0,1,2,0,4,NULL,'2019-12-09 10:52:18'),(59,0,0,'66
\r\n','20191209105340.png',6,'4',0,2,2,0,6,NULL,'2019-12-09 10:53:40');/*Table structure for table `t_product_type` */DROP TABLE IF EXISTS `t_product_type`;CREATE TABLE `t_product_type` ( `id` int(11) NOT NULL AUTO_INCREMENT, `image_name` varchar(255) DEFAULT NULL, `name` varchar(100) DEFAULT NULL, `conent` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;/*Data for the table `t_product_type` */insert into `t_product_type`(`id`,`image_name`,`name`,`conent`) values (1,NULL,'3C数码','3C数码'),(2,NULL,'服饰家居','服饰家居'),(3,NULL,'商城超市','商城超市'),(4,NULL,'家用电器','家用电器'),(5,NULL,'生鲜特产','生鲜特产');/*Table structure for table `t_role` */DROP TABLE IF EXISTS `t_role`;CREATE TABLE `t_role` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) DEFAULT NULL, `remarks` varchar(1000) DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;/*Data for the table `t_role` */insert into `t_role`(`id`,`name`,`remarks`) values (1,'系统管理','管理员 最高权限'),(2,'主管','主管');/*Table structure for table `t_role_menu` */DROP TABLE IF EXISTS `t_role_menu`;CREATE TABLE `t_role_menu` ( `id` int(11) NOT NULL AUTO_INCREMENT, `menu_id` int(11) DEFAULT NULL, `role_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `FKhayg4ib6v7h1wyeyxhq6xlddq` (`menu_id`), KEY `FKsonb0rbt2u99hbrqqvv3r0wse` (`role_id`), CONSTRAINT `FKhayg4ib6v7h1wyeyxhq6xlddq` FOREIGN KEY (`menu_id`) REFERENCES `t_menu` (`id`), CONSTRAINT `FKsonb0rbt2u99hbrqqvv3r0wse` FOREIGN KEY (`role_id`) REFERENCES `t_role` (`id`)) ENGINE=InnoDB AUTO_INCREMENT=119 DEFAULT CHARSET=utf8;/*Data for the table `t_role_menu` */insert into `t_role_menu`(`id`,`menu_id`,`role_id`) values (2,1,1),(3,10,1),(4,20,1),(5,30,1),(6,40,1),(7,50,1),(8,60,1),(9,1010,1),(10,1020,1),(14,2010,1),(19,3010,1),(20,3020,1),(21,3030,1),(22,3040,1),(23,3050,1),(24,4010,1),(25,4020,1),(26,4030,1),(27,4040,1),(28,4050,1),(29,4060,1),(30,5010,1),(31,5020,1),(32,5030,1),(33,5040,1),(34,6010,1),(35,6020,1),(43,6030,1),(44,6040,1),(64,6050,1),(111,1,2),(112,10,2),(113,1010,2),(114,1020,2),(115,20,2),(116,2010,2),(117,30,2),(118,3010,2);/*Table structure for table `t_sign` */DROP TABLE IF EXISTS `t_sign`;CREATE TABLE `t_sign` ( `id` int(11) NOT NULL AUTO_INCREMENT, `time` datetime DEFAULT NULL, `user_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `FKpgbiiry4i4nmqkrsflmqkhnuj` (`user_id`), CONSTRAINT `FKpgbiiry4i4nmqkrsflmqkhnuj` FOREIGN KEY (`user_id`) REFERENCES `t_user` (`id`)) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;/*Data for the table `t_sign` */insert into `t_sign`(`id`,`time`,`user_id`) values (2,'2019-04-11 22:15:09',1),(3,'2019-12-02 02:27:36',1);/*Table structure for table `t_user` */DROP TABLE IF EXISTS `t_user`;CREATE TABLE `t_user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `address` varchar(255) DEFAULT NULL, `email` varchar(100) DEFAULT NULL, `image_name` varchar(100) DEFAULT NULL, `is_off` bit(1) NOT NULL, `password` varchar(100) DEFAULT NULL, `phone` varchar(100) DEFAULT NULL, `points` int(11) DEFAULT NULL, `register_date` datetime DEFAULT NULL, `user_name` varchar(100) DEFAULT NULL, `code` varchar(255) DEFAULT NULL, `login_date` datetime DEFAULT NULL, `token` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;/*Data for the table `t_user` */insert into `t_user`(`id`,`address`,`email`,`image_name`,`is_off`,`password`,`phone`,`points`,`register_date`,`user_name`,`code`,`login_date`,`token`) values (1,NULL,NULL,NULL,'\0','679c95616439f714e074d5ba7dde2909','1894',0,'2019-04-09 22:35:14','123',NULL,NULL,NULL),(2,NULL,NULL,NULL,'\0','709c6d536da2f6d916812b2e56ddbeb1','189',0,'2019-12-07 19:07:09','123',NULL,NULL,NULL),(3,NULL,NULL,NULL,'\0','14a41f704fbb3e11ae8bf13f8280ea94','189',0,'2019-12-07 19:10:37','123',NULL,NULL,NULL);/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
转载地址:https://monologue.blog.csdn.net/article/details/104628152 如侵犯您的版权,请留言回复原文章的地址,我们会给您删除此文章,给您带来不便请您谅解!
发表评论
最新留言
能坚持,总会有不一样的收获!
[***.219.124.196]2024年05月04日 10时14分34秒
关于作者
喝酒易醉,品茶养心,人生如梦,品茶悟道,何以解忧?唯有杜康!
-- 愿君每日到此一游!
推荐文章
剑指offer:往上到下打印二叉树(java)
2019-05-03
剑指offer:二叉搜索树的后序遍历序列(java)
2019-05-03
剑指offer:二叉树中和为某一值的所有路径(java)
2019-05-03
剑指offer:复杂链表的复制(java)
2019-05-03
剑指offer:二叉搜索树与双向链表(java)
2019-05-03
剑指offer:字符串的排列(java)
2019-05-03
剑指offer:字符串的组合(java)
2019-05-03
剑指offer:数组中出现次数超过一半的数字(java)
2019-05-03
剑指offer:最小的k个数(java)
2019-05-03
剑指offer:连续子数组的最大和(java)
2019-05-03
剑指offer:从1到n整数中1出现的次数(java)
2019-05-03
剑指offer:把数组排成最小的数(java)
2019-05-03
剑指offer:丑数(java)
2019-05-03
剑指offer:第一个只出现一次的字
2019-05-03
剑指offer:数组中的逆序对(java)
2019-05-03
剑指offer:两个链表的第一个公共结点(java)
2019-05-03
剑指offer:数字在排序数组中出现的次数(java)
2019-05-03
实时开发框架Meteor API解读系列<二>Core
2019-05-03