servlet 分页搜索

最新推荐文章于 2022-05-09 11:56:26 发布

weixin_45615663

最新推荐文章于 2022-05-09 11:56:26 发布

阅读量104

点赞数

本文链接：https://blog.csdn.net/weixin_45615663/article/details/102457900

版权

包设置

在这里插入图片描述

FindByPageServlet代码

package com.zhongruan.servlet;

import com.zhongruan.model.User;
import com.zhongruan.pojo.PageInfo;
import com.zhongruan.service.IUserService;
import com.zhongruan.service.impl.UserServiceImpl;

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

public class FindByPageServlet extends HttpServlet {
   @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        HttpSession session=request.getSession();
        String searchname=(String) session.getAttribute("searchname");
        String c=request.getParameter("currentPage");
        int currentPage=Integer.parseInt(c);
        String s=request.getParameter("size");
        int size=Integer.parseInt(s);
        IUserService userService=new UserServiceImpl();
        PageInfo pageInfo=null;
        pageInfo=userService.findByPage(searchname,currentPage,size);

        session.setAttribute("pageInfo",pageInfo);
        request.getRequestDispatcher("allUser.jsp").forward(request,response);

    }

    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String searchname=request.getParameter("searchname");
        int currentPage=1;
        int size=5;
        IUserService userService=new UserServiceImpl();
        PageInfo pageInfo=null;
        pageInfo=userService.findByPage(searchname,currentPage,size);
        HttpSession session=request.getSession();
        session.setAttribute("pageInfo",pageInfo);
        session.setAttribute("session",session);
        request.getRequestDispatcher("allUser.jsp").forward(request,response);
    }



}

UserDaoImpl代码

package com.zhongruan.dao.impl;

import com.zhongruan.dao.IUserDao;
import com.zhongruan.model.User;
import com.zhongruan.util.DBUtil;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

import java.util.ArrayList;
import java.util.List;

public class UserDaoImpl implements IUserDao {
    @Override
    public User findUserByname(String username) {
        ResultSet resultSet=null;
        PreparedStatement statement=null;
        Connection connection=null;
        User user=null;
        try {
            connection = DBUtil.getConnection();
            //3.写sql
            //查询
            String sql = "select * from tb_user where username=?";

            //4.得到statement对象，
            statement = connection.prepareStatement(sql);
            statement.setString(1,username);
            //5.执行sql
            resultSet = statement.executeQuery();
            //6.处理结果集
            while (resultSet.next()) {
                user=new User();
                user.setUsername(resultSet.getString(2));
                user.setPassword(resultSet.getString(3));

            }

        }catch (Exception e){
            e.printStackTrace();
        }finally{
            //7.关闭资源
            DBUtil.closeAll(resultSet,statement,connection);
        }
        return  user;
    }



    @Override
    public List<User> findAll(){
        List<User> users=new ArrayList<>();
        Connection connection=null;
        PreparedStatement statement=null;
        ResultSet resultSet=null;
        try {
            connection=DBUtil.getConnection();
            String sql="select * from tb_user";
            statement=connection.prepareStatement(sql);
            resultSet=statement.executeQuery();
            while (resultSet.next()) {
                User user=new User();
                user.setId(resultSet.getInt(1));
                user.setUsername(resultSet.getString(2));
                user.setPassword(resultSet.getString(3));
                users.add(user);
            }
        }catch (Exception e){
            e.printStackTrace();

        }
        return users;
    }



    @Override
    public void delete(Integer id) {
        Connection connection=null;
        PreparedStatement statement=null;
        try{
            connection=DBUtil.getConnection();
            statement=connection.prepareStatement("delete from tb_user where id=?");
            statement.setInt(1,id);
            statement.executeUpdate();
        }catch (ClassNotFoundException e){
            e.printStackTrace();
        }catch (Exception e){
            e.printStackTrace();
        }finally {

            DBUtil.closeAll(null,statement,connection);
        }

    }

    @Override
    public void add(String username, String password) {
        PreparedStatement statement = null;
        Connection connection = null;
        try{
            connection = DBUtil.getConnection();
            statement = connection.prepareStatement("insert into tb_user(username,password)values(?,?)");
            statement.setString(1, username);
            statement.setString(2, password);
            statement.executeUpdate();
        }catch (ClassNotFoundException e){
            e.printStackTrace();
        } catch (Exception e){
            e.printStackTrace();
        }finally {
            DBUtil.closeAll(null, statement, connection);

        }

    }

    @Override
    public void update(int id, String username, String password) {
        Connection connection = null;
        PreparedStatement statement = null;

        try {
            connection=DBUtil.getConnection();
            String sql="update tb_user set username=?,password=? where id=?";
            statement=connection.prepareStatement(sql);
            statement.setInt(3,id);
            statement.setString(1,username);
            statement.setString(2,password);
            statement.executeUpdate();
        } catch (Exception e) {
            e.printStackTrace();
        }
        finally {
            DBUtil.closeAll(null,statement,connection);
        }

    }

    @Override
    public User findUserById(int id) {
        ResultSet resultSet=null;
        PreparedStatement statement=null;
        Connection connection=null;
        User user=null;
        try {
            connection = DBUtil.getConnection();
            //3.写sql
            //查询
            String sql = "select * from tb_user where id=?";

            //4.得到statement对象，
            statement = connection.prepareStatement(sql);
            statement.setInt(1,id);
            //5.执行sql
            resultSet = statement.executeQuery();
            //6.处理结果集
            while (resultSet.next()) {
                user=new User();
                user.setId(resultSet.getInt(1));
                user.setUsername(resultSet.getString(2));
                user.setPassword(resultSet.getString(3));

            }

        }catch (Exception e){
            e.printStackTrace();
        }finally{
            //7.关闭资源
            DBUtil.closeAll(resultSet,statement,connection);
        }
        return  user;
    }

    @Override
    public List<User> findByPage(String username,int start, int size) {
        List<User> users=new ArrayList<>() ;
        ResultSet resultSet=null;
        PreparedStatement statement=null;
        Connection connection=null;
        String sql=null;
        try {
            connection = DBUtil.getConnection();
            //3.写sql
            //查询
            if (username==null){
                sql = "select * from tb_user limit ?,?";
                statement = connection.prepareStatement(sql);
                statement.setInt(1,start);
                statement.setInt(2,size);
            }else {
                sql = "select * from tb_user where username like ? limit ?,?";
                //4.得到statement对象，
                statement = connection.prepareStatement(sql);
                statement.setString(1,"%"+username+"%");
                statement.setInt(2,start);
                statement.setInt(3,size);
            }

            //5.执行sql
            resultSet = statement.executeQuery();
            //6.处理结果集
            while (resultSet.next()) {
                User user=new User();
                user.setId(resultSet.getInt(1));
                user.setUsername(resultSet.getString(2));
                user.setPassword(resultSet.getString(3));
                users.add(user);

            }

        }catch (Exception e){
            e.printStackTrace();
        }finally{
            //7.关闭资源
            DBUtil.closeAll(resultSet,statement,connection);
        }
        return users ;
    }


    @Override
    public int selectCount() {
        List<User> users=new ArrayList<>() ;
        ResultSet resultSet=null;
        PreparedStatement statement=null;
        Connection connection=null;
        int count=0;
        try {
            connection = DBUtil.getConnection();
            //3.写sql
            //查询
            String sql = "select count(*)from tb_user";

            //4.得到statement对象，
            statement = connection.prepareStatement(sql);
            //5.执行sql
            resultSet = statement.executeQuery();
            //6.处理结果集
            while (resultSet.next()) {
           count=resultSet.getInt(1);

            }

        }catch (Exception e){
            e.printStackTrace();
        }finally{
            //7.关闭资源
            DBUtil.closeAll(resultSet,statement,connection);
        }
        return count ;
    }
}

IUserDao代码

package com.zhongruan.dao;

import com.zhongruan.model.User;

import java.util.List;

public interface IUserDao {
    User findUserByname(String username);
    List<User> findAll();

    void delete(Integer id);
    void add(String username, String password);
    void update(int id,String username,String password);
    User findUserById(int id);
    List<User>findByPage(String username,int start,int size);
    int selectCount();

}

PageInfo代码

package com.zhongruan.pojo;

import com.zhongruan.model.User;

import java.util.List;

public class PageInfo {
    private int currentPage;
    private int size;
    private List<User> list;
    private int totalPage;
    private int totalCount;

    public int getCurrentPage() {
        return currentPage;
    }

    public void setCurrentPage(int currentPage) {
        this.currentPage = currentPage;
    }

    public int getSize() {
        return size;
    }

    public void setSize(int size) {
        this.size = size;
    }

    public List<User> getList() {
        return list;
    }

    public void setList(List<User> list) {
        this.list = list;
    }

    public int getTotalPage() {
        return totalPage;
    }

    public void setTotalPage(int totalPage) {
        this.totalPage = totalPage;
    }

    public int getTotalCount() {
        return totalCount;
    }

    public void setTotalCount(int totalCount) {
        this.totalCount = totalCount;
    }

    @Override
    public String toString() {
        return "PageInfo{" +
                "currentPage=" + currentPage +
                ", size=" + size +
                ", list=" + list +
                ", totalPage=" + totalPage +
                ", totalCount=" + totalCount +
                '}';
    }
}

IUserService 代码

package com.zhongruan.service;

import com.zhongruan.model.User;
import com.zhongruan.pojo.PageInfo;

import java.util.List;

public interface IUserService {
    Boolean login(String username, String password);
    
    void delete(Integer id2);

    void add(String username, String password);
    
    void update(int id, String username, String password);
    User findUserById(int id);
    
    
    
    List<User> findAll();
    
    PageInfo findByPage( String username,int currentPage,int size);


}

web 代码

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
         version="4.0">
    <servlet>
        <servlet-name>LoginServlet</servlet-name>
        <servlet-class>com.zhongruan.servlet.LoginServlet</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>LoginServlet</servlet-name>
        <url-pattern>/login</url-pattern>
    </servlet-mapping>
    <servlet>
        <servlet-name>DeleteServlet</servlet-name>
        <servlet-class>com.zhongruan.servlet.DeleteServlet</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>DeleteServlet</servlet-name>
        <url-pattern>/delete</url-pattern>
    </servlet-mapping>
    <servlet>
        <servlet-name>AddServlet</servlet-name>
        <servlet-class>com.zhongruan.servlet.AddServlet</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>AddServlet</servlet-name>
        <url-pattern>/add</url-pattern>
    </servlet-mapping>
    <servlet>
        <servlet-name>ToUpdateServlet</servlet-name>
        <servlet-class>com.zhongruan.servlet.ToUpdateServlet</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>ToUpdateServlet</servlet-name>
        <url-pattern>/toupdate</url-pattern>
    </servlet-mapping>
    <servlet>
        <servlet-name>UpdateServlet</servlet-name>
        <servlet-class>com.zhongruan.servlet.UpDateServlet</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>UpdateServlet</servlet-name>
        <url-pattern>/update</url-pattern>
    </servlet-mapping>

    <servlet>
        <servlet-name>FindPage</servlet-name>
        <servlet-class>com.zhongruan.servlet.FindByPageServlet</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>FindPage</servlet-name>
        <url-pattern>/findByPage</url-pattern>
    </servlet-mapping>

</web-app>