empupdatedao.java

员工管理系统

package com.yiboit.hhs.daos;

import java.sql.SQLException;

import javax.sql.DataSource;

import com.yiboit.hhs.db.BaseDAO;
import com.yiboit.hhs.form.EmpUpdateForm;

public class EmpUpdateDAO extends BaseDAO {
	private static final String QUERY = "update emp set emp_name = ?" +
			", emp_sex = ?, dept_id = ?, salary = ? " +
			" where emp_id = ? ";

	private EmpUpdateForm frm;

	private boolean result = false;

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

	@Override
	public void databaseAccess() throws SQLException {
		try {
			Object[] param = new Object[] { frm.getEmpName(), frm.getEmpSex(),
					frm.getDeptId(), frm.getSalary(), frm.getEmpId() };

			int res = sqlUtil.update(QUERY, param);

			result = res == 1 ? true : false;
		} finally {
			sqlUtil.close();
		}
	}

	public boolean isResult() {
		return result;
	}

	public void setFrm(EmpUpdateForm frm) {
		this.frm = frm;
	}
}