网站导航
> 技术文档 > 校园二手交易小程序的设计与实现

校园二手交易小程序的设计与实现

网友: 技术文档 2025-07-26 20:01:44

文章目录

    • 前言
    • 详细视频演示
    • 具体实现截图
      • 后端框架SpringBoot
      • 微信小程序
      • 持久层框架MyBaits
    • 成功系统案例：
    • 参考代码
    • 数据库
    • 源码获取

前言

博主介绍:CSDN特邀作者、985高校计算机专业毕业、现任某互联网大厂高级全栈开发工程师、Gitee/掘金/华为云/阿里云/GitHub等平台持续输出高质量技术内容、深耕Java、小程序、前端、python等技术领域和毕业项目实战，以及程序定制化开发、全栈讲解。

💯文末获取源码+数据库💯
感兴趣的可以先收藏起来，还有大家在毕设选题，项目以及论文编写等相关问题都可以找我咨询，希望帮助更多的人。

详细视频演示

视频演示

具体实现截图

在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述
在这里插入图片描述

在这里插入图片描述
在这里插入图片描述

后端框架SpringBoot

Spring Boot允许开发者快速构建出既可以独立运行又满足生产级别标准的Spring基础应用程序。此框架通过提供一系列便捷的工具和服务，极大地促进了基于Spring的应用开发工作的效率和质量。通过提供一系列大型项目中常用的默认配置，Spring Boot最大化减少配置文件的使用，开发者能够迅速启动和运行Spring应用程序。

Spring Boot通过约定优于配置的原则，避免了许多传统Spring应用开发时繁琐的配置，该框架支持对内嵌服务器的自动配置，如Tomcat、Jetty或Undertow，从而简化了Web应用的部署过程。

微信小程序

小程序开发框架的目标是通过尽可能简单、高效的方式让开发者可以在微信中开发具有原生 APP 体验的服务。
整个小程序框架系统分为两部分：逻辑层（App Service）和 视图层（View）。小程序提供了自己的视图层描述语言 WXML 和 WXSS，以及基于 JavaScript 的逻辑层框架，并在视图层与逻辑层间提供了数据传输和事件系统，让开发者能够专注于数据与逻辑。

持久层框架MyBaits

MyBatis是一个开源的持久层框架，它可以帮助开发者简化数据库操作的编写和管理。MyBatis的核心思想是将SQL语句和Java代码分离，通过XML或注解的方式来描述数据库操作，从而实现了数据访问层的解耦和灵活性。

MyBatis的优势主要包括以下几点：

简化数据库操作：MyBatis通过提供强大的SQL映射功能，可以将Java对象与数据库表进行映射，开发者无需手动编写繁琐的SQL语句，大大简化了数据库操作的编写和维护。

灵活的SQL控制：MyBatis支持动态SQL，可以根据不同的条件和逻辑来动态生成SQL语句，使得查询、更新等操作更加灵活和可控。

缓存支持：MyBatis提供了一级缓存和二级缓存的支持，可以有效减少数据库的访问次数，提高系统性能。

可扩展性强：MyBatis采用插件机制，可以方便地扩展和定制自己的功能，满足各种不同的业务需求。

所有项目均为博主亲自收集、开发并严格测试，确保源码完整、可运行，无缺失依赖或兼容性问题！同学们拿到后就能使用！博主具备多年高级开发经验，能深入讲解代码架构、核心逻辑及技术难点，助你高效掌握项目精髓。

成功系统案例：

在这里插入图片描述
在这里插入图片描述
在这里插入图片描述

参考代码

package com.example.modules.controller;import java.text.MessageFormat;import java.util.Date;import org.apache.commons.lang3.StringUtils;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.web.bind.annotation.PostMapping;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.RestController;import com.alibaba.fastjson.JSON;import com.example.common.utils.Assert;import com.example.common.utils.Constant;import com.example.common.utils.HttpUtils;import com.example.common.utils.R;import com.example.common.utils.ResourceUtil;import com.example.modules.bo.WxOpenSessionBo;import com.example.modules.entity.UserEntity;import com.example.modules.service.UserService;@RestController@RequestMapping(\"/cus/api/user\")public class ApiUserController {public final String OBJ_TAG = \"data\";@Autowiredprivate UserService userService;/** * 登录 */@PostMapping(\"login\")// @RequestMapping(\"login\")public R login(String username, String password,String code ) { UserEntity userEntity = userService.login(username, password); if (userEntity==null )return R.error(\"帐号密码不对\"); //String urlStr = \" https://api.weixin.qq.com/sns/jscode2session?appid={0}&secret={1}&js_code={2}&grant_type=authorization_code\";//urlStr = MessageFormat.format(urlStr,//ResourceUtil.getConfigByName(Constant.APP_ID),//ResourceUtil.getConfigByName(Constant.APP_SECRET), code);//String str = HttpUtils.doGet(urlStr);//WxOpenSessionBo wx = JSON.parseObject(str, WxOpenSessionBo.class);//if (wx.getErrcode() == 0) {//UserEntity user = userService.queryByOpenId(wx.getOpenId());//if (user == null) {// user = new UserEntity();// user.setId(userEntity.getId());//user.setOpenId(wx.getOpenId());//user.setPassword(null);//userService.update(user);// }////return R.ok().put(OBJ_TAG, user );//}return R.ok().put(OBJ_TAG, userEntity);}/** * 注册 */@PostMapping(\"register\")// @RequestMapping(\"login\")public R register(String username,String openId, String password, String address,String pic,String phone ,String nickname,String sex) {Assert.isBlank(username, \"用户名不能为空\");Assert.isBlank(password, \"密码不能为空\"); UserEntity userEntity;try {userEntity = new UserEntity();userEntity.setAddress(address);userEntity.setUsername(username);userEntity.setPassword(password);userEntity.setNickname(nickname);userEntity.setSex(sex);userEntity.setVip(0); userEntity.setOpenId(null);userEntity.setAphone(phone);userEntity.setUser(nickname); userEntity.setPic(pic);userEntity.setPhone(phone);userEntity.setCreateTime(new Date());userService.save(userEntity);return R.ok().put(OBJ_TAG, userEntity);} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();}return R.error(\"用户名已存在\");}/** * 注册 */@PostMapping(\"update\")// @RequestMapping(\"login\")public R update(String username, String password, int userId,String phone,String realname ) { UserEntity userEntity;try {userEntity = userService.queryObject(userId);userEntity.setUsername(username);if(!StringUtils.isEmpty(password))userEntity.setPassword(password); userEntity.setPhone(phone); userEntity.setNickname(realname); userService.update(userEntity);return R.ok().put(OBJ_TAG, userEntity);} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();}return R.error(\"用户名已存在\");}@RequestMapping(\"wxcode\")public R wxcode(String code,String nickname,String pic,String zhangbenId) {String urlStr = \" https://api.weixin.qq.com/sns/jscode2session?appid={0}&secret={1}&js_code={2}&grant_type=authorization_code\";urlStr = MessageFormat.format(urlStr,ResourceUtil.getConfigByName(Constant.APP_ID),ResourceUtil.getConfigByName(Constant.APP_SECRET), code);String str = HttpUtils.doGet(urlStr);WxOpenSessionBo wx = JSON.parseObject(str, WxOpenSessionBo.class);if (wx.getErrcode() == 0) {UserEntity user = userService.queryByOpenId(wx.getOpenId());if (user == null) {//user=new UserEntity();//user.setNickname(nickname);//user.setUsername(nickname);//user.setPassword(nickname);//user.setPhone(\"1\");//user.setOpenId(wx.getOpenId());//user.setSex(\"1\");////user.setCreateTime(new Date());//userService.save(user);return R.error(\"未绑定信息，请先绑定\");}user.setPic(pic);user.setNickname(nickname);userService.update(user);return R.ok().put(OBJ_TAG, user );}return R.error();} }

数据库

SET NAMES utf8mb4;SET FOREIGN_KEY_CHECKS = 0;-- ------------------------------ Table structure for sys_user-- ----------------------------DROP TABLE IF EXISTS `sys_user`;CREATE TABLE `sys_user` ( `user_id` bigint NOT NULL AUTO_INCREMENT, `username` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT \'用户名\', `password` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT \'密码\', `salt` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT \'盐\', `email` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT \'邮箱\', `phone` varchar(11) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT \'手机号\', `status` tinyint NULL DEFAULT NULL COMMENT \'状态 0：禁用 1：正常\', `create_time` datetime NULL DEFAULT NULL, `user_type` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL, PRIMARY KEY (`user_id`) USING BTREE, UNIQUE INDEX `username`(`username` ASC) USING BTREE) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = \'系统用户\' ROW_FORMAT = Dynamic;-- ------------------------------ Records of sys_user-- ----------------------------INSERT INTO `sys_user` VALUES (1, \'admin\', \'e1153123d7d180ceeb820d577ff119876678732a68eef4e6ffc0b1f06a01f91b\', \'YzcmCZNvbXocrsz9dm8e\', \'root@qq.io\', \'13612345656\', 1, \'2022-02-08 13:06:23\', \'1\');-- ------------------------------ Table structure for t_cat-- ----------------------------DROP TABLE IF EXISTS `t_cat`;CREATE TABLE `t_cat` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT \'分类名称\', PRIMARY KEY (`id`) USING BTREE) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = \'分类\' ROW_FORMAT = Dynamic;-- ------------------------------ Records of t_cat-- ----------------------------INSERT INTO `t_cat` VALUES (8, \'办公用品\');INSERT INTO `t_cat` VALUES (9, \'电脑\');INSERT INTO `t_cat` VALUES (10, \'二手书籍\');INSERT INTO `t_cat` VALUES (11, \'二手衣服\');INSERT INTO `t_cat` VALUES (12, \'生活用品\');INSERT INTO `t_cat` VALUES (14, \'3C数码\');-- ------------------------------ Table structure for t_goods-- ----------------------------DROP TABLE IF EXISTS `t_goods`;CREATE TABLE `t_goods` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT \'名称\', `status` int NOT NULL DEFAULT 0 COMMENT \'状态\', `pic` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT \'图片\', `price` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT \'价格\', `content` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT \'介绍\', `cat_id` int NULL DEFAULT NULL COMMENT \'分类\', `pics` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT \'图片\', `user_id` int NULL DEFAULT NULL COMMENT \'用户\', PRIMARY KEY (`id`) USING BTREE) ENGINE = InnoDB AUTO_INCREMENT = 22 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = \'商品\' ROW_FORMAT = Dynamic;-- ------------------------------ Records of t_goods-- ----------------------------INSERT INTO `t_goods` VALUES (22, \'自用二手苹果14\', 1, \'/upload/1753427571223.jpg\', \'1999\', \' 美女自用，成色好\', 14, \'/upload/1753427571223.jpg\', NULL);INSERT INTO `t_goods` VALUES (23, \'圆珠笔\', 1, \'/upload/1753427648608.jpg\', \'1\', \' 圆珠笔\', 8, \'/upload/1753427648608.jpg\', NULL);INSERT INTO `t_goods` VALUES (24, \'黑色短袖\', 1, \'/upload/1753427683263.jpg\', \'9.9\', \' 黑色短袖\', 11, \'/upload/1753427683263.jpg\', NULL);INSERT INTO `t_goods` VALUES (25, \'白色耳机\', 1, \'/upload/1753427710656.jpg\', \'9.9\', \' 白色耳机 ，音质好，成色新\', 14, \'/upload/1753427710656.jpg\', NULL);INSERT INTO `t_goods` VALUES (26, \'黑色耳机\', 1, \'/upload/1753428612222.jpg\', \'39\', \' 自用黑色耳机\', 14, \'/upload/1753428612222.jpg\', NULL);INSERT INTO `t_goods` VALUES (27, \'橡皮擦(自用的)\', 0, \'/upload/1753429756046.jpg\', \'2\', \'自用橡皮擦，成色新\', 0, \'/upload/1753429756046.jpg\', 1);-- ------------------------------ Table structure for t_likes-- ----------------------------DROP TABLE IF EXISTS `t_likes`;CREATE TABLE `t_likes` ( `id` int NOT NULL AUTO_INCREMENT, `user_id` int NOT NULL DEFAULT 0 COMMENT \'用户\', `goods_id` int NOT NULL DEFAULT 0 COMMENT \'商品\', `create_time` datetime NULL DEFAULT NULL COMMENT \'收藏时间\', PRIMARY KEY (`id`) USING BTREE) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = \'收藏记录\' ROW_FORMAT = Dynamic;-- ------------------------------ Records of t_likes-- ----------------------------INSERT INTO `t_likes` VALUES (15, 1, 22, \'2025-07-25 07:16:32\');INSERT INTO `t_likes` VALUES (16, 1, 26, \'2025-07-25 07:30:40\');-- ------------------------------ Table structure for t_order-- ----------------------------DROP TABLE IF EXISTS `t_order`;CREATE TABLE `t_order` ( `order_id` varchar(36) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT \'订单号\', `goods_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT \'商品名称\', `goods_id` int NOT NULL COMMENT \'商品\', `user_id` int NOT NULL COMMENT \'用户\', `status` int NOT NULL DEFAULT 0 COMMENT \'状态\', `pic` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT \'图片\', `price` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT \'价格\', `star` int NULL DEFAULT 0 COMMENT \'星级\', `comment` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT \'评价\', `create_time` datetime NULL DEFAULT NULL COMMENT \'创建时间\', `num` int NULL DEFAULT 1 COMMENT \'数量\', `address` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT \'地址\', `phone` varchar(11) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT \'电话\', `user` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT \'联系人\', PRIMARY KEY (`order_id`) USING BTREE) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = \'订单\' ROW_FORMAT = Dynamic;-- ------------------------------ Records of t_order-- ----------------------------INSERT INTO `t_order` VALUES (\'1753427756069\', \'圆珠笔\', 23, 1, 2, \'/upload/1753427648608.jpg\', \'1\', NULL, NULL, \'2025-07-25 07:15:56\', 1, \'t303宿舍\', \'13456789011\', \'xiyang\');INSERT INTO `t_order` VALUES (\'1753427987757\', \'自用二手苹果14\', 22, 1, 0, \'/upload/1753427571223.jpg\', \'1999\', NULL, NULL, \'2025-07-25 07:19:48\', 1, \'t303宿舍\', \'13456789011\', \'xiyang\');INSERT INTO `t_order` VALUES (\'1753428658935\', \'黑色耳机\', 26, 1, 1, \'/upload/1753428612222.jpg\', \'39\', NULL, NULL, \'2025-07-25 07:30:59\', 1, \'t303宿舍\', \'13456789011\', \'xiyang\');-- ------------------------------ Table structure for t_record-- ----------------------------DROP TABLE IF EXISTS `t_record`;CREATE TABLE `t_record` ( `id` int NOT NULL AUTO_INCREMENT, `user_id` int NOT NULL DEFAULT 0 COMMENT \'用户\', `type_id` int NOT NULL DEFAULT 0 COMMENT \'类型\', `price` int NOT NULL DEFAULT 0 COMMENT \'金额\', `create_time` datetime NULL DEFAULT NULL COMMENT \'创建时间\', PRIMARY KEY (`id`) USING BTREE) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = \'充值提现记录\' ROW_FORMAT = Dynamic;-- ------------------------------ Records of t_record-- ----------------------------INSERT INTO `t_record` VALUES (10, 1, 1, 100, \'2025-07-01 14:22:11\');INSERT INTO `t_record` VALUES (11, 1, 1, 50, \'2025-07-01 14:25:12\');INSERT INTO `t_record` VALUES (12, 1, 1, 50, \'2025-07-01 14:45:22\');INSERT INTO `t_record` VALUES (13, 1, 1, 100, \'2025-07-01 14:56:12\');INSERT INTO `t_record` VALUES (14, 1, 1, 100, \'2025-07-01 15:22:11\');INSERT INTO `t_record` VALUES (15, 1, 1, 100, \'2025-07-01 15:26:45\');INSERT INTO `t_record` VALUES (16, 1, 1, 300, \'2025-07-01 15:45:33\');INSERT INTO `t_record` VALUES (17, 1, 1, 10, \'2025-07-01 16:22:22\');-- ------------------------------ Table structure for t_shopcar-- ----------------------------DROP TABLE IF EXISTS `t_shopcar`;CREATE TABLE `t_shopcar` ( `id` int NOT NULL AUTO_INCREMENT, `user_id` int NOT NULL COMMENT \'用户\', `goods_id` int NOT NULL COMMENT \'商品\', `status` int NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE) ENGINE = InnoDB AUTO_INCREMENT = 36 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = \'购物车\' ROW_FORMAT = Dynamic;-- ------------------------------ Records of t_shopcar-- ----------------------------INSERT INTO `t_shopcar` VALUES (39, 1, 27, NULL);-- ------------------------------ Table structure for t_user-- ----------------------------DROP TABLE IF EXISTS `t_user`;CREATE TABLE `t_user` ( `id` int NOT NULL AUTO_INCREMENT COMMENT \'ID\', `username` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT \'用户名\', `password` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT \'密码\', `nickname` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT \'昵称\', `phone` varchar(11) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT \'手机号\', `pic` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT \'用户头像\', `sex` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT \'性别\', `create_time` datetime NULL DEFAULT NULL COMMENT \'创建时间\', `open_id` varchar(36) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL, `yu` int NULL DEFAULT NULL COMMENT \'余额\', `aphone` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL, `address` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL, `user` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL, `vip` int NULL DEFAULT 0 COMMENT \'是否vip\', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `username`(`username` ASC) USING BTREE) ENGINE = InnoDB AUTO_INCREMENT = 26 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;-- ------------------------------ Records of t_user-- ----------------------------INSERT INTO `t_user` VALUES (1, \'xiyang\', \'xiyang\', \'xiyang\', \'13456789011\', \'https://wx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTLib7icZuiaQWLJqicRtO7sdcSa7XVnIfMbjvFmnGiaYBGwPcwJmPyteDnpib7mibBSuomFl9pujiaicDueWAw/132\', \'女\', \'2022-02-08 13:06:23\', \'o1ZY_5XjBqWxFAgtgY2IwyUPDPII\', 352, \'13456789011\', \'t303宿舍\', \'xiyang\', 1);INSERT INTO `t_user` VALUES (4, \'qqqq\', \'qqqqqq11\', \'qqqq\', \'13323333333\', \'https://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTLib7icZuiaQWLJqicRtO7sdcSa7XVnIfMbjvFmnGiaYBGwPcwJmPyteDnpib7mibBSuomFl9pujiaicDueWAw/132\', \'1\', \'2022-02-08 13:06:23\', NULL, 0, NULL, NULL, NULL, NULL);INSERT INTO `t_user` VALUES (21, \'aaa\', \'qqqq1111\', \'aaa\', \'14344444444\', \'https://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTLib7icZuiaQWLJqicRtO7sdcSa7XVnIfMbjvFmnGiaYBGwPcwJmPyteDnpib7mibBSuomFl9pujiaicDueWAw/132\', \'男\', \'2022-02-08 13:06:23\', \'undefined\', NULL, NULL, NULL, NULL, 0);INSERT INTO `t_user` VALUES (24, \'aaaa\', \'qqqq1111\', \'aaaa\', \'14588888888\', \'https://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTLib7icZuiaQWLJqicRtO7sdcSa7XVnIfMbjvFmnGiaYBGwPcwJmPyteDnpib7mibBSuomFl9pujiaicDueWAw/132\', \'男\', \'2022-02-08 21:41:59\', NULL, NULL, \'14588888888\', \'t303宿舍\', \'xiyang\', 0);-- ------------------------------ Table structure for t_views-- ----------------------------DROP TABLE IF EXISTS `t_views`;CREATE TABLE `t_views` ( `id` int NOT NULL AUTO_INCREMENT, `user_id` int NOT NULL DEFAULT 0 COMMENT \'用户\', `goods_id` int NOT NULL DEFAULT 0 COMMENT \'商品\', `create_time` datetime NULL DEFAULT NULL COMMENT \'浏览时间\', `score` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT \'分值\', PRIMARY KEY (`id`) USING BTREE) ENGINE = InnoDB AUTO_INCREMENT = 92 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = \'浏览记录\' ROW_FORMAT = Dynamic;-- ------------------------------ Records of t_views-- ----------------------------INSERT INTO `t_views` VALUES (82, 1, 13, \'2022-02-08 13:09:14\', \'4.5\');INSERT INTO `t_views` VALUES (83, 1, 17, \'2022-02-08 20:43:55\', \'4.5\');INSERT INTO `t_views` VALUES (84, 1, 6, \'2022-02-08 21:04:02\', \'3.5\');INSERT INTO `t_views` VALUES (85, 1, 12, \'2022-02-08 21:04:38\', \'4.5\');INSERT INTO `t_views` VALUES (86, 1, 2, \'2022-02-08 21:04:41\', \'2.0\');INSERT INTO `t_views` VALUES (87, 1, 12, \'2022-02-08 21:04:55\', \'2.0\');INSERT INTO `t_views` VALUES (88, 1, 17, \'2022-02-08 21:42:06\', \'2.5\');INSERT INTO `t_views` VALUES (89, 1, 2, \'2022-02-08 21:44:26\', \'4.5\');INSERT INTO `t_views` VALUES (90, 1, 12, \'2022-02-08 21:45:56\', \'1.5\');INSERT INTO `t_views` VALUES (91, 1, 13, \'2022-02-08 21:45:59\', \'2.0\');INSERT INTO `t_views` VALUES (92, 1, 23, \'2025-07-25 07:15:49\', \'2.0\');INSERT INTO `t_views` VALUES (93, 1, 22, \'2025-07-25 07:16:30\', \'2.0\');INSERT INTO `t_views` VALUES (94, 1, 22, \'2025-07-25 07:16:34\', \'2.0\');INSERT INTO `t_views` VALUES (95, 1, 22, \'2025-07-25 07:19:14\', \'2.0\');INSERT INTO `t_views` VALUES (96, 1, 22, \'2025-07-25 07:19:26\', \'1.5\');INSERT INTO `t_views` VALUES (97, 1, 26, \'2025-07-25 07:30:37\', \'3.0\');INSERT INTO `t_views` VALUES (98, 1, 26, \'2025-07-25 07:30:51\', \'3.5\');INSERT INTO `t_views` VALUES (99, 1, 23, \'2025-07-25 07:44:14\', \'3.0\');INSERT INTO `t_views` VALUES (100, 1, 27, \'2025-07-25 07:49:31\', \'2.5\');INSERT INTO `t_views` VALUES (101, 1, 27, \'2025-07-25 07:52:33\', \'3.0\');

源码获取

如需交流/获取资料，请先【关注+私信】我，私信获取源码~

网络标签：

相关问题