public void set_Patient(MsgParse mp)
            throws SQLException {
        try {

            PreparedStatement prepStmt = connection.prepareStatement(
                    "insert into patient (mrn, last_name, first_name, birth_date, sex_code, ethnic_code, address_line1, address_line2,"
                            + "address_city, address_state, address_zip, home_phone, work_phone, marital_code, religion_code, ssn) "
                            + "values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");

            prepStmt.setString(1, mp.patient.getMRN());
            prepStmt.setString(2, mp.patient.getLastName());
            prepStmt.setString(3, mp.patient.getFirstName());
            prepStmt.setString(4, mp.patient.getBirthDate());
            prepStmt.setString(5, mp.patient.getSexCd());
            prepStmt.setString(6, mp.patient.getEthnicCd());
            prepStmt.setString(7, mp.patient.getAddress1());
            prepStmt.setString(8, mp.patient.getAddress2());
            prepStmt.setString(9, mp.patient.getCity());
            prepStmt.setString(10, mp.patient.getState());
            prepStmt.setString(11, mp.patient.getZip());
            prepStmt.setString(12, mp.patient.getHomePhone());
            prepStmt.setString(13, mp.patient.getWorkPhone());
            prepStmt.setString(14, mp.patient.getMaritalCd());
            prepStmt.setString(15, mp.patient.getReligionCd());
            prepStmt.setString(16, mp.patient.getSSN());      

            prepStmt.execute();

            //Get max PID that we just inserted so we can use it as FK in Visit Insert
            prepStmt = connection.prepareStatement("select max(pid) from patient");
            ResultSet rs = prepStmt.executeQuery();
            while (rs.next()){
                patientId = rs.getInt(1);
                System.out.println("MAX PID: " + patientId);
            }
            
            prepStmt.close();
        } catch (SQLException se) {
            System.out.println("Error in DBLoader.set_Patient: " + se);
        }
    }