bookdao.java

jsp/servlet/javaBean:通讯录

package common;

import java.sql.*;
import java.util.*;
import entity.BookBean;

public class BookDao {
	
	BaseDao base=new BaseDao();
	String sql=null;
	PreparedStatement psmt=null;
	ResultSet rest=null;
	List book=new ArrayList();
		
	// 显示通讯录
	public List getBook(String rel,String id){
		Connection conn=null;
		try{
			conn=base.getConn();
			if(rel!=null && id!=null){
				sql="select * from BOOK where relation=? and userId=?";
				psmt=conn.prepareStatement(sql);
				psmt.setString(1,rel);
				psmt.setString(2,id);
			}
			else if(rel==null && id!=null){
				sql="select * from BOOK where userId=?";
				psmt=conn.prepareStatement(sql);
				psmt.setString(1,id);
			}
			rest=psmt.executeQuery();
			while(rest.next()){
				BookBean bean=new BookBean();
				bean.setId(rest.getInt(1));
				bean.setName(rest.getString(2));
				bean.setSex(rest.getString(3));
				bean.setPhone(rest.getString(4));
				bean.setMobilePhone(rest.getString(5));
				book.add(bean);
			}			
		}catch(SQLException se){
			se.printStackTrace();
			System.out.println(se.getMessage());
		}
		finally{
			base.closeConn(conn, psmt, rest);
		}
		return book;
	}
	
	// 添加联系人
	public int addBook(BookBean bean){
		Connection conn=null;
		int i=0;
		try{
			conn=base.getConn();
			sql="insert BOOK values(?,?,?,?,?,?)";
			String[] param={bean.getName(),bean.getSex(),bean.getPhone(),bean.getMobilePhone(),
					String.valueOf(bean.getRelation()),String.valueOf(bean.getUserId())};
			i=base.changeDB(sql, param);
		}catch(Exception se){
			se.printStackTrace();
			System.out.println(se.getMessage());
		}
		finally{
			base.closeConn(conn, psmt, rest);
		}
		return i;
	}
}