managerdaoimpl.java

oa办公系统

/**
 * FileName:ManagerDaoImpl.java,v 1.0 created in 2008-11-7 下午02:46:11
 * 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 com.wanczy.dbutil.IResultSetHandler;

import cn.jx.ecjtu.oa.ps.dao.BaseDao;
import cn.jx.ecjtu.oa.ps.dao.ManagerDao;
import cn.jx.ecjtu.oa.ps.pojo.Manager;

/**
 * ManagerDao的实现类
 * @author luomin
 * @version $Revision: 1.2 $
 * $ Revisior:1.0 $
 * @since 1.0
 */
public class ManagerDaoImpl extends BaseDao implements ManagerDao{
	class ResultSet2Manager implements IResultSetHandler {
		public Object handle(ResultSet rs) throws SQLException {
			return new Manager(rs.getInt("dept_id"),
					rs.getString("dept_name"),
					rs.getInt("user_id"),
					rs.getString("user_name"));
		}
	}
	private ResultSet2Manager resultSet2Manager=new ResultSet2Manager();
	/**
	 * 设置部门经理
	 */
	public int setManager(int dept_id, int manager_id) {
		return dbAccess.executeUpdate(
				"update oa_department set manager_id=? where dept_id=?",
				new Object[]{new Integer(manager_id),
						new Integer(dept_id)});
	}

}