usercarddaoimpl.java

oa办公系统

/**
 * FileName:UsercardDaoImple.java,v 1.0 created in 2008-11-7 下午02:58:05
 * Created by 吴春辉
 * 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 cn.jx.ecjtu.oa.ps.dao.BaseDao;
import cn.jx.ecjtu.oa.ps.dao.UserCardDao;
import cn.jx.ecjtu.oa.ps.pojo.Group;
import cn.jx.ecjtu.oa.ps.pojo.UserCard;

import com.wanczy.dbutil.IResultSetHandler;
public class UserCardDaoImpl extends BaseDao implements UserCardDao {
	class ResultSet2UserCard implements IResultSetHandler {
		public Object handle(ResultSet rs) throws SQLException {
			return new UserCard(rs.getInt("user_id"),
					            rs.getInt("card_id"),
					            rs.getInt("group_id"),
					            rs.getString("name"),
					            rs.getBoolean("gender"),
					            rs.getDate("birthday"),
					            rs.getString("duty"),
					            rs.getString("company_name"),
					            rs.getString("home_address"),
					            rs.getString("phone"),
					            rs.getString("email"),
					            rs.getString("qq"),
					            rs.getString("msn"));
		}
	}
	private ResultSet2UserCard resultSet2UserCard=new ResultSet2UserCard();

	/* (non-Javadoc)
	 * @see cn.jx.ecjtu.oa.ps.dao.UserCardDao#findUserCardById(int)
	 */
	/**
	 * @todo:以下4个查找
	 * @author  倪扬
	 * @version $Revision: 1.44 $
	 * @since 1.0
	 */
	public List<UserCard> findUserCardById(int user_id,int card_id) {
		List list=dbAccess.executeQuery("select * from oa_postcard where card_id=? and user_id=?",
				new Object[]{new Integer(card_id),new Integer(user_id)},
				resultSet2UserCard);
		if(list.size()>0) return list;
		else return null;
		// TODO Auto-generated method stub
		
	}
	public List<UserCard> findUserCardByName(int user_id,String name) {
		List list=dbAccess.executeQuery("select * from oa_postcard where name=? and user_id=?",
				new Object[]{new String(name),new Integer(user_id)},
				resultSet2UserCard);
		if(list.size()>0) return list;
		else return null;	
		// TODO Auto-generated method stub		
	}
	
	public List<UserCard> findUserCardByPhone(int user_id,String phone) {
		List list=dbAccess.executeQuery("select * from oa_postcard where phone=? and user_id=?",
				new Object[]{new String(phone),new Integer(user_id)},
				resultSet2UserCard);
		if(list.size()>0) return list;
		else return null;
		// TODO Auto-generated method stub
		
	}
	/**
	 * @todo:以联系人名片ID为查询条件模糊查找个人名片
	 * @author 邹勇
	 * @version $Revision: 1.44 $
	 * @since 1.0
	 */
	public List<UserCard> findUserCardByLikeCard_Id(int user_id,String id,int offset,int num) {
		String sql="select top "+(offset+num)+ " * from oa_postcard where card_id like ?"+"AND user_id=?";
		List list=dbAccess.executeQuery(sql,
				new Object[]{new String("%"+id+"%"),new Integer(user_id)},
				resultSet2UserCard);
		if(list.size()>offset){
			for(int i=0;i<offset;i++){
				list.remove(0);
			}
		}
		else{
			list.clear();
		}
		if(list.size()>0) return list;
		else return null;
		
	}
	/**
	 * @todo:以联系人电话为查询条件模糊查找个人名片
	 * @author 邹勇
	 * @version $Revision: 1.44 $
	 * @since 1.0
	 */
	public List<UserCard> findUserCardByLikePhone(int user_id,String phone,int offset,int num) {
		String sql="select top "+(offset+num)+ " * from oa_postcard where phone like ?"+"AND user_id=?";
		List list=dbAccess.executeQuery(sql,
				new Object[]{new String("%"+phone+"%"),new Integer(user_id)},
				resultSet2UserCard);
		if(list.size()>offset){
			for(int i=0;i<offset;i++){
				list.remove(0);
			}
		}
		else{
			list.clear();
		}
		if(list.size()>0) return list;
		else return null;
		
	}
	/**
	 * @todo:以联系人姓名为查询条件模糊查找个人名片
	 * @author 邹勇
	 * @version $Revision: 1.44 $
	 * @since 1.0
	 */
	public List<UserCard> findUserCardByLikeName(int user_id,String name,int offset,int num) {
		String sql="select top "+(offset+num)+ " * from oa_postcard where name like ?"+"AND user_id=?";
		List list=dbAccess.executeQuery(sql,
				new Object[]{new String("%"+name+"%"),new Integer(user_id)},
				resultSet2UserCard);
		if(list.size()>offset){
			for(int i=0;i<offset;i++){
				list.remove(0);
			}
		}
		else{
			list.clear();
		}
		if(list.size()>0) return list;
		else return null;
		
	}
	/**
	 * @todo:根据组ID列出个人名片信息
	 * @author 邹勇
	 * @version $Revision: 1.44 $
	 * @since 1.0
	 */
	public List<UserCard> findUserCardByGroupId(int user_id,int group_id,int offset,int num){
		String sql="select top "+(offset+num)+ " * from oa_postcard where group_id=? and user_id=?";
		List list=dbAccess.executeQuery(sql,
				new Object[]{new Integer(group_id),new Integer(user_id)},
				resultSet2UserCard);
		if(list.size()>offset){
			for(int i=0;i<offset;i++){
				list.remove(0);
			}
		}
		else{
			list.clear();
		}
		if(list.size()>0) return list;
		else return null;
	}
	/**
	 * @todo:以联系人组名为查询条件模糊查找个人名片
	 * @author 邹勇
	 * @version $Revision: 1.44 $
	 * @since 1.0
	 */
	public List<UserCard> findUserCardByLikeGroupName(int user_id,String name,int offset,int num) {
		String sql="select top "+(offset+num)+ " * from oa_postcard where user_id=? and "+"group_id in ("+
		"select group_id from oa_group where group_name like? );";
		List list=dbAccess.executeQuery(sql,
				new Object[]{new Integer(user_id),new String("%"+name+"%")},
				resultSet2UserCard);
		if(list.size()>offset){
			for(int i=0;i<offset;i++){
				list.remove(0);
			}
		}
		else{
			list.clear();
		}
		if(list.size()>0) return list;
		else return null;
		
	}
	/**
	 * @todo:导出组查找
	 * @author 王一沛
	 * @version $Revision: 1.44 $
	 * @since 1.0
	 */
	public List<UserCard> findAllCardById(int user_id,int group_id) {
		List list=dbAccess.executeQuery("select * from oa_postcard where group_id=? and user_id=?",
				new Object[]{new Integer(group_id),new Integer(user_id)}, 
				resultSet2UserCard);
		return list;		
	}
	
	/**
	 * @todo:删除个人名片
	 * @author 曹新星
	 * @version $Revision: 1.44 $
	 * @since 1.0
	 */
	public int removeUserCard(int user_id, int card_id) {

		return dbAccess.executeUpdate("delete from oa_postcard where user_id=? and card_id=?",
				new Object[]{user_id,card_id});
            
	}

	/**
	 * @todo:添加个人名片
	 * @author 谢睿文
	 * @version $Revision: 1.44 $
	 * @since 1.0
	 */
	public int saveUserCard(UserCard usercard) {
		return dbAccess.executeUpdate(
				"insert into oa_postcard (user_id,group_id,name,gender,birthday,duty,company_name,home_address,phone,email,qq,msn) values (?,?,?,?,?,?,?,?,?,?,?,?)",
				new Object[]{usercard.getUser_id(),
					     usercard.getGroup_id(),
					     usercard.getName(),
					     usercard.getGender(),
					     usercard.getBirthday(),
					     usercard.getDuty(),
					     usercard.getCompany_name(),
					     usercard.getHome_address(),
					     usercard.getPhone(),
					     usercard.getEmail(),
					     usercard.getQq(),
					     usercard.getMsn()
					     
			});
	}

	
	/**
	 * @todo:修改个人名片信息
	 * @author 吴春辉 
	 * @version $Revision: 1.44 $
	 * @since 1.0
	 */
	public int updateUserCard(UserCard usercard) {
		return dbAccess.executeUpdate(
				"update oa_postcard set group_id=?,name=?,gender=?,birthday=?,duty=?,company_name=?,home_address=?,phone=?,email=?,qq=?,msn=? where card_id=?",
				new Object[]{
						     
						     usercard.getGroup_id(),
						     usercard.getName(),
						     usercard.getGender(),
						     new java.sql.Date(usercard.getBirthday().getTime()),
						     usercard.getDuty(),
						     usercard.getCompany_name(),
						     usercard.getHome_address(),
						     usercard.getPhone(),
						     usercard.getEmail(),
						     usercard.getQq(),
						     usercard.getMsn(),	
						     usercard.getCard_id()});	
		//user_id=?,usercard.getUser_id(),
	}
	/**
	 * @todo:列出个人名片信息
	 * @author 吴春辉 
	 * @version $Revision: 1.44 $
	 * @since 1.0
	 */
	public List<UserCard> findusercardByOwner(int ownerId,int groupId){
		return dbAccess.executeQuery("select * from oa_postcard where user_id=? and group_id=?",
				new Object[] { ownerId,groupId }, resultSet2UserCard);
	}
}