package com.jspdev.ch13;
import java.util.*;
import com.jspdev.util.*;
import java.sql.*;
public class ContactBean
{
	private Connection conn;
	Vector v;
	public ContactBean()throws Exception
	{
		conn=DatabaseConn.getConnection();
		v=new Vector();
	}
	public int getAvailableCount()throws Exception
	{
		int ret=0;
		Statement stmt=conn.createStatement();
		String strSql="select count(*) from contact";
		ResultSet rset=stmt.executeQuery(strSql);
		while(rset.next())
		{
			ret=rset.getInt(1);
		}
		return ret;		
		
	}
	public PageBean listData(String page)throws Exception
	{
		try
		{
			PageBean pageBean=new PageBean(this);
			int pageNum=Integer.parseInt(page);
			Statement stmt=conn.createStatement();
			String strSql="select top "+pageNum*pageBean.rowsPerPage+" * from contact order by userName";
			ResultSet rset=stmt.executeQuery(strSql);
			int i=0;
			while(rset.next())
			{
				if(i>(pageNum-1)*pageBean.rowsPerPage-1)
				{
					
					Object[] obj=new Object[6];
					obj[0]=rset.getString("userName");
					obj[1]=new Integer(rset.getInt("mobile"));
					obj[2]=rset.getString("phone");
					obj[3]=rset.getString("mail");
					obj[4]=rset.getDate("lastcontact");
					obj[5]=rset.getString("mem");
					v.add(obj);
				}
				i++;
			}
			
			rset.close();
			stmt.close();

			pageBean.curPage=pageNum;
			pageBean.data=v;
			return pageBean;
		}
		catch(Exception e)
		{
		   	e.printStackTrace();
			throw e;
			
		}
	}
	public Vector getResult()throws Exception
	{
		//listDate("2");
		return v;
	}
}