questiondaoimpl.java

出试卷系统（包括前台教师出卷系统

package daoImpl;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Collection;

import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import util.JdbcUtil;

import dao.QuestionDAO;
import entity.Question;
import entity.TCExam;
import entity.Theme;

public class QuestionDAOImpl  extends HibernateDaoSupport implements QuestionDAO {

	public void insert(Question question) {
		this.getHibernateTemplate().saveOrUpdate(question);	
	}

	public Question selectBycontext(String context ,Long id) {
		Question intance=new Question();
		Collection<Question> question = getHibernateTemplate()
		.find(
				"from entity.Question q where q.context =?",
				context);
					for(Question qu:question){
				intance=qu;
						}
			return intance;
	}

	public Question selectById(Long id) {
		Question instance = (Question) getHibernateTemplate()
		.find(
				"from entity.Question q where q.id =?",
				id).get(0);
		return instance;
	}

	public Question selectById(int id) {
		Question question = new Question();
		Connection con = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		String sql = "select * from t_question where id=? order by id";
		try {
			con = JdbcUtil.getConnection();
			ps = con.prepareStatement(sql);
			ps.setInt(1, id);
			rs = ps.executeQuery();
			while (rs.next()) {
				question.setId(rs.getLong(1));
				question.setQuestionid(rs.getInt(2));
				question.setContext(rs.getString(3));
				question.setKeya(rs.getString(4));
				question.setKeyb(rs.getString(5));
				question.setKeyc(rs.getString(6));
				question.setKeyd(rs.getString(7));
				question.setKeye(rs.getString(8));
				question.setKeyf(rs.getString(9));
				question.setKeyg(rs.getString(10));	
				question.setAnswer(rs.getString(11));
				question.setPoint(rs.getInt(12));
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			JdbcUtil.release(rs, ps, con);
		}
		return question;
	}
	public static void main(String[] args) {
		QuestionDAOImpl qdao=new QuestionDAOImpl();
		Question question=qdao.selectById(1);
		System.out.println(question.getId());
		System.out.println(question.getQuestionid());
		System.out.println(question.getContext());
		System.out.println(question.getKeya());
		System.out.println(question.getKeya());
		System.out.println(question.getKeya());
		System.out.println(question.getKeya());
		System.out.println(question.getKeya());
		System.out.println(question.getKeya());
		System.out.println(question.getKeya());
		System.out.println(question.getAnswer());
		System.out.println(question.getPoint());
	}
	public int findAll() {
		int n = 0;
		Connection con = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		try {
			con = JdbcUtil.getConnection();
			String sql = "select max(id) from t_anlysis ";
			ps = con.prepareStatement(sql);
			rs = ps.executeQuery();
			while (rs.next()) {
				n = rs.getInt(1);
			}
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			JdbcUtil.release(rs, ps, con);
		}
		return n;
	}
	/**
	 * 插入t_anlysis表，用于教师分析之用
	 */
	public void insertAnlysis( Long studentid, Long exmaid, int themeid, Long questionid,int rightorwrong) {
		Question question = new Question();
		Connection con = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		String sql = "insert into t_anlysis values(?,?,?,?,?,?)";
		try {
			con = JdbcUtil.getConnection();
			ps = con.prepareStatement(sql);
			ps.setInt(1, findAll()+1);
			ps.setLong(2, studentid);
			ps.setLong(3, exmaid);
			ps.setInt(4, themeid);
			ps.setLong(5, questionid);
			ps.setInt(6, rightorwrong);
			ps.executeUpdate();
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			JdbcUtil.release(rs, ps, con);
		}
	}

}