功能组管理-添加移除功能（两种实现方式）

/**
	 * 点击加入或者移除功能
	 * @param groupID
	 * @param functionIDs
	 * @param flag
	 * @return
	 */
	public ResultInfo addOrDelFunctionToGroup(int groupID,String functionIDs, int flag) {
		ResultInfo result = new ResultInfo(false);
		String[] funcID = functionIDs.split(",");
		if (flag == 1) {// 1添加，2移除
			String sql = "";
			for (int i = 0; i < funcID.length; i++) {
				sql = "update tFunction set groupID = ? where functionID = ?";
				jdbcTemplate.update(sql, new Object[] { groupID,funcID[i]});
			}
		} else if (flag == 2) {
			String sql = "update tFunction set groupID = 0 where ";
			for (int i = 0; i < funcID.length; i++) {
				if(i==0){
					sql +=" functionID = "+funcID[i];
				}else{
					sql +=" or functionID = "+funcID[i];
				}
			}
			jdbcTemplate.update(sql);
		}
		result.setSuccess(true);
		return result;
	}
           

等同于如下代码

/**
	 * 功能组管理--将功能加入到功能组
	 * @param groupID
	 * @param functionIDs
	 * @return
	 */
	public ResultInfo addFuncToGroup(int groupID,String functionIDs){
		ResultInfo result = new ResultInfo(false);
		String sql="update tFunction set groupID = ? where functionID in ("+functionIDs+")";
		jdbcTemplate.update(sql, new Object[] { groupID});
		result.setSuccess(true);
		return result;
	}
	/**
	 * 功能组管理--将功能从功能组中移除
	 * @param functionIDs
	 * @return
	 */
	public ResultInfo removeFuncFromGroup(String functionIDs){
		ResultInfo result = new ResultInfo(false);
		String sql="update tFunction set groupID = 0 where functionID in ("+functionIDs+")";
		jdbcTemplate.update(sql);
		result.setSuccess(true);
		return result;
	}