public void doA02(MsgParse mp)
            throws SQLException {
        if (!mp.visit.getPatient_class().isEmpty())
        try {
        //get the current location from the visit table for patient                     
        //update table -- prior location gets value of current location
        //update table -- current location gets value from the A02 message
            PreparedStatement prepStmt = connection.prepareStatement(
                    "update visit "
                            + "set prior_location = ?, location = ? "
                            + "where location = ? "
                            + "AND admit_date = ?");
            
            prepStmt.setString(1, mp.visit.getPrior_location());
            prepStmt.setString(2, mp.visit.getLocation());
            prepStmt.setString(3, mp.visit.getPrior_location());
            prepStmt.setString(4, mp.visit.getAdmit_date());
            prepStmt.executeUpdate();

            prepStmt.close();
        } catch (SQLException se) {
            System.out.println("Error in DBLoader.doA02: " + se);
        }
    }//doA02