本文探讨了在移动互联网趋势下，如何利用微信小程序技术开发轻量级的手机交易商城，以提升用户体验。通过SpringBoot、MyBatis等技术构建后端，Vue和Element-ui实现前端操作，展示了微信小程序在满足小店商业需求和便利二次开发方面的优势。
基于微信的手机交易商城设计与开发
摘要：伴随着移动互联网的进一步发展趋势，传统式手机应用程序的问题慢慢出現在技术性关心的行业。原生态Android运用的安裝和卸载掉危害用户体验，一个轻量的内嵌式WEB程序流程为用户体验吸引住了愈来愈多开发人员的关心。自打微信小程序明确提出后，愈来愈多的互联网公司竞相开发设计单独的微信小程序运用，大有作为。
根据现阶段盛行的微信小程序应用程序开发技术性，融合手机买卖商城系统的用户需求，开发设计了一套易于器重、可配备、面对小店的手机买卖商城系统开发。系统软件根据现阶段流行的Java后端工程师框架SpringBoot、流行的数据库配备框架MyBatis和实用的MySQL数据库搭建后台管理网络服务器新项目，应用Vue网站前端开发框架和Element-ui插口原素完成小程序管理员的操作系统插口，依据微信小程序给予的设计方案文档制作原生态手机买卖商城小程序。微信小程序可以达到现阶段小店的商业要求，完成控制模块的信息配备，易于二次开发。有利于迅速构建成形系统软件，具备一定的社会经济实际效果。
关键词：手机交易商城，小程序，动态配置，SpringBoot，Vue
Design and Development of Online Mall Based on WeChat
Abstract: With the further development trend of mobile Internet, the problems of traditional mobile phone applications are slowly emerging in industries of technical concern. The installation and uninstallation of the original Android application endanger the user experience. A lightweight embedded web program process has attracted more and more developers' attention for the user experience. Since the wechat applet was clearly put forward, more and more Internet companies have competed to develop and design separate wechat applets, which have made great achievements。
According to the popular wechat applet application development technology at this stage, and integrating the user needs of the second-hand book trading mall system, a set of second-hand book trading mall system development which is easy to value, can be equipped and facing small stores is developed and designed. The system software builds a new project of background management network server according to the popular Java back-end engineer framework springboot, the popular database configuration framework mybatis and the practical MySQL database at the present stage, applies the Vue website front-end development framework and element UI socket elements to complete the operating system socket of the applet administrator, and makes the original ecological second-hand book shopping mall applet according to the design scheme documents given by the wechat applet. Wechat applet can meet the business requirements of small stores at this stage, complete the information configuration of control module, and is easy to secondary development. It is conducive to the rapid construction of forming system software, and has a certain social and economic practical effect。
Keywords: online mall, mini program, dynamic allocation, SpringBoot, Vue
/*
Navicat Premium Data Transfer
Source Server : localhost_3306
Source Server Type : MySQL
Source Server Version : 50625
Source Host : localhost:3306
Source Schema : shop_data
Target Server Type : MySQL
Target Server Version : 50625
File Encoding : 65001
Date: 27/05/2022 10:21:39
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for shop_class
-- ----------------------------
DROP TABLE IF EXISTS `shop_class`;
CREATE TABLE `shop_class` (
`class_id` int(4) NOT NULL AUTO_INCREMENT,
`class_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
PRIMARY KEY (`class_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 43 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of shop_class
-- ----------------------------
INSERT INTO `shop_class` VALUES (35, 'VIVO');
INSERT INTO `shop_class` VALUES (36, 'OPPO');
INSERT INTO `shop_class` VALUES (37, 'HUAWEI');
INSERT INTO `shop_class` VALUES (38, '苹果');
INSERT INTO `shop_class` VALUES (39, '三星');
INSERT INTO `shop_class` VALUES (40, '荣耀');
INSERT INTO `shop_class` VALUES (41, 'iQOO');
INSERT INTO `shop_class` VALUES (42, '小米');
-- ----------------------------
-- Table structure for shop_good
-- ----------------------------
DROP TABLE IF EXISTS `shop_good`;
CREATE TABLE `shop_good` (
`good_id` int(4) NOT NULL AUTO_INCREMENT,
`class_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`good_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`good_price` double(24, 2) NOT NULL,
`good_image` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`good_introduce` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`good_state` bit(1) NOT NULL,
`good_star` int(8) NULL DEFAULT NULL,
PRIMARY KEY (`good_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 49 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of shop_good
-- ----------------------------
INSERT INTO `shop_good` VALUES (40, 'HUAWEI', '华为P50 Pocket', 8988.00, 'http://localhost:8081/img/goodImage/1653616635094cea1MyCmAU3w.jpg', '基本参数 发布会时间 2021年12月23日 电商报价 ￥8688 上市日期 2021年12月23日 手机类型 4G手机>，3G手机>，智能手机>，平板手机>，拍照手机>，折叠屏手机> 机身材质 铝合金中框，玻璃后壳 查看外观图> 机身颜色 曜石黑，晶钻白 查看外观> 指纹识别 侧面指纹识别> 面部识别 支持', b'1', 0);
INSERT INTO `shop_good` VALUES (41, 'HUAWEI', '华为P50（全网通）', 4388.00, 'http://localhost:8081/img/goodImage/1653616674654ceCpk9GveTz9.jpg', '高通骁龙888处理器，90Hz OLED显示屏，IP68防尘防水，鸿蒙2.0系统', b'1', 0);
INSERT INTO `shop_good` VALUES (42, 'VIVO', 'vivo X Fold', 8999.00, 'http://localhost:8081/img/goodImage/1653616744106ceAiuhkWRDgGw.jpg', '2K+120Hz E5折叠巨幕，航天级浮翼式铰链，双屏幕指纹，旗舰骁龙8 Gen1', b'1', 0);
INSERT INTO `shop_good` VALUES (43, 'VIVO', 'vivo S15 Pro', 3399.00, 'http://localhost:8081/img/goodImage/1653616775861ceyulU4oJGSA.jpg', '天玑8100，独立显示芯片Pro，索尼定制大底主摄', b'1', 0);
INSERT INTO `shop_good` VALUES (44, 'OPPO', 'OPPO Reno8 Pro+', 3699.00, 'http://localhost:8081/img/goodImage/1653616826823ceFDJDFjhroo.jpg', '流云双镜设计，航空铝直边金属中框，双芯人像科技', b'1', 0);
INSERT INTO `shop_good` VALUES (45, '苹果', '苹果iPhone 13', 5999.00, 'http://localhost:8081/img/goodImage/1653616876955ceg7Gv0Z6T6M.jpg', '解锁超能力，超先进双摄系统，A15仿生芯片', b'1', 0);
INSERT INTO `shop_good` VALUES (46, '苹果', '苹果iPhone 13 Pro', 8799.00, 'http://localhost:8081/img/goodImage/1653616927560ceSpiIWcoym16.jpg', 'A15仿生芯片，超视网膜XDR显示屏，Pro级摄像头系统，ProMotion自适应刷新率技术', b'1', 0);
INSERT INTO `shop_good` VALUES (47, '三星', '三星Galaxy S22', 4999.00, 'http://localhost:8081/img/goodImage/1653616976717cekP3i26HPyBg.jpg', '超凡卓越影像系统，超亮顺滑全视屏，全新一代骁龙8移动平台', b'1', 0);
INSERT INTO `shop_good` VALUES (48, '三星', '三星Galaxy Z Fold3', 1280.00, 'http://localhost:8081/img/goodImage/1653617029980cebUZ8pyh4gcc.jpg', 'CPU：高通 骁龙888行业最高：全新一代骁龙8移动平台 后置：1200万像素主镜头+1200万像素超广角镜头+1200万像素2X变焦镜头高清级像素高于10.61%手机像素行业最高：10800万＞', b'1', 0);
-- ----------------------------
-- Table structure for shop_img
-- ----------------------------
DROP TABLE IF EXISTS `shop_img`;
CREATE TABLE `shop_img` (
`img_id` int(4) NOT NULL AUTO_INCREMENT,
`img_src` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`img_text` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
PRIMARY KEY (`img_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 29 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of shop_img
-- ----------------------------
INSERT INTO `shop_img` VALUES (28, 'http://imgs.bootstrapmb.com/2020/10/140947156.jpg', '免费换机何必东奔西走，微信商城全都有');
-- ----------------------------
-- Table structure for shop_mainmenu
-- ----------------------------
DROP TABLE IF EXISTS `shop_mainmenu`;
CREATE TABLE `shop_mainmenu` (
`mainmenu_id` int(50) NOT NULL,
`mainmenu_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`mainmenu_path` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
PRIMARY KEY (`mainmenu_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of shop_mainmenu
-- ----------------------------
INSERT INTO `shop_mainmenu` VALUES (100, '用户管理', '#');
INSERT INTO `shop_mainmenu` VALUES (200, '手机管理', '#');
INSERT INTO `shop_mainmenu` VALUES (300, '订单管理', '#');
INSERT INTO `shop_mainmenu` VALUES (400, '广告管理', '#');
INSERT INTO `shop_mainmenu` VALUES (600, '系统设置', '#');
-- ----------------------------
-- Table structure for shop_order
-- ----------------------------
DROP TABLE IF EXISTS `shop_order`;
CREATE TABLE `shop_order` (
`order_id` int(4) NOT NULL AUTO_INCREMENT,
`user_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`user_phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`order_address` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`order_text` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`order_value` double(24, 2) NOT NULL,
`order_state` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`self_phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
PRIMARY KEY (`order_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of shop_order
-- ----------------------------
-- ----------------------------
-- Table structure for shop_role
-- ----------------------------
DROP TABLE IF EXISTS `shop_role`;
CREATE TABLE `shop_role` (
`role_id` int(4) NOT NULL AUTO_INCREMENT,
`role_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`role_cost` double(10, 2) NULL DEFAULT NULL,
`role_value` double(10, 2) NULL DEFAULT NULL,
`role_days` int(6) NULL DEFAULT NULL,
PRIMARY KEY (`role_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of shop_role
-- ----------------------------
INSERT INTO `shop_role` VALUES (1, '管理员', 0.00, 111.00, 1111);
INSERT INTO `shop_role` VALUES (2, '超级会员', 0.50, 88.00, 88);
INSERT INTO `shop_role` VALUES (3, '普通会员', 0.80, 88.00, 111);
INSERT INTO `shop_role` VALUES (4, '普通用户', 1.00, 88.00, 88);
INSERT INTO `shop_role` VALUES (7, '跳楼价', 0.20, 66.00, 9999);
INSERT INTO `shop_role` VALUES (8, '3.15消费者权益日', 0.66, 88.00, 9888);
-- ----------------------------
-- Table structure for shop_submenu
-- ----------------------------
DROP TABLE IF EXISTS `shop_submenu`;
CREATE TABLE `shop_submenu` (
`submenu_id` int(50) NOT NULL,
`submenu_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`submenu_path` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`mainmenu_id` int(50) NOT NULL,
PRIMARY KEY (`submenu_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of shop_submenu
-- ----------------------------
INSERT INTO `shop_submenu` VALUES (101, '用户列表', '/userList', 100);
INSERT INTO `shop_submenu` VALUES (102, '权限管理', '/userRole', 100);
INSERT INTO `shop_submenu` VALUES (201, '手机列表', '/goodList', 200);
INSERT INTO `shop_submenu` VALUES (202, '分类管理', '/goodClass', 200);
INSERT INTO `shop_submenu` VALUES (301, '订单列表', '/orderList', 300);
INSERT INTO `shop_submenu` VALUES (302, '未发货', '/orderNew', 300);
INSERT INTO `shop_submenu` VALUES (303, '已发货', '/orderOld', 300);
INSERT INTO `shop_submenu` VALUES (401, '轮播图管理', '/banner', 400);
INSERT INTO `shop_submenu` VALUES (402, '热门手机', '/hotGood', 400);
INSERT INTO `shop_submenu` VALUES (501, '商城配置', '/mallConfig', 500);
INSERT INTO `shop_submenu` VALUES (601, '修改密码', '/system', 600);
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
