软件定制开发供应商Javaweb学生信息管理系统（Mysql+JSP+MVC+CSS）

软件定制开发供应商项目源码及数据库：

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

 

目录

一.项目介绍

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

数据库：Mysql

开发工具：

开发环境：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包

下载官网地址：
 

 

五.数据库表格

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

①登录注册表格login

②学生信息表格student1

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