private static boolean insertPrescription(Prescription bean, PreparedStatement stmt) throws SQLException{
		
		stmt.setDate(1, bean.getStartDate());
		stmt.setDate(2, bean.getThisDay());
		stmt.setString(3, bean.getDose());
		stmt.setInt(4, bean.getQuantity());
		stmt.setInt(5, bean.getRefill());
		stmt.setDate(6, bean.getExpirationDate());
		stmt.setBoolean(7, bean.getPayStatus());
		stmt.setInt(8, bean.getDid());
		stmt.setInt(9, bean.getPid());

		int affected = stmt.executeUpdate();
		if(affected == 1){
			System.out.println("new prescription added successfully");
		}else{
			System.out.println("error adding prescription");
			return false;
		}
		return true;
	}