empadddao.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.EmpAddForm;

public class EmpAddDAO extends BaseDAO {

	private static final String QUERY = "insert into emp(emp_id, emp_name, emp_sex, dept_id, salary) "
			+ "values(seq_emp_id.nextval, ?, ?, ?, ?)";

	private EmpAddForm frm;

	private boolean result = false;

	public EmpAddDAO(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()};

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

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

	public boolean isResult() {
		return result;
	}

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

}