SpringMVC页面向Controller提交数组+Mybatis传多个参数+MySQL一次写入多条记录

最新推荐文章于 2020-02-27 21:56:21 发布

suanday_sunny

最新推荐文章于 2020-02-27 21:56:21 发布

阅读量2.3k

点赞数

分类专栏： mybatis spring mysql

本文链接：https://blog.csdn.net/mlz_2/article/details/52765750

版权

mysql 同时被 3 个专栏收录

22 篇文章 0 订阅

订阅专栏

spring

14 篇文章 0 订阅

订阅专栏

mybatis

13 篇文章 0 订阅

订阅专栏

DAO层定义：

int insertRole2Authorities(@Param("roleId")int roleId, @Param("authorities")List<Integer> authId);

XML文件：

  <!-- 一个角色对应多个权限，批量insert -->
  <insert id="insertRole2Authorities" useGeneratedKeys="true" >  
    insert into tm05_roles_authorities (role_id,authority_id)   
    values  
    <foreach collection="authorities" item="authId" index="index" separator="," >  
        (#{roleId,jdbcType=INTEGER},#{authId})  
    </foreach>  
</insert>

Service层

@Transactional
	public int writeRoleAuth(int roleId, List<Integer> authId) {

		int updates = 0;
		
		updates += roleDao.deleteAllAuthByRoleId(roleId);
		updates += roleDao.insertRole2Authorities(roleId,authId);
		
		return updates;
	}

控制层，authId接收页面仅提交一个的数据，authId[]接收页面提交多个authID的数据。required=false，如果页面一个authId也没提交，两个参数都是null。

@ResponseBody
	@RequestMapping(value={"/edit_auth"}, method=RequestMethod.POST)
	public Map<String, Object> editRoleAuthorites(
			@RequestParam(value="roleId", required=true)int roleId,
			@RequestParam(value="authId", required=false)Integer authId,
			@RequestParam(value="authId[]", required=false)List<Integer> authorities) {
		
    	Map<String, Object> modal = new HashMap<String, Object>(3); 
    	try{
    		int ok = 0;
    		if(authId == null && authorities!=null && authorities.size()>0)
    			ok = service.writeRoleAuth(roleId,authorities);
    		else if(authId != null && authorities==null){
    			authorities = new ArrayList<Integer>();
    			authorities.add(authId);
    			ok = service.writeRoleAuth(roleId,authorities);
    		}
    		else	
    			ok = dao.deleteAllAuthByRoleId(roleId);
    		
	    	modal.put("ok", ok);
    	}
    	catch(Exception e){
    		modal.put("ok", 0);
    		modal.put("error",e.getMessage());
    		e.printStackTrace();
    	}
    	return modal;
	}

页面html

div class="input-group">
				<span class="input-group-addon"> <input type="checkbox" value="1" name="authId"></span>
				<label class="form-control">权限1 -- 具体内容</label>
			  </div>
			  <div class="input-group">
				<span class="input-group-addon"> <input type="checkbox" value="2" name="authId"></span>
				<label class="form-control">权限1 -- 具体内容</label>
			  </div>
			  <div class="input-group">
				<span class="input-group-addon"> <input type="checkbox" value="3" name="authId"></span>
				<label class="form-control">权限1 -- 具体内容</label>
			  </di<span style="font-family: Arial, Helvetica, sans-serif;">v></span>