论坛 › Mybatis › mybatis-@Param

nics 发表于 2016-11-24 07:29:30

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>

查看完整版本: mybatis-@Param