private static boolean modifyPrescription(Prescription bean, PreparedStatement stmt, String field) throws SQLException{
		
		String sql = "UPDATE prescriptions SET "+field+"= ? WHERE presc_id = ?";
		stmt = conn.prepareStatement(sql);
		
		if(field.toLowerCase().equals("dose"))
			stmt.setString(1, bean.getDose());
		if(field.toLowerCase().equals("quantity"))
			stmt.setInt(1, bean.getQuantity());
		if(field.toLowerCase().equals("refill"));
			stmt.setInt(1, bean.getRefill());
		stmt.setInt(2, bean.getPrescriptionID());
			
		int affected = stmt.executeUpdate();
		if (affected == 1) {
			System.out.println("prescription info updated");
			return true;
		} else {
			System.out.println("error: no update applied");
			return false;
		}
	}