在线 OJ 系统竞赛管理模块实战 (Java/Spring/Vue) | 极客日志

Java大前端java算法

在线 OJ 系统竞赛管理模块实战 (Java/Spring/Vue)

基于 Java Spring Boot 与 Vue 构建的在线 OJ 系统竞赛管理模块，涵盖数据库设计、前后端交互及核心业务逻辑。实现内容包括竞赛列表查询、新增与编辑、题目关联管理、状态发布控制等。技术细节涉及 MyBatis Plus 分页、Jackson 序列化处理、批量数据插入优化及并发状态校验，确保竞赛流程的完整性与数据一致性。

奶糖兔发布于 2026/3/23更新于 2026/5/108 浏览

在线 OJ 系统竞赛管理模块实战 (Java/Spring/Vue)

数据库设计

竞赛管理涉及竞赛基础信息与题目关联，核心表结构如下：

create table tb_exam (
    exam_id bigint unsigned not null comment '竞赛 id（主键）',
    title varchar(50) not null comment '竞赛标题',
    start_time datetime not null comment '竞赛开始时间',
    end_time datetime not null comment '竞赛结束时间',
    status tinyint not null default '0' comment '是否发布 0：未发布 1：已发布',
    create_by bigint unsigned not null comment '创建人',
    create_time datetime not null comment '创建时间',
    update_by bigint unsigned comment '更新人',
    update_time datetime comment '更新时间',
    primary key(exam_id)
);

create table tb_exam_question (
    exam_question_id bigint unsigned not null comment '竞赛题目关系 id（主键）',
    question_id bigint unsigned not null comment '题目 id（主键）',
    exam_id bigint unsigned not null comment '竞赛 id（主键）',
    question_order int not null comment '题目顺序',
    create_by bigint unsigned not null comment '创建人',
    create_time datetime not null comment '创建时间',
    update_by  unsigned comment ,
    update_time datetime comment ,
    (exam_question_id)
);

@RestController
@RequestMapping("/exam")
public class ExamController extends BaseController {
    @Autowired
    private IExamService examService;

    @GetMapping("/list")
    public TableDataInfo list(ExamQueryDTO examQueryDTO) {
        return getDataTable(examService.list(examQueryDTO));
    }
}

<select resultType="com.bite.system.model.exam.vo.ExamVO">
    SELECT te.exam_id, te.title, te.start_time, te.end_time, te.create_time, ts.nick_name as create_name, te.status 
    FROM tb_exam te 
    left join tb_sys_user ts on te.create_by = ts.user_id
    <where>
        <if test="title !=null and title !='' ">
            AND te.title LIKE CONCAT('%',#{title},'%')
        </if>
        <if test="startTime != null and startTime != '' ">
            AND te.start_time >= #{startTime}
        </if>
        <if test="endTime != null and endTime != ''">
            AND te.end_time &lt;= #{endTime}
        </if>
    </where>
    ORDER BY te.create_time DESC
</select>

@Override
public String add(ExamAddDTO examAddDTO) {
    checkExamSaveParams(examAddDTO, null);
    Exam exam = new Exam();
    BeanUtil.copyProperties(examAddDTO, exam);
    examMapper.insert(exam);
    return exam.getExamId().toString();
}

private void checkExamSaveParams(ExamAddDTO examSaveDTO, Long examId) {
    List<Exam> examList = examMapper.selectList(new LambdaQueryWrapper<Exam>()
        .eq(Exam::getTitle, examSaveDTO.getTitle())
        .ne(examId != null, Exam::getExamId, examId));
    if (CollectionUtil.isNotEmpty(examList)) {
        throw new ServiceException(ResultCode.FAILED_ALREADY_EXISTS);
    }
    if (examSaveDTO.getStartTime().isBefore(LocalDateTime.now())) {
        throw new ServiceException(ResultCode.EXAM_START_TIME_BEFORE_CURRENT_TIME);
    }
    if (examSaveDTO.getStartTime().isAfter(examSaveDTO.getEndTime())) {
        throw new ServiceException(ResultCode.EXAM_START_TIME_AFTER_END_TIME);
    }
}

async function saveBaseInfo() {
    const fd = new FormData()
    for (let key in formExam) {
        if (key === 'examDate') {
            fd.append('startTime', formExam.examDate[0])
            fd.append('endTime', formExam.examDate[1])
        } else {
            fd.append(key, formExam[key])
        }
    }
    await examAddService(fd)
    ElMessage.success('基本信息保存成功')
}

@Override
public boolean questionAdd(ExamQuestAddDTO examQuestAddDTO) {
    Exam exam = getExam(examQuestAddDTO.getExamId());
    checkExam(exam); // 检查状态
    Set<Long> questionIdSet = examQuestAddDTO.getQuestionIdSet();
    if (CollectionUtil.isEmpty(questionIdSet)) return true;
    
    List<Question> questionList = questionMapper.selectBatchIds(questionIdSet);
    if (CollectionUtil.isEmpty(questionList) || questionList.size() < questionIdSet.size()) {
        throw new ServiceException(ResultCode.EXAM_QUESTION_NOT_EXISTS);
    }
    return saveExamQuestion(exam, questionIdSet);
}

<if test="excludeIdSet !=null and !excludeIdSet.isEmpty()">
    <foreach collection="excludeIdSet" open=" AND tq.question_id NOT IN( " close=" ) " item="id" separator=",">
        #{id}
    </foreach>
</if>

@Override
public int publish(Long examId) {
    Exam exam = getExam(examId);
    if (exam.getEndTime().isBefore(LocalDateTime.now())) {
        throw new ServiceException(ResultCode.EXAM_IS_FINISH);
    }
    Long count = examQuestionMapper.selectCount(new LambdaQueryWrapper<ExamQuestion>().eq(ExamQuestion::getExamId, examId));
    if (count == null || count <= 0) {
        throw new ServiceException(ResultCode.EXAM_NOT_HAS_QUESTION);
    }
    exam.setStatus(Contants.TRUE);
    return examMapper.updateById(exam);
}