empdeldao.java

员工管理系统

package com.yiboit.hhs.daos;

import java.sql.SQLException;

import javax.sql.DataSource;

import com.yiboit.hhs.db.BaseDAO;

public class EmpDelDAO extends BaseDAO {
	private static final String QUERY = "delete from emp where emp_id = ?";

	// 输入参数
	private String empId;
	// 输出参数
	private boolean result;

	public boolean isResult() {
		return result;
	}

	public void setEmpId(String empId) {
		this.empId = empId;
	}

	public EmpDelDAO(DataSource ds) throws SQLException {
		super(ds);
	}

	@Override
	public void databaseAccess() throws SQLException {
		Object[] param = new Object[] { empId };
		int res = super.sqlUtil.update(QUERY, param);
		this.result = res == 1 ? true : false;
	}
}