<select id="getFreightEfclInventoryList" parameterType="long" resultMap="BaseResultMap1">
SELECT
freight_efcl_inventory_id,
freight_efcl_id,
closing_date,
sailing_date,
shipping_space_total,
shipping_space_remain,
shipping_space_used
FROM
freight_efcl_inventory
WHERE
1=1
AND freight_efcl_id=#{freightEfclId}
AND sailing_date >= DATE(current_timestamp)
ORDER BY
sailing_date ASC
limit 4
</select>
注意:sailing_date字段类型是Date类型,系统当前时间current_timestamp时间格式带时分秒的,所以需要将其转换成Date类型。