Servlet登录界面增加修改功能

一.修改

这节课新建了几个JAVA文件 ToUpdateServlet UpdateServlet JAVA文件和jsp文件updateUser

新建一个ToUpdateServlet文件 代码如下

public class ToUpdateServlet extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        String id=req.getParameter("id");
        int id1=Integer.parseInt(id);
        IUserService userService=new UserServiceImpl();
        Consumer consumer=userService.findConsumerById(id1);
        HttpSession session=req.getSession();
        session.setAttribute("consumer",consumer);
        req.getRequestDispatcher("UpDateUser.jsp").forward(req,resp);
    }
}

这里要用到find方法 所以要新建一个 findConsumerById方法 （用id在表consumer里找）
IConsumerDaoImpl里添加以下代码

Consumer findConsumerById(int id);

ConsumerDaoImpl里就会出现异常 抛出异常后添加以下代码

    @Override
    public Consumer findConsumerById(int id) {
        {
            ResultSet resultSet = null;
            PreparedStatement statement = null;
            Connection connection = null;
            Consumer consumer = null;
            try {
                connection = DBUtil.getConnection();
                String sql = "select * from consumer where id=?";
                statement