JavaWeb實(shí)現(xiàn)學(xué)生管理系統(tǒng)的超詳細(xì)過程
更新時(shí)間：2023年05月10日 11:52:14 作者：小菜鳥想逆襲
學(xué)生信息管理系統(tǒng)是針對(duì)學(xué)校人事處的大量業(yè)務(wù)處理工作而開發(fā)的管理軟件,主要用于學(xué)校學(xué)生信息管理,下面這篇文章主要給大家介紹了關(guān)于JavaWeb實(shí)現(xiàn)學(xué)生管理系統(tǒng)的超詳細(xì)過程,需要的朋友可以參考下
一、項(xiàng)目介紹
該項(xiàng)目是基于JavaWeb實(shí)現(xiàn)的學(xué)生管理系統(tǒng)，使用maven進(jìn)行管理jar包，能夠?qū)W(xué)生信息進(jìn)行增刪改查，分頁(yè)查詢，以及實(shí)現(xiàn)管理員的注冊(cè)、登錄
- 數(shù)據(jù)庫(kù)：MySQL
- 開發(fā)工具：idea
- 開發(fā)環(huán)境：jdk 1.8 + tomcat
二、項(xiàng)目結(jié)構(gòu)
三、前期準(zhǔn)備
1.配置maven環(huán)境，在pom.xml配置文件中配置項(xiàng)目所依賴的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數(shù)據(jù)庫(kù)中，創(chuàng)建登錄注冊(cè)表login和學(xué)生信息表student
（1）登錄注冊(cè)表login
（2）學(xué)生信息表student
（3）創(chuàng)建數(shù)據(jù)表代碼
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,'長(zhǎng)薩珊','女',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
四、代碼實(shí)現(xiàn)
1.JSP界面實(shí)現(xiàn)
（1）首頁(yè)-登錄界面 (index.jsp)
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
<!DOCTYPE html>
<html>
<head>
<title>學(xué)生信息管理平臺(tái)</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">學(xué)生信息管理平臺(tái)</div>
<form action="LoginServlet" method="post">
<div class="loginDiv">
<div class="name">
用戶登錄 <a href="register.jsp"> 立即注冊(cè)</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("注冊(cè)成功, 請(qǐng)登錄！");
}
}
%>
</div>
</form>
</div>
</body>
</html>（2）用戶注冊(cè)界面 (register.jsp)
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
<!DOCTYPE html>
<html>
<head>
<title>注冊(cè)賬號(hào)</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">學(xué)生信息管理平臺(tái)</div>
<form action = "RegisterServlet">
<div class = "registerDiv">
<div class = "name">用戶注冊(cè)</div>
<div class = "item">
<input type = "text" name = "uid" placeholder="賬號(hào)"/>
</div>
<div class = "item">
<input type = "password" name = "pwd" placeholder="密碼"/>
</div>
<input type = "submit" class = "btn" value = "注冊(cè)"/>
<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>學(xué)生信息管理平臺(tái)</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">歡迎進(jìn)入學(xué)生信息管理平臺(tái)</div>
<%
if(session.getAttribute("login") == null) {
session.setAttribute("loginErrorMessage", "您必須先登錄才能訪問主頁(yè)！");
response.sendRedirect("index.jsp");
}
%>
<div class="Navigation">
<a href="addStudent.jsp">添加學(xué)生</a>
<a href="ShowStudentsByPageServlet">分頁(yè)查詢</a>
<a href="ShowAllStudentsServlet">查看所有學(xué)生信息</a>
<a href="QuitServlet">退出登錄</a>
</div>
</div>
</body>
</html>
（4）添加學(xué)生界面 (addStudent.jsp)
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<!DOCTYPE html>
<html>
<head>
<title>添加學(xué)生信息</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">學(xué)生信息管理平臺(tái)</div>
<form action = "AddServlet">
<div class = "addDiv">
<div class = "name">添加學(xué)生信息</div>
<div class = "item">
<input type = "text" name="sno" placeholder="學(xué)號(hào)"/>
</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）分頁(yè)查詢界面（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>學(xué)生信息管理平臺(tái)</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">分頁(yè)查詢學(xué)生信息</div>
<div class = "showStudentDiv">
<table border="2" cellspacing="0">
<tr>
<th><h3>學(xué)號(hào)</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">首頁(yè)</a>
<a href = "ShowStudentsByPageServlet?currentPage=<%=page1.getCurrentPage()-1%>">上一頁(yè)</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%>">下一頁(yè)</a>
<a href = "ShowStudentsByPageServlet?currentPage=<%=page1.getTotalPage()%>">尾頁(yè)</a>
</div>
<%
} else{
%>
<div class = item>
<a href = "ShowStudentsByPageServlet?currentPage=0">首頁(yè)</a>
<a href = "ShowStudentsByPageServlet?currentPage=<%=page1.getCurrentPage()-1%>">上一頁(yè)</a>
<input type = "text" name = "currentPage" value="<%=page1.getCurrentPage()+1%>"/>
<a href = "ShowStudentsByPageServlet?currentPage=<%=page1.getCurrentPage()+1%>">下一頁(yè)</a>
<a href = "ShowStudentsByPageServlet?currentPage=<%=page1.getTotalPage()%>">尾頁(yè)</a>
</div>
<%
}
%>
<a href = "main.jsp">返回</a>
</div>
</div>
</body>
</html>（6）查看所有學(xué)生信息界面
<%@ 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>學(xué)生信息管理平臺(tái)</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">查看所有學(xué)生信息</div>
<div class = "showStudentDiv">
<table border="2" cellspacing="0">
<tr>
<th><h3>學(xué)號(hào)</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） 修改學(xué)生界面 (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>修改學(xué)生信息</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">學(xué)生信息管理平臺(tái)</div>
<form action = "UpdateServlet">
<%
Student s =(Student)request.getAttribute("student");
%>
<div class = "updateDiv">
<div class = "name">修改學(xué)生信息</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實(shí)體類封裝數(shù)據(jù)
（1）學(xué)生信息類 (Student.java)
package com.stu.po;
public class Student {
//這是一個(gè)實(shí)體類，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）分頁(yè)幫助類 (Page.java)
package com.stu.po;
import java.util.List;
//分頁(yè)幫助類
public class Page {
private int currentPage; //當(dāng)前頁(yè)面
private int pageSize; //一頁(yè)有多少條數(shù)據(jù)
private int totalCount; //一共有多少條數(shù)據(jù)
private int totalPage; //一共有多少頁(yè)
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.三層架構(gòu)
（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");
}
}
}② 用戶注冊(cè)表示層 (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);
}
}
}③ 分頁(yè)查詢表示層 (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);
}
}④ 查詢所學(xué)生信息表示層 (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");
}
}⑤ 添加學(xué)生表示層 (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");
}
}⑥ 刪除學(xué)生表示層 (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.執(zhí)行刪除
StudentService service = new StudentServiceImpl();
Student stu = service.deleteStudent(_sno);
//3.跳轉(zhuǎn)到列表頁(yè)
request.setAttribute("stu", stu);
request.getRequestDispatcher("ShowAllStudentsServlet").forward(request,response);
}
}⑦ 根據(jù)學(xué)號(hào)查詢學(xué)生信息表示層 (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.查詢學(xué)生數(shù)據(jù)
StudentService service = new StudentServiceImpl();
Student student = service.queryStudentBySno(_sno);
//3.顯示數(shù)據(jù)
//存數(shù)據(jù)
request.setAttribute("student", student);
//跳轉(zhuǎn)
request.getRequestDispatcher("updateStudent.jsp").forward(request,response);
}
}⑧ 修改學(xué)生信息表示層 (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.跳轉(zhuǎn)界面
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對(duì)象中的所有屬性數(shù)據(jù)內(nèi)容
resp.sendRedirect("index.jsp");
}
}（2）業(yè)務(wù)邏輯層service
① Service接口（StudentService.java）
package com.stu.service;
import java.util.List;
import com.stu.po.Student;
public interface StudentService {
//service表示業(yè)務(wù)邏輯層,定義的每一個(gè)方法實(shí)際上對(duì)應(yīng)的就是用戶的一個(gè)需求(請(qǐng)求)
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);
}② 接口的實(shí)現(xiàn)類（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);
}
// 注冊(cè)
@Override
public boolean addLogin(int uid, String pwd){
return dao.addLogin(uid, pwd);
}
// 查詢所有學(xué)生
@Override
public List<Student> getAllStudents() {
return dao.getAllStudents();
}
// 分頁(yè)查詢
@Override
public List<Student> queryStudentsByPageNo(int current, int pageSize) {
return dao.queryStudentByPage(current,pageSize);
}
// 刪除學(xué)生
@Override
public Student deleteStudent(int sno){
return dao.deleteStudent(sno);
}
// 修改學(xué)生信息，要先根據(jù)學(xué)號(hào)查詢學(xué)生信息
public Student queryStudentBySno(int sno) {
return dao.queryStudentBySno(sno);
}
//更改學(xué)生信息
public int updateStudentBySno(int sno, Student stu) {
return dao.updateStudentBySno(sno,stu);
}
//查詢總條數(shù)
@Override
public int getTotalCount() {
return dao.getTotalCount();
}
@Override
public int addStudent(Student student) {
return dao.addStudent(student);
}
}（3）數(shù)據(jù)訪問層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);
//查詢總數(shù)據(jù)數(shù)
public int getTotalCount();
public int addStudent(Student student);
}② 接口的實(shí)現(xiàn)類（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; // 連接對(duì)象
Statement st = null; // 語句對(duì)象
ResultSet rs = null; // 結(jié)果集合對(duì)象
@Override
public boolean login(int uid, String pwd) {
// 在這里需要連接數(shù)據(jù)庫(kù)，根據(jù)int sno, String pwd這兩個(gè)參數(shù)來查詢student表
// jdbc
// 1:配置環(huán)境，下載數(shù)據(jù)庫(kù)連接驅(qū)動(dòng)jar文件，拷貝到項(xiàng)目中來
// 2:加載驅(qū)動(dòng)，根據(jù)驅(qū)動(dòng)創(chuàng)建數(shù)據(jù)庫(kù)的連接對(duì)象
try {
Class.forName(DBTools.DRIVER_CLASS);// 加載驅(qū)動(dòng)
conn = DriverManager.getConnection(DBTools.CONN_STR, DBTools.USRENAME, DBTools.PWD);
// 3:執(zhí)行sql語句，完成對(duì)數(shù)據(jù)庫(kù)中表的數(shù)據(jù)的增刪該查。必須創(chuàng)建一個(gè)語句對(duì)象（執(zhí)行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);// 加載驅(qū)動(dòng)
conn = DriverManager.getConnection(DBTools.CONN_STR, DBTools.USRENAME, DBTools.PWD);
// 3:執(zhí)行sql語句，完成對(duì)數(shù)據(jù)庫(kù)中表的數(shù)據(jù)的增刪該查。必須創(chuàng)建一個(gè)語句對(duì)象（執(zhí)行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);// 加載驅(qū)動(dòng)
conn = DriverManager.getConnection(DBTools.CONN_STR, DBTools.USRENAME, DBTools.PWD);
// 3:執(zhí)行sql語句，完成對(duì)數(shù)據(jù)庫(kù)中表的數(shù)據(jù)的增刪該查。必須創(chuàng)建一個(gè)語句對(duì)象（執(zhí)行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() {//查詢總數(shù)據(jù)數(shù)
try {
Class.forName(DBTools.DRIVER_CLASS);// 加載驅(qū)動(dòng)
conn = DriverManager.getConnection(DBTools.CONN_STR, DBTools.USRENAME, DBTools.PWD);
// 3:執(zhí)行sql語句，完成對(duì)數(shù)據(jù)庫(kù)中表的數(shù)據(jù)的增刪該查。必須創(chuàng)建一個(gè)語句對(duì)象（執(zhí)行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);// 加載驅(qū)動(dòng)
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);// 加載驅(qū)動(dòng)
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);// 加載驅(qū)動(dòng)
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);// 加載驅(qū)動(dòng)
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);// 加載驅(qū)動(dòng)
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;
}
}總結(jié)
到此這篇關(guān)于JavaWeb實(shí)現(xiàn)學(xué)生管理系統(tǒng)的文章就介紹到這了,更多相關(guān)JavaWeb學(xué)生管理系統(tǒng)內(nèi)容請(qǐng)搜索腳本之家以前的文章或繼續(xù)瀏覽下面的相關(guān)文章希望大家以后多多支持腳本之家！
相關(guān)文章
SpringBoot自定義HttpMessageConverter操作
這篇文章主要介紹了SpringBoot自定義HttpMessageConverter的操作，具有很好的參考價(jià)值，如有錯(cuò)誤或未考慮完全的地方，望不吝賜教2021-08-08
使用maven-assembly-plugin如何將system 依賴范圍的jar以class 方式
這篇文章主要介紹了使用maven-assembly-plugin如何將system 依賴范圍的jar以class 方式打包進(jìn) jar包中,本文給大家分享完美解決思路，結(jié)合實(shí)例代碼給大家介紹的非常詳細(xì)，需要的朋友可以參考下2023-06-06
Java實(shí)現(xiàn)Kruskal算法的示例代碼
Kruskal算法是一種用來尋找最小生成樹的算法，由Joseph Kruskal在1956年發(fā)表。用來解決同樣問題的還有Prim算法和Boruvka算法等。本文將介紹用Java語言實(shí)現(xiàn)Kruskal算法的示例代碼，需要的可以參考一下2022-07-07
本文主要介紹了SpringBoot讀取配置的6種方式，主要包括使用默認(rèn)配置、使用application.properties文件、使用application.yml文件、使用@Value注解、使用Environment對(duì)象和使用ConfigurableEnvironment對(duì)象，感興趣的可以了解一下2023-08-08
Java中SimpleDateFormat方法超詳細(xì)分析
這篇文章主要給大家介紹了關(guān)于Java中SimpleDateFormat方法超詳細(xì)分析的相關(guān)資料,SimpleDateFormat 是一個(gè)以國(guó)別敏感的方式格式化和分析數(shù)據(jù)的具體類,文中通過代碼介紹的非常詳細(xì),需要的朋友可以參考下2023-08-08
這篇文章主要介紹了Netty粘包拆包問題解決方案,文中通過示例代碼介紹的非常詳細(xì)，對(duì)大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價(jià)值,需要的朋友可以參考下2020-08-08
java項(xiàng)目發(fā)布到j(luò)ar之后找不到文件路徑，遇到這樣問題如何處理呢，下面小編給大家分享獲取jar包resources文件路徑的解決方法，感興趣的朋友一起看看吧2023-12-12
這篇文章主要介紹了lombok @Accessors用法詳解，文中通過示例代碼介紹的非常詳細(xì)，對(duì)大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價(jià)值，需要的朋友們下面隨著小編來一起學(xué)習(xí)學(xué)習(xí)吧2020-11-11
Eclipse的Debug調(diào)試技巧大全（總結(jié)）
這篇文章主要介紹了Eclipse的Debug調(diào)試技巧大全（總結(jié)）,小編覺得挺不錯(cuò)的，現(xiàn)在分享給大家，也給大家做個(gè)參考。一起跟隨小編過來看看吧2017-12-12
SpringMVC整合SSM實(shí)現(xiàn)表現(xiàn)層數(shù)據(jù)封裝詳解
這篇文章主要介紹了SpringMVC整合SSM實(shí)現(xiàn)表現(xiàn)層數(shù)據(jù)封裝，文中通過示例代碼介紹的非常詳細(xì)，對(duì)大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價(jià)值，需要的朋友們下面隨著小編來一起學(xué)習(xí)吧2022-10-10