public class SaleOrderByTitleRptRowMapper implements RowMapper<SaleOrderByTitleRpt>{
@Override
public SaleOrderByTitleRpt mapRow(ResultSet rs, int rowNum) throws SQLException {
SaleOrderByTitleRpt sotr = new SaleOrderByTitleRpt();
sotr.setDateStart(rs.getDate("date_start"));
sotr.setDateEnd(rs.getDate("date_end"));
sotr.setTitle(rs.getString("title"));
sotr.setOrders(rs.getInt("orders"));
sotr.setTotal(rs.getBigDecimal("total"));
return sotr;
}