servlet管理系统的基础上实现分页、模糊查询2.0

在昨天的基础上删除searchServlet和FindServlet

UserDaoImpl修改如下：

package com.zhongruan.dao.impl;

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

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

public class UserDaoImpl implements IUserDao {

    @Override
    public User findUserByUsername(String username) {
        Connection connection=null;
        User user=null;
        PreparedStatement statement=null;
        ResultSet resultSet=null;
        try {
            connection= DBUtil.getConnection();
            String sql="select * from tb_user where username=?";
            statement=connection.prepareStatement(sql);
            statement.setString(1,username);
            resultSet=statement.executeQuery();
            while (resultSet.next()){
                 user=new User();
                 user.setId(resultSet.getInt(1));
                user.setUsername(username);
                user.setPassword(resultSet.getString(3));
            }
        } catch (Exception e) {
            e.printStackTrace();
        }finally {
            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();
        }finally {
            DBUtil.closeALL(resultSet,statement,connection);
        }
        return users;
    }

    @Override
    public void delete(int id) {
        Connection connection=null;
        PreparedStatement statement=null;
        try {
            connection=DBUtil.getConnection();
            statement=connection.prepareStatement(&