/** * 点击加入或者移除功能 * @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; }
原文:http://blog.csdn.net/sgx425021234/article/details/19564527