目录
一、项目介绍
该项目是基于JavaWeb实现的学生管理系统,使用maven进行管理jar包,能够对学生信息进行增删改查,分页查询,以及实现管理员的注册、登录
- 数据库:MySQL
- 开发工具:idea
- 开发环境:jdk 1.8 + tomcat
二、项目结构
三、前期准备
1.配置maven环境,在pom.xml配置文件中配置项目所依赖的jar包
<dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>8.0.21</version> </dependency> <dependency> <groupId>javax.servlet</groupId> <artifactId>javax.servlet-api</artifactId> <version>3.0.1</version> <scope>provided</scope> </dependency> <dependency> <groupId>javax.servlet.jsp</groupId> <artifactId>jsp-api</artifactId> <version>2.2</version> <scope>provided</scope> </dependency>
2.在MySql数据库中,创建登录注册表login和学生信息表student
(1)登录注册表login
(2)学生信息表student
(3)创建数据表代码
SET NAMES utf-8; CREATE DATABASE studentManager; USE studentManager; CREATE TABLE student ( sno INT PRIMARY KEY, sname VARCHAR(20) NOT NULL, sex CHAR(4) , age INT DEFAULT 20, phone VARCHAR(30) ); INSERT INTO student VALUES(1001,\'jack\',\'男\',23,\'13389076524\'); INSERT INTO student VALUES(1002,\'rose\',\'女\',23,\'18760987543\'); INSERT INTO student VALUES(1003,\'tom\',\'男\',23,\'13389067823\'); INSERT INTO student VALUES(1004,\'王麻子\',\'男\',23,\'13560738947\'); INSERT INTO student VALUES(1005,\'大麻子\',\'男\',23,\'18899067532\'); INSERT INTO student VALUES(1006,\'小麻子\',\'男\',23,\'15678634789\'); INSERT INTO student VALUES(1007,\'老麻子\',\'男\',23,\'12199834572\'); INSERT INTO student VALUES(1008,\'张三\',\'男\',23,\'15533098843\'); INSERT INTO student VALUES(1009,\'长萨珊\',\'女\',23,\'12209835679\'); INSERT INTO student VALUES(1010,\'李四\',\'女\',23,\'15509087635\'); INSERT INTO student VALUES(1011,\'王五\',\'男\',23,\'15788679043\'); INSERT INTO student VALUES(1012,\'赵六\',\'女\',23,\'12489034506\'); INSERT INTO student VALUES(1013,\'刘二\',\'男\',23,\'13560596743\'); CREATE TABLE login ( uid INT PRIMARY KEY, pwd VARCHAR(20) NOT NULL, ); INSERT INTO login VALUES(1, \'1234\'); INSERT INTO login VALUES(2, \'2222\'); INSERT INTO login VALUES(3, \'6688\');
3.配置tocamt
四、代码实现
1.JSP界面实现
(1)首页-登录界面 (index.jsp)
<%@ page language=\"java\" contentType=\"text/html; charset=utf-8\" pageEncoding=\"utf-8\"%> <!DOCTYPE html> <html> <head> <title>学生信息管理平台</title> <style> .titleDiv{ height: 85px; color:white; padding-top: 30px; font-size: 50px; padding-left: 30px; font-family: 隶书; } .mainDiv{ width: 899px; height: 500px; border: 4px rgb(237, 237, 237) solid; border-radius: 5px; background-image: url(\"输入你要的图片链接!\"); margin: auto; margin-top: 50px; } .loginDiv{ height: 220px; width: 260px; padding:50px; background-color:rgba(255,255,255,0.9); border-radius:25px; border:1px #bdbdbd solid; opacity:0.9; float: right; margin-right: 100px } .name{ font-size: 25px; } a{ font-size:15px; color:#59c2c5; padding-left:20px; } .item{ height:60px; } .item input{ line-height:40px; width:245px; border:none; border-bottom: 1px solid #59c2c5; margin-bottom: 20px; margin-top: 10px; } .login-btn{ display:block; width:255px; height:50px; color:#fff; background:#59c2c5; font-size:16px; line-height:30px; text-align:center; border-radius:10px; border:none; margin-bottom: 20px; margin-top: 10px; } </style> </head> <body> <div class=\"mainDiv\"> <div class=\"titleDiv\">学生信息管理平台</div> <form action=\"LoginServlet\" method=\"post\"> <div class=\"loginDiv\"> <div class=\"name\"> 用户登录 <a href=\"register.jsp\"> 立即注册</a> </div> <div class=item> <input type=\"text\" name=\"uid\" placeholder=\"用户名\"/> </div> <div class=item> <input type=\"password\" name=\"pwd\" placeholder=\"密码\"/> </div> <input type=\"submit\" class=\"login-btn\" value=\"登 录\"/> <% if(session.getAttribute(\"loginErrorMessage\") != null){ String loginErrorMessage = (String)session.getAttribute(\"loginErrorMessage\"); out.print(loginErrorMessage); } %> <% String register = (String) request.getAttribute(\"register\"); if (register!= null) { if (register.equals(\"reg\")) { out.println(\"注册成功, 请登录!\"); } } %> </div> </form> </div> </body> </html>
(2)用户注册界面 (register.jsp)
<%@ page language=\"java\" contentType=\"text/html; charset=utf-8\" pageEncoding=\"utf-8\"%> <!DOCTYPE html> <html> <head> <title>注册账号</title> <style> .mainDiv{ width: 899px; height: 500px; border: 4px rgb(237, 237, 237) solid; border-radius: 5px; background-image: url(\"输入你要的图片链接!\"); margin: auto; margin-top: 50px; } .titleDiv{ height: 85px; color:white; padding-top: 30px; font-size: 50px; padding-left: 30px; font-family: 隶书; } .registerDiv{ height: 220px; width: 260px; padding:50px; background-color:rgba(255,255,255,0.9); border-radius:25px; border:1px #bdbdbd solid; opacity:0.9; float: right; margin-right: 100px } .name{ font-size: 25px; } .item{ height:60px; } .item input{ line-height:40px; width:245px; border:none; border-bottom: 1px solid #59c2c5; margin-bottom: 20px; margin-top: 10px; } .btn{ display:block; width:255px; height:50px; color:#fff; background:#59c2c5; font-size:16px; line-height:30px; text-align:center; border-radius:10px; border:none; margin-top: 10px; } a{ font-size:18px; padding-left:200px; padding-bottom: 50px; color:#59c2c5; } </style> </head> </head> <body> <div class=\"mainDiv\"> <div class=\"titleDiv\">学生信息管理平台</div> <form action = \"RegisterServlet\"> <div class = \"registerDiv\"> <div class = \"name\">用户注册</div> <div class = \"item\"> <input type = \"text\" name = \"uid\" placeholder=\"账号\"/> </div> <div class = \"item\"> <input type = \"password\" name = \"pwd\" placeholder=\"密码\"/> </div> <input type = \"submit\" class = \"btn\" value = \"注册\"/> <a href = \"index.jsp\" >返回</a> </div> </form> </div> </body> </html>
(3)登录成功-主界面 (main.jsp)
<%@ page language=\"java\" contentType=\"text/html; charset=utf-8\" pageEncoding=\"utf-8\"%> <%@ page import=\"com.stu.po.Student\" %> <!DOCTYPE html> <html > <head> <title>学生信息管理平台</title> <style> .titleDiv{ height: 85px; color:white; padding-top: 30px; font-size: 50px; padding-left: 30px; font-family: 隶书; } .mainDiv{ width: 899px; height: 500px; border: 4px rgb(237, 237, 237) solid; border-radius: 5px; background-image: url(\"https://img1.baidu.com/it/u=4271373647,1745018175&fm=253&fmt=auto&app=138&f=JPEG?w=889&h=500\"); margin: auto; margin-top: 50px; background-size: auto; } .Navigation{ width: 899px; height: 200px; background-color:#59c2c5; opacity:0.8; text-align: center; line-height: 200px; font-family: 楷体; } a{ font-size:30px; color:whitesmoke; padding-left:20px; text-decoration: none; } a:hover{ color: blue; font-family: 隶书; } </style> </head> <body> <div class=\"mainDiv\"> <div class=\"titleDiv\">欢迎进入学生信息管理平台</div> <% if(session.getAttribute(\"login\") == null) { session.setAttribute(\"loginErrorMessage\", \"您必须先登录才能访问主页!\"); response.sendRedirect(\"index.jsp\"); } %> <div class=\"Navigation\"> <a href=\"addStudent.jsp\">添加学生</a> <a href=\"ShowStudentsByPageServlet\">分页查询</a> <a href=\"ShowAllStudentsServlet\">查看所有学生信息</a> <a href=\"QuitServlet\">退出登录</a> </div> </div> </body> </html>
(4)添加学生界面 (addStudent.jsp)
<%@ page contentType=\"text/html;charset=UTF-8\" language=\"java\" %> <!DOCTYPE html> <html> <head> <title>添加学生信息</title> <style> .titleDiv{ height: 2px; color:white; padding-top: 12px; font-size: 50px; padding-left: 30px; font-family: 隶书; } .mainDiv{ width: 899px; height: 500px; border: 4px rgb(237, 237, 237) solid; border-radius: 5px; background-image: url(\"图片链接\"); margin: auto; margin-top: 50px; background-size: auto; } .addDiv{ height: 380px; width: 260px; padding:50px; background-color:rgba(255,255,255,0.9); border-radius:25px; border:1px #bdbdbd solid; opacity:0.9; float: right; margin-right: 80px } .name{ font-size: 20px; } .item{ height:60px; } .item input{ line-height:40px; width:245px; border:none; border-bottom: 1px solid #59c2c5; margin-bottom: 20px; margin-top: 10px; } .btn{ display:block; width:255px; height:50px; color:#fff; background:#59c2c5; font-size:16px; line-height:30px; text-align:center; border-radius:10px; border:none; margin-top: 10px; } a{ font-size:18px; padding-left:200px; padding-bottom: 50px; color:#59c2c5; } </style> </head> <body> <div class=\"mainDiv\"> <div class=\"titleDiv\">学生信息管理平台</div> <form action = \"AddServlet\"> <div class = \"addDiv\"> <div class = \"name\">添加学生信息</div> <div class = \"item\"> <input type = \"text\" name=\"sno\" placeholder=\"学号\"/> </div> <div class = \"item\"> <input type = \"text\" name=\"sname\" placeholder=\"姓名\"/> </div> <div class = \"item\"> <input type = \"text\" name=\"sex\" placeholder=\"性别\"/> </div> <div class = \"item\"> <input type = \"text\" name=\"age\" placeholder=\"年龄\"/> </div> <div class = \"item\"> <input type = \"text\" name=\"phone\" placeholder=\"电话\"/> </div> <input type = \"submit\" class = \"btn\" value = \"添加\"/> <a href = \"main.jsp\">返回</a> </div> </form> </div> </div> </body> </html>
(5)分页查询界面(showAllStudentByPageNo.jsp)
<%@ page import=\"com.stu.po.Student\" %> <%@ page import=\"java.util.List\" %> <%@ page import=\"com.stu.po.Page\" %> <%@ page language=\"java\" contentType=\"text/html; charset=utf-8\" pageEncoding=\"utf-8\"%> <!DOCTYPE html> <html> <head> <title>学生信息管理平台</title> <style> .mainDiv{ width: 900px; height: 550px; border: 4px rgb(237, 237, 237) solid; border-radius: 5px; background-image: url(\"图片链接\"); margin: auto; background-size: auto; } .titleDiv{ height: 20px; color:white; padding-top: 30px; font-size: 50px; padding-left: 30px; font-family: 隶书; } .showStudentDiv{ background-size: cover; width:700px; height:500px; margin: auto; margin-top: 50px; } .item{ height:40px; border-radius:15px; } .item a{ background-color: lightgrey; text-decoration: none; font-size:15px; color:black; border-radius:3px; } .item input{ width: 20px; text-align: center; } table{ width:100%; border-collapse:collapse; background-color: rgba(255,255,255,0.9); opacity: 0.8; } table body{ display: block; height:300px; overflow-y: scroll; } table td{ border:1px solid #A6A6A6; height:30px; width: 300px; text-align: center; font-size: 15px; } table th{ height:30px; border:1px solid #A6A6A6; } </style> </head> <body> <div class=\"mainDiv\"> <div class=\"titleDiv\">分页查询学生信息</div> <div class = \"showStudentDiv\"> <table border=\"2\" cellspacing=\"0\"> <tr> <th><h3>学号</h3></th> <th><h3>姓名</h3></th> <th><h3>性别</h3></th> <th><h3>年龄</h3></th> <th><h3>电话</h3></th> </tr> <% Page page1 = (Page)request.getAttribute(\"page1\"); for(Student student:page1.getStudent()){ %> <tr> <td><%=student.getSno() %></td> <td><%=student.getSname() %></td> <td><%=student.getSex() %></td> <td><%=student.getAge() %></td> <td><%=student.getPhone() %></td> </tr> <% } %> </table> <% if(page1.getCurrentPage()==page1.getTotalPage()){ %> <div class = item> <a href = \"ShowStudentsByPageServlet?currentPage=0\">首页</a> <a href = \"ShowStudentsByPageServlet?currentPage=<%=page1.getCurrentPage()-1%>\">上一页</a> <input type = \"text\" name = \"currentPage\" value=\"<%=page1.getTotalPage()+1%>\"/> </div> <% } else if(page1.getCurrentPage()==0){ %> <div class = item> <input type = \"text\" name = \"currentPage\" value=\"1\"/> <a href = \"ShowStudentsByPageServlet?currentPage=<%=page1.getCurrentPage()+1%>\">下一页</a> <a href = \"ShowStudentsByPageServlet?currentPage=<%=page1.getTotalPage()%>\">尾页</a> </div> <% } else{ %> <div class = item> <a href = \"ShowStudentsByPageServlet?currentPage=0\">首页</a> <a href = \"ShowStudentsByPageServlet?currentPage=<%=page1.getCurrentPage()-1%>\">上一页</a> <input type = \"text\" name = \"currentPage\" value=\"<%=page1.getCurrentPage()+1%>\"/> <a href = \"ShowStudentsByPageServlet?currentPage=<%=page1.getCurrentPage()+1%>\">下一页</a> <a href = \"ShowStudentsByPageServlet?currentPage=<%=page1.getTotalPage()%>\">尾页</a> </div> <% } %> <a href = \"main.jsp\">返回</a> </div> </div> </body> </html>
(6)查看所有学生信息界面
<%@ page language=\"java\" contentType=\"text/html; charset=utf-8\" pageEncoding=\"utf-8\"%> <%@ page import=\"com.stu.po.Student\" %> <%@ page import=\"java.util.List\" %> <!DOCTYPE html> <html> <head> <title>学生信息管理平台</title> <style> .mainDiv{ width: 900px; height: 700px; border: 4px rgb(237, 237, 237) solid; border-radius: 5px; background-image: url(\"图片链接\"); margin: auto; background-size: auto; } .titleDiv{ height: 20px; color:white; padding-top: 30px; font-size: 50px; padding-left: 30px; font-family: 隶书; } .showStudentDiv{ background-size: cover; width:700px; height:500px; margin: auto; margin-top: 50px; } .item{ height:40px; border-radius:15px; } .item a{ background-color: lightgrey; text-decoration: none; font-size:15px; color:black; border-radius:3px; } table{ width:100%; border-collapse:collapse; background-color: rgba(255,255,255,0.9); opacity: 0.8; } table body{ display: block; height:300px; overflow-y: scroll; } table td{ border:1px solid #A6A6A6; height:30px; width: 300px; text-align: center; font-size: 15px; } table th{ height:30px; border:1px solid #A6A6A6; } </style> </head> <body> <div class=\"mainDiv\"> <div class=\"titleDiv\">查看所有学生信息</div> <div class = \"showStudentDiv\"> <table border=\"2\" cellspacing=\"0\"> <tr> <th><h3>学号</h3></th> <th><h3>姓名</h3></th> <th><h3>性别</h3></th> <th><h3>年龄</h3></th> <th><h3>电话</h3></th> <th><h3>操作</h3></th> </tr> <% List<Student> allStudents = (List<Student>)session.getAttribute(\"allStudents\"); for (int i = 0; i < allStudents.size(); i++) { Student s = allStudents.get(i); %> <tr> <td><%=s.getSno() %></td> <td><%=s.getSname() %></td> <td><%=s.getSex() %></td> <td><%=s.getAge() %></td> <td><%=s.getPhone() %></td> <td> <a href = \"DeleteServlet?sno=<%=s.getSno() %>\">删除</a> <a href = \"QueryStudentBySnoServlet?sno=<%=s.getSno()%>\">修改</a> </td> </tr> <% } %> </table> <a href = \"main.jsp\">返回</a> </div> </div> </body> </html>
(7) 修改学生界面 (updateStudent.jsp)
<%@ page language=\"java\" contentType=\"text/html; charset=utf-8\" pageEncoding=\"utf-8\"%> <%@ page import=\"com.stu.po.Student\" %> <!DOCTYPE html> <html lang=\"en\"> <head> <meta charset=\"UTF-8\"> <meta http-equiv=\"X-UA-Compatible\" content=\"IE=edge\"> <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\"> <title>修改学生信息</title> <style> .titleDiv{ height: 20px; color:white; padding-top: 30px; font-size: 50px; padding-left: 30px; font-family: 隶书; } .mainDiv{ width: 899px; height: 500px; border: 4px rgb(237, 237, 237) solid; border-radius: 5px; background-image: url(\"https://img1.baidu.com/it/u=4271373647,1745018175&fm=253&fmt=auto&app=138&f=JPEG?w=889&h=500\"); margin: auto; margin-top: 50px; background-size: auto; } .updateDiv{ height: 340px; width: 260px; padding:50px; background-color:rgba(255,255,255,0.9); border-radius:25px; border:1px #bdbdbd solid; opacity:0.9; float: right; margin-right: 100px } .name{ font-size: 25px; } .item{ height:60px; } .item input{ line-height:40px; width:245px; border:none; border-bottom: 1px solid #59c2c5; margin-bottom: 20px; margin-top: 10px; } .btn{ display:block; width:255px; height:50px; color:#fff; background:#59c2c5; font-size:16px; line-height:30px; text-align:center; border-radius:10px; border:none; margin-top: 10px; } a{ font-size:18px; padding-right:100px; padding-bottom: 50px; } </style> </head> <body> <div class=\"mainDiv\"> <div class=\"titleDiv\">学生信息管理平台</div> <form action = \"UpdateServlet\"> <% Student s =(Student)request.getAttribute(\"student\"); %> <div class = \"updateDiv\"> <div class = \"name\">修改学生信息</div> <input type=\"hidden\" name=\"sno\" value=\"<%=s.getSno()%>\"/> <div class = \"item\"> <input type = \"text\" name=\"sname\" placeholder=\"姓名\" value=\"<%=s.getSname()%>\"/> </div> <div class = \"item\"> <input type = \"text\" name=\"sex\" placeholder=\"性别\" value=\"<%=s.getSex()%>\"/> </div> <div class = \"item\"> <input type = \"text\" name=\"age\" placeholder=\"年龄\" value=\"<%=s.getAge()%>\"/> </div> <div class = \"item\"> <input type = \"text\" name=\"phone\" placeholder=\"电话\" value=\"<%=s.getPhone()%>\"/> </div> <input type = \"submit\" class = \"btn\" value = \"修改\"/> <a href = \"showAllStudents.jsp\">返回</a> </div> </form> </div> </div> </body> </html>
2.JavaBean实体类封装数据
(1)学生信息类 (Student.java)
package com.stu.po; public class Student { //这是一个实体类,javabean private int sno; private String sname; private String sex; private int age; private String phone; public Student(int sno, String sname, String sex, int age, String phone) { this.sno = sno; this.sname = sname; this.sex = sex; this.age = age; this.phone = phone; } public Student() { } public int getSno() { return sno; } public void setSno(int sno) { this.sno = sno; } public String getSname() { return sname; } public void setSname(String sname) { this.sname = sname; } public String getSex() { return sex; } public void setSex(String sex) { this.sex = sex; } public int getAge() { return age; } public void setAge(int age) { this.age = age; } public String getPhone() { return phone; } public void setPhone(String phone) { this.phone = phone; } }
(2)分页帮助类 (Page.java)
package com.stu.po; import java.util.List; //分页帮助类 public class Page { private int currentPage; //当前页面 private int pageSize; //一页有多少条数据 private int totalCount; //一共有多少条数据 private int totalPage; //一共有多少页 private List<Student> student; public Page() { } public Page(int currentPage, int pageSize, int totalCount, int totalPage, List<Student> student) { this.currentPage = currentPage; this.pageSize = pageSize; this.totalCount = totalCount; this.totalPage = totalPage; this.student = student; } public int getCurrentPage() { return currentPage; } public void setCurrentPage(int currentPage) { this.currentPage = currentPage; } public int getPageSize() { return pageSize; } public void setPageSize(int pageSize) { this.pageSize = pageSize; } public int getTotalCount() { return totalCount; } public void setTotalCount(int totalCount) { this.totalCount = totalCount; } public int getTotalPage() { return totalPage; } public void setTotalPage(int totalPage) { this.totalPage = totalPage; } public List<Student> getStudent() { return student; } public void setStudent(List<Student> student) { this.student = student; } }
(3)JDBC工具类 (DBTools.java)
package com.stu.utils; public interface DBTools { public static final String DRIVER_CLASS = \"com.mysql.jdbc.Driver\"; public static final String CONN_STR = \"jdbc:mysql://localhost:3306/studentmanager?userSSL=false&serverTimezone=Asia/Shanghai\"; public static final String USRENAME = \"root\"; public static final String PWD = \"123456\"; }
3.三层架构
(1)表示层servlet
① 用户登录表示层 (LoginServlet.java)
package com.stu.servlet; import java.io.IOException; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import com.stu.po.Student; import com.stu.service.StudentService; import com.stu.service.StudentServiceImpl; @WebServlet(\"/LoginServlet\") public class LoginServlet extends HttpServlet{ @Override protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { this.doPost(req, resp); } @Override protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { StudentService service = new StudentServiceImpl(); HttpSession session = request.getSession(); if (session.getAttribute(\"loginErrorMessage\") != null) { session.invalidate(); } String uid = request.getParameter(\"uid\"); String pwd = request.getParameter(\"pwd\"); int _uid = Integer.parseInt(uid); boolean result = service.login(_uid, pwd); if(result){ session.setAttribute(\"login\", \"log\"); response.sendRedirect(\"main.jsp\"); }else{ response.sendRedirect(\"index.jsp\"); } } }
② 用户注册表示层 (RegisterServlet.java)
package com.stu.servlet; import java.io.IOException; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import com.stu.po.Student; import com.stu.service.StudentService; import com.stu.service.StudentServiceImpl; @WebServlet(\"/RegisterServlet\") public class RegisterServlet extends HttpServlet{ @Override protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { this.doPost(req, resp); } @Override protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { StudentService service = new StudentServiceImpl(); String uid = request.getParameter(\"uid\"); String pwd = request.getParameter(\"pwd\"); int _uid = Integer.parseInt(uid); boolean result = service.addLogin(_uid,pwd); if(!result) { request.setAttribute(\"register\", \"reg\"); request.getRequestDispatcher(\"index.jsp\").forward(request, response); }else { request.getRequestDispatcher(\"register.jsp\").forward(request, response); } } }
③ 分页查询表示层 (ShowStudentsByPageServlet.java)
package com.stu.servlet; import java.io.IOException; import java.util.List; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import com.stu.po.Page; import com.stu.po.Student; import com.stu.service.StudentService; import com.stu.service.StudentServiceImpl; @WebServlet(\"/ShowStudentsByPageServlet\") public class ShowStudentsByPageServlet extends HttpServlet{ @Override protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { StudentService Service = new StudentServiceImpl(); int count = Service.getTotalCount(); Page page = new Page(); String currentPage = request.getParameter(\"currentPage\"); if(currentPage == null) { currentPage = \"0\"; } int _currentPage = Integer.parseInt(currentPage); page.setCurrentPage(_currentPage); int totalCount = Service.getTotalCount(); page.setTotalCount(totalCount); int pageSize = 5; int totalPage = (totalCount / pageSize) + 1; page.setTotalPage(totalPage+1); page.setPageSize(pageSize); List<Student> student = Service.queryStudentsByPageNo(_currentPage, pageSize); page.setStudent(student); request.setAttribute(\"page1\", page); request.getRequestDispatcher(\"showAllStudentsByPageNo.jsp\").forward(request, response); } }
④ 查询所学生信息表示层 (ShowAllStudentsServlet.java)
package com.stu.servlet; import java.io.IOException; import java.util.List; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import com.stu.po.Student; import com.stu.service.StudentService; import com.stu.service.StudentServiceImpl; @WebServlet(\"/ShowAllStudentsServlet\") public class ShowAllStudentsServlet extends HttpServlet{ @Override protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { StudentService service = new StudentServiceImpl(); HttpSession session = request.getSession(); List<Student> allStudents = service.getAllStudents(); session.setAttribute(\"allStudents\", allStudents); response.sendRedirect(\"showAllStudents.jsp\"); } }
⑤ 添加学生表示层 (AddServlet.java)
package com.stu.servlet; import com.stu.po.Student; import com.stu.service.StudentService; import com.stu.service.StudentServiceImpl; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import java.io.IOException; @WebServlet(\"/AddServlet\") public class AddServlet extends HttpServlet{ @Override protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { this.doPost(req, resp); } @Override protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { StudentService service = new StudentServiceImpl(); String sno = request.getParameter(\"sno\"); String sname = request.getParameter(\"sname\"); String sex = request.getParameter(\"sex\"); String age = request.getParameter(\"age\"); String phone = request.getParameter(\"phone\"); int _sno = 0; if(sno != null || \"\".equals(sno)){ _sno = Integer.parseInt(sno); } int _age = 0; if (age !=null || \"\".equals(age)){ _age = Integer.parseInt(age); } Student s = new Student(_sno, sname, sex, _age, phone); int result = service.addStudent(s); HttpSession session = request.getSession(); session.setAttribute(\"student\", \"stu\"); response.sendRedirect(\"main.jsp\"); } }
⑥ 删除学生表示层 (DeleteServlet.java)
package com.stu.servlet; import com.stu.po.Student; import com.stu.service.StudentService; import com.stu.service.StudentServiceImpl; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.io.IOException; @WebServlet(\"/DeleteServlet\") public class DeleteServlet extends HttpServlet { protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { //1.获取sno String sno = request.getParameter(\"sno\"); int _sno = 0; if(sno != null && !\"\".equals(sno)){ _sno = Integer.parseInt(sno); } //2.执行删除 StudentService service = new StudentServiceImpl(); Student stu = service.deleteStudent(_sno); //3.跳转到列表页 request.setAttribute(\"stu\", stu); request.getRequestDispatcher(\"ShowAllStudentsServlet\").forward(request,response); } }
⑦ 根据学号查询学生信息表示层 (QueryStudentBySnoSevlet.java)
package com.stu.servlet; import com.stu.po.Student; import com.stu.service.StudentService; import com.stu.service.StudentServiceImpl; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.io.IOException; @WebServlet(\"/QueryStudentBySnoServlet\") public class QueryStudentBySnoServlet extends HttpServlet { @Override protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { //获取sno; String sno = request.getParameter(\"sno\"); int _sno = 0; if(sno != null && !\"\".equals(sno)){ _sno = Integer.parseInt(sno); } //2.查询学生数据 StudentService service = new StudentServiceImpl(); Student student = service.queryStudentBySno(_sno); //3.显示数据 //存数据 request.setAttribute(\"student\", student); //跳转 request.getRequestDispatcher(\"updateStudent.jsp\").forward(request,response); } }
⑧ 修改学生信息表示层 (UpdateServlet.java)
package com.stu.servlet; import com.stu.po.Student; import com.stu.service.StudentService; import com.stu.service.StudentServiceImpl; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import java.io.IOException; import java.util.List; @WebServlet(\"/UpdateServlet\") public class UpdateServlet extends HttpServlet { protected void doGet(HttpServletRequest request, HttpServletResponse resp) throws ServletException, IOException { String sno = request .getParameter(\"sno\"); String sname = request.getParameter(\"sname\"); String sex = request.getParameter(\"sex\"); String age = request.getParameter(\"age\"); String phone = request.getParameter(\"phone\"); int _sno = 0; if(sno != null && !\"\".equals(sno)){ _sno = Integer.parseInt(sno); } int _age = 0; if(age != null && !\"\".equals(age)){ _age = Integer.parseInt(age); } Student stu = new Student(_sno, sname, sex, _age, phone); StudentService service = new StudentServiceImpl(); service.updateStudentBySno(_sno,stu); //3.跳转界面 request.getRequestDispatcher(\"ShowAllStudentsServlet\").forward(request, resp); } }
⑨ 退出登录表示层 (QuitServlet.java)
package com.stu.servlet; import java.io.IOException; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; @WebServlet(\"/QuitServlet\") public class QuitServlet extends HttpServlet{ @Override protected void doGet(HttpServletRequest request, HttpServletResponse resp) throws ServletException, IOException { HttpSession session = request.getSession(); session.invalidate();//清空session对象中的所有属性数据内容 resp.sendRedirect(\"index.jsp\"); } }
(2)业务逻辑层service
① Service接口(StudentService.java)
package com.stu.service; import java.util.List; import com.stu.po.Student; public interface StudentService { //service表示业务逻辑层,定义的每一个方法实际上对应的就是用户的一个需求(请求) public boolean login(int uid,String pwd); public boolean addLogin(int uid, String pwd); public List<Student> getAllStudents(); public List<Student> queryStudentsByPageNo(int current, int pageSize); public Student deleteStudent(int sno); public Student queryStudentBySno(int sno); public int updateStudentBySno(int sno, Student stu) ; public int getTotalCount(); public int addStudent(Student student); }
② 接口的实现类(StudentServiceImpl.java)
package com.stu.service; import java.util.List; import com.stu.dao.StudentDao; import com.stu.dao.StudentDaoImpl; import com.stu.po.Student; public class StudentServiceImpl implements StudentService { StudentDao dao = new StudentDaoImpl(); //登陆 @Override public boolean login(int uid, String pwd) { return dao.login(uid, pwd); } // 注册 @Override public boolean addLogin(int uid, String pwd){ return dao.addLogin(uid, pwd); } // 查询所有学生 @Override public List<Student> getAllStudents() { return dao.getAllStudents(); } // 分页查询 @Override public List<Student> queryStudentsByPageNo(int current, int pageSize) { return dao.queryStudentByPage(current,pageSize); } // 删除学生 @Override public Student deleteStudent(int sno){ return dao.deleteStudent(sno); } // 修改学生信息,要先根据学号查询学生信息 public Student queryStudentBySno(int sno) { return dao.queryStudentBySno(sno); } //更改学生信息 public int updateStudentBySno(int sno, Student stu) { return dao.updateStudentBySno(sno,stu); } //查询总条数 @Override public int getTotalCount() { return dao.getTotalCount(); } @Override public int addStudent(Student student) { return dao.addStudent(student); } }
(3)数据访问层dao
① 接口(StudentDao.java)
package com.stu.dao; import java.util.List; import com.stu.po.Student; public interface StudentDao { public boolean login(int uid ,String pwd); public boolean addLogin(int uid, String pwd); public List<Student> getAllStudents(); public List<Student> queryStudentByPage(int currentPage,int pageSize); public Student deleteStudent(int sno); public Student queryStudentBySno(int sno); public int updateStudentBySno(int sno,Student stu); //查询总数据数 public int getTotalCount(); public int addStudent(Student student); }
② 接口的实现类(StudentDaoImpl.java)
package com.stu.dao; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import java.util.List; import com.stu.po.Student; import com.stu.utils.DBTools; public class StudentDaoImpl implements StudentDao { Connection conn = null; // 连接对象 Statement st = null; // 语句对象 ResultSet rs = null; // 结果集合对象 @Override public boolean login(int uid, String pwd) { // 在这里需要连接数据库,根据int sno, String pwd这两个参数来查询student表 // jdbc // 1:配置环境,下载数据库连接驱动jar文件,拷贝到项目中来 // 2:加载驱动,根据驱动创建数据库的连接对象 try { Class.forName(DBTools.DRIVER_CLASS);// 加载驱动 conn = DriverManager.getConnection(DBTools.CONN_STR, DBTools.USRENAME, DBTools.PWD); // 3:执行sql语句,完成对数据库中表的数据的增删该查。必须创建一个语句对象(执行sql语句的) st = conn.createStatement(); int count = 0; String sqlStr = \"select * from login where uid =\" + uid + \" and pwd = \'\" + pwd + \"\'\"; rs = st.executeQuery(sqlStr); while(rs.next()) { count++; } if(count>0) return true; else return false; } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } return false; } @Override public List<Student> getAllStudents() { try { Class.forName(DBTools.DRIVER_CLASS);// 加载驱动 conn = DriverManager.getConnection(DBTools.CONN_STR, DBTools.USRENAME, DBTools.PWD); // 3:执行sql语句,完成对数据库中表的数据的增删该查。必须创建一个语句对象(执行sql语句的) st = conn.createStatement(); String sqlStr = \"select * from student\"; rs = st.executeQuery(sqlStr); List<Student> allStudents = new ArrayList<Student>(); while (rs.next()) { int _sno = rs.getInt(1); String _sname = rs.getString(2); String _sex = rs.getString(3); int _age = rs.getInt(4); String _phone = rs.getString(5); Student s = new Student(_sno, _sname, _sex, _age, _phone); allStudents.add(s); } return allStudents; } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } return null; } public List<Student> queryStudentByPage(int current, int pageSize) { try { Class.forName(DBTools.DRIVER_CLASS);// 加载驱动 conn = DriverManager.getConnection(DBTools.CONN_STR, DBTools.USRENAME, DBTools.PWD); // 3:执行sql语句,完成对数据库中表的数据的增删该查。必须创建一个语句对象(执行sql语句的) st = conn.createStatement(); int startPosition = current * pageSize; String sqlStr = \"select * from student limit \" + startPosition + \",\" + pageSize; rs = st.executeQuery(sqlStr); List<Student> allStudents = new ArrayList<Student>(); while (rs.next()) { int _sno = rs.getInt(1); String _sname = rs.getString(2); String _sex = rs.getString(3); int _age = rs.getInt(4); String _phone = rs.getString(5); Student s = new Student(_sno, _sname, _sex, _age, _phone); allStudents.add(s); } return allStudents; } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } return null; } public int getTotalCount() {//查询总数据数 try { Class.forName(DBTools.DRIVER_CLASS);// 加载驱动 conn = DriverManager.getConnection(DBTools.CONN_STR, DBTools.USRENAME, DBTools.PWD); // 3:执行sql语句,完成对数据库中表的数据的增删该查。必须创建一个语句对象(执行sql语句的) st = conn.createStatement(); String sql = \"select count(*) from student\"; rs = st.executeQuery(sql); while (rs.next()){ int totalCount = rs.getInt(1); } }catch (Exception e){ e.printStackTrace(); } return 0; } @Override public int addStudent(Student student) { try { Class.forName(DBTools.DRIVER_CLASS);// 加载驱动 conn = DriverManager.getConnection(DBTools.CONN_STR, DBTools.USRENAME, DBTools.PWD); st = conn.createStatement(); String sqlStr = \"insert into student values(\"+student.getSno()+\",\'\" + student.getSname()+ \"\',\'\" + student.getSex() +\"\',\"+student.getAge()+\",\'\"+student.getPhone()+\"\')\"; System.out.println(sqlStr); int result = st.executeUpdate(sqlStr); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } return 0; } @Override public boolean addLogin(int uid, String pwd) { try { Class.forName(DBTools.DRIVER_CLASS);// 加载驱动 conn = DriverManager.getConnection(DBTools.CONN_STR, DBTools.USRENAME, DBTools.PWD); st = conn.createStatement(); String sqlStr = \"insert into login values(\" + uid + \",\'\" + pwd + \"\')\"; int result = st.executeUpdate(sqlStr); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } return false; } @Override public Student deleteStudent(int sno) { try { Class.forName(DBTools.DRIVER_CLASS);// 加载驱动 conn = DriverManager.getConnection(DBTools.CONN_STR, DBTools.USRENAME, DBTools.PWD); st = conn.createStatement(); String sqlStr = \"delete from student where sno = \" + sno; System.out.println(sqlStr); int result = st.executeUpdate(sqlStr); } catch (Exception e){ e.printStackTrace(); } return null; } @Override public Student queryStudentBySno(int sno) { try { Class.forName(DBTools.DRIVER_CLASS);// 加载驱动 conn = DriverManager.getConnection(DBTools.CONN_STR, DBTools.USRENAME, DBTools.PWD); st = conn.createStatement(); String sqlStr = \"select * from student where sno = \"+ sno; rs = st.executeQuery(sqlStr); if (rs.next()) { int _sno = rs.getInt(1); String _sname = rs.getString(2); String _sex = rs.getString(3); int _age = rs.getInt(4); String _phone = rs.getString(5); Student s = new Student(_sno, _sname, _sex, _age, _phone); return s; } } catch (Exception e) { e.printStackTrace(); } return null; } @Override public int updateStudentBySno(int sno, Student stu){ try { Class.forName(DBTools.DRIVER_CLASS);// 加载驱动 conn = DriverManager.getConnection(DBTools.CONN_STR, DBTools.USRENAME, DBTools.PWD); st = conn.createStatement(); String sql = \"update student set sname= \'\"+stu.getSname()+\"\', sex=\'\"+stu.getSex()+\"\', age=\"+stu.getAge()+\", phone=\'\"+stu.getPhone()+\"\' where sno=\"+sno; System.out.println(sql); int result = st.executeUpdate(sql); } catch (Exception e){ e.printStackTrace(); } return 0; } }
做猪小侠源码的代理,提供一站式服务
如果你不懂得搭建网站或者服务器,小程序,源码之类的怎么办? 第一通过本站学习各种互联网的技术 第二就是联系客服,我帮帮你搭建(当然要收取部分的费用) 第三成为我们的代理,我们提供整套的服务。