JavaWeb实现学生管理系统的超详细过程

2023-05-30 0 4,744

目录

一、项目介绍

该项目是基于JavaWeb实现的学生管理系统,使用maven进行管理jar包,能够对学生信息进行增删改查,分页查询,以及实现管理员的注册、登录

  • 数据库:MySQL
  • 开发工具:idea
  • 开发环境:jdk 1.8 + tomcat

二、项目结构

JavaWeb实现学生管理系统的超详细过程

JavaWeb实现学生管理系统的超详细过程

三、前期准备

1.配置maven环境,在pom.xml配置文件中配置项目所依赖的jar包

    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>8.0.21</version>
    </dependency>
    <dependency>
      <groupId>javax.servlet</groupId>
      <artifactId>javax.servlet-api</artifactId>
      <version>3.0.1</version>
      <scope>provided</scope>
    </dependency>
    <dependency>
      <groupId>javax.servlet.jsp</groupId>
      <artifactId>jsp-api</artifactId>
      <version>2.2</version>
      <scope>provided</scope>
    </dependency>

2.在MySql数据库中,创建登录注册表login和学生信息表student

(1)登录注册表login

JavaWeb实现学生管理系统的超详细过程

(2)学生信息表student

JavaWeb实现学生管理系统的超详细过程

(3)创建数据表代码

SET NAMES utf-8;
CREATE DATABASE studentManager;
USE studentManager;
CREATE TABLE student
(
  sno INT PRIMARY KEY,
  sname VARCHAR(20) NOT NULL,
  sex CHAR(4) ,
  age INT DEFAULT 20,
  phone VARCHAR(30) 
);
INSERT INTO student VALUES(1001,\'jack\',\'男\',23,\'13389076524\');
INSERT INTO student VALUES(1002,\'rose\',\'女\',23,\'18760987543\');
INSERT INTO student VALUES(1003,\'tom\',\'男\',23,\'13389067823\');
INSERT INTO student VALUES(1004,\'王麻子\',\'男\',23,\'13560738947\');
INSERT INTO student VALUES(1005,\'大麻子\',\'男\',23,\'18899067532\');
INSERT INTO student VALUES(1006,\'小麻子\',\'男\',23,\'15678634789\');
INSERT INTO student VALUES(1007,\'老麻子\',\'男\',23,\'12199834572\');
INSERT INTO student VALUES(1008,\'张三\',\'男\',23,\'15533098843\');
INSERT INTO student VALUES(1009,\'长萨珊\',\'女\',23,\'12209835679\');
INSERT INTO student VALUES(1010,\'李四\',\'女\',23,\'15509087635\');
INSERT INTO student VALUES(1011,\'王五\',\'男\',23,\'15788679043\');
INSERT INTO student VALUES(1012,\'赵六\',\'女\',23,\'12489034506\');
INSERT INTO student VALUES(1013,\'刘二\',\'男\',23,\'13560596743\');
CREATE TABLE login
(
  uid INT PRIMARY KEY,
  pwd VARCHAR(20) NOT NULL,
);
INSERT INTO login VALUES(1, \'1234\');
INSERT INTO login VALUES(2, \'2222\');
INSERT INTO login VALUES(3, \'6688\');

3.配置tocamt

JavaWeb实现学生管理系统的超详细过程

JavaWeb实现学生管理系统的超详细过程

四、代码实现

1.JSP界面实现

(1)首页-登录界面 (index.jsp)

<%@ page language=\"java\" contentType=\"text/html; charset=utf-8\"  pageEncoding=\"utf-8\"%>
<!DOCTYPE html>
<html>
<head>
    <title>学生信息管理平台</title>
    <style>
        .titleDiv{
            height: 85px;
            color:white;
            padding-top: 30px;
            font-size: 50px;
            padding-left: 30px;
            font-family: 隶书;
        }
        .mainDiv{
            width: 899px;
            height: 500px;
            border: 4px rgb(237, 237, 237) solid;
            border-radius: 5px;
            background-image: url(\"输入你要的图片链接!\");
            margin: auto;
            margin-top: 50px;
        }
        .loginDiv{
            height: 220px;
            width: 260px;
            padding:50px;
            background-color:rgba(255,255,255,0.9);
            border-radius:25px;
            border:1px #bdbdbd solid;
            opacity:0.9;
            float: right;
            margin-right: 100px
        }
        .name{
            font-size: 25px;
        }
        a{
            font-size:15px;
            color:#59c2c5;
            padding-left:20px;
        }
        .item{
            height:60px;
        }
        .item input{
            line-height:40px;
            width:245px;
            border:none;
            border-bottom: 1px solid #59c2c5;
            margin-bottom: 20px;
            margin-top: 10px;
        }
        .login-btn{
            display:block;
            width:255px;
            height:50px;
            color:#fff;
            background:#59c2c5;
            font-size:16px;
            line-height:30px;
            text-align:center;
            border-radius:10px;
            border:none;
            margin-bottom: 20px;
            margin-top: 10px;
        }
    </style>
</head>
<body>
<div class=\"mainDiv\">
    <div class=\"titleDiv\">学生信息管理平台</div>
    <form action=\"LoginServlet\" method=\"post\">
    <div class=\"loginDiv\">
        <div class=\"name\">
            用户登录 <a href=\"register.jsp\"> 立即注册</a>
        </div>
        <div class=item>
            <input type=\"text\" name=\"uid\" placeholder=\"用户名\"/>
        </div>
        <div class=item>
            <input type=\"password\" name=\"pwd\" placeholder=\"密码\"/>
        </div>
        <input type=\"submit\" class=\"login-btn\" value=\"登 录\"/>
        <%
            if(session.getAttribute(\"loginErrorMessage\") != null){
                String loginErrorMessage = (String)session.getAttribute(\"loginErrorMessage\");
                out.print(loginErrorMessage);
            }
        %>
        <%
            String register = (String) request.getAttribute(\"register\");
            if (register!= null) {
                if (register.equals(\"reg\")) {
                    out.println(\"注册成功, 请登录!\");
                }
            }
        %>
    </div>
    </form>
</div>
</body>
</html>

(2)用户注册界面 (register.jsp)

<%@ page language=\"java\" contentType=\"text/html; charset=utf-8\" pageEncoding=\"utf-8\"%>
<!DOCTYPE html>
<html>
<head>
    <title>注册账号</title>

    <style>
        .mainDiv{
            width: 899px;
            height: 500px;
            border: 4px rgb(237, 237, 237) solid;
            border-radius: 5px;
            background-image: url(\"输入你要的图片链接!\");
            margin: auto;
            margin-top: 50px;
        }


        .titleDiv{
            height: 85px;
            color:white;
            padding-top: 30px;
            font-size: 50px;
            padding-left: 30px;
            font-family: 隶书;
        }

        .registerDiv{
            height: 220px;
            width: 260px;
            padding:50px;
            background-color:rgba(255,255,255,0.9);
            border-radius:25px;
            border:1px #bdbdbd solid;
            opacity:0.9;
            float: right;
            margin-right: 100px
        }

        .name{
            font-size: 25px;
        }

        .item{
            height:60px;
        }

        .item input{
            line-height:40px;
            width:245px;
            border:none;
            border-bottom: 1px solid #59c2c5;
            margin-bottom: 20px;
            margin-top: 10px;
        }

        .btn{
            display:block;
            width:255px;
            height:50px;
            color:#fff;
            background:#59c2c5;
            font-size:16px;
            line-height:30px;
            text-align:center;
            border-radius:10px;
            border:none;
            margin-top: 10px;
        }

        a{
            font-size:18px;
            padding-left:200px;
            padding-bottom: 50px;
            color:#59c2c5;

        }


    </style>
</head>

</head>
<body>
<div class=\"mainDiv\">
    <div class=\"titleDiv\">学生信息管理平台</div>
    <form action = \"RegisterServlet\">
        <div class = \"registerDiv\">
            <div class = \"name\">用户注册</div>
            <div class = \"item\">
                <input type = \"text\" name = \"uid\" placeholder=\"账号\"/>
            </div>
            <div class = \"item\">
                <input type = \"password\" name = \"pwd\"  placeholder=\"密码\"/>
            </div>
            <input type = \"submit\" class = \"btn\" value = \"注册\"/>
            <a href = \"index.jsp\" >返回</a>

        </div>
    </form>
</div>
</body>
</html>

(3)登录成功-主界面 (main.jsp)

<%@ page language=\"java\" contentType=\"text/html; charset=utf-8\"  pageEncoding=\"utf-8\"%>
<%@ page import=\"com.stu.po.Student\" %>
<!DOCTYPE html>
<html >
<head>
    <title>学生信息管理平台</title>

    <style>
        .titleDiv{
            height: 85px;
            color:white;
            padding-top: 30px;
            font-size: 50px;
            padding-left: 30px;
            font-family: 隶书;
        }

        .mainDiv{
            width: 899px;
            height: 500px;
            border: 4px rgb(237, 237, 237) solid;
            border-radius: 5px;
            background-image: url(\"https://img1.baidu.com/it/u=4271373647,1745018175&fm=253&fmt=auto&app=138&f=JPEG?w=889&h=500\");
            margin: auto;
            margin-top: 50px;
            background-size: auto;
        }

        .Navigation{
            width: 899px;
            height: 200px;
            background-color:#59c2c5;
            opacity:0.8;
            text-align: center;
            line-height: 200px;
            font-family: 楷体;

        }

        a{
            font-size:30px;
            color:whitesmoke;
            padding-left:20px;
            text-decoration: none;
        }

        a:hover{
            color: blue;
            font-family: 隶书;
        }

    </style>
</head>
<body>
<div class=\"mainDiv\">
    <div class=\"titleDiv\">欢迎进入学生信息管理平台</div>
    <%
        if(session.getAttribute(\"login\") == null) {
            session.setAttribute(\"loginErrorMessage\", \"您必须先登录才能访问主页!\");
            response.sendRedirect(\"index.jsp\");
        }
    %>
    <div class=\"Navigation\">
        <a href=\"addStudent.jsp\">添加学生</a>
        <a href=\"ShowStudentsByPageServlet\">分页查询</a>
        <a href=\"ShowAllStudentsServlet\">查看所有学生信息</a>
        <a href=\"QuitServlet\">退出登录</a>
    </div>
</div>
</body>
</html>

(4)添加学生界面 (addStudent.jsp)

<%@ page contentType=\"text/html;charset=UTF-8\" language=\"java\" %>
<!DOCTYPE html>
<html>
<head>
    <title>添加学生信息</title>

    <style>
        .titleDiv{
            height: 2px;
            color:white;
            padding-top: 12px;
            font-size: 50px;
            padding-left: 30px;
            font-family: 隶书;
        }

        .mainDiv{
            width: 899px;
            height: 500px;
            border: 4px rgb(237, 237, 237) solid;
            border-radius: 5px;
            background-image: url(\"图片链接\");
            margin: auto;
            margin-top: 50px;
            background-size: auto;
        }

        .addDiv{
            height: 380px;
            width: 260px;
            padding:50px;
            background-color:rgba(255,255,255,0.9);
            border-radius:25px;
            border:1px #bdbdbd solid;
            opacity:0.9;
            float: right;
            margin-right: 80px
        }

        .name{
            font-size: 20px;

        }

        .item{
            height:60px;
        }

        .item input{
            line-height:40px;
            width:245px;
            border:none;
            border-bottom: 1px solid #59c2c5;
            margin-bottom: 20px;
            margin-top: 10px;
        }

        .btn{
            display:block;
            width:255px;
            height:50px;
            color:#fff;
            background:#59c2c5;
            font-size:16px;
            line-height:30px;
            text-align:center;
            border-radius:10px;
            border:none;
            margin-top: 10px;
        }

        a{
            font-size:18px;
            padding-left:200px;
            padding-bottom: 50px;
            color:#59c2c5;

        }

    </style>
</head>

<body>
<div class=\"mainDiv\">
    <div class=\"titleDiv\">学生信息管理平台</div>
    <form action = \"AddServlet\">
        <div class = \"addDiv\">
            <div class = \"name\">添加学生信息</div>

            <div class = \"item\">
                <input type = \"text\" name=\"sno\" placeholder=\"学号\"/>
            </div>
            <div class = \"item\">
                <input type = \"text\" name=\"sname\" placeholder=\"姓名\"/>
            </div>
            <div class = \"item\">
                <input type = \"text\" name=\"sex\" placeholder=\"性别\"/>
            </div>
            <div class = \"item\">
                <input type = \"text\" name=\"age\" placeholder=\"年龄\"/>
            </div>
            <div class = \"item\">
                <input type = \"text\" name=\"phone\" placeholder=\"电话\"/>
            </div>
            <input type = \"submit\" class = \"btn\" value = \"添加\"/>
            <a href = \"main.jsp\">返回</a>
        </div>
    </form>
</div>
</div>
</body>
</html>

(5)分页查询界面(showAllStudentByPageNo.jsp)

<%@ page import=\"com.stu.po.Student\" %>
<%@ page import=\"java.util.List\" %>
<%@ page import=\"com.stu.po.Page\" %>
<%@ page language=\"java\" contentType=\"text/html; charset=utf-8\" pageEncoding=\"utf-8\"%>
<!DOCTYPE html>
<html>
<head>

  <title>学生信息管理平台</title>

  <style>
    .mainDiv{
      width: 900px;
      height: 550px;
      border: 4px rgb(237, 237, 237) solid;
      border-radius: 5px;
      background-image: url(\"图片链接\");
      margin: auto;
      background-size: auto;
    }

    .titleDiv{
      height: 20px;
      color:white;
      padding-top: 30px;
      font-size: 50px;
      padding-left: 30px;
      font-family: 隶书;
    }

    .showStudentDiv{
      background-size: cover;
      width:700px;
      height:500px;
      margin: auto;
      margin-top: 50px;

    }

    .item{
      height:40px;
      border-radius:15px;
    }

    .item a{
      background-color: lightgrey;
      text-decoration: none;
      font-size:15px;
      color:black;
      border-radius:3px;
    }

    .item input{
      width: 20px;
      text-align: center;
    }


    table{
      width:100%;
      border-collapse:collapse;
      background-color: rgba(255,255,255,0.9);
      opacity: 0.8;
    }


    table body{
      display: block;
      height:300px;
      overflow-y: scroll;
    }
    table td{
      border:1px solid #A6A6A6;
      height:30px;
      width: 300px;
      text-align: center;
      font-size: 15px;
    }
    table th{
      height:30px;
      border:1px solid #A6A6A6;
    }

  </style>
</head>
<body>
<div class=\"mainDiv\">
  <div class=\"titleDiv\">分页查询学生信息</div>
    <div class = \"showStudentDiv\">
      <table  border=\"2\" cellspacing=\"0\">
        <tr>
          <th><h3>学号</h3></th>
          <th><h3>姓名</h3></th>
          <th><h3>性别</h3></th>
          <th><h3>年龄</h3></th>
          <th><h3>电话</h3></th>

        </tr>
        <%
          Page page1 = (Page)request.getAttribute(\"page1\");

          for(Student student:page1.getStudent()){

        %>
            <tr>
              <td><%=student.getSno() %></td>
              <td><%=student.getSname() %></td>
              <td><%=student.getSex() %></td>
              <td><%=student.getAge() %></td>
              <td><%=student.getPhone() %></td>
            </tr>
          <%
            }
          %>
      </table>

      <%
        if(page1.getCurrentPage()==page1.getTotalPage()){
      %>
        <div class = item>
          <a href = \"ShowStudentsByPageServlet?currentPage=0\">首页</a>
          <a href = \"ShowStudentsByPageServlet?currentPage=<%=page1.getCurrentPage()-1%>\">上一页</a>
          <input type = \"text\" name = \"currentPage\" value=\"<%=page1.getTotalPage()+1%>\"/>
        </div>
      <%
      } else if(page1.getCurrentPage()==0){
      %>
        <div class = item>
          <input type = \"text\" name = \"currentPage\" value=\"1\"/>
          <a href = \"ShowStudentsByPageServlet?currentPage=<%=page1.getCurrentPage()+1%>\">下一页</a>
          <a href = \"ShowStudentsByPageServlet?currentPage=<%=page1.getTotalPage()%>\">尾页</a>
        </div>
      <%
      } else{
      %>
        <div class = item>
          <a href = \"ShowStudentsByPageServlet?currentPage=0\">首页</a>
          <a href = \"ShowStudentsByPageServlet?currentPage=<%=page1.getCurrentPage()-1%>\">上一页</a>
          <input type = \"text\" name = \"currentPage\" value=\"<%=page1.getCurrentPage()+1%>\"/>
          <a href = \"ShowStudentsByPageServlet?currentPage=<%=page1.getCurrentPage()+1%>\">下一页</a>
          <a href = \"ShowStudentsByPageServlet?currentPage=<%=page1.getTotalPage()%>\">尾页</a>
        </div>
      <%
        }
      %>

      <a href = \"main.jsp\">返回</a>
    </div>
</div>
</body>
</html>

(6)查看所有学生信息界面

<%@ page language=\"java\" contentType=\"text/html; charset=utf-8\"  pageEncoding=\"utf-8\"%>
<%@ page import=\"com.stu.po.Student\" %>
<%@ page import=\"java.util.List\" %>
<!DOCTYPE html>
<html>
<head>
	<title>学生信息管理平台</title>

	<style>
		.mainDiv{
			width: 900px;
			height: 700px;
			border: 4px rgb(237, 237, 237) solid;
			border-radius: 5px;
			background-image: url(\"图片链接\");
			margin: auto;
			background-size: auto;
		}

		.titleDiv{
			height: 20px;
			color:white;
			padding-top: 30px;
			font-size: 50px;
			padding-left: 30px;
			font-family: 隶书;
		}

		.showStudentDiv{
			background-size: cover;
			width:700px;
			height:500px;
			margin: auto;
			margin-top: 50px;

		}

		.item{
			height:40px;
			border-radius:15px;
		}

		.item a{
			background-color: lightgrey;
			text-decoration: none;
			font-size:15px;
			color:black;
			border-radius:3px;
		}


		table{
			width:100%;
			border-collapse:collapse;
			background-color: rgba(255,255,255,0.9);
			opacity: 0.8;
		}


		table body{
			display: block;
			height:300px;
			overflow-y: scroll;
		}
		table td{
			border:1px solid #A6A6A6;
			height:30px;
			width: 300px;
			text-align: center;
			font-size: 15px;
		}
		table th{
			height:30px;
			border:1px solid #A6A6A6;
		}



	</style>
</head>
<body>
<div class=\"mainDiv\">
	<div class=\"titleDiv\">查看所有学生信息</div>
	<div class = \"showStudentDiv\">
		<table  border=\"2\" cellspacing=\"0\">
			<tr>
				<th><h3>学号</h3></th>
				<th><h3>姓名</h3></th>
				<th><h3>性别</h3></th>
				<th><h3>年龄</h3></th>
				<th><h3>电话</h3></th>
				<th><h3>操作</h3></th>
			</tr>
			<%

				List<Student> allStudents = (List<Student>)session.getAttribute(\"allStudents\");
				for (int i = 0; i < allStudents.size(); i++) {
					Student s  = allStudents.get(i);
			%>
			<tr>
				<td><%=s.getSno() %></td>
				<td><%=s.getSname() %></td>
				<td><%=s.getSex() %></td>
				<td><%=s.getAge() %></td>
				<td><%=s.getPhone() %></td>
				<td>
					<a href = \"DeleteServlet?sno=<%=s.getSno() %>\">删除</a>
					<a href = \"QueryStudentBySnoServlet?sno=<%=s.getSno()%>\">修改</a>
				</td>
			</tr>
			<%
				}
			%>
		</table>
		<a href = \"main.jsp\">返回</a>
	</div>

</div>
</body>
</html>

(7) 修改学生界面 (updateStudent.jsp)

<%@ page language=\"java\" contentType=\"text/html; charset=utf-8\"  pageEncoding=\"utf-8\"%>
<%@ page import=\"com.stu.po.Student\" %>
<!DOCTYPE html>
<html lang=\"en\">
<head>
    <meta charset=\"UTF-8\">
    <meta http-equiv=\"X-UA-Compatible\" content=\"IE=edge\">
    <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">
    <title>修改学生信息</title>

    <style>
        .titleDiv{
            height: 20px;
            color:white;
            padding-top: 30px;
            font-size: 50px;
            padding-left: 30px;
            font-family: 隶书;
        }

        .mainDiv{
            width: 899px;
            height: 500px;
            border: 4px rgb(237, 237, 237) solid;
            border-radius: 5px;
            background-image: url(\"https://img1.baidu.com/it/u=4271373647,1745018175&fm=253&fmt=auto&app=138&f=JPEG?w=889&h=500\");
            margin: auto;
            margin-top: 50px;
            background-size: auto;
        }

        .updateDiv{
            height: 340px;
            width: 260px;
            padding:50px;
            background-color:rgba(255,255,255,0.9);
            border-radius:25px;
            border:1px #bdbdbd solid;
            opacity:0.9;
            float: right;
            margin-right: 100px
        }

        .name{
            font-size: 25px;
        }

        .item{
            height:60px;
        }

        .item input{
            line-height:40px;
            width:245px;
            border:none;
            border-bottom: 1px solid #59c2c5;
            margin-bottom: 20px;
            margin-top: 10px;
        }

        .btn{
            display:block;
            width:255px;
            height:50px;
            color:#fff;
            background:#59c2c5;
            font-size:16px;
            line-height:30px;
            text-align:center;
            border-radius:10px;
            border:none;
            margin-top: 10px;
        }

        a{
            font-size:18px;
            padding-right:100px;
            padding-bottom: 50px;
        }

    </style>
</head>

<body>
<div class=\"mainDiv\">
    <div class=\"titleDiv\">学生信息管理平台</div>

    <form action = \"UpdateServlet\">
        <%
            Student s =(Student)request.getAttribute(\"student\");
        %>
        <div class = \"updateDiv\">
            <div class = \"name\">修改学生信息</div>
            <input type=\"hidden\" name=\"sno\" value=\"<%=s.getSno()%>\"/>
            <div class = \"item\">
                <input type = \"text\" name=\"sname\" placeholder=\"姓名\" value=\"<%=s.getSname()%>\"/>
            </div>
            <div class = \"item\">
                <input type = \"text\" name=\"sex\" placeholder=\"性别\" value=\"<%=s.getSex()%>\"/>
            </div>
            <div class = \"item\">
                <input type = \"text\" name=\"age\" placeholder=\"年龄\" value=\"<%=s.getAge()%>\"/>
            </div>
            <div class = \"item\">
                <input type = \"text\" name=\"phone\" placeholder=\"电话\" value=\"<%=s.getPhone()%>\"/>
            </div>
            <input type = \"submit\" class = \"btn\" value = \"修改\"/>
            <a href = \"showAllStudents.jsp\">返回</a>
        </div>
    </form>
</div>
</div>
</body>
</html>

2.JavaBean实体类封装数据

(1)学生信息类 (Student.java)

package com.stu.po;

public class Student {
    //这是一个实体类,javabean

    private int sno;
    private String sname;
    private String sex;
    private int age;
    private String phone;

    public Student(int sno, String sname, String sex, int age, String phone) {
        this.sno = sno;
        this.sname = sname;
        this.sex = sex;
        this.age = age;
        this.phone = phone;
    }

    public Student() {

    }

    public int getSno() {
        return sno;
    }

    public void setSno(int sno) {
        this.sno = sno;
    }

    public String getSname() {
        return sname;
    }

    public void setSname(String sname) {
        this.sname = sname;
    }

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    public int getAge() {
        return age;
    }

    public void setAge(int age) {
        this.age = age;
    }

    public String getPhone() {
        return phone;
    }

    public void setPhone(String phone) {
        this.phone = phone;
    }
}

(2)分页帮助类 (Page.java)

package com.stu.po;
import java.util.List;
//分页帮助类
public class Page {
    private int currentPage;  //当前页面
    private int pageSize;     //一页有多少条数据
    private int totalCount;   //一共有多少条数据
    private int totalPage;    //一共有多少页
    private List<Student> student;
    public Page() {
    }
    public Page(int currentPage, int pageSize, int totalCount, int totalPage, List<Student> student) {
        this.currentPage = currentPage;
        this.pageSize = pageSize;
        this.totalCount = totalCount;
        this.totalPage = totalPage;
        this.student = student;
    }
    public int getCurrentPage() {
        return currentPage;
    }
    public void setCurrentPage(int currentPage) {
        this.currentPage = currentPage;
    }
    public int getPageSize() {
        return pageSize;
    }
    public void setPageSize(int pageSize) {
        this.pageSize = pageSize;
    }
    public int getTotalCount() {
        return totalCount;
    }
    public void setTotalCount(int totalCount) {
        this.totalCount = totalCount;
    }
    public int getTotalPage() {
        return totalPage;
    }
    public void setTotalPage(int totalPage) {
        this.totalPage = totalPage;
    }
    public List<Student> getStudent() {
        return student;
    }
    public void setStudent(List<Student> student) {
        this.student = student;
    }
}

(3)JDBC工具类 (DBTools.java)

package com.stu.utils;
public interface DBTools {
    public static final String DRIVER_CLASS = \"com.mysql.jdbc.Driver\";
    public static final String CONN_STR = \"jdbc:mysql://localhost:3306/studentmanager?userSSL=false&serverTimezone=Asia/Shanghai\";
    public static final String USRENAME = \"root\";
    public static final String PWD = \"123456\";
}

3.三层架构

(1)表示层servlet

① 用户登录表示层 (LoginServlet.java)

package com.stu.servlet;
import java.io.IOException;

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 javax.servlet.http.HttpSession;

import com.stu.po.Student;
import com.stu.service.StudentService;
import com.stu.service.StudentServiceImpl;

@WebServlet(\"/LoginServlet\")
public class LoginServlet extends HttpServlet{

    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        this.doPost(req, resp);
    }

    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

        StudentService service = new StudentServiceImpl();
        HttpSession session = request.getSession();

        if (session.getAttribute(\"loginErrorMessage\") != null) {
            session.invalidate();
        }
        String uid = request.getParameter(\"uid\");
        String pwd = request.getParameter(\"pwd\");


        int _uid = Integer.parseInt(uid);
        boolean result = service.login(_uid, pwd);

        if(result){
            session.setAttribute(\"login\", \"log\");
            response.sendRedirect(\"main.jsp\");
        }else{
            response.sendRedirect(\"index.jsp\");
        }

    }

}

② 用户注册表示层 (RegisterServlet.java)

package com.stu.servlet;

import java.io.IOException;

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 javax.servlet.http.HttpSession;

import com.stu.po.Student;
import com.stu.service.StudentService;
import com.stu.service.StudentServiceImpl;

@WebServlet(\"/RegisterServlet\")
public class RegisterServlet extends HttpServlet{

    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        this.doPost(req, resp);
    }

    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

        StudentService service = new StudentServiceImpl();
        String uid = request.getParameter(\"uid\");
        String pwd = request.getParameter(\"pwd\");
        int _uid = Integer.parseInt(uid);
        boolean result = service.addLogin(_uid,pwd);

        if(!result) {
            request.setAttribute(\"register\", \"reg\");
            request.getRequestDispatcher(\"index.jsp\").forward(request, response);
        }else {
            request.getRequestDispatcher(\"register.jsp\").forward(request, response);
        }

    }

}

③ 分页查询表示层 (ShowStudentsByPageServlet.java)

package com.stu.servlet;

import java.io.IOException;
import java.util.List;

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 javax.servlet.http.HttpSession;

import com.stu.po.Page;
import com.stu.po.Student;
import com.stu.service.StudentService;
import com.stu.service.StudentServiceImpl;

@WebServlet(\"/ShowStudentsByPageServlet\")
public class ShowStudentsByPageServlet extends HttpServlet{

    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        StudentService Service = new StudentServiceImpl();
        int count = Service.getTotalCount();

        Page page = new Page();


        String currentPage = request.getParameter(\"currentPage\");

        if(currentPage == null) {
            currentPage = \"0\";
        }
        int _currentPage = Integer.parseInt(currentPage);
        page.setCurrentPage(_currentPage);

        int totalCount = Service.getTotalCount();
        page.setTotalCount(totalCount);


        int pageSize = 5;
        int totalPage = (totalCount / pageSize) + 1;
        page.setTotalPage(totalPage+1);


        page.setPageSize(pageSize);

        List<Student> student = Service.queryStudentsByPageNo(_currentPage, pageSize);
        page.setStudent(student);

        request.setAttribute(\"page1\", page);
        request.getRequestDispatcher(\"showAllStudentsByPageNo.jsp\").forward(request, response);
    }

}

④ 查询所学生信息表示层 (ShowAllStudentsServlet.java)

package com.stu.servlet;

import java.io.IOException;
import java.util.List;

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 javax.servlet.http.HttpSession;

import com.stu.po.Student;
import com.stu.service.StudentService;
import com.stu.service.StudentServiceImpl;

@WebServlet(\"/ShowAllStudentsServlet\")
public class ShowAllStudentsServlet extends HttpServlet{

    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        StudentService service = new StudentServiceImpl();
        HttpSession  session =   request.getSession();
        List<Student> allStudents = service.getAllStudents();
        session.setAttribute(\"allStudents\", allStudents);
        response.sendRedirect(\"showAllStudents.jsp\");
    }

}

⑤ 添加学生表示层 (AddServlet.java)

package com.stu.servlet;

import com.stu.po.Student;
import com.stu.service.StudentService;
import com.stu.service.StudentServiceImpl;

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 javax.servlet.http.HttpSession;
import java.io.IOException;

@WebServlet(\"/AddServlet\")
public class AddServlet extends HttpServlet{

    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        this.doPost(req, resp);
    }

    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

        StudentService service = new StudentServiceImpl();
        String sno  = request.getParameter(\"sno\");
        String sname  = request.getParameter(\"sname\");
        String sex  = request.getParameter(\"sex\");
        String age  = request.getParameter(\"age\");
        String phone  = request.getParameter(\"phone\");

        int _sno = 0;
        if(sno != null || \"\".equals(sno)){
            _sno = Integer.parseInt(sno);
        }

        int _age = 0;
        if (age !=null || \"\".equals(age)){
            _age = Integer.parseInt(age);
        }

        Student s = new Student(_sno, sname, sex, _age, phone);
        int result = service.addStudent(s);

        HttpSession session = request.getSession();
        session.setAttribute(\"student\", \"stu\");
        response.sendRedirect(\"main.jsp\");

    }
}

⑥ 删除学生表示层 (DeleteServlet.java)

package com.stu.servlet;

import com.stu.po.Student;
import com.stu.service.StudentService;
import com.stu.service.StudentServiceImpl;

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;


@WebServlet(\"/DeleteServlet\")
public class DeleteServlet extends HttpServlet {

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        //1.获取sno
        String sno = request.getParameter(\"sno\");

        int _sno = 0;
        if(sno != null && !\"\".equals(sno)){
            _sno = Integer.parseInt(sno);
        }

        //2.执行删除
        StudentService service = new StudentServiceImpl();
        Student stu = service.deleteStudent(_sno);
        //3.跳转到列表页
        request.setAttribute(\"stu\", stu);
        request.getRequestDispatcher(\"ShowAllStudentsServlet\").forward(request,response);
    }
}

⑦ 根据学号查询学生信息表示层 (QueryStudentBySnoSevlet.java)

package com.stu.servlet;

import com.stu.po.Student;
import com.stu.service.StudentService;
import com.stu.service.StudentServiceImpl;

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;



@WebServlet(\"/QueryStudentBySnoServlet\")
public class QueryStudentBySnoServlet extends HttpServlet {

    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        //获取sno;
        String sno = request.getParameter(\"sno\");
        int _sno = 0;
        if(sno != null && !\"\".equals(sno)){
            _sno = Integer.parseInt(sno);
        }

        //2.查询学生数据
        StudentService service = new StudentServiceImpl();
        Student student = service.queryStudentBySno(_sno);

        //3.显示数据
        //存数据
        request.setAttribute(\"student\", student);
        //跳转
        request.getRequestDispatcher(\"updateStudent.jsp\").forward(request,response);

    }
}

⑧ 修改学生信息表示层 (UpdateServlet.java)

package com.stu.servlet;

import com.stu.po.Student;
import com.stu.service.StudentService;
import com.stu.service.StudentServiceImpl;

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 javax.servlet.http.HttpSession;
import java.io.IOException;
import java.util.List;

@WebServlet(\"/UpdateServlet\")
public class UpdateServlet extends HttpServlet {

    protected void doGet(HttpServletRequest request, HttpServletResponse resp) throws ServletException, IOException {

        String sno = request .getParameter(\"sno\");
        String sname  = request.getParameter(\"sname\");
        String sex  = request.getParameter(\"sex\");
        String age  = request.getParameter(\"age\");
        String phone  = request.getParameter(\"phone\");

        int _sno = 0;
        if(sno != null && !\"\".equals(sno)){
            _sno = Integer.parseInt(sno);
        }
        int _age = 0;
        if(age != null && !\"\".equals(age)){
            _age = Integer.parseInt(age);
        }


        Student stu = new Student(_sno, sname, sex, _age, phone);

        StudentService service = new StudentServiceImpl();
        service.updateStudentBySno(_sno,stu);

        //3.跳转界面
        request.getRequestDispatcher(\"ShowAllStudentsServlet\").forward(request, resp);

    }
}

⑨ 退出登录表示层 (QuitServlet.java)

package com.stu.servlet;

import java.io.IOException;

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 javax.servlet.http.HttpSession;


@WebServlet(\"/QuitServlet\")
public class QuitServlet extends HttpServlet{

    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse resp) throws ServletException, IOException {
        HttpSession  session =   request.getSession();
        session.invalidate();//清空session对象中的所有属性数据内容
        resp.sendRedirect(\"index.jsp\");
    }
}

(2)业务逻辑层service

① Service接口(StudentService.java)

package com.stu.service;
import java.util.List;
import com.stu.po.Student;
public interface StudentService {
    //service表示业务逻辑层,定义的每一个方法实际上对应的就是用户的一个需求(请求)
    public boolean login(int uid,String pwd);
    public boolean addLogin(int uid, String pwd);
    public List<Student> getAllStudents();
    public List<Student> queryStudentsByPageNo(int current, int pageSize);
    public Student deleteStudent(int sno);
    public Student queryStudentBySno(int sno);
    public int updateStudentBySno(int sno, Student stu) ;
    public int getTotalCount();
    public int addStudent(Student student);
}

② 接口的实现类(StudentServiceImpl.java)

package com.stu.service;
import java.util.List;
import com.stu.dao.StudentDao;
import com.stu.dao.StudentDaoImpl;
import com.stu.po.Student;
public class StudentServiceImpl implements StudentService {
    StudentDao dao = new StudentDaoImpl();
    //登陆
    @Override
    public boolean login(int uid, String pwd) {
        return dao.login(uid, pwd);
    }
    // 注册
    @Override
    public boolean addLogin(int uid, String pwd){
        return dao.addLogin(uid, pwd);
    }
    // 查询所有学生
    @Override
    public List<Student> getAllStudents() {
        return dao.getAllStudents();
    }
    // 分页查询
    @Override
    public List<Student> queryStudentsByPageNo(int current, int pageSize) {
        return dao.queryStudentByPage(current,pageSize);
    }
    // 删除学生
    @Override
    public Student deleteStudent(int sno){
        return dao.deleteStudent(sno);
    }
    // 修改学生信息,要先根据学号查询学生信息
    public Student queryStudentBySno(int sno) {
        return dao.queryStudentBySno(sno);
    }
    //更改学生信息
    public int updateStudentBySno(int sno, Student stu) {
        return dao.updateStudentBySno(sno,stu);
    }
    //查询总条数
    @Override
    public int getTotalCount() {
        return dao.getTotalCount();
    }
    @Override
    public int addStudent(Student student) {
        return dao.addStudent(student);
    }
}

(3)数据访问层dao

① 接口(StudentDao.java)

package com.stu.dao;
import java.util.List;
import com.stu.po.Student;
public interface StudentDao {
    public boolean login(int uid ,String pwd);
    public boolean addLogin(int uid, String pwd);
    public List<Student> getAllStudents();
    public List<Student> queryStudentByPage(int currentPage,int pageSize);
    public Student deleteStudent(int sno);
    public Student queryStudentBySno(int sno);
    public int updateStudentBySno(int sno,Student stu);
    //查询总数据数
    public int getTotalCount();
    public int addStudent(Student student);
}

② 接口的实现类(StudentDaoImpl.java)

package com.stu.dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import com.stu.po.Student;
import com.stu.utils.DBTools;
public class StudentDaoImpl implements StudentDao {
    Connection conn = null; // 连接对象
    Statement st = null; // 语句对象
    ResultSet rs = null; // 结果集合对象
    @Override
    public boolean login(int uid, String pwd) {
        // 在这里需要连接数据库,根据int sno, String pwd这两个参数来查询student表
        // jdbc
        // 1:配置环境,下载数据库连接驱动jar文件,拷贝到项目中来
        // 2:加载驱动,根据驱动创建数据库的连接对象
        try {
            Class.forName(DBTools.DRIVER_CLASS);// 加载驱动
            conn = DriverManager.getConnection(DBTools.CONN_STR, DBTools.USRENAME, DBTools.PWD);
            // 3:执行sql语句,完成对数据库中表的数据的增删该查。必须创建一个语句对象(执行sql语句的)
            st = conn.createStatement();
            int count = 0;
            String sqlStr = \"select * from login where uid =\" + uid + \" and pwd = \'\" + pwd + \"\'\";
            rs = st.executeQuery(sqlStr);
            while(rs.next()) {
                count++;
            }
            if(count>0)
                return true;
            else
                return false;
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return false;
    }
    @Override
    public List<Student> getAllStudents() {
        try {
            Class.forName(DBTools.DRIVER_CLASS);// 加载驱动
            conn = DriverManager.getConnection(DBTools.CONN_STR, DBTools.USRENAME, DBTools.PWD);
            // 3:执行sql语句,完成对数据库中表的数据的增删该查。必须创建一个语句对象(执行sql语句的)
            st = conn.createStatement();
            String sqlStr = \"select * from student\";
            rs = st.executeQuery(sqlStr);
            List<Student> allStudents = new ArrayList<Student>();
            while (rs.next()) {
                int _sno = rs.getInt(1);
                String _sname = rs.getString(2);
                String _sex = rs.getString(3);
                int _age = rs.getInt(4);
                String _phone = rs.getString(5);
                Student s = new Student(_sno, _sname, _sex, _age, _phone);
                allStudents.add(s);
            }
            return allStudents;
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return null;
    }
    public List<Student> queryStudentByPage(int current, int pageSize) {
        try {
            Class.forName(DBTools.DRIVER_CLASS);// 加载驱动
            conn = DriverManager.getConnection(DBTools.CONN_STR, DBTools.USRENAME, DBTools.PWD);
            // 3:执行sql语句,完成对数据库中表的数据的增删该查。必须创建一个语句对象(执行sql语句的)
            st = conn.createStatement();
            int startPosition = current * pageSize;
            String sqlStr = \"select * from student limit \" + startPosition + \",\" + pageSize;
            rs = st.executeQuery(sqlStr);
            List<Student> allStudents = new ArrayList<Student>();
            while (rs.next()) {
                int _sno = rs.getInt(1);
                String _sname = rs.getString(2);
                String _sex = rs.getString(3);
                int _age = rs.getInt(4);
                String _phone = rs.getString(5);
                Student s = new Student(_sno, _sname, _sex, _age, _phone);
                allStudents.add(s);
            }
            return allStudents;
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return null;
    }
    public int getTotalCount() {//查询总数据数
        try {
            Class.forName(DBTools.DRIVER_CLASS);// 加载驱动
            conn = DriverManager.getConnection(DBTools.CONN_STR, DBTools.USRENAME, DBTools.PWD);
            // 3:执行sql语句,完成对数据库中表的数据的增删该查。必须创建一个语句对象(执行sql语句的)
            st = conn.createStatement();
            String sql = \"select count(*) from student\";
            rs = st.executeQuery(sql);
            while (rs.next()){
                int totalCount = rs.getInt(1);
            }
        }catch (Exception e){
            e.printStackTrace();
        }
        return 0;
    }
    @Override
    public int addStudent(Student student) {
        try {
            Class.forName(DBTools.DRIVER_CLASS);// 加载驱动
            conn = DriverManager.getConnection(DBTools.CONN_STR, DBTools.USRENAME, DBTools.PWD);
            st = conn.createStatement();
            String sqlStr = \"insert into student values(\"+student.getSno()+\",\'\" + student.getSname()+ \"\',\'\" + student.getSex() +\"\',\"+student.getAge()+\",\'\"+student.getPhone()+\"\')\";
            System.out.println(sqlStr);
            int result = st.executeUpdate(sqlStr);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return 0;
    }
    @Override
    public boolean addLogin(int uid, String pwd) {
        try {
            Class.forName(DBTools.DRIVER_CLASS);// 加载驱动
            conn = DriverManager.getConnection(DBTools.CONN_STR, DBTools.USRENAME, DBTools.PWD);
            st = conn.createStatement();
            String sqlStr = \"insert into login values(\" + uid + \",\'\" + pwd + \"\')\";
            int result = st.executeUpdate(sqlStr);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return false;
    }
    @Override
    public Student deleteStudent(int sno) {
        try {
            Class.forName(DBTools.DRIVER_CLASS);// 加载驱动
            conn = DriverManager.getConnection(DBTools.CONN_STR, DBTools.USRENAME, DBTools.PWD);
            st = conn.createStatement();
            String sqlStr = \"delete from student where sno = \" + sno;
            System.out.println(sqlStr);
            int result = st.executeUpdate(sqlStr);
        } catch (Exception e){
            e.printStackTrace();
        }
        return null;
    }
    @Override
    public Student queryStudentBySno(int sno) {
        try {
            Class.forName(DBTools.DRIVER_CLASS);// 加载驱动
            conn = DriverManager.getConnection(DBTools.CONN_STR, DBTools.USRENAME, DBTools.PWD);
            st = conn.createStatement();
            String sqlStr = \"select * from student where sno = \"+ sno;
            rs = st.executeQuery(sqlStr);
            if (rs.next()) {
                int _sno = rs.getInt(1);
                String _sname = rs.getString(2);
                String _sex = rs.getString(3);
                int _age = rs.getInt(4);
                String _phone = rs.getString(5);
                Student s = new Student(_sno, _sname, _sex, _age, _phone);
                return s;
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        return null;
    }
    @Override
    public int updateStudentBySno(int sno, Student stu){
        try {
            Class.forName(DBTools.DRIVER_CLASS);// 加载驱动
            conn = DriverManager.getConnection(DBTools.CONN_STR, DBTools.USRENAME, DBTools.PWD);
            st = conn.createStatement();
            String sql = \"update student set sname= \'\"+stu.getSname()+\"\', sex=\'\"+stu.getSex()+\"\', age=\"+stu.getAge()+\", phone=\'\"+stu.getPhone()+\"\' where sno=\"+sno;
            System.out.println(sql);
            int result = st.executeUpdate(sql);
        } catch (Exception e){
            e.printStackTrace();
        }
        return 0;
    }
}

总结

资源下载此资源下载价格为1小猪币,终身VIP免费,请先
由于本站资源来源于互联网,以研究交流为目的,所有仅供大家参考、学习,不存在任何商业目的与商业用途,如资源存在BUG以及其他任何问题,请自行解决,本站不提供技术服务! 由于资源为虚拟可复制性,下载后不予退积分和退款,谢谢您的支持!如遇到失效或错误的下载链接请联系客服QQ:442469558

:本文采用 知识共享署名-非商业性使用-相同方式共享 4.0 国际许可协议 进行许可, 转载请附上原文出处链接。
1、本站提供的源码不保证资源的完整性以及安全性,不附带任何技术服务!
2、本站提供的模板、软件工具等其他资源,均不包含技术服务,请大家谅解!
3、本站提供的资源仅供下载者参考学习,请勿用于任何商业用途,请24小时内删除!
4、如需商用,请购买正版,由于未及时购买正版发生的侵权行为,与本站无关。
5、本站部分资源存放于百度网盘或其他网盘中,请提前注册好百度网盘账号,下载安装百度网盘客户端或其他网盘客户端进行下载;
6、本站部分资源文件是经压缩后的,请下载后安装解压软件,推荐使用WinRAR和7-Zip解压软件。
7、如果本站提供的资源侵犯到了您的权益,请邮件联系: 442469558@qq.com 进行处理!

猪小侠源码-最新源码下载平台 Java教程 JavaWeb实现学生管理系统的超详细过程 http://www.20zxx.cn/763359/xuexijiaocheng/javajc.html

猪小侠源码,优质资源分享网

常见问题
  • 本站所有资源版权均属于原作者所有,均只能用于参考学习,请勿直接商用。若由于商用引起版权纠纷,一切责任均由使用者承担
查看详情
  • 最常见的情况是下载不完整: 可对比下载完压缩包的与网盘上的容量,建议提前注册好百度网盘账号,使用百度网盘客户端下载
查看详情

相关文章

官方客服团队

为您解决烦忧 - 24小时在线 专业服务