JavaWeb用户信息管理系统-修改用户操作的实现
1 创建更新用户持久层
void updateUserByUserId(Users users); /**
* 更新用户
* @param users
*/
@Override
public void updateUserByUserId(Users users) {
Connection conn = null;
try{
conn = JdbcUtils.getConnection();
conn.setAutoCommit(false);
PreparedStatement preparedStatement = conn.prepareStatement("update users set username=? ,usersex = ?,phonenumber=?,qqnumber = ? where userid = ? ");
preparedStatement.setString(1,users.getUsername());
preparedStatement.setString(2,users.getUsersex());
preparedStatement.setString(3,users.getPhonenumber());
preparedStatement.setString(4,users.getQqnumber());
preparedStatement.setInt(5,users.getUserid());
preparedStatement.execute();
conn.commit();
}catch(Exception e){
e.printStackTrace();
JdbcUtils.rollbackConnection(conn);
}finally {
JdbcUtils.closeConnection(conn);
}
}2 创建更新用户业务层
void modifyUser(Users users); /**
* 修改用户
* @param users
*/
@Override
public void modifyUser(Users users) {
UserManagerDao userManagerDao = new UserManagerDaoImpl();
userManagerDao.updateUserByUserId(users);
}3 创建更新用户 Servlet
/**
* 处理更新用户请求
*/
private void modifyUser(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException{
String userid = req.getParameter("userid");
Users users = this.createUsers(req);
users.setUserid(Integer.parseInt(userid));
try{
UserManagerService userManagerService = new UserManagerServiceImpl();
userManagerService.modifyUser(users);
resp.sendRedirect("ok.jsp");
}catch(Exception e){
e.printStackTrace();
resp.sendRedirect("error.jsp");
}
}4 修改更新用户页面
修改 updateUser.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
<link href="css/style.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div class="place">
<span>位置：</span>
<ul class="placeul">
<li><a href="#">用户管理</a></li>
<li><a href="#">修改用户</a></li>
</ul>
</div>
<div class="formbody">
<div class="formtitle"><span>基本信息</span></div>
<form action="userManager.do" method="post">
<input type="hidden" name="flag" value="modifyUser"/>
<input type="hidden" name="userid" value="${user.userid}"/>
<ul class="forminfo">
<li><label>用户名</label><input name="username" type="text" class="dfinput" value="${user.username}"/> </li>
<li>
<label>性别</label><cite>
<c:choose>
<c:when test="${user.usersex == 1}">
<input name="usersex" type="radio" value="1" checked="checked" />男
<input name="usersex" type="radio" value="0" />女
</c:when>
<c:otherwise>
<input name="usersex" type="radio" value="1" />男
<input name="usersex" type="radio" value="0" checked="checked" />女
</c:otherwise>
</c:choose>
</li>
<li><label>手机号</label><input name="phonenumber" type="text" class="dfinput" value="${user.phonenumber}"/></li>
<li><label>QQ号</label><input name="qqnumber" type="text" class="dfinput" value="${user.qqnumber}"/></li>
<li><label> </label><input type="submit" class="btn" value="确认保存"/></li>
</ul>
</form>
</div>
</body>
</html>
5 测试结果
