mybatis-@Param

Mapper.java

List<TInsure> selectInsureByDatePeriodFromRoute(
	    @Param(value = "startDate")Date startDate, 
	    @Param(value = "endDate")Date endDate);

 

Mapper.xml

<select id="select" resultMap="BaseResultMap" parameterType="java.util.Map">
		SELECT <include refid="Base_Column_List" /> FROM t_route 
		where create_time between #{startDate,jdbcType=TIMESTAMP} and #{endDate,jdbcType=TIMESTAMP}
</select>