方法一:
Controller
List newsList = newsService.findAllNewsByUserId(userId, stratIndex, pageCount);
Mapper
List findAllNewsByUserId(@Param(“userId”) Integer userId, @Param(“startIndex”) Integer startIndex, @Param(“pageCount”) Integer pageCount);
SQL
SELECT
*
FROM
news n
WHERE
userid = #{userId,jdbcType=INTEGER}
limit #{startIndex},#{pageCount}
方法二:
把多参数存放在map中传递给mapper,取值同上