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