综合练习–2 修改
修改
修改流程
修改主要分为两个大的步骤:数据回显和修改。
一、回显
1、dao
UserDao.java
/**
* 根据ID查找用户信息,用于回显数据
*/
User findById(int id);
UserDaoImpl.java
@Override
public User findById(int id) {
String sql = "select * from user where id=?";
User user= null;
try {
user = template.queryForObject(sql, new BeanPropertyRowMapper<>(User.class), id);
}catch(Exception ex){
}
return user;
}
2、service
UserService.java
/**
* 根据ID查找用户信息,用于回显数据
*/
User findById(String id);
UserServiceImpl.java
@Override
public User findById(String id) {
User user=userDao.findById(Integer.parseInt(id));
return user;
}
3、web
添加FindUserServlet
@WebServlet(value = "/FindUserServlet")
public class FindUserServlet extends HttpServlet {
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
//接收要修改的id
String id = request.getParameter("id");
//调用业务层,根据id查找出一个完整的user对象
UserService userService = new UserServiceImpl();
User user = userService.findById(id);
//将user对象传到update.jsp进行回显
request.setAttribute("user",user);
request.getRequestDispatcher("/update.jsp").forward(request,response);
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doPost(request, response);
}
}
4、前端页面
list.jsp
二、修改
1、dao
UserDao.java
/**
* 修改用户信息
*/
void update(User user);
UserDaoImpl.java
@Override
public void update(User user) {
String sql = "UPDATE USER SET NAME=?,gender=?,age=?,address=?,qq=?,email=? WHERE id=?";
template.update(sql,user.getName(),user.getGender(),user.getAge(),user.getAddress(),user.getQq(),user.getEmail(),user.getId());
}
2、service
UserService.java
/**
* 修改用户信息
*/
void update(User user);
UserServiceImpl.java
@Override
public void update(User user) {
userDao.update(user);
}
3、web
添加UpdateUserServlet
@WebServlet(value = "/UpdateUserServlet")
public class UpdateUserServlet extends HttpServlet {
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
//1、编码处理
request.setCharacterEncoding("utf-8");
//接收修改后的用户数据
Map<String, String[]> parameterMap = request.getParameterMap();
//将用户数据封装到 user对象中
User user = new User();
try {
BeanUtils.populate(user,parameterMap);
} catch (IllegalAccessException e) {
e.printStackTrace();
} catch (InvocationTargetException e) {
e.printStackTrace();
}
//调用业务层进行数据修改
UserService userService = new UserServiceImpl();
userService.update(user);
//重新跳转到UserListServlet
response.sendRedirect(request.getContextPath()+"/UserListServlet");
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doPost(request, response);
}
}
4、前端页面
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<!DOCTYPE html>
<!-- 网页使用的语言 -->
<html lang="zh-CN">
<head>
<!-- 指定字符集 -->
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>修改用户</title>
<link href="css/bootstrap.min.css" rel="stylesheet">
<script src="js/jquery-2.1.0.min.js"></script>
<script src="js/bootstrap.min.js"></script>
</head>
<body>
<div class="container" style="width: 400px;">
<h3 style="text-align: center;">修改联系人</h3>
<form action="${pageContext.request.contextPath}/UpdateUserServlet" method="post">
<input type="hidden" name="id" value="${user.id}"/>
<div class="form-group">
<label for="name">姓名:</label>
<input type="text" class="form-control" id="name" name="name" readonly="readonly" value="${user.name}" />
</div>
<div class="form-group">
<label>性别:</label>
<c:if test="${user.gender=='男'}">
<input type="radio" name="gender" value="男" checked />男
<input type="radio" name="gender" value="女" />女
</c:if>
<c:if test="${user.gender=='女'}">
<input type="radio" name="gender" value="男" />男
<input type="radio" name="gender" value="女" checked />女
</c:if>
</div>
<div class="form-group">
<label for="age">年龄:</label>
<input type="text" class="form-control" id="age" name="age" value="${user.age}" />
</div>
<div class="form-group">
<label for="address">籍贯:</label>
<select name="address" class="form-control" >
<c:if test="${user.address=='陕西'}">
<option value="陕西" selected>陕西</option>
<option value="广西">广西</option>
<option value="湖南">湖南</option>
</c:if>
<c:if test="${user.address=='广西'}">
<option value="陕西" >陕西</option>
<option value="广西" selected>广西</option>
<option value="湖南">湖南</option>
</c:if>
<c:if test="${user.address=='湖南'}">
<option value="陕西" >陕西</option>
<option value="广西" >广西</option>
<option value="湖南" selected>湖南</option>
</c:if>
</select>
</div>
<div class="form-group">
<label for="qq">QQ:</label>
<input type="text" class="form-control" name="qq" value="${user.qq}"/>
</div>
<div class="form-group">
<label for="email">Email:</label>
<input type="text" class="form-control" name="email" value="${user.email}"/>
</div>
<div class="form-group" style="text-align: center">
<input class="btn btn-primary" type="submit" value="提交" />
<input class="btn btn-default" type="reset" value="重置" />
<input class="btn btn-default" type="button" value="返回"/>
</div>
</form>
</div>
</body>
</html>
这几篇介绍了简单的增删改查功能。还有几个复杂功能后面总结:
1、多选删除
2、分页查询
3、带条件的分页查询
在写代码的过程中,总会出现各种错误,各种bug,有时候看一两个小时都搞不定,锤键盘的心都有了。单词写错,路径写错,变量名写错,各种错,但是最后还是都解决了。
沉下心来,出错是正常的,解决错误的过程真的很锻炼人,希望以后在敲代码的过程中能快速提升自己改bug的能力!加油!