ssm框架模糊查询和中文

ssm框架模糊查询和中文

主要是实现模糊查询和新增用户时添加中文字符

首先结构如下

User

package com.zhongruan.bean;

public class User {
    private  int id;
    private  String username;
    private  String password;

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", username='" + username + '\'' +
                ", password='" + password + '\'' +
                '}';
    }
}

UserController

package com.zhongruan.controller;

import com.github.pagehelper.PageInfo;
import com.zhongruan.bean.User;
import com.zhongruan.service.IUserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.servlet.ModelAndView;

import javax.servlet.http.HttpSession;
import java.util.List;

@Controller
public class UserController {
    @Autowired
    private IUserService userService;

    @RequestMapping("/findAll.do")
    public ModelAndView findAll(@RequestParam(defaultValue ="1") int pageNum, @RequestParam(defaultValue ="5") int size, String searchname, HttpSession session) {
        ModelAndView modelAndView = new ModelAndView();
        String username=(String) session.getAttribute("username");
//        if (username==null){
//            modelAndView.setViewName("failure.jsp");
//            return  modelAndView;
//        }
        if (searchname!=null){
            session.setAttribute("searchname",searchname);
        }else {
            searchname=(String) session.getAttribute("searchname");
        }
        List<User> users = userService.findAll(pageNum, size,searchname);
        PageInfo<User> pageInfo=new PageInfo<>(users);

        modelAndView.setViewName("allUser.jsp");
        modelAndView.addObject("pageInfo", pageInfo);
        return modelAndView;
    }

    @RequestMapping("/login.do")
    public String login(User user,HttpSession session) {
        Boolean flag = userService.login(user.getUsername(), user.getPassword());
        if (flag) {
            session.setAttribute("username",user.getUsername());
            return "redirect:/findAll.do";
        } else {
            return "failure.jsp";
        }
    }

    @RequestMapping("/delete.do")
    public String deleteById(int id) {
        userService.deleteById(id);
        return "redirect:/findAll.do";
    }

    @RequestMapping("/addUser.do")
    public String addById(User user) {
        userService.addById(user);
        return "redirect:/findAll.do";
    }

    @RequestMapping("/update.do")
    public String update(User user) {
        userService.updateById(user);
        return "redirect:/findAll.do";
    }

    @RequestMapping("/toupdate.do")
    public ModelAndView toupdate(int id) {
    User user =userService.findById(id);
    ModelAndView mv =new ModelAndView();
    mv.addObject("user",user);
    mv.setViewName("updateUser.jsp");
    return mv;
    }
}

IUserDao

package com.zhongruan.dao;


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

import java.util.List;

public interface IUserDao {
    List<User> findAll(@Param("searchname")String searchname);
    User selectByUserName(String name);
    void  deleteById(int id);
    void  addById(User user);
    void updateById(User user);
    User findById(int id);
}

LoginFilter

package com.zhongruan.filter;


import javax.servlet.*;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import java.io.IOException;

public class LoginFilter implements Filter {
    @Override
    public void init(FilterConfig filterConfig) throws ServletException {

    }

    @Override
    public void doFilter(ServletRequest servletRequest, ServletResponse servletResponse, FilterChain filterChain) throws IOException, ServletException {
        HttpServletRequest request= (HttpServletRequest) servletRequest;
        HttpServletResponse response= (HttpServletResponse) servletResponse;
        HttpSession session=request.getSession();
        if (session.getAttribute("username")==null&&
                request.getRequestURI().indexOf("/login.do")==-1){
            response.sendRedirect("index.jsp");
        }else {
            filterChain.doFilter(request,response);
        }
    }

    @Override
    public void destroy() {

    }
}

UserService

package com.zhongruan.service.iml;

import com.github.pagehelper.PageHelper;
im