模糊查询

一.模糊查询

在allUser中输入以下代码

<form action="/findByPage" method="post">
            <input name="searchname" type="text">
            <input type="submit" value="搜索">
</form>

在web里添加以下代码

<servlet>
        <servlet-name>SearchServlet</servlet-name>
        <servlet-class>com.zhongruan.servlet.SearchServlet</servlet-class>
</servlet>
<servlet-mapping>
        <servlet-name>SearchServlet</servlet-name>
        <url-pattern>/search</url-pattern>
</servlet-mapping>

新建一个JAVA文件SearchServlet
代码内容如下

public class SearchServlet extends HttpServlet {
    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        IUserService userService=new UserServiceImpl();
        String username=req.getParameter("username");
        List<User> users=userService.search(username);
        HttpSession session=req.getSession();
        PageInfo pageInfo=new  PageInfo();
        pageInfo.setList(users);
        session.setAttribute("pageInfo",pageInfo);
        req.getRequestDispatcher("/allUser.jsp").forward(req,resp);
    }
}

在IConsumerDao中添加“List search(String name);”.
在ConsumerDaoImpl中添加以下代码

 @Override
    public List<Consumer> search(String username) {
        ResultSet resultSet = null;
        PreparedStatement statement = null;
        Connection connection = null;
        ListConsuerr>consumers = new ArrayList<>();
        try {
            connection = DBUtil.getConnection();
            String sql = "select * from consumer where name like ?";
            statement = connection.prepareStatement(sql);
            statement.setString(1,"%"+username+"%");
            resultSet = statement.executeQuery();
            while (resultSet.next()) {
                Consumer consumer = new Consumer();
                consumer.setId(resultSet.getInt(1));
                consumer.setName(resultSet.getString(2));
                consumer.setPassword(resultSet.getString(3));
                consumers.add(consumer);
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            DBUtil.closeALL(resultSet, statement, connection);
        }
        return consumers;
    }

在UserrService中添加“ List search(String name);”
在UserServicelmpl中添加以下代码

@Override
    public List<consumer> search(String name) {
      return iConsumerDao.search(name);
    }