#71 Add setters for datePattern and dateTimePattern on ResultSetHelper

[Arend v. Reinersdorff]

I just used custom date patterns with CSVWriter. It's nice that this is possible in opencsv. But one has to to iterate over the ResultSet oneself:

// current code using custom date patterns
CSVWriter csvWriter = new CSVWriter(writer);
ResultSetHelper resultSetHelper = new ResultSetHelperService();
csvWriter.writeNext(resultSetHelper.getColumnNames(rs));
while (rs.next()) {
    String datePattern = "dd.MM.yyyy";
    String dateTimePattern = "dd.MM.yyyy HH:mm:ss";
    csvWriter.writeNext(resultSetHelper.getColumnValues(rs, false, datePattern, dateTimePattern));
}

It would be nice if ResultSetHelper (or the default implementation ResultSetHelperService) had setters for the date patterns. So CSVWriter could do the iteration over the ResultSet with writeAll():

// requested code with date pattern setters
CSVWriter csvWriter = new CSVWriter(writer);
ResultSetHelper resultSetHelper = new ResultSetHelperService();
resultSetHelper.setDatePattern("dd.MM.yyyy");
resultSetHelper.setDateTimePattern("dd.MM.yyyy HH:mm:ss");
csvWriter.setResultSetHelper(resultSetHelper);
csvWriter.writeAll(rs, true);

[Scott Conway]

Done - new methods to ResultSetHelperServce have been merged to trunk and will be in the 3.6 release.

[Arend v. Reinersdorff]

Great, thanks a lot :-)