页面操作数据库系统

记录通过浏览器操作数据库 , 前端页面有点不熟悉 , 见谅啊~~!

三层架构

按照不同功能分为不同层，通常分为三层：表现层(web层)，业务层，持久(数据库)层。


其中

• WEB层(Servlet)
  • 获得请求参数
  • 创建业务对象,调用业务处理参数结果
  • 响应
• 业务层(Service)
  • 处理业务(请求参数处理)
  • 创建Dao对象,调用Dao
• 持久层(Dao)
  • 操作数据库

该程序设计的宗旨:

• 高内聚低耦合
• 可拓展性强
• 可维护性强
• 可重用性强

打码环节

效果图

• 管理员登录页面
  

• 超级管理员注册登录页面
  

• 超级管理员注册页面
  

• 数据库查看页面

• 

• 用户信息新增页面
  

• 用户信息删除页面
  

• 用户信息修改页面
  

打码

• 项目结构
  

Web层

• RootServlet(登录页面的数据处理)

  package com.lqh.Demo.web.Servlet;
  import com.lqh.Demo.Domain.Root;
  import com.lqh.Demo.Service.RootService;
  import org.apache.commons.beanutils.BeanUtils;
  import javax.servlet.ServletException;
  import javax.servlet.annotation.WebServlet;
  import javax.servlet.http.Cookie;
  import javax.servlet.http.HttpServlet;
  import javax.servlet.http.HttpServletRequest;
  import javax.servlet.http.HttpServletResponse;
  import java.io.IOException;
  import java.lang.reflect.InvocationTargetException;
  import java.sql.SQLException;
  import java.util.Map;
  /**
   * author:小刘
   * 日期: 2019/12/31 11:58
   */
  @WebServlet(value = "/RootServlet")
  public class RootServlet extends HttpServlet {
      protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
          doGet(request, response);
      }
  
      protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
          String method = request.getParameter("method");
          RootService rootService = new RootService();
          String rootid = request.getParameter("id");
          String rootname = request.getParameter("root");
          String password = request.getParameter("password");
          String Rootname = request.getParameter("Root");
          //查询超级管理员
          if ("findRoot".equals(method)) {
              try {
                  boolean result = rootService.findRoot(rootid, Rootname, password);
                  if (result) {
                      request.setAttribute("MSG", "登录成功");
                      request.getSession().setAttribute("rootboss", rootid);
                      request.getRequestDispatcher("Register.jsp").forward(request, response);
                  } else {
                      request.setAttribute("MSG", "请输入正确的账户信息或者联系管理员");
                      request.getRequestDispatcher("RootLogin.jsp").forward(request, response);
                  }
              } catch (SQLException e) {
                  request.setAttribute("MSG", "异常,请重试");
                  request.getRequestDispatcher("RootLogin.jsp").forward(request, response);
              }
          }
          //添加管理员
          if ("addroot".equals(method)) {
              Map<String, String[]> map = request.getParameterMap();
              Root root = new Root();
              try {
                  BeanUtils.populate(root, map);
                  boolean result = rootService.addroot(root);
                  if (result) {
                      request.setAttribute("MSG", "添加root成功");
                      request.getRequestDispatcher("Register.jsp").forward(request, response);
                  }
              } catch (IllegalAccessException e) {
                  request.setAttribute("MSG", "添加root失败");
                  request.getRequestDispatcher("Register.jsp").forward(request, response);
              } catch (InvocationTargetException e) {
                  request.setAttribute("MSG", "添加root失败");
                  request.getRequestDispatcher("Register.jsp").forward(request, response);
              } catch (SQLException e) {
                  request.setAttribute("MSG", "添加root失败");
                  request.getRequestDispatcher("Register.jsp").forward(request, response);
              }
          }
          //查询管理员
          if ("findroot".equals(method)) {
              try {
                  boolean result = rootService.findroot(rootid, rootname, password);
                  if (result) {
                      //找到管理员信息之后要匹配验证码是否正确
                      String jspcode = request.getParameter("code");
                      String Servletcode = (String) request.getSession().getAttribute("code");
                      if (Servletcode.equalsIgnoreCase(jspcode)) {
                          //获取是否记住用户名和密码
                          String remember = request.getParameter("remember");
                          Cookie rotid = new Cookie("cookieid", rootid);
                          Cookie rotname = new Cookie("cookierootname", rootname);
                          Cookie rotpassword = new Cookie("cookiepassword", password);
                          if (remember != null) {
                              rotid.setMaxAge(24 * 60 * 60);
                              rotname.setMaxAge(24 * 60 * 60);
                              rotpassword.setMaxAge(24 * 60 * 60);
                          } else {
                              rotid.setMaxAge(0);
                              rotname.setMaxAge(0);
                              rotpassword.setMaxAge(0);
                          }
                          response.addCookie(rotid);
                          response.addCookie(rotname);
                          response.addCookie(rotpassword);
                          request.getSession().setAttribute("remember", remember);
  //-------------------------------------
                          request.setAttribute("MSG", "登录成功");
                          request.getSession().setAttribute("root", rootid);
  //默认每页展示5条数据,当前页为1                   
  						String curSize = "5";
  						String curPage = "1";
   response.sendRedirect("UserServlet?method=findPage&curSize=" + curSize + "&curPage=" + curPage);
                      } else { request.setAttribute("msg", "请输入正确的验证码");       request.getRequestDispatcher("index.jsp").forward(request, response);
                      }
                  } else {
                      request.setAttribute("MSG", "请输入正确的账户信息或者联系管理员");
                      request.getRequestDispatcher("index.jsp").forward(request, response);
                  }
              } catch (SQLException e) {
                  request.setAttribute("MSG", "请输入正确的账户信息或者联系管理员");
                  request.getRequestDispatcher("index.jsp").forward(request, response);
              }
          }
      }
  }

• UserServlet(展示页面的数据处理)

  package com.lqh.Demo.web.Servlet;
  import com.lqh.Demo.Domain.Page;
  import com.lqh.Demo.Domain.User;
  import com.lqh.Demo.Service.UserService;
  import org.apache.commons.beanutils.BeanUtils;
  import javax.servlet.ServletException;
  import javax.servlet.annotation.WebServlet;
  import javax.servlet.http.HttpServlet;
  import javax.servlet.http.HttpServletRequest;
  import javax.servlet.http.HttpServletResponse;
  import java.io.IOException;
  import java.lang.reflect.InvocationTargetException;
  import java.sql.SQLException;
  import java.util.Map;
  import java.util.Random;
  
  /**
   * author:小刘
   * 日期: 2019/12/30 10:16
   */
  @WebServlet(value = "/UserServlet")
  public class UserServlet extends HttpServlet {
      private UserService userService = new UserService();
  
      protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
          doGet(request, response);
      }
  
      protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  
          Map<String, String[]> map = request.getParameterMap();
          User user = new User();
          String method = request.getParameter("method");
          //查
          if ("findPage".equals(method)) {
              //调用业务层findPage
              String regex = "^[0-9]*$";
              String curPage1 = request.getParameter("curPage");
              String curSize1 = request.getParameter("curSize");
              if (curSize1.trim().length() == 0 || "0".equals(curSize1)) {
                  curSize1 = "5";
              }
              if (curPage1.trim().length() == 0 || "0".equals(curPage1)) {
                  curPage1 = "1";
              }
              if (!curPage1.matches(regex) || !curSize1.matches(regex)) {
                  request.setAttribute("MSG1", "兄嘚异常辣,到底了或请输入正整数");
                  request.getRequestDispatcher("UserManage.jsp").forward(request, response);
              }
  
              int curPage = Integer.parseInt(curPage1);
              int curSize = Integer.parseInt(curSize1);
              try {
                  Page pageBean = userService.PageBean(curPage, curSize);
                  if (curPage > pageBean.getSumPage()) {
                      int sumPage = pageBean.getSumPage().intValue();
                      pageBean = userService.PageBean(sumPage, curSize);
                  }
                  request.getSession().setAttribute("PageBean", pageBean);
                  response.sendRedirect("UserManage.jsp");
  
              } catch (SQLException e) {
                  request.setAttribute("MSG", "数据库异常,请重试");
              }
          }
          //改
          if ("updateUser".equals(method)) {
              //调用业务层update
              String id = request.getParameter("updateid");
              try {
                  BeanUtils.populate(user, map);
              } catch (IllegalAccessException e) {
                  request.setAttribute("MSG", "修改失败 ，系统异常,请重新修改 ！");
                  request.getRequestDispatcher("UserManage.jsp").forward(request, response);
              } catch (InvocationTargetException e) {
                  request.setAttribute("MSG", "修改失败 ，系统异常,请重新修改 ！");
                  request.getRequestDispatcher("UserManage.jsp").forward(request, response);
              }
              try {
                  updateUser(id, user, request, response);
              } catch (SQLException e) {
                  request.setAttribute("MSG", "修改失败 ，数据库异常,请重新添加 ！");
                  request.getRequestDispatcher("UserManage.jsp").forward(request, response);
              }
          }
  
          //增
          if ("addUser".equals(method)) {
              //调用业务层addUser
              try {
                  BeanUtils.populate(user, map);
              } catch (IllegalAccessException e) {
                  request.setAttribute("MSG", "添加失败 ，系统异常,请重新添加 ！");
                  request.getRequestDispatcher("addUser.jsp").forward(request, response);
              } catch (InvocationTargetException e) {
                  request.setAttribute("MSG", "添加失败 ，系统异常,请重新添加 ！");
                  request.getRequestDispatcher("addUser.jsp").forward(request, response);
              }
              try {
                  addUser(user, request, response);
              } catch (SQLException e) {
                  request.setAttribute("MSG", "添加失败 ，数据库异常,请重新添加 ！");
                  request.getRequestDispatcher("addUser.jsp").forward(request, response);
              }
  
          }
          //删
          if ("deleteUser".equals(method)) {
              //调用业务层deleteUser
              String id = request.getParameter("id");
              try {
                  deleteUser(id, request, response);
              } catch (SQLException e) {
                  request.setAttribute("MSG", "删除失败 ，数据库异常,请重新添加 ！");
                  request.getRequestDispatcher("UserManage.jsp").forward(request, response);
              }
          }
          //测试加100个人
          if ("test".equals(method)) {
              int i = new Random().nextInt(6);
              int age = new Random().nextInt(92) + 18;
              int i1 = new Random().nextInt(2);
              for (int j = 0; j < 50; j++) {
                  User user1 = new User();
                  String[] address = {"北京", "上海", "广东", "福建", "南京", "汕头"};
                  String[] name = {"家政3", "家政1", "家政2", "家政5", "家政56", "家政58"};
                  String[] sex = {"男", "女"};
                  user1.setAddress(address[i]);
                  user1.setAge(age);
                  user1.setName(name[i]);
                  user1.setEmail("123456789@qq.com");
                  user1.setQq("123456789");
                  user1.setSex(sex[i1]);
                  try {
                      userService.addUser(user1);
                  } catch (SQLException e) {
                      e.printStackTrace();
                  }
              }
              request.setAttribute("MSG", "添加成功 !");
              request.getRequestDispatcher("UserManage.jsp").forward(request, response);
          }
      }

//-------------------------------------这是方法区--------------------------------------
public void addUser(User user, HttpServletRequest request, HttpServletResponse response) throws SQLException, ServletException, IOException {
    boolean User = userService.addUser(user);
    //判断有没有这个人
    if (User) {
        request.setAttribute("MSG", "添加成功 !");
        request.getRequestDispatcher("addUser.jsp").forward(request, response);
    } else {
        request.setAttribute("MSG", "添加失败 ，请重新添加 ！");
        request.getRequestDispatcher("addUser.jsp").forward(request, response);
    }
}

private void updateUser(String id, User user, HttpServletRequest request, HttpServletResponse response) throws SQLException, ServletException, IOException {
    boolean result = userService.updateUser(id, user);
    if (result) {
        request.setAttribute("MSG", "修改成功 !");
        request.getRequestDispatcher("UserManage.jsp").forward(request, response);
    } else {
        request.setAttribute("MSG", "修改失败 ，请重新修改 ！");
        request.getRequestDispatcher("UserManage.jsp").forward(request, response);
    }
}

private void deleteUser(String id, HttpServletRequest request, HttpServletResponse response) throws SQLException, ServletException, IOException {
    boolean result = userService.deleteUser(id);
    if (result) {
        request.setAttribute("MSG", "删除成功 !");
        request.getRequestDispatcher("UserManage.jsp").forward(request, response);
    } else {
        request.setAttribute("MSG", "删除失败 ，请重新删除 ！");
        request.getRequestDispatcher("UserManage.jsp").forward(request, response);
    }
}

}

- CodeServlet(用于验证码生产)

​```java
package com.lqh.Demo.web.Servlet;

import cn.dsna.util.images.ValidateCode;
import javax.servlet.ServletException;
import javax.servlet.ServletOutputStream;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;

/**
 * author:小刘
 * 日期: 2019/12/26 13:00
 */
@WebServlet(value = "/Code")
public class CodeServlet extends HttpServlet {
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doGet(request, response);
    }
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
      //生成验证码
        ValidateCode code = new ValidateCode(100, 30, 4, 8);
        String code1 = code.getCode();
      //将验证码信息共享RootServlet
        request.getSession().setAttribute("code", code1);
        ServletOutputStream ous = response.getOutputStream();
        code.write(ous);
    }
}

Service层

• RootService

package com.lqh.Demo.Service;
import com.lqh.Demo.Dao.RootDao;
import com.lqh.Demo.Domain.Root;
import java.sql.SQLException;
/**
 * author:小刘
 * 日期: 2019/12/31 12:23
 */
public class RootService {
    private RootDao rootDao = new RootDao();
    public boolean findRoot(String rootid,String Rootname,String password) throws SQLException {
        Root root = rootDao.findRoot(rootid);
        return Result(password, root,Rootname);

    }

    public boolean addroot(Root root) throws SQLException {
        int result = rootDao.addroot(root);
        System.out.println(root);
        System.out.println(result);
        if(result>0){
            return true;
        }else return false;
    }
  
    public boolean findroot(String rootid,String rootname,String password) throws SQLException {
        Root root = rootDao.findroot(rootid);
        return Result(password, root,rootname);
    }
    //----------------------方法区--------------------------------------------
    private boolean Result(String password, Root root,String rootname) {
        if (root != null) {
            if (root.getPassword().equals(password)) {
                if(root.getRoot().equals(rootname)){
                    return true;
                }else return false;
            } else return false;
        } else return false;
    }
}

• UserService

package com.lqh.Demo.Service;

import com.lqh.Demo.Dao.UserDao;
import com.lqh.Demo.Domain.Page;
import com.lqh.Demo.Domain.User;

import java.sql.SQLException;
import java.util.List;

/**
 * author:小刘
 * 日期: 2019/12/30 10:10
 */
public class UserService {
    private UserDao userDao = new UserDao();

    //查
    public List<User> findPage(int a, int b) throws SQLException {
        return userDao.findPage(a, b);
    }

    // 获取Page封装对象
    public Page PageBean(int curPage, int curSize) throws SQLException {
        Page page = new Page();
        page.setCurPage(curPage);
        //获取总页数
        Long count = userDao.findCount();
        long sumpage = count / curSize;
        if (count % curSize == 0) {
            sumpage = count / curSize;
        } else {
            sumpage += 1;
        }
        page.setSumPage(sumpage);
        page.setCount(count);
        page.setCurSize(curSize);
        //获得跳过的查询数量和本次查询数量的User列表
        int a = (curPage - 1) * curSize;
        page.setList(userDao.findPage(a, curSize));
        return page;
    }

    //增
    public boolean addUser(User user) throws SQLException {
        int row = userDao.addUser(user);
        if (row > 0) {
            return true;
        } else return false;
    }

    //改
    public boolean updateUser(String id, User user) throws SQLException {
        int row = userDao.updateUser(id, user);
        if (row > 0) {
            return true;
        } else return false;
    }

    //查
    public boolean deleteUser(String id) throws SQLException {
        int row = userDao.deleteUser(id);
        if (row > 0) {
            return true;
        } else return false;
    }
}

Dao层

• RootDao

  package com.lqh.Demo.Dao;
  
  import com.lqh.Demo.Domain.Root;
  import com.lqh.Demo.Utils.C3P0Utils;
  import org.apache.commons.dbutils.QueryRunner;
  import org.apache.commons.dbutils.handlers.BeanHandler;
  
  import java.sql.SQLException;
  
  /**
   * author:小刘
   * 日期: 2019/12/31 11:51
   */
  public class RootDao {
      private QueryRunner queryRunner = new QueryRunner(C3P0Utils.getDataSource());
  
      //查
      //查找超级管理员的所有信息
      public Root findRoot(String rootid) throws SQLException {
          String sql = "select * from rootboss where id=?";
          return queryRunner.query(sql, new BeanHandler<Root>(Root.class), rootid);
      }
  
      //增加管理员
      public int addroot(Root root) throws SQLException {
          String sql = "insert into root values(?,?,?)";
          return queryRunner.update(sql, root.getId(), root.getRoot(), root.getPassword());
      }
  
      //查询管理员信息
      public Root findroot(String rootid) throws SQLException {
          String sql = "select * from root where id=?";
          return queryRunner.query(sql, new BeanHandler<Root>(Root.class), rootid);
      }
  }

• UserDao

  package com.lqh.Demo.Dao;
  
  import com.lqh.Demo.Domain.User;
  import com.lqh.Demo.Utils.C3P0Utils;
  import org.apache.commons.dbutils.QueryRunner;
  import org.apache.commons.dbutils.handlers.BeanListHandler;
  import org.apache.commons.dbutils.handlers.ScalarHandler;
  
  import java.sql.Connection;
  import java.sql.SQLException;
  import java.util.List;
  
  /**
   * author:小刘
   * 日期: 2019/12/30 9:54
   */
  public class UserDao {
      private QueryRunner queryRunner = new QueryRunner(C3P0Utils.getDataSource());
  
      //查
      //查找当前页面的所有信息
      public List<User> findPage(int a, int b) throws SQLException {
          String sql = "select * from User limit ?, ?";
          return queryRunner.query(sql, new BeanListHandler<User>(User.class), a, b);
  
      }
  
      //查找数据库所有信息的数量
      public Long findCount() throws SQLException {
          String sql = "select count(*) from User ";
          return (Long) queryRunner.query(sql, new ScalarHandler());
      }
  
  //---------------------------------------------------------------------------
  
      //增
      public int addUser(User user) throws SQLException {
          String sql = "insert into User values(null,?,?,?,?,?,?)";
          return queryRunner.update(sql, user.getName(), user.getSex(), user.getAge(), user.getAddress(), user.getQq(), user.getEmail());
      }
  
      //改
      public int updateUser(String id, User user) throws SQLException {
          String sql = "update User set name=? ,sex=?,age=?,address=?,qq=?,email=? where id=? ";
          return queryRunner.update(sql, user.getName(), user.getSex(), user.getAge(), user.getAddress(), user.getQq(), user.getEmail(), id);
      }
  
      //删
      public int deleteUser(String id) throws SQLException {
          String sql = "delete from User where id =?";
          return queryRunner.update(sql, id);
      }
  }

  ​

管理员登录jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>$Title$</title>
</head>
<script>
    function checkUsername(obj) {
        //校验用户名的格式:只能由英文字母和数字组成，长度为4～16个字符，并且以英文字母开头
        var rex = /^[a-zA-Z][a-zA-Z0-9]{3,15}$/;
        var username = obj.value;
        var b = rex.test(username);
        if (b) {
            document.getElementById("name1").innerHTML = "格式正确"
        } else {
            document.getElementById("name1").innerHTML = "<font color='red'>格式不符合要求</font>"
            document.getElementById("name1").setAttribute("sytle", "color:red");
        }
    }

    function checkword(obj) {
        //校验用户名的格式:只能由英文字母和数字组成，长度为4～16个字符，并且以英文字母开头
        var rex = /^[0-9]{6,8}$/;
        var password = obj.value;
        var b = rex.test(password);
        if (b) {
            document.getElementById("name2").innerHTML = "格式正确"
        } else {
            document.getElementById("name2").innerHTML = "<font color='red'>格式不符合要求</font>"
        }
    }

    function checkcode(obj) {
        //让系统不走缓存
        obj.src = "Code?aaaaaaa=" + new Date();
    }
</script>
<%
    Object remember = request.getSession().getAttribute("remember");
    String checked = "";
    if (remember != null) {
        checked = "checked";
    }
    String cookieid = "";
    String cookiename = "";
    String cookiepassword = "";
    Cookie[] cookies = request.getCookies();
    for (Cookie cookie : cookies) {
        if (cookie.getName().equals("cookieid")) {
            cookieid = cookie.getValue();
        }
        if (cookie.getName().equals("cookierootname")) {
            cookiename = cookie.getValue();
        }
        if (cookie.getName().equals("cookiepassword")) {
            cookiepassword = cookie.getValue();
        }
    }
%>
<body>
<h1 align="center">管理员登录页面</h1>
<center>
    <h4><font color="red">${MSG}</font></h4>
    <form action="RootServlet?method=findroot" method="post" style="background: aquamarine"><!--show-->
        工号<input type="text" name="id" placeholder="请输入您的工号" value="<%=cookieid%>" onblur="checkid(this)"/><br>
        姓名<input type="text" name="root" value="<%=cookiename%>"
                 placeholder="只能由英文字母和数字组成，长度为4～16个字符，并且以英文字母开头" onblur="checkUsername(this)"/>
        <span id="name1"></span><br/>
        密码<input type="password" name="password" placeholder="密码为6-8位" value="<%=cookiepassword%>"
                 onblur="checkword(this)"/>
        <span id="name2"></span><br/>
        验证码<input type="text" name="code" placeholder="请输入验证码"/><br/>
        <img src="Code" onclick="checkcode(this)"><font color="red">${msg}</font><br/>
        记住用户名和密码<input type="checkbox" name="remember" <%=checked%>><br/>
        <input type="submit" value="登录"/>
        <a href="RootLogin.jsp"><input type="button" value="注册?"/></a>
    </form>
</center>
</form>
</body>
</html>

超级管理员注册登录jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Root注册</title>
</head>
<body>
<center>
    <h1 align="center">Root用户登录</h1>
    <font color="red">${MSG}</font>
    <form action="RootServlet?method=findRoot" method="post">
        Root工号: <input type="text" name="id" placeholder="请输入工号"><br/>
        Root姓名: <input type="text" name="Root" placeholder="请输入姓名"><br/>
        Root密码:<input type="password" name="password" placeholder="请输入密码"><br/>
        <input type="submit" value="登录">
        <a href="index.jsp"><input type="button" value="返回"/></a> <br/>

</center>
</form>
</body>
</html>

超级管理员注册管理员jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>注册页面</title>
</head>

<script>
    function checkUsername(obj) {
        //校验用户名的格式:只能由英文字母和数字组成，长度为4～16个字符，并且以英文字母开头
        var rex = /^[a-zA-Z][a-zA-Z0-9]{3,15}$/;
        var username = obj.value;
        var b = rex.test(username);
        if (b) {
            document.getElementById("name1").innerHTML = "Right"
        } else {
            document.getElementById("name1").innerHTML = "<font color='red'>ERROR</font>"
            document.getElementById("name1").setAttribute("sytle", "color:red");
        }
    }

    function checkword(obj) {
        var rex = /^[0-9]{6,8}$/;
        var password = obj.value;
        var b = rex.test(password);
        if (b) {
            document.getElementById("name2").innerHTML = "Right"
        } else {
            document.getElementById("name2").innerHTML = "<font color='red'>ERROR</font>"
        }
    }

    function checkid(obj) {
        //校验用户名的格式:只能由数字组成
        var rex = /^[0-9]*$/;
        var password = obj.value;
        var b = rex.test(password);
        if (b) {
            document.getElementById("name2").innerHTML = "Right"
        } else {
            document.getElementById("name2").innerHTML = "<font color='red'>ERROR</font>"
        }
    }
</script>
<body>
<h1 align="center">超级管理员注册页面</h1>
<center>
    <font color="red">${MSG}</font>
    <form action="RootServlet?method=addroot" method="post"><!--show-->
        工号<input type="text" name="id" placeholder="请输入您的工号" onblur="checkid(this)"/><br/>
        姓名<input type="text" name="root" id="name" placeholder="只能由英文字母和数字组成，长度为4～16个字符，并且以英文字母开头"
                 onblur="checkUsername(this)"/>
        <span id="name1"></span><br/>
        密码<input type="text" name="password" placeholder="密码为6-8位" onblur="checkword(this)"/>
        <span id="name2"></span><br/>
        <input type="submit" value="注册"/>
        <a href="index.jsp"><input type="button" value="返回"/></a> <br>
    </form>
</center>
</body>
</html>

展示数据库信息(其中有分页效果和删除页面)jsp

• 分页是将用户点击想要跳转的页码和每页想要展示多少数据,传给后端 , 通过与后端查询的总页码(总数量/每页展示的数量)结合得出 , 按钮的数量和当前页的高亮 , 对于页数的导航的图片则是用了表格来进行排布

<%@ page import="com.lqh.Demo.Domain.Page" %>
<%@ page import="java.util.Date" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>

<%--
  Created by IntelliJ IDEA.
  User: pc
  Date: 2019/12/30
  Time: 9:51
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>数据库管理系统</title>
    <script>
        function de(name,id) {
        var b = confirm("是否真的要删除"+name+"信息");
        if(b=true){
            location.href="UserServlet?method=deleteUser&id="+id;
        }
    }
    </script>
    <%
        Page Page =(com.lqh.Demo.Domain.Page) session.getAttribute("PageBean");
        int curPage = Page.getCurPage();
        System.out.println(Page);
        request.setAttribute("preCurPage",curPage-1);
        request.setAttribute("nextCurPage",curPage+1);
        String Date = new Date().toLocaleString();
    %>
</head>


<body>
<center>
    <h1 align="center">数据库管理系统</h1>
    管理员:${root} , 亲 ! 一共查询到${PageBean.count}条记录 ,今天是<%=Date%>
    <table align="center" border="1"  width="80%" style="font-size: medium">
        <tr  align="center" bgcolor="#7fffd4" >
            <th>序号</th>
            <th>名称</th>
            <th>性别</th>
            <th>年龄</th>
            <th>地址</th>
            <th>QQ</th>
            <th>邮箱</th>
            <th>操作选项</th>
        </tr>
        <c:forEach items="${PageBean.list}"  var="user" >
            <tr align="center">
                <td>${user.id}</td>
                <td>${user.name}</td>
                <td>${user.sex}</td>
                <td>${user.age}</td>
                <td>${user.address}</td>
                <td>${user.qq}</td>
                <td>${user.email}</td>
                <td><a href="updateUser.jsp?updateid=${user.id}&updatename=${user.name}&updatesex=${user.sex}&updateage=${user.age}&updateaddress=${user.address}&updateqq=${user.qq}&updateemail=${user.email}" ><input type="button" value="修改"></a>&nbsp;<input type="button" value="删除" onclick="de('${user.name}','${user.id}')"></td>
            </tr>
        </c:forEach>
    </table><br/>
    <h6><font color="red">${MSG}</font></h6>
    <%--遍历获得总页数--%>
    <table>
    <tr>
        <c:if test="${sessionScope.PageBean.curPage<5}">
            <td>
                <c:if test="${preCurPage!=0}">
                    <a href="UserServlet?method=findPage&curPage=${preCurPage}&curSize=${PageBean.curSize}"><input type="button" value="<上一页" name="prePage"></a>
                </c:if>
            </td>
            <c:forEach begin="${1}" end="5" var="j" step="1">
                <td>
                <c:if test="${j==sessionScope.PageBean.curPage}">
                    <img src="Photo/center.jpg"><br>
                    <a href="UserServlet?method=findPage&curPage=${j}&curSize=${PageBean.curSize}"><input type="button" value="${j}" name="curPage" style="background: blue;color: white"></a>
                </c:if>
                <c:if test="${j!=sessionScope.PageBean.curPage}">
                    <img src="Photo/right.jpg"><br>
                    <a href="UserServlet?method=findPage&curPage=${j}&curSize=${PageBean.curSize}"><input type="button" value="${j}" name="curPage" ></a>
                </c:if>
                </td>
            </c:forEach>
            <td>
                <c:if test="${nextCurPage!=PageBean.sumPage+1}">
                    <a href="UserServlet?method=findPage&curPage=${nextCurPage}&curSize=${PageBean.curSize}"><input type="button" value="下一页>" name="nextPage"></a>
                </c:if>
            </td>
        </c:if>
    </tr>
</table>

<table>
    <tr>
        <c:if test="${sessionScope.PageBean.curPage>=5}">
            <td>
                <c:if test="${preCurPage!=0}">
                    <a href="UserServlet?method=findPage&curPage=${preCurPage}&curSize=${PageBean.curSize}"><input type="button" value="<上一页" name="prePage"></a>
                </c:if>
            </td>
            <c:forEach begin="${sessionScope.PageBean.curPage-2}" end="${sessionScope.PageBean.curPage-1}" var="j2" step="1">
            <td>
                    <c:if test="${j2==sessionScope.PageBean.curPage}">
                        <img src="Photo/center.jpg"><br>
                        <a href="UserServlet?method=findPage&curPage=${j2}&curSize=${PageBean.curSize}"><input type="button" value="${j2}" name="curPage" style="background: blue;color: white"></a>
                    </c:if>
                    <c:if test="${j2!=sessionScope.PageBean.curPage}">
                        <img src="Photo/right.jpg"><br>
                        <a href="UserServlet?method=findPage&curPage=${j2}&curSize=${PageBean.curSize}"><input type="button" value="${j2}" name="curPage" ></a>
                    </c:if>
            </td>
            </c:forEach>
                <c:forEach begin="${sessionScope.PageBean.curPage}" end="${sessionScope.PageBean.curPage+2}" var="j1" step="1">
                    <td>
                    <%--J小于总页数的情况--%>
                    <c:if test="${j1<=PageBean.sumPage}">
                        <c:if test="${j1==sessionScope.PageBean.curPage}">
                            <img src="Photo/center.jpg"><br>
                            <a href="UserServlet?method=findPage&curPage=${j1}&curSize=${PageBean.curSize}"><input type="button" value="${j1}" name="curPage" style="background: blue;color: white"></a>
                        </c:if>
                        <c:if test="${j1!=sessionScope.PageBean.curPage}">
                            <img src="Photo/right.jpg"><br>
                            <a href="UserServlet?method=findPage&curPage=${j1}&curSize=${PageBean.curSize}"><input type="button" value="${j1}" name="curPage" ></a>
                        </c:if>
                    </c:if>
        </td>
                </c:forEach>
            <td>
                <c:if test="${nextCurPage!=PageBean.sumPage+1}">
                    <a href="UserServlet?method=findPage&curPage=${nextCurPage}&curSize=${PageBean.curSize}"><input type="button" value="下一页>" name="nextPage"></a>
                </c:if>
            </td>
        </c:if>
    </tr>
</table>
        <a href="UserServlet?method=findPage&curPage=${PageBean.curPage}&curSize=${PageBean.curSize}"><input type="button" value="刷新"></a><br/>
        当前${PageBean.curPage}页|共计${PageBean.sumPage}页<br/><br/>
        <a href="UserServlet?method=test"> <input type="button" value="增加50个用户"></a>
    <a href="addUser.jsp"><input type="button" value="新增联系人"></a>
    <%-- 获得当前页数--%>
    <form action="UserServlet?method=findPage" method="post">
        <table align="center">
            <tr>
                <%--获得每页展示的数量--%>
                <td align="center">
                    每页展示<input type="text" name="curSize" placeholder="请输入页码,默认5">页<br/>
                    想跳转到<input type="text" name="curPage" placeholder="请输入页码,默认1">页<br/><br/>
                    <input type="submit" value="跳转到该页"><h6><font color="red">${MSG1}</font></h6>
                </td>
            </tr>
        </table>
    </form>
</center>
</body>
</html>

修改用户信息(默认将修改用户信息带到该页面)

为了方便,下面代码直接走jsp,不走Servlet

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%--
  Created by IntelliJ IDEA.
  User: pc
  Date: 2019/12/30
  Time: 14:55
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>修改信息页面</title>
</head>
<%
    String updateid = request.getParameter("updateid");
    String updatename = request.getParameter("updatename");
    String updatesex = request.getParameter("updatesex");
    String updateage = request.getParameter("updateage");
    String updateaddress = request.getParameter("updateaddress");
    String updateqq= request.getParameter("updateqq");
    String updateemail = request.getParameter("updateemail");
    request.getSession().setAttribute("updateid",updateid);
    request.getSession().setAttribute("updatename",updatename);
    request.getSession().setAttribute("updatesex",updatesex );
    request.getSession().setAttribute("updateage",updateage );
    request.getSession().setAttribute("updateaddress",updateaddress);
    request.getSession().setAttribute("updateqq",updateqq);
    request.getSession().setAttribute("updateemail",updateemail);
%>
<body>
<center>
    <h1>修改信息页面</h1>
<form action="UserServlet?method=updateUser&updateid=${updateid}" method="post">
    姓名:<br>
    <input type="text" name="name" placeholder="请输入姓名" value="${updatename}"><br>
    性别:<input type="radio" name="sex" value="男" checked>男<input type="radio" name="sex" value="女">女<br>
    年龄:<br>
    <input type="text" name="age" placeholder="请输入年龄" value="${updateage}"><br>
    籍贯:<br>
    <input type="text" name="address" placeholder="请输入籍贯" value="${updateaddress}"><br>
    QQ:<br>
    <input type="text" name="qq" placeholder="请输入QQ" value="${updateqq}"><br>
    Email:<br>
    <input type="text" name="email" placeholder="请输入邮件" value="${updateemail}"><br>
    <input type="submit" value="提交" style="background: blue">
    <a href="updateUser.jsp"><input type="button" value="重置"></a>
    <a href="UserManage.jsp"><input type="button" value="返回"></a>
    <font color="red">${MSG}</font>
</form>
</center>
</body>
</html>

新增用户jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>新增联系人</title>
</head>
<body>
<center>
    <h1>新增联系人页面</h1>
    <form action="UserServlet?method=addUser" method="post">
        姓名:<br>
        <input type="text" name="name" placeholder="请输入姓名"><br>
        性别:<input type="radio" name="sex" value="男" checked>男<input type="radio" name="sex" value="女">女<br>
        年龄:<br>
        <input type="text" name="age" placeholder="请输入年龄"><br>
        籍贯:<br>
        <input type="text" name="address" placeholder="请输入籍贯"><br>
        QQ:<br>
        <input type="text" name="qq" placeholder="请输入QQ"><br>
        Email:<br>
        <input type="text" name="email" placeholder="请输入邮件"><br>
        <input type="submit" value="提交" style="background: cyan">
        <a href="addUser.jsp"><input type="button" value="重置"></a>
        <a href="UserManage.jsp"><input type="button" value="返回"></a>
        <font color="red">${MSG}</font>
    </form>
</center>
</body>

总结

通过本次打码 加深了mysql , 三层架构 , jsp 的理解 , 同时掌握了

1 数据库增删改查操作和分页操作

2 三层架构的基本逻辑

3 浏览器会话技术数据和请求时,后台数据的处理

期间对于展示页面的分页效果 , 逻辑借鉴了百度页面 ,然后按照自己逻辑进行实现 , 好玩又有趣;

赏

小劉感谢您的赞赏

微信