springboot实现高并发红包系统（java 全网最全包括语音口令文字口令普通拼手气）

置顶

刘明同学呀

已于 2023-12-12 12:45:54 修改

阅读量1.3k

点赞数 3

分类专栏：红包高并发文章标签： redis rabbitmq spring boot java

于 2022-06-14 10:14:05 首次发布

本文链接：https://blog.csdn.net/qq_40942490/article/details/125273041

版权

一起探讨学习

欢迎大家进群，一起讨论学习

每天给大家提供技术干货

在这里插入图片描述

博主技术笔记 https://notes.xiyankt.com

博主开源微服架构前后端分离技术博客项目源码地址，欢迎各位star https://gitee.com/bright-boy/xiyan-blog

springboot实现高并发红包系统（全网最全）

`下面的业务处理请根据你们实际的场景进行处理`

1.sql设计

CREATE TABLE `red_packet_info`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `packet_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '红包id',
  `type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '红包类型（0=拼手气红包，1=普通红包，2=文字口令红包，3=语音口令红包）',
  `watchword_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '口令内容',
  `user_id` int(0) NOT NULL COMMENT '用户id，哪个用户发的红包',
  `total_amount` decimal(8, 2) NOT NULL COMMENT '红包总金额',
  `total_packet` int(0) NOT NULL COMMENT '红包个数',
  `amount_one` decimal(8, 2) NULL DEFAULT NULL COMMENT '单个红包金额',
  `blessing` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '红包祝福语',
  `cover` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '红包封面',
  `left_amount` decimal(8, 2) NOT NULL COMMENT '剩余红包金额',
  `left_packet` int(0) NOT NULL COMMENT '剩余红包个数',
  `expire_time` datetime(0) NOT NULL COMMENT '红包过期时间',
  `send_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '发送红包类型（0=私发,1=群发）',
  `status` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '红包状态（1=已创建，-1=已失效，2=已抢完）',
  `create_time` datetime(0) NOT NULL COMMENT '创建时间',
  `update_time` datetime(0) NOT NULL COMMENT '更新时间',
  `deleted` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '0' COMMENT '是否删除',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '更新者',
  `tenant_id` bigint(0) NOT NULL DEFAULT 0 COMMENT '租户编号',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `packet_id`(`packet_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 775 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '红包表' ROW_FORMAT = Dynamic;

CREATE TABLE `red_packet_records`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `user_id` int(0) NOT NULL COMMENT '用户id',
  `amount` decimal(8, 2) NOT NULL COMMENT '抢到的金额',
  `watchword_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '口令内容',
  `red_packet_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '红包id',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` datetime(0) NOT NULL COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` datetime(0) NOT NULL COMMENT '更新时间',
  `deleted` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '1' COMMENT '是否删除',
  `tenant_id` bigint(0) NOT NULL DEFAULT 0 COMMENT '租户编号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 223 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '红包记录表' ROW_FORMAT = Dynamic;

2.实体类

RedPacketInfoDO

package cn.inno.pala.module.packet.dal.dataobject;

import cn.inno.pala.framework.tenant.core.db.TenantBaseDO;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.Data;
import lombok.EqualsAndHashCode;
import lombok.experimental.Accessors;

import java.math.BigDecimal;
import java.util.Date;

/**
 * @author: Bright
 * @time: 2022-06-07 13:58
 * @description: 红包表
 */
@Data
@EqualsAndHashCode(callSuper = false)
@Accessors(chain = true)
@TableName("red_packet_info")
public class RedPacketInfoDO extends TenantBaseDO {
   

    private static final long serialVersionUID = 1L;

    /**
     * 自增id
     */
    @TableId(value = "id", type = IdType.AUTO)
    private Integer id;

    /**
     * 红包id
     */
    private String packetId;

    /**
     * 红包类型（0=拼手气红包，1=普通红包，2=文字口令红包，3=语音口令红包）
     */
    private String type;

    /**
     * 口令内容
     */
    private String watchwordContent;

    /**
     * 用户id，哪个用户发的红包
     */
    private Integer userId;

    /**
     * 红包总金额
     */
    private BigDecimal totalAmount;

    /**
     * 红包个数
     */
    private Integer totalPacket;

    /**
     * 单个红包金额
     */
    private BigDecimal amountOne;

    /**
     * 红包祝福语
     */
    private String blessing;

    /**
     * 红包封面
     */
    private String cover;

    /**
     * 剩余红包金额
     */
    private BigDecimal leftAmount;

    /**
     * 剩余红包个数
     */
    private Integer leftPacket;

    /**
     * 发送红包类型（0=私发,1=群发）
     */
    private String sendType;

    /**
     * 红包过期时间
     */
    private Date expireTime;

    /**
     * 红包状态（1=已创建，-1=已失效，2=已抢完）
     */
    private String status;

    /**
     * 用户昵称
     */
    @TableField(exist = false)
    private String nickname;

    /**
     * 用户头像
     */
    @TableField(exist = false)
    private String avatar;

}

RedPacketRecordsDO

package cn.inno.pala.module.packet.dal.dataobject;

import cn.inno.pala.framework.tenant.core.db.TenantBaseDO;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.Data;
import lombok.EqualsAndHashCode;
import lombok.experimental.Accessors;

import java.math.BigDecimal;

/**
 * @author: Bright
 * @time: 2022-06-07 13:58
 * @description: 红包记录表
 */
@Data
@EqualsAndHashCode(callSuper = false)
@Accessors(chain = true)
@TableName("red_packet_records")
public class RedPacketRecordsDO extends TenantBaseDO {
   

    private static final long serialVersionUID = 1L;

    @TableId(value = "id", type = IdType.AUTO)
    private Integer id;

    /**
     * 用户id
     */
    private Integer userId;

    /**
     * 抢到的金额
     */
    private BigDecimal amount;

    /**
     * 口令内容
     */
    private String watchwordContent;
    /**
     * 红包id
     */
    private String redPacketId;


    /**
     * 用户昵称
     */
    @TableField(exist = false)
    private String nickname;

    /**
     * 用户头像
     */
    @TableField(exist = false)
    private String avatar;
}

3.Mapper

RedPacketInfoMapper

package cn.inno.pala.module.packet.dal.mysql;

import cn.inno.pala.framework.mybatis.core.mapper.BaseMapperX;
import cn.inno.pala.module.packet.dal.dataobject.RedPacketInfoDO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

/**
 * @author: Bright
 * @time: 2022-06-07 13:58
 * @description:
 */
@Mapper
public interface RedPacketInfoMapper extends BaseMapperX<RedPacketInfoDO> {
   
    /**
     * 红包查询
     *
     * @param packetId
     * @return
     */
    RedPacketInfoDO getRedPacket(@Param("packetId") String packetId);
}

RedPacketRecordsMapper

package cn.inno.pala.module.packet.dal.mysql;

import cn.inno.pala.framework.mybatis.core.mapper.BaseMapperX;
import cn.inno.pala.module.packet.dal.dataobject.RedPacketRecordsDO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * @author: Bright
 * @time: 2022-06-07 13:58
 * @description:
 */
@Mapper
public interface RedPacketRecordsMapper extends BaseMapperX<RedPacketRecordsDO> {
   
    /**
     * 根据用户id和红包id查询红包记录
     *
     * @param packetId
     * @param userId
     * @return
     */
    RedPacketRecordsDO getRedPacketRecord(@Param("packetId") String packetId, @Param("userId") Long userId);

    /**
     * 根据红包id查询红包记录列表
     *
     * @param packetId
     * @return
     */
    List<RedPacketRecordsDO> getRedPacketRecordList(@Param("packetId") String packetId);
}

4.xml

RedPacketInfoMapper.xml

<?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="cn.inno.pala.module.packet.dal.mysql.RedPacketInfoMapper">
    <resultMap id="redPacketResultMap" type="RedPacketInfoDO">
        <id column="id" property="id"></id>
        <result column="packet_id" property="packetId"></result>
        <result column="type" property="type"></result>
        <result column="watchword_content" property="watchwordContent"></result>
        <result column="user_id" property="userId"></result>
        <result column="total_amount" property="totalAmount"></result>
        <result column="total_packet" property="totalPacket"></result>
        <result column="amount_one" property="amountOne"></result>
        <result column="blessing" property="blessing"></result>
        <result column="cover" property="cover"></result>
        <result column="left_amount" property="leftAmount"></result>
        <result column="left_packet" property="leftPacket"></result>
        <result column="expire_time" property="expireTime"></result>
        <result column="send_type" property="sendType"></result>
        <result column="status" property="status"></result>
        <result column="create_time" property="createTime"></result>
        <result column="update_time" property="updateTime"></result>
        <result column="deleted" property="deleted"></result>
        <result column="creator" property="creator"></result>
        <result column="updater" property="updater"></result>
        <result column="tenant_id" property="tenantId"></result>
    </resultMap>

    <select id="getRedPacket" resultMap="redPacketResultMap">
        SELECT r.*, m.nickname, m.avatar
        FROM `red_packet_info` r
                 INNER JOIN member_user m ON r.user_id = m.id
        WHERE r.packet_id = #{packetId}
    </select>
</mapper>

RedPacketRecordsMapper.xml

<?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="cn.inno.pala.module.packet.dal.mysql.RedPacketRecordsMapper">
    <resultMap id="redPacketRecordResultMap" type="RedPacketRecordsDO">
        <id column="id" property="id"></id>