mysql数据库随机_mysql数据库随机生成某个范围内的数据

一、完成内容

1. 根据组卷规则随机生成试题

2. 获取考生答案，计算分数

3. 判断答案正误，错题存到错题表

4. 判断考试是否第一次答题，若不是，使用第一次生成的试题

二、功能截图

三、核心代码

/**

* @param context 页面传过来的题号及其对应的答案，形式是 题号:ABCD*/@OverridepublicInteger stuTest(String testId, String context, String stuname) {//TODO Auto-generated method stub//声明一个变量分数

int rightNum =0;

String bids="";//处理答案，计算分数//1.处理文本

String str[] = context.split(",");for (int i = 0; i < str.length; i++) {//获取对应的试题id

String bid = str[i].substring(0, str[i].indexOf(":"));//获取对应答案

String answer= str[i].substring(str[i].indexOf(":")+1);//根据bid查询出题库中正确的答案

ItemBank itemBank = itemBankDao.selectByBid(newInteger(bid));//判断答案是否一致

answer = answer.replaceAll(" ", "");

String itemBankAnswer= itemBank.getAnswer().replace(" ", "");if(answer.equalsIgnoreCase(itemBankAnswer)) {

rightNum=rightNum+1;

System.out.println("rightNum>>>"+rightNum);

}else{//查询判断是否含有此bid

MisCollection collection = misCollectionDao.selectByStuname(newInteger(stuname));if(collection!=null) {

String misbids=collection.getBids();if(!misbids.contains(bid)) {

misbids+=","+bid;

misCollectionDao.update(misbids,newInteger(stuname));

}

}else{//第一次做题

if(i==0) {

bids=bid;

}else{

bids+=","+bid;

}//将错题存到表中

misCollectionDao.add(bids,newInteger(stuname));

}

}

}

Double score= (double)((rightNum/str.length)*100);//将分数，答案更新到试卷表(testpaper)

return testPaperDao.updateScoreAndAnswer(score,context,new Integer(testId),newInteger(stuname));

}

四、数据库随机范围查询

SELECT * FROM itembank

WHERE bid >= (SELECT floor((select MIN(bid) from itembank where subid=#{0})+RAND() * (SELECT MAX(bid) FROM itembank where subid=#{0})))

ORDER BY bid LIMIT #{1}