线上实习 终见篇章——模糊查询

//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<User> 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<Integer> 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<User> findAll(int currentPage,String username){ PageInfo<User> 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<Integer> 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<User> findAll(int currentPage,String username); void deleteAll(@Param("ids") List<Integer> ids);

}

//UserMapper.xml select * from wzbc1 WHERE username LIKE concat("%",#{username},"%") limit #{start},5 delete from wzbc1 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("删除失败"); } }); } }