public PersonBean getPersonInfo(String userid){
		PersonBean person=null;
		ResultSet rs = null;
		Connection con = null;
		PreparedStatement ps = null;
		boolean result = true;
		
		try {
			String sql = "SELECT * FROM PERSON WHERE userid=(?)";
			con = ConnectionPool.getConnectionFromPool();
			ps = con.prepareStatement(sql);
			ps.setString(1, userid);
			rs = ps.executeQuery();
			if(rs.next()){
				person=new PersonBean();
				person.setId(rs.getInt("ID"));
				person.setFname(rs.getString("FNAME"));
				person.setLname(rs.getString("LNAME"));
				person.setAddress(rs.getString("ADDRESS"));
				person.setUserid(rs.getString("USERID"));
				person.setType(rs.getString("TYPE"));
			}
		} catch (Exception ex) {
			ex.printStackTrace();
		} finally {
			if (rs != null) {
				try {
					rs.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
			}
			if (ps != null) {
				try {
					ps.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
			}
			if (con != null) {
				try {
					ConnectionPool.addConnectionBackToPool(con);
				} catch (Exception e) {
					e.printStackTrace();
				}
			}
		}
		
		return person;
	}