teacherdaoimpl.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.TeacherDAO;
import entity.Teacher;

public class TeacherDAOImpl extends HibernateDaoSupport implements TeacherDAO {

	public Teacher selectAll() {
		return null;
	}

	public Teacher selectTeacherByTeacher(String loginName, String loginPassword) {

		String hqlName = "from Teacher t where t.login_name=:loginName and t.login_password=:loginPassword";
		String[] argNames = new String[] { "loginName", "loginPassword" };
		String[] argValues = new String[] { loginName, loginPassword };
		Teacher teacher = (Teacher) this.getHibernateTemplate()
				.findByNamedParam(hqlName, argNames, argValues).get(0);
		System.out.println("********88"+teacher);
		
		return teacher;
	}
	public Collection<Teacher> selectAllTeacher() {
		List<Teacher> teachers = new ArrayList<Teacher>();
		Connection con = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		String sql = "select * from t_teacher order by id";
		try {
			con = JdbcUtil.getConnection();
			ps = con.prepareStatement(sql);
			rs = ps.executeQuery();
			while (rs.next()) {
				Teacher teacher = new Teacher();
				teacher.setId(rs.getLong(1));
				teacher.setTname(rs.getString(2));
				teacher.setLogin_name(rs.getString(3));
				teacher.setLogin_password(rs.getString(4));
				teachers.add(teacher);
			}
		} catch (SQLException e) {
			e.printStackTrace();
			if (con != null) {
				try {
					con.rollback();
				} catch (SQLException e1) {
					e1.printStackTrace();
				}
			}
		} finally {
			JdbcUtil.release(rs, ps, con);
		}
		return teachers;
	}
public Teacher selectTeacherByTName(String tname) {
	Connection con = null;
	PreparedStatement ps = null;
	ResultSet rs = null;
	Teacher teacher = new Teacher();
	String sql = "select * from t_teacher t where t.tname=?";
	try {
		con = JdbcUtil.getConnection();
		ps = con.prepareStatement(sql);
		ps.setString(1, tname);
		rs = ps.executeQuery();
		while (rs.next()) {
			teacher.setId(rs.getLong(1));
			teacher.setTname(rs.getString(2));
			teacher.setLogin_name(rs.getString(3));
			teacher.setLogin_password(rs.getString(4));
		}
	} catch (Exception e) {
		e.printStackTrace();
	} finally {
		JdbcUtil.release(rs, ps, con);
	}
	return teacher;
}
}