到网页中的修改使用更简单的方法

我们这节课用了更简单的方法，在以前的servlet包中基础上删掉两个java文件，剩下下面这几个

在FindByPageServlet实现搜索：
package com.zhongruan.servlet;

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 = 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 = userService.findByPage(searchname, currentPage, size);
    HttpSession session = request.getSession();
    session.setAttribute("searchname", searchname);
    session.setAttribute("pageInfo", pageInfo);
    request.getRequestDispatcher("allUser.jsp").forward(request, response);
}

}

在web中删掉两个java的代码，剩下下面这些：

<?xml version="1.0" encoding="UTF-8"?>

LoginServlet
com.zhongruan.servlet.LoginServlet


LoginServlet
/login

<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>

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.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

public class UserDaoImpl implements IUserDao {
@Override
public User findUserByUsername(String username) {
User user = null;
Connection connection = null;
PreparedStatement statement = null;
ResultSet resultSet = null;
try {
connection = DBUtil.getConnection();
//3写sql
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 charu(String username, String password) {
    Connection connection=null;
    PreparedStatement statement=null;
    try {
        connection=DBUtil.getConnection();
        statement = connection.prepareStatement("INSERT INTO tb_user(username,PASSWORD,TYPE) VALUES (?,?,NULL)");
        statement.setString(1,username);
        statement.setString(2,password);
        statement.executeUpdate();

    } catch (SQLException e) {
        e.printStackTrace();
    }finally {
        DBUtil.closeAll(null,statement,connection);
    }
}

@Override
public void delete(int 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 (SQLException e) {
        e.printStackTrace();
    }finally {
        DBUtil.closeAll(null,statement,connection);
    }
}

@Override
public void up(int id, String username, String password) {
    Connection connection=null;
    PreparedStatement statement=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 (SQLException e) {
        e.printStackTrace();
    }finally {
        DBUtil.closeAll(null,statement,connection);
    }
}

@Override
public User findUserById(int id) {
    User user = null;
    Connection connection = null;
    PreparedStatement statement = null;
    ResultSet resultSet = null;
    try {
        connection = DBUtil.getConnection();
        //3写sql
        String sql = "select * from tb_user where id=?";
        statement = connection.prepareStatement(sql);
        statement.setInt(1, id);
        resultSet = statement.executeQuery();
        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 {
        DBUtil.closeAll(resultSet, statement, connection);
    }
    return user;
}



@Override
public void update(int id,String username,String password) {
    Connection connection = null;
    PreparedStatement statement = null;
    ResultSet resultSet = 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 List<User> search(String username) {
    return null;
}


@Override
public List<User> findByPage(String username,int start, int size) {
    List<User> users=new ArrayList<>();
    Connection connection=null;
    PreparedStatement statement=null;
    ResultSet resultSet=null;
    String sql=null;
    try {
        connection = DBUtil.getConnection();

        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 ?,?";
            statement = connection.prepareStatement(sql);
            statement.setString(1, "%" + username + "%");
            statement.setInt(2, start);
            statement.setInt(3, size);
        }
        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 int selectCount(String d) {
    Connection connection=null;
    PreparedStatement statement=null;
    ResultSet resultSet=null;
    int count=0;
    System.out.println(d);
    try {
        connection = DBUtil.getConnection();
        if (d==null){
            String sql="select count(*) from tb_user ";
            statement= connection.prepareStatement(sql);
        }
    else {
            String sql = "select count(*) from tb_user where username like ? ";
            statement = connection.prepareStatement(sql);
            statement.setString(1, "%" + d + "%");
        }

        resultSet = statement.executeQuery();
        while (resultSet.next()){
            count=resultSet.getInt(1);
        }
        System.out.println(count);
    } catch (Exception e) {
        e.printStackTrace();
    } finally {
        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 findUserByUsername(String username);
List findAll();
void charu(String username,String password);
void delete(int id);
void up(int id,String username,String password);
User findUserById(int id);
void update(int id,String username,String password);
List search(String username);
List findByPage(String username,int start,int size);
int selectCount(String d);
}

其他不变，我们来看看效果：