Java使用Springboot+Redis实现点赞功能

1. 流程图流程图

实现思路由于点赞属于一种频繁的提交操作，如果直接选用数据库做存储，对于数据库的压力比较大。这里考虑使用缓存作为中间层，然后定时的将数据持久化数据库，降低数据库的读写压力。缓存选用的是redis。 2. 具体实现 2.1 表设计点赞表

CREATE TABLE `user_likes` (
  `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '点赞信息ID',
  `info_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '点赞对象id',
  `create_time` datetime DEFAULT NULL COMMENT '时间',
  `like_user_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '点赞人ID',
  `update_time` datetime DEFAULT NULL,
  `status` int DEFAULT '0' COMMENT '0 取消 1 点赞',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `agdkey` (`like_user_id`,`info_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='点赞记录表';

点赞的内容表

CREATE TABLE `video` (
  `id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `likes_number` int DEFAULT NULL COMMENT '点赞数',
  `comments_number` int DEFAULT NULL COMMENT '评论数',
  `share_number` int DEFAULT NULL COMMENT '分享数',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_user` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `update_user` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '更新者',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

2.2 工具类及枚举类 RedisKeyUtils

public class RedisKeyUtils {
    
    public static final String MAP_KEY_USER_LIKED = "MAP_USER_LIKED";
    
    public static final String MAP_KEY_USER_LIKED_COUNT = "MAP_USER_LIKED_COUNT";

    
    public static String getLikedKey(String likedUserId, String likedPostId){
            return likedUserId +
                "::" +
                likedPostId;
    }

RedisConfig

@Configuration
public class RedisConfig {
    @Bean
    @ConditionalOnMissingBean(name = "redisTemplate")
    public RedisTemplate redisTemplate(RedisConnectionFactory redisConnectionFactory)  {

        Jackson2JsonRedisSerializer

Java使用Springboot+Redis实现点赞功能

Java相关栏目本月热门文章