基于java+mysql+JDBC+tomcat+Servlet+JSP+js的学生管理系统

转x33g5p2x  于2022-04-10 转载在 Java  
字(27.2k)|赞(0)|评价(0)|浏览(692)

实现流程和思路

项目视频演示

设置数据库studenttest

①、创建user表

创建项目

jsp页面

登录界面login.jsp

主界面mainPage.jsp

添加学生信息AddUser.jsp

修改学生信息change.jsp

Servlet下

登录LoginServlet

查找SearchServlet

删除DeleteServlet

修改ChangeServlet

添加addServlet

Service下

FileServic接口下

FileServiceImpl实现类下

pojo下

User学生类

Dao下

FileDao接口下 

FileDaoImpl实现类下

utils下

JDBCUtils

 实现流程和思路

创建jsp页面，然后转发到servlet下，接受jsp页面传过来的值，拿着这些值去访问service服务层接口，服务层写个实类，这个实现类去服务层的接口，然后这个服务层的实现类再去访问dao层的接口，在持久层dao中在编写一个dao层接口的实现类去实现dao层的接口，最后在dao层的的实现类去访问数据库。

图示：

 项目视频演示

学生管理系统项目演示

设置数据库studenttest

①、创建user表

其中包括设置删除的u_isdelete（0是存在，1是删除）

  1. create table user(
  2. u_name varchar(20),
  3. u_id int primary key auto_increment,
  4.  u_pwd varchar(20) ,
  5. u_phone varchar(20) not null,
  6. u_role  int not null,
  7. u_isdelete int not null
  8. )
  9. charset=utf8;

创建项目

项目界面总览

jsp页面

登录界面login.jsp

  1. <%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8" %>
  2. <%
  3.     String path = request.getContextPath();
  4.     String basepath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort() + path + "/";
  5. %>
  6. <html>
  7. <head>
  8.     <base href="<%=basepath %>"/>
  9.     <meta charset="utf-8"/>
  10.     <title>登录界面</title>
  11.     <%--  css代码--%>
  12.     <style>
  13.         #fame_{
  14.             width: 500px;
  15.             height: 400px;
  16.             margin-left: 600px;
  17.             margin-top: 200px;
  18.             background-color: aqua;
  19.             /*边框黑色 实线 2像素*/
  20.             border: black solid 2px;
  21.         }
  22.         #inner_{
  23.             margin-left: 140px;
  24.             margin-top: 160px;
  25.         }
  26.     </style>
  28. </head>
  29. <body>
  30. <h1 align="center" style="color: red">登录界面</h1>
  31. <div id="fame_"  >
  32.     <div id="inner_">
  33.         用户:<input type="text" id="u_id">
  34.         <b>  <span id="span1" style="color: crimson">${error}</span></b><br><br>
  35.         密码:<input type="password" id="u_pwd">
  36.         <b>  <span id="span2" style="color: crimson"></span></b><br><br>
  37.         <button id="btn01">重置</button>
  38.         <button id="btn02" style="margin-left: 20px">登录</button><br>
  40.         <script>
  41.             <%-- 这里写js代码验证账号密码值是否为空--%>
  42.               window.onload=function() {
  43.                   document.getElementById("btn02").onclick = function () {
  44.                       let id_value = document.getElementById("u_id").value
  45.                       if (id_value == null || id_value == "") {
  46.                           document.getElementById("span1").innerHTML = "用户名不能为空"
  47.                           return;
  48.                       }
  50.                       //判断密码是否为空
  51.                       let pwd = document.getElementById("u_pwd").value
  52.                       if (pwd == null || pwd == "") {
  53.                           document.getElementById("span2").innerHTML = "密码不能为空"
  54.                           return;
  55.                       }
  56.                       //跳转到servlet
  57.                       window.location.href = "login?u_id=" + id_value + "&u_pwd=" + pwd;
  58.                   }
  59.                   //在次点击清空错误信息
  60.                   document.getElementById("u_id").onfocus = function () {
  61.                       document.getElementById("span1").innerText = ""
  62.                   }
  63.                   document.getElementById("u_pwd").onfocus = function () {
  64.                       document.getElementById("span2").innerText = ""
  65.                   }
  66.                   //清空内容
  67.                   document.getElementById("btn01").onclick=function () {
  68.                       document.getElementById("u_id").value="";
  69.                       document.getElementById("u_pwd").value="";
  70.                   }
  71.               }
  72.         </script>
  73.     </div>
  74. </div>
  75. </body>
  76. </html>

主界面mainPage.jsp

  1. <%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8" %>
  2. <%
  3.     String path = request.getContextPath();
  4.     String basepath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort() + path + "/";
  5. %>
  6. <%--JSTL语法，可以使用user.getName()方法--%>
  7. <%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
  8. <html>
  9. <head>
  10.     <title>主界面</title>
  11.     <style>
  12.         #head_{
  13.             height: 100px;
  14.             width: 100%;
  15.            background-color: darkcyan;
  16.         }
  17.         #personFile{
  18.             width: 120px;
  19.             height: 50px;
  20.             padding-top: 25px;
  21.             margin-left: 90%;
  22.         }
  23.         #search{
  24.             height: 70px;
  25.             width: 100%;
  26.          background-color: aqua;
  27.         }
  28.         #inner_s{
  29.             /*width: 200px;
  30.             height: 40px;
  31.             padding-right: 70%;
  32.             padding-top: 50%;*/
  33.             width: 30%;
  34.             padding-top:25px;
  35.             padding-left: 45%;
  36.         }
  37.         #table{
  38.             margin-left: 30%;
  39.             margin-top: 30px;
  40.         }
  41.         td{
  42.             text-align: center;
  43.             height: 20px;
  44.             width: 150px;
  45.             border:  darkcyan 2px solid;
  46.             padding:6px;
  48.         }
  50.     </style>
  52. </head>
  53. <body>
  55. <div id="head_">
  56.    <h2>
  57.        <div id="personFile" >
  58.         名字:<span style="color: red">${user.getU_name()}</span><br>
  59.         编号:<span style="color: red">${user.getU_id()}</span>
  60.        </div>
  61.    </h2>
  62. </div>
  64. <div id="search">
  65.     <div id="inner_s">
  66.         <input type="text" style="font-size: 20px; height: 26px;width: 190px " id="fileId">&nbsp;&nbsp;
  67.         <button  style="font-size: 18px; height: 28px;"  id="cx"margin-left: 30px>查询</button>
  68.         <button  style="font-size: 18px; height: 28px;" id="addUser" margin-left: 100px>添加</button>
  69.         <button  style="font-size: 18px; height: 28px;" id="deleteUser">删除</button>
  70.         <button  style="font-size: 18px; height: 28px;" id="changeUser">修改</button>
  71.        <b> <span style="color: crimson">${tip}</span></b>
  72.     </div>
  73. </div>
  74. <script>
  75.            //提交
  76.     document.getElementById("cx").onclick=function(){
  77.         let v = document.getElementById('fileId').value;
  78.         //访问服务器searchServlet
  79.         window.location.href = "searchServlet?v=" + v+"&id=${user.getU_name()}";
  80.     }
  81.     //删除
  82.     document.getElementById("deleteUser").onclick=function () {
  83.        let v =document.getElementById('fileId').value;
  85.         window.location.href = "deleteServlet?v="+v+"&id=${user.getU_name()}";
  86.     }
  87.      // 添加跳转到AddUser.jsp界面
  88.     document.getElementById("addUser").onclick=function () {
  89.         window.location = "AddUser.jsp";
  90.     }
  91.          //修改，跳转到change.jsp
  92.            document.getElementById("changeUser").onclick=function () {
  93.                let v =document.getElementById('fileId').value;
  94.                window.location.href = "change.jsp";
  95.            }
  96. </script>
  98. <div>
  99.     <table id="table" style="height: 30px;width: 700px;border: black 1px solid;border-collapse:collapse;">
  101.        <tr style="font-weight: bold" >
  102.             <td>学生id</td>
  103.             <td>学生名字</td>
  104.             <td>学生电话</td>
  105.             <td>学生成绩</td>
  106.             <td>学生品行</td>
  107.         </tr>
  108.       <%--jstl语法遍历,var是一个指指针--%>
  109.         <c:forEach items="${arr}" var="item">
  110.             <tr>
  111.                 <td>${item.getU_id()}</td>
  112.                 <td>${item.getU_name()}</td>
  113.                 <td>${item.getU_phone()}</td>
  114.                 <td style="color: deeppink"> 优秀</td>
  115.                 <td style="color: red">良好</td>
  116.                 </td>
  117.             </tr>
  119.         </c:forEach>
  121.     </table>
  122. </div>
  124. <div>
  126. </div>
  129. </body>
  130. </html>

添加学生信息AddUser.jsp

  1. <%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8" %>
  2. <%
  3.     String path = request.getContextPath();
  4.     String basepath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort() + path + "/";
  5. %>
  6. <%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
  7. <html>
  8. <head>
  9.     <base href="<%=basepath %>"/>
  10.     <meta charset="utf-8"/>
  11.     <title>添加信息界面</title>
  12. </head>
  13. <style>
  14.     #div1{
  15.         width: 400px;
  16.         height: 300px;
  17.         margin-left: 600px;
  18.         margin-top: 200px;
  19.       background-color:deepskyblue;
  20.         /*边框黑色 实线 2像素*/
  21.         border: black solid 2px;
  22.     }
  24. </style>
  25. <body>
  26. <h2 align="center" >添加学生信息</h2><br><br>
  27. <div id="div1" >
  29.      <tr> 学生id:<input type="text" id="u_id" >
  30.        <span id="span01" style="color: red"></span> <br><br></tr>
  31.        <tr>  姓名:<input type="text" id="u_name" ><br><br></tr>
  32.        <tr>  密码:<input type="password" id="u_pwd"><br><br></tr>
  33.        <tr> 电话号码:<input type="text" id="u_phone"><br><br></tr>
  35. <button id="btn3">提交</button>
  36.     <script>
  37.         document.getElementById("btn3").onclick=function(){
  38.             //获取填写的数据
  39.            let u_id=document.getElementById("u_id").value;
  40.             let u_name=document.getElementById("u_name").value;
  41.             let u_pwd=document.getElementById("u_pwd").value;
  42.             let u_phone=document.getElementById("u_phone").value;
  44.            if(u_id==null||u_id==""||u_name==null||u_name==""){
  45.                document.getElementById("span01").innerText="id或名字为为空"
  46.            }else{
  47.                //把数据发送到后端，发送到servlet的addUser路径下
  48.            window.location.href="addUser?u_id="+u_id+"&u_pwd="+u_pwd+"&u_name="+u_name+"&u_phone="+u_phone+"&id=${user.getU_name()}";
  49.            }
  50.         }
  51.         document.getElementById("u_id").onfocus=function () {
  52.             document.getElementById("span01").innerText=""
  53.         }
  55.     </script>
  56. </div>
  57. </body>
  58. </html>

修改学生信息change.jsp

  1. <%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8" %>
  2. <%
  3.     String path = request.getContextPath();
  4.     String basepath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort() + path + "/";
  5. %>
  6. <html>
  7. <head>
  8.     <base href="<%=basepath %>"/>
  9.     <meta charset="utf-8"/>
  10.     <title>修改界面</title>
  11. </head>
  13. <style>
  14.     #div1{
  15.         width: 400px;
  16.         height: 300px;
  17.         margin-left: 600px;
  18.         margin-top: 200px;
  19.         background-color:deepskyblue;
  20.         /*边框黑色 实线 2像素*/
  21.         border: black solid 2px;
  22.     }
  24. </style>
  25. <body>
  26. <h2 align="center" >修改学生信息</h2><br><br>
  27. <div id="div1" >
  29.      修改的学生id:<input type="text" id="u_id" >
  30.         <span id="span01" style="color: red"></span> <br><br>
  31.    姓名:<input type="text" id="u_name" ><br><br>
  32.       密码:<input type="password" id="u_pwd"><br><br>
  33.      电话号码:<input type="text" id="u_phone"><br><br>
  35.     <button id="btn3">提交</button>
  36.     <script>
  37.         //获取填写数据
  38.         document.getElementById("btn3").onclick=function(){
  39.             let u_id=document.getElementById("u_id").value;
  40.             let u_name=document.getElementById("u_name").value;
  41.             let u_pwd=document.getElementById("u_pwd").value;
  42.             let u_phone=document.getElementById("u_phone").value;
  43.           //判断非空
  44.             if(u_id==null||u_id==""||u_name==null||u_name==""){
  45.                 document.getElementById("span01").innerText="id或名字为为空"
  46.             }else{
  47.                 //不为空就转发到后端
  48.                 window.location.href="changeUser?u_id="+u_id+"&u_pwd="+u_pwd+"&u_name="+u_name+"&u_phone="+u_phone+"&id=${user.getU_name()}";
  49.             }
  50.         }
  51.         //再次点击清除错误信息提示
  52.         document.getElementById("u_id").onfocus=function () {
  53.             document.getElementById("span01").innerText=""
  54.         }
  56.     </script>
  57. </div>
  58. </body>
  59. </html>

Servlet下

登录LoginServlet

  1. package com.StudentTest.Servlet;
  3. import com.StudentTest.pojo.User;
  4. import com.StudentTest.service.FileService;
  5. import com.StudentTest.service.FileServiceImpl;
  6. import com.StudentTest.service.LoginService;
  7. import com.StudentTest.service.LoginServiceImpl;
  9. import javax.servlet.ServletException;
  10. import javax.servlet.annotation.WebServlet;
  11. import javax.servlet.http.HttpServlet;
  12. import javax.servlet.http.HttpServletRequest;
  13. import javax.servlet.http.HttpServletResponse;
  14. import java.io.IOException;
  15. import java.util.ArrayList;
  17. @WebServlet("/login")
  18. public class LoginServlet extends HttpServlet {
  19.     @Override
  20.     protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
  21.         String u_id=null,u_pwd=null;
  22.         User u = new User();
  23.         try{//非数字异常判断
  24.           u_id = req.getParameter("u_id");
  25.            u_pwd = req.getParameter("u_pwd");
  26.             u.setU_id(Integer.valueOf(u_id));
  27.             u.setU_pwd(u_pwd);
  28.       }catch (Exception e){
  29.             req.setAttribute("error", "你输入的不是数字");
  30.             //错误就回到主界面
  31.             req.getRequestDispatcher("login.jsp").forward(req, resp);
  32.       }
  34.         //实现登录服务层的业务逻辑层，从服务层service到持久层dao
  35.         LoginService ls = new LoginServiceImpl();
  36.         //返回user这样可以看到登录的用户是谁
  37.         /**
  38.          * 如果user为空说明账号密码不一致，跳转到登录界面
  39.          * 不为空说明账号密码一致，跳转到主界面
  40.          */
  41.         User user = null;
  42.         try {
  43.             user = ls.loginService(u);
  44.         } catch (Exception e) {
  45.             e.printStackTrace();
  46.         }
  48.         if (user != null) {
  49.             FileService fs=new FileServiceImpl();
  50.             //查看所有数据
  51.             ArrayList<User> arrUser=fs.getAllStudent();
  52.             //将这些数据转发到前端
  53.             req.setAttribute("arr",arrUser);
  54.             req.setAttribute("user", user);
  55.             //跳转到主界面
  56.             req.getRequestDispatcher("mainPage.jsp").forward(req, resp);
  57.         } else {
  58.             req.setAttribute("error", "密码不匹配");
  59.             req.getRequestDispatcher("login.jsp").forward(req, resp);
  60.         }
  61.     }
  62. }

查找SearchServlet

  1. package com.StudentTest.Servlet;
  3. import com.StudentTest.pojo.User;
  4. import com.StudentTest.service.FileService;
  5. import com.StudentTest.service.FileServiceImpl;
  6. import com.StudentTest.service.LoginService;
  7. import com.StudentTest.service.LoginServiceImpl;
  9. import javax.servlet.ServletException;
  10. import javax.servlet.annotation.WebServlet;
  11. import javax.servlet.http.HttpServlet;
  12. import javax.servlet.http.HttpServletRequest;
  13. import javax.servlet.http.HttpServletResponse;
  14. import java.io.IOException;
  15. import java.util.ArrayList;
  17. @WebServlet("/login")
  18. public class LoginServlet extends HttpServlet {
  19.     @Override
  20.     protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
  21.         String u_id=null,u_pwd=null;
  22.         User u = new User();
  23.         try{//非数字异常判断
  24.           u_id = req.getParameter("u_id");
  25.            u_pwd = req.getParameter("u_pwd");
  26.             u.setU_id(Integer.valueOf(u_id));
  27.             u.setU_pwd(u_pwd);
  28.       }catch (Exception e){
  29.             req.setAttribute("error", "你输入的不是数字");
  30.             //错误就回到主界面
  31.             req.getRequestDispatcher("login.jsp").forward(req, resp);
  32.       }
  34.         //实现登录服务层的业务逻辑层，从服务层service到持久层dao
  35.         LoginService ls = new LoginServiceImpl();
  36.         //返回user这样可以看到登录的用户是谁
  37.         /**
  38.          * 如果user为空说明账号密码不一致，跳转到登录界面
  39.          * 不为空说明账号密码一致，跳转到主界面
  40.          */
  41.         User user = null;
  42.         try {
  43.             user = ls.loginService(u);
  44.         } catch (Exception e) {
  45.             e.printStackTrace();
  46.         }
  48.         if (user != null) {
  49.             FileService fs=new FileServiceImpl();
  50.             //查看所有数据
  51.             ArrayList<User> arrUser=fs.getAllStudent();
  52.             //将这些数据转发到前端
  53.             req.setAttribute("arr",arrUser);
  54.             req.setAttribute("user", user);
  55.             //跳转到主界面
  56.             req.getRequestDispatcher("mainPage.jsp").forward(req, resp);
  57.         } else {
  58.             req.setAttribute("error", "密码不匹配");
  59.             req.getRequestDispatcher("login.jsp").forward(req, resp);
  60.         }
  61.     }
  62. }

删除DeleteServlet

  1. package com.StudentTest.Servlet;
  3. import com.StudentTest.pojo.User;
  4. import com.StudentTest.service.FileService;
  5. import com.StudentTest.service.FileServiceImpl;
  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.ArrayList;
  15. @WebServlet("/deleteServlet")
  16. public class DeleteServlet  extends HttpServlet {
  17.     @Override
  18.     protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
  19.         req.setCharacterEncoding("UTF-8");
  20.         String del=req.getParameter("v");
  21.         //获取登录人信息
  22.          String adm=req.getParameter("id");
  23.          //访问service层，在service层创建对应的方法
  24.         FileService fs=new FileServiceImpl();
  25.         ArrayList<User> list=fs.getAllStudent();
  26.         //获取登录人员信息
  27.         User u = fs.getAdmint(adm);
  28.         //service层调用方法，转到dao层执行sql语句
  29.         boolean user=fs.delUser(del);
  30.         String tip="";
  31.         if(user){
  32.            tip="删除成功";
  33.         }else {
  34.             tip="删除失败";
  35.         }
  36.         //发送到前端
  37.         req.setAttribute("user", u);
  38.         req.setAttribute("arr", list);
  39.         req.setAttribute("tip", tip);
  40.         req.getRequestDispatcher("mainPage.jsp").forward(req, resp);
  41.     }
  42. }

修改ChangeServlet

  1. package com.StudentTest.Servlet;
  3. import com.StudentTest.pojo.User;
  4. import com.StudentTest.service.FileService;
  5. import com.StudentTest.service.FileServiceImpl;
  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.ArrayList;
  15. @WebServlet("/changeUser")
  16. public class ChangeServlet  extends HttpServlet {
  17.     @Override
  18.     protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
  19.         req.setCharacterEncoding("UTF-8");
  20.         String id=req.getParameter("u_id");
  21.         String pwd=req.getParameter("u_pwd");
  22.         String phone=req.getParameter("u_phone");
  23.         String name=req.getParameter("u_name");
  24.         FileService fs=new FileServiceImpl();
  25.         User user=new User(name,Integer.valueOf(id),pwd,phone);
  26.         String adm=req.getParameter("id");
  27.         //获取登录人员信息
  28.         User u = fs.getAdmint(adm);
  29.         System.out.println(u);
  30.         boolean flag=fs.changeUser( user);
  32.         ArrayList<User> list=fs.getAllStudent();
  33.         String tip="";
  34.         if (flag){
  35.             tip="修改成功";
  36.         }else{
  37.             tip="修改失败";
  38.         }
  39.         //发送到前端
  41.         req.setAttribute("tip",tip);
  42.         req.setAttribute("user", u);
  43.         req.setAttribute("arr", list);
  45.         req.getRequestDispatcher("mainPage.jsp").forward(req, resp);
  46.     }
  47. }

添加addServlet

  1. package com.StudentTest.Servlet;
  3. import com.StudentTest.pojo.User;
  4. import com.StudentTest.service.FileService;
  5. import com.StudentTest.service.FileServiceImpl;
  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.ArrayList;
  15. @WebServlet("/addUser")
  16. public class AddServlet extends HttpServlet {
  17.     @Override
  18.     protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
  19.         req.setCharacterEncoding("UTF-8");
  20.            String id=req.getParameter("u_id");
  21.            String pwd=req.getParameter("u_pwd");
  22.            String phone=req.getParameter("u_phone");
  23.           String name=req.getParameter("u_name");
  24.         FileService fs=new FileServiceImpl();
  25.         User user=new User(name,Integer.valueOf(id),pwd,phone);
  26.         String adm=req.getParameter("id");
  27.         //获取登录人员信息
  28.         User u = fs.getAdmint(adm);
  29.         System.out.println(u);
  30.       boolean flag=fs.addUser( user);
  32.         ArrayList<User> list=fs.getAllStudent();
  33.         String tip="";
  34.         if (flag){
  35.             tip="添加成功";
  36.         }else{
  37.             tip="添加失败";
  38.         }
  39.         //发送到前端
  41.       req.setAttribute("tip",tip);
  42.         req.setAttribute("user", u);
  43.         req.setAttribute("arr", list);
  45.         req.getRequestDispatcher("mainPage.jsp").forward(req, resp);
  47.     }
  48. }

Service下

FileServic接口下

  1. package com.StudentTest.service;
  3. import com.StudentTest.pojo.User;
  5. import java.util.ArrayList;
  7. public interface FileService {
  8.     ArrayList<User> getAllStudent();
  10.     User searchIdName(String v);
  11.     User getAdmint(String id);
  12.  boolean delUser(String del);
  13.   boolean addUser(User user);
  15.     boolean changeUser(User user);
  16.     User loginService(User u) throws Exception;
  17. }

FileServiceImpl实现类下

  1. package com.StudentTest.service;
  3. import com.StudentTest.Dao.FileDao;
  4. import com.StudentTest.Dao.FileDaoImpl;
  5. import com.StudentTest.pojo.User;
  7. import java.util.ArrayList;
  9. public class FileServiceImpl implements FileService {
  10.     FileDao fd= new FileDaoImpl();
  11.     @Override
  12.     public ArrayList<User> getAllStudent() {
  13.         /**
  14.          * 访问持久层
  15.          */
  17.         return fd.getAllStudent();
  18.     }
  20.     @Override
  21.     public User searchIdName(String v) {
  23.         return fd.searchIdName( v);
  24.     }
  26.     @Override
  27.     public User getAdmint(String id) {
  28.         return fd.getAdmint(id);
  29.     }
  31.     @Override
  32.     public boolean delUser(String del) {
  33.         return fd.delUser(del );
  34.     }
  36.     @Override
  37.     public boolean addUser(User user) {
  38.         return fd.addUser(user);
  39.     }
  41.     @Override
  42.     public boolean changeUser(User user) {
  43.         return fd.changeUser(user);
  44.     }
  46.     @Override
  47.     public User loginService(User u) throws Exception {
  48.         return fd.loginDao( u);
  49.     }
  51. }

pojo下

User学生类

  1. package com.StudentTest.pojo;
  3. public class User {
  4.     private String u_name;
  5.     private int u_id;
  6.     private String u_pwd;
  7.     private String u_phone;
  8.     private int u_role;
  9.     private int u_isdelete;
  11.     public User() {
  12.     }
  13.     public User(String u_name, int u_id, String u_pwd, String u_phone) {
  14.         this.u_name = u_name;
  15.         this.u_id = u_id;
  16.         this.u_pwd = u_pwd;
  17.         this.u_phone = u_phone;
  19.     }
  21.     public User(String u_name, int u_id, String u_pwd, String u_phone, int u_role, int u_isdelete) {
  22.         this.u_name = u_name;
  23.         this.u_id = u_id;
  24.         this.u_pwd = u_pwd;
  25.         this.u_phone = u_phone;
  26.         this.u_role = u_role;
  27.         this.u_isdelete = u_isdelete;
  28.     }
  30.     public String getU_name() {
  31.         return u_name;
  32.     }
  34.     public void setU_name(String u_name) {
  35.         this.u_name = u_name;
  36.     }
  38.     public int getU_id() {
  39.         return u_id;
  40.     }
  42.     public void setU_id(int u_id) {
  43.         this.u_id = u_id;
  44.     }
  46.     public String getU_pwd() {
  47.         return u_pwd;
  48.     }
  50.     public void setU_pwd(String u_pwd) {
  51.         this.u_pwd = u_pwd;
  52.     }
  54.     public String getU_phone() {
  55.         return u_phone;
  56.     }
  58.     public void setU_phone(String u_phone) {
  59.         this.u_phone = u_phone;
  60.     }
  62.     public int getU_role() {
  63.         return u_role;
  64.     }
  66.     public void setU_role(int u_role) {
  67.         this.u_role = u_role;
  68.     }
  70.     public int getU_isdelete() {
  71.         return u_isdelete;
  72.     }
  74.     public void setU_isdelete(int u_isdelete) {
  75.         this.u_isdelete = u_isdelete;
  76.     }
  78.     @Override
  79.     public String toString() {
  80.         return "User{" +
  81.                 "u_name='" + u_name + '\'' +
  82.                 ", u_id=" + u_id +
  83.                 ", u_pwd='" + u_pwd + '\'' +
  84.                 ", u_phone='" + u_phone + '\'' +
  85.                 ", u_role=" + u_role +
  86.                 ", u_isdelete=" + u_isdelete +
  87.                 '}';
  88.     }
  89. }

Dao下

FileDao接口下 

  1. package com.StudentTest.Dao;
  3. import com.StudentTest.pojo.User;
  5. import java.util.ArrayList;
  7. public interface FileDao {
  8.     ArrayList<User> getAllStudent();
  10.     User searchIdName(String v);
  12.     User getAdmint(String id);
  14.     boolean delUser(String del);
  16.    boolean addUser(User user);
  18.     boolean changeUser(User user);
  20.         User loginDao(User u) throws Exception;
  22. }

FileDaoImpl实现类下

  1. package com.StudentTest.Dao;
  3. import com.StudentTest.pojo.User;
  4. import com.utils.JDBCUtils;
  6. import java.sql.Connection;
  7. import java.sql.PreparedStatement;
  8. import java.sql.ResultSet;
  9. import java.sql.SQLException;
  10. import java.util.ArrayList;
  12. public class FileDaoImpl implements FileDao {
  14.     @Override
  15.     public User loginDao(User u) throws SQLException, ClassNotFoundException {
  16.         /**在这写数据库的内容
  17.          * 获取链接对象，获取sql语句
  18.          */
  19.         int id=u.getU_id();
  20.         String pwd=u.getU_pwd();
  21. //       //访问数据库
  22. //        User user=new User("慧宝",1001,"520","15216123240",1,0);
  23.         Connection connection= JDBCUtils.getConnection();
  24.         PreparedStatement pre =null;
  25.         ResultSet res =null;
  26.         String sql="select *from user where u_id="+id+" and u_pwd='"+pwd+"'";
  27.         try{
  28.             pre= connection.prepareStatement(sql);
  29.             res=pre.executeQuery();
  30.             User user=new User();
  31.             while(res.next()){
  32.                 user.setU_id(res.getInt("u_id"));
  33.                 user.setU_name(res.getString("u_name"));
  34.                 user.setU_pwd(res.getString("u_pwd"));
  35.                 user.setU_phone(res.getString("u_phone"));
  36.                 user.setU_role(res.getInt("u_role"));
  37.                 user.setU_isdelete(res.getInt("u_isdelete"));
  38.                 return user;
  39.             }
  41.         } catch (SQLException s){
  42.             s.printStackTrace();
  43.         }
  45.         return null;
  46.     }
  49. //获取所有学生信息
  50.     @Override
  51.     public ArrayList<User> getAllStudent() {
  52.         ArrayList<User> arr=new ArrayList<>();
  54.         Connection connection= null;
  55.         try {
  56.             connection = JDBCUtils.getConnection();
  57.         } catch (Exception e) {
  59.         }
  60.         PreparedStatement pre =null;
  61.             ResultSet res =null;
  62.             //u_role为1表示普通用户，为0为管理员，u_isdelete为0表示还在，为1表示已删除
  63.             String sql="select *from user where u_role=1 and u_isdelete=0 ";
  64.             try{
  65.                 pre= connection.prepareStatement(sql);
  66.                 res=pre.executeQuery();
  67.                 while(res.next()){
  68.                     User user=new User();
  69.                     user.setU_id(res.getInt("u_id"));
  70.                     user.setU_name(res.getString("u_name"));
  71.                     user.setU_pwd(res.getString("u_pwd"));
  72.                     user.setU_phone(res.getString("u_phone"));
  73.                     user.setU_role(res.getInt("u_role"));
  74.                     user.setU_isdelete(res.getInt("u_isdelete"));
  75.                     arr.add(user);
  76.                 }
  77.                 return arr;
  79.             } catch (SQLException s){
  80.                 s.printStackTrace();
  81.             }
  83.             return null;
  84.         }
  86.         //找指定学生
  87.     @Override
  88.     public User searchIdName(String v) {
  89.         /**
  90.          * sql
  91.          */
  92.         Connection connection= null;
  93.         try {
  94.             connection = JDBCUtils.getConnection();
  95.         } catch (Exception e) {
  97.         }
  98.         PreparedStatement pre =null;
  99.         ResultSet res =null;
  100.         //u_role为1表示普通用户，为0为管理员，u_isdelete为0表示还在，为1表示已删除
  101.         String sql="select *from user where u_id ='"+v+"'or+ u_name ='"+v+"' ";
  102.         try{
  103.             pre= connection.prepareStatement(sql);
  104.             res=pre.executeQuery();
  105.             while(res.next()){
  106.                 User user=new User();
  107.                 user.setU_id(res.getInt("u_id"));
  108.                 user.setU_name(res.getString("u_name"));
  109.                 user.setU_pwd(res.getString("u_pwd"));
  110.                 user.setU_phone(res.getString("u_phone"));
  111.                 user.setU_role(res.getInt("u_role"));
  112.                 user.setU_isdelete(res.getInt("u_isdelete"));
  114.                 return  user;
  115.             }
  117.         } catch (SQLException s){
  118.             s.printStackTrace();
  119.         }
  121.         return null;
  122.     }
  124.     //获取登录人员信息
  125.     @Override
  126.     public User getAdmint(String id) {
  127.         Connection connection= null;
  128.         try {
  129.             connection = JDBCUtils.getConnection();
  130.         } catch (Exception e) {
  132.         }
  133.         PreparedStatement pre =null;
  134.         ResultSet res =null;
  135.         String sql="select *from user where u_id ='"+id+"'or+ u_name ='"+id+"' ";
  136.        try{
  137.             pre= connection.prepareStatement(sql);
  138.             res=pre.executeQuery();
  139.             while(res.next()){
  140.                 User user=new User();
  141.                 user.setU_id(res.getInt("u_id"));
  142.                 user.setU_name(res.getString("u_name"));
  143.                 return user;
  144.             }
  146.         } catch (SQLException s){
  147.             s.printStackTrace();
  148.         }
  149.         return null;
  150.     }
  152.     //删除信息
  153.     @Override
  154.     public boolean delUser(String del) {
  155.         Connection connection= null;
  156.         try {
  157.             connection = JDBCUtils.getConnection();
  158.         } catch (Exception e) {
  160.         }
  161.         PreparedStatement pre =null;
  162.         ResultSet ress=null;
  163.         int res=0;
  164.         String sql="delete from user where u_name ='"+del+"'or + u_id ='"+del+"' ";
  165.         try{
  166.             pre= connection.prepareStatement(sql);
  167.             res=pre.executeUpdate();
  169.          if(res>0)return true;
  171.         } catch (SQLException s){
  172.             s.printStackTrace();
  173.         }
  175.         return false;
  176.     }
  178. //添加学生
  179.     @Override
  180.     public boolean addUser(User user) {
  181.         Connection connection= null;
  182.         try {
  183.             connection = JDBCUtils.getConnection();
  184.         } catch (Exception e) {
  186.         }
  187.         PreparedStatement pre =null;
  188.         ResultSet ress=null;
  189.         String name=user.getU_name();
  190.          int id=user.getU_id();
  191.          String pwd=user.getU_pwd();
  192.          String phone=user.getU_phone();
  193.         int res=0;
  194.         //"insert into user values('"+user.getU_name()+"','"+user.getU_id()+"','"+user.getU_pwd()+"','"+user.getU_phone()+"')"
  195.         String sql="insert into user(u_name,u_id,u_pwd,u_phone)\n" +
  196.                 "values('"+name+"','"+id+"','"+pwd+"','"+phone+"')";
  197.         try{
  198.             pre= connection.prepareStatement(sql);
  199.             res=pre.executeUpdate();
  200.             System.out.println(res);
  201.             if(res>=0)return true;
  203.         } catch (SQLException s){
  204.             s.printStackTrace();
  205.         }
  207.         return false;
  208.     }
  210.     //修改信息
  211.     @Override
  212.     public boolean changeUser(User user) {
  213.         Connection connection= null;
  214.         try {
  215.             connection = JDBCUtils.getConnection();
  216.         } catch (Exception e) {
  218.         }
  219.         PreparedStatement pre =null;
  220.         ResultSet ress=null;
  221.         String name=user.getU_name();
  222.         int id=user.getU_id();
  223.         String pwd=user.getU_pwd();
  224.         String phone=user.getU_phone();
  225.         int res=0,res1=0;
  226.         String sql1="delete from user where u_id="+id;
  228.         try{
  229.             pre= connection.prepareStatement(sql1);
  230.             res=pre.executeUpdate();
  231.             if (res>0){
  232.                 String sql="insert into user(u_name,u_id,u_pwd,u_phone)\n" +
  233.                         "values('"+name+"','"+id+"','"+pwd+"','"+phone+"')";
  234.                 pre= connection.prepareStatement(sql);
  235.                 res1=pre.executeUpdate();
  236.             }
  237.             System.out.println(res);
  238.             if(res1>0)return true;
  240.         } catch (SQLException s){
  241.             s.printStackTrace();
  242.         }
  244.         return false;
  245.     }
  246. }

utils下

JDBCUtils

  1. package com.utils;
  3. import java.sql.*;
  5. public class JDBCUtils {
  6.     public static Connection getConnection() throws SQLException, ClassNotFoundException {
  7.         Class.forName("com.mysql.cj.jdbc.Driver");
  8.         String url="jdbc:mysql://localhost:3306/studenttest?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone = GMT";
  9.         String username="root";
  10.         String password="123456";
  11.         Connection conn= DriverManager.getConnection(url,username,password);
  12.         return conn;
  13.     }
  15.     public static void release(Statement stmt,Connection conn){
  16.         if(stmt!=null){
  17.             try{
  18.                 stmt.close();
  19.             }catch(SQLException e){
  20.                 e.printStackTrace();
  21.             }
  22.             stmt=null;
  23.         }
  24.         if(conn!=null){
  25.             try{
  26.                 conn.close();
  27.             }catch (SQLException e){
  28.                 e.printStackTrace();
  29.             }
  30.             conn=null;
  31.         }
  32.     }
  34.     public static void release(ResultSet rs,Statement stmt,Connection conn){
  35.         if(rs!=null){
  36.             try{
  37.                 rs.close();
  38.             }catch (SQLException e){
  39.                 e.printStackTrace();
  40.             }
  41.             rs=null;
  42.         }
  43.         release(stmt,conn);
  44.     }
  45. }

还有写web-inf下lib下的jar包

版权说明 : 本文为转载文章, 版权归原作者所有 版权申明

原文链接 : https://blog.csdn.net/weixin_60719453/article/details/123872514

内容来源于网络，如有侵权，请联系作者删除！

Javamysqljdbctomcatservlet

相关文章

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新文章

    更多
    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com