关闭

Mybatis批处理(批量查询,更新,插入)

标签: mybatis批处理批量查询批量插入批量更新
29人阅读 评论(0) 收藏 举报

mybatis批量查询


mapper.java

List<UBaseMenu> findMenuName(List<String> valueList);

mapper.xml

<select id="findMenuName"  resultType="java.lang.String" parameterType="java.util.List">
  	select menu_name
  	from menu
  	where menu_id in
  	<foreach collection="list" item="valueList"  open="(" close=")" separator=",">
  		#{valueList}
  	</foreach>
 </select>

批量插入

mapper.java


int addResource(List<Resource> ResourceList);
mapper.xml

<insert id="addResource" parameterType="java.util.List">
  	 insert into resource (object_id, res_id, res_detail_value, 
      res_detail_name)
      values
    	 <foreach collection="list" item=" ResourceList " index="index" separator=",">
    		  (#{ResourceList.objectId,jdbcType=VARCHAR},
    		   #{ResourceList.resId,jdbcType=VARCHAR},
    		   #{ResourceList.resDetailValue,jdbcType=VARCHAR},
    		    #{ResourceList.resDetailName,jdbcType=VARCHAR}
    		   )
    	 </foreach>
  </insert>

批量更新

mapper.java

int updateRoles(List<String> roleList);
mapper.xml

<update id="updateRoles" parameterType="java.util.List">
  	update role
  	set enabled = '0'
  	where role_id in <foreach collection="list" item="roleIds" index="index"  open="(" separator="," close=")">     
        #{roleIds} 
      </foreach>
  </update>




1
0

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:735次
    • 积分:87
    • 等级:
    • 排名:千里之外
    • 原创:3篇
    • 转载:1篇
    • 译文:0篇
    • 评论:0条
    文章存档