软件系统定制开发基于java+mysql+JDBC+tomcat+Servlet+JSP+js的学生管理系统

目录

 软件系统定制开发实现流程和思路

 软件系统定制开发前些天发现了一个巨牛软件系统定制开发的人工智能学习网站，通俗易懂，风趣幽默，软件系统定制开发忍不住分享一下给大家。软件系统定制开发点击跳转到网站

创建jsp页面，软件系统定制开发然后转发到下，接受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>
  27.  
  28.  
  29. </head>
  30. <body>
  31. <h1 align="center" style="color: red">登录界面</h1>
  32. <div id="fame_"  >
  33.     <div id="inner_">
  34.         用户:<input type="text" id="u_id">
  35.         <b>  <span id="span1" style="color: crimson">${error}</span></b><br><br>
  36.         密码:<input type="password" id="u_pwd">
  37.         <b>  <span id="span2" style="color: crimson"></span></b><br><br>
  38.         <button id="btn01">重置</button>
  39.         <button id="btn02" style="margin-left: 20px">登录</button><br>
  40.  
  41.         <script>
  42.             <%-- 这里写js代码验证账号密码值是否为空--%>
  43.               window.onload=function() {
  44.                   document.getElementById("btn02").onclick = function () {
  45.                       let id_value = document.getElementById("u_id").value
  46.                       if (id_value == null || id_value == "") {
  47.                           document.getElementById("span1").innerHTML = "用户名不能为空"
  48.                           return;
  49.                       }
  50.  
  51.                       //判断密码是否为空
  52.                       let pwd = document.getElementById("u_pwd").value
  53.                       if (pwd == null || pwd == "") {
  54.                           document.getElementById("span2").innerHTML = "密码不能为空"
  55.                           return;
  56.                       }
  57.                       //跳转到servlet
  58.                       window.location.href = "login?u_id=" + id_value + "&u_pwd=" + pwd;
  59.                   }
  60.                   //在次点击清空错误信息
  61.                   document.getElementById("u_id").onfocus = function () {
  62.                       document.getElementById("span1").innerText = ""
  63.                   }
  64.                   document.getElementById("u_pwd").onfocus = function () {
  65.                       document.getElementById("span2").innerText = ""
  66.                   }
  67.                   //清空内容
  68.                   document.getElementById("btn01").onclick=function () {
  69.                       document.getElementById("u_id").value="";
  70.                       document.getElementById("u_pwd").value="";
  71.                   }
  72.               }
  73.         </script>
  74.     </div>
  75. </div>
  76. </body>
  77. </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;
  47.  
  48.         }
  49.  
  50.  
  51.     </style>
  52.  
  53. </head>
  54. <body>
  55.  
  56. <div id="head_">
  57.    <h2>
  58.        <div id="personFile" >
  59.         名字:<span style="color: red">${user.getU_name()}</span><br>
  60.         编号:<span style="color: red">${user.getU_id()}</span>
  61.        </div>
  62.    </h2>
  63. </div>
  64.  
  65.  
  66. <div id="search">
  67.     <div id="inner_s">
  68.         <input type="text" style="font-size: 20px; height: 26px;width: 190px " id="fileId">&nbsp;&nbsp;
  69.         <button  style="font-size: 18px; height: 28px;"  id="cx"margin-left: 30px>查询</button>
  70.         <button  style="font-size: 18px; height: 28px;" id="addUser" margin-left: 100px>添加</button>
  71.         <button  style="font-size: 18px; height: 28px;" id="deleteUser">删除</button>
  72.         <button  style="font-size: 18px; height: 28px;" id="changeUser">修改</button>
  73.        <b> <span style="color: crimson">${tip}</span></b>
  74.     </div>
  75. </div>
  76. <script>
  77.            //提交
  78.     document.getElementById("cx").onclick=function(){
  79.         let v = document.getElementById('fileId').value;
  80.         //访问服务器searchServlet
  81.         window.location.href = "searchServlet?v=" + v+"&id=${user.getU_name()}";
  82.     }
  83.     //删除
  84.     document.getElementById("deleteUser").onclick=function () {
  85.        let v =document.getElementById('fileId').value;
  86.  
  87.         window.location.href = "deleteServlet?v="+v+"&id=${user.getU_name()}";
  88.     }
  89.      // 添加跳转到AddUser.jsp界面
  90.     document.getElementById("addUser").onclick=function () {
  91.         window.location = "AddUser.jsp";
  92.     }
  93.          //修改，跳转到change.jsp
  94.            document.getElementById("changeUser").onclick=function () {
  95.                let v =document.getElementById('fileId').value;
  96.                window.location.href = "change.jsp";
  97.            }
  98. </script>
  99.  
  100. <div>
  101.     <table id="table" style="height: 30px;width: 700px;border: black 1px solid;border-collapse:collapse;">
  102.  
  103.        <tr style="font-weight: bold" >
  104.             <td>学生id</td>
  105.             <td>学生名字</td>
  106.             <td>学生电话</td>
  107.             <td>学生成绩</td>
  108.             <td>学生品行</td>
  109.         </tr>
  110.       <%--jstl语法遍历,var是一个指指针--%>
  111.         <c:forEach items="${arr}" var="item">
  112.             <tr>
  113.                 <td>${item.getU_id()}</td>
  114.                 <td>${item.getU_name()}</td>
  115.                 <td>${item.getU_phone()}</td>
  116.                 <td style="color: deeppink"> 优秀</td>
  117.                 <td style="color: red">良好</td>
  118.                 </td>
  119.             </tr>
  120.  
  121.         </c:forEach>
  122.  
  123.     </table>
  124. </div>
  125.  
  126.  
  127. <div>
  128.  
  129. </div>
  130.  
  131.  
  132.  
  133. </body>
  134. </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.     }
  23.  
  24. </style>
  25. <body>
  26. <h2 align="center" >添加学生信息</h2><br><br>
  27. <div id="div1" >
  28.  
  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>
  34.  
  35.  
  36. <button id="btn3">提交</button>
  37.     <script>
  38.         document.getElementById("btn3").onclick=function(){
  39.             //获取填写的数据
  40.            let u_id=document.getElementById("u_id").value;
  41.             let u_name=document.getElementById("u_name").value;
  42.             let u_pwd=document.getElementById("u_pwd").value;
  43.             let u_phone=document.getElementById("u_phone").value;
  44.  
  45.            if(u_id==null||u_id==""||u_name==null||u_name==""){
  46.                document.getElementById("span01").innerText="id或名字为为空"
  47.            }else{
  48.                //把数据发送到后端，发送到servlet的addUser路径下
  49.            window.location.href="addUser?u_id="+u_id+"&u_pwd="+u_pwd+"&u_name="+u_name+"&u_phone="+u_phone+"&id=${user.getU_name()}";
  50.            }
  51.         }
  52.         document.getElementById("u_id").onfocus=function () {
  53.             document.getElementById("span01").innerText=""
  54.         }
  55.  
  56.     </script>
  57. </div>
  58. </body>
  59. </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>
  12.  
  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.     }
  23.  
  24. </style>
  25. <body>
  26. <h2 align="center" >修改学生信息</h2><br><br>
  27. <div id="div1" >
  28.  
  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>
  34.  
  35.  
  36.     <button id="btn3">提交</button>
  37.     <script>
  38.         //获取填写数据
  39.         document.getElementById("btn3").onclick=function(){
  40.             let u_id=document.getElementById("u_id").value;
  41.             let u_name=document.getElementById("u_name").value;
  42.             let u_pwd=document.getElementById("u_pwd").value;
  43.             let u_phone=document.getElementById("u_phone").value;
  44.           //判断非空
  45.             if(u_id==null||u_id==""||u_name==null||u_name==""){
  46.                 document.getElementById("span01").innerText="id或名字为为空"
  47.             }else{
  48.                 //不为空就转发到后端
  49.                 window.location.href="changeUser?u_id="+u_id+"&u_pwd="+u_pwd+"&u_name="+u_name+"&u_phone="+u_phone+"&id=${user.getU_name()}";
  50.             }
  51.         }
  52.         //再次点击清除错误信息提示
  53.         document.getElementById("u_id").onfocus=function () {
  54.             document.getElementById("span01").innerText=""
  55.         }
  56.  
  57.     </script>
  58. </div>
  59. </body>
  60. </html>

Servlet下

登录LoginServlet

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

查找SearchServlet

  1. package com.StudentTest.Servlet;
  2.  
  3. import com.StudentTest.pojo.User;
  4. import com.StudentTest.service.FileService;
  5. import com.StudentTest.service.FileServiceImpl;
  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.ArrayList;
  14.  
  15. @WebServlet("/searchServlet")
  16. public class SearchServlet extends HttpServlet {
  17.     @Override
  18.     protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
  19.      //设置字符集为
  20.        req.setCharacterEncoding("UTF-8");
  21.        String v=req.getParameter("v");
  22.         //访问service层，在由service访问dao层
  23.         FileService fs=new FileServiceImpl();
  24.         //创建service方法到dao层中去访问
  25.         User u=fs.searchIdName(v);
  26.         //创建集合用来接受dao层访问后的数据
  27.         ArrayList<User> arr=new ArrayList<>();
  28.         //将数据添加到集合中去
  29.         arr.add(u);
  30.         //获取登录人员的信息
  31.         String id=req.getParameter("id");
  32.         //创建service服务层，通过service访问doa层
  33.         FileService fs2=new FileServiceImpl();
  34.         //通过一连串的访问，最终去访问
  35.         User admine=fs2.getAdmint(id);
  36.         //将登录的信息发送到前端
  37.         req.setAttribute("user", admine);
  38.       //如果访问的信息不为空
  39.         if(u!=null){
  40.             //管理员信息
  41.             req.setAttribute("arr",arr);
  42.             //跳转到主界面
  43.             req.getRequestDispatcher("mainPage.jsp").forward(req, resp);
  44.         }else{
  45.             FileService f=new FileServiceImpl();
  46.             ArrayList<User> arr2=f.getAllStudent();
  47.             req.setAttribute("arr", arr2);
  48.             req.getRequestDispatcher("mainPage.jsp").forward(req, resp);
  49.         }
  50.     }
  51. }

删除DeleteServlet

  1. package com.StudentTest.Servlet;
  2.  
  3. import com.StudentTest.pojo.User;
  4. import com.StudentTest.service.FileService;
  5. import com.StudentTest.service.FileServiceImpl;
  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.ArrayList;
  14.  
  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;
  2.  
  3. import com.StudentTest.pojo.User;
  4. import com.StudentTest.service.FileService;
  5. import com.StudentTest.service.FileServiceImpl;
  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.ArrayList;
  14.  
  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);
  31.  
  32.         ArrayList<User> list=fs.getAllStudent();
  33.         String tip="";
  34.         if (flag){
  35.             tip="修改成功";
  36.         }else{
  37.             tip="修改失败";
  38.         }
  39.         //发送到前端
  40.  
  41.         req.setAttribute("tip",tip);
  42.         req.setAttribute("user", u);
  43.         req.setAttribute("arr", list);
  44.  
  45.         req.getRequestDispatcher("mainPage.jsp").forward(req, resp);
  46.     }
  47. }

添加addServlet

  1. package com.StudentTest.Servlet;
  2.  
  3. import com.StudentTest.pojo.User;
  4. import com.StudentTest.service.FileService;
  5. import com.StudentTest.service.FileServiceImpl;
  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.ArrayList;
  14.  
  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);
  31.  
  32.         ArrayList<User> list=fs.getAllStudent();
  33.         String tip="";
  34.         if (flag){
  35.             tip="添加成功";
  36.         }else{
  37.             tip="添加失败";
  38.         }
  39.         //发送到前端
  40.  
  41.       req.setAttribute("tip",tip);
  42.         req.setAttribute("user", u);
  43.         req.setAttribute("arr", list);
  44.  
  45.         req.getRequestDispatcher("mainPage.jsp").forward(req, resp);
  46.  
  47.     }
  48. }

Service下

FileServic接口下

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

FileServiceImpl实现类下

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

pojo下

User学生类

  1. package com.StudentTest.pojo;
  2.  
  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;
  10.  
  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;
  18.  
  19.     }
  20.  
  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.     }
  29.  
  30.     public String getU_name() {
  31.         return u_name;
  32.     }
  33.  
  34.     public void setU_name(String u_name) {
  35.         this.u_name = u_name;
  36.     }
  37.  
  38.     public int getU_id() {
  39.         return u_id;
  40.     }
  41.  
  42.     public void setU_id(int u_id) {
  43.         this.u_id = u_id;
  44.     }
  45.  
  46.     public String getU_pwd() {
  47.         return u_pwd;
  48.     }
  49.  
  50.     public void setU_pwd(String u_pwd) {
  51.         this.u_pwd = u_pwd;
  52.     }
  53.  
  54.     public String getU_phone() {
  55.         return u_phone;
  56.     }
  57.  
  58.     public void setU_phone(String u_phone) {
  59.         this.u_phone = u_phone;
  60.     }
  61.  
  62.     public int getU_role() {
  63.         return u_role;
  64.     }
  65.  
  66.     public void setU_role(int u_role) {
  67.         this.u_role = u_role;
  68.     }
  69.  
  70.     public int getU_isdelete() {
  71.         return u_isdelete;
  72.     }
  73.  
  74.     public void setU_isdelete(int u_isdelete) {
  75.         this.u_isdelete = u_isdelete;
  76.     }
  77.  
  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;
  2.  
  3. import com.StudentTest.pojo.User;
  4.  
  5. import java.util.ArrayList;
  6.  
  7. public interface FileDao {
  8.     ArrayList<User> getAllStudent();
  9.  
  10.     User searchIdName(String v);
  11.  
  12.     User getAdmint(String id);
  13.  
  14.     boolean delUser(String del);
  15.  
  16.  
  17.    boolean addUser(User user);
  18.  
  19.     boolean changeUser(User user);
  20.  
  21.         User loginDao(User u) throws Exception;
  22.  
  23. }

FileDaoImpl实现类下

  1. package com.StudentTest.Dao;
  2.  
  3. import com.StudentTest.pojo.User;
  4. import com.utils.JDBCUtils;
  5.  
  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;
  11.  
  12. public class FileDaoImpl implements FileDao {
  13.  
  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","1314",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.             }
  40.  
  41.         } catch (SQLException s){
  42.             s.printStackTrace();
  43.         }
  44.  
  45.         return null;
  46.     }
  47.  
  48.  
  49.  
  50. //获取所有学生信息
  51.     @Override
  52.     public ArrayList<User> getAllStudent() {
  53.         ArrayList<User> arr=new ArrayList<>();
  54.  
  55.         Connection connection= null;
  56.         try {
  57.             connection = JDBCUtils.getConnection();
  58.         } catch (Exception e) {
  59.  
  60.         }
  61.         PreparedStatement pre =null;
  62.             ResultSet res =null;
  63.             //u_role为1表示普通用户，为0为管理员，u_isdelete为0表示还在，为1表示已删除
  64.             String sql="select *from user where u_role=1 and u_isdelete=0 ";
  65.             try{
  66.                 pre= connection.prepareStatement(sql);
  67.                 res=pre.executeQuery();
  68.                 while(res.next()){
  69.                     User user=new User();
  70.                     user.setU_id(res.getInt("u_id"));
  71.                     user.setU_name(res.getString("u_name"));
  72.                     user.setU_pwd(res.getString("u_pwd"));
  73.                     user.setU_phone(res.getString("u_phone"));
  74.                     user.setU_role(res.getInt("u_role"));
  75.                     user.setU_isdelete(res.getInt("u_isdelete"));
  76.                     arr.add(user);
  77.                 }
  78.                 return arr;
  79.  
  80.             } catch (SQLException s){
  81.                 s.printStackTrace();
  82.             }
  83.  
  84.             return null;
  85.         }
  86.  
  87.         //找指定学生
  88.     @Override
  89.     public User searchIdName(String v) {
  90.         /**
  91.          * sql
  92.          */
  93.         Connection connection= null;
  94.         try {
  95.             connection = JDBCUtils.getConnection();
  96.         } catch (Exception e) {
  97.  
  98.         }
  99.         PreparedStatement pre =null;
  100.         ResultSet res =null;
  101.         //u_role为1表示普通用户，为0为管理员，u_isdelete为0表示还在，为1表示已删除
  102.         String sql="select *from user where u_id ='"+v+"'or+ u_name ='"+v+"' ";
  103.         try{
  104.             pre= connection.prepareStatement(sql);
  105.             res=pre.executeQuery();
  106.             while(res.next()){
  107.                 User user=new User();
  108.                 user.setU_id(res.getInt("u_id"));
  109.                 user.setU_name(res.getString("u_name"));
  110.                 user.setU_pwd(res.getString("u_pwd"));
  111.                 user.setU_phone(res.getString("u_phone"));
  112.                 user.setU_role(res.getInt("u_role"));
  113.                 user.setU_isdelete(res.getInt("u_isdelete"));
  114.  
  115.                 return  user;
  116.             }
  117.  
  118.         } catch (SQLException s){
  119.             s.printStackTrace();
  120.         }
  121.  
  122.         return null;
  123.     }
  124.  
  125.     //获取登录人员信息
  126.     @Override
  127.     public User getAdmint(String id) {
  128.         Connection connection= null;
  129.         try {
  130.             connection = JDBCUtils.getConnection();
  131.         } catch (Exception e) {
  132.  
  133.         }
  134.         PreparedStatement pre =null;
  135.         ResultSet res =null;
  136.         String sql="select *from user where u_id ='"+id+"'or+ u_name ='"+id+"' ";
  137.        try{
  138.             pre= connection.prepareStatement(sql);
  139.             res=pre.executeQuery();
  140.             while(res.next()){
  141.                 User user=new User();
  142.                 user.setU_id(res.getInt("u_id"));
  143.                 user.setU_name(res.getString("u_name"));
  144.                 return user;
  145.             }
  146.  
  147.         } catch (SQLException s){
  148.             s.printStackTrace();
  149.         }
  150.         return null;
  151.     }
  152.  
  153.     //删除信息
  154.     @Override
  155.     public boolean delUser(String del) {
  156.         Connection connection= null;
  157.         try {
  158.             connection = JDBCUtils.getConnection();
  159.         } catch (Exception e) {
  160.  
  161.         }
  162.         PreparedStatement pre =null;
  163.         ResultSet ress=null;
  164.         int res=0;
  165.         String sql="delete from user where u_name ='"+del+"'or + u_id ='"+del+"' ";
  166.         try{
  167.             pre= connection.prepareStatement(sql);
  168.             res=pre.executeUpdate();
  169.  
  170.          if(res>0)return true;
  171.  
  172.         } catch (SQLException s){
  173.             s.printStackTrace();
  174.         }
  175.  
  176.         return false;
  177.     }
  178.  
  179. //添加学生
  180.     @Override
  181.     public boolean addUser(User user) {
  182.         Connection connection= null;
  183.         try {
  184.             connection = JDBCUtils.getConnection();
  185.         } catch (Exception e) {
  186.  
  187.         }
  188.         PreparedStatement pre =null;
  189.         ResultSet ress=null;
  190.         String name=user.getU_name();
  191.          int id=user.getU_id();
  192.          String pwd=user.getU_pwd();
  193.          String phone=user.getU_phone();
  194.         int res=0;
  195.         //"insert into user values('"+user.getU_name()+"','"+user.getU_id()+"','"+user.getU_pwd()+"','"+user.getU_phone()+"')"
  196.         String sql="insert into user(u_name,u_id,u_pwd,u_phone)\" +
  197.                 "values('"+name+"','"+id+"','"+pwd+"','"+phone+"')";
  198.         try{
  199.             pre= connection.prepareStatement(sql);
  200.             res=pre.executeUpdate();
  201.             System.out.println(res);
  202.             if(res>=0)return true;
  203.  
  204.         } catch (SQLException s){
  205.             s.printStackTrace();
  206.         }
  207.  
  208.         return false;
  209.     }
  210.  
  211.     //修改信息
  212.     @Override
  213.     public boolean changeUser(User user) {
  214.         Connection connection= null;
  215.         try {
  216.             connection = JDBCUtils.getConnection();
  217.         } catch (Exception e) {
  218.  
  219.         }
  220.         PreparedStatement pre =null;
  221.         ResultSet ress=null;
  222.         String name=user.getU_name();
  223.         int id=user.getU_id();
  224.         String pwd=user.getU_pwd();
  225.         String phone=user.getU_phone();
  226.         int res=0,res1=0;
  227.         String sql1="delete from user where u_id="+id;
  228.  
  229.         try{
  230.             pre= connection.prepareStatement(sql1);
  231.             res=pre.executeUpdate();
  232.             if (res>0){
  233.                 String sql="insert into user(u_name,u_id,u_pwd,u_phone)\" +
  234.                         "values('"+name+"','"+id+"','"+pwd+"','"+phone+"')";
  235.                 pre= connection.prepareStatement(sql);
  236.                 res1=pre.executeUpdate();
  237.             }
  238.             System.out.println(res);
  239.             if(res1>0)return true;
  240.  
  241.         } catch (SQLException s){
  242.             s.printStackTrace();
  243.         }
  244.  
  245.         return false;
  246.     }
  247. }
  248.

utils下

JDBCUtils

  1. package com.utils;
  2.  
  3. import java.sql.*;
  4.  
  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.     }
  14.  
  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.     }
  33.  
  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包

网站建设定制开发 软件系统开发定制 定制软件开发 软件开发定制 定制app开发 app开发定制 app开发定制公司 电商商城定制开发 定制小程序开发 定制开发小程序 客户管理系统开发定制 定制网站 定制开发 crm开发定制 开发公司 小程序开发定制 定制软件 收款定制开发 企业网站定制开发 定制化开发 android系统定制开发 定制小程序开发费用 定制设计 专注app软件定制开发 软件开发定制定制 知名网站建设定制 软件定制开发供应商 应用系统定制开发 软件系统定制开发 企业管理系统定制开发 系统定制开发