questiondao.java

accp s1毕业项目 考试管理系统

package com.exam.db.dao;

import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import com.exam.db.bean.Question;
import com.yutang.dboption.DBOption;
import com.yutang.dboption.IPreparedStatementSetter;

public class QuestionDao {
	List<Question> list = new ArrayList<Question>();
	DBOption<Question> db = new DBOption<Question>();
	Question question = new Question();
	
	public int insertQuestion(final Question question) {
		int result = 0;
		db.setCon(MyConnection.getConnection(QuestionDao.class));
		String sql = "insert into Question values(?,?,?,?,?,?,?)";
		result = db.save(sql, new IPreparedStatementSetter() {
			public PreparedStatement setValues(PreparedStatement pst)
					throws SQLException {
				pst.setInt(1, question.getCouID());
				pst.setString(2, question.getQueType());
				pst.setString(3, question.getQuestion());
				pst.setString(4, question.getAnswer());
				pst.setString(5, question.getRightAnswer());
				pst.setString(6, question.getTeaID());
				pst.setInt(7, question.getMark());
				return pst;
			}
		});
		db.closeCon();
		return result;
	}

	// 随机选题
	public List<Question> selectQuestion(final int couID) {	
		db.setCon(MyConnection.getConnection(QuestionDao.class));
		String sql = "select top 20 * from Question where CouID = ? order by newid()";
		list = db.queryAll(sql, question, new IPreparedStatementSetter() {
			public PreparedStatement setValues(PreparedStatement pst)
					throws SQLException {
				pst.setInt(1, couID);
				return pst;
			}

		});
		return list;
	}

	// 根据科目选择试题
	public List<Question> selectQuestionByCouID(final int couID) {
		db.setCon(MyConnection.getConnection(QuestionDao.class));
		String sql = "select * from Question where CouID = ?";
		list = db.queryAll(sql, question, new IPreparedStatementSetter() {
			public PreparedStatement setValues(PreparedStatement pst)
					throws SQLException {
				pst.setInt(1, couID);
				return pst;
			}
		});
		return list;
	}

	// 根据编号选择试题
	public Question selectQuestionByQueID(final int queID) {
		db.setCon(MyConnection.getConnection(QuestionDao.class));
		String sql = "select * from Question where QueID = ?";
		question = db.queryOne(sql, question, new IPreparedStatementSetter(){
			public PreparedStatement setValues(PreparedStatement pst)
					throws SQLException {
				pst.setInt(1, queID);
				return pst;
			}			
		});
		return question;
	}
}