detaildaoimpl.java

oa办公系统

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.DetailDao;
import cn.jx.ecjtu.oa.ps.pojo.Detail;
/**
 * 
 * @todo:DetailDao接口的方法实现类
 * @author 陈智
 * @version $Revision: 1.26 $
 * @since 1.0
 */
public class DetailDaoImpl  extends BaseDao implements DetailDao {

	class ResultSet2Detail implements IResultSetHandler {
		public Object handle(ResultSet rs) throws SQLException {
			return new Detail(rs.getInt("user_id"),
					rs.getString("name"),
					rs.getBoolean("gender"),
					rs.getDate("birthday"),
					rs.getString("address"),
					rs.getString("phone"),
					rs.getString("email"),
					rs.getString("qq"),
					rs.getString("msn")
							);
		}
	}
	private ResultSet2Detail resulSet2Detail=new ResultSet2Detail();
	
	/**
	 * 根据部门ID查询员工记录
	 */
	public List<Detail> findDetailByDepID(int id,int offset,int num,String sql) {
		String language="select top "+(offset+num)+ " oa_user_details.* from oa_user_details,oa_login_user where oa_user_details.user_id=oa_login_user.id  AND oa_login_user.dept_id"+sql+"?";
		List list=dbAccess.executeQuery(language,
				new Object[]{new Integer(id)},
				resulSet2Detail);
		if(list.size()>offset){
			for(int i=0;i<offset;i++){
				list.remove(0);
			}
		}
		else{
			list.clear();
		}
		return list;
	}
	
	/**
	 * 根据员工ID查询员工记录
	 */
	public List<Detail> findDetailById(int user_id,String sql) {
		String language="select * from oa_user_details where user_id"+sql+"?";
		List list=dbAccess.executeQuery(language,
				new Object[]{user_id},
				resulSet2Detail);
		if(list.size()>0) {
			return list;}
		else{ 
			return null;}
	}
	
	public List<Detail> findDetailByLikeName(String name,int offset,int num) {
		List list=dbAccess.executeQuery("select top "+(offset+num)+ " * from oa_user_details where name like ?",
				new Object[]{"%"+name+"%"},
				resulSet2Detail);
		if(list.size()>offset){
			for(int i=0;i<offset;i++){
				list.remove(0);
			}
		}
		else{
			list.clear();
		}
		return list;
	}
	
	public List<Detail> findDetailByName(String name) {
		List list=dbAccess.executeQuery("select * from oa_user_details where name=?",
				new Object[]{new String(name)},
				resulSet2Detail);
		if(list.size()>0) return list;
		else return null;
	}
	
	public List<Detail> findDetailByPhone(String phone) {
		List list=dbAccess.executeQuery("select * from oa_user_details where phone=?",
				new Object[]{new String(phone)},
				resulSet2Detail);
		if(list.size()>0) return list;
		else return null;
	}
	
	public int saveDetail(Detail detail) {
		 return dbAccess.executeUpdate(
				"insert into oa_user_details (user_id,phone,name,gender,address,email,birthday,qq,msn) values (?,?,?,?,?,?,?,?,?)",
				new Object[]{detail.getUser_id(),
						     detail.getPhone(),
						     detail.getName(),
						     detail.getGender(),
						     detail.getAddress(),
						     detail.getEmail(),
						     detail.getBirthday(),
						     detail.getQq(),
						     detail.getMsn()
				});
	}
	 
    /**
     * 查询部门ID为id的所有员工的记录
     * @param id 输入部门ID
     * @return 部门ID为ID的员工记录列表
     */
   public List<Detail> findAllDetailById(int id,String sql){
	   String language="select oa_user_details. * from oa_user_details,oa_login_user where oa_user_details.user_id=oa_login_user.id  AND oa_login_user.dept_id"+sql+"?";
	   List list=dbAccess.executeQuery(language,new Object[]{new Integer(id)},
				resulSet2Detail);
	   if(list.size()>0) return list;
		else return null;
		
    }
    
    /**
     * 根据关键字查找员工记录
     * @param name 关键字
     * @return 名字内包含有name的员工记录的列表
     */
    public List<Detail> findAllDetailByName(String name){
    	List list=dbAccess.executeQuery("select * from oa_user_details where name like ?",
				new Object[]{"%"+name+"%"},
				resulSet2Detail);
		if(list.size()>0) return list;
		else return null;
    }
  
    public int updataDetail(Detail detail){
    	return dbAccess.executeUpdate(
				" update oa_user_details set name=?,gender=?,birthday=?,address=?,phone=?,email=?,qq=?,msn=? where user_id=?",
				new Object[]{detail.getName(),
						     detail.getGender(),
						     detail.getBirthday(),
						     detail.getAddress(),
						     detail.getPhone(),
						     detail.getEmail(),
						     detail.getQq(),
						     detail.getMsn(),
						     detail.getUser_id()
				});
  }
	
}