SELECT
*
FROM
orders
WHERE
order_date >= $P{START_DATE}
AND order_date < $P{END_DATE};
<select id="getOrders" parameterType="map" resultType="Order">
SELECT * FROM orders WHERE order_date >= #{startDate} AND order_date < #{endDate}
</select>