mysql的批量操作_mysql批量操作

&allowMultiQueries=true

1、批量删除

Mapper.java

public void deleteCommunityRelUser(@Param("communityId") String communityId,@Param("userIdList") List userIdList) throws Exception;

sql.xml

DELETE FROM COMMUNITY_REL_USER

AND COMMUNITY_ID=#{communityId}

AND USER_ID IN

#{item}

2、批量修改

Mapper.java

public void updateCommunityRelUser(@Param("communityId") String communityId,@Param("userIdList") List userIdList) throws Exception;

sql.xml

UPDATE COMMUNITY_REL_USER SET AUDIT='1'

AND COMMUNITY_ID=#{communityId}

AND USER_ID IN

#{item}

3、批量新增

Mapper.java

public void insertInviteUser(@Param("communityMemberVOList") List communityMemberVOList) throws Exception;

sql.xml

mysql

INSERT INTO COMMUNITY_REL_USER (USER_ID,COMMUNITY_ID,AUDIT)

VALUES

(#{item.userId:VARCHAR},#{item.communityId:VARCHAR},#{item.audit:VARCHAR})

oracle

INSERT INTO COMMUNITY_REL_USER (USER_ID,COMMUNITY_ID,AUDIT,create_date)

select

#{item.userId,jdbcType=VARCHAR},

#{item.communityId,jdbcType=VARCHAR},

#{item.audit,jdbcType=VARCHAR},

#{item.createdate:TIMESTAMP}

from dual

分享到：

2015-03-12 15:08

浏览 302

分类:数据库

评论