首页IT科技用java写学生信息管理系统(Javaweb学生信息管理系统(Mysql+JSP+MVC+CSS))

用java写学生信息管理系统(Javaweb学生信息管理系统(Mysql+JSP+MVC+CSS))

时间2025-04-30 17:31:12分类IT科技浏览3428
导读:项目源码及数据库:...

项目源码及数据库:

链接: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)

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html> <html> <head> <link href="css/login.css" type="text/css" rel="stylesheet"> <meta charset="UTF-8"> <title>学生信息管理系统-登录界面</title> </head> <body> <form action="CheckLoginServlet" method="post"> <div class="content"> <div class="wrap"> <div class="login-box"> <div class="login-frame"> <h2> 用户登录 <a href="register.jsp"> 立即注册</a> </h2> <div class=item> <input type="text" name="UID" placeholder="用户名"> </div> <div class=item> <input type="password" name="upwd" placeholder="密码"> </div> <input type="submit" class="login-btn" value="登 录"> <div class=item1> <a href="UpdateLoginPwd.jsp"> 修改密码</a> <a href="DeleteLoginID.jsp"> 注销用户</a> </div> <% String error = (String) request.getAttribute("error"); String error0 = (String) request.getAttribute("error0"); String error1 = (String) request.getAttribute("error1"); String error2 = (String) request.getAttribute("error2"); String error3 = (String) request.getAttribute("error3"); String error4 = (String) request.getAttribute("error4"); if (error != null) { if (error.equals("loginError")) { out.println("用户名或密码错误!登录失败!"); } else if (error.equals("nologinError")) { response.sendRedirect("QueryStudentByPageServlet"); } } if (error0 != null) { if (error0.equals("loginError")) { out.println("用户名或密码错误!修改失败!"); } else if (error0.equals("nologinError")) { if (error1 != null) { if (error1.equals("noupdateError")) { out.println("密码修改成功!"); } } } } if (error2 != null) { if (error2.equals("loginError")) { out.println("用户名或密码错误!注销失败!"); } else if (error2.equals("nologinError")) { if (error3 != null) { if (error3.equals("nodeleteError")) { out.println("账户注销成功!"); } } } } if (error4 != null) { if (error4.equals("noaddError")) { out.println("账户注册成功!"); } } %> </div> </div> </div> </div> </form> </body> </html>

②登录界面css(login.css)

*{margin:0;padding:0;} a{text-decoration:none;color:#666;} a:hover{ text-decoration:underline; color:E4393C; } html,body { font:12px/150% Arial,Verdana; } .wrap{ width:1000px; margin:0 auto; } .left{ float:left; } .content{ background:url(../image/login.jpg); background-size: cover; width:1280px; height:559px; } .login-frame{ margin:50px 5% 50px 5%; float:right; padding:60px; background:white; background-color:rgba(255,255,255,0.9); border-radius:25px; order-right:1px #bdbdbd solid; width:280px; height:230px; } .login-frame h2{ font-size:25px; height:40px; margin-buttom:25px; } .login-frame h2 a{ font-size:15px; color:#59c2c5; padding-left:20px; background:url(../image/icon5.jpg)no-repeat; } .login-frame .item{ height:60px; margin-buttom:40px; } .login-frame .item input{ line-height:40px; width:260px; border:none; border-bottom: 1px solid #59c2c5; } .login-btn{ display:block; height:50px;display:block; height:50px; color:#fff; background:#59c2c5; width:265px; font-size:16px; line-height:30px; text-align:center; border-radius:10px; border:none; color:#fff; background:#59c2c5; width:265px; font-size:16px; line-height:30px; text-align:center; border-radius:10px; border:none; } .login-frame .item1{ dislpay:flex; justify-content: space-between; margin-top:1 rem; } .login-frame .item1 a{ line-height:40px; font-size:1.1rem; margin-top:5 rem; padding:1rem 3rem; }

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

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html> <html> <head> <link href="css/index.css" type="text/css" rel="stylesheet"> <meta charset="UTF-8"> <script type = "text/javascript" src = "js/jquery-3.6.0.js"></script> <script type = "text/javascript"> function check() { var UID = $("#UID").val(); var upwd = $("#upwd").val(); var upwd1 = $("#upwd1").val(); if(upwd != upwd1){ alert("两次输入的密码不一致      ,请重新输入!"); return false; } return true; } $(document).ready(function(){ }); </script> <title>注册账号</title> </head> <body> <form action = "AddLoginIDServlet" method = "post" onsubmit = "return check()"> <div class = "content"> <div class = "box"> <div class = "item1"> <h2>用户注册</h2> </div> <div class = "item"> <input type = "text" name = "UID" id = "UID" placeholder="账号"/><br/> </div> <div class = "item"> <input type = "password" name = "upwd" id = "upwd" placeholder="密码"/><br/> </div> <div class = "item"> <input type = "password" name = "upwd1" id = "upwd1" placeholder="确认密码"/><br/> </div> <input type = "submit" class = "btn" value = "注册"/><br/> <a href = "login.jsp">返回</a> <% String error4 = (String) request.getAttribute("error4"); if (error4!= null) { if (error4.equals("addError")) { out.println("注册失败!账户名已经存在!"); } } %> </div> </div> </form> </body> </html>

④注册用户界面css(index.css)

*{margin:0;padding:0;} html,body { font:12px/150% Arial,Verdana; } .content{ background:url(../image/login.jpg); background-size: cover; width:1280px; height:559px; } .box{ margin:60px 18% 60px 18%; float:right; padding:30px; background:white; background-color:rgba(255,255,255,0.9); border-radius:15px; } .item{ height:60px; margin-buttom:40px; } .item input{ line-height:40px; width:260px; border:none; border-bottom: 1px solid #59c2c5; border-radius:3px; } .item1{ font-size:15px; height:40px; } .btn{ display:block; height:50px; color:#fff; background:#59c2c5; width:265px; font-size:16px; line-height:30px; text-align:center; border-radius:10px; border:none; }

⑤修改密码界面(UpdateLoginID.jsp)

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html> <html> <head> <link href="css/index.css" type="text/css" rel="stylesheet"> <meta charset="UTF-8"><script type = "text/javascript" src = "js/jquery-3.6.0.js"></script> <script type = "text/javascript"> function check() { var upwd = $("#upwd").val(); var upwd1 = $("#upwd1").val(); var upwd2 = $("#upwd2").val(); if(upwd1 != upwd2){ alert("两次输入的密码不一致                ,请重新输入!"); return false; } return true; } $(document).ready(function(){ }); </script> <title>更改账号密码</title> </head> <body> <form action = "UpdateLoginPwdServlet" method = "post" onsubmit = "return check()"> <div class = "content"> <div class = "box"> <div class= "item1"><h2>修改密码</h2></div> <div class = item> <input type = "text" name = "UID" id = "UID" placeholder="账号"/><br/> </div> <div class = item> <input type = "password" name = "upwd" id = "upwd" placeholder="旧密码"/><br/> </div> <div class = item> <input type = "password" name = "upwd1" id = "upwd1" placeholder="新密码"/><br/> </div> <div class = item> <input type = "password" name = "upwd2" id = "upwd2" placeholder="确认密码"/><br/> </div> <input type = "submit" class = "btn" value = "提交"/><br/> <a href = "login.jsp">返回</a> <% String error0 = (String) request.getAttribute("error0"); if (error0!= null) { if (error0.equals("loginError")) { out.println("用户名或密码错误          ,请重新输入!"); } else if (error0.equals("nologinError")) { response.sendRedirect("login.jsp"); } } %> </div> </div> </form> </body> </html>

⑥注销用户界面(DeleteLoginID.jsp)

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html> <html> <head> <link href="css/index.css" type="text/css" rel="stylesheet"> <meta charset="UTF-8"> <title>注销账号</title> </head> <body> <form action = "DeleteLoginIDServlet" method = "post"> <div class = "content"> <div class = "box"> <div class = "item1"> <h2>注销账号</h2> </div> <div class = "item"> <input type = "text" name = "UID" id = "UID" placeholder="账号"/><br/> </div> <div class = "item"> <input type = "password" name = "upwd" id = "upwd" placeholder="密码"/><br/> </div> <input type = "submit" class = "btn" value = "注销"/><br/> <a href = "login.jsp">返回</a> <% String error2 = (String) request.getAttribute("error2"); if (error2!= null) { if (error2.equals("loginError")) { out.println("用户名或密码错误!注销失败!"); } } %> </div> </div> </form> </body> </html>

⑦登录成功主界面(index.jsp)

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

点击删除删除学生信息

<%@page import="student.entity.Page"%> <%@page import="java.util.List"%> <%@page import="student.entity.Student"%> <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html> <html> <head> <script type = "text/javascript" src = "js/jquery-3.6.0.js"></script> <script type = "text/javascript"> $(document).ready(function(){ $("tr:odd").css("background-color","lightgrey"); }); </script> <link href="css/show.css" type="text/css" rel="stylesheet"> <meta charset="UTF-8"> <title>学生信息列表</title> </head> <body> <div class = "content"> <div class = "box"> <table border="2" cellspacing="0"> <tr> <th><h2>学号</h2></th> <th><h2>姓名</h2></th> <th><h2>年龄</h2></th> <th><h2>专业</h2></th> <th><h2>操作</h2></th> </tr> <% Page page1 = (Page)request.getAttribute("page1"); for(Student student:page1.getStudents()){ %> <tr> <td><a href = "QueryStudentBySnoServlet?sno=<%=student.getSno()%>"><%=student.getSno() %></a></td> <td><%=student.getName() %></td> <td><%=student.getAge() %></td> <td><%=student.getDept() %></td> <td><a href = "DeleteStudentServlet?sno=<%=student.getSno() %>">删除</a></td> </tr> <% } %> </table> <div class = item> <a href = "add.jsp">增加学生</a> </div> <% if(page1.getCurrentPage()==page1.getTotalPage()-1){ %> <div class = item> <a href = "QueryStudentByPageServlet?currentPage=0">首页</a> <a href = "QueryStudentByPageServlet?currentPage=<%=page1.getCurrentPage()-1%>">上一页</a> </div> <% } else if(page1.getCurrentPage()==0){ %> <div class = item> <a href = "QueryStudentByPageServlet?currentPage=<%=page1.getCurrentPage()+1%>">下一页</a> <a href = "QueryStudentByPageServlet?currentPage=<%=page1.getTotalPage()-1%>">尾页</a> </div> <% } else{ %> <div class = item> <a href = "QueryStudentByPageServlet?currentPage=0">首页</a> <a href = "QueryStudentByPageServlet?currentPage=<%=page1.getCurrentPage()-1%>">上一页</a> <a href = "QueryStudentByPageServlet?currentPage=<%=page1.getCurrentPage()+1%>">下一页</a> <a href = "QueryStudentByPageServlet?currentPage=<%=page1.getTotalPage()-1%>">尾页</a> </div> <% } %> <input type = "button" value = "上传作业" class = "btn" onclick = "location = UpAndDown.jsp"/><br/> <% String error = (String)request.getAttribute("error"); if(error!=null){ if(error.equals("addError")){ out.println("增加失败!"); } else if(error.equals("noaddError")){ out.println("增加成功!"); } } String error1 = (String)request.getAttribute("error1"); if(error1!=null){ if(error1.equals("deleteError")){ out.println("删除失败!"); } else if(error1.equals("nodeleteError")){ out.println("删除成功!"); } } String error2 = (String)request.getAttribute("error2"); if(error2!=null){ if(error2.equals("updateError")){ out.println("修改失败!"); } else if(error2.equals("noupdateError")){ out.println("修改成功!"); } } String error3 = (String)request.getAttribute("error3"); if(error3!=null){ if(error3.equals("uploadError")){ out.println("上传失败!"); } else if(error3.equals("nouploadError")){ out.println("上传成功!"); } } %> </div> </div> </body> </html>

⑧登陆成功界面css(show.css)

*{margin:0;padding:0;} html,body { font:12px/150% Arial,Verdana; } .content{ background:url(../image/index.JPG); background-size: cover; width:1280px; height:559px; } .box{ margin:60px 18% 60px 18%; float:right; padding:30px; background:white; background-color:rgba(255,255,255,0.9); border-radius:15px; } .item{ height:40px; border-radius:15px; } .item a{ background-color: lightgrey; text-decoration: none; font-size:15px; color:black; border-radius:3px; } .item1{ font-size:15px; height:40px; } table{ width:100%; border-collapse:collapse; } table body{ diaplay:block; height:300px; overflow-y: scroll; } table td{ border:1px solid #A6A6A6; height:60px; width:300px; text-align: center; font-size: 15px; } table th{ height:60px; border:1px solid #A6A6A6; }

⑨点击学号                 ,修改学生信息界面(StudentInfo.jsp)

<%@page import="student.entity.Student"%> <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <link href="css/index.css" type="text/css" rel="stylesheet"> <title>修改学生信息</title> </head> <body> <% Student student = (Student)request.getAttribute("student"); %> <form action = "UpdateStudentServlet" method = "post"> <div class = "content"> <div class = "box"> <div class = "item1"> <h2>修改学生信息</h2> </div> <div class = "item"> 学号:<input type = "text" name = "sno" value ="<%=student.getSno()%>" readonly = "readonly"/><br/> </div> <div class = "item"> 姓名:<input type = "text" name = "name" value ="<%=student.getName()%>"/><br/> </div> <div class = "item"> 年龄:<input type = "text" name = "age" value ="<%=student.getAge()%>"/><br/> </div> <div class = "item"> 专业:<input type = "text" name = "dept" value ="<%=student.getDept()%>"/><br/> </div> <input type = "submit" class = "btn" value = "修改"/> <a href = "QueryStudentByPageServlet">返回</a> </div> </div> </form> </body> </html>

⑩增加学生信息(add.jsp)

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <link href="css/index.css" type="text/css" rel="stylesheet"> <script type = "text/javascript" src = "js/jquery-3.6.0.js"></script> <script type = "text/javascript"> function check() { var sname = $("#sname").val(); var sno = $("#sno").val(); var sage = $("#sage").val(); var sdept = $("#sdept").val(); if(!(sno>1&&sno<2000)){ alert("学号有误!必须是1-2000"); return false; } if(!(sname.length>1&&sname.length<5)){ alert("姓名有误!必须是2-4位"); return false; } if(!(sage>1&&sage<100)){ alert("年龄有误!必须是1-100"); return false; } return true; } $(document).ready(function(){ }); </script> <title>增加学生信息</title> </head> <body> <form action = "AddStudentServlet" method = "post" onsubmit = "return check()"> <div class = "content"> <div class = "box"> <div class = "item2"> <h2>增加学生信息</h2> </div> <div class = "item"> <input type = "text" name = "name" id = "sname" placeholder="姓名"/><br/> </div> <div class = "item"> <input type = "text" name = "sno" id = "sno" placeholder="学号"/><br/> </div> <div class = "item"> <input type = "text" name = "age" id = "sage" placeholder="年龄"/><br/> </div> <div class = "item"> <input type = "text" name = "dept" id = "sdept" placeholder="专业"/><br/> </div> <input type = "submit" class = "btn" value = "增加"/><br/> <a href = "QueryStudentByPageServlet">返回</a> </div> </div> </form> </body> </html>

⑪上传作业操作(UpAndDown.jsp)

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <link href="css/index.css" type="text/css" rel="stylesheet"> <title>上传作业</title> </head> <body> <form action ="UploadServlet" method = "post" enctype = "multipart/form-data"> <div class = "content"> <div class = "box"> <div class = "item2"> <h2>上传作业</h2> </div> <div class = "item"> <input type = "text" name="sno" placeholder="学号"/><br/> </div> <div class = "item"> <input type = "text" name = "name" placeholder="姓名"/><br/> </div> <input type = "file" name = "spiature"/> <br/> <br/> <input type = "submit" class = "btn" value ="上传"/> <a href = "QueryStudentByPageServlet">返回</a> </div> </div> </form> </body> </html>

2.三层架构

①表示层Servlet

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

package student.servlet; import java.io.IOException; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import student.service.IStudentService; import student.service.impl.StudentServiceImpl; public class CheckLoginServlet extends HttpServlet { protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("utf-8"); String ID = request.getParameter("UID"); String pwd = request.getParameter("upwd"); IStudentService service = new StudentServiceImpl(); boolean result = service.checkLoginID(ID,pwd); response.setContentType("text/html;charest=UTF-8"); response.setCharacterEncoding("utf-8"); if(!result) { request.setAttribute("error", "loginError"); }else { request.setAttribute("error", "nologinError"); } request.getRequestDispatcher("login.jsp").forward(request, response); } protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub doGet(request, response); } }

注册账户表示层(AddLoginIDServlet.java)

package student.servlet; import java.io.IOException; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import student.service.IStudentService; import student.service.impl.StudentServiceImpl; /** * Servlet implementation class AddLoginIDServlet */ public class AddLoginIDServlet extends HttpServlet { private static final long serialVersionUID = 1L; protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("utf-8"); String ID = request.getParameter("UID"); String pwd = request.getParameter("upwd"); IStudentService studentService = new StudentServiceImpl(); boolean result = studentService.addLoginID(ID,pwd); response.setContentType("text/html;charest=UTF-8"); response.setCharacterEncoding("utf-8"); if(!result) { request.setAttribute("error4", "addError"); request.getRequestDispatcher("register.jsp").forward(request, response); }else { request.setAttribute("error4", "noaddError"); request.getRequestDispatcher("login.jsp").forward(request, response); } } /** * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub doGet(request, response); } }

修改密码表示层(UpdateLoginPwdServlet.java)

package student.servlet; import java.io.IOException; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import student.service.IStudentService; import student.service.impl.StudentServiceImpl; /** * Servlet implementation class UpdateLoginPwdServlet */ public class UpdateLoginPwdServlet extends HttpServlet { private static final long serialVersionUID = 1L; protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("utf-8"); String ID = request.getParameter("UID"); String pwd = request.getParameter("upwd"); String pwd1 = request.getParameter("upwd1"); IStudentService service = new StudentServiceImpl(); boolean result = service.checkLoginID(ID,pwd); response.setContentType("text/html;charest=UTF-8"); response.setCharacterEncoding("utf-8"); if(!result) { request.setAttribute("error0", "loginError"); request.getRequestDispatcher("UpdateLoginPwd.jsp").forward(request, response); }else { request.setAttribute("error0", "nologinError"); boolean result1 = service.updateLoginPwd(ID,pwd1); if(!result1) { request.getRequestDispatcher("UpdateLoginPwd.jsp").forward(request, response); }else { request.setAttribute("error1", "noupdateError"); request.getRequestDispatcher("login.jsp").forward(request, response); } } } /** * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub doGet(request, response); } }

注销用户表示层(DeleteLoginIDServlet.java)

package student.servlet; import java.io.IOException; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import student.service.IStudentService; import student.service.impl.StudentServiceImpl; /** * Servlet implementation class DeleteLoginIDServlet */ public class DeleteLoginIDServlet extends HttpServlet { private static final long serialVersionUID = 1L; protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("utf-8"); String ID = request.getParameter("UID"); String pwd = request.getParameter("upwd"); IStudentService service = new StudentServiceImpl(); boolean result = service.checkLoginID(ID,pwd); boolean result1 = service.deleteLoginID(ID); response.setContentType("text/html;charest=UTF-8"); response.setCharacterEncoding("utf-8"); if(!result) { request.setAttribute("error2", "loginError"); request.getRequestDispatcher("DeleteLoginID.jsp").forward(request, response); }else { request.setAttribute("error2", "nologinError"); if(!result1) { request.setAttribute("error3", "deleteError"); request.getRequestDispatcher("DeleteLoginID.jsp").forward(request, response); }else { request.setAttribute("error3", "nodeleteError"); request.getRequestDispatcher("login.jsp").forward(request, response); } } } /** * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub doGet(request, response); } }

分页显示(QueryStudentByPageServlet.java)

package student.servlet; import java.io.IOException; import java.util.List; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import student.entity.Page; import student.entity.Student; import student.service.IStudentService; import student.service.impl.StudentServiceImpl; public class QueryStudentByPageServlet extends HttpServlet { private static final long serialVersionUID = 1L; public QueryStudentByPageServlet() { super(); } protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { IStudentService studentService = new StudentServiceImpl(); int count = studentService.getTotalCount(); Page page = new Page(); String cPage = request.getParameter("currentPage"); if(cPage == null) { cPage = "0"; } int currentPage = Integer.parseInt(cPage); page.setCurrentPage(currentPage); int totalCount = studentService.getTotalCount(); page.setTotalCount(totalCount); int pageSize = 4; page.setPageSize(pageSize); List<Student> students = studentService.queryStudentsByPage(currentPage, pageSize); page.setStudents(students); request.setAttribute("page1", page); request.getRequestDispatcher("index.jsp").forward(request, response); } /** * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub doGet(request, response); } }

按学号查询学生信息(QueryStudentBySnoServlet.java)

package student.servlet; import java.io.IOException; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import student.entity.Student; import student.service.IStudentService; import student.service.impl.StudentServiceImpl; public class QueryStudentBySnoServlet extends HttpServlet { /** * */ private static final long serialVersionUID = 1L; protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("UTF-8"); int sno = Integer.parseInt(request.getParameter("sno")); IStudentService service = new StudentServiceImpl(); Student student = service.queryStudentBySno(sno); request.setAttribute("student", student);//将查询到的request信息放在request域中 request.getRequestDispatcher("StudentInfo.jsp").forward(request,response); } protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doGet(request, response); } }

增加学生信息(AddStudentServlet.java)

package student.servlet; import java.io.IOException; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import student.entity.Student; import student.service.IStudentService; import student.service.impl.StudentServiceImpl; public class AddStudentServlet extends HttpServlet { /** * */ private static final long serialVersionUID = 1L; protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("utf-8"); String name = request.getParameter("name"); int sno = Integer.parseInt(request.getParameter("sno")); int age = Integer.parseInt(request.getParameter("age")); String dept = request.getParameter("dept"); Student student = new Student(name, sno, age, dept); IStudentService studentService = new StudentServiceImpl(); boolean result = studentService.addStudent(student); response.setContentType("text/html;charest=UTF-8"); response.setCharacterEncoding("utf-8"); if(!result) { request.setAttribute("error", "addError"); }else { request.setAttribute("error", "noaddError"); } request.getRequestDispatcher("QueryStudentByPageServlet").forward(request, response); } protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doGet(request, response); } }

删除学生信息(DeleteStudentServlet.java)

package student.servlet; import java.io.IOException; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import student.service.IStudentService; import student.service.impl.StudentServiceImpl; /** * Servlet implementation class DeleteStudentServlet */ public class DeleteStudentServlet extends HttpServlet { protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("utf-8"); int sno = Integer.parseInt(request.getParameter("sno")); IStudentService service = new StudentServiceImpl(); boolean result = service.deleteStudentBySno(sno); response.setContentType("text/html;charest=UTF-8"); response.setCharacterEncoding("utf-8"); if(!result) { request.setAttribute("error1", "deleteError"); }else { request.setAttribute("error1", "nodeleteError"); } request.getRequestDispatcher("QueryStudentByPageServlet").forward(request, response); } protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub doGet(request, response); } }

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

package student.servlet; import java.io.IOException; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import student.entity.Student; import student.service.IStudentService; import student.service.impl.StudentServiceImpl; public class UpdateStudentServlet extends HttpServlet { /** * */ private static final long serialVersionUID = 1L; protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("UTF-8"); String name = request.getParameter("name"); int sno = Integer.parseInt(request.getParameter("sno")); int age = Integer.parseInt(request.getParameter("age")); String dept = request.getParameter("dept"); Student student = new Student(name, age, dept); System.out.println(sno); IStudentService service = new StudentServiceImpl(); boolean result = service.updateStudentBySno(sno, student); response.setContentType("text/html;charest=UTF-8"); response.setCharacterEncoding("utf-8"); if(!result) { request.setAttribute("error2", "updateError"); }else { request.setAttribute("error2", "noupdateError"); } request.getRequestDispatcher("QueryStudentByPageServlet").forward(request, response); } protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doGet(request, response); } }

上传作业(UploadServlet.java)

package student.servlet; import java.io.File; import java.io.IOException; import java.util.Iterator; import java.util.List; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.apache.commons.fileupload.FileItem; import org.apache.commons.fileupload.FileUploadBase; import org.apache.commons.fileupload.FileUploadException; import org.apache.commons.fileupload.disk.DiskFileItemFactory; import org.apac

创心域SEO版权声明:以上内容作者已申请原创保护,未经允许不得转载,侵权必究!授权事宜、对本内容有异议或投诉,敬请联系网站管理员,我们将尽快回复您,谢谢合作!

展开全文READ MORE
戴尔对标公司是哪个(与戴尔科技同行,与远见如影随形) 修改文章的软件有什么好的(免费文章改写软件,这些工具你必须知道)