JAVA智能题库AI题库系统源码支持小程序+公众号+H5

源码交付 · 小程序＋公众号＋H5

SPRINGBOOT · UNIAPP

刷题 · 错题本 · AI答疑 · 会员

JAVA智能题库系统

做题记录沉淀成错题，AI 接住看不懂的题。

后台 SpringBoot + MyBatis-Plus + MySQL用户端 uni-app · 后台 Vue + ElementUI

SQL

-- 题库主表：题目与选项分离，选项存 JSONCREATE TABLE t_question (  id BIGINT PRIMARY KEY AUTO_INCREMENT,  category_id BIGINT NOT NULL,  subject VARCHAR(32) NOT NULL,  grade VARCHAR(16) NOT NULL,  stem MEDIUMTEXT NOT NULL,  options JSON NOT NULL,  answer VARCHAR(64) NOT NULL,  analysis MEDIUMTEXT,  difficulty TINYINT DEFAULT 2,  status TINYINT DEFAULT 1,  KEY idx_cat (category_id)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;-- 答题记录：一次作答一行，唯一索引挡重复提交CREATE TABLE t_answer_record (  id BIGINT PRIMARY KEY AUTO_INCREMENT,  user_id BIGINT NOT NULL,  question_id BIGINT NOT NULL,  paper_id BIGINT NOT NULL,  user_answer VARCHAR(64),  is_right TINYINT DEFAULT 0,  submit_no CHAR(32) NOT NULL,  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,  UNIQUE KEY uk_submit (user_id,paper_id,    question_id, submit_no),  KEY idx_user (user_id,created_at)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

JAVA

// 交卷：判分 + 写错题本 + 扣会员次数，同一事务@Transactional(rollbackFor = Exception.class)public SubmitVO submit(SubmitDTO dto, Long uid) {    String no = dto.getSubmitNo();    // 幂等：同一 submitNo 重复提交直接返回旧结果    AnswerRecord exist = recordMapper.selectOne(        Wrappers.<AnswerRecord>lambdaQuery()            .eq(AnswerRecord::getSubmitNo, no)            .eq(AnswerRecord::getUserId, uid).last("limit 1"));    if (exist != null) return SubmitVO.replay(exist);    List<Long> qids = dto.getQuestionIds();    List<Question> qs = questionMapper.selectBatchIds(qids);    int right = 0;    for (Question q : qs) {        String ua = dto.getAnswers().get(q.getId());        boolean ok = checkAnswer(ua, q.getAnswer());        if (ok) right++;        AnswerRecord r = new AnswerRecord();        r.setUserId(uid); r.setPaperId(dto.getPaperId());        r.setQuestionId(q.getId()); r.setUserAnswer(ua);        r.setSubmitNo(no); r.setIsRight(ok ? 1 : 0);        try { recordMapper.insert(r); }        catch (DuplicateKeyException e) {            // 唯一索引兜住并发重复，不抛给前端            right -= ok ? 1 : 0;        }        if (!ok) wrongBookMapper.upsert(uid, q.getId());    }    memberService.consume(uid, qs.size());    return SubmitVO.of(right, qs.size(), no);}

JAVA

// 会员剩余次数扣减：条件 UPDATE + 重试，不先查后改public boolean consume(Long uid, int need) {    for (int i = 0; i < 3; i++) {        int ok = memberMapper.update(null,            Wrappers.<Member>lambdaUpdate()                .setSql("remain = remain - " + need)                .eq(Member::getUserId, uid)                .eq(Member::getStatus, 1)                .ge(Member::getRemain, need));        if (ok > 0) return true;        // 影响行数为 0：余额不足或已被其它请求扣走        Member m = memberMapper.selectById(uid);        if (m == null || m.getRemain() < need) {            throw new BizException("QUOTA_NOT_ENOUGH");        }    }    throw new BizException("CONCURRENT_RETRY_EXCEEDED");}

JAVA

// 会员支付回调：唯一索引 + 状态 CAS，防止重复到账public void onPayNotify(PayNotify n) {    if (!signService.verify(n)) return;    // 幂等键：订单号 + 交易号，重复通知直接跳过    int inserted = payLogMapper.insertIgnore(        n.getOrderNo(), n.getTradeNo(), n.getAmount());    if (inserted == 0) {        log.info("replay {} {}", n.getOrderNo(), n.getTradeNo());        return;    }    int cas = orderMapper.update(null,        Wrappers.<PayOrder>lambdaUpdate()            .set(PayOrder::getStatus, PAID)            .eq(PayOrder::getOrderNo, n.getOrderNo())            .eq(PayOrder::getStatus, UNPAID));    if (cas == 0) return; // 已处理过，不重复加时长    memberService.grantQuota(n.getUserId(),        n.getQuota(), n.getOrderNo());}

JAVA

// 多租户/角色隔离：注解 + AOP，把条件塞进构造器@Target(ElementType.METHOD) @Retention(RUNTIME)public @interface RequireScope {    String value() default ""; // subject:grade}@Around("execution(* com.edu..*Controller.*(..))")public Object scope(ProceedingJoinPoint pjp) throws Throwable {    RequireScope a = resolve(pjp);    if (a == null) return pjp.proceed();    ScopeHolder.set(SessionUtil.currentScope());    try { return pjp.proceed(); }    finally { ScopeHolder.clear(); }}// Mapper 侧统一包一层，业务代码不用自己记得拼public static <T> LambdaQueryWrapper<T> scoped(        LambdaQueryWrapper<T> w) {    Scope s = ScopeHolder.get();    if (s == null || s.isAll()) return w;    return w.eq(T::getGrade, s.getGrade())            .eq(T::getSubject, s.getSubject());}

JAVASCRIPT

// uniapp 请求封装：统一带幂等键，三端共用一份export function request({ url, method = 'GET',  data = {}, idem = true }) {  const headers = {    'Content-Type': 'application/json',    'X-Token': uni.getStorageSync('token') || '',  };  if (idem && method !== 'GET') {    // 提交类接口带上本次操作号，服务端据此去重    headers['X-Idem-Key'] = uuid();  }  return new Promise((resolve, reject) => {    uni.request({      url: BASE + url, method, data, header: headers,      success: (res) => {        if (res.statusCode === 401) return toLogin();        if (res.data.code !== 0) return reject(res.data);        resolve(res.data.data);      },      fail: (err) => reject(err),    });  });}

VUE

<!-- 后台错题审核列表：分页 + 状态标签 + 操作 --><el-table :data="rows" v-loading="loading" stripe>  <el-table-column prop="stem" label="题干"    min-width="220" show-overflow-tooltip />  <el-table-column prop="subject" label="学科"    width="90" />  <el-table-column prop="grade" label="年级"    width="90" />  <el-table-column label="状态" width="110">    <template #default="{ row }">      <el-tag :type="tagOf(row.status)" size="small">        {{ statusText(row.status) }}      </el-tag>    </template>  </el-table-column>  <el-table-column label="操作" width="150" fixed="right">    <template #default="{ row }">      <el-button type="primary" link        @click="openAudit(row)">审核</el-button>      <el-button type="danger" link        @click="offline(row)">下架</el-button>    </template>  </el-table-column></el-table><el-pagination background layout="total, sizes, prev,  pager, next" :total="total" :page-size="size"  @size-change="onSize" @current-change="onPage" />