• 案例---用户信息列表展示模块

    目录

    1. 需求

    2. 设计

    2.1技术选型

    2.2 数据库设计

    3.创建项目，导入html与jsp页面，配置文件，jar包

    3.1html与jsp页面的导入

    3.1.1css，fonts，js的相关文件

    3.1.2html页面

     3.1.3配置文件

    3.1.4jar包

    4.功能查询

    4.1功能查询分析

    4.2代码实现

    5.用户登录

    5.1用户登录分析

    5.2代码实现

    6.添加功能

    6.1分析

     6.2代码实现

    1. 需求

    用户信息的增删改查操作

    2. 设计

    2.1技术选型

    Servlet+JSP+MySQL+JDBCTempleat+Duird+BeanUtilS+tomcat

    2.2 数据库设计

    1. create database day17; -- 创建数据库
    2. use day17;                -- 使用数据库
    3. create table user(   -- 创建表
    4.     id int primary key auto_increment,
    5.     name varchar(20) not null,
    6.     gender varchar(5),
    7.     age int,
    8.     address varchar(32),
    9.     qq    varchar(20),
    10.     email varchar(50)
    11. )

    3.创建项目，导入html与jsp页面，配置文件，jar包

    3.1html与jsp页面的导入

    下面一次导入以下包

    3.1.1css，fonts，js的相关文件

     

     

    通过BooStrap官网可以找到相应的文件，或者是自己喜欢的文件格式。

    3.1.2html页面

    add.html

    2. html>
    4. <html lang="zh-CN">
    5. <head>
    6.     
    7.     <meta charset="utf-8">
    8.     
    9.     <meta http-equiv="X-UA-Compatible" content="IE=edge">
    10.     
    11.     <meta name="viewport" content="width=device-width, initial-scale=1">
    12.     
    13.     <title>添加用户title>
    14.  
    15.     
    16.     <link href="css/bootstrap.min.css" rel="stylesheet">
    17.     
    18.     <script src="js/jquery-2.1.0.min.js">script>
    19.     
    20.     <script src="js/bootstrap.min.js">script>
    21. head>
    22. <body>
    23. <div class="container">
    24.     <center><h3>添加联系人页面h3>center>
    25.     <form action="" method="post">
    26.         <div class="form-group">
    27.             <label for="name">姓名：label>
    28.             <input type="text" class="form-control" id="name" name="name" placeholder="请输入姓名">
    29.         div>
    30.  
    31.         <div class="form-group">
    32.             <label>性别：label>
    33.             <input type="radio" name="sex" value="男" checked="checked"/>男
    34.             <input type="radio" name="sex" value="女"/>女
    35.         div>
    36.  
    37.         <div class="form-group">
    38.             <label for="age">年龄：label>
    39.             <input type="text" class="form-control" id="age" name="age" placeholder="请输入年龄">
    40.         div>
    41.  
    42.         <div class="form-group">
    43.             <label for="address">籍贯：label>
    44.             <select name="address" class="form-control" id="jiguan">
    45.                 <option value="广东">广东option>
    46.                 <option value="广西">广西option>
    47.                 <option value="湖南">湖南option>
    48.             select>
    49.         div>
    50.  
    51.         <div class="form-group">
    52.             <label for="qq">QQ：label>
    53.             <input type="text" class="form-control" name="qq" placeholder="请输入QQ号码"/>
    54.         div>
    55.  
    56.         <div class="form-group">
    57.             <label for="email">Email：label>
    58.             <input type="text" class="form-control" name="email" placeholder="请输入邮箱地址"/>
    59.         div>
    60.  
    61.         <div class="form-group" style="text-align: center">
    62.             <input class="btn btn-primary" type="submit" value="提交" />
    63.             <input class="btn btn-default" type="reset" value="重置" />
    64.             <input class="btn btn-default" type="button" value="返回" />
    65.         div>
    66.     form>
    67. div>
    68. body>
    69. html>

     index.html

    1. html> 
    2. <html lang="zh-CN">
    3.   <head>
    4.     <meta charset="utf-8"/>
    5.     <meta http-equiv="X-UA-Compatible" content="IE=edge"/>
    6.     <meta name="viewport" content="width=device-width, initial-scale=1"/>
    7.     <title>首页title>
    8.  
    9.     
    10.     <link href="css/bootstrap.min.css" rel="stylesheet">
    11.     
    12.     <script src="js/jquery-2.1.0.min.js">script>
    13.     
    14.     <script src="js/bootstrap.min.js">script>
    15.     <script type="text/javascript">
    16.     script>
    17.   head>
    18.   <body>
    19.   <div align="center">
    20.   	<a
    21. 	  href="list.html" style="text-decoration:none;font-size:33px">查询所有用户信息
    22. 	a>
    23.   div>
    24.   body>
    25. html>

     list.html

    1. html>
    3. <html lang="zh-CN">
    4. <head>
    5.     
    6.     <meta charset="utf-8">
    7.     
    8.     <meta http-equiv="X-UA-Compatible" content="IE=edge">
    9.     
    10.     <meta name="viewport" content="width=device-width, initial-scale=1">
    11.     
    12.     <title>用户信息管理系统title>
    13.  
    14.     
    15.     <link href="css/bootstrap.min.css" rel="stylesheet">
    16.     
    17.     <script src="js/jquery-2.1.0.min.js">script>
    18.     
    19.     <script src="js/bootstrap.min.js">script>
    20.     <style type="text/css">
    21.         td, th {
    22.             text-align: center;
    23.         }
    24.     style>
    25. head>
    26. <body>
    27. <div class="container">
    28.     <h3 style="text-align: center">用户信息列表h3>
    29.     <table border="1" class="table table-bordered table-hover">
    30.         <tr class="success">
    31.             <th>编号th>
    32.             <th>姓名th>
    33.             <th>性别th>
    34.             <th>年龄th>
    35.             <th>籍贯th>
    36.             <th>QQth>
    37.             <th>邮箱th>
    38.             <th>操作th>
    39.         tr>
    40.         <tr>
    41.             <td>1td>
    42.             <td>张三td>
    43.             <td>男td>
    44.             <td>20td>
    45.             <td>广东td>
    46.             <td>44444222td>
    47.             <td>zs@qq.comtd>
    48.             <td><a class="btn btn-default btn-sm" href="update.html">修改a> <a class="btn btn-default btn-sm" href="">删除a>td>
    49.         tr>
    50.         <tr>
    51.             <td>2td>
    52.             <td>张三td>
    53.             <td>男td>
    54.             <td>20td>
    55.             <td>广东td>
    56.             <td>44444222td>
    57.             <td>zs@qq.comtd>
    58.             <td><a class="btn btn-default btn-sm" href="update.html">修改a> <a class="btn btn-default btn-sm" href="">删除a>td>
    59.         tr>
    60.         <tr>
    61.             <td>3td>
    62.             <td>张三td>
    63.             <td>男td>
    64.             <td>20td>
    65.             <td>广东td>
    66.             <td>44444222td>
    67.             <td>zs@qq.comtd>
    68.             <td><a class="btn btn-default btn-sm" href="update.html">修改a> <a class="btn btn-default btn-sm" href="">删除a>td>
    69.         tr>
    70.         <tr>
    71.             <td>4td>
    72.             <td>张三td>
    73.             <td>男td>
    74.             <td>20td>
    75.             <td>广东td>
    76.             <td>44444222td>
    77.             <td>zs@qq.comtd>
    78.             <td><a class="btn btn-default btn-sm" href="update.html">修改a> <a class="btn btn-default btn-sm" href="">删除a>td>
    79.         tr>
    80.         <tr>
    81.             <td>5td>
    82.             <td>张三td>
    83.             <td>男td>
    84.             <td>20td>
    85.             <td>广东td>
    86.             <td>44444222td>
    87.             <td>zs@qq.comtd>
    88.             <td><a class="btn btn-default btn-sm" href="update.html">修改a> <a class="btn btn-default btn-sm" href="">删除a>td>
    89.         tr>
    90.         <tr>
    91.             <td colspan="8" align="center"><a class="btn btn-primary" href="add.html">添加联系人a>td>
    92.         tr>
    93.     table>
    94. div>
    95. body>
    96. html>

     login.html

    1. html> 
    2. <html lang="zh-CN">
    3.   <head>
    4.     <meta charset="utf-8"/>
    5.     <meta http-equiv="X-UA-Compatible" content="IE=edge"/>
    6.     <meta name="viewport" content="width=device-width, initial-scale=1"/>
    7.     <title>管理员登录title>
    8.  
    9.     
    10.     <link href="css/bootstrap.min.css" rel="stylesheet">
    11.     
    12.     <script src="js/jquery-2.1.0.min.js">script>
    13.     
    14.     <script src="js/bootstrap.min.js">script>
    15.     <script type="text/javascript">
    16.     script>
    17.   head>
    18.   <body>
    19.   	<div class="container" style="width: 400px;">
    20.   		<h3 style="text-align: center;">管理员登录h3>
    21.         <form action="login" method="post">
    22. 	      <div class="form-group">
    23. 	        <label for="user">用户名：label>
    24. 	        <input type="text" name="user" class="form-control" id="user" placeholder="请输入用户名"/>
    25. 	      div>
    26. 	      
    27. 	      <div class="form-group">
    28. 	        <label for="password">密码：label>
    29. 	        <input type="password" name="password" class="form-control" id="password" placeholder="请输入密码"/>
    30. 	      div>
    31. 	      
    32. 	      <div class="form-inline">
    33. 	        <label for="vcode">验证码：label>
    34. 	        <input type="text" name="verifycode" class="form-control" id="verifycode" placeholder="请输入验证码" style="width: 120px;"/>
    35. 	        <a href="javascript:refreshCode()"><img src="vcode" title="看不清点击刷新" id="vcode"/>a>
    36. 	      div>
    37. 	      <hr/>
    38. 	      <div class="form-group" style="text-align: center;">
    39. 	        <input class="btn btn btn-primary" type="submit" value="登录">
    40. 	       div>
    41. 	  	form>
    42. 		
    43. 		
    44. 	  	<div class="alert alert-warning alert-dismissible" role="alert">
    45. 		  <button type="button" class="close" data-dismiss="alert" >
    46. 		  	<span>×span>button>
    47. 		   <strong>登录失败!strong>
    48. 		div>
    49.   	div>
    50.   body>
    51. html>

    update.html

    1. html>
    3. <html lang="zh-CN">
    4.     <head>
    5.     	<base href="<%=basePath%>"/>
    6.         
    7.         <meta charset="utf-8">
    8.         <meta http-equiv="X-UA-Compatible" content="IE=edge">
    9.         <meta name="viewport" content="width=device-width, initial-scale=1">
    10.         <title>修改用户title>
    11.  
    12.         <link href="css/bootstrap.min.css" rel="stylesheet">
    13.         <script src="js/jquery-2.1.0.min.js">script>
    14.         <script src="js/bootstrap.min.js">script>
    15.         
    16.     head>
    17.     <body>
    18.         <div class="container" style="width: 400px;">
    19.         <h3 style="text-align: center;">修改联系人h3>
    20.         <form action="" method="post">
    21.           <div class="form-group">
    22.             <label for="name">姓名：label>
    23.             <input type="text" class="form-control" id="name" name="name"  readonly="readonly" placeholder="请输入姓名" />
    24.           div>
    25.  
    26.           <div class="form-group">
    27.             <label>性别：label>
    28.               <input type="radio" name="sex" value="男"  />男
    29.                 <input type="radio" name="sex" value="女"  />女
    30.           div>
    31.  
    32.           <div class="form-group">
    33.             <label for="age">年龄：label>
    34.             <input type="text" class="form-control" id="age"  name="age" placeholder="请输入年龄" />
    35.           div>
    36.  
    37.           <div class="form-group">
    38.             <label for="address">籍贯：label>
    39.              <select name="address" class="form-control" >
    40.                 <option value="广东">广东option>
    41.                 <option value="广西">广西option>
    42.                 <option value="湖南">湖南option>
    43.             select>
    44.           div>
    45.  
    46.           <div class="form-group">
    47.             <label for="qq">QQ：label>
    48.             <input type="text" class="form-control" name="qq" placeholder="请输入QQ号码"/>
    49.           div>
    50.  
    51.           <div class="form-group">
    52.             <label for="email">Email：label>
    53.             <input type="text" class="form-control" name="email" placeholder="请输入邮箱地址"/>
    54.           div>
    55.  
    56.              <div class="form-group" style="text-align: center">
    57.                 <input class="btn btn-primary" type="submit" value="提交" />
    58.                 <input class="btn btn-default" type="reset" value="重置" />
    59.                 <input class="btn btn-default" type="button" value="返回"/>
    60.              div>
    61.         form>
    62.         div>
    63.     body>
    64. html>

     3.1.3配置文件

    druid.properties

    1. driverClassName=com.mysql.jdbc.Driver
    2. url=jdbc:mysql:///day17
    3. username=root
    4. password=root
    5. # 初始化连接数量
    6. initialSize=5
    7. # 最大连接数
    8. maxActive=10
    9. # 最大等待时间
    10. maxWait=3000

     JDBCUtils.java

    1. package cn.itcast.util;
    2.  
    3. import com.alibaba.druid.pool.DruidDataSourceFactory;
    4.  
    5. import javax.sql.DataSource;
    6. import javax.xml.crypto.Data;
    7. import java.io.IOException;
    8. import java.io.InputStream;
    9. import java.sql.Connection;
    10. import java.sql.SQLException;
    11. import java.util.Properties;
    12.  
    13. /**
    14.  * JDBC工具类 使用Durid连接池
    15.  */
    16. public class JDBCUtils {
    17.  
    18.     private static DataSource ds ;
    19.  
    20.     static {
    21.  
    22.         try {
    23.             //1.加载配置文件
    24.             Properties pro = new Properties();
    25.             //使用ClassLoader加载配置文件，获取字节输入流
    26.             InputStream is = JDBCUtils.class.getClassLoader().getResourceAsStream("druid.properties");
    27.             pro.load(is);
    28.  
    29.             //2.初始化连接池对象
    30.             ds = DruidDataSourceFactory.createDataSource(pro);
    31.  
    32.         } catch (IOException e) {
    33.             e.printStackTrace();
    34.         } catch (Exception e) {
    35.             e.printStackTrace();
    36.         }
    37.     }
    38.  
    39.     /**
    40.      * 获取连接池对象
    41.      */
    42.     public static DataSource getDataSource(){
    43.         return ds;
    44.     }
    45.  
    46.  
    47.     /**
    48.      * 获取连接Connection对象
    49.      */
    50.     public static Connection getConnection() throws SQLException {
    51.         return  ds.getConnection();
    52.     }
    53. }

    3.1.4jar包

    4.功能查询

    4.1功能查询分析

    当用户再index.jsp页面点击“查询所有用户信息”时，页面跳转到list.jsp页面，并且显示查询信息。

    4.2代码实现

    User.java

    1. package cn.itcast.domain;
    2.  
    3. public class User {
    4.     private int id;
    5.     private String name;
    6.     private String gender;
    7.     private int age;
    8.     private String address;
    9.     private String qq;
    10.     private String email;
    11.  
    12.     private String username;
    13.     private String password;
    14.  
    15.     public String getUsername() {
    16.         return username;
    17.     }
    18.  
    19.     public void setUsername(String username) {
    20.         this.username = username;
    21.     }
    22.  
    23.     public String getPassword() {
    24.         return password;
    25.     }
    26.  
    27.     public void setPassword(String password) {
    28.         this.password = password;
    29.     }
    30.  
    31.     public int getId() {
    32.         return id;
    33.     }
    34.  
    35.     public void setId(int id) {
    36.         this.id = id;
    37.     }
    38.  
    39.     public String getName() {
    40.         return name;
    41.     }
    42.  
    43.     public void setName(String name) {
    44.         this.name = name;
    45.     }
    46.  
    47.     public String getGender() {
    48.         return gender;
    49.     }
    50.  
    51.     public void setGender(String gender) {
    52.         this.gender = gender;
    53.     }
    54.  
    55.     public int getAge() {
    56.         return age;
    57.     }
    58.  
    59.     public void setAge(int age) {
    60.         this.age = age;
    61.     }
    62.  
    63.     public String getAddress() {
    64.         return address;
    65.     }
    66.  
    67.     public void setAddress(String address) {
    68.         this.address = address;
    69.     }
    70.  
    71.     public String getQq() {
    72.         return qq;
    73.     }
    74.  
    75.     public void setQq(String qq) {
    76.         this.qq = qq;
    77.     }
    78.  
    79.     public String getEmail() {
    80.         return email;
    81.     }
    82.  
    83.     public void setEmail(String email) {
    84.         this.email = email;
    85.     }
    86.  
    87.     @Override
    88.     public String toString() {
    89.         return "User{" +
    90.                 "id=" + id +
    91.                 ", name='" + name + '\'' +
    92.                 ", gender='" + gender + '\'' +
    93.                 ", age=" + age +
    94.                 ", address='" + address + '\'' +
    95.                 ", qq='" + qq + '\'' +
    96.                 ", email='" + email + '\'' +
    97.                 ", username='" + username + '\'' +
    98.                 ", password='" + password + '\'' +
    99.                 '}';
    100.     }
    101. }

    index.jsp

    1. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
    2. <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
    3.  
    4. html>
    5. <html lang="zh-CN">
    6. <head>
    7.   <meta charset="utf-8"/>
    8.   <meta http-equiv="X-UA-Compatible" content="IE=edge"/>
    9.   <meta name="viewport" content="width=device-width, initial-scale=1"/>
    10.   <title>首页title>
    11.  
    12.   
    13.   <link href="css/bootstrap.min.css" rel="stylesheet">
    14.   
    15.   <script src="js/jquery-2.1.0.min.js">script>
    16.   
    17.   <script src="js/bootstrap.min.js">script>
    18.   <script type="text/javascript">
    19.   script>
    20. head>
    21. <body>
    22.  
    23.  
    24.   <div >${user.name},欢迎您div>
    25.   <div align="center">
    26.     <a
    27.             href="${pageContext.request.contextPath}/findUserByPageServlet" style="text-decoration:none;font-size:33px">查询所有用户信息
    28.     a>
    29.   div>
    30.  
    31.  
    32.  
    33.  
    34.  
    35.  
    36. body>
    37. html>

    userListServlet.java

    1. package cn.itcast.web.servlet;
    2.  
    3. import cn.itcast.domain.User;
    4. import cn.itcast.service.UserService;
    5. import cn.itcast.service.impl.UserServiceImpl;
    6.  
    7. import javax.servlet.ServletException;
    8. import javax.servlet.annotation.WebServlet;
    9. import javax.servlet.http.HttpServlet;
    10. import javax.servlet.http.HttpServletRequest;
    11. import javax.servlet.http.HttpServletResponse;
    12. import java.io.IOException;
    13. import java.util.List;
    14.  
    15. @WebServlet("/userListServlet")
    16. public class UserListServlet extends HttpServlet {
    17.     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    18.         //1.调用UserService完成查询
    19.         UserService service = new UserServiceImpl();
    20.         List users = service.findAll();
    21.         //2.将list存入request域
    22.         request.setAttribute("users",users);
    23.         //3.转发到list.jsp
    24.         request.getRequestDispatcher("/list.jsp").forward(request,response);
    25.     }
    26.  
    27.     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    28.         this.doPost(request, response);
    29.     }
    30. }

    构建会话👉调用下层方法(servicefindAll())👉将返回值List users设置在request域内共享👉利用转发的原理将List users信息发送到list.jsp页面

    UserService.java

    1. package cn.itcast.service;
    2.  
    3. import cn.itcast.domain.PageBean;
    4. import cn.itcast.domain.User;
    5.  
    6. import java.util.List;
    7. import java.util.Map;
    8.  
    9. /**
    10.  * 用户管理的业务接口
    11.  */
    12. public interface UserService {
    13.  
    14.     /**
    15.      * 查询所有用户信息
    16.      * @return
    17.      */
    18.     public List findAll();
    19.  
    20.     /**
    21.      * 登录方法
    22.      * @param user
    23.      * @return
    24.      */
    25.     User login(User user);
    26.  
    27.     /**
    28.      * 保存User
    29.      * @param user
    30.      */
    31.     void addUser(User user);
    32.  
    33.     /**
    34.      * 根据id删除User
    35.      * @param id
    36.      */
    37.     void deleteUser(String id);
    38.  
    39.     /**
    40.      * 根据id查询
    41.      * @param id
    42.      * @return
    43.      */
    44.     User findUserById(String id);
    45.  
    46.     /**
    47.      * 修改用户信息
    48.      * @param user
    49.      */
    50.     void updateUser(User user);
    51.  
    52.     /**
    53.      * 批量删除用户
    54.      * @param ids
    55.      */
    56.     void delSelectedUser(String[] ids);
    57.  
    58.     /**
    59.      * 分页条件查询
    60.      * @param currentPage
    61.      * @param rows
    62.      * @param condition
    63.      * @return
    64.      */
    65.     PageBean findUserByPage(String currentPage, String rows, Map condition);
    66. }

     UserServicelmpl.java

    1. package cn.itcast.service.impl;
    2.  
    3. import cn.itcast.dao.UserDao;
    4. import cn.itcast.dao.impl.UserDaoImpl;
    5. import cn.itcast.domain.PageBean;
    6. import cn.itcast.domain.User;
    7. import cn.itcast.service.UserService;
    8.  
    9. import java.util.List;
    10. import java.util.Map;
    11.  
    12. public class UserServiceImpl implements UserService {
    13.     private UserDao dao = new UserDaoImpl();
    14.  
    15.     @Override
    16.     public List findAll() {
    17.         //调用Dao完成查询
    18.         return dao.findAll();
    19.     }
    20.  
    21.     @Override
    22.     public User login(User user) {
    23.         return dao.findUserByUsernameAndPassword(user.getUsername(),user.getPassword());
    24.     }
    25.  
    26.     @Override
    27.     public void addUser(User user) {
    28.         dao.add(user);
    29.     }
    30.  
    31.     @Override
    32.     public void deleteUser(String id) {
    33.         dao.delete(Integer.parseInt(id));
    34.     }
    35.  
    36.     @Override
    37.     public User findUserById(String id) {
    38.         return dao.findById(Integer.parseInt(id));
    39.     }
    40.  
    41.     @Override
    42.     public void updateUser(User user) {
    43.         dao.update(user);
    44.     }
    45.  
    46.     @Override
    47.     public void delSelectedUser(String[] ids) {
    48.         if(ids != null && ids.length > 0){
    49.             //1.遍历数组
    50.             for (String id : ids) {
    51.                 //2.调用dao删除
    52.                 dao.delete(Integer.parseInt(id));
    53.             }
    54.         }
    55.  
    56.     }
    57.  
    58.     @Override
    59.     public PageBean findUserByPage(String _currentPage, String _rows, Map condition) {
    60.  
    61.         int currentPage = Integer.parseInt(_currentPage);
    62.         int rows = Integer.parseInt(_rows);
    63.  
    64.         if(currentPage <=0) {
    65.             currentPage = 1;
    66.         }
    67.         //1.创建空的PageBean对象
    68.         PageBean pb = new PageBean();
    69.         //2.设置参数
    70.         pb.setCurrentPage(currentPage);
    71.         pb.setRows(rows);
    72.  
    73.         //3.调用dao查询总记录数
    74.         int totalCount = dao.findTotalCount(condition);
    75.         pb.setTotalCount(totalCount);
    76.         //4.调用dao查询List集合
    77.         //计算开始的记录索引
    78.         int start = (currentPage - 1) * rows;
    79.         List list = dao.findByPage(start,rows,condition);
    80.         pb.setList(list);
    81.  
    82.         //5.计算总页码
    83.         int totalPage = (totalCount % rows)  == 0 ? totalCount/rows : (totalCount/rows) + 1;
    84.         pb.setTotalPage(totalPage);
    85.  
    86.  
    87.         return pb;
    88.     }
    89. }

    UserDao.java

    1. package cn.itcast.dao;
    2.  
    3. import cn.itcast.domain.User;
    4.  
    5. import java.util.List;
    6. import java.util.Map;
    7.  
    8. /**
    9.  * 用户操作的DAO
    10.  */
    11. public interface UserDao {
    12.  
    13.  
    14.     public List findAll();
    15.  
    16.     User findUserByUsernameAndPassword(String username, String password);
    17.  
    18.     void add(User user);
    19.  
    20.     void delete(int id);
    21.  
    22.     User findById(int i);
    23.  
    24.     void update(User user);
    25.  
    26.     /**
    27.      * 查询总记录数
    28.      * @return
    29.      * @param condition
    30.      */
    31.     int findTotalCount(Map condition);
    32.  
    33.     /**
    34.      * 分页查询每页记录
    35.      * @param start
    36.      * @param rows
    37.      * @param condition
    38.      * @return
    39.      */
    40.     List findByPage(int start, int rows, Map condition);
    41. }

    UserDaoimpl.java

    1. package cn.itcast.dao.impl;
    2.  
    3. import cn.itcast.dao.UserDao;
    4. import cn.itcast.domain.User;
    5. import cn.itcast.util.JDBCUtils;
    6. import org.springframework.jdbc.core.BeanPropertyRowMapper;
    7. import org.springframework.jdbc.core.JdbcTemplate;
    8.  
    9. import java.util.ArrayList;
    10. import java.util.List;
    11. import java.util.Map;
    12. import java.util.Set;
    13.  
    14. public class UserDaoImpl implements UserDao {
    15.  
    16.     private JdbcTemplate template = new JdbcTemplate(JDBCUtils.getDataSource());
    17.  
    18.     @Override
    19.     public List findAll() {
    20.         //使用JDBC操作数据库...
    21.         //1.定义sql
    22.         String sql = "select * from user";
    23.         List users = template.query(sql, new BeanPropertyRowMapper(User.class));
    24.  
    25.         return users;
    26.     }
    27.  
    28.     @Override
    29.     public User findUserByUsernameAndPassword(String username, String password) {
    30.         try {
    31.             String sql = "select * from user where username = ? and password = ?";
    32.             User user = template.queryForObject(sql, new BeanPropertyRowMapper(User.class), username, password);
    33.             return user;
    34.         } catch (Exception e) {
    35.             e.printStackTrace();
    36.             return null;
    37.         }
    38.  
    39.     }
    40.  
    41.     @Override
    42.     public void add(User user) {
    43.         //1.定义sql
    44.         String sql = "insert into user values(null,?,?,?,?,?,?,null,null)";
    45.         //2.执行sql
    46.         template.update(sql, user.getName(), user.getGender(), user.getAge(), user.getAddress(), user.getQq(), user.getEmail());
    47.     }
    48.  
    49.     @Override
    50.     public void delete(int id) {
    51.         //1.定义sql
    52.         String sql = "delete from user where id = ?";
    53.         //2.执行sql
    54.         template.update(sql, id);
    55.     }
    56.  
    57.     @Override
    58.     public User findById(int id) {
    59.         String sql = "select * from user where id = ?";
    60.         return template.queryForObject(sql, new BeanPropertyRowMapper(User.class), id);
    61.     }
    62.  
    63.     @Override
    64.     public void update(User user) {
    65.         String sql = "update user set name = ?,gender = ? ,age = ? , address = ? , qq = ?, email = ? where id = ?";
    66.         template.update(sql, user.getName(), user.getGender(), user.getAge(), user.getAddress(), user.getQq(), user.getEmail(), user.getId());
    67.     }
    68.  
    69.     @Override
    70.     public int findTotalCount(Map condition) {
    71.         //1.定义模板初始化sql
    72.         String sql = "select count(*) from user where 1 = 1 ";
    73.         StringBuilder sb = new StringBuilder(sql);
    74.         //2.遍历map
    75.         Set keySet = condition.keySet();
    76.         //定义参数的集合
    77.         List params = new ArrayList();
    78.         for (String key : keySet) {
    79.  
    80.             //排除分页条件参数
    81.             if("currentPage".equals(key) || "rows".equals(key)){
    82.                 continue;
    83.             }
    84.  
    85.             //获取value
    86.             String value = condition.get(key)[0];
    87.             //判断value是否有值
    88.             if(value != null && !"".equals(value)){
    89.                 //有值
    90.                 sb.append(" and "+key+" like ? ");
    91.                 params.add("%"+value+"%");//？条件的值
    92.             }
    93.         }
    94.         System.out.println(sb.toString());
    95.         System.out.println(params);
    96.  
    97.         return template.queryForObject(sb.toString(),Integer.class,params.toArray());
    98.     }
    99.  
    100.     @Override
    101.     public List findByPage(int start, int rows, Map condition) {
    102.         String sql = "select * from user  where 1 = 1 ";
    103.  
    104.         StringBuilder sb = new StringBuilder(sql);
    105.         //2.遍历map
    106.         Set keySet = condition.keySet();
    107.         //定义参数的集合
    108.         List params = new ArrayList();
    109.         for (String key : keySet) {
    110.  
    111.             //排除分页条件参数
    112.             if("currentPage".equals(key) || "rows".equals(key)){
    113.                 continue;
    114.             }
    115.  
    116.             //获取value
    117.             String value = condition.get(key)[0];
    118.             //判断value是否有值
    119.             if(value != null && !"".equals(value)){
    120.                 //有值
    121.                 sb.append(" and "+key+" like ? ");
    122.                 params.add("%"+value+"%");//？条件的值
    123.             }
    124.         }
    125.  
    126.         //添加分页查询
    127.         sb.append(" limit ?,? ");
    128.         //添加分页查询参数值
    129.         params.add(start);
    130.         params.add(rows);
    131.         sql = sb.toString();
    132.         System.out.println(sql);
    133.         System.out.println(params);
    134.  
    135.         return template.query(sql,new BeanPropertyRowMapper(User.class),params.toArray());
    136.     }
    137. }
      138.  

       创建UserService接口，定义方法，创建UserServicelmpl类实现该接口，并且重写该方法👉告诉下层(dao)调用其findAll()方法👉dao层创建UserDao接口，定义该findAll()方法为pubilc List类型👉UserDaoimpl实现UserDao接口，重写findAll()方法
       

      当findAll()操作完数据库后，返回一个List users，从dao层👉service层👉UserListSerrvlet层再转发到list.jsp
       

      list.jsp
       

      1. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
      2.  
      3. <%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
      4.  
      5. html>
      7. <html lang="zh-CN">
      8. <head>
      9.     
      10.     <meta charset="utf-8">
      11.     
      12.     <meta http-equiv="X-UA-Compatible" content="IE=edge">
      13.     
      14.     <meta name="viewport" content="width=device-width, initial-scale=1">
      15.     
      16.     <title>用户信息管理系统title>
      17.  
      18.     
      19.     <link href="css/bootstrap.min.css" rel="stylesheet">
      20.     
      21.     <script src="js/jquery-2.1.0.min.js">script>
      22.     
      23.     <script src="js/bootstrap.min.js">script>
      24.     <style type="text/css">
      25.         td, th {
      26.             text-align: center;
      27.         }
      28.     style>
      29.  
      30.     <script>
      31.         function deleteUser(id){
      32.             //用户安全提示
      33.             if(confirm("您确定要删除吗？")){
      34.                 //访问路径
      35.                 location.href="${pageContext.request.contextPath}/delUserServlet?id="+id;
      36.             }
      37.         }
      38.  
      39.         window.onload = function(){
      40.             //给删除选中按钮添加单击事件
      41.             document.getElementById("delSelected").onclick = function(){
      42.                 if(confirm("您确定要删除选中条目吗？")){
      43.  
      44.                    var flag = false;
      45.                     //判断是否有选中条目
      46.                     var cbs = document.getElementsByName("uid");
      47.                     for (var i = 0; i < cbs.length; i++) {
      48.                         if(cbs[i].checked){
      49.                             //有一个条目选中了
      50.                             flag = true;
      51.                             break;
      52.                         }
      53.                     }
      54.  
      55.                     if(flag){//有条目被选中
      56.                         //表单提交
      57.                         document.getElementById("form").submit();
      58.                     }
      59.  
      60.                 }
      61.  
      62.             }
      63.             //1.获取第一个cb
      64.             document.getElementById("firstCb").onclick = function(){
      65.                 //2.获取下边列表中所有的cb
      66.                 var cbs = document.getElementsByName("uid");
      67.                 //3.遍历
      68.                 for (var i = 0; i < cbs.length; i++) {
      69.                     //4.设置这些cbs[i]的checked状态 = firstCb.checked
      70.                     cbs[i].checked = this.checked;
      71.  
      72.                 }
      73.  
      74.             }
      75.  
      76.  
      77.         }
      78.  
      79.  
      80.     script>
      81. head>
      82. <body>
      83. <div class="container">
      84.     <h3 style="text-align: center">用户信息列表h3>
      85.  
      86.     <div style="float: left;">
      87.  
      88.         <form class="form-inline" action="${pageContext.request.contextPath}/findUserByPageServlet" method="post">
      89.             <div class="form-group">
      90.                 <label for="exampleInputName2">姓名label>
      91.                 <input type="text" name="name" value="${condition.name[0]}" class="form-control" id="exampleInputName2" >
      92.             div>
      93.             <div class="form-group">
      94.                 <label for="exampleInputName3">籍贯label>
      95.                 <input type="text" name="address" value="${condition.address[0]}" class="form-control" id="exampleInputName3" >
      96.             div>
      97.  
      98.             <div class="form-group">
      99.                 <label for="exampleInputEmail2">邮箱label>
      100.                 <input type="text" name="email" value="${condition.email[0]}" class="form-control" id="exampleInputEmail2"  >
      101.             div>
      102.             <button type="submit" class="btn btn-default">查询button>
      103.         form>
      104.  
      105.     div>
      106.  
      107.     <div style="float: right;margin: 5px;">
      108.  
      109.         <a class="btn btn-primary" href="${pageContext.request.contextPath}/add.jsp">添加联系人a>
      110.         <a class="btn btn-primary" href="javascript:void(0);" id="delSelected">删除选中a>
      111.  
      112.     div>
      113.     <form id="form" action="${pageContext.request.contextPath}/delSelectedServlet" method="post">
      114.         <table border="1" class="table table-bordered table-hover">
      115.         <tr class="success">
      116.             <th><input type="checkbox" id="firstCb">th>
      117.             <th>编号th>
      118.             <th>姓名th>
      119.             <th>性别th>
      120.             <th>年龄th>
      121.             <th>籍贯th>
      122.             <th>QQth>
      123.             <th>邮箱th>
      124.             <th>操作th>
      125.         tr>
      126.  
      127.         <c:forEach items="${pb.list}" var="user" varStatus="s">
      128.             <tr>
      129.                 <td><input type="checkbox" name="uid" value="${user.id}">td>9
      130.                 <td>${s.count}td>
      131.                 <td>${user.name}td>
      132.                 <td>${user.gender}td>
      133.                 <td>${user.age}td>
      134.                 <td>${user.address}td>
      135.                 <td>${user.qq}td>
      136.                 <td>${user.email}td>
      137.                 <td><a class="btn btn-default btn-sm" href="${pageContext.request.contextPath}/findUserServlet?id=${user.id}">修改a> 
      138.                     <a class="btn btn-default btn-sm" href="javascript:deleteUser(${user.id});">删除a>td>
      139.             tr>
      140.  
      141.         c:forEach>
      142.  
      143.  
      144.     table>
      145.     form>
      146.     <div>
      147.         <nav aria-label="Page navigation">
      148.             <ul class="pagination">
      149.                 <c:if test="${pb.currentPage == 1}">
      150.                     <li class="disabled">
      151.                 c:if>
      152.  
      153.                 <c:if test="${pb.currentPage != 1}">
      154.                     <li>
      155.                 c:if>
      156.  
      157.  
      158.                     <a href="${pageContext.request.contextPath}/findUserByPageServlet?currentPage=${pb.currentPage - 1}&rows=5&name=${condition.name[0]}&address=${condition.address[0]}&email=${condition.email[0]}" aria-label="Previous">
      159.                         <span aria-hidden="true">«span>
      160.                     a>
      161.                 li>
      162.  
      163.  
      164.                 <c:forEach begin="1" end="${pb.totalPage}" var="i" >
      165.  
      166.  
      167.                     <c:if test="${pb.currentPage == i}">
      168.                         <li class="active"><a href="${pageContext.request.contextPath}/findUserByPageServlet?currentPage=${i}&rows=5&name=${condition.name[0]}&address=${condition.address[0]}&email=${condition.email[0]}">${i}a>li>
      169.                     c:if>
      170.                     <c:if test="${pb.currentPage != i}">
      171.                         <li><a href="${pageContext.request.contextPath}/findUserByPageServlet?currentPage=${i}&rows=5&name=${condition.name[0]}&address=${condition.address[0]}&email=${condition.email[0]}">${i}a>li>
      172.                     c:if>
      173.  
      174.                 c:forEach>
      175.  
      176.  
      177.                 <li>
      178.                     <a href="${pageContext.request.contextPath}/findUserByPageServlet?currentPage=${pb.currentPage + 1}&rows=5&name=${condition.name[0]}&address=${condition.address[0]}&email=${condition.email[0]}" aria-label="Next">
      179.                         <span aria-hidden="true">»span>
      180.                     a>
      181.                 li>
      182.                 <span style="font-size: 25px;margin-left: 5px;">
      183.                     共${pb.totalCount}条记录，共${pb.totalPage}页
      184.                 span>
      185.  
      186.             ul>
      187.         nav>
      188.  
      189.  
      190.     div>
      191.  
      192.  
      193. div>
      194.  
      195.  
      196. body>
      197. html>
       

      5.用户登录
       

      5.1用户登录分析
       

       

       首先在login.jsp中让用户输入数据，然后LoginServlet.java中使用session拿到服务端的验证码符号与request域中的验证码进行判断，判断该验证码是否输入正确，若正确则将用户输入的用户名和密码封装成user对象，然后调用Service中的login()方法，将用户输入的信息对象user进行传参，并且在service层创建接口和实现类，定义方法，接着到dao层创建接口和实现类，对方法进行重写，使用sql语句操作数据库，若用户名与密码正确则返回该用户的用户信息对象user，反之则为null，层层递进到servlet层，进行用户登录的判断(判断返回值为user还是null)。
       

      5.2代码实现
       

      login.jsp
       

      1. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
      2.  
      3. html>
      4. <html lang="zh-CN">
      5. <head>
      6.     <meta charset="utf-8"/>
      7.     <meta http-equiv="X-UA-Compatible" content="IE=edge"/>
      8.     <meta name="viewport" content="width=device-width, initial-scale=1"/>
      9.     <title>管理员登录title>
      10.  
      11.     
      12.     <link href="css/bootstrap.min.css" rel="stylesheet">
      13.     
      14.     <script src="js/jquery-2.1.0.min.js">script>
      15.     
      16.     <script src="js/bootstrap.min.js">script>
      17.     <script type="text/javascript">
      18.         //切换验证码
      19.         function refreshCode(){
      20.             //1.获取验证码图片对象
      21.             var vcode = document.getElementById("vcode");
      22.  
      23.             //2.设置其src属性，加时间戳
      24.             vcode.src = "${pageContext.request.contextPath}/checkCodeServlet?time="+new Date().getTime();
      25.         }
      26.     script>
      27. head>
      28. <body>
      29. <div class="container" style="width: 400px;">
      30.     <h3 style="text-align: center;">管理员登录h3>
      31.     <form action="${pageContext.request.contextPath}/loginServlet" method="post">
      32.         <div class="form-group">
      33.             <label for="user">用户名：label>
      34.             <input type="text" name="username" class="form-control" id="user" placeholder="请输入用户名"/>
      35.         div>
      36.  
      37.         <div class="form-group">
      38.             <label for="password">密码：label>
      39.             <input type="password" name="password" class="form-control" id="password" placeholder="请输入密码"/>
      40.         div>
      41.  
      42.         <div class="form-inline">
      43.             <label for="vcode">验证码：label>
      44.             <input type="text" name="verifycode" class="form-control" id="verifycode" placeholder="请输入验证码" style="width: 120px;"/>
      45.             <a href="javascript:refreshCode();">
      46.                 <img src="${pageContext.request.contextPath}/checkCodeServlet" title="看不清点击刷新" id="vcode"/>
      47.             a>
      48.         div>
      49.         <hr/>
      50.         <div class="form-group" style="text-align: center;">
      51.             <input class="btn btn btn-primary" type="submit" value="登录">
      52.         div>
      53.     form>
      54.  
      55.     
      56.     <div class="alert alert-warning alert-dismissible" role="alert">
      57.         <button type="button" class="close" data-dismiss="alert" >
      58.             <span>×span>
      59.         button>
      60.         <strong>${login_msg}strong>
      61.     div>
      62. div>
      63. body>
      64. html>
       

      CheckCodeServlet.java
       

      验证码的生成
       

      1. package cn.itcast.web.servlet;
      2.  
      3. import javax.imageio.ImageIO;
      4. import javax.servlet.ServletException;
      5. import javax.servlet.annotation.WebServlet;
      6. import javax.servlet.http.HttpServlet;
      7. import javax.servlet.http.HttpServletRequest;
      8. import javax.servlet.http.HttpServletResponse;
      9. import java.awt.*;
      10. import java.awt.image.BufferedImage;
      11. import java.io.IOException;
      12. import java.util.Random;
      13.  
      14. /**
      15.  * 验证码
      16.  */
      17. @WebServlet("/checkCodeServlet")
      18. public class CheckCodeServlet extends HttpServlet {
      19. 	public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {
      20. 		
      21. 		//服务器通知浏览器不要缓存
      22. 		response.setHeader("pragma","no-cache");
      23. 		response.setHeader("cache-control","no-cache");
      24. 		response.setHeader("expires","0");
      25. 		
      26. 		//在内存中创建一个长80，宽30的图片，默认黑色背景
      27. 		//参数一：长
      28. 		//参数二：宽
      29. 		//参数三：颜色
      30. 		int width = 80;
      31. 		int height = 30;
      32. 		BufferedImage image = new BufferedImage(width,height,BufferedImage.TYPE_INT_RGB);
      33. 		
      34. 		//获取画笔
      35. 		Graphics g = image.getGraphics();
      36. 		//设置画笔颜色为灰色
      37. 		g.setColor(Color.GRAY);
      38. 		//填充图片
      39. 		g.fillRect(0,0, width,height);
      40. 		
      41. 		//产生4个随机验证码，12Ey
      42. 		String checkCode = getCheckCode();
      43. 		//将验证码放入HttpSession中
      44. 		request.getSession().setAttribute("CHECKCODE_SERVER",checkCode);
      45. 		
      46. 		//设置画笔颜色为黄色
      47. 		g.setColor(Color.YELLOW);
      48. 		//设置字体的小大
      49. 		g.setFont(new Font("黑体",Font.BOLD,24));
      50. 		//向图片上写入验证码
      51. 		g.drawString(checkCode,15,25);
      52. 		
      53. 		//将内存中的图片输出到浏览器
      54. 		//参数一：图片对象
      55. 		//参数二：图片的格式，如PNG,JPG,GIF
      56. 		//参数三：图片输出到哪里去
      57. 		ImageIO.write(image,"PNG",response.getOutputStream());
      58. 	}
      59. 	/**
      60. 	 * 产生4位随机字符串 
      61. 	 */
      62. 	private String getCheckCode() {
      63. 		String base = "0123456789ABCDEFGabcdefg";
      64. 		int size = base.length();
      65. 		Random r = new Random();
      66. 		StringBuffer sb = new StringBuffer();
      67. 		for(int i=1;i<=4;i++){
      68. 			//产生0到size-1的随机值
      69. 			int index = r.nextInt(size);
      70. 			//在base字符串中获取下标为index的字符
      71. 			char c = base.charAt(index);
      72. 			//将c放入到StringBuffer中去
      73. 			sb.append(c);
      74. 		}
      75. 		return sb.toString();
      76. 	}
      77. 	public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
      78. 		this.doGet(request,response);
      79. 	}
      80. }
      81.  
      82.  
      83.  
       

      LoginServlet.java
       

      1. package cn.itcast.web.servlet;
      2.  
      3. import cn.itcast.domain.User;
      4. import cn.itcast.service.UserService;
      5. import cn.itcast.service.impl.UserServiceImpl;
      6. import org.apache.commons.beanutils.BeanUtils;
      7.  
      8. import javax.servlet.ServletException;
      9. import javax.servlet.annotation.WebServlet;
      10. import javax.servlet.http.HttpServlet;
      11. import javax.servlet.http.HttpServletRequest;
      12. import javax.servlet.http.HttpServletResponse;
      13. import javax.servlet.http.HttpSession;
      14. import java.io.IOException;
      15. import java.lang.reflect.InvocationTargetException;
      16. import java.util.Map;
      17.  
      18. @WebServlet("/loginServlet")
      19. public class LoginServlet extends HttpServlet {
      20.     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
      21.         //1.设置编码
      22.         request.setCharacterEncoding("utf-8");
      23.  
      24.         //2.获取数据
      25.         //2.1获取用户填写验证码
      26.         String verifycode = request.getParameter("verifycode");
      27.  
      28.         //3.验证码校验
      29.         HttpSession session = request.getSession();
      30.         String checkcode_server = (String) session.getAttribute("CHECKCODE_SERVER");
      31.         session.removeAttribute("CHECKCODE_SERVER");//确保验证码一次性
      32.         if(!checkcode_server.equalsIgnoreCase(verifycode)){
      33.             //验证码不正确
      34.             //提示信息
      35.             request.setAttribute("login_msg","验证码错误！");
      36.             //跳转登录页面
      37.             request.getRequestDispatcher("/login.jsp").forward(request,response);
      38.  
      39.             return;
      40.         }
      41.  
      42.         Map map = request.getParameterMap();
      43.         //4.封装User对象
      44.         User user = new User();
      45.         try {
      46.             BeanUtils.populate(user,map);
      47.         } catch (IllegalAccessException e) {
      48.             e.printStackTrace();
      49.         } catch (InvocationTargetException e) {
      50.             e.printStackTrace();
      51.         }
      52.  
      53.  
      54.         //5.调用Service查询
      55.         UserService service = new UserServiceImpl();
      56.         User loginUser = service.login(user);
      57.         //6.判断是否登录成功
      58.         if(loginUser != null){
      59.             //登录成功
      60.             //将用户存入session
      61.             session.setAttribute("user",loginUser);
      62.             //跳转页面
      63.             response.sendRedirect(request.getContextPath()+"/index.jsp");
      64.         }else{
      65.             //登录失败
      66.             //提示信息
      67.             request.setAttribute("login_msg","用户名或密码错误！");
      68.             //跳转登录页面
      69.             request.getRequestDispatcher("/login.jsp").forward(request,response);
      70.  
      71.         }
      72.  
      73.  
      74.  
      75.  
      76.     }
      77.  
      78.     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
      79.         this.doPost(request, response);
      80.     }
      81. }
       

      接下来的service层和dao层都在上面查询功能。
       

      6.添加功能
       

      6.1分析
       

       

       6.2代码实现
       

      add.jsp
       

      1. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
      2.  
      4. html>
      6. <html lang="zh-CN">
      7. <head>
      8.     
      9.     <meta charset="utf-8">
      10.     
      11.     <meta http-equiv="X-UA-Compatible" content="IE=edge">
      12.     
      13.     <meta name="viewport" content="width=device-width, initial-scale=1">
      14.     
      15.     <title>添加用户title>
      16.  
      17.     
      18.     <link href="css/bootstrap.min.css" rel="stylesheet">
      19.     
      20.     <script src="js/jquery-2.1.0.min.js">script>
      21.     
      22.     <script src="js/bootstrap.min.js">script>
      23. head>
      24. <body>
      25. <div class="container">
      26.     <center><h3>添加联系人页面h3>center>
      27.     <form action="${pageContext.request.contextPath}/addUserServlet" method="post">
      28.         <div class="form-group">
      29.             <label for="name">姓名：label>
      30.             <input type="text" class="form-control" id="name" name="name" placeholder="请输入姓名">
      31.         div>
      32.  
      33.         <div class="form-group">
      34.             <label>性别：label>
      35.             <input type="radio" name="gender" value="男" checked="checked"/>男
      36.             <input type="radio" name="gender" value="女"/>女
      37.         div>
      38.  
      39.         <div class="form-group">
      40.             <label for="age">年龄：label>
      41.             <input type="text" class="form-control" id="age" name="age" placeholder="请输入年龄">
      42.         div>
      43.  
      44.         <div class="form-group">
      45.             <label for="address">籍贯：label>
      46.             <select name="address" class="form-control" id="address">
      47.                 <option value="陕西">陕西option>
      48.                 <option value="北京">北京option>
      49.                 <option value="上海">上海option>
      50.             select>
      51.         div>
      52.  
      53.         <div class="form-group">
      54.             <label for="qq">QQ：label>
      55.             <input type="text" class="form-control" id="qq" name="qq" placeholder="请输入QQ号码"/>
      56.         div>
      57.  
      58.         <div class="form-group">
      59.             <label for="email">Email：label>
      60.             <input type="text" class="form-control" id="email" name="email" placeholder="请输入邮箱地址"/>
      61.         div>
      62.  
      63.         <div class="form-group" style="text-align: center">
      64.             <input class="btn btn-primary" type="submit" value="提交" />
      65.             <input class="btn btn-default" type="reset" value="重置" />
      66.             <input class="btn btn-default" type="button" value="返回" />
      67.         div>
      68.     form>
      69. div>
      70. body>
      71. html>
       

      AddUserServlet.java
       

      1. package cn.itcast.web.servlet;
      2.  
      3. import cn.itcast.domain.User;
      4. import cn.itcast.service.UserService;
      5. import cn.itcast.service.impl.UserServiceImpl;
      6. import org.apache.commons.beanutils.BeanUtils;
      7.  
      8. import javax.servlet.ServletException;
      9. import javax.servlet.annotation.WebServlet;
      10. import javax.servlet.http.HttpServlet;
      11. import javax.servlet.http.HttpServletRequest;
      12. import javax.servlet.http.HttpServletResponse;
      13. import java.io.IOException;
      14. import java.lang.reflect.InvocationTargetException;
      15. import java.util.Map;
      16.  
      17. @WebServlet("/addUserServlet")
      18. public class AddUserServlet extends HttpServlet {
      19.     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
      20.         //1.设置编码
      21.         request.setCharacterEncoding("utf-8");
      22.         //2.获取参数
      23.         Map map = request.getParameterMap();
      24.         //3.封装对象
      25.         User user = new User();
      26.         try {
      27.             BeanUtils.populate(user,map);
      28.         } catch (IllegalAccessException e) {
      29.             e.printStackTrace();
      30.         } catch (InvocationTargetException e) {
      31.             e.printStackTrace();
      32.         }
      33.  
      34.         //4.调用Service保存
      35.         UserService service = new UserServiceImpl();
      36.         service.addUser(user);
      37.  
      38.         //5.跳转到userListServlet
      39.         response.sendRedirect(request.getContextPath()+"/userListServlet");
      40.     }
      41.  
      42.     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
      43.         this.doPost(request, response);
      44.     }
      45. }
       

        
      

       

       
       

      
                
                    
                

                
    138. 

                    相关阅读:
      
                    
国内较好的iPaaS供应商有哪些？                            
      
已解决: Microservice Error: Timeout Error: Service didn‘t respond in time                            
      
3年功能测试，面试要求18k，实在没法给，还不如给低点去招应届生                            
      
105K Star的GitHub项目再陷风波，其托管商惨遭三大唱片公司起诉                            
      
论坛介绍｜COSCon'23 大数据（D）                            
      
软设上午题错题知识点2                            
      
以太网帧格式 以及 认识MAC地址                            
      
三种典型电气减压比例阀线性度和短期重复性的对比考核试验                            
      
南京邮电大学计算机网络实验二（网络路由器配置RIP协议）                            
      
操作系统中的进程是什么?(详细讲解进程调度相关PCB信息)                            
      
                          
                
      139. 
                
    139. 
                    原文地址：https://blog.csdn.net/weixin_65440201/article/details/126293650
                
      140.