deptdaoimpl.java

oa办公系统

/**
 * FileName:DeptDaoImpl.java,v 1.0 created in 2008-11-7 下午03:29:48
 * Created by luomin
 * Copyright (c) 2008 ecjtu
 * All Rights Reserved.
 */
package cn.jx.ecjtu.oa.ps.dao.impl;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;

import com.wanczy.dbutil.IResultSetHandler;

import cn.jx.ecjtu.oa.ps.dao.BaseDao;
import cn.jx.ecjtu.oa.ps.dao.DeptDao;
import cn.jx.ecjtu.oa.ps.pojo.Dept;

/**
 * @todo:Description
 * @author luomin
 * @version $Revision: 1.4 $
 * $ Revisior:1.0 $
 * @since 1.0
 */
public class DeptDaoImpl extends BaseDao implements DeptDao{
	class ResultSet2Dept implements IResultSetHandler {
		public Object handle(ResultSet rs) throws SQLException {
			return new Dept (rs.getInt("dept_id"),
					rs.getString("name"),
					rs.getInt("manager_id"),
					rs.getString("address"),
					rs.getString("phone"),
					rs.getString("fax"),
					rs.getInt("predept_id"),
					rs.getString("duty"),
					rs.getInt("sort_number"));
		}
	}
	private ResultSet2Dept resultSet2Dept=new ResultSet2Dept();
	/**
	 * 获取所有部门的信息放置于部门列表中
	 */
	public List<Dept> findAllDept() {
		List list=dbAccess.executeQuery("select * from oa_department order by sort_number",
				resultSet2Dept);
		return list;
	}
	/**
	 * 根据部门的id查询部门的信息
	 */
	public Dept findDeptInfoByID(int dept_id) {
		List list=dbAccess.executeQuery("select * from oa_department where dept_id=?",
				new Object[]{new Integer(dept_id)},
				resultSet2Dept);
		if(list.size()>0) return (Dept)list.get(0);
		else return null;
	}
	/**
	 * 根据部门id删除部门
	 */
	public int removeDept(int dept_id) {
		return dbAccess.executeUpdate("delete from oa_department where dept_id=?",
				new Object[]{new Integer(dept_id)});
	}
	/**
	 * 增加部门
	 */
	public int saveDept(Dept dept) {
		return dbAccess.executeUpdate(
				"insert into oa_department (name,manager_id,address," +
				"phone,fax,predept_id,duty,sort_number) values (?,?,?,?,?,?,?,?)",
				new Object[]{dept.getName(),
						dept.getManager_id(),
						dept.getAddress(),
						dept.getPhone(),
						dept.getFax(),
						dept.getPredept_id(),
						dept.getDuty(),
						dept.getSort_number()});
	}
	/**
	 * 修改部门的信息
	 */
	public int updateDept(Dept dept) {
		return dbAccess.executeUpdate(
				"update oa_department set name=?,manager_id=?,address=?," +
				"phone=?,fax=?,predept_id=?,duty=?,sort_number=? where dept_id=?",
				new Object[]{dept.getName(),
						dept.getManager_id(),
						dept.getAddress(),
						dept.getPhone(),
						dept.getFax(),
						dept.getPredept_id(),
						dept.getDuty(),
						dept.getSort_number(),
						dept.getDept_id()});
	}

}