empdaoimpl.java

来自「初学者的struts 的基本应用 包含struts action的 和 stru」· Java 代码 · 共 59 行

package com.accp.daoimpl;

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

import com.accp.dao.EmpDAO;
import com.accp.entity.Dept;
import com.accp.entity.Emp;

public class EmpDAOImpl extends DAOBase implements EmpDAO {

	@Override
	public ArrayList searchEmp(Emp emp) {

		super.getConn();
		Object[] paras = new Object[3];
		int n = 0;
		ArrayList arr = new ArrayList();
		String sql = "SELECT * FROM emp WHERE 1=1 ";
		String ename = emp.getEname();
		String job = emp.getJob();
		Long deptNo = emp.getDeptNo();
		if( !ename.equals("")){
			sql += "AND ename =? ";
			paras[n++] = emp.getEname();
		}
		if( !job.equals("")){
			sql += "AND job =? ";
			paras[n++] = emp.getJob();
		}
		if( !deptNo.equals("")){
			sql += "AND deptNo =? ";
			paras[n++] = emp.getDeptNo();
		}
		
		
		try {
			pstmt = conn.prepareStatement(sql);
			super.setParas(n, paras, pstmt);
			rs = pstmt.executeQuery();
			Emp empBean = null;
			while(rs.next()){
				empBean = new Emp();
				empBean.setEmpno(rs.getLong("Empno"));
				empBean.setEname(rs.getString("Ename"));
				empBean.setSal(rs.getDouble("Sal"));
				arr.add(empBean);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			super.closeConn();
		}
		return arr;
	}

}