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