ssm框架小总结——批量删除
jsp
layui框架：
//头工具栏事件 table.on('toolbar(test)', function(obj){ var checkStatus = table.checkStatus(obj.config.id); switch(obj.event){ //找到 批量删除的id
case 'getCheckData':
// 定义变量, 批量删除的id var data = checkStatus.data; //layer.alert(JSON.stringify(data)); //alert(data.test_id);
//建立空数组， 存放要删除的id var str="";
// 循环 id 添加到容器里去 if(data.length>0){ for(var i=0;i<data.length;i++){ str+=data[i].test_id+","; } // ajax传值 layer.confirm('是否删除这'+data.length+'条数据?',{icon:1,title:'提示'},function(index){ $.ajax({ url:'${ctxtPath}/test/delAll?str='+ str, type:'get', data: $(data.form).serialize(), dataType:'json', success:function(data,textStatus,jqXHR){ window.location.reload(); } }); layer.closr(index); }); } else{ layer.alert("请选择要删除的数据 "); } break;
conllert
package com.laima.car.sys;
import java.util.HashMap;
import java.util.Map;
import javax.servlet.http.HttpServletRequest;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.ModelAttribute;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.ResponseBody;
import com.laima.car.common.Page;
import com.laima.car.common.SystemLog;
@Controller
@RequestMapping(value="/test")
public class TestController {
@Autowired
private TestService testService;
//跳转需要的页面
@RequestMapping(value="/testall")
public String testall(@ModelAttribute("command")Test test, HttpServletRequest request){
return "/sys/quertest";
}
//查看所有数据 （同时也有搜索查询功能）
@ResponseBody
@RequestMapping(value="/getseeall")
public Map<String, Object> getseeall(Test test, HttpServletRequest request){
Map<String, Object> map = new HashMap<String, Object>(); 前台layui框架，获取浅谈所有数据
Page page = testService.queryMenu(test);
map.put("code", "0");
map.put("msg", "");
map.put("count", page.getRecordCount());
map.put("data", page.getResultList());
return map;
}
//添加跳转页面
@RequestMapping(value="/testadd")
public String testadd(@ModelAttribute("command")Test test){
return "/sys/testadd";
}
//添加数据
@ResponseBody
@RequestMapping(value="/addtest", method = RequestMethod.POST)
public Map<String, Object> addtest(Test test, HttpServletRequest request){
Map<String, Object> map = new HashMap<String, Object>();
System.out.println();
testService.addtest(test);
map.put("status", "0");
return map;
}
//修改 跳转并回显数据
@RequestMapping(value="/updatatest/{TestId}")
public String updatatest(@PathVariable String TestId, HttpServletRequest request){
System.out.println(TestId);
Test test=testService.updatatestUI(TestId);
System.out.println(test.toString());
request.setAttribute("coun", test);
return "/sys/testup";
}
//修改 数据
@RequestMapping(value="/updTest", method = RequestMethod.POST)
@SystemLog(module="菜单管理", methods="/menu/toUpdMenu&/admin/updMenu", logDesc="修改菜单")
public String updTest(Test test, HttpServletRequest request){
testService.updTest(test);
request.setAttribute("alertMsg", "菜单修改成功");
return "redirect:/menu/queryMenu";
}
//删除数据
@ResponseBody
@RequestMapping(value="/delTest/{testId}", method = RequestMethod.POST)
@SystemLog(module="菜单管理", methods="/menu/delMenu", logDesc="删除菜单")
public Map<String, Object> delTest(@PathVariable String testId, HttpServletRequest request){
Map<String, Object> map = new HashMap<String, Object>();
Test test = testService.getMenu(testId);
System.out.println(test);
testService.delTest(test);;
map.put("status", "0");
return map;
}
//批量删除
@ResponseBody
@RequestMapping(value="/delAll", method = RequestMethod.GET)
@SystemLog(module="菜单管理", methods="/menu/delMenu", logDesc="删除菜单")
public Map<String, Object> delAll( HttpServletRequest request){
Map<String, Object> map = new HashMap<String, Object>();
String str=request.getParameter("str");
// testService.getMenu(str);
testService.delAll(str);
System.out.println(str);
map.put("status", "0");
return map;
}
}
service层
package com.laima.car.sys;
import java.util.ArrayList;
import java.util.List;
import javax.transaction.Transactional;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.util.StringUtils;
import com.laima.car.common.JdbcDao;
import com.laima.car.common.Page;
@Service
@Transactional
public class TestService {
@Autowired
private TestDao testDao;
@Autowired
private JdbcDao jdbcDao;
//查看所有的人员资料
public Page queryMenu(Test test){
List<Object> args = new ArrayList<Object>();
String Name = test.getTestName();
String calss= test.getTestClass();
StringBuffer sql = new StringBuffer(
"SELECT test_id, test_name,test_age,test_home,test_phone,test_class FROM test_lcy where 1 = 1 ");
if(StringUtils.hasText(Name)){
sql.append("and test_name like ?");
args.add("%" + Name + "%");
}
if(StringUtils.hasText( calss)){
sql.append("and test_class like ?");
args.add("%" + calss + "%");
}
// sql.append(" order by desc");
return jdbcDao.querySqlPage(sql.toString(), args.toArray());
}
//添加数据
public void addtest(Test test){
testDao.save(test);
testDao.saveAndFlush(test);
}
//修改 跳转并回显数据
public Test updatatestUI(String TestId){
return testDao.getOne(TestId);
}
//修改
public void updTest(Test test){
testDao.saveAndFlush(test);
}
//删除
public void delTest(Test test){
String sql = "delete from test_lcy where test_id = ? ";
jdbcDao.updateSql(sql, test.getTestId());
}
public Test getMenu(String testId){
return testDao.getOne(testId);
}
//批量删除
public void delAll(String str){
//String menuSql = "delete from test_lcy where test_id in ('"+ menuIds +"') ";
str=str.replaceAll(",", "','");
String sql = "delete from test_lcy where test_id in ('"+ str +"') ";
jdbcDao.updateSql(sql);
//jdbcDao.updateSql(menuSql);
}
}
分割字符串的几种方式
分割字符串“
String time = "158,9874,7506"; //数值传入
1. time=time.replaceAll(",", "','");
String[] times = time.split(",");
2. String str = "'";
for (int i = 0; i < times.length; i++) {
System.out.println(times[i]);
str += times[i] + "',";
}
3. str = str.substring(0, str.length()-1);
StringBuffer s=new StringBuffer(str);
s.delete(s.length()-1, s.length());
结果：
String sql = "delete from table where id in("+str+")";
System.out.println(sql);
}}
