Mybatis的Mapper.xml文件中集合遍历

最新推荐文章于 2025-04-17 19:10:53 发布

潍坊彭于晏

最新推荐文章于 2025-04-17 19:10:53 发布

阅读量1.2k

点赞数 1

分类专栏： mysql 文章标签： mysql mybatis xml java

本文链接：https://blog.youkuaiyun.com/weixin_43937112/article/details/106382380

版权

mysql 专栏收录该内容

7 篇文章

订阅专栏

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="dnn.exam.QuestionMapper">
	<select id="getQuestionList" resultType="dnn.exam.Question">
 		SELECT * FROM (SELECT * FROM question
	<where>  1 = 1	    
		<if test="null != questionids and questionids.size() > 0">
		    AND 
			<foreach collection="questionids" index="index" item="item" open="(" separator="and" close=")">
              id != #{item}       
           </foreach>    
		</if>	
	</where> 
		 ORDER BY question.count ASC LIMIT 5) tab ORDER BY RAND()
 	</select>
</mapper>