private static Employee getEmployee(Employee bean, PreparedStatement stmt, ResultSet rs) throws SQLException{
		
		stmt.setString(1, bean.getUsername());
		rs = stmt.executeQuery();
		
		if (rs.next()) {
			Employee newBean = new Employee();
			newBean.setName(rs.getString("name"));
			newBean.setUsername(rs.getString("username"));
			newBean.setPass(rs.getString("pass"));
			newBean.setDob(rs.getDate("dob"));
			newBean.setPhone(rs.getString("phone"));
			newBean.setAddress(rs.getString("address"));
			newBean.setEmail(rs.getString("email"));
			newBean.setPosition(rs.getString("position"));
			return newBean;
		} else {
			System.out.println("unable to retrieve Employee info");
			return null;
		}
	}