mybatis order by绑定的参数

<select id = "queryByStartWithOrder" resultType="org.seckill.entity.SuccessKilled">
            select * from success_killed order by ${column} limit #{start},#{end}
        </select>
    public List<SuccessKilled> queryByStartWithOrder(@Param("start") int start, @Param("end")int end,@Param("column") String column) ;

order by绑定的参数 需要使用$而不是# 否则会出错,刚百度搜到的,做个标记

准备把mooc上面的秒杀课程做的玩具,扩展一下

posted on 2016-10-01 21:36  winters86  阅读(379)  评论(0编辑  收藏  举报