servlejsp+修改

接上一个博客写以下修改


UserDaoImpl 加以下代码

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);
    }
}

IuserDao 加以下

User findUserById(int id);
void update(int id,String username,String password);

UserServiceImpl

@Override
public User findUserById(int id) {
return userDao.findUserById(id);
}
@Override
public void update(int id, String username, String password) {
userDao.update(id,username,password);
}
}

IUserService

void update(int id,String username,String password);
User findUserById(int id);

ToUpdateServlet

package com.zhongruan.servlet;

import com.zhongruan.model.User;
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 ToUpdateServlet extends HttpServlet {
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String id=request.getParameter(“id”);
int id1=Integer.parseInt(id);
IUserService userService=new UserServiceImpl();
User user=userService.findUserById(id1);
//1.得到session
HttpSession session = request.getSession();
//2.把值放到session
session.setAttribute(“user”,user);
//3.跳转到更新页面
request.getRequestDispatcher(“updateUser.jsp”).forward(request,response);
}
}

UpdateServlet

package com.zhongruan.servlet;

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 java.io.IOException;

public class UpdateServlet extends HttpServlet{
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
IUserService userService=new UserServiceImpl();
int id= Integer.parseInt(request.getParameter(“id”));
String username=request.getParameter(“username”);
String password=request.getParameter(“password”);
userService.update(id,username,password);
request.getRequestDispatcher("/find").forward(request,response);
}
}

web.xml
servlet>
ToUpdateServlet
com.zhongruan.servlet.ToUpdateServlet


ToUpdateServlet
/toupdate

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

updateUser.jsp

allUser.jsp