public class SaleOrderRptRowMapper implements RowMapper<SaleOrderRpt>{
@Override
public SaleOrderRpt mapRow(ResultSet rs, int rowNum)
throws SQLException {
SaleOrderRpt so = new SaleOrderRpt();
so.setDateStart(rs.getDate("date_start"));
so.setDateEnd(rs.getDate("date_end"));
so.setOrders(rs.getInt("orders"));
so.setProducts(rs.getInt("products"));
so.setTax(rs.getInt("tax"));
so.setTotal(rs.getBigDecimal("total"));
return so;
}