完整的Java微信小程序商城源码包含前后端

/* Navicat Premium Data Transfer Source Server : localhost_3307 Source Server Type : MySQL Source Server Version : 50642 Source Host : localhost:3307 Source Schema : wxmall Target Server Type : MySQL Target Server Version : 50642 File Encoding : 65001 Date: 14/05/2019 19:39:28 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for wx_access_log -- ---------------------------- DROP TABLE IF EXISTS `wx_access_log`; CREATE TABLE `wx_access_log` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id', `user_id` bigint(20) DEFAULT NULL COMMENT '用户ID', `user_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '用户名', `operate_type` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '操作类型', `operate_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '操作名称', `operate_method` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '请求方法名', `url` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '请求URL', `req_param` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '请求参数', `res_result` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '响应结果', `execute_time` bigint(20) DEFAULT NULL COMMENT '执行时长', `ip` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '访问IP', `create_by` bigint(20) DEFAULT NULL COMMENT '创建人ID', `create_time` datetime(0) DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_by` bigint(20) DEFAULT NULL COMMENT '修改人ID', `update_time` datetime(0) DEFAULT NULL COMMENT '修改时间', `enable` tinyint(1) DEFAULT 1 COMMENT '删除标识：0为已删除，1为未删除', `remark` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '备注', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '访问日志' ROW_FORMAT = Compact; -- ---------------------------- -- Records of wx_access_log -- ---------------------------- INSERT INTO `wx_access_log` VALUES (1, 1, 'admin', '4', '查询个人登录信息', 'com.yun.smart.controller.UserInfoControllergetBaseInfo', '/smart/userInfo/pc/v1/getBaseInfo', '{\"token\":\"b5f6cd4bc56342beb6d80dda339e85f4\"}', '{\"code\":\"0000\",\"msg\":\"成功完成操作。\",\"data\":{\"userRole\":\"超级管理员\",\"userName\":\"admin\",\"userMsg\":0}}', 314, '127.0.0.1', 1, '2019-05-14 18:58:44', 1, '2019-05-14 18:58:44', 1, NULL); INSERT INTO `wx_access_log` VALUES (2, 1, 'admin', '4', '查询个人登录信息', 'com.yun.smart.controller.UserInfoControllergetBaseInfo', '/smart/userInfo/pc/v1/getBaseInfo', '{\"token\":\"4d854f83939244ec96abc57a0feca922\"}', '{\"code\":\"0000\",\"msg\":\"成功完成操作。\",\"data\":{\"userRole\":\"超级管理员\",\"userName\":\"admin\",\"userMsg\":0}}', 67, '127.0.0.1', 1, '2019-05-14 19:26:34', 1, '2019-05-14 19:26:34', 1, NULL); INSERT INTO `wx_access_log` VALUES (3, 1, 'admin', '4', '查询个人登录信息', 'com.yun.smart.controller.UserInfoControllergetBaseInfo', '/smart/userInfo/pc/v1/getBaseInfo', '{\"token\":\"7860f55e1e53489787db227ab99ac6d4\"}', '{\"code\":\"0000\",\"msg\":\"成功完成操作。\",\"data\":{\"userRole\":\"超级管理员\",\"userName\":\"admin\",\"userMsg\":0}}', 52, '127.0.0.1', 1, '2019-05-14 19:27:55', 1, '2019-05-14 19:27:55', 1, NULL); INSERT INTO `wx_access_log` VALUES (4, 1, 'admin', '4', '查询个人登录信息', 'com.yun.smart.controller.UserInfoControllergetBaseInfo', '/smart/userInfo/pc/v1/getBaseInfo', '{\"token\":\"3f21b854a63f4917b0c58c11a3813af0\"}', '{\"code\":\"0000\",\"msg\":\"成功完成操作。\",\"data\":{\"userRole\":\"超级管理员\",\"userName\":\"admin\",\"userMsg\":0}}', 35, '127.0.0.1', 1, '2019-05-14 19:31:00', 1, '2019-05-14 19:31:00', 1, NULL); INSERT INTO `wx_access_log` VALUES (5, 1, 'admin', '4', '查询个人登录信息', 'com.yun.smart.controller.UserInfoControllergetBaseInfo', '/smart/userInfo/pc/v1/getBaseInfo', '{\"token\":\"ad58c0ee1f4f4fb2881ed4b28f0e723d\"}', '{\"code\":\"0000\",\"msg\":\"成功完成操作。\",\"data\":{\"userRole\":\"超级管理员\",\"userName\":\"admin\",\"userMsg\":0}}', 23, '127.0.0.1', 1, '2019-05-14 19:31:07', 1, '2019-05-14 19:31:07', 1, NULL); -- ---------------------------- -- Table structure for wx_address_list -- ---------------------------- DROP TABLE IF EXISTS `wx_address_list`; CREATE TABLE `wx_address_list` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id', `user_id` bigint(20) DEFAULT NULL COMMENT '用户ID', `link_man` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '联系人', `link_phone` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '联系电话', `link_addr` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '联系地址', `default_addr` tinyint(1) DEFAULT 0 COMMENT '默认地址：0=非默认，1=默认', `create_by` bigint(20) DEFAULT NULL COMMENT '创建人ID', `create_time` datetime(0) DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_by` bigint(20) DEFAULT NULL COMMENT '修改人ID', `update_time` datetime(0) DEFAULT NULL COMMENT '修改时间', `enable` tinyint(1) DEFAULT 1 COMMENT '删除标识：0为已删除，1为未删除', `remark` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '备注', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '地址' ROW_FORMAT = Compact; -- ---------------------------- -- Records of wx_address_list -- ---------------------------- INSERT INTO `wx_address_list` VALUES (1, 2, '张三', '13812348899', '广东省广州市天河区白云大道南112号', 1, 2, '2019-05-14 13:59:35', 2, '2019-05-14 13:59:35', 1, NULL); INSERT INTO `wx_address_list` VALUES (2, 1, '最代码', '13520109202', 'zuidaima.com', 1, 1, '2019-05-14 19:37:31', 1, '2019-05-14 19:37:31', 1, NULL); -- ---------------------------- -- Table structure for wx_dic_info -- ---------------------------- DROP TABLE IF EXISTS `wx_dic_info`; CREATE TABLE `wx_dic_info` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id', `parent_id` bigint(20) DEFAULT NULL COMMENT '父节点ID 默认0', `dic_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '字典名词', `dic_value` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '字典值', `dic_text` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '字典词', `create_by` bigint(20) DEFAULT NULL COMMENT '创建人ID', `create_time` datetime(0) DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_by` bigint(20) DEFAULT NULL COMMENT '修改人ID', `update_time` datetime(0) DEFAULT NULL COMMENT '修改时间', `enable` tinyint(1) DEFAULT 1 COMMENT '删除标识：0为已删除，1为未删除', `remark` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '备注', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 44 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '字典' ROW_FORMAT = Compact; -- ---------------------------- -- Records of wx_dic_info -- ---------------------------- INSERT INTO `wx_dic_info` VALUES (1, NULL, '', NULL, '用户类型', NULL, '2019-05-14 13:12:51', NULL, NULL, 1, NULL); INSERT INTO `wx_dic_info` VALUES (2, NULL, '', NULL, '图片类型', NULL, '2019-05-14 13:12:51', NULL, NULL, 1, NULL); INSERT INTO `wx_dic_info` VALUES (3, NULL, '', NULL, '反馈类型', NULL, '2019-05-14 13:12:51', NULL, NULL, 1, NULL); INSERT INTO `wx_