coursedaoimpl.java

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

package daoImpl;

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

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

import util.JdbcUtil;
import dao.CourseDAO;
import entity.Course;
import entity.Paper;

public class CourseDAOImpl extends HibernateDaoSupport implements CourseDAO {

	public Collection<Course> selectAll() {
		String hql = "from Course c";
		return this.getHibernateTemplate().find(hql);
	}

	public Course selectByName(String name) {
		Course instance = (Course) getHibernateTemplate()
		.find(
				"from entity.Course c where c.name =?",
				name).get(0);
		return instance;
	}

	public Course selectById(Long id) {
		Course instance = (Course) getHibernateTemplate()
		.find(
				"from entity.Course c where c.id =?",
				id).get(0);
		System.out.print("DAO"+instance.getName());
		return instance;
		
	}

	public Collection<Course> selectAllCourse() {
		List<Course> courses = new ArrayList<Course>();
		Connection con = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		String sql = "select * from t_course order by id";
		try {
			con = JdbcUtil.getConnection();
			ps = con.prepareStatement(sql);
			rs = ps.executeQuery();
			while (rs.next()) {
				Course course = new Course();
				course.setId(rs.getLong(1));
				course.setName(rs.getString(2));
				courses.add(course);
			}
		} catch (SQLException e) {
			e.printStackTrace();
			if (con != null) {
				try {
					con.rollback();
				} catch (SQLException e1) {
					e1.printStackTrace();
				}
			}
		} finally {
			JdbcUtil.release(rs, ps, con);
		}
		return courses;
	}

	public Course selectCourseByName(String name) {

		Connection con = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		Course course = new Course();
		String sql = "select * from t_course c where c.name=?";
		try {
			con = JdbcUtil.getConnection();
			ps = con.prepareStatement(sql);
			ps.setString(1, name);
			rs = ps.executeQuery();
			while (rs.next()) {
				course.setId(rs.getLong(1));
				course.setName(rs.getString(2));
			}
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			JdbcUtil.release(rs, ps, con);
		}
		return course;
	}
}