class OrderItemFieldSetMapper implements FieldSetMapper<LineItem> {

	public static final String TOTAL_PRICE_COLUMN = "TOTAL_PRICE";

	public static final String QUANTITY_COLUMN = "QUANTITY";

	public static final String HANDLING_PRICE_COLUMN = "HANDLING_PRICE";

	public static final String SHIPPING_PRICE_COLUMN = "SHIPPING_PRICE";

	public static final String DISCOUNT_AMOUNT_COLUMN = "DISCOUNT_AMOUNT";

	public static final String DISCOUNT_PERC_COLUMN = "DISCOUNT_PERC";

	public static final String PRICE_COLUMN = "PRICE";

	public static final String ITEM_ID_COLUMN = "ITEM_ID";

	@Override
	public LineItem mapFieldSet(FieldSet fieldSet) {<FILL_FUNCTION_BODY>}

}

		LineItem item = new LineItem();

		item.setItemId(fieldSet.readLong(ITEM_ID_COLUMN));
		item.setPrice(fieldSet.readBigDecimal(PRICE_COLUMN));
		item.setDiscountPerc(fieldSet.readBigDecimal(DISCOUNT_PERC_COLUMN));
		item.setDiscountAmount(fieldSet.readBigDecimal(DISCOUNT_AMOUNT_COLUMN));
		item.setShippingPrice(fieldSet.readBigDecimal(SHIPPING_PRICE_COLUMN));
		item.setHandlingPrice(fieldSet.readBigDecimal(HANDLING_PRICE_COLUMN));
		item.setQuantity(fieldSet.readInt(QUANTITY_COLUMN));
		item.setTotalPrice(fieldSet.readBigDecimal(TOTAL_PRICE_COLUMN));

		return item;
	
<no_super_class>