灌水论坛系统总体设计文档

客户端层：HTML + CSS + JavaScript + Tabler UI
         |
         | HTTP/HTTPS
         v
应用服务层：Spring Boot + Spring MVC + Swagger
         |
         | MyBatis
         v
数据存储层：MySQL数据库

public class User {
    private Long id;
    @ApiModelProperty("用户名")
    private String username;
    @JsonIgnore // 不参与JSON序列化
    private String password;
    @ApiModelProperty("昵称")
    private String nickname;
    // ... 其他字段 ...
    @ApiModelProperty("头像地址")
    @JsonInclude(JsonInclude.Include.ALWAYS) // 强制参与JSON序列化
    private String avatarUrl;
    // ... 其他字段 ...
    @ApiModelProperty("注册日期")
    private Date createTime;
    private Date updateTime;
}

@Data
@ApiModel("用户信息")
public class User {
    private Long id;                     // 用户ID
    @ApiModelProperty("用户名")
    private String username;             // 登录用户名
    @JsonIgnore                         // JSON序列化时忽略密码
    private String password;             // 加密后的密码
    @ApiModelProperty("昵称")
    private String nickname;             // 显示昵称
    @ApiModelProperty("电话号码")
    private String phoneNum;             // 电话号码
    @ApiModelProperty("邮箱")
    private String email;                // 电子邮箱
    @ApiModelProperty("性别")
    private Byte gender;                 // 性别(0女,1男,2保密)
    @JsonIgnore
    private String salt;                 // 密码加密盐值
    @ApiModelProperty("头像地址")
    private String avatarUrl;            // 头像URL
    @ApiModelProperty("发帖数量")
    private Integer articleCount;        // 发帖数
    @ApiModelProperty("是否管理员")
    private Byte isAdmin;                // 管理员标识
    @ApiModelProperty("个人简介")
    private String remark;               // 个人简介
    private Byte state;                  // 用户状态
    private Date createTime;             // 注册时间
    private Date updateTime;             // 更新时间
}

@Data
public class ArticleReply {
    private Long id;                     // 回复ID
    private Long articleId;              // 关联帖子ID
    private Long postUserId;             // 回复者ID
    private Long replyId;                // 被回复的回复ID(楼中楼)
    private Long replyUserId;            // 被回复者ID
    private String content;              // 回复内容
    private Integer likeCount;           // 点赞数
    private Byte state;                  // 回复状态
    private Date createTime;             // 回复时间
    private Date updateTime;             // 更新时间
    private User user;                   // 关联的用户信息
}

public class MD5Util {
    // 使用MD5+盐值加密
    public static String md5Salt(String password, String salt) {
        String passwordSalt = password + salt;
        return DigestUtils.md5DigestAsHex(passwordSalt.getBytes());
    }
}

@Service
public class UserServiceImpl implements IUserService {
    @Resource
    private UserMapper userMapper;
    
    @Override
    public User login(String username, String password) {
        // 1. 根据用户名查询用户
        User user = userMapper.selectByUsername(username);
        if (user == null) {
            return null;
        }
        
        // 2. 验证密码
        String encryptPassword = MD5Util.md5Salt(password, user.getSalt());
        if (!encryptPassword.equals(user.getPassword())) {
            return null;
        }
        
        // 3. 清除敏感信息
        user.setPassword(null);
        user.setSalt(null);
        
        return user;
    }
}

@Service
public class ArticleServiceImpl implements IArticleService {
    @Resource
    private ArticleMapper articleMapper;
    @Resource
    private BoardMapper boardMapper;
    
    @Override
    @Transactional
    public void createArticle(Article article) {
        // 1. 设置初始值
        article.setVisitCount(0);
        article.setReplyCount(0);
        article.setLikeCount(0);
        article.setState((byte)0);
        article.setCreateTime(new Date());
        article.setUpdateTime(new Date());
        
        // 2. 保存帖子
        articleMapper.insert(article);
        
        // 3. 更新版块帖子数
        boardMapper.incrementArticleCount(article.getBoardId());
    }
}

@Service
public class ArticleServiceImpl implements IArticleService {
    
    @Override
    public PageInfo<Article> getArticleList(Integer pageNum, Integer pageSize, Long boardId) {
        // 1. 设置分页
        PageHelper.startPage(pageNum, pageSize);
        
        // 2. 查询条件
        ArticleExample example = new ArticleExample();
        if (boardId != null) {
            example.createCriteria()
                  .andBoardIdEqualTo(boardId)
                  .andStateEqualTo((byte)0);
        }
        example.setOrderByClause("create_time desc");
        
        // 3. 执行查询
        List<Article> articles = articleMapper.selectByExample(example);
        
        // 4. 填充用户信息
        for (Article article : articles) {
            User user = userMapper.selectByPrimaryKey(article.getUserId());
            article.setUser(user);
        }
        
        return new PageInfo<>(articles);
    }
}

@Service
public class ArticleReplyServiceImpl implements IArticleReplyService {
    
    @Override
    @Transactional
    public void reply(ArticleReply reply) {
        // 1. 设置初始值
        reply.setLikeCount(0);
        reply.setState((byte)0);
        reply.setCreateTime(new Date());
        reply.setUpdateTime(new Date());
        
        // 2. 保存回复
        replyMapper.insert(reply);
        
        // 3. 更新帖子回复数
        Article article = articleMapper.selectByPrimaryKey(reply.getArticleId());
        article.setReplyCount(article.getReplyCount() + 1);
        articleMapper.updateByPrimaryKey(article);
    }
}

// 配置分页插件
@Configuration
public class MybatisConfig {
    @Bean
    public PageInterceptor pageInterceptor() {
        return new PageInterceptor();
    }
}

// 使用分页
public PageInfo<Article> getArticleList(int pageNum, int pageSize) {
    PageHelper.startPage(pageNum, pageSize);
    List<Article> list = articleMapper.selectByExample(new ArticleExample());
    return new PageInfo<>(list);
}

@Data
public class AppResult<T> {
    private Integer code;        // 状态码
    private String message;      // 提示信息
    private T data;             // 响应数据
    
    public static <T> AppResult<T> success(T data) {
        AppResult<T> result = new AppResult<>();
        result.setCode(0);
        result.setMessage("success");
        result.setData(data);
        return result;
    }
    
    public static AppResult failed(ResultCode resultCode) {
        AppResult result = new AppResult();
        result.setCode(resultCode.getCode());
        result.setMessage(resultCode.getMessage());
        return result;
    }
}

@Component
public class LoginInterceptor implements HandlerInterceptor {
    
    @Override
    public boolean preHandle(HttpServletRequest request, HttpServletResponse response, 
                           Object handler) throws Exception {
        // 1. 获取session
        HttpSession session = request.getSession(false);
        if (session == null) {
            response.sendRedirect("/sign-in.html");
            return false;
        }
        
        // 2. 验证用户登录状态
        User user = (User) session.getAttribute(AppConfig.USER_SESSION);
        if (user == null) {
            response.sendRedirect("/sign-in.html");
            return false;
        }
        
        return true;
    }
}

@RestController
@RequestMapping("/upload")
public class UploadController {
    
    @PostMapping("/image")
    public AppResult<String> uploadImage(@RequestParam("file") MultipartFile file) {
        // 1. 验证文件类型
        String contentType = file.getContentType();
        if (!contentType.startsWith("image/")) {
            return AppResult.failed(ResultCode.FAILED_UPLOAD_TYPE);
        }
        
        // 2. 生成文件名
        String fileName = UUID.randomUUID().toString() + 
                         file.getOriginalFilename().substring(
                             file.getOriginalFilename().lastIndexOf("."));
        
        // 3. 保存文件
        try {
            String filePath = uploadPath + fileName;
            file.transferTo(new File(filePath));
            return AppResult.success("/uploads/" + fileName);
        } catch (IOException e) {
            return AppResult.failed(ResultCode.FAILED_UPLOAD);
        }
    }
}