模糊查询

//UserController @RequestMapping("/deleteAll.do") public String deleteAll(String userList){ String[] strs = userList.split(","); List ids = new ArrayList<>(); for(String s:strs){ ids.add(Integer.parseInt(s)); } userService.deleteAll(ids); return “redirect:findAll.do”; }

//UserDao package com.zhongruan.dao;

import com.zhongruan.bean.PageInfo; import com.zhongruan.bean.User; import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface UserDao { User findUserByUserName(String username); List findAll(@Param(“start”) int start, @Param(“username”) String username);

void deleteById(int id);

void add(User user);

User selectById(int id);

void Update(User user);

int getTotalCount(@Param(“username”) String username);

void deleteAll(@Param(“ids”) List ids); }

//UserService package com.zhongruan.service.impl;

import com.zhongruan.bean.PageInfo; import com.zhongruan.bean.User; import com.zhongruan.dao.UserDao; import com.zhongruan.service.IUserService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service;

import java.util.List;

@Service public class UserService implements IUserService { @Autowired private UserDao userDao;

@Override public boolean login(String username, String password) { User user = userDao.findUserByUserName(username); if (user!=null && user.getPassword().equals(password)){ return true; } return false; }

@Override public PageInfo findAll(int currentPage,String username){ PageInfo pageInfo = new PageInfo<>(); pageInfo.setSize(5);

int tc = userDao.getTotalCount(username); pageInfo.setTotalCount(tc); int tp=(int)Math.ceil(tc/5.0); pageInfo.setTotalPage(tp); if(currentPage<1){ pageInfo.setCurrentPage(1); }else if(currentPage>tp){ pageInfo.setCurrentPage(tp); }else { pageInfo.setCurrentPage(currentPage); } int start = (pageInfo.getCurrentPage()-1)*5; List<User> userList = userDao.findAll(start,username); pageInfo.setList(userList); return pageInfo;

}

@Override public void deleteAll(List ids) { userDao.deleteAll(ids); }

@Override public void deleteById(int id) { userDao.deleteById(id); }

@Override public void add(User user) { userDao.add(user); }

@Override public User selectUserById(int id) { return userDao.selectById(id); }

@Override public void Update(User user) { userDao.Update(user); } }

//IUserService package com.zhongruan.service;

import com.zhongruan.bean.PageInfo; import com.zhongruan.bean.User; import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface IUserService { boolean login(String username,String password); void deleteById(int id);

void add(User user);

User selectUserById(int id);

void Update(User user);

PageInfo findAll(int currentPage,String username);

void deleteAll(@Param(“ids”) List ids); }

//UserMapper.xml

select * from tb_user

WHERE username LIKE concat("%",#{username},"%")

limit #{start},5

delete from tb_user where id in

#{id}

//user-list.jsp function deleteAll() { var checkedNum=$(“input[name=‘ids’]:checked”).length; alert(checkedNum); if(checkedNum==0){ alert(“请至少选择一个进行删除！！！”); return; } if(confirm(“确认要删除这些用户吗？”)){ var userList=new Array(); KaTeX parse error: Expected ‘}’, got ‘EOF’ at end of input: … userList.push((this).val()) } ); alert(userList); KaTeX parse error: Expected ‘}’, got ‘EOF’ at end of input: …", url: “{pageContext.request.contextPath}/user/deleteAll.do”, data:{userList:userList.toString()}, success:function () { alert(“删除成功”); location.reload(); }, error:function () { alert(“删除失败”);

} }); } }