手把手教你SSM搭建Easymall电商项目 (二)

最新推荐文章于 2021-01-26 23:08:44 发布

萌新Java程序猿

最新推荐文章于 2021-01-26 23:08:44 发布

阅读量5.1k

点赞数 2

分类专栏： Esaymall SSM项目实战演练文章标签： SSM

版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。

本文链接：https://blog.csdn.net/LiuY521/article/details/90412946

版权

Esaymall 同时被 2 个专栏收录

7 篇文章 1 订阅

订阅专栏

SSM项目实战演练

7 篇文章 3 订阅

订阅专栏

SSM搭建Easymall电商项目 (二)

目录

SSM搭建Easymall电商项目 (二)

一.Easymall需求代码实现

1.测试类测试请求地址路径IndexController.java 动态查询,输入信息的数据跳转相应的页面

1.1测试结果图

2.写一个类去实现商品相关的需求代码ProductController

1.1Easymall数据库.sql文件 emdb.sql PS:记得数据库和配置一定要匹配

一.Easymall需求代码实现

1.测试类测试请求地址路径IndexController.java 动态查询,输入信息的数据跳转相应的页面

package com.jt.easymall.controller;

import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.ResponseBody;
/**
 * 容器的扫描范围之内，完成controller对象创建
 * 实现springmvc容器的管理对象逻辑
 * @author TY
 * create date: 2019年5月20日 下午5:31:41
 */
@Controller
public class IndexController {
	//dispatcherservlet将会根据映射器处理
	//找到当前容器中所有requestMapping匹配的controller方法
	@RequestMapping(value="/",method=RequestMethod.GET)
	public String goIndex() {
		return "index";//视图解析器，前缀，后缀的拼接
		//最终页面响应的结果WEB-INF/views/index.jsp
	}
	///addr1/addr2/addr3
	//在映射注解mapping中定义的{变量名}，必须和方法的参数变量名一致
	//顺序最好保持路径从左到右的获取
	/*@RequestMapping(value="{var1}/{var2}/{var3}")
	@ResponseBody//视图解析时不拼接前后缀寻找页面，直接将controller的返回
	//结果放到响应体中
	public String pathVar(@PathVariable String var1,
			@PathVariable String var2,@PathVariable String var3){
		System.out.println("var1="+var1);
		System.out.println("var2="+var2);
		System.out.println("var3="+var3);
		return "pay";
	}*/
	//动态接收请求地址参数做页面跳转
	@RequestMapping(value="page/{pageName}",method=RequestMethod.GET)
	public String goPage(@PathVariable String pageName){
		//页面解析的地址值
		return pageName;
	}
}

1.1测试结果图

2.写一个类去实现商品相关的需求代码ProductController

package com.jt.easymall.controller;
/**
 * 处理所有与商品逻辑有管的请求
 * 控制层
 * @author TEDU
 */

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.ResponseBody;

import com.jt.easymall.pojo.Product;
import com.jt.easymall.service.ProductService;
import com.jt.easymall.vo.EasyUIResult;
import com.jt.easymall.vo.Page;
import com.jt.easymall.vo.SysResult;

@Controller
public class ProductController {
	/*private static final Integer AVALIBLE=1;
	private static final String ALLOW_PRI="明天过来拿东西";*/
	@Autowired
	private ProductService productService;
	//请求地址：/product/page?currentPage=1&rows=5
	@RequestMapping(value="product/page"
			,method=RequestMethod.GET)
	public String queryByPage(Integer currentPage,Integer rows,
			Model model){
		//如果有数据，返回到页面解析，如何携带数据，model将数据放到域
		//el表达式可以从域数据获取数据展示内容，使用内容
	//	Page page=productService.queryByPage(currentPage,rows);
		//携带数据返回,${page.currentPage},${page.totalPage},${page.products}
	//	model.addAttribute("page", page);
		return "product_list";
	}

2.1实现图

3.分页查询

下面是相关配置代码和接口

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.jt.easymall.mapper.ProductMapper">
	<select id="queryTotal" resultType="int">
		select count(product_id) from t_product;
	</select>
	<select id="queryByPage" resultType="Product">
		select * from t_product limit #{start},#{rows}
	</select>
</mapper>

package com.jt.easymall.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.jt.easymall.pojo.Product;

public interface ProductMapper {
	//查询总条数
	int queryTotal();
	//查询分页
	List<Product> queryByPage(@Param(value="start")int start, @Param(value="rows")Integer rows);

	Product queryById(String productId);

	void saveProduct(Product product);

	void updateProduct(Product product);

}

@Controller
public class ProductController {
	/*private static final Integer AVALIBLE=1;
	private static final String ALLOW_PRI="明天过来拿东西";*/
	@Autowired
	private ProductService productService;
	//请求地址：/product/page?currentPage=1&rows=5
	@RequestMapping(value="product/page"
			,method=RequestMethod.GET)
	public String queryByPage(Integer currentPage,Integer rows,
			Model model){
		//如果有数据，返回到页面解析，如何携带数据，model将数据放到域
		//el表达式可以从域数据获取数据展示内容，使用内容
		Page page=productService.queryByPage(currentPage,rows);
		//携带数据返回,${page.currentPage},${page.totalPage},${page.products}
		model.addAttribute("page", page);
		return "product_list";
	}

@Service
public class ProductService {
	@Autowired
	private ProductMapper productMapper;
	public Page queryByPage(Integer currentPage, Integer rows) {
		//准备一个空对象
		Page page=new Page();
		page.setCurrentPage(currentPage);//当前页封装完毕
		//封装总页数，需要从持久层查询商品表格的数据条数81，与rows做计算
		//从数据库查询product的总条数 select count(*) from t_product
		int total=productMapper.queryTotal();
		int totalPage=(total%rows==0)?(total/rows):(total/rows+1);
		page.setTotalPage(totalPage);
		//封装根据页数和条数查询的分页结果 select * from t_product limit start,rows
		//计算start起始位置
		int start=(currentPage-1)*rows;
		List<Product> pList=productMapper.queryByPage(start,rows);
		page.setProducts(pList);
		return page;
	}

3.1效果图

1.1Easymall数据库.sql文件 emdb.sql PS:记得数据库和配置一定要匹配

/*
SQLyog Ultimate - MySQL GUI v8.2 
MySQL - 5.5.27 : Database - easydb
*********************************************************************
*/
/*!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*/`easydb` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `easydb`;

/*Table structure for table `t_cart` */

DROP TABLE IF EXISTS `t_cart`;

CREATE TABLE `t_cart` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(100) DEFAULT NULL,
  `product_id` varchar(100) DEFAULT NULL,
  `product_image` varchar(500) DEFAULT NULL,
  `product_name` varchar(100) DEFAULT NULL,
  `product_price` double DEFAULT NULL,
  `num` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;

/*Data for the table `t_cart` */

insert  into `t_cart`(`id`,`user_id`,`product_id`,`product_image`,`product_name`,`product_price`,`num`) values (13,'sdalfj','sadfasdfs','dslfjasdfasdf','sadf',2323,4646),(15,'df05c14c-679e-414d-b10a-958a48793382','0b984a7e-fc0d-4bd0-90a6-b03a93213909','http://image.jt.com//upload\\d\\1\\5\\2\\9\\e\\b\\f/1539450159413600.jpg','澶х數瑙嗕粠c浠庝粠',123,8),(16,'ecaf1f41-bc7b-4d2d-a237-3731caa11d86','09f47493-214d-44bc-927d-6ce0bf89a057','http://image.jt.com/upload/5/2/3/4/7/8/d/c/1838eaa6-6459-420f-b8e2-6ea9f43c4b5e_dfd259ab-bcc7-43f6-a9d5-62872ff5671e.jpg','iPhone7Plus 3200G 榛戣壊鎵嬫満',1000,9);

/*Table structure for table `t_order` */

DROP TABLE IF EXISTS `t_order`;

CREATE TABLE `t_order` (
  `order_id` char(36) NOT NULL DEFAULT '',
  `order_money` double DEFAULT '0',
  `order_receiverinfo` varchar(255) DEFAULT '',
  `order_paystate` int(11) DEFAULT '0',
  `order_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `user_id` char(36) DEFAULT NULL,
  PRIMARY KEY (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `t_order` */

insert  into `t_order`(`order_id`,`order_money`,`order_receiverinfo`,`order_paystate`,`order_time`,`user_id`) values ('06036d1e-79d6-404e-b564-f666f778a2b8',10900,'鍖椾含甯傛湞闃冲尯甯歌惀',0,'2018-05-22 12:12:12','7008ffa6-e01d-48ed-a460-dbf2a4908bfa'),('35d29c62-4d52-42cc-8808-a37cdc7ee9ea',10900,'鍖椾含甯傛湞闃冲尯甯歌惀',0,'2018-05-22 12:12:12','7008ffa6-e01d-48ed-a460-dbf2a4908bfa'),('39511958-ea3d-4679-ae5c-80ecb100c7d0',10900,'鍖椾含甯傛湞闃冲尯甯歌惀',1,'2018-05-22 12:12:12','7008ffa6-e01d-48ed-a460-dbf2a4908bfa'),('461dd627-003b-45e7-a0a4-bc951791fd97',10900,'鍖椾含甯傛湞闃冲尯甯歌惀',1,'2018-05-22 12:12:12','7008ffa6-e01d-48ed-a460-dbf2a4908bfa'),('508f4dd3-b65d-40f4-8f73-f109d1bde6e0',12900,'鍖椾含甯傛湞闃冲尯甯歌惀',0,'2018-05-22 12:12:12','7008ffa6-e01d-48ed-a460-dbf2a4908bfa'),('5cbf3c83-81ed-44df-bf8b-fc2c570000a3',10900,'鍖椾含甯傛湞闃冲尯甯歌惀',1,'2018-05-22 12:12:12','7008ffa6-e01d-48ed-a460-dbf2a4908bfa'),('6ad4abfa-113c-45df-bc52-22c4ab4148a6',10900,'鍖椾含甯傛湞闃冲尯甯歌惀',0,'2018-05-22 12:12:12','7008ffa6-e01d-48ed-a460-dbf2a4908bfa'),('7b9a34c3-2777-43a8-814e-46de8399e767',10900,'鍖椾含甯傛湞闃冲尯甯歌惀',0,'2018-05-22 12:12:12','7008ffa6-e01d-48ed-a460-dbf2a4908bfa'),('80ecd7b1-9287-4892-8b65-2a0750d33b9e',10900,'鍖椾含甯傛湞闃冲尯甯歌惀',1,'2018-05-22 12:12:12','7008ffa6-e01d-48ed-a460-dbf2a4908bfa'),('8457cebf-1593-4c98-87c7-96671f181c9e',1000,'dsafdsfsdfsdf',0,'2018-08-02 21:51:59','10bf2a84-4bf6-40b1-8c85-e625bdb1e938'),('87b76d07-d8c8-4957-af94-a62b942a7a84',10900,'鍖椾含甯傛湞闃冲尯甯歌惀',1,'2018-05-22 12:12:12','7008ffa6-e01d-48ed-a460-dbf2a4908bfa'),('95887eee-be01-4574-b8d5-79093b027ff4',10000,'鍖椾含甯傛湞闃冲尯甯歌惀',1,'2018-05-22 12:12:12','a28e34eb-ec9d-43cd-a297-42abb14afcf9'),('a0903b70-d83a-4fa9-9746-b33ce6b0d92a',12900,'鍖椾含甯傛湞闃冲尯甯歌惀',1,'2018-05-22 12:12:12','7008ffa6-e01d-48ed-a460-dbf2a4908bfa'),('a69060de-d7cc-4007-a854-ede6ffb4d1d0',900,'',0,'2018-08-02 21:50:55','10bf2a84-4bf6-40b1-8c85-e625bdb1e938'),('ba3fd8ba-66c4-4051-a917-748838bf2ad5',10900,'鍖椾含甯傛湞闃冲尯甯歌惀',1,'2018-05-22 12:12:12','7008ffa6-e01d-48ed-a460-dbf2a4908bfa'),('bc91fed9-9333-4236-a2a6-2144bb778c2f',6978,'',0,'2018-10-03 19:32:51','ecaf1f41-bc7b-4d2d-a237-3731caa11d86'),('de20d0c5-4863-41fa-8ff8-299cda3182b2',10000,'鍖椾含甯傛湞闃冲尯甯歌惀',0,'2018-05-22 12:12:12','a28e34eb-ec9d-43cd-a297-42abb14afcf9'),('e2104664-3285-46f9-8990-66264b46e54a',10900,'鍖椾含甯傛湞闃冲尯甯歌惀',0,'2018-05-22 12:12:12','7008ffa6-e01d-48ed-a460-dbf2a4908bfa'),('e262f1f2-0cdd-4694-9d3b-f6752df5dc23',10900,'鍖椾含甯傛湞闃冲尯甯歌惀',0,'2018-05-22 12:12:12','7008ffa6-e01d-48ed-a460-dbf2a4908bfa'),('e59d231f-e4ad-4912-a9cb-0a7a525374d3',6778,'',0,'2018-10-03 19:31:33','ecaf1f41-bc7b-4d2d-a237-3731caa11d86');

/*Table structure for table `t_order_item` */

DROP TABLE IF EXISTS `t_order_item`;

CREATE TABLE `t_order_item` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `order_id` char(100) DEFAULT NULL,
  `product_id` char(36) DEFAULT NULL,
  `num` int(11) DEFAULT '0',
  `product_image` varchar(500) DEFAULT NULL,
  `product_name` varchar(100) DEFAULT NULL,
  `product_price` double DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=104 DEFAULT CHARSET=utf8;

/*Data for the table `t_order_item` */

insert  into `t_order_item`(`id`,`order_id`,`product_id`,`num`,`product_image`,`product_name`,`product_price`) values (52,'19d7609c-0783-4ff5-82a6-2ee232989dac','07c1b2d5-4e73-4499-8046-71cb2d193e11',28,'upload/2/6/4/a/a/5/2/3/ee6c796a-6333-4cd5-a06e-271d876aac8c_589577.jpg','鍚庢倲鑽?',200),(53,'19d7609c-0783-4ff5-82a6-2ee232989dac','09f47493-214d-44bc-927d-6ce0bf89a057',1,'upload/5/2/3/4/7/8/d/c/1838eaa6-6459-420f-b8e2-6ea9f43c4b5e_dfd259ab-bcc7-43f6-a9d5-62872ff5671e.jpg','iPhone7Plus 3200G 榛戣壊鎵嬫満',1000),(54,'19d7609c-0783-4ff5-82a6-2ee232989dac','5b7a84fb-b888-4c5d-8ace-6877d909fe89',1,'upload/e/d/b/1/f/0/6/7/bcff4ee1-cc7f-4b30-a29c-017f76a21bf8_1.jpg','鑻?null1',998),(55,'19d7609c-0783-4ff5-82a6-2ee232989dac','103e5414-0da2-4fba-b92f-0ba876e08939',1,'upload/4/d/2/a/2/3/1/8/b3c3fc7a-222c-49be-9491-f466553d2284_386718.jpg','婊戦洩濂楄',2000),(56,'19d7609c-0783-4ff5-82a6-2ee232989dac','1114f043-e36a-4333-ae5e-5e610eabca12',1,'upload/6/b/8/3/a/4/9/8/3fb77001-cd6c-4e4f-94a1-21a9c0563778_Hydrangeas.jpg','闃插垎鎵嬬鍣細澶х爾澶?',0),(57,'19d7609c-0783-4ff5-82a6-2ee232989dac','49d57c16-758b-425a-ba96-9da03b86408d',1,'upload/7/c/b/f/7/d/2/9/5e229aef-063f-4d0d-91df-2d4aa7167670_6f84843a-1d1e-49c7-b4ce-c035d7790171.jpg','鎵撳嵃鏈?',180),(58,'19d7609c-0783-4ff5-82a6-2ee232989dac','05e20c1a-0401-4c0a-82ab-6fb0f37db397',1,'upload/5/e/d/5/4/5/e/b/5f0d34dc-157f-49ba-ad39-1b28927ba6ae_1005714.jpg','娴锋哗鍒',900),(59,'23c34051-ea4f-4dd9-8a57-d2b896a570a3','07c1b2d5-4e73-4499-8046-71cb2d193e11',28,'upload/2/6/4/a/a/5/2/3/ee6c796a-6333-4cd5-a06e-271d876aac8c_589577.jpg','鍚庢倲鑽?',200),(60,'23c34051-ea4f-4dd9-8a57-d2b896a570a3','09f47493-214d-44bc-927d-6ce0bf89a057',1,'upload/5/2/3/4/7/8/d/c/1838eaa6-6459-420f-b8e2-6ea9f43c4b5e_dfd259ab-bcc7-43f6-a9d5-62872ff5671e.jpg','iPhone7Plus 3200G 榛戣壊鎵嬫満',1000),(61,'23c34051-ea4f-4dd9-8a57-d2b896a570a3','5b7a84fb-b888-4c5d-8ace-6877d909fe89',1,'upload/e/d/b/1/f/0/6/7/bcff4ee1-cc7f-4b30-a29c-017f76a21bf8_1.jpg','鑻?null1',998),(62,'23c34051-ea4f-4dd9-8a57-d2b896a570a3','103e5414-0da2-4fba-b92f-0ba876e08939',1,'upload/4/d/2/a/2/3/1/8/b3c3fc7a-222c-49be-9491-f466553d2284_386718.jpg','婊戦洩濂楄',2000),(63,'23c34051-ea4f-4dd9-8a57-d2b896a570a3','1114f043-e36a-4333-ae5e-5e610eabca12',1,'upload/6/b/8/3/a/4/9/8/3fb77001-cd6c-4e4f-94a1-21a9c0563778_Hydrangeas.jpg','闃插垎鎵嬬鍣細澶х爾澶?',0),(64,'23c34051-ea4f-4dd9-8a57-d2b896a570a3','49d57c16-758b-425a-ba96-9da03b86408d',1,'upload/7/c/b/f/7/d/2/9/5e229aef-063f-4d0d-91df-2d4aa7167670_6f84843a-1d1e-49c7-b4ce-c035d7790171.jpg','鎵撳嵃鏈?',180),(65,'23c34051-ea4f-4dd9-8a57-d2b896a570a3','05e20c1a-0401-4c0a-82ab-6fb0f37db397',2,'upload/5/e/d/5/4/5/e/b/5f0d34dc-157f-49ba-ad39-1b28927ba6ae_1005714.jpg','娴锋哗鍒',900),(66,'06f9577b-dc11-487a-bf80-7d15ae9e66e1','07c1b2d5-4e73-4499-8046-71cb2d193e11',28,'upload/2/6/4/a/a/5/2/3/ee6c796a-6333-4cd5-a06e-271d876aac8c_589577.jpg','鍚庢倲鑽?',200),(67,'06f9577b-dc11-487a-bf80-7d15ae9e66e1','09f47493-214d-44bc-927d-6ce0bf89a057',2,'upload/5/2/3/4/7/8/d/c/1838eaa6-6459-420f-b8e2-6ea9f43c4b5e_dfd259ab-bcc7-43f6-a9d5-62872ff5671e.jpg','iPhone7Plus 3200G 榛戣壊鎵嬫満',1000),(68,'06f9577b-dc11-487a-bf80-7d15ae9e66e1','5b7a84fb-b888-4c5d-8ace-6877d909fe89',1,'upload/e/d/b/1/f/0/6/7/bcff4ee1-cc7f-4b30-a29c-017f76a21bf8_1.jpg','鑻?null1',998),(69,'06f9577b-dc11-487a-bf80-7d15ae9e66e1','103e5414-0da2-4fba-b92f-0ba876e08939',1,'upload/4/d/2/a/2/3/1/8/b3c3fc7a-222c-49be-9491-f466553d2284_386718.jpg','婊戦洩濂楄',2000),(70,'06f9577b-dc11-487a-bf80-7d15ae9e66e1','1114f043-e36a-4333-ae5e-5e610eabca12',1,'upload/6/b/8/3/a/4/9/8/3fb77001-cd6c-4e4f-94a1-21a9c0563778_Hydrangeas.jpg','闃插垎鎵嬬鍣細澶х爾澶?',0),(71,'06f9577b-dc11-487a-bf80-7d15ae9e66e1','49d57c16-758b-425a-ba96-9da03b86408d',1,'upload/7/c/b/f/7/d/2/9/5e229aef-063f-4d0d-91df-2d4aa7167670_6f84843a-1d1e-49c7-b4ce-c035d7790171.jpg','鎵撳嵃鏈?',180),(72,'06f9577b-dc11-487a-bf80-7d15ae9e66e1','05e20c1a-0401-4c0a-82ab-6fb0f37db397',2,'upload/5/e/d/5/4/5/e/b/5f0d34dc-157f-49ba-ad39-1b28927ba6ae_1005714.jpg','娴锋哗鍒',900),(73,'c1f6e10b-36ca-45ca-adb4-8c89d4fa18d1','07c1b2d5-4e73-4499-8046-71cb2d193e11',28,'upload/2/6/4/a/a/5/2/3/ee6c796a-6333-4cd5-a06e-271d876aac8c_589577.jpg','鍚庢倲鑽?',200),(74,'c1f6e10b-36ca-45ca-adb4-8c89d4fa18d1','09f47493-214d-44bc-927d-6ce0bf89a057',2,'upload/5/2/3/4/7/8/d/c/1838eaa6-6459-420f-b8e2-6ea9f43c4b5e_dfd259ab-bcc7-43f6-a9d5-62872ff5671e.jpg','iPhone7Plus 3200G 榛戣壊鎵嬫満',1000),(75,'c1f6e10b-36ca-45ca-adb4-8c89d4fa18d1','5b7a84fb-b888-4c5d-8ace-6877d909fe89',1,'upload/e/d/b/1/f/0/6/7/bcff4ee1-cc7f-4b30-a29c-017f76a21bf8_1.jpg','鑻?null1',998),(76,'c1f6e10b-36ca-45ca-adb4-8c89d4fa18d1','103e5414-0da2-4fba-b92f-0ba876e08939',1,'upload/4/d/2/a/2/3/1/8/b3c3fc7a-222c-49be-9491-f466553d2284_386718.jpg','婊戦洩濂楄',2000),(77,'c1f6e10b-36ca-45ca-adb4-8c89d4fa18d1','1114f043-e36a-4333-ae5e-5e610eabca12',1,'upload/6/b/8/3/a/4/9/8/3fb77001-cd6c-4e4f-94a1-21a9c0563778_Hydrangeas.jpg','闃插垎鎵嬬鍣細澶х爾澶?',0),(78,'c1f6e10b-36ca-45ca-adb4-8c89d4fa18d1','49d57c16-758b-425a-ba96-9da03b86408d',1,'upload/7/c/b/f/7/d/2/9/5e229aef-063f-4d0d-91df-2d4aa7167670_6f84843a-1d1e-49c7-b4ce-c035d7790171.jpg','鎵撳嵃鏈?',180),(79,'c1f6e10b-36ca-45ca-adb4-8c89d4fa18d1','05e20c1a-0401-4c0a-82ab-6fb0f37db397',2,'upload/5/e/d/5/4/5/e/b/5f0d34dc-157f-49ba-ad39-1b28927ba6ae_1005714.jpg','娴锋哗鍒',900),(80,'d53f6de0-efb9-490c-92d8-d27179d0d51d','07c1b2d5-4e73-4499-8046-71cb2d193e11',28,'upload/2/6/4/a/a/5/2/3/ee6c796a-6333-4cd5-a06e-271d876aac8c_589577.jpg','鍚庢倲鑽?',200),(81,'d53f6de0-efb9-490c-92d8-d27179d0d51d','09f47493-214d-44bc-927d-6ce0bf89a057',2,'upload/5/2/3/4/7/8/d/c/1838eaa6-6459-420f-b8e2-6ea9f43c4b5e_dfd259ab-bcc7-43f6-a9d5-62872ff5671e.jpg','iPhone7Plus 3200G 榛戣壊鎵嬫満',1000),(82,'d53f6de0-efb9-490c-92d8-d27179d0d51d','5b7a84fb-b888-4c5d-8ace-6877d909fe89',1,'upload/e/d/b/1/f/0/6/7/bcff4ee1-cc7f-4b30-a29c-017f76a21bf8_1.jpg','鑻?null1',998),(83,'d53f6de0-efb9-490c-92d8-d27179d0d51d','103e5414-0da2-4fba-b92f-0ba876e08939',1,'upload/4/d/2/a/2/3/1/8/b3c3fc7a-222c-49be-9491-f466553d2284_386718.jpg','婊戦洩濂楄',2000),(84,'d53f6de0-efb9-490c-92d8-d27179d0d51d','1114f043-e36a-4333-ae5e-5e610eabca12',1,'upload/6/b/8/3/a/4/9/8/3fb77001-cd6c-4e4f-94a1-21a9c0563778_Hydrangeas.jpg','闃插垎鎵嬬鍣細澶х爾澶?',0),(85,'d53f6de0-efb9-490c-92d8-d27179d0d51d','49d57c16-758b-425a-ba96-9da03b86408d',1,'upload/7/c/b/f/7/d/2/9/5e229aef-063f-4d0d-91df-2d4aa7167670_6f84843a-1d1e-49c7-b4ce-c035d7790171.jpg','鎵撳嵃鏈?',180),(86,'d53f6de0-efb9-490c-92d8-d27179d0d51d','05e20c1a-0401-4c0a-82ab-6fb0f37db397',3,'upload/5/e/d/5/4/5/e/b/5f0d34dc-157f-49ba-ad39-1b28927ba6ae_1005714.jpg','娴锋哗鍒',900),(87,'f90d1c83-b791-42ed-873b-153fefe07daf','07c1b2d5-4e73-4499-8046-71cb2d193e11',28,'upload/2/6/4/a/a/5/2/3/ee6c796a-6333-4cd5-a06e-271d876aac8c_589577.jpg','鍚庢倲鑽?',200),(88,'f90d1c83-b791-42ed-873b-153fefe07daf','09f47493-214d-44bc-927d-6ce0bf89a057',2,'upload/5/2/3/4/7/8/d/c/1838eaa6-6459-420f-b8e2-6ea9f43c4b5e_dfd259ab-bcc7-43f6-a9d5-62872ff5671e.jpg','iPhone7Plus 3200G 榛戣壊鎵嬫満',1000),(89,'f90d1c83-b791-42ed-873b-153fefe07daf','5b7a84fb-b888-4c5d-8ace-6877d909fe89',1,'upload/e/d/b/1/f/0/6/7/bcff4ee1-cc7f-4b30-a29c-017f76a21bf8_1.jpg','鑻?null1',998),(90,'f90d1c83-b791-42ed-873b-153fefe07daf','103e5414-0da2-4fba-b92f-0ba876e08939',1,'upload/4/d/2/a/2/3/1/8/b3c3fc7a-222c-49be-9491-f466553d2284_386718.jpg','婊戦洩濂楄',2000),(91,'f90d1c83-b791-42ed-873b-153fefe07daf','1114f043-e36a-4333-ae5e-5e610eabca12',1,'upload/6/b/8/3/a/4/9/8/3fb77001-cd6c-4e4f-94a1-21a9c0563778_Hydrangeas.jpg','闃插垎鎵嬬鍣細澶х爾澶?',0),(92,'f90d1c83-b791-42ed-873b-153fefe07daf','49d57c16-758b-425a-ba96-9da03b86408d',1,'upload/7/c/b/f/7/d/2/9/5e229aef-063f-4d0d-91df-2d4aa7167670_6f84843a-1d1e-49c7-b4ce-c035d7790171.jpg','鎵撳嵃鏈?',180),(93,'f90d1c83-b791-42ed-873b-153fefe07daf','05e20c1a-0401-4c0a-82ab-6fb0f37db397',3,'upload/5/e/d/5/4/5/e/b/5f0d34dc-157f-49ba-ad39-1b28927ba6ae_1005714.jpg','娴锋哗鍒',900),(94,'3dc54c4e-7f3c-4dd7-8efb-5b353c0dd744','07c1b2d5-4e73-4499-8046-71cb2d193e11',28,'upload/2/6/4/a/a/5/2/3/ee6c796a-6333-4cd5-a06e-271d876aac8c_589577.jpg','鍚庢倲鑽?',200),(95,'3dc54c4e-7f3c-4dd7-8efb-5b353c0dd744','09f47493-214d-44bc-927d-6ce0bf89a057',2,'upload/5/2/3/4/7/8/d/c/1838eaa6-6459-420f-b8e2-6ea9f43c4b5e_dfd259ab-bcc7-43f6-a9d5-62872ff5671e.jpg','iPhone7Plus 3200G 榛戣壊鎵嬫満',1000),(96,'3dc54c4e-7f3c-4dd7-8efb-5b353c0dd744','5b7a84fb-b888-4c5d-8ace-6877d909fe89',1,'upload/e/d/b/1/f/0/6/7/bcff4ee1-cc7f-4b30-a29c-017f76a21bf8_1.jpg','鑻?null1',998),(97,'3dc54c4e-7f3c-4dd7-8efb-5b353c0dd744','103e5414-0da2-4fba-b92f-0ba876e08939',1,'upload/4/d/2/a/2/3/1/8/b3c3fc7a-222c-49be-9491-f466553d2284_386718.jpg','婊戦洩濂楄',2000),(98,'3dc54c4e-7f3c-4dd7-8efb-5b353c0dd744','1114f043-e36a-4333-ae5e-5e610eabca12',1,'upload/6/b/8/3/a/4/9/8/3fb77001-cd6c-4e4f-94a1-21a9c0563778_Hydrangeas.jpg','闃插垎鎵嬬鍣細澶х爾澶?',0),(99,'3dc54c4e-7f3c-4dd7-8efb-5b353c0dd744','49d57c16-758b-425a-ba96-9da03b86408d',1,'upload/7/c/b/f/7/d/2/9/5e229aef-063f-4d0d-91df-2d4aa7167670_6f84843a-1d1e-49c7-b4ce-c035d7790171.jpg','鎵撳嵃鏈?',180),(100,'3dc54c4e-7f3c-4dd7-8efb-5b353c0dd744','05e20c1a-0401-4c0a-82ab-6fb0f37db397',3,'upload/5/e/d/5/4/5/e/b/5f0d34dc-157f-49ba-ad39-1b28927ba6ae_1005714.jpg','娴锋哗鍒',900),(101,'17d1dd74-b367-42ce-bf53-01c83e9e638b','09f47493-214d-44bc-927d-6ce0bf89a057',9,'http://image.jt.com/upload/5/2/3/4/7/8/d/c/1838eaa6-6459-420f-b8e2-6ea9f43c4b5e_dfd259ab-bcc7-43f6-a9d5-62872ff5671e.jpg','iPhone7Plus 3200G 榛戣壊鎵嬫満',1000),(102,'f32af018-0468-44a0-b14b-7de7b02137d5','07c1b2d5-4e73-4499-8046-71cb2d193e11',1,'http://image.jt.com/upload/2/6/4/a/a/5/2/3/ee6c796a-6333-4cd5-a06e-271d876aac8c_589577.jpg','鍚庢倲鑽?',200),(103,'21f17893-804c-4ea6-8876-266397a1ee6a','09f47493-214d-44bc-927d-6ce0bf89a057',9,'http://image.jt.com/upload/5/2/3/4/7/8/d/c/1838eaa6-6459-420f-b8e2-6ea9f43c4b5e_dfd259ab-bcc7-43f6-a9d5-62872ff5671e.jpg','iPhone7Plus 3200G 榛戣壊鎵嬫満',1000);

/*Table structure for table `t_product` */

DROP TABLE IF EXISTS `t_product`;

CREATE TABLE `t_product` (
  `product_id` char(36) NOT NULL DEFAULT '',
  `product_name` varchar(100) DEFAULT NULL,
  `product_price` double DEFAULT '0',
  `product_category` varchar(100) DEFAULT '',
  `product_imgurl` varchar(500) DEFAULT '',
  `product_num` int(11) DEFAULT '0',
  `product_description` varchar(255) DEFAULT '',
  PRIMARY KEY (`product_id`),
  UNIQUE KEY `UN_product_name` (`product_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `t_product` */

insert  into `t_product`(`product_id`,`product_name`,`product_price`,`product_category`,`product_imgurl`,`product_num`,`product_description`) values ('05e20c1a-0401-4c0a-82ab-6fb0f37db397','娴锋哗澶ф矙婊ゝds',900,'鐢靛瓙鏁扮爜','http://image.jt.com/upload/5/e/d/5/4/5/e/b/5f0d34dc-157f-49ba-ad39-1b28927ba6ae_1005714.jpg',211,'闈㈡湞澶ф捣, 渚ч潰鏈夊北, 瀹変韩鏅氬勾涔嬮閫?!!'),('07c1b2d5-4e73-4499-8046-71cb2d193e11','鍚庢倲鑽?',200,'鏃ョ敤鐧捐揣','http://image.jt.com/upload/2/6/4/a/a/5/2/3/ee6c796a-6333-4cd5-a06e-271d876aac8c_589577.jpg',4765,'閮借涓栦笂娌℃湁鍚庢倲鑽?鍘熸湰鎴戜篃娣变俊涓嶇枒'),('09f47493-214d-44bc-927d-6ce0bf89a057','iPhone7Plus 3200G 榛戣壊鎵嬫満',1000,'鐢靛瓙鏁扮爜','http://image.jt.com/upload/5/2/3/4/7/8/d/c/1838eaa6-6459-420f-b8e2-6ea9f43c4b5e_dfd259ab-bcc7-43f6-a9d5-62872ff5671e.jpg',2549,'鐖变笂鐖辩柉, 浣犵柉...鎴戠柉...澶у涓€璧风柉....'),('0b984a7e-fc0d-4bd0-90a6-b03a93213909','澶х數瑙嗕粠c浠庝粠',123,'鎵嬫満','http://image.jt.com//upload\\d\\1\\5\\2\\9\\e\\b\\f/1539450159413600.jpg',123,''),('103e5414-0da2-4fba-b92f-0ba876e08939','婊戦洩濂楄',2000,'鏃ョ敤鐧捐揣','http://image.jt.com/upload/4/d/2/a/2/3/1/8/b3c3fc7a-222c-49be-9491-f466553d2284_386718.jpg',224,'婊戦洩蹇呭濂楄浆, 浣? 鍊煎緱浣犳嫢鏈墌~~'),('1114f043-e36a-4333-ae5e-5e610eabca12','闃插垎鎵嬬鍣細澶х爾澶?',0,'鏃ョ敤鐧捐揣','http://image.jt.com/upload/6/b/8/3/a/4/9/8/3fb77001-cd6c-4e4f-94a1-21a9c0563778_Hydrangeas.jpg',2345,'浣犲啀璇翠竴涓垎鎵嬭瘯璇曘€傘€傘€傘€?),('17c3f20e-ef86-4857-9293-f29e52954a95','鎵撳嵃鏈?,180,'鐢靛瓙鏁扮爜','http://image.jt.com/upload/7/c/b/f/7/d/2/9/5e229aef-063f-4d0d-91df-2d4aa7167670_6f84843a-1d1e-49c7-b4ce-c035d7790171.jpg',1508,'涓€涓濂囩殑鎵撳嵃鏈?..,鍙互鎵撳嵃浜烘皯甯? 浣犳暍鐢ㄥ悧??'),('21bba7e8-21b8-46aa-932f-958b1a36e118','鐑堟€х偢鑽?',5899,'鐢靛瓙鏁扮爜','http://image.jt.com/upload/c/7/4/1/4/2/3/2/a99e691b-88d4-43a2-ac12-82ec54db123d_738f47e2-9605-46aa-b647-fc8dca814074.jpg',435,'鍏呯數浼氳嚜鍔ㄥ紩鐖? 鍐嶄篃涓嶇敤鎷呭績鑷潃shi涓嶄簡浜?),('26128d47-423b-4220-8047-544ff899db50','MacBook Air 13.3鑻卞绗旇鏈?,12,'鐢靛瓙鏁扮爜','http://image.jt.com/upload/2/1/0/3/f/0/3/5/2fb0b43b-4dbe-440b-899b-13c02a9f5475_22d124c9-df52-4cd4-88b3-691005f1cafe.jpg',1233,'涓夊潙绗旇鏈? 浠庢浜瀻浣犵殑鐪?...'),('2ad0d041-8c5f-4b70-a0ef-1ca2fd476dba','鎴樼涓绘満',5888,'鐢靛瓙鏁扮爜','http://image.jt.com/upload/b/4/1/b/d/9/8/8/e41cd642-2fc2-4cb2-b20a-f8a78405eee2_e9dd0d91-40c1-4db5-a888-244e825e9ce4.jpg',78,'涓绘満涓殑鎴樻枟鏈? 娆ц€秪~~~'),('2fb06be4-d3aa-451f-807e-cb8940ca3ba2','闃叉ゼ涓婂櫔闊?000W闇囧姩鍙嶅嚮绁炲櫒1',88,'鏃ョ敤鐧捐揣','http://image.jt.com/upload/6/5/a/4/2/9/e/8/cb68faa0-0033-4517-bff0-5fb2f1f1019a_671434fae6cd7b89a26ce25e072442a7d8330efa.jpg',532,'鏅氫笂寮€鍚竴鍒嗛挓, 妤间笂瀹夐潤10灏忔椂, 鍐嶄篃涓嶆€曟ゼ涓婂埗閫犲櫔闊充簡....'),('343bb952-1505-49ba-9920-47f69108152a','鐖辩溂婊よ摑鍏塋ED鑳屽厜娑叉櫠鏄剧ず鍣?',20000,'瀹剁敤鐢靛櫒','http://image.jt.com/upload/1/8/e/9/b/2/7/2/95e01470-8e6f-40dc-a76b-087d804bb0cf_bae0a60a-521d-48ef-bea6-0854b89d7be0.jpg',424,'鏋佽嚧褰遍櫌浣撻獙, 浠庤繖閲屽紑濮媬~~'),('3643034b-47c6-4298-913a-3cdc1fd176ca','婊戦洩濂楄1',2000,'鏃ョ敤鐧捐揣','http://image.jt.com/upload/4/d/2/a/2/3/1/8/b3c3fc7a-222c-49be-9491-f466553d2284_386718.jpg',224,'婊戦洩蹇呭濂楄浆, 浣? 鍊煎緱浣犳嫢鏈墌~~'),('36b9407f-746a-4956-988e-557122bc74d0','banana',11,'鏃ョ敤鐧捐揣','http://image.jt.com/upload/e/5/0/9/c/7/6/0/60746822-144c-4e98-8aaa-fca07e142a63_banana.jpg',453,'鍥戒骇澶anana,濂藉悆鍙堝ソ鐢?),('38a4a0f0-7c33-4e78-aa9e-1a3f7f193683','缁胯壊鍋ュ悍澶ч粍鐡?,1000,'鐢靛瓙鏁扮爜','http://image.jt.com/upload/8/6/b/0/5/9/e/f/1d25320d-e1b2-42bc-b890-981d58391cf0_6f84843a-1d1e-49c7-b4ce-c035d7790171.jpg',4865,'涔颁簡鎴戠殑鐡? 蹇樹簡閭ｄ釜浠?瀹?濂?..'),('3da04a08-a570-4945-91b5-cd0d63ace7b4','鏈哄櫒浜?,10000,'鐢靛瓙鏁扮爜','http://image.jt.com/upload/9/f/f/a/1/6/d/0/49617712-4018-4c0e-9e7a-5ebc4ff79ad1_6f84843a-1d1e-49c7-b4ce-c035d7790171.jpg',654,'涓€娆惧彲浠ユ墦鍗板コ鏈嬪弸鐨勬墦鍗版満...绋嬪簭鍛樺繀澶?!!'),('3f36ac54-5da0-4cd8-9991-2ee86cc348c2','閲戝＋椤?G鍐呭瓨鏉?,800,'鐢靛瓙鏁扮爜','http://image.jt.com/upload/2/2/b/7/f/2/f/4/06402c91-aa25-45d5-b0c3-3ac276a7cd05_244c59c6-bf0a-451b-81e6-18f8bb257e5f.jpg',8447,'8G鍐呭瓨鏉★紝閫熷害鎷胯揣, 鏁伴噺鏈夐檺(璧?G绉嶅瓙, 浣犳噦鐨?...)锛?),('49d57c16-758b-425a-ba96-9da03b86408d','鎵撳嵃鏈?',180,'鐢靛瓙鏁扮爜','http://image.jt.com/upload/7/c/b/f/7/d/2/9/5e229aef-063f-4d0d-91df-2d4aa7167670_6f84843a-1d1e-49c7-b4ce-c035d7790171.jpg',1508,'涓€涓濂囩殑鎵撳嵃鏈?..,鍙互鎵撳嵃浜烘皯甯? 浣犳暍鐢ㄥ悧??'),('500553f6-3157-4a41-8b8f-38437b5840b7','sadfa',12312,'鎵嬫満','http://image.jt.com//upload/8/c/6/c/3/5/f/1/1540782619025800.jpg',12321,''),('515b9c6c-60ea-4527-8887-92f5b9458ef8','鎴戜滑閮芥湁涓€涓す',123123,'鎵嬫満','',123213,'asdfasdfads'),('517b4ef7-ecfa-406b-9355-7ce04f86781a','姝讳骸娴蜂綋楠屽椁?',4444,'鏃ョ敤鐧捐揣','http://image.jt.com/upload/c/8/1/0/4/6/3/b/28139e28-7390-45a7-82c8-03e673486e60_Desert.jpg',624,'浣撻獙姝讳骸鐨勬劅瑙夛紝浣犲€煎緱鎷ユ湁!'),('55e7f79f-883c-4adb-b92b-83765afec0bc','123',123,'12312','http://image.jt.com//upload\\9\\e\\f\\2\\7\\2\\0\\e/1539450825764591.jpg',123,'12321閫熷害鍙戦€佸垎鏁ｅ埌'),('59622587-958e-43cb-b657-49619f60713e','闃叉ゼ涓婂櫔闊?000W闇囧姩鍙嶅嚮绁炲櫒',88,'鏃ョ敤鐧捐揣','http://image.jt.com/upload/6/5/a/4/2/9/e/8/cb68faa0-0033-4517-bff0-5fb2f1f1019a_671434fae6cd7b89a26ce25e072442a7d8330efa.jpg',532,'鏅氫笂寮€鍚竴鍒嗛挓, 妤间笂瀹夐潤10灏忔椂, 鍐嶄篃涓嶆€曟ゼ涓婂埗閫犲櫔闊充簡....'),('5a47d790-bc44-472b-8b9f-55b15a0cfb2c','neutrogena闃叉檼涔?',100,'鐢靛瓙鏁扮爜','http://image.jt.com/upload/5/0/6/f/4/4/b/f/40ca42aa-8298-430a-9fa9-88d6156d7b18_c987f2c1-4123-4d87-83bd-fe2fb221e272.jpg',1349,'甯︿綘鍙樻垚鐧藉瘜缇? 璧颁笂浜虹敓鐧柉~~~'),('5b7a84fb-b888-4c5d-8ace-6877d909fe89','鑻?null1',998,'搴婁笂鐢ㄥ搧','http://image.jt.com/upload/e/d/b/1/f/0/6/7/bcff4ee1-cc7f-4b30-a29c-017f76a21bf8_1.jpg',874,'鑻嶈€佸笀鍚屾'),('65cf809a-1eaf-4ba0-95b7-b13476e82c07','瀹犵墿鐚?',30000,'鏃ョ敤鐧捐揣','http://image.jt.com/upload/3/5/5/4/c/3/a/b/943de853-0e1b-4d51-9524-991607024d3b_IMG_0928.JPG',245,'鍙湁涓€鍙摝锛屽揩鏉ユ姠璐惂'),('6746c459-b284-4256-bbc6-1df60ba4a0a2','鍚庢倲鑽?,200,'鏃ョ敤鐧捐揣','http://image.jt.com/upload/2/6/4/a/a/5/2/3/ee6c796a-6333-4cd5-a06e-271d876aac8c_589577.jpg',4765,'閮借涓栦笂娌℃湁鍚庢倲鑽?鍘熸湰鎴戜篃娣变俊涓嶇枒'),('6c28bc1a-9c9b-4be3-b1cf-0068565e64e4','鍏斿瓙',59,'瀹剁敤鐢靛櫒','http://image.jt.com/upload/1/f/b/5/3/4/e/4/61a8cdff-52f7-4fce-bdb5-570426022082_preview.jpg',52,'鎴戜滑鐨勫緛閫旀槸鏄熻景澶ф捣!'),('70ee3179-3e76-4a3d-bd30-55d740f022dc','鏋佸搧姘存瘝',998,'鏃ョ敤鐧捐揣','http://image.jt.com/upload/e/6/f/d/3/f/6/1/d2370fcb-dc8f-4405-9bf2-76e798a91567_Jellyfish.jpg',243,'灞呭鏃呰锛屽繀澶囦箣閫?!!!'),('71e869ae-2d0c-4f3e-bb7f-6f6630f02cf7','MacBook Air 13.3鑻卞绗旇鏈?',12,'鐢靛瓙鏁扮爜','http://image.jt.com/upload/2/1/0/3/f/0/3/5/2fb0b43b-4dbe-440b-899b-13c02a9f5475_22d124c9-df52-4cd4-88b3-691005f1cafe.jpg',1233,'涓夊潙绗旇鏈? 浠庢浜瀻浣犵殑鐪?...'),('77a32d18-5596-4579-a700-ac1e76aa321e','鏋佸搧姘存瘝1',998,'鏃ョ敤鐧捐揣','http://image.jt.com/upload/e/6/f/d/3/f/6/1/d2370fcb-dc8f-4405-9bf2-76e798a91567_Jellyfish.jpg',243,'灞呭鏃呰锛屽繀澶囦箣閫?!!!'),('77feb539-a575-487b-8500-df38520f3239','鎴樺湴1 璞崕鐗?Origin骞冲彴姝ｇ増婵€娲荤爜',780,'鍥句功鏉傚織','http://image.jt.com/upload/5/e/e/6/c/4/9/b/67c1a752-9020-4372-bcda-3375ef01c878_preview.jpg',103,'鎯冲姙娉曞共浠栦竴鐐?...'),('7ab311f2-30b9-41ab-82a8-3524dbd012d0','娴锋哗鍒1',900,'鐢靛瓙鏁扮爜','http://image.jt.com/upload/5/e/d/5/4/5/e/b/5f0d34dc-157f-49ba-ad39-1b28927ba6ae_1005714.jpg',212,'闈㈡湞澶ф捣, 渚ч潰鏈夊北, 瀹変韩鏅氬勾涔嬮閫?!!'),('83ffa948-998e-4058-bdad-16dadae90fc0','缁胯壊鍋ュ悍澶ч粍鐡?',1000,'鐢靛瓙鏁扮爜','http://image.jt.com/upload/8/6/b/0/5/9/e/f/1d25320d-e1b2-42bc-b890-981d58391cf0_6f84843a-1d1e-49c7-b4ce-c035d7790171.jpg',4865,'www.jt.com/涔颁簡鎴戠殑鐡? 蹇樹簡閭ｄ釜浠?瀹?濂?..'),('885a2417-ca4d-4fc7-ac6c-1f9bda76c5da','鍙嶆亹绮捐嫳濂楄1',10000,'鏈嶈鏈嶉グ','http://image.jt.com/upload/1/4/2/e/7/3/6/4/09af74da-3829-45c5-9517-380d2cc74f6a_preview.jpg',644,'涓撲笟鍙嶆亹鏈嶈锛屽甫浣犺x甯︿綘椋?..biu~biu~biu~~'),('8b80bc62-f22a-4d69-a0c0-41b2ea2846ce','閲戝＋椤?G鍐呭瓨鏉?',800,'鐢靛瓙鏁扮爜','http://image.jt.com/upload/2/2/b/7/f/2/f/4/06402c91-aa25-45d5-b0c3-3ac276a7cd05_244c59c6-bf0a-451b-81e6-18f8bb257e5f.jpg',8447,'8G鍐呭瓨鏉★紝閫熷害鎷胯揣, 鏁伴噺鏈夐檺(璧?G绉嶅瓙, 浣犳噦鐨?...)锛?),('8c0023f1-2a49-48a7-9810-a52ba4cd00d1','涓夊潙鎵嬫満1',5000,'鐢靛瓙鏁扮爜','http://image.jt.com/upload/3/6/c/0/7/2/1/3/741c8c70-cdd1-43a9-8cde-aa6a787129ca_738f47e2-9605-46aa-b647-fc8dca814074.jpg',524,'涓夊潙鎵嬫満, 涓撲笟鍧戜汉涓夊崄骞? 浠庢湭琚秴瓒?..!!!'),('8ed715e9-f506-4792-9f9f-f4b81aa87f36','鍗庝负鑽ｈ€€81',5000,'鐢靛瓙鏁扮爜','http://image.jt.com/upload/4/a/d/8/8/c/4/0/236ac480-db3a-4e6b-bc7f-c379a30c2c2c_301fb535-938a-4103-a2f5-f3f9af9ba9c6.jpg',2545,'鏀寔鍥戒骇, 浠庝綘鎴戝仛璧?!!'),('97122945-9308-42a9-a602-071b755d2ec3','鎴樺湴1 璞崕鐗?Origin骞冲彴姝ｇ増婵€娲荤爜1',780,'鍥句功鏉傚織','http://image.jt.com/upload/5/e/e/6/c/4/9/b/67c1a752-9020-4372-bcda-3375ef01c878_preview.jpg',103,'鎯冲姙娉曞共浠栦竴鐐?...'),('a0390f80-bed7-4a92-9954-5e22e64cbe17','neutrogena闃叉檼涔?,100,'鐢靛瓙鏁扮爜','http://image.jt.com/upload/5/0/6/f/4/4/b/f/40ca42aa-8298-430a-9fa9-88d6156d7b18_c987f2c1-4123-4d87-83bd-fe2fb221e272.jpg',1349,'甯︿綘鍙樻垚鐧藉瘜缇? 璧颁笂浜虹敓鐧柉~~~'),('a08b13e9-c16a-4657-94ee-3b9bee2bd9c6','鎴戝幓浣犲ぇ鐖?,5000,'鐢靛瓙鏁扮爜','http://image.jt.com/upload/4/a/d/8/8/c/4/0/236ac480-db3a-4e6b-bc7f-c379a30c2c2c_301fb535-938a-4103-a2f5-f3f9af9ba9c6.jpg',2545,'鏀寔鍥戒骇, 浠庝綘鎴戝仛璧?!!'),('a515807d-507e-4567-95b9-907b892efe09','iPhone7Plus 3200G 榛戣壊鎵嬫満1',1000,'鐢靛瓙鏁扮爜','http://image.jt.com/upload/5/2/3/4/7/8/d/c/1838eaa6-6459-420f-b8e2-6ea9f43c4b5e_dfd259ab-bcc7-43f6-a9d5-62872ff5671e.jpg',2550,'鐖变笂鐖辩柉, 浣犵柉...鎴戠柉...澶у涓€璧风柉....'),('a7184417-5aa2-4de0-8237-a4c0f53972a1','涓夊潙鎵嬫満',5000,'鐢靛瓙鏁扮爜','http://image.jt.com/upload/3/6/c/0/7/2/1/3/741c8c70-cdd1-43a9-8cde-aa6a787129ca_738f47e2-9605-46aa-b647-fc8dca814074.jpg',524,'涓夊潙鎵嬫満, 涓撲笟鍧戜汉涓夊崄骞? 浠庢湭琚秴瓒?..!!!'),('b1f9c947-4f72-4245-b09d-8c5a8c311ae1','鍦颁腑娴?鏃ユ父',5000,'鏃ョ敤鐧捐揣','http://image.jt.com/upload/6/5/5/c/5/4/1/9/d437c381-59af-49ee-80c6-2b01e0b06105_1017530.jpg',2345,'鏀炬澗韬績锛屽鎵捐壋閬?),('bef7494b-06a8-42f8-8659-17f2c2c5c2df','鍏斿瓙1',59,'瀹剁敤鐢靛櫒','http://image.jt.com/upload/1/f/b/5/3/4/e/4/61a8cdff-52f7-4fce-bdb5-570426022082_preview.jpg',52,'鎴戜滑鐨勫緛閫旀槸鏄熻景澶ф捣!'),('bf45940e-ac72-454f-b67f-83dd288d11f9','鍙嶆亹绮捐嫳濂楄',10000,'鏈嶈鏈嶉グ','http://image.jt.com/upload/1/4/2/e/7/3/6/4/09af74da-3829-45c5-9517-380d2cc74f6a_preview.jpg',644,'涓撲笟鍙嶆亹鏈嶈锛屽甫浣犺x甯︿綘椋?..biu~biu~biu~~'),('c0e7b4f3-e1ad-47d6-8c0d-f1c58b820ca8','鐏甸瓊鍑轰綋鍑虹獚鏈?,1000,'鐢靛瓙鏁扮爜','http://image.jt.com/upload/c/4/b/7/b/5/8/f/5adda796-66af-4c6e-a9e5-49a52a3c44a5_371cee6d-d81b-42b7-a11f-3ad36dc0e537.jpg',42,'30澶╁浼氱伒榄傚嚭绐嶆湳, 濡傛灉瀛︿笉浼? 璇风櫥褰曟垜浠殑缃戠珯, 涓夋墦婧滅偣涓嶅潙浣犲潙璋佺偣鍗″'),('c2952779-e9e0-4eda-8e0a-41a61f1afc66','鑻?null',998,'搴婁笂鐢ㄥ搧','http://image.jt.com/upload/e/d/b/1/f/0/6/7/bcff4ee1-cc7f-4b30-a29c-017f76a21bf8_1.jpg',874,'鑻嶈€佸笀鍚屾'),('c2978733-5af8-473b-adbc-05073126164b','瀹犵墿鐚?,30000,'鏃ョ敤鐧捐揣','http://image.jt.com/upload/3/5/5/4/c/3/a/b/943de853-0e1b-4d51-9524-991607024d3b_IMG_0928.JPG',245,'鍙湁涓€鍙摝锛屽揩鏉ユ姠璐惂'),('c766ec19-4645-4e6b-9ddf-73a0f4aa5f6c','鑴戞畫鐗?,999,'鏃ョ敤鐧捐揣','http://image.jt.com/upload/f/e/f/8/2/e/3/c/82c1698f-38a2-4340-9df7-83fadaefff4b_howardmouth.jpg',562,'鑴戞畫璁よ瘑鐨勭闊? 鑴戞畫鐗囬浄浜轰笂甯? 浣?..闇€瑕佸悧?'),('cd116f32-74ff-47c5-8195-8d077cdcca25','鏈哄櫒浜?',10000,'鐢靛瓙鏁扮爜','http://image.jt.com/upload/9/f/f/a/1/6/d/0/49617712-4018-4c0e-9e7a-5ebc4ff79ad1_6f84843a-1d1e-49c7-b4ce-c035d7790171.jpg',654,'涓€娆惧彲浠ユ墦鍗板コ鏈嬪弸鐨勬墦鍗版満...绋嬪簭鍛樺繀澶?!!'),('d283359c-3e43-4655-bde4-4f834ec288df','banana111',11,'鏃ョ敤鐧捐揣','http://image.jt.com/upload/e/5/0/9/c/7/6/0/60746822-144c-4e98-8aaa-fca07e142a63_banana.jpg',453,'鍥戒骇澶anana,濂藉悆鍙堝ソ鐢?),('d73ab7ed-9f78-4775-a93b-4d355b2d5fc0','姝讳骸娴蜂綋楠屽椁?,4444,'鏃ョ敤鐧捐揣','http://image.jt.com/upload/c/8/1/0/4/6/3/b/28139e28-7390-45a7-82c8-03e673486e60_Desert.jpg',624,'浣撻獙姝讳骸鐨勬劅瑙夛紝浣犲€煎緱鎷ユ湁!'),('d7f7cce4-b268-41a7-9429-21fa69b64159','鐖辩溂婊よ摑鍏塋ED鑳屽厜娑叉櫠鏄剧ず鍣?,20000,'瀹剁敤鐢靛櫒','http://image.jt.com/upload/1/8/e/9/b/2/7/2/95e01470-8e6f-40dc-a76b-087d804bb0cf_bae0a60a-521d-48ef-bea6-0854b89d7be0.jpg',424,'鏋佽嚧褰遍櫌浣撻獙, 浠庤繖閲屽紑濮媬~~'),('d8cb845e-37f6-4515-9fc1-dea07719ee06','闃插垎鎵嬬鍣細澶х爾澶?,0,'鏃ョ敤鐧捐揣','http://image.jt.com/upload/6/b/8/3/a/4/9/8/3fb77001-cd6c-4e4f-94a1-21a9c0563778_Hydrangeas.jpg',2345,'www.jt.com/浣犲啀璇翠竴涓垎鎵嬭瘯璇曘€傘€傘€傘€?),('dad80f9d-4878-4f79-b2fb-f55d7c60bb9d','鐏甸瓊鍑轰綋鍑虹獚鏈?',1000,'鐢靛瓙鏁扮爜','http://image.jt.com/upload/c/4/b/7/b/5/8/f/5adda796-66af-4c6e-a9e5-49a52a3c44a5_371cee6d-d81b-42b7-a11f-3ad36dc0e537.jpg',42,'www.jt.com/30澶╁浼氱伒榄傚嚭绐嶆湳, 濡傛灉瀛︿笉浼? 璇风櫥褰曟垜浠殑缃戠珯, 涓夋墦婧滅偣涓嶅潙浣犲潙璋佺偣鍗″'),('dbbe7d98-a5a2-4971-9493-cddecd3a2b55','鑴戞畫鐗?',999,'鏃ョ敤鐧捐揣','http://image.jt.com/upload/f/e/f/8/2/e/3/c/82c1698f-38a2-4340-9df7-83fadaefff4b_howardmouth.jpg',562,'www.jt.com/鑴戞畫璁よ瘑鐨勭闊? 鑴戞畫鐗囬浄浜轰笂甯? 浣?..闇€瑕佸悧?'),('dd135a52-3361-4a4f-ad68-79e5826152ab','鍦颁腑娴?鏃ユ父1',5000,'鏃ョ敤鐧捐揣','http://image.jt.com/upload/6/5/5/c/5/4/1/9/d437c381-59af-49ee-80c6-2b01e0b06105_1017530.jpg',2345,'www.jt.com/鏀炬澗韬績锛屽鎵捐壋閬?),('f8433d6d-4964-4ddc-a1d8-e50f6ccdf1d7','鎴樼涓绘満1',5888,'鐢靛瓙鏁扮爜','http://image.jt.com/upload/b/4/1/b/d/9/8/8/e41cd642-2fc2-4cb2-b20a-f8a78405eee2_e9dd0d91-40c1-4db5-a888-244e825e9ce4.jpg',78,'www.jt.com/涓绘満涓殑鎴樻枟鏈? 娆ц€秪~~~'),('f88539b5-c08a-45b2-a493-54b906439f7e','dsfdsafds',123,'鎵嬫満','http://image.jt.com//upload\\3\\a\\5\\4\\4\\2\\4\\7/1539450628968292.jpg',123,''),('ff838641-feb5-42a1-b061-042b9113a95c','鐑堟€х偢鑽?,5899,'鐢靛瓙鏁扮爜','http://image.jt.com/upload/c/7/4/1/4/2/3/2/a99e691b-88d4-43a2-ac12-82ec54db123d_738f47e2-9605-46aa-b647-fc8dca814074.jpg',435,'www.jt.com/鍏呯數浼氳嚜鍔ㄥ紩鐖? 鍐嶄篃涓嶇敤鎷呭績鑷潃shi涓嶄簡浜?);

/*Table structure for table `t_user` */

DROP TABLE IF EXISTS `t_user`;

CREATE TABLE `t_user` (
  `user_id` char(36) NOT NULL COMMENT '鐢ㄦ埛id uuid 涓婚敭',
  `user_name` varchar(20) NOT NULL COMMENT '鐢ㄦ埛鐧婚檰鍚嶇О',
  `user_password` varchar(32) NOT NULL COMMENT '鐢ㄦ埛瀵嗙爜 md5',
  `user_nickname` varchar(50) DEFAULT '涓婂笣' COMMENT '鐢ㄦ埛鏄电О',
  `user_email` varchar(30) DEFAULT NULL COMMENT '鐢ㄦ埛閭',
  `user_type` int(11) DEFAULT '0' COMMENT '鐢ㄦ埛鐘舵€?0(鏅€氱敤鎴?,1(绠＄悊鍛?,2(瓒呯骇绠＄悊鍛?',
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `UN_user_name` (`user_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `t_user` */

insert  into `t_user`(`user_id`,`user_name`,`user_password`,`user_nickname`,`user_email`,`user_type`) values ('10bf2a84-4bf6-40b1-8c85-e625bdb1e938','ee','e10adc3949ba59abbe56e057f20f883e','鐭ヨ5','wt_zss@126.com',0),('1e6397f7-09ff-4eb9-8162-63af7940c6b5','admin2','202cb962ac59075b964b07152d234b70','绠＄悊鍛?','wt_zss@126.com',1),('209a8250-a91b-4c1e-8abd-82f49423d57d','123213','202cb962ac59075b964b07152d234b70','123','254567038@qq.com',0),('3ad1188d-1f98-4b92-aa34-c4d58105485f','ff','202cb962ac59075b964b07152d234b70','鐭ヨ6','wt_zss@126.com',0),('46238b68-6bef-491b-b5af-a3e0f45d1462','dd','202cb962ac59075b964b07152d234b70','鐭ヨ4','wt_zss@126.com',0),('6199a734-b872-4f41-a0a3-83781f098d9a','asdfadsf','123','123','254567038@qq.com',0),('6f489e6c-1292-41dc-83fd-57ccae4042df','admin1','202cb962ac59075b964b07152d234b70','绠＄悊鍛?','wt_zss@126.com',1),('7008ffa6-e01d-48ed-a460-dbf2a4908bfa','aa','202cb962ac59075b964b07152d234b70','鐭ヨ1','wt_zss@126.com',0),('73338d3e-04b8-4719-8d10-6cdb599d435e','sdafas','123','123','254567038@qq.com',0),('983513c5-4460-44ca-afc7-7eabd6f7b35b','jj','202cb962ac59075b964b07152d234b70','鐭ヨ10','wt_zss@126.com',0),('a28e34eb-ec9d-43cd-a297-42abb14afcf9','admin','202cb962ac59075b964b07152d234b70','瓒呯骇绠＄悊鍛?,'wt_zss@126.com',2),('ad0e7678-39a4-46d5-9946-f3dd5100bc62','hh','202cb962ac59075b964b07152d234b70','鐭ヨ8','wt_zss@126.com',0),('c2fcfe86-6db7-46b2-bbbd-43690c7017b3','cc','202cb962ac59075b964b07152d234b70','鐭ヨ3','wt_zss@126.com',0),('c36af784-d33f-48f7-bcb4-737ec6fd4052','gg','202cb962ac59075b964b07152d234b70','鐭ヨ7','wt_zss@126.com',0),('da240514-b46f-437a-a9fe-f0a2c0ea16cc','asdfdsa','123','123','254567038@qq.com',0),('df05c14c-679e-414d-b10a-958a48793382','asd','e10adc3949ba59abbe56e057f20f883e','123','254567038@qq.com',0),('ecaf1f41-bc7b-4d2d-a237-3731caa11d86','eeee','e10adc3949ba59abbe56e057f20f883e','sad','23432@qq.com',0),('ecf1311d-de45-4851-a20f-4e6cf55073f0','bb','202cb962ac59075b964b07152d234b70','鐭ヨ2','wt_zss@126.com',0),('f2ca3738-de69-4762-a9f0-7cb477e9ce21','ii','202cb962ac59075b964b07152d234b70','鐭ヨ9','wt_zss@126.com',0);

/*!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 */;

萌新Java程序猿

关注

2
点赞
踩
5

收藏

觉得还不错? 一键收藏
2
评论
复制链接

分享到 QQ

分享到新浪微博

扫一扫

专栏目录

评论 2

被折叠的条评论为什么被折叠?

到【灌水乐园】发言

查看更多评论

添加红包

成就一亿技术人!

hope_wisdom

发出的红包

实付元

使用余额支付

点击重新获取

扫码支付

钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。