private static boolean modifyPatient(Patient bean, PreparedStatement stmt, String field) throws SQLException{
		
		String sql = "UPDATE patients SET "+field+"= ? WHERE pid = ?";
		
		stmt = conn.prepareStatement(sql);
		
		if(field.toLowerCase().equals("primarydoc"))
			stmt.setString(1, bean.getPrimaryDoc());
		if(field.toLowerCase().equals("phone"))
			stmt.setString(1, bean.getPhone());
		if(field.toLowerCase().equals("address"))
			stmt.setString(1, bean.getAddress());
		if(field.toLowerCase().equals("city"))
			stmt.setString(1, bean.getCity());
		if(field.toLowerCase().equals("state"))
			stmt.setString(1, bean.getState());
		if(field.toLowerCase().equals("zip"))
			stmt.setString(1, bean.getZip());
		stmt.setInt(2, bean.getPid());
			
		int affected = stmt.executeUpdate();
		if (affected == 1) {
			System.out.println("patient info updated");
			return true;
		} else {
			System.out.println("error: no update applied");
			return false;
		}
	}