添加功能
分析:
list.jsp:进行修改一下
add.jsp:
![复制代码](https://common.cnblogs.com/images/copycode.gif)
<%@ page contentType="text/html;charset=UTF-8" language="java" %> <!-- HTML5文档--> <!DOCTYPE html> <!-- 网页使用的语言 --> <html lang="zh-CN"> <head> <!-- 指定字符集 --> <meta charset="utf-8"> <!-- 使用Edge最新的浏览器的渲染方式 --> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <!-- viewport视口:网页可以根据设置的宽度自动进行适配,在浏览器的内部虚拟一个容器,容器的宽度与设备的宽度相同。 width: 默认宽度与设备的宽度相同 initial-scale: 初始的缩放比,为1:1 --> <meta name="viewport" content="width=device-width, initial-scale=1"> <!-- 上述3个meta标签*必须*放在最前面,任何其他内容都*必须*跟随其后! --> <title>添加用户</title> <!-- 1. 导入CSS的全局样式 --> <link href="css/bootstrap.min.css" rel="stylesheet"> <!-- 2. jQuery导入,建议使用1.9以上的版本 --> <script src="js/jquery-2.1.0.min.js"></script> <!-- 3. 导入bootstrap的js文件 --> <script src="js/bootstrap.min.js"></script> </head> <body> <div class="container"> <center><h3>添加联系人页面</h3></center> <form action="${pageContext.request.contextPath}/addUserServlet" method="post"> <div class="form-group"> <label for="name">姓名:</label> <input type="text" class="form-control" id="name" name="name" placeholder="请输入姓名"> </div> <div class="form-group"> <label>性别:</label> <input type="radio" name="gender" value="男" checked="checked"/>男 <input type="radio" name="gender" value="女"/>女 </div> <div class="form-group"> <label for="age">年龄:</label> <input type="text" class="form-control" id="age" name="age" placeholder="请输入年龄"> </div> <div class="form-group"> <label for="address">籍贯:</label> <select name="address" class="form-control" id="address"> <option value="峡西">峡西</option> <option value="广西">广西</option> <option value="湖南">湖南</option> </select> </div> <div class="form-group"> <label for="qq">QQ:</label> <input type="text" class="form-control" id="qq" name="qq" placeholder="请输入QQ号码"/> </div> <div class="form-group"> <label for="email">Email:</label> <input type="text" class="form-control" id="email" name="email" placeholder="请输入邮箱地址"/> </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>
![复制代码](https://common.cnblogs.com/images/copycode.gif)
UserDao:添加一个方法
void add(User user);
UserDaoImpl:重写方法
![复制代码](https://common.cnblogs.com/images/copycode.gif)
@Override public void add(User user) { //定义sql String sql = "insert into user values(null,?,?,?,?,?,?,null,null)"; //执行sql template.update(sql,user.getName(),user.getGender(),user.getAge(),user.getAddress(),user.getQq(),user.getEmail()); }
![复制代码](https://common.cnblogs.com/images/copycode.gif)
UserService:
/** * 保存User * @param user */ void addUser(User user);
UserServiceImpl:
@Override public void addUser(User user) { dao.add(user); }
AddUserServlet
![复制代码](https://common.cnblogs.com/images/copycode.gif)
@WebServlet("/addUserServlet") public class AddUserServlet extends HttpServlet { protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { //设置编码 request.setCharacterEncoding("utf-8"); //获取参数 Map<String, String[]> map = request.getParameterMap(); //封装对象 User user = new User(); try { BeanUtils.populate(user,map); } catch (IllegalAccessException e) { e.printStackTrace(); } catch (InvocationTargetException e) { e.printStackTrace(); } //调用Service保存 UserServiceImpl service = new UserServiceImpl(); service.addUser(user); //跳转到userListServlet response.sendRedirect(request.getContextPath()+"/userListServlet"); } protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { this.doPost(request, response); } }
删除功能
分析:
list.jsp:进行修改:
UserDao:
void delete(int id);
UserDaoImpl:
![复制代码](https://common.cnblogs.com/images/copycode.gif)
@Override public void delete(int id) { //定义sql String sql = "delete from user where id = ?"; //执行sql template.update(sql,id); }
![复制代码](https://common.cnblogs.com/images/copycode.gif)
UserService:
/** * 根据id删除user * @param id */ void deleteUser(String id);
UserServiceImpl
@Override public void deleteUser(String id) { dao.delete(Integer.parseInt(id)); }
delUserServlet实现:
![复制代码](https://common.cnblogs.com/images/copycode.gif)
@WebServlet("/delUserServlet") public class delUserServlet extends HttpServlet { protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { //获取id String id = request.getParameter("id"); //调用service删除 UserServiceImpl service = new UserServiceImpl(); service.deleteUser(id); //跳转到查询所有的Servlet response.sendRedirect(request.getContextPath()+"/userListServlet"); } protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { this.doPost(request, response); } }
![复制代码](https://common.cnblogs.com/images/copycode.gif)
修改功能
分析:
信息的回显功能:
list.jsp:进行修改
UserDao:
User findById(int parseInt);
UserDaoImpl:
@Override public User findById(int id) { String sql = "select * from user where id=?"; return template.queryForObject(sql,new BeanPropertyRowMapper<User>(User.class),id); }
UserService:
/** * 根据id查询 * @param id * @return */ User findUserById(String id);
UserServiceImpl:
@Override public User findUserById(String id) { return dao.findById(Integer.parseInt(id)); }
update.jsp:
![复制代码](https://common.cnblogs.com/images/copycode.gif)
<%@ 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"> <%--隐藏域 提交id--%> <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" value="${user.name}" readonly="readonly" placeholder="请输入姓名" /> </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" value="${user.age}" name="age" placeholder="请输入年龄" /> </div> <div class="form-group"> <label for="address">籍贯:</label> <select name="address" id="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" id="qq" class="form-control" value="${user.qq}" name="qq" placeholder="请输入QQ号码"/> </div> <div class="form-group"> <label for="email">Email:</label> <input type="text" id="email" class="form-control" value="${user.email}" name="email" placeholder="请输入邮箱地址"/> </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>
![复制代码](https://common.cnblogs.com/images/copycode.gif)
FindUserServlet:
复制代码 @WebServlet("/findUserServlet") public class FindUserServlet extends HttpServlet { protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { //1.获取id String id = request.getParameter("id"); //调用Service查询 UserServiceImpl service = new UserServiceImpl(); User user = service.findUserById(id); //将user存入request request.setAttribute("user",user); //转发到update.jsp页面 request.getRequestDispatcher("/update.jsp").forward(request,response); } protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { this.doPost(request, response); } }
用户信息修改功能
UserDao:
void update(User user);
UserDaoImpl:
@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()); }
UserService:
/** * 修改用户信息 * @param user */ void updateUser(User user);
UserServiceImpl:
@Override public void updateUser(User user) { dao.update(user); }
UpdateUserServlet:
![复制代码](https://common.cnblogs.com/images/copycode.gif)
@WebServlet("/updateUserServlet") public class UpdateUserServlet extends HttpServlet { protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { //设置编码 request.setCharacterEncoding("utf-8"); //获取map Map<String, String[]> map = request.getParameterMap(); //封装对象 User user = new User(); try { BeanUtils.populate(user,map); } catch (IllegalAccessException e) { e.printStackTrace(); } catch (InvocationTargetException e) { e.printStackTrace(); } //调用Service修改 UserServiceImpl service = new UserServiceImpl(); service.updateUser(user); //跳转到查询页面 response.sendRedirect(request.getContextPath()+"/userListServlet"); } protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { this.doPost(request, response); } }
标签:功能,删除,void,request,response,添加,user,id,User From: https://www.cnblogs.com/yuzong/p/17023137.html