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

前言

博主介绍: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";

	@Autowired
	private 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 block
			e.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 block
			e.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');

源码获取

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