persondao.java

房屋出租,jsp房屋出租系统,可以注册添加出租/修改/删除信息,用户可搜索房源

package com.svse.dao;

import java.sql.Date;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.List;

import com.svse.model.Person;
import com.svse.util.DBHelper;

public class PersonDAO extends BaseDao{
	private List<Person> list;
	
	/*************************
	 * @author Denis Zhou
	 * @remark 查找所有用户
	 * @return
	 * @throws ClassNotFoundException
	 * @throws SQLException
	 */
	public List<Person> getAll() throws ClassNotFoundException, SQLException
	{
		list = new ArrayList<Person>();
		String sql = "select * from t_per order by p_id desc";
		try {
			conn = DBHelper.getConn();
			ps = conn.prepareStatement(sql);
			rs = ps.executeQuery();
			while(rs.next())
			{
				Person p = new Person();
				p.setP_id(rs.getInt("p_id"));
				p.setP_name(rs.getString("p_name"));
				p.setP_password(rs.getString("p_password"));
				list.add(p);
			}
		} catch (ClassNotFoundException e) {
			throw e;
		} catch (SQLException e) {
			throw e;
		}finally
		{
			closeResourse(ps, rs);
			DBHelper.closeConn(conn);
		}
		return list;
	}
	
	/***********************
	 * @author Denis Zhou
	 * @remark 通过用户名查找用户
	 * @param per
	 * @return
	 * @throws ClassNotFoundException
	 * @throws SQLException
	 */
	public Person get_name(Person per) throws ClassNotFoundException, SQLException
	{
		Person p =null;
		String sql = "select * from t_per where p_name = ?";
		try {
			conn = DBHelper.getConn();
			ps = conn.prepareStatement(sql);
			ps.setString(1, per.getP_name());
			rs = ps.executeQuery();
			while(rs.next())
			{
				p = new Person();
				p.setP_id(rs.getInt("p_id"));
				p.setP_name(rs.getString("p_name"));
				p.setP_password(rs.getString("p_password"));
			}
		} catch (ClassNotFoundException e) {
			throw e;
		} catch (SQLException e) {
			throw e;
		}finally
		{
			closeResourse(ps, rs);
			DBHelper.closeConn(conn);
		}
		return p;
	}
	
	/*******************
	 * @author Denis Zhou
	 * @remark 返回表中最大的p_id号
	 * @return
	 * @throws SQLException 
	 * @throws ClassNotFoundException 
	 */
	public int getCount() throws ClassNotFoundException, SQLException
	{
		try{
			list = getAll();
			count = list.get(0).getP_id();		
		} catch (ClassNotFoundException e) {
			throw e;
		} catch (SQLException e) {
			throw e;
		}finally
		{
			closeResourse(ps, rs);
			DBHelper.closeConn(conn);
		}
		return count;
	}
	
	/**********************
	 * @author Denis Zhou
	 * @remark  新用户注册——添加新用户
	 * @param per
	 * @return 是否添加成功
	 * @throws ClassNotFoundException
	 * @throws SQLException
	 */
	public boolean addPer(Person per) throws ClassNotFoundException, SQLException
	{
		boolean isFlat = false;
		try{
			count = getCount();
			String sql = "insert into t_per values(?,?,?)";	
			conn = DBHelper.getConn();	
			ps = conn.prepareStatement(sql);
			ps.setInt(1, count+1);
			ps.setString(2, per.getP_name());
			ps.setString(3, per.getP_password());
			int i = ps.executeUpdate();
			if(i >0)
			{
				isFlat = true;
			}
		} catch (ClassNotFoundException e) {
			throw e;
		} catch (SQLException e) {
			throw e;
		}finally
		{
			closeResourse(ps, rs);
			DBHelper.closeConn(conn);
		}
		return isFlat;		
	}	
}