devbox
花生_TL007
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

Javaweb学生信息管理系统（Mysql+JSP+MVC+CSS）_图书馆学生注册信息web

作者：花生_TL007 | 2024-06-11 03:13:37

赞

踩

图书馆学生注册信息web

项目源码及数据库：

链接：https://pan.baidu.com/s/1ktUyxbOI9lljWr-HRTRIiQ?pwd=1024
提取码：1024

 

目录

一.项目介绍

二.运行效果

1.登录界面

2.主界面（点击学号修改学生信息）

3.增加学生界面

​编辑

三.项目目录结构

 四.代码展示

1.jsp及css代码

 ①登录界面代码（login.jsp）

②登录界面css（login.css）

③注册用户界面（register.jsp）

④注册用户界面css（index.css）

⑤修改密码界面（UpdateLoginID.jsp）

⑥注销用户界面（DeleteLoginID.jsp）

⑦登录成功主界面（index.jsp）

⑧登陆成功界面css（show.css）

⑨点击学号，修改学生信息界面（StudentInfo.jsp）

⑩增加学生信息（add.jsp）

⑪上传作业操作（UpAndDown.jsp）

2.三层架构

①表示层Servlet

②业务逻辑层Service

③数据访问层Dao

④通用的数据库操作（DBUtils.java）

3.JavaBean封装数据

①分页帮助类（Page.java）

②封装学生信息（Student.java）

4.项目所需jar包

五.数据库表格

①登录注册表格login

②学生信息表格student1

一.项目介绍

本系统主要实现对基于Javaweb学生信息管理系统所需的各项基本功能，能够对学生信息进行增删改查等功能，并可以实现用户注册、用户登陆等功能。

数据库：Mysql

开发工具：Eclipse

开发环境：JDK+Tomcat

二.运行效果

1.登录界面

2.主界面（点击学号修改学生信息）

3.增加学生界面

三.项目目录结构

 四.代码展示

1.jsp及css代码

 ①登录界面代码（login.jsp）

  1. <%@ page language="java" contentType="text/html; charset=UTF-8"
  2. 	pageEncoding="UTF-8"%>
  3. <!DOCTYPE html>
  4. <html>
  5. <head>
  6. <link href="css/login.css" type="text/css" rel="stylesheet">
  7. <meta charset="UTF-8">
  8.  
  9. <title>学生信息管理系统-登录界面</title>
  10. </head>
  11. <body>
  12. 	<form action="CheckLoginServlet" method="post">
  13. 		<div class="content">
  14. 			<div class="wrap">
  15. 				<div class="login-box">
  16. 					<div class="login-frame">
  17. 						<h2>
  18. 							用户登录 <a href="register.jsp"> 立即注册</a>
  19. 						</h2>
  20. 						<div class=item>
  21. 							<input type="text" name="UID" placeholder="用户名">
  22. 						</div>
  23. 						<div class=item>
  24. 							<input type="password" name="upwd" placeholder="密码">
  25. 						</div>
  26. 						<input type="submit" class="login-btn" value="登 录">
  27. 						<div class=item1>
  28. 							<a href="UpdateLoginPwd.jsp"> 修改密码</a> 
  29. 							<a	href="DeleteLoginID.jsp"> 注销用户</a>
  30. 						</div>
  31. 						<%
  32. 							String error = (String) request.getAttribute("error");
  33. 							String error0 = (String) request.getAttribute("error0");
  34. 							String error1 = (String) request.getAttribute("error1");
  35. 							String error2 = (String) request.getAttribute("error2");
  36. 							String error3 = (String) request.getAttribute("error3");
  37. 							String error4 = (String) request.getAttribute("error4");
  38.  
  39. 							if (error != null) {
  40. 								if (error.equals("loginError")) {
  41. 									out.println("用户名或密码错误！登录失败！");
  42. 								} else if (error.equals("nologinError")) {
  43. 									response.sendRedirect("QueryStudentByPageServlet");
  44. 								}
  45. 							}
  46.  
  47. 							if (error0 != null) {
  48. 								if (error0.equals("loginError")) {
  49. 									out.println("用户名或密码错误！修改失败！");
  50. 								} else if (error0.equals("nologinError")) {
  51. 									if (error1 != null) {
  52. 								if (error1.equals("noupdateError")) {
  53. 									out.println("密码修改成功！");
  54. 								}
  55. 									}
  56. 								}
  57. 							}
  58. 							if (error2 != null) {
  59. 								if (error2.equals("loginError")) {
  60. 									out.println("用户名或密码错误！注销失败！");
  61. 								} else if (error2.equals("nologinError")) {
  62. 									if (error3 != null) {
  63. 								if (error3.equals("nodeleteError")) {
  64. 									out.println("账户注销成功！");
  65. 								}
  66. 									}
  67. 								}
  68. 							}
  69. 							if (error4 != null) {
  70. 								if (error4.equals("noaddError")) {
  71. 									out.println("账户注册成功！");
  72. 								}
  73. 							}
  74. 							%>
  75. 						</div>
  76. 					</div>
  77. 				</div>
  78. 			</div>
  79. 	</form>
  80.  
  81. </body>
  82.  
  83.  
  84.  
  85. </html>

②登录界面css（login.css）

  1. *{margin:0;padding:0;}
  2. a{text-decoration:none;color:#666;}
  3. a:hover{
  4. 	text-decoration:underline;
  5. 	color:E4393C;
  6. }
  7. html,body
  8. {
  9. 	font:12px/150% Arial,Verdana;
  10. }
  11.  
  12. .wrap{
  13. 	width:1000px;
  14. 	margin:0 auto;
  15. }
  16. .left{
  17. 	float:left;
  18. }
  19.  
  20. .content{
  21. 	background:url(../image/login.jpg);
  22. 	background-size: cover;
  23. 	width:1280px;
  24. 	height:559px;
  25. }
  26.  
  27. .login-frame{
  28. 	margin:50px 5% 50px 5%;
  29. 	float:right;
  30. 	padding:60px;
  31. 	background:white;
  32. 	background-color:rgba(255,255,255,0.9);
  33. 	border-radius:25px;
  34. 	order-right:1px #bdbdbd solid;
  35. 	width:280px;
  36. 	height:230px;
  37. }
  38.  
  39.  
  40. .login-frame h2{
  41. 	font-size:25px;
  42. 	height:40px;
  43. 	margin-buttom:25px;
  44. }
  45. .login-frame h2 a{
  46. 	font-size:15px;
  47. 	color:#59c2c5;
  48. 	padding-left:20px;
  49. 	background:url(../image/icon5.jpg)no-repeat;
  50. }
  51.  
  52. .login-frame .item{
  53. 	height:60px;
  54. 	margin-buttom:40px;
  55. }
  56.  
  57. .login-frame .item input{
  58. 	line-height:40px;
  59. 	width:260px;
  60. 	border:none;
  61. 	border-bottom: 1px solid #59c2c5;
  62. }
  63.  
  64. .login-btn{
  65. 	display:block;
  66. 	height:50px;display:block;
  67. 	height:50px;
  68. 	color:#fff;
  69. 	background:#59c2c5;
  70. 	width:265px;
  71. 	font-size:16px;
  72. 	line-height:30px;
  73. 	text-align:center;
  74. 	border-radius:10px;
  75. 	border:none;
  76. 	color:#fff;
  77. 	background:#59c2c5;
  78. 	width:265px;
  79. 	font-size:16px;
  80. 	line-height:30px;
  81. 	text-align:center;
  82. 	border-radius:10px;
  83. 	border:none;
  84. }
  85. .login-frame .item1{
  86. 	dislpay:flex;
  87. 	justify-content: space-between;
  88. 	margin-top:1 rem;
  89. }
  90. .login-frame .item1 a{
  91. 	line-height:40px;
  92. 	font-size:1.1rem;
  93. 	margin-top:5 rem;
  94. 	padding:1rem 3rem;
  95. }

③注册用户界面（register.jsp）

  1. <%@ page language="java" contentType="text/html; charset=UTF-8"
  2.     pageEncoding="UTF-8"%>
  3. <!DOCTYPE html>
  4. <html>
  5. <head>
  6. <link href="css/index.css" type="text/css" rel="stylesheet">
  7. <meta charset="UTF-8">
  8. <script type = "text/javascript" src = "js/jquery-3.6.0.js"></script>
  9. 	
  10. 	<script type = "text/javascript">
  11. 	function check()
  12. 	{
  13. 		var UID = $("#UID").val();
  14. 		var upwd = $("#upwd").val();
  15. 		var upwd1 = $("#upwd1").val();
  16. 		if(upwd != upwd1){
  17. 			alert("两次输入的密码不一致，请重新输入！");
  18. 			return false;
  19. 		}
  20. 		
  21. 		return true;
  22. 	}
  23. 	 $(document).ready(function(){
  24. 	 });
  25. 	</script>
  26. <title>注册账号</title>
  27. </head>
  28. <body>
  29. 	<form action = "AddLoginIDServlet" method = "post" onsubmit = "return check()">
  30. 	<div class = "content">
  31. 		<div class = "box">
  32. 		<div class = "item1">
  33. 		<h2>用户注册</h2>
  34. 		</div>
  35. 		<div class = "item">
  36. 		<input type = "text" name = "UID" id = "UID" placeholder="账号"/><br/>
  37. 		</div>
  38. 		<div class = "item">
  39. 		<input type = "password" name = "upwd" id = "upwd" placeholder="密码"/><br/>
  40. 		</div>
  41. 		<div class = "item">
  42. 		<input type = "password" name = "upwd1" id = "upwd1" placeholder="确认密码"/><br/>
  43. 		</div>
  44. 		<input type = "submit" class = "btn" value = "注册"/><br/>
  45. 		<a href = "login.jsp">返回</a>
  46. 		<%
  47. 		String error4 = (String) request.getAttribute("error4");
  48. 		if (error4!= null) {
  49. 		if (error4.equals("addError")) {
  50. 			out.println("注册失败！账户名已经存在！");
  51. 		} 
  52. 	}
  53. 	%>
  54. 	</div>
  55. 	</div>
  56. 	</form>
  57. 	
  58. </body>
  59. </html>

④注册用户界面css（index.css）

  1. *{margin:0;padding:0;}
  2. html,body
  3. {
  4. 	font:12px/150% Arial,Verdana;
  5. }
  6. .content{
  7. 	background:url(../image/login.jpg);
  8. 	background-size: cover;
  9. 	width:1280px;
  10. 	height:559px;
  11. }
  12. .box{
  13. 	margin:60px 18% 60px 18%;
  14. 	float:right;
  15. 	padding:30px;
  16. 	background:white;
  17. 	background-color:rgba(255,255,255,0.9);
  18. 	border-radius:15px;
  19. 	
  20. }
  21. .item{
  22. 	height:60px;
  23. 	margin-buttom:40px;
  24. }
  25. .item input{
  26. 	line-height:40px;
  27. 	width:260px;
  28. 	border:none;
  29. 	border-bottom: 1px solid #59c2c5;
  30. 	border-radius:3px;
  31. }
  32. .item1{
  33. 	font-size:15px;
  34. 	height:40px;
  35. }
  36. .btn{
  37. 	display:block;
  38. 	height:50px;
  39. 	color:#fff;
  40. 	background:#59c2c5;
  41. 	width:265px;
  42. 	font-size:16px;
  43. 	line-height:30px;
  44. 	text-align:center;
  45. 	border-radius:10px;
  46. 	border:none;
  47. }

⑤修改密码界面（UpdateLoginID.jsp）

  1. <%@ page language="java" contentType="text/html; charset=UTF-8"
  2.     pageEncoding="UTF-8"%>
  3. <!DOCTYPE html>
  4. <html>
  5. <head>
  6. <link href="css/index.css" type="text/css" rel="stylesheet">
  7. <meta charset="UTF-8"><script type = "text/javascript" src = "js/jquery-3.6.0.js"></script>
  8. 	
  9. 	<script type = "text/javascript">
  10. 	function check()
  11. 	{
  12. 		var upwd = $("#upwd").val();
  13. 		var upwd1 = $("#upwd1").val();
  14. 		var upwd2 = $("#upwd2").val();
  15. 		if(upwd1 != upwd2){
  16. 			alert("两次输入的密码不一致，请重新输入！");
  17. 			return false;
  18. 		}
  19. 		
  20. 		return true;
  21. 	}
  22. 	 $(document).ready(function(){
  23. 	 });
  24. 	</script>
  25.  
  26. <title>更改账号密码</title>
  27. </head>
  28. <body>
  29. 	<form action = "UpdateLoginPwdServlet" method = "post" onsubmit = "return check()">
  30. 	<div class = "content">
  31. 	<div class = "box">
  32. 	<div class= "item1"><h2>修改密码</h2></div>
  33. 	<div class = item>
  34. 	<input type = "text" name = "UID" id = "UID" placeholder="账号"/><br/>
  35. 	</div>
  36. 	<div class = item>
  37. 	<input type = "password" name = "upwd" id = "upwd" placeholder="旧密码"/><br/>
  38. 	</div>
  39. 	<div class = item>
  40. 	<input type = "password" name = "upwd1" id = "upwd1" placeholder="新密码"/><br/>
  41. 	</div>
  42. 	<div class = item>
  43. 	<input type = "password" name = "upwd2" id = "upwd2" placeholder="确认密码"/><br/>
  44. 	</div>
  45. 	<input type = "submit" class = "btn" value = "提交"/><br/>
  46. 	<a href = "login.jsp">返回</a>
  47. 	<%
  48. 	String error0 = (String) request.getAttribute("error0");
  49. 	if (error0!= null) {
  50. 		if (error0.equals("loginError")) {
  51. 			out.println("用户名或密码错误，请重新输入！");
  52. 		} else if (error0.equals("nologinError")) {
  53. 			response.sendRedirect("login.jsp");
  54. 		}
  55. 	}
  56. 	%>
  57. 	</div>
  58. 	</div>
  59. 	</form>
  60. </body>
  61. </html>

⑥注销用户界面（DeleteLoginID.jsp）

  1. <%@ page language="java" contentType="text/html; charset=UTF-8"
  2.     pageEncoding="UTF-8"%>
  3. <!DOCTYPE html>
  4. <html>
  5. <head>
  6. <link href="css/index.css" type="text/css" rel="stylesheet">
  7. <meta charset="UTF-8">
  8. <title>注销账号</title>
  9. </head>
  10. <body>
  11. 	<form action = "DeleteLoginIDServlet" method = "post">
  12. 	<div class = "content">
  13. 	<div class = "box">
  14. 	<div class = "item1">
  15. 	<h2>注销账号</h2>
  16. 	</div>
  17. 	<div class = "item">
  18. 	<input type = "text" name = "UID" id = "UID" placeholder="账号"/><br/>
  19. 	</div>
  20. 	<div class = "item">
  21. 	<input type = "password" name = "upwd" id = "upwd" placeholder="密码"/><br/>
  22. 	</div>
  23. 	<input type = "submit" class = "btn" value = "注销"/><br/>
  24. 	<a href = "login.jsp">返回</a>
  25. 	<%
  26. 	String error2 = (String) request.getAttribute("error2");
  27. 	if (error2!= null) {
  28. 	if (error2.equals("loginError")) {
  29. 			out.println("用户名或密码错误！注销失败！");
  30. 		}
  31. 	}
  32. 		%>
  33. 	</div>
  34. 	</div>
  35.  
  36. 	</form>
  37. </body>
  38. </html>

⑦登录成功主界面（index.jsp）

点击学号进入单个学生信息展示界面，可修改学生信息

点击删除删除学生信息

  1. <%@page import="student.entity.Page"%>
  2. <%@page import="java.util.List"%>
  3. <%@page import="student.entity.Student"%>
  4. <%@ page language="java" contentType="text/html; charset=UTF-8"
  5.     pageEncoding="UTF-8"%>
  6. <!DOCTYPE html>
  7. <html>
  8. <head>
  9. 	<script type = "text/javascript" src = "js/jquery-3.6.0.js"></script>
  10. 	
  11. 	<script type = "text/javascript">
  12. 	 $(document).ready(function(){
  13. 	 	$("tr:odd").css("background-color","lightgrey");
  14. 	 
  15. 	 });
  16. 	</script>
  17. 	
  18. <link href="css/show.css" type="text/css" rel="stylesheet">
  19. <meta charset="UTF-8">
  20. <title>学生信息列表</title>
  21. </head>
  22. <body>
  23.  
  24. 	<div class = "content">
  25. 	<div class = "box">
  26. 	<table  border="2" cellspacing="0">
  27. 		<tr>
  28. 			<th><h2>学号</h2></th>
  29. 			<th><h2>姓名</h2></th>
  30. 			<th><h2>年龄</h2></th>
  31. 			<th><h2>专业</h2></th>
  32. 			<th><h2>操作</h2></th>
  33. 		</tr>
  34. 		<%
  35. 		Page page1 = (Page)request.getAttribute("page1");
  36. 		
  37. 		for(Student student:page1.getStudents()){
  38. 			%>
  39. 			<tr>
  40. 				<td><a href = "QueryStudentBySnoServlet?sno=<%=student.getSno()%>"><%=student.getSno() %></a></td>
  41. 				<td><%=student.getName() %></td>
  42. 				<td><%=student.getAge() %></td>
  43. 				<td><%=student.getDept() %></td>
  44. 				<td><a href = "DeleteStudentServlet?sno=<%=student.getSno() %>">删除</a></td>
  45. 			</tr>
  46. 			<%			
  47. 		}
  48. 		%>
  49. 		</table>
  50. 		<div class = item>
  51. 		<a href = "add.jsp">增加学生</a>
  52. 		</div>
  53. 	<% 
  54. 		if(page1.getCurrentPage()==page1.getTotalPage()-1){
  55. 		%>
  56. 		<div class = item>
  57. 		<a href = "QueryStudentByPageServlet?currentPage=0">首页</a>
  58. 		<a href = "QueryStudentByPageServlet?currentPage=<%=page1.getCurrentPage()-1%>">上一页</a>
  59. 		</div>
  60. 		<% 
  61. 		}
  62. 		else if(page1.getCurrentPage()==0){
  63. 			%>
  64. 			<div class = item>
  65. 			<a href = "QueryStudentByPageServlet?currentPage=<%=page1.getCurrentPage()+1%>">下一页</a>
  66. 			<a href = "QueryStudentByPageServlet?currentPage=<%=page1.getTotalPage()-1%>">尾页</a>
  67. 			</div>
  68. 			<%
  69. 		}
  70. 		else{
  71. 			%>
  72. 			<div class = item>
  73. 			<a href = "QueryStudentByPageServlet?currentPage=0">首页</a>
  74. 			<a href = "QueryStudentByPageServlet?currentPage=<%=page1.getCurrentPage()-1%>">上一页</a>
  75. 			<a href = "QueryStudentByPageServlet?currentPage=<%=page1.getCurrentPage()+1%>">下一页</a>
  76. 			<a href = "QueryStudentByPageServlet?currentPage=<%=page1.getTotalPage()-1%>">尾页</a>
  77. 			</div>
  78. 			<%
  79. 		}
  80. 		%>
  81. 		<input type = "button" value = "上传作业" class = "btn"  onclick = "location = 'UpAndDown.jsp'"/><br/>
  82. 			<%
  83. 	String error = (String)request.getAttribute("error");
  84. 	if(error!=null){
  85. 	if(error.equals("addError")){
  86. 		out.println("增加失败！");
  87. 	}
  88. 	else if(error.equals("noaddError")){
  89. 		out.println("增加成功！");
  90. 	}
  91. 	}
  92. 	
  93. 	String error1 = (String)request.getAttribute("error1");
  94. 	if(error1!=null){
  95. 	if(error1.equals("deleteError")){
  96. 		out.println("删除失败！");
  97. 	}
  98. 	else if(error1.equals("nodeleteError")){
  99. 		out.println("删除成功！");
  100. 	}
  101. 	}
  102. 	String error2 = (String)request.getAttribute("error2");
  103. 	if(error2!=null){
  104. 	if(error2.equals("updateError")){
  105. 		out.println("修改失败！");
  106. 	}
  107. 	else if(error2.equals("noupdateError")){
  108. 		out.println("修改成功！");
  109. 	}
  110. 	}
  111. 	
  112. 	
  113. 	String error3 = (String)request.getAttribute("error3");
  114. 	if(error3!=null){
  115. 	if(error3.equals("uploadError")){
  116. 		out.println("上传失败！");
  117. 	}
  118. 	else if(error3.equals("nouploadError")){
  119. 		out.println("上传成功！");
  120. 	}
  121. 	}
  122. 	%>
  123. 		</div>
  124. 		</div>
  125. </body>
  126. </html>

⑧登陆成功界面css（show.css）

  1. *{margin:0;padding:0;}
  2. html,body
  3. {
  4. 	font:12px/150% Arial,Verdana;
  5. }
  6. .content{
  7. 	background:url(../image/index.JPG);
  8. 	background-size: cover;
  9. 	width:1280px;
  10. 	height:559px;
  11. }
  12. .box{
  13. 	margin:60px 18% 60px 18%;
  14. 	float:right;
  15. 	padding:30px;
  16. 	background:white;
  17. 	background-color:rgba(255,255,255,0.9);
  18. 	border-radius:15px;
  19. 	
  20. }
  21. .item{
  22. 	height:40px;
  23. 	
  24. 	border-radius:15px;
  25. }
  26. .item a{
  27. 	background-color: lightgrey;
  28. 	text-decoration: none;
  29. 	font-size:15px;
  30. 	color:black;
  31. 	border-radius:3px;
  32. }
  33. .item1{
  34. 	font-size:15px;
  35. 	height:40px;
  36. }
  37. table{
  38. 	width:100%;
  39. 	border-collapse:collapse;
  40. }
  41. table body{
  42. 	diaplay:block;
  43. 	height:300px;
  44. 	overflow-y: scroll;
  45. }
  46. table td{
  47. 	border:1px solid #A6A6A6;
  48. 	height:60px;
  49. 	width:300px;
  50. 	text-align: center;
  51. 	font-size: 15px;
  52. }
  53. table th{
  54. 	height:60px;
  55. 	border:1px solid #A6A6A6;
  56. }

⑨点击学号，修改学生信息界面（StudentInfo.jsp）

  1. <%@page import="student.entity.Student"%>
  2. <%@ page language="java" contentType="text/html; charset=UTF-8"
  3.     pageEncoding="UTF-8"%>
  4. <!DOCTYPE html>
  5. <html>
  6. <head>
  7. <meta charset="UTF-8">
  8. <link href="css/index.css" type="text/css" rel="stylesheet">
  9. <title>修改学生信息</title>
  10. </head>
  11. <body>
  12. 	<%
  13. 		Student student = (Student)request.getAttribute("student");
  14. 	%>		
  15. 	<form action = "UpdateStudentServlet" method = "post">
  16. 	<div class = "content">
  17. 	<div class = "box">
  18. 	<div class = "item1">
  19. 	<h2>修改学生信息</h2>
  20. 	</div>
  21. 		<div class = "item">
  22. 		学号:<input type = "text" name = "sno" value ="<%=student.getSno()%>" readonly = "readonly"/><br/>
  23. 		</div>
  24. 		<div class = "item">
  25. 		姓名:<input type = "text" name = "name" value ="<%=student.getName()%>"/><br/>
  26. 		</div>
  27. 		<div class = "item">
  28. 		年龄:<input type = "text" name = "age" value ="<%=student.getAge()%>"/><br/>
  29. 		</div>
  30. 		<div class = "item">
  31. 		专业:<input type = "text" name = "dept" value ="<%=student.getDept()%>"/><br/>
  32. 		</div>
  33. 		<input type = "submit" class = "btn" value = "修改"/>
  34. 		<a href = "QueryStudentByPageServlet">返回</a>
  35. 		</div>
  36. 		</div>
  37. 	</form>
  38. </body>
  39. </html>

⑩增加学生信息（add.jsp）

  1. <%@ page language="java" contentType="text/html; charset=UTF-8"
  2.     pageEncoding="UTF-8"%>
  3. <!DOCTYPE html>
  4. <html>
  5. <head>
  6. <meta charset="UTF-8">
  7. <link href="css/index.css" type="text/css" rel="stylesheet">
  8. <script type = "text/javascript" src = "js/jquery-3.6.0.js"></script>
  9. 	
  10. 	<script type = "text/javascript">
  11. 	function check()
  12. 	{
  13. 		var sname = $("#sname").val();
  14. 		var sno = $("#sno").val();
  15. 		var sage = $("#sage").val();
  16. 		var sdept = $("#sdept").val();
  17. 		if(!(sno>1&&sno<2000)){
  18. 			alert("学号有误！必须是1-2000");
  19. 			return false;
  20. 		}
  21. 		if(!(sname.length>1&&sname.length<5)){
  22. 			alert("姓名有误！必须是2-4位");
  23. 			return false;
  24. 		}
  25. 		if(!(sage>1&&sage<100)){
  26. 			alert("年龄有误！必须是1-100");
  27. 			return false;
  28. 		}
  29. 		return true;
  30. 	}
  31. 	 $(document).ready(function(){
  32. 	 });
  33. 	</script>
  34. 	
  35. <title>增加学生信息</title>
  36. </head>
  37. <body>
  38. 	<form action = "AddStudentServlet" method = "post"  onsubmit = "return check()">
  39. 	<div class = "content">
  40. 	<div class = "box">
  41. 	<div class = "item2">
  42. 	<h2>增加学生信息</h2>
  43. 	</div>
  44. 	<div class = "item">
  45. 	<input type = "text" name = "name" id = "sname" placeholder="姓名"/><br/>
  46. 	</div>
  47. 	<div class = "item">
  48. 	<input type = "text" name = "sno" id = "sno" placeholder="学号"/><br/>
  49. 	</div>
  50. 	<div class = "item">
  51. 	<input type = "text" name = "age" id = "sage" placeholder="年龄"/><br/>
  52. 	</div>
  53. 	<div class = "item">
  54. 	<input type = "text" name = "dept" id = "sdept" placeholder="专业"/><br/>
  55. 	</div>
  56. 	<input type = "submit" class = "btn" value = "增加"/><br/>
  57. 	<a href = "QueryStudentByPageServlet">返回</a>
  58. 	</div>
  59. 	</div>
  60. 	</form>
  61. </body>
  62. </html>

⑪上传作业操作（UpAndDown.jsp）

  1. <%@ page language="java" contentType="text/html; charset=UTF-8"
  2.     pageEncoding="UTF-8"%>
  3. <!DOCTYPE html>
  4. <html>
  5. <head>
  6. <meta charset="UTF-8">
  7. <link href="css/index.css" type="text/css" rel="stylesheet">
  8. <title>上传作业</title>
  9. </head>
  10. <body>
  11. 	<form action ="UploadServlet" method = "post" enctype = "multipart/form-data">
  12. 	<div class = "content">
  13. 	<div class = "box">
  14. 	<div class = "item2">
  15. 	<h2>上传作业</h2>
  16. 	</div>
  17. 	<div class = "item">
  18. 	<input type = "text" name="sno" placeholder="学号"/><br/>
  19. 	</div>
  20. 	<div class = "item">
  21. 	<input type = "text" name = "name" placeholder="姓名"/><br/>
  22. 	</div>
  23. 	<input type = "file" name = "spiature"/>
  24. 	<br/>
  25. 	<br/>
  26. 	<input type = "submit" class = "btn" value ="上传"/>
  27. 	<a href = "QueryStudentByPageServlet">返回</a>
  28. 	</div>
  29. 	</div>
  30. 	</form>
  31. </body>
  32. </html>

2.三层架构

①表示层Servlet

检查登录的用户名和密码是否匹配（CheckLoginServlet.java）

  1. package student.servlet;
  2.  
  3. import java.io.IOException;
  4. import javax.servlet.ServletException;
  5. import javax.servlet.http.HttpServlet;
  6. import javax.servlet.http.HttpServletRequest;
  7. import javax.servlet.http.HttpServletResponse;
  8.  
  9. import student.service.IStudentService;
  10. import student.service.impl.StudentServiceImpl;
  11.  
  12.  
  13. public class CheckLoginServlet extends HttpServlet {
  14. 	
  15. 	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  16. 		request.setCharacterEncoding("utf-8");
  17. 		String ID = request.getParameter("UID");
  18. 		String pwd = request.getParameter("upwd");
  19. 		IStudentService service = new StudentServiceImpl();
  20. 		boolean result = service.checkLoginID(ID,pwd);
  21. 		response.setContentType("text/html;charest=UTF-8");
  22. 		response.setCharacterEncoding("utf-8");
  23. 		if(!result) {
  24. 			request.setAttribute("error", "loginError");
  25. 		}else {
  26. 			request.setAttribute("error", "nologinError");
  27. 		}
  28. 		request.getRequestDispatcher("login.jsp").forward(request, response);
  29. 	}
  30.  
  31. 	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  32. 		// TODO Auto-generated method stub
  33. 		doGet(request, response);
  34. 	}
  35.  
  36. }

注册账户表示层（AddLoginIDServlet.java）

  1. package student.servlet;
  2.  
  3. import java.io.IOException;
  4. import javax.servlet.ServletException;
  5. import javax.servlet.http.HttpServlet;
  6. import javax.servlet.http.HttpServletRequest;
  7. import javax.servlet.http.HttpServletResponse;
  8.  
  9. import student.service.IStudentService;
  10. import student.service.impl.StudentServiceImpl;
  11.  
  12. /**
  13.  * Servlet implementation class AddLoginIDServlet
  14.  */
  15. public class AddLoginIDServlet extends HttpServlet {
  16. 	private static final long serialVersionUID = 1L;
  17. 	
  18. 	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  19. 		request.setCharacterEncoding("utf-8");
  20. 		String ID = request.getParameter("UID");
  21. 		String pwd = request.getParameter("upwd");
  22. 		IStudentService studentService = new StudentServiceImpl();
  23. 		boolean result = studentService.addLoginID(ID,pwd);
  24. 		
  25. 		response.setContentType("text/html;charest=UTF-8");
  26. 		response.setCharacterEncoding("utf-8");
  27. 		if(!result) {
  28. 			request.setAttribute("error4", "addError");
  29. 			request.getRequestDispatcher("register.jsp").forward(request, response);
  30. 		}else {
  31. 			request.setAttribute("error4", "noaddError");
  32. 			request.getRequestDispatcher("login.jsp").forward(request, response);
  33. 		}
  34. 		
  35. 	}
  36.  
  37. 	/**
  38. 	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
  39. 	 */
  40. 	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  41. 		// TODO Auto-generated method stub
  42. 		doGet(request, response);
  43. 	}
  44.  
  45. }

修改密码表示层（UpdateLoginPwdServlet.java）

  1. package student.servlet;
  2.  
  3. import java.io.IOException;
  4. import javax.servlet.ServletException;
  5. import javax.servlet.http.HttpServlet;
  6. import javax.servlet.http.HttpServletRequest;
  7. import javax.servlet.http.HttpServletResponse;
  8.  
  9. import student.service.IStudentService;
  10. import student.service.impl.StudentServiceImpl;
  11.  
  12. /**
  13.  * Servlet implementation class UpdateLoginPwdServlet
  14.  */
  15. public class UpdateLoginPwdServlet extends HttpServlet {
  16. 	private static final long serialVersionUID = 1L;
  17.        
  18.    
  19. 	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  20. 		request.setCharacterEncoding("utf-8");
  21. 		String ID = request.getParameter("UID");
  22. 		String pwd = request.getParameter("upwd");
  23. 		String pwd1 = request.getParameter("upwd1");
  24. 		IStudentService service = new StudentServiceImpl();
  25. 		boolean result = service.checkLoginID(ID,pwd);
  26. 		response.setContentType("text/html;charest=UTF-8");
  27. 		response.setCharacterEncoding("utf-8");
  28. 		if(!result) {
  29. 			request.setAttribute("error0", "loginError");
  30. 			request.getRequestDispatcher("UpdateLoginPwd.jsp").forward(request, response);
  31. 		}else {
  32. 			request.setAttribute("error0", "nologinError");
  33. 			boolean result1 = service.updateLoginPwd(ID,pwd1);
  34. 			if(!result1) {
  35. 				request.getRequestDispatcher("UpdateLoginPwd.jsp").forward(request, response);
  36. 			}else {
  37. 				request.setAttribute("error1", "noupdateError");
  38. 				request.getRequestDispatcher("login.jsp").forward(request, response);
  39. 			}
  40. 		}
  41. 	}
  42.  
  43. 	/**
  44. 	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
  45. 	 */
  46. 	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  47. 		// TODO Auto-generated method stub
  48. 		doGet(request, response);
  49. 	}
  50.  
  51. }

注销用户表示层（DeleteLoginIDServlet.java）

  1. package student.servlet;
  2.  
  3. import java.io.IOException;
  4. import javax.servlet.ServletException;
  5. import javax.servlet.http.HttpServlet;
  6. import javax.servlet.http.HttpServletRequest;
  7. import javax.servlet.http.HttpServletResponse;
  8.  
  9. import student.service.IStudentService;
  10. import student.service.impl.StudentServiceImpl;
  11.  
  12. /**
  13.  * Servlet implementation class DeleteLoginIDServlet
  14.  */
  15. public class DeleteLoginIDServlet extends HttpServlet {
  16. 	private static final long serialVersionUID = 1L;
  17.     
  18. 	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  19. 		request.setCharacterEncoding("utf-8");
  20. 		String ID = request.getParameter("UID");
  21. 		String pwd = request.getParameter("upwd");
  22. 		IStudentService service = new StudentServiceImpl();
  23. 		boolean result = service.checkLoginID(ID,pwd);
  24. 		boolean result1 = service.deleteLoginID(ID);
  25. 		response.setContentType("text/html;charest=UTF-8");
  26. 		response.setCharacterEncoding("utf-8");
  27. 		if(!result) {
  28. 			request.setAttribute("error2", "loginError");
  29. 			request.getRequestDispatcher("DeleteLoginID.jsp").forward(request, response);
  30. 		}else {
  31. 			request.setAttribute("error2", "nologinError");
  32. 			if(!result1) {
  33. 				request.setAttribute("error3", "deleteError");
  34. 				request.getRequestDispatcher("DeleteLoginID.jsp").forward(request, response);
  35. 			}else {
  36. 				request.setAttribute("error3", "nodeleteError");
  37. 				request.getRequestDispatcher("login.jsp").forward(request, response);
  38. 		}
  39. 		}
  40. 	}
  41.  
  42. 	/**
  43. 	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
  44. 	 */
  45. 	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  46. 		// TODO Auto-generated method stub
  47. 		doGet(request, response);
  48. 	}
  49.  
  50. }

分页显示（QueryStudentByPageServlet.java）

  1. package student.servlet;
  2.  
  3. import java.io.IOException;
  4. import java.util.List;
  5.  
  6. import javax.servlet.ServletException;
  7. import javax.servlet.http.HttpServlet;
  8. import javax.servlet.http.HttpServletRequest;
  9. import javax.servlet.http.HttpServletResponse;
  10.  
  11. import student.entity.Page;
  12. import student.entity.Student;
  13. import student.service.IStudentService;
  14. import student.service.impl.StudentServiceImpl;
  15.  
  16. public class QueryStudentByPageServlet extends HttpServlet {
  17. 	private static final long serialVersionUID = 1L;
  18.     public QueryStudentByPageServlet() {
  19.         super();
  20.     }
  21. 	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  22. 		IStudentService studentService = new StudentServiceImpl();
  23. 		int count = studentService.getTotalCount();
  24. 		
  25. 		Page page = new Page();
  26. 		
  27. 		
  28. 		String cPage = request.getParameter("currentPage");
  29. 		
  30. 		if(cPage == null) {
  31. 			cPage = "0";
  32. 		}
  33. 		int currentPage = Integer.parseInt(cPage);
  34. 		page.setCurrentPage(currentPage);
  35.  
  36. 		int totalCount = studentService.getTotalCount();
  37. 		page.setTotalCount(totalCount);
  38. 		int pageSize = 4;
  39. 		
  40. 		page.setPageSize(pageSize);
  41. 		
  42. 		List<Student> students = studentService.queryStudentsByPage(currentPage, pageSize);
  43. 		
  44. 		page.setStudents(students);
  45. 		request.setAttribute("page1", page);
  46. 		request.getRequestDispatcher("index.jsp").forward(request, response);
  47. 	}
  48.  
  49. 	/**
  50. 	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
  51. 	 */
  52. 	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  53. 		// TODO Auto-generated method stub
  54. 		doGet(request, response);
  55. 	}
  56.  
  57. }

按学号查询学生信息（QueryStudentBySnoServlet.java）

  1. package student.servlet;
  2.  
  3. import java.io.IOException;
  4. import javax.servlet.ServletException;
  5. import javax.servlet.http.HttpServlet;
  6. import javax.servlet.http.HttpServletRequest;
  7. import javax.servlet.http.HttpServletResponse;
  8.  
  9. import student.entity.Student;
  10. import student.service.IStudentService;
  11. import student.service.impl.StudentServiceImpl;
  12.  
  13. public class QueryStudentBySnoServlet extends HttpServlet {
  14. 	
  15. 	/**
  16. 	 * 
  17. 	 */
  18. 	private static final long serialVersionUID = 1L;
  19.  
  20. 	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  21. 	request.setCharacterEncoding("UTF-8");
  22. 	int sno = Integer.parseInt(request.getParameter("sno"));
  23. 	IStudentService service = new StudentServiceImpl();
  24. 	Student student = service.queryStudentBySno(sno);
  25. 	request.setAttribute("student", student);//将查询到的request信息放在request域中
  26. 	request.getRequestDispatcher("StudentInfo.jsp").forward(request,response);
  27. 	}
  28.  
  29. 	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  30. 		doGet(request, response);
  31. 	}
  32.  
  33. }

增加学生信息（AddStudentServlet.java）

  1. package student.servlet;
  2.  
  3. import java.io.IOException;
  4.  
  5. import javax.servlet.ServletException;
  6. import javax.servlet.http.HttpServlet;
  7. import javax.servlet.http.HttpServletRequest;
  8. import javax.servlet.http.HttpServletResponse;
  9.  
  10. import student.entity.Student;
  11. import student.service.IStudentService;
  12. import student.service.impl.StudentServiceImpl;
  13.  
  14. public class AddStudentServlet extends HttpServlet {
  15.  
  16. 	/**
  17. 	 * 
  18. 	 */
  19. 	private static final long serialVersionUID = 1L;
  20.  
  21. 	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  22. 		request.setCharacterEncoding("utf-8");
  23. 		String name = request.getParameter("name");
  24. 		int sno = Integer.parseInt(request.getParameter("sno"));
  25. 		int age = Integer.parseInt(request.getParameter("age"));
  26. 		String dept = request.getParameter("dept");
  27. 		Student student = new Student(name, sno, age, dept);
  28. 		
  29. 		IStudentService studentService = new StudentServiceImpl();
  30. 		boolean result = studentService.addStudent(student);
  31. 		
  32. 		response.setContentType("text/html;charest=UTF-8");
  33. 		response.setCharacterEncoding("utf-8");
  34. 		if(!result) {
  35. 			request.setAttribute("error", "addError");
  36. 		}else {
  37. 			request.setAttribute("error", "noaddError");
  38. 		}
  39. 		request.getRequestDispatcher("QueryStudentByPageServlet").forward(request, response);
  40. 	}
  41.  
  42. 	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  43. 		doGet(request, response);
  44. 	}
  45.  
  46. }

删除学生信息（DeleteStudentServlet.java）

  1. package student.servlet;
  2.  
  3. import java.io.IOException;
  4. import javax.servlet.ServletException;
  5. import javax.servlet.http.HttpServlet;
  6. import javax.servlet.http.HttpServletRequest;
  7. import javax.servlet.http.HttpServletResponse;
  8.  
  9. import student.service.IStudentService;
  10. import student.service.impl.StudentServiceImpl;
  11.  
  12. /**
  13.  * Servlet implementation class DeleteStudentServlet
  14.  */
  15. public class DeleteStudentServlet extends HttpServlet {
  16. 	
  17. 	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  18. 		request.setCharacterEncoding("utf-8");
  19. 		int sno = Integer.parseInt(request.getParameter("sno"));
  20. 		IStudentService service = new StudentServiceImpl();
  21. 		boolean result = service.deleteStudentBySno(sno);
  22. 		response.setContentType("text/html;charest=UTF-8");
  23. 		response.setCharacterEncoding("utf-8");
  24. 		if(!result) {
  25. 			request.setAttribute("error1", "deleteError");
  26. 		}else {
  27. 			request.setAttribute("error1", "nodeleteError");
  28. 		}
  29. 		request.getRequestDispatcher("QueryStudentByPageServlet").forward(request, response);
  30. 	}
  31.  
  32. 	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  33. 		// TODO Auto-generated method stub
  34. 		doGet(request, response);
  35. 	}
  36.  
  37. }

修改学生信息表示层（UpdateStudentServlet.java）

  1. package student.servlet;
  2.  
  3. import java.io.IOException;
  4. import javax.servlet.ServletException;
  5. import javax.servlet.http.HttpServlet;
  6. import javax.servlet.http.HttpServletRequest;
  7. import javax.servlet.http.HttpServletResponse;
  8.  
  9. import student.entity.Student;
  10. import student.service.IStudentService;
  11. import student.service.impl.StudentServiceImpl;
  12.  
  13. public class UpdateStudentServlet extends HttpServlet {
  14.  
  15. 	/**
  16. 	 * 
  17. 	 */
  18. 	private static final long serialVersionUID = 1L;
  19.  
  20.  
  21. 	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  22. 		request.setCharacterEncoding("UTF-8");
  23. 		String name = request.getParameter("name");
  24. 		int sno = Integer.parseInt(request.getParameter("sno"));
  25. 		int age = Integer.parseInt(request.getParameter("age"));
  26. 		String dept = request.getParameter("dept");
  27. 		Student student = new Student(name, age, dept);
  28. 		
  29. 		System.out.println(sno);
  30. 		
  31. 		IStudentService service = new StudentServiceImpl();
  32. 		boolean result = service.updateStudentBySno(sno, student);
  33. 		
  34. 		response.setContentType("text/html;charest=UTF-8");
  35. 		response.setCharacterEncoding("utf-8");
  36. 		if(!result) {
  37. 			request.setAttribute("error2", "updateError");
  38. 		}else {
  39. 			request.setAttribute("error2", "noupdateError");
  40. 		}
  41.  
  42. 		request.getRequestDispatcher("QueryStudentByPageServlet").forward(request, response);
  43. 	}
  44. 		
  45.  
  46. 	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  47. 		doGet(request, response);
  48. 	}
  49.  
  50. }

上传作业（UploadServlet.java）

  1. package student.servlet;
  2.  
  3. import java.io.File;
  4. import java.io.IOException;
  5. import java.util.Iterator;
  6. import java.util.List;
  7.  
  8. import javax.servlet.ServletException;
  9. import javax.servlet.http.HttpServlet;
  10. import javax.servlet.http.HttpServletRequest;
  11. import javax.servlet.http.HttpServletResponse;
  12.  
  13. import org.apache.commons.fileupload.FileItem;
  14. import org.apache.commons.fileupload.FileUploadBase;
  15. import org.apache.commons.fileupload.FileUploadException;
  16. import org.apache.commons.fileupload.disk.DiskFileItemFactory;
  17. import org.apache.commons.fileupload.servlet.ServletFileUpload;
  18.  
  19. import student.service.IStudentService;
  20. import student.service.impl.StudentServiceImpl;
  21.  
  22.  
  23. public class UploadServlet extends HttpServlet {
  24. 	private static final long serialVersionUID = 1L;
  25.     
  26. 	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  27. 		request.setCharacterEncoding("UTF-8");
  28. 		response.setCharacterEncoding("UTF-8");
  29. 		response.setContentType("text/html; charset=UTF-8");
  30. 		String name = null;
  31. 		int sno = -1;
  32. 		
  33. 		boolean isMutipart = ServletFileUpload.isMultipartContent(request);
  34. 		if(isMutipart) {
  35. 			DiskFileItemFactory factory = new DiskFileItemFactory();
  36. 			ServletFileUpload upload = new ServletFileUpload(factory);
  37. 			factory.setRepository(new File("D:\\uploadtemp"));
  38. 			List<FileItem> items = null;
  39. 				try {
  40. 					items = upload.parseRequest(request);
  41. 				} catch (FileUploadException e) {
  42. 					// TODO Auto-generated catch block
  43. 					e.printStackTrace();
  44. 				}
  45. 			Iterator<FileItem> iter = items.iterator();
  46. 			while(iter.hasNext()) {
  47. 				FileItem item= iter.next();
  48. 				String fileName = item.getName();
  49. 				String itemName = item.getFieldName();
  50. 				if(item.isFormField()) {
  51. 					if(itemName.equals("name")){
  52. 						name = item.getString("utf-8");
  53. 					}else if(itemName.equals("sno")) {
  54. 						sno =Integer.parseInt(item.getString("utf-8"));
  55. 					}else {
  56. 						
  57. 					}
  58. 				}else {
  59. 					//定义上传路径：指定上传的位置
  60. 					String path = "D:\\upload";
  61. 					File file = new File(path,fileName);
  62. 						try {
  63. 							item.write(file);
  64. 							} catch (Exception e) {
  65. 							e.printStackTrace();
  66. 							}
  67. 			}
  68. 		}
  69. 		IStudentService studentService = new StudentServiceImpl();
  70. 		boolean result = studentService.upLoadWork(sno,name);
  71. 		
  72. 		System.out.println(name+sno);
  73. 		System.out.println(result);
  74. 		if(!result) {
  75. 			request.setAttribute("error3", "uploadError");
  76. 			request.getRequestDispatcher("QueryStudentByPageServlet").forward(request, response);
  77. 			
  78. 		}else{
  79. 			request.setAttribute("error3", "nouploadError");
  80. 			request.getRequestDispatcher("QueryStudentByPageServlet").forward(request, response);
  81. 			
  82. 		}
  83. 		}
  84. 	}
  85.  
  86.  
  87. 	
  88. 	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  89. 		// TODO Auto-generated method stub
  90. 		doGet(request, response);
  91. 	}
  92.  
  93. }

②业务逻辑层Service

Service接口（IStudentService.java）

  1. package student.service;
  2.  
  3. import java.util.List;
  4.  
  5. import student.entity.Student;
  6.  
  7. public interface IStudentService {
  8. 	//查询全部学生信息
  9. 	public List<Student> queryAllStudents();
  10. 	//按照学号查询学生信息
  11. 	public Student queryStudentBySno(int sno);
  12. 	//删除学生信息
  13. 	public boolean deleteStudentBySno(int sno) ;
  14. 	
  15. 	//更改学生信息
  16. 	public boolean updateStudentBySno(int sno, Student student) ;
  17. 	
  18. 	//增加学生信息
  19. 	public boolean addStudent(Student student) ;
  20. 	
  21. 	//查询总数据
  22. 	public int getTotalCount();
  23. 	//分页
  24. 	public List<Student> queryStudentsByPage(int current, int pageSize);
  25. 	//检查登陆账户和密码
  26. 	public boolean checkLoginID(String ID,String pwd);
  27. 	//注册账户
  28. 	public boolean addLoginID(String ID, String pwd);
  29. 	//更改密码
  30. 	public boolean updateLoginPwd(String ID,String pwd1);
  31. 	//注销账号
  32. 	public boolean deleteLoginID(String ID);
  33. 	//判断ID是否存在
  34. 	public boolean IDExist(String ID);
  35. 	//判断上传作业输入的学生信息是否存在
  36. 	public boolean upLoadWork(int sno, String name);
  37.  
  38. }

接口的实现类（StudentServiceImpl.java）

  1. package student.service.impl;
  2.  
  3. import java.util.List;
  4.  
  5. import student.dao.IStudentDao;
  6. import student.dao.impl.StudentDaoImpl;
  7. import student.entity.Student;
  8. import student.service.IStudentService;
  9. import student.util.DBUtil;
  10.  
  11. //业务逻辑层：逻辑性的增删改查（增：查+增），对dao层进行的组装
  12. public class StudentServiceImpl implements IStudentService{
  13. 	IStudentDao studentDao = new StudentDaoImpl();
  14. 	//查询全部学生信息
  15. 	public List<Student> queryAllStudents(){
  16. 		return studentDao.queryAllStudents();
  17. 	}
  18. 	//按照学号查询学生信息
  19. 	public Student queryStudentBySno(int sno) {
  20. 		return studentDao.queryStudentBySno(sno);
  21. 		
  22. 	}
  23. 	//删除学生信息
  24. 	public boolean deleteStudentBySno(int sno) {
  25. 		if(studentDao.isExist(sno)) {
  26. 			return studentDao.deleteStudentBySno(sno);
  27. 		}
  28. 			return false;
  29. 	}
  30. 	
  31. 	
  32. 	//更改学生信息
  33. 	public boolean updateStudentBySno(int sno, Student student) {
  34. 			return studentDao.updateStudentBySno(sno, student);
  35. 	}
  36. 	
  37. 	
  38. 	//增加学生信息
  39. 	public boolean addStudent(Student student) {
  40. 		if(!studentDao.isExist(student.getSno())) {
  41. 			studentDao.addStudent(student);
  42. 			return true;
  43. 		}else {
  44. 			System.out.println("学号重复！");
  45. 			return false;
  46. 		}
  47. 	}
  48. 	
  49. 	//查询总条数
  50. 	@Override
  51. 	public int getTotalCount() {
  52. 		return studentDao.getTotalCount();
  53. 	}
  54. 	//查询当前页的数据集合
  55. 	@Override
  56. 	public List<Student> queryStudentsByPage(int current, int pageSize) {
  57. 		return studentDao.queryStudentByPage(current, pageSize);
  58. 	}
  59. 	
  60. 	
  61. 	@Override
  62. 	public boolean checkLoginID(String ID, String pwd) {
  63. 		return studentDao.checkLoginID(ID, pwd);
  64. 	}
  65. 	@Override
  66. 	public boolean addLoginID(String ID, String pwd) {
  67. 		return studentDao.addLoginID(ID,pwd);
  68. 					
  69. 	}
  70. 	@Override
  71. 	public boolean updateLoginPwd(String ID, String pwd1) {
  72. 		return studentDao.updateLoginPwd(ID,pwd1);
  73. 	}
  74. 	@Override
  75. 	public boolean deleteLoginID(String ID) {
  76. 		return studentDao.deleteLoginID(ID);
  77. 	}
  78. 	@Override
  79. 	public boolean IDExist(String ID) {
  80. 		return studentDao.IDExist(ID);
  81. 	}
  82. 	@Override
  83. 	public boolean upLoadWork(int sno, String name) {
  84. 		return studentDao.upLoadWork(sno,name);
  85. 	}
  86. 	
  87. 	
  88. }

③数据访问层Dao

接口（IStudentDao.java）

  1. package student.dao;
  2.  
  3. import java.util.List;
  4.  
  5. import student.entity.Student;
  6.  
  7. public interface IStudentDao {
  8. 	public boolean updateLoginPwd(String ID,String pwd1);
  9.  
  10.  
  11. 	//查询全部学生信息
  12. 	public List<Student> queryAllStudents();
  13. 	
  14. 	
  15. 	//判断此人是否存在
  16. 	public boolean isExist(int sno) ;
  17. 	
  18. 	//增加学生信息
  19. 	public boolean addStudent(Student student);
  20. 	//删除学生信息
  21. 	public boolean deleteStudentBySno(int sno);
  22. 	
  23. 	//根据sno找到要修改的学生，然后再进行修改
  24. 	public boolean  updateStudentBySno(int sno,Student student);
  25. 	//根据学号查询学生信息
  26. 	public Student queryStudentBySno(int sno);
  27. 	
  28. 	//查询总数据数
  29. 	public int getTotalCount();
  30. 	//currentPage:当前页（页码）pageSize:页面大小（每页显示的数据条数）
  31. 	public List<Student> queryStudentByPage(int currentPage,int pageSize);
  32. 	
  33. 	public boolean checkLoginID(String ID,String pwd);
  34.  
  35.  
  36. 	public boolean addLoginID(String ID, String pwd);
  37.  
  38.  
  39. 	public boolean deleteLoginID(String ID);
  40.  
  41.  
  42. 	public boolean IDExist(String ID);
  43.  
  44.  
  45. 	public boolean upLoadWork(int sno, String name);
  46. }

接口的实现类（StudentDaoImpl.java）

  1. package student.dao.impl;
  2.  
  3. import java.sql.Connection;
  4. import java.sql.DriverManager;
  5. import java.sql.PreparedStatement;
  6. import java.sql.ResultSet;
  7. import java.sql.SQLException;
  8. import java.util.ArrayList;
  9. import java.util.List;
  10.  
  11. import student.dao.IStudentDao;
  12. import student.entity.Student;
  13. import student.util.DBUtil;
  14.  
  15. public class StudentDaoImpl implements IStudentDao{
  16. 	
  17. 	private final String URL = "jdbc:mysql://localhost:3306/STUDENT?useSSL=false&serverTimezone=UTC";
  18. 	private final String UserName = "root";
  19. 	private final String Pwd = "123456";
  20.  
  21. 	String JDBC_DRIVER = "com.mysql.cj.jdbc.Driver";
  22. 	//查询全部学生信息
  23. 	public List<Student> queryAllStudents(){
  24. 		PreparedStatement pstmt = null;
  25. 		Student student = null;
  26. 		List<Student> students = new ArrayList<>();
  27. 		ResultSet rs = null;
  28. 		try {
  29. 			String sql = "select * from student1";
  30. 			rs = DBUtil.executeQuery(sql, null);
  31. 			while(rs.next()) {
  32. 				int sno= rs.getInt("sno");
  33. 				String name = rs.getString("name");
  34. 				int age = rs.getInt("age");
  35. 				String dept = rs.getString("dept");
  36. 				student = new Student(name, sno, age, dept);
  37. 				students.add(student);
  38. 			}
  39. 			return students;
  40. 			
  41. 		} catch(Exception e) {
  42. 			e.printStackTrace();
  43. 			return null;
  44. 		}
  45. 		finally {
  46. 			DBUtil.closeAll(rs, pstmt, DBUtil.connection);
  47. 	}
  48. 	}
  49. 	
  50. 	
  51. 	//判断此人是否存在
  52. 	public boolean isExist(int sno) {
  53. 		return queryStudentBySno(sno) == null? false:true;
  54. 	}
  55. 	
  56. 	//增加学生信息
  57. 	public boolean addStudent(Student student) {
  58. 		String sql = "insert into student1(name,sno,age,dept) values(?,?,?,?)";
  59. 		Object[] params = {student.getName(),student.getSno(),student.getAge(),student.getDept()};
  60. 		return DBUtil.executeUpdate(sql, params);
  61. 	}
  62. 	//删除学生信息
  63. 	public boolean deleteStudentBySno(int sno) {
  64. 		String sql = "delete from student1 where sno =?";
  65. 		Object[] params = {sno};
  66. 		return DBUtil.executeUpdate(sql, params);
  67. 	}
  68. 	
  69. 	//根据sno找到要修改的学生，然后再进行修改
  70. 	public boolean  updateStudentBySno(int sno,Student student) {
  71. 		String sql = "update student1 set name =?,age=?,dept=? where sno=?";
  72. 		Object[] params = {student.getName(),student.getAge(),student.getDept(),sno};
  73. 		
  74. 		return DBUtil.executeUpdate(sql, params);
  75. 		
  76. 	}
  77. 	//根据学号查询学生信息
  78. 	public Student queryStudentBySno(int sno){
  79. 		PreparedStatement pstmt = null;
  80. 		Student student = null;
  81. 		Connection connection = null;
  82. 		ResultSet rs = null;
  83. 		try {
  84. 			Class.forName(JDBC_DRIVER);
  85. 			connection = DriverManager.getConnection(URL,UserName,Pwd);
  86. 			String sql = "select * from student1 where sno = ?";
  87. 			pstmt = connection.prepareStatement(sql);
  88. 			pstmt.setInt(1, sno);
  89. 			rs = pstmt.executeQuery();
  90. 			if(rs.next()) {
  91. 				int no= rs.getInt("sno");
  92. 				String name = rs.getString("name");
  93. 				int age = rs.getInt("age");
  94. 				String dept = rs.getString("dept");
  95. 				student = new Student(name, no, age, dept);
  96. 			}
  97. 			return student;
  98. 			
  99. 		} catch (ClassNotFoundException e) {
  100. 			// TODO Auto-generated catch block
  101. 			e.printStackTrace();
  102. 			return null;
  103. 		} catch(SQLException e) {
  104. 			e.printStackTrace();
  105. 			return null;
  106. 		}catch(Exception e) {
  107. 			e.printStackTrace();
  108. 			return null;
  109. 		}
  110. 		finally {
  111. 			DBUtil.closeAll(rs, pstmt, DBUtil.connection);
  112. 				}
  113.  
  114. 	}
  115.  
  116.  
  117. 	@Override
  118. 	public int getTotalCount() {//查询总数据数
  119. 		String sql = "select count(1) from student1";
  120. 		return DBUtil.getTotalCount(sql);
  121. 	}
  122.  
  123.  
  124. 	@Override
  125. 	public List<Student> queryStudentByPage(int currentPage, int pageSize) {
  126. 		String sql = "select * from student1 order by sno asc limit ?,?";
  127. 		Object[] params = {currentPage*pageSize,pageSize};
  128. 		
  129. 		List<Student> students = new ArrayList<>();
  130. 		ResultSet rs = DBUtil.executeQuery(sql, params);
  131. 		try {
  132. 			while(rs.next()) {
  133. 				Student student = new Student(rs.getString("name"),rs.getInt("sno"),rs.getInt("age"),rs.getString("dept"));
  134. 				students.add(student);
  135. 			}
  136. 		} catch (SQLException e) {
  137. 			e.printStackTrace();
  138. 		}catch (Exception e) {
  139. 			e.printStackTrace();
  140. 		}
  141. 		return students;
  142. 	}
  143.  
  144.  
  145. 	@Override
  146. 	public boolean checkLoginID(String ID, String pwd){
  147. 		int count = 0;
  148. 		String sql = "select * from login where ID=? and pwd=?";
  149. 		Object[] params = {ID,pwd};
  150. 		ResultSet rs = DBUtil.executeQuery(sql, params);
  151. 		try {
  152. 			while(rs.next()) {
  153. 				count++;
  154. 			}
  155. 			if(count>0)
  156. 				return true;
  157. 			else
  158. 				return false;
  159. 		} catch (SQLException e) {
  160. 			e.printStackTrace();
  161. 			}
  162. 				return false;
  163. 	}
  164.  
  165.  
  166. 	@Override
  167. 	public boolean addLoginID(String ID, String pwd) {
  168. 		// TODO Auto-generated method stub
  169. 		String sql = "insert into login(ID,pwd) values(?,?)";
  170. 		Object[] params = {ID,pwd};
  171. 		return DBUtil.executeUpdate(sql, params);
  172. 	}
  173.  
  174.  
  175. 	@Override
  176. 	public boolean updateLoginPwd(String ID, String pwd1) {
  177. 		String sql = "update login set pwd =? where ID=?";
  178. 		Object[] params = {pwd1,ID};
  179. 		return DBUtil.executeUpdate(sql, params);
  180. 	}
  181.  
  182.  
  183. 	@Override
  184. 	public boolean deleteLoginID(String ID) {
  185. 		String sql = "delete from login where ID =?";
  186. 		Object[] params = {ID};
  187. 		return DBUtil.executeUpdate(sql, params);
  188. 	}
  189.  
  190.  
  191. 	@Override
  192. 	public boolean IDExist(String ID) {
  193. 		String sql = "select *from login where ID = ?";
  194. 				Object[] params = {ID};
  195. 		return DBUtil.executeUpdate(sql, params);
  196. 	}
  197.  
  198.  
  199. 	@Override
  200. 	public boolean upLoadWork(int sno, String name) {
  201. 		int count = 0;
  202. 		String sql = "select *from student1 where sno = ? and name = ?";
  203. 		Object[] params = {sno,name};
  204. 		ResultSet rs = DBUtil.executeQuery(sql, params);
  205. 		try {
  206. 			while(rs.next()) {
  207. 				count++;
  208. 			}
  209. 			if(count>0)
  210. 				return true;
  211. 			else
  212. 				return false;
  213. 		} catch (SQLException e) {
  214. 			e.printStackTrace();
  215. 			}
  216. 				return false;
  217. 	}
  218. }

④通用的数据库操作（DBUtils.java）

  1. package student.util;
  2.  
  3. import java.sql.Connection;
  4. import java.sql.DriverManager;
  5. import java.sql.PreparedStatement;
  6. import java.sql.ResultSet;
  7. import java.sql.SQLException;
  8. import java.sql.Statement;
  9. import java.util.ArrayList;
  10. import java.util.List;
  11.  
  12. import student.entity.Student;
  13.  
  14. //通用的数据库操作方法
  15. public class DBUtil {
  16. 	private static final String URL = "jdbc:mysql://localhost:3306/STUDENT?useSSL=false&serverTimezone=UTC";
  17. 	private static final String UserName = "root";
  18. 	private static final String Pwd = "123456";
  19. 	private static final String JDBC_DRIVER = "com.mysql.cj.jdbc.Driver";
  20. 	public static Connection connection = null;
  21. 	public static PreparedStatement pstmt = null;
  22. 	public static ResultSet rs = null;
  23. 	
  24. 	//查询总数
  25. 	public static int getTotalCount(String sql){
  26. 		int count = -1;
  27. 		try {
  28. 			pstmt = createPreParedStatement(sql,null);
  29. 			rs = pstmt.executeQuery();
  30. 			if(rs.next()) {
  31. 				count = rs.getInt(1);
  32. 			}
  33. 		} catch (SQLException e) {
  34. 			e.printStackTrace();
  35. 		}catch (Exception e) {
  36. 			e.printStackTrace();
  37. 		}finally {
  38. 			closeAll(rs,pstmt,connection);
  39. 		}
  40. 		return count;
  41. 	}
  42. 	
  43. 	//增删改
  44. 	public static boolean executeUpdate(String sql,Object[] params) {
  45. 		try {
  46. 			pstmt = createPreParedStatement(sql,params);
  47. 			int count = pstmt.executeUpdate();
  48. 			
  49. 			System.out.println(count);
  50. 			if(count>0) {
  51. 				return true;
  52. 			}
  53. 			else {
  54. 				return false;
  55. 			}
  56. 		} catch (ClassNotFoundException e) {
  57. 			e.printStackTrace();
  58. 			return false;
  59. 		} catch(SQLException e) {
  60. 			e.printStackTrace();
  61. 			return false;
  62. 		}catch(Exception e) {
  63. 			e.printStackTrace();
  64. 			return false;
  65. 		}
  66. 		finally {
  67. 			closeAll(null,pstmt,connection);
  68. 	}
  69. 	}
  70. 	public static void closeAll(ResultSet rs,Statement stmt,Connection connection){
  71. 		try{
  72. 			if(rs!=null)rs.close();
  73. 			if(pstmt!=null)pstmt.close();
  74. 			if(connection!=null)connection.close();
  75. 		
  76. 		}catch(SQLException e) {
  77. 			e.printStackTrace();
  78. 		}
  79. 	}
  80. 	
  81. 	public static PreparedStatement createPreParedStatement(String sql,Object[] params) throws ClassNotFoundException, SQLException {
  82. 			pstmt = getConnection().prepareStatement(sql);
  83. 			if(params!=null) {
  84. 			for(int i = 0;i<params.length;i++) {
  85. 				pstmt.setObject(i+1, params[i]);
  86. 			}
  87. 			}
  88. 			return pstmt;
  89. 	}
  90. 	
  91. 	public static Connection getConnection() throws ClassNotFoundException, SQLException {
  92. 		Class.forName(JDBC_DRIVER);
  93. 		return DriverManager.getConnection(URL,UserName,Pwd);
  94. 	}
  95. 	//通用的查
  96. 	public static ResultSet executeQuery(String sql,Object[] params){
  97. 		List<Student> students = new ArrayList<>();
  98. 		Student student = null;
  99. 		
  100. 		try {
  101. 			pstmt = createPreParedStatement(sql,params);
  102. 			rs = pstmt.executeQuery();
  103. 			
  104. 			return rs;
  105. 			
  106. 		} catch(SQLException e) {
  107. 			e.printStackTrace();
  108. 			return null;
  109. 		}catch(Exception e) {
  110. 			e.printStackTrace();
  111. 			return null;
  112. 		}
  113. 		
  114. 	}
  115.  
  116. 	}
  117.

3.JavaBean封装数据

①分页帮助类（Page.java）

  1. package student.entity;
  2.  
  3. import java.util.List;
  4.  
  5. //分页帮助类
  6. public class Page {
  7. 	private int currentPage;
  8. 	private int pageSize;
  9. 	private int totalCount;
  10. 	private int totalPage;
  11. 	private List<Student> students;
  12. 	public Page() {
  13. 		
  14. 	}
  15. 	public Page(int currentPage, int pageSize, int totalCount, int totalPage, List<Student> students) {
  16. 		this.currentPage = currentPage;
  17. 		this.pageSize = pageSize;
  18. 		this.totalCount = totalCount;
  19. 		this.totalPage = totalPage;
  20. 		this.students = students;
  21. 	}
  22. 	public int getCurrentPage() {
  23. 		return currentPage;
  24. 	}
  25. 	public void setCurrentPage(int currentPage) {
  26. 		this.currentPage = currentPage;
  27. 	}
  28. 	public int getPageSize() {
  29. 		return pageSize;
  30. 	}
  31. 	
  32. 	public void setPageSize(int pageSize) {
  33. 		this.pageSize = pageSize;
  34. 		this.totalPage = this.totalCount%this.pageSize==0?this.totalCount/this.pageSize:this.totalCount/this.pageSize+1;
  35. 	}
  36. 	public int getTotalCount() {
  37. 		return totalCount;
  38. 	}
  39. 	public void setTotalCount(int totalCount) {
  40. 		this.totalCount = totalCount;
  41. 	}
  42. 	public int getTotalPage() {
  43. 		return totalPage;
  44. 	}
  45. 	
  46. 	
  47. 	public List<Student> getStudents() {
  48. 		return students;
  49. 	}
  50. 	public void setStudents(List<Student> students) {
  51. 		this.students = students;
  52. 	}
  53. }

②封装学生信息（Student.java）

  1. package student.entity;
  2.  
  3. public class Student {
  4. 	private String name;
  5. 	private int sno;
  6. 	private int age;
  7. 	private String dept;
  8. 	
  9. 	public Student(int sno) {
  10. 		this.sno = sno;
  11. 	}
  12. 	
  13. 	public Student() {
  14. 		
  15. 	}
  16. 	public Student(String name, int age, String dept) {
  17. 		this.name = name;
  18. 		this.age = age;
  19. 		this.dept = dept;
  20. 	}
  21. 	public Student(String name, int sno, int age, String dept) {
  22. 		this.name = name;
  23. 		this.sno = sno;
  24. 		this.age = age;
  25. 		this.dept = dept;
  26. 	}
  27. 	
  28. 	public String getName() {
  29. 		return name;
  30. 	}
  31. 	public void setName(String name) {
  32. 		this.name = name;
  33. 	}
  34. 	public int getSno() {
  35. 		return sno;
  36. 	}
  37. 	public void setSno(int sno) {
  38. 		this.sno = sno;
  39. 	}
  40. 	public int getAge() {
  41. 		return age;
  42. 	}
  43. 	public void setAge(int age) {
  44. 		this.age = age;
  45. 	}
  46. 	public String getDept() {
  47. 		return dept;
  48. 	}
  49. 	public void setDept(String dept) {
  50. 		this.dept = dept;
  51. 	}
  52. 	public String toString() {
  53. 		return this.getSno()+"-"+this.getName()+"-"+this.getAge()+"-"+this.getDept();
  54. 		
  55. 	}
  56. }

4.项目所需jar包

项目需要3个jar包，前两个jar包属于文件上传所需，最后一个为连接数据库的jar包

下载官网地址：https://mvnrepository.com/
 

 

五.数据库表格

本人用的是mysql数据库，直接在mysql数据库中新建表格

①登录注册表格login

②学生信息表格student1

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/花生_TL007/article/detail/701464
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号