public Medicine findMedicine(int id) {
        String query = "SELECT * FROM `medicine` WHERE `id` = %d LIMIT 1;";
        Utils.DBA dba = Helper.getDBA();
        Medicine m = new Medicine();
        try {
            ResultSet rs = dba.executeQuery(String.format(query, id));
            rs.next();
            m.setID(rs.getInt("id"));
            m.setName(rs.getString("name"));
            m.setCost(rs.getInt("cost"));
        } catch (SQLException sqlEx) {
            Helper.logException(sqlEx);
        }
        return m;
    }