SQL语句DB2数据库:updatetable1setcol1=‘ABCD’whereid=15orid=16;Action中的源码/***删除所有用户*@return*@throwsCMSException*/publicStringdelAllUser()throwsCMSException{Rec...
SQL 语句 DB2数据库:
update table1 set col1=‘ABCD’ where id=15 or id=16;
Action中的源码
/**
* 删除所有用户
* @return
* @throws CMSException
*/
public String delAllUser() throws CMSException{
RecruitPostService recruitPostService=(RecruitPostService)ApplicationContext.getBean("recruitPostService");
//根据穿进去的条件查找
List list=recruitPostService.getUserIdsByChoices(recruitUser);
System.out.println("打印出获得用户的数量:"+list.size());
String ids="";
if(list!=null&&list.size()>0){
for (int i = 0; i < list.size(); i++) {
//把用户的ID一一获取,用逗号分开
Map map=(Map)list.get(i);
String temp=map.get("RESUMEID").toString();
ids+=temp+",";
}
//去掉最后一个逗号
if (ids.endsWith(",")) {
ids=ids.substring(0,ids.length()-1);
}
//打印出ID
System.out.println(ids);
//根据ID删除用户
recruitPostService.deleteUsersByIds(ids);
}
return SUCCESS;
}
展开