Spring Mybatis 返回List<Map<String,Object>>

来源:互联网 发布:中国核心期刊数据库 编辑:程序博客网 时间:2024/06/06 18:13

Spring Mybatis 返回List<Map<String,Object>>


List<Map<String,Object>> selectSysArticleForClient(@Param("articleOrder") int articleOrder, @Param("categoryId") String categoryId);
<select id="selectSysArticleForClient" resultType="java.util.Map" parameterType="map">
 SELECT ID,TITLE,CREATE_TIME FROM easy_sys_article 
WHERE ARTICLE_STATUS = 1
AND ARTICLE_ORDER = #{articleOrder,jdbcType=INTEGER}
AND CATEGORY_ID = #{categoryId,jdbcType=CHAR}
ORDER BY CREATE_TIME DESC
limit 0,6
</select>


原创粉丝点击