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

来源：互联网发布：在线编程编辑：程序博客网时间：2024/05/22 05:17

/** * 点击加入或者移除功能 * @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;}

1 0