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

基于javaweb的图书管理系统_基于web的图书管理系统

作者：酷酷是懒虫 | 2024-06-19 00:47:05

赞

踩

基于web的图书管理系统

一、系统简介

本项目采用eclipse工具开发，jsp+servlet技术编写，样式采用了layui前端框架，数据库采用的是mysql，navicat开发工具。

系统一共分为2个角色分别是：管理员，学生

二、模块简介
管理员


1、登录

2、修改个人信息

3、图书类型管理

4、图书管理

5、图书借阅管理

6、借阅审批管理

7、图书借阅统计

8、学生管理

9、公告管理

学生
1、登录、注册

2、个人信息修改

3、图书借阅

4、借阅管理

5、借阅统计

6、查看公告

三、相关截图

项目结构、数据库结构

 

 登录注册页面

 

 图书类型管理

 图书管理

 学生管理

 审批管理

 

借阅管理

 公告管理

 管理员统计

 学生统计

 图书借阅

 借阅历史

 四、相关代码

登录代码

用户通过login.jsp页面填写指定的用户名和密码，点击登录按钮，执行servlet里面的方法，后台校验成功后，返回main.jsp

  1. <%@ page language="java" contentType="text/html; charset=utf-8"
  2. 	pageEncoding="utf-8"%>
  3. <%
  4. 	String path = request.getContextPath();
  5. 	String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort() + path + "/";
  6. %>
  7. <!DOCTYPE html>
  8. <html>
  9. 	<head>
  10. 		<meta charset="utf-8">
  11. 		<title>Login Page</title>
  12. 		<!-- 样 式 文 件 -->
  13. 		<link rel="stylesheet" href="resource/component/pear/css/pear.css" />
  14. 		<link rel="stylesheet" href="resource/admin/css/other/login.css" />
  15. 	</head>
  16.     <!-- 代 码 结 构 -->
  17. 	<body background="resource/admin/images/background.svg" style="background-size: cover;">
  18. 		<form class="layui-form" action="LoginServlet?action=login" method="post"  id="loginForm" name="loginForm" >
  19. 			<div class="layui-form-item">
  20. 				<img class="logo" src="resource/admin/images/logo.png" />
  21. 				<div class="title">登&emsp;&emsp;录</div>
  22. 				<div class="desc">
  23. 					 图  书  管  理  系  统
  24. 				</div>
  25. 			</div>
  26. 			<div class="layui-form-item">
  27. 				<input type="text" placeholder="请输入用户名或者手机号" name="userName" id="userName" hover class="layui-input"  />
  28. 				<span id="msg3" style="color:red">${message}</span>
  29. 			</div>
  30. 			<div class="layui-form-item">
  31. 				<input id="password" type="password" name="password" placeholder="请输入密码" hover class="layui-input"  />
  32. 			</div>
  33. 			<div class="layui-form-item" style="text-align: center;">
  34. 			      <input type="radio" name="type" id="type" value="1" title="管理员" checked>
  35.                   <input type="radio" name="type" id="type" value="2" title="学生" > 
  36. 			</div>
  37. 			<div class="layui-form-item">
  38. 				<button type="submit" class="pear-btn pear-btn-success login" id="login">
  39. 					登录
  40. 				</button>
  41. 			</div>
  42. 			 <div class="layui-form-item">
  43. 				<a href="LoginServlet?action=toRegister" class="pear-btn pear-btn-warming  layui-btn-fluid">去注册</a>
  44. 			</div> 
  45. 		</form>
  46. 		<!-- 资 源 引 入 -->
  47. 		<script src="resource/component/layui/layui.js"></script>
  48. 		<script src="resource/component/pear/pear.js"></script>
  49. 		<script>
  50. 		layui.use(['layer', 'form','jquery'], function(){
  51. 			var form = layui.form,
  52. 			 layer = layui.layer,
  53. 			 $= layui.jquery;
  54. 			 form.render();//这句一定要加，占坑
  55. 		   
  56. 		$("#login").on("click", function() {
  57. 		    var userName = $("#userName").val().trim(); // trim()去除空格
  58. 		    var password = $("#password").val().trim();
  59. 		    var type = $("#type").val();
  60. 		    
  61. 		    
  62. 		    if(userName == ""){
  63. 		    	layer.msg('用户名或者手机号不能为空！');
  64. 		    	return false;
  65. 		    }
  66. 		    if(password == ""){
  67. 		    	layer.msg('密码不能为空！');
  68. 		    	return false;
  69. 		    }
  70. 		    if(type == ""){
  71. 		    	layer.msg('请选择角色！');
  72. 		    	return false;
  73. 		    }
  74.  
  75. 		});
  76.  
  77. 		setTimeout(function(){ $("#msg").html("")},3000);
  78. 		setTimeout(function(){ $("#msg2").html("")},3000);
  79. 		setTimeout(function(){ $("#msg3").html("")},3000);
  80. 		});
  81. 		</script>
  82. 	</body>
  83. </html>
  1.  
  2.  
  3. 	private void login(HttpServletRequest request, HttpServletResponse response) {
  4. 		// TODO Auto-generated method stub
  5. 		removeAll(request,response);
  6. 		String userName = request.getParameter("userName");
  7. 		String password = request.getParameter("password");
  8. 		String type = request.getParameter("type");
  9. 		if(type.equals("1")){
  10. 			Admin admin = new Admin();
  11. 			admin.setUserName(userName);
  12. 			admin.setPwd(password);
  13. 			Admin admin1 = ls.selectAdmin(admin);
  14. 			  try {
  15. 					 if (admin1 == null){
  16. 			        	  request.setAttribute("message", "管理员用户不存在或者密码错误");
  17. 						  request.getRequestDispatcher("/WEB-INF/views/login.jsp").forward(request, response);
  18. 			         }else {
  19. 			        	  request.getSession().setAttribute("admin",admin1);
  20. 			        	  request.getSession().setAttribute("flag",1);
  21. 			              request.getRequestDispatcher("/WEB-INF/views/main.jsp").forward(request, response);
  22. 			         }				
  23. 				 } catch (Exception e) {
  24. 				 	e.printStackTrace();
  25. 				 }
  26. 		 }else if(type.equals("2")){
  27. 			 Student student = new Student();
  28. 			 student.setStno(userName);
  29. 			 student.setPwd(password);
  30. 			 Student student1 = ls.selectStudent(student);
  31. 			  try {
  32. 					 if (student1 == null){
  33. 			        	  request.setAttribute("message", "学号不存在或者密码错误");
  34. 						  request.getRequestDispatcher("/WEB-INF/views/login.jsp").forward(request, response);
  35. 			         }else {
  36. 			        	  request.getSession().setAttribute("student",student1);
  37. 			        	  request.getSession().setAttribute("flag",2);
  38. 			              request.getRequestDispatcher("/WEB-INF/views/main.jsp").forward(request, response);
  39. 			         }				
  40. 				 } catch (Exception e) {
  41. 				 	e.printStackTrace();
  42. 				 }
  43. 		 }else{
  44. 			    request.setAttribute("message", "工作人员手机号不存在或者密码错误");
  45. 			    try {
  46. 				request.getRequestDispatcher("/WEB-INF/views/login.jsp").forward(request, response);
  47. 				} catch (Exception e) {
  48. 					e.printStackTrace();
  49. 				} 
  50. 		 }
  51. 	}

注册代码

学生初始化注册自己的账号，填写form表单，提价后，后台进行插入的操作，注册成功后跳转登录页面

  1. <%@ page language="java" contentType="text/html; charset=utf-8"
  2. 	pageEncoding="utf-8"%>
  3. <%
  4. 	String path = request.getContextPath();
  5. 	String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort() + path + "/";
  6. %>
  7. <!DOCTYPE html>
  8. <html>
  9. 	<head>
  10. 		<meta charset="utf-8">
  11. 		<title>Login Page</title>
  12. 		<!-- 样 式 文 件 -->
  13. 		<link rel="stylesheet" href="resource/component/pear/css/pear.css" />
  14. 		<link rel="stylesheet" href="resource/admin/css/other/login.css" />
  15. 	</head>
  16.     <!-- 代 码 结 构 -->
  17. 	<body background="resource/admin/images/background.svg" style="background-size: cover;">
  18. 		<form class="layui-form" action="StudentServlet?action=addStudent" method="post"  id="loginForm" name="loginForm" >
  19. 			 <input id="te" type="hidden" name="te" value="1" />
  20. 			<div class="layui-form-item">
  21. 				<img class="logo" src="resource/admin/images/logo.png" />
  22. 				<div class="title">注&emsp;&emsp;册</div>
  23. 				<div class="desc">
  24. 					 图  书  管  理  系  统
  25. 				</div>
  26. 			</div>
  27. 			<div class="layui-form-item">
  28. 				<input type="text" placeholder="请输入姓名" name="name" id="name" hover class="layui-input"  />
  29. 				<span id="msg" style="color:red">${message}</span>
  30. 			</div>
  31. 			<div class="layui-form-item">
  32. 				<input id="stno" type="text" name="stno" placeholder="请输入学号" hover class="layui-input"  />
  33. 			</div>
  34. 			<div class="layui-form-item">
  35. 				<select name="sex" id ="sex">
  36. 				        <option value="">请选择性别</option>
  37. 				        <option value="男">男</option>
  38. 				        <option value="女">女</option>
  39. 				      </select>
  40. 			</div>
  41. 			 <div class="layui-form-item">
  42. 				<input id="classes" type="text" name="classes" placeholder="请输入班级" hover class="layui-input"  />
  43. 			</div>
  44. 			 <div class="layui-form-item">
  45. 				<input id="time" type="text" name="time" placeholder="请输入入学时间" hover class="layui-input"  />
  46. 			</div>
  47. 			 <div class="layui-form-item">
  48. 				<input id="phone" type="text" name="phone" placeholder="请输入手机号" hover class="layui-input"  />
  49. 			</div>
  50. 			 <div class="layui-form-item">
  51. 				<input id="pwd" type="text" name="pwd" placeholder="请输入登录密码" hover class="layui-input"  />
  52. 			</div>
  53. 			 <div class="layui-form-item">
  54. 				<input id="xy" type="text" name="xy" placeholder="请输入学院" hover class="layui-input"  />
  55. 			</div>
  56. 			<div class="layui-form-item">
  57. 				<button type="submit" class="pear-btn pear-btn-success login" id="login">
  58. 					注册
  59. 				</button>
  60. 			</div>
  61. 			 <div class="layui-form-item">
  62. 				<a href="LoginServlet?action=toLogin" class="pear-btn pear-btn-warming  layui-btn-fluid">返回</a>
  63. 			</div> 
  64. 		</form>
  65. 		<!-- 资 源 引 入 -->
  66. 		<script src="resource/component/layui/layui.js"></script>
  67. 		<script src="resource/component/pear/pear.js"></script>
  68. 		<script>
  69. 		layui.use(['layer', 'form','jquery','laydate'], function(){
  70. 			var form = layui.form,
  71. 			 layer = layui.layer,
  72. 			 laydate=layui.laydate,
  73. 			 $= layui.jquery;
  74. 			 form.render();//这句一定要加，占坑
  75. 		   
  76. 			 laydate.render({
  77. 				    elem: '#time'
  78. 				  });
  79. 		$("#login").on("click", function() {
  80. 			  var name = $("#name").val();
  81. 		        var sex = $("#sex").val();
  82. 		        var classes = $("#classes").val();
  83. 		        var time = $("#time").val();
  84. 		        var xy = $("#xy").val();
  85. 		        var phone = $("#phone").val();
  86. 		        var pwd = $("#pwd").val();
  87. 		        var stno = $("#stno").val();
  88. 		        if(sex == null || sex== ""){
  89. 		        	layer.msg('性别不能为空！');
  90. 		        	return false;
  91. 		        }
  92. 		        if(name == null || name== ""){
  93. 		        	layer.msg('姓名不能为空！');
  94. 		        	return false;
  95. 		        }
  96. 		        if(classes == null || classes== ""){
  97. 		        	layer.msg('班级不能为空！');
  98. 		        	return false;
  99. 		        }
  100. 		        if(time == null || time== ""){
  101. 		        	layer.msg('入学时间不能为空！');
  102. 		        	return false;
  103. 		        }
  104. 		        if(xy == null || xy== ""){
  105. 		        	layer.msg('学院不能为空！');
  106. 		        	return false;
  107. 		        }
  108. 		        if(phone == null || phone== ""){
  109. 		        	layer.msg('手机号不能为空！');
  110. 		        	return false;
  111. 		        }
  112. 		        if(pwd == null || pwd== ""){
  113. 		        	layer.msg('密码不能为空！');
  114. 		        	return false;
  115. 		        }
  116. 		        if(stno == null || stno== ""){
  117. 		        	layer.msg('学号不能为空！');
  118. 		        	return false;
  119. 		        }
  120. 		});
  121.  
  122. 		setTimeout(function(){ $("#msg").html("")},3000);
  123. 		setTimeout(function(){ $("#msg2").html("")},3000);
  124. 		setTimeout(function(){ $("#msg3").html("")},3000);
  125. 		});
  126. 		</script>
  127. 	</body>
  128. </html>
  1. 	/**
  2. 	 * 新增学生信息
  3. 	 * @param request
  4. 	 * @param response
  5. 	 */
  6. 	private void addStudent(HttpServletRequest request,
  7. 			HttpServletResponse response) {
  8. 		String te = request.getParameter("te");
  9. 		String name = request.getParameter("name");
  10. 		String sex = request.getParameter("sex");
  11. 		String classes = request.getParameter("classes");
  12. 		String time = request.getParameter("time");
  13. 		String xy = request.getParameter("xy");
  14. 		String phone = request.getParameter("phone");
  15. 		String pwd = request.getParameter("pwd");
  16. 		String stno = request.getParameter("stno");
  17. 		Student stu = new Student();
  18. 		stu.setClasses(classes);
  19. 		stu.setName(name);
  20. 		stu.setPhone(phone);
  21. 		stu.setPwd(pwd);
  22. 		stu.setSex(sex);
  23. 		stu.setState("1");
  24. 		stu.setStno(stno);
  25. 		stu.setTime(time);
  26. 		stu.setXy(xy);
  27. 		Student student = ss.selectStudentByPhone(phone);
  28. 		Student student1 = ss.selectStudentByStuNo(stno);
  29. 		if(te == null || te.equals("")){
  30. 			if(student != null){
  31. 				request.setAttribute("message", "电话号码重复！");
  32. 				try {
  33. 					request.getRequestDispatcher("/WEB-INF/views/student/addStudent.jsp").forward(request,response);
  34. 				} catch (Exception e) {
  35. 					e.printStackTrace();
  36. 				}
  37. 			}else if(student1 != null){
  38. 				request.setAttribute("message", "学号重复！");
  39. 				try {
  40. 					request.getRequestDispatcher("/WEB-INF/views/student/addStudent.jsp").forward(request,response);
  41. 				} catch (Exception e) {
  42. 					e.printStackTrace();
  43. 				}
  44. 			}else{
  45. 				try {
  46. 					ss.saveStudent(stu);
  47. 		 			response.sendRedirect(request.getContextPath()+"/StudentServlet?action=studentList");
  48. 				} catch (Exception e) {
  49. 					e.printStackTrace();
  50. 				}
  51. 			}
  52. 			
  53. 		}else{
  54. 			if(student != null){
  55. 				request.setAttribute("message", "电话号码重复！");
  56. 				try {
  57. 					request.getRequestDispatcher("/WEB-INF/views/register.jsp").forward(request,response);
  58. 				} catch (Exception e) {
  59. 					e.printStackTrace();
  60. 				}
  61. 			}else if(student1 != null){
  62. 				request.setAttribute("message", "学号重复！");
  63. 				try {
  64. 					request.getRequestDispatcher("/WEB-INF/views/register.jsp").forward(request,response);
  65. 				} catch (Exception e) {
  66. 					e.printStackTrace();
  67. 				}
  68. 			}else{
  69. 				try {
  70. 					ss.saveStudent(stu);
  71. 		 			response.sendRedirect(request.getContextPath()+"/LoginServlet?action=toLogin");
  72. 				} catch (Exception e) {
  73. 					e.printStackTrace();
  74. 				}
  75. 			}
  76. 			
  77. 		}
  78. 		
  79. 	}

学生列表代码

后台分页查询所有学生的信息，返回到studentList.jsp中，进行遍历展示

  1.  
  2. 	/**
  3. 	 * 分页查询学生
  4. 	 * @param request
  5. 	 * @param response
  6. 	 */
  7. 	private void studentList(HttpServletRequest request,
  8. 			HttpServletResponse response) {
  9. 		String p=request.getParameter("p");//接收页码
  10.         int pageSize=4;//每页显示5条
  11.         int pageNum=1; //默认第一页
  12.         if(p!=null){
  13.             pageNum= Integer.parseInt(p);
  14.         }
  15.         //调用分页查询
  16.         List<Student> list=ss.getstudentListPage(pageNum,pageSize);
  17.         //携带参数到页面
  18.         int nums=ss.queryStudentCount(); //查询总数
  19.         //计算总页数
  20.         int totalPage=(nums%pageSize==0)? (nums/pageSize):(nums/pageSize+1);
  21.         request.setAttribute("cp",pageNum); //当前页
  22.         request.setAttribute("tp",totalPage); //总页数
  23. 		try {
  24.          request.removeAttribute("msg");
  25.          request.setAttribute("list" ,list);
  26.            request.getRequestDispatcher("/WEB-INF/views/student/studentList.jsp").forward(request, response);
  27. 		} catch (Exception e) {
  28. 			e.printStackTrace();
  29. 		}
  30. 	}
  1. <%@ page language="java" contentType="text/html; charset=utf-8"
  2. 	pageEncoding="utf-8"%>
  3. <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
  4. <%
  5. 	String path = request.getContextPath();
  6. 	String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort()
  7. 			+ path + "/";
  8. %>
  9. <jsp:include page="/WEB-INF/common/form_header.jsp"/>
  10.  
  11. <body>
  12.  
  13. 	<div class="layui-col-md12">
  14. 		<div class="layui-card">
  15. 			<div class="layui-card-header">学生列表</div>
  16. 			<div class="layui-card-body">
  17. 				<form action="StudentServlet?action=studentListLike" method="post">
  18. 					 <div class="layui-form-item">
  19. 						    <div class="layui-inline">
  20. 						      <div class="layui-input-inline">
  21. 						       		<input type="text" placeholder="根据入学年份查询" name="time" id ="time" class="layui-input"  />
  22. 						      </div>
  23. 						        <div class="layui-input-inline">
  24. 						       		<input type="text" placeholder="根据入学生姓名查询" name="names" id ="names" class="layui-input"  />
  25. 						      </div>
  26. 						    </div>
  27. 						    <div class="layui-inline">
  28. 						      <button type="submit" class="layui-btn layui-btn-sm layui-btn-normal">查询</button>
  29. 						       <a href="StudentServlet?action=toAddStudent"
  30. 					class="layui-btn layui-btn-sm layui-btn-normal">新增学生</a>
  31. 						  </div>
  32. 						  </div>
  33. 					
  34. 					<%-- </c:if> --%>
  35. 		           </form>   
  36. 				<table class="layui-table">
  37. 					<thead>
  38. 						<tr>
  39. 						    <th>姓名</th>
  40. 							<th>性别</th>
  41. 							<th>班级</th>
  42. 							<th>入学时间</th>
  43. 							<th>学院</th>
  44. 							<!-- <th>能否借阅书籍</th> -->
  45. 							<th>手机号</th>
  46. 							<th>密码</th>
  47. 							<th>学号</th>
  48. 							<c:if test="${flag == 1}">
  49. 								<th>操作</th>
  50. 							</c:if>
  51. 						</tr>
  52. 					</thead>
  53. 					<tbody>
  54. 						<c:forEach items="${list}" var="u">
  55. 							<tr>
  56. 							    <td>${u.name }</td>
  57. 								<td>${u.sex }</td>
  58. 								<td>${u.classes }</td>
  59. 								<td>${u.time }</td>
  60. 								<td>${u.xy }</td>
  61. 								<%-- <td>
  62. 								<c:if test="${u.state == '1'}">
  63. 								  <span style="color:green">能</span>
  64. 								</c:if>
  65. 								
  66. 								<c:if test="${u.state == '2'}">
  67. 								  <span style="color:red">不能</span>
  68. 								</c:if>
  69.                                </td> --%>
  70. 								<td>${u.phone }</td>
  71. 								<td>${u.pwd }</td>
  72. 								<td>${u.stno }</td>
  73. 								<c:if test="${flag == 1}">
  74. 								<td>  
  75. 									<input id ="${u.id}" value="${u.id}" type="hidden" class="weui-input"/>
  76. 								
  77. 								<a href="StudentServlet?action=toUpdateStudent&id=${u.id}" id="update"
  78. 									class="layui-btn layui-btn-sm layui-btn-norma"><i
  79. 										class="layui-icon">修改</i></a>
  80. 								 <a  href='javascript:void(0)' class="layui-btn layui-btn-sm layui-btn-danger"><i
  81. 										class="layui-icon">删除</i></a>
  82. 								<%-- <a href="StudentServlet?action=deleteStudent&id=${u.id}" id="delete"
  83. 									class="layui-btn layui-btn-sm layui-btn-danger"><i
  84. 										class="layui-icon">删除</i></a> --%>
  85. 										</td>
  86. 								</c:if> 
  87. 							</tr>
  88. 						</c:forEach>
  89. 					</tbody>
  90. 				</table>
  91.                <div style="text-align: center">
  92. 					<div class="layui-btn-group">
  93. 						<a class="layui-btn layui-btn-primary"
  94. 							href="StudentServlet?action=studentList&p=1">首页</a>
  95. 						<%--        判断是否有上一页--%>
  96. 						<c:if test="${cp>1}">
  97. 							<a class="layui-btn layui-btn-primary"
  98. 								href="StudentServlet?action=studentList&p=${cp-1}">上一页</a>
  99. 						</c:if>
  100. 						<%--        循环显示页码--%>
  101. 						<c:forEach begin="${cp-2>1 ? (cp-2) :1}"
  102. 							end="${cp+2>tp?tp:(cp+2)}" var="e">
  103. 							<%--            判断是否是当前页--%>
  104. 							<c:if test="${cp==e}">
  105. 								<a class="layui-btn layui-btn-danger"
  106. 									href="StudentServlet?action=studentList&p=${e}">${e}</a>
  107. 							</c:if>
  108. 							<c:if test="${cp!=e}">
  109. 								<a class="layui-btn layui-btn-primary"
  110. 									href="StudentServlet?action=studentList&p=${e}">${e}</a>
  111. 							</c:if>
  112.  
  113. 						</c:forEach>
  114.  
  115. 						<%--        判断是否有下一页--%>
  116. 						<c:if test="${cp<tp}">
  117. 							<a class="layui-btn  layui-btn-primary"
  118. 								href="StudentServlet?action=studentList&p=${cp+1}">下一页</a>
  119. 						</c:if>
  120. 						<a class="layui-btn  layui-btn-primary"
  121. 							href="StudentServlet?action=studentList&p=${tp}">尾页</a> <a
  122. 							clss="layui-btn" href="StudentServlet?action=studentList&p=2">2</a>
  123. 						<a clss="layui-btn" href="StudentServlet?action=studentList&p=3">3</a>
  124. 						<a clss="layui-btn" href="StudentServlet?action=studentList&p=4">4</a>
  125. 					</div>
  126. 				</div>
  127.  
  128. 			</div>
  129. 		</div>
  130. 	</div>
  131.  
  132. 	<script src="layui/layui.js"></script>
  133. <script src="layui/jquery-1.9.1.min.js"></script>
  134. 	<script type="application/javascript">
  135.  
  136. layui.use([ 'form','jquery','layer','laydate' ], function() {
  137. 	var form = layui.form,
  138. 	 layer = layui.layer,
  139. 	 laydate=layui.laydate,
  140. 	 $= layui.jquery;
  141. 	 form.render();//这句一定要加，占坑
  142. 	 
  143. 	 
  144. 	 $('a.layui-btn-danger').click(function(e){
  145. 	   		            var id = $(e.currentTarget).parent().find('.weui-input').attr('id');
  146. 				   		if(confirm("确定要删除吗？")){
  147. 				   		  $.post("StudentServlet?action=deleteStudent&id="+id, function(data) {
  148. 				   			   layer.msg('删除成功！',{icon:6,offset:"auto",time:2000},function(){
  149. 							    	document.location.reload();//当前页面
  150. 							    });
  151. 				   		   }); 
  152. 				   	}
  153. 	   		})
  154. 	 
  155. 	 laydate.render({
  156. 		    elem: '#time'
  157. 		    ,type: 'year'
  158. 	});
  159.  
  160. });
  161.  
  162. </script>
  163.  
  164. </body>
  165. </html>

新增学生代码

点击新增按钮跳转addStudent.jsp页面，用户填写相关信息后提交代码到studentservlet里面，进行插入操作后返回页面，遍历展示信息

  1.  
  2. <%@ page language="java" contentType="text/html; charset=utf-8"
  3.     pageEncoding="utf-8"%>
  4.      <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
  5.       <%
  6. 	String path = request.getContextPath();
  7. 	String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort()
  8. 			+ path + "/";
  9. %>
  10. <jsp:include page="/WEB-INF/common/form_header.jsp"/>
  11. <body>
  12.  
  13.  
  14.   <div class="layui-fluid">
  15.     <div class="layui-row layui-col-space15">
  16.       <div class="layui-col-md12">
  17.         <div class="layui-card">
  18.           <div class="layui-card-header">新增学生</div>
  19.           <div class="layui-card-body">
  20.              <form action="StudentServlet?action=addStudent" method="post" id="registerForm" name="registerForm" >
  21.               <div class="layui-form-item">
  22.                 <label class="layui-form-label">姓名:</label>
  23.                 <div class="layui-input-inline">
  24. 				<input name="name" id="name" class="layui-input" /> 
  25. 				  <span id="msg3" style="color:red">${message}</span>
  26.                 </div>
  27.               </div>
  28.               
  29.                 <div class="layui-form-item">
  30.                 <label class="layui-form-label">学号:</label>
  31.                 <div class="layui-input-inline">
  32. 				<input name="stno" id="stno" class="layui-input" /> 
  33.                 </div>
  34.               </div>
  35.               
  36.               <div class="layui-form-item">
  37. 	               <label class="layui-form-label">性别:</label>
  38. 	                    <select name="sex" id ="sex" style="width:13%;height:38px">
  39. 				        <option value="">请选择性别</option>
  40. 				        <option value="男">男</option>
  41. 				        <option value="女">女</option>
  42. 				      </select>
  43.               </div>
  44.               
  45.               <div class="layui-form-item">
  46.                 <label class="layui-form-label">班级:</label>
  47.                 <div class="layui-input-inline">
  48. 				<input name="classes" id="classes" class="layui-input" /> 
  49.                 </div>
  50.               </div>
  51.               
  52.                <div class="layui-form-item">
  53.                 <label class="layui-form-label">入学时间:</label>
  54.                 <div class="layui-input-inline">
  55. 				<input name="time" id="time" class="layui-input" /> 
  56.                 </div>
  57.               </div>
  58.               
  59.                <div class="layui-form-item">
  60.                 <label class="layui-form-label">手机号:</label>
  61.                 <div class="layui-input-inline">
  62. 				<input name="phone" id="phone" class="layui-input" /> 
  63.                 </div>
  64.               </div>
  65.               
  66.                <div class="layui-form-item">
  67.                 <label class="layui-form-label">登录密码:</label>
  68.                 <div class="layui-input-inline">
  69. 				<input name="pwd" id="pwd" class="layui-input" /> 
  70.                 </div>
  71.               </div>
  72.               
  73.                <div class="layui-form-item">
  74.                 <label class="layui-form-label">学院:</label>
  75.                 <div class="layui-input-inline">
  76. 				<input name="xy" id="xy" class="layui-input" /> 
  77.                 </div>
  78.               </div>
  79.               
  80.               
  81.               <br>
  82.                 <div class="layui-form-item">
  83.                 <div class="layui-input-block">
  84.                   <button class="layui-btn" type="submit" id="sub_btn">提交</button>
  85.                   <a href="StudentServlet?action=studentList" class="layui-btn layui-btn-primary" >返回</a>
  86.                 </div>
  87.               </div>  
  88.               </form>
  89.             </div>
  90.             
  91.           </div>
  92.         </div>
  93.       </div>
  94.     </div>
  95. 		
  96.  
  97. <script src="layui/layui.js"></script>
  98. <script src="layui/jquery-1.9.1.min.js"></script>
  99. <script>
  100.  
  101. layui.use([ 'form','jquery','layer','laydate' ], function() {
  102. 	var form = layui.form,
  103. 	 layer = layui.layer,
  104. 	 laydate=layui.laydate,
  105. 	 $= layui.jquery;
  106. 	 form.render();//这句一定要加，占坑
  107. 	 
  108. 	 laydate.render({
  109. 		    elem: '#time'
  110. 		  });
  111. 	 
  112. 	 $(function () {
  113. 		    // 给注册绑定单击事件i
  114. 		    $("#sub_btn").click(function () {
  115. 		        var name = $("#name").val();
  116. 		        var sex = $("#sex").val();
  117. 		        var classes = $("#classes").val();
  118. 		        var time = $("#time").val();
  119. 		        var xy = $("#xy").val();
  120. 		        var phone = $("#phone").val();
  121. 		        var pwd = $("#pwd").val();
  122. 		        var stno = $("#stno").val();
  123. 		        if(sex == null || sex== ""){
  124. 		        	layer.msg('性别不能为空！');
  125. 		        	return false;
  126. 		        }
  127. 		        if(name == null || name== ""){
  128. 		        	layer.msg('姓名不能为空！');
  129. 		        	return false;
  130. 		        }
  131. 		        if(classes == null || classes== ""){
  132. 		        	layer.msg('班级不能为空！');
  133. 		        	return false;
  134. 		        }
  135. 		        if(time == null || time== ""){
  136. 		        	layer.msg('入学时间不能为空！');
  137. 		        	return false;
  138. 		        }
  139. 		        if(xy == null || xy== ""){
  140. 		        	layer.msg('学院不能为空！');
  141. 		        	return false;
  142. 		        }
  143. 		        if(phone == null || phone== ""){
  144. 		        	layer.msg('手机号不能为空！');
  145. 		        	return false;
  146. 		        }
  147. 		        if(pwd == null || pwd== ""){
  148. 		        	layer.msg('密码不能为空！');
  149. 		        	return false;
  150. 		        }
  151. 		        if(stno == null || stno== ""){
  152. 		        	layer.msg('学号不能为空！');
  153. 		        	return false;
  154. 		        }
  155. 		    });
  156. 		    setTimeout(function(){ $("#errorMsg").html("")},3000);
  157. 	});
  158. 	 setTimeout(function(){ $("#msg3").html("")},3000);
  159.  
  160. });
  161. </script>
  162. </body>
  163. </html>
  1. /**
  2. 	 * 新增学生信息
  3. 	 * @param request
  4. 	 * @param response
  5. 	 */
  6. 	private void addStudent(HttpServletRequest request,
  7. 			HttpServletResponse response) {
  8. 		String te = request.getParameter("te");
  9. 		String name = request.getParameter("name");
  10. 		String sex = request.getParameter("sex");
  11. 		String classes = request.getParameter("classes");
  12. 		String time = request.getParameter("time");
  13. 		String xy = request.getParameter("xy");
  14. 		String phone = request.getParameter("phone");
  15. 		String pwd = request.getParameter("pwd");
  16. 		String stno = request.getParameter("stno");
  17. 		Student stu = new Student();
  18. 		stu.setClasses(classes);
  19. 		stu.setName(name);
  20. 		stu.setPhone(phone);
  21. 		stu.setPwd(pwd);
  22. 		stu.setSex(sex);
  23. 		stu.setState("1");
  24. 		stu.setStno(stno);
  25. 		stu.setTime(time);
  26. 		stu.setXy(xy);
  27. 		Student student = ss.selectStudentByPhone(phone);
  28. 		Student student1 = ss.selectStudentByStuNo(stno);
  29. 		if(te == null || te.equals("")){
  30. 			if(student != null){
  31. 				request.setAttribute("message", "电话号码重复！");
  32. 				try {
  33. 					request.getRequestDispatcher("/WEB-INF/views/student/addStudent.jsp").forward(request,response);
  34. 				} catch (Exception e) {
  35. 					e.printStackTrace();
  36. 				}
  37. 			}else if(student1 != null){
  38. 				request.setAttribute("message", "学号重复！");
  39. 				try {
  40. 					request.getRequestDispatcher("/WEB-INF/views/student/addStudent.jsp").forward(request,response);
  41. 				} catch (Exception e) {
  42. 					e.printStackTrace();
  43. 				}
  44. 			}else{
  45. 				try {
  46. 					ss.saveStudent(stu);
  47. 		 			response.sendRedirect(request.getContextPath()+"/StudentServlet?action=studentList");
  48. 				} catch (Exception e) {
  49. 					e.printStackTrace();
  50. 				}
  51. 			}
  52. 			
  53. 		}else{
  54. 			if(student != null){
  55. 				request.setAttribute("message", "电话号码重复！");
  56. 				try {
  57. 					request.getRequestDispatcher("/WEB-INF/views/register.jsp").forward(request,response);
  58. 				} catch (Exception e) {
  59. 					e.printStackTrace();
  60. 				}
  61. 			}else if(student1 != null){
  62. 				request.setAttribute("message", "学号重复！");
  63. 				try {
  64. 					request.getRequestDispatcher("/WEB-INF/views/register.jsp").forward(request,response);
  65. 				} catch (Exception e) {
  66. 					e.printStackTrace();
  67. 				}
  68. 			}else{
  69. 				try {
  70. 					ss.saveStudent(stu);
  71. 		 			response.sendRedirect(request.getContextPath()+"/LoginServlet?action=toLogin");
  72. 				} catch (Exception e) {
  73. 					e.printStackTrace();
  74. 				}
  75. 			}
  76. 			
  77. 		}
  78. 		
  79. 	}

修改学生代码

页面点击修改按钮，跳转到修改的页面，用户修改制定内容后提交代码，执行action里面的servlet路径，serlvet执行相关代码后，返回到前端展示数据！！！！！

  1.  
  2. <%@ page language="java" contentType="text/html; charset=utf-8"
  3.     pageEncoding="utf-8"%>
  4.      <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
  5.       <%
  6. 	String path = request.getContextPath();
  7. 	String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort()
  8. 			+ path + "/";
  9. %>
  10. <jsp:include page="/WEB-INF/common/form_header.jsp"/>
  11. <body>
  12.   <div class="layui-fluid">
  13.     <div class="layui-row layui-col-space15">
  14.       <div class="layui-col-md12">
  15.         <div class="layui-card">
  16.           <div class="layui-card-header">修改学生</div>
  17.           <div class="layui-card-body">
  18.              <form action="StudentServlet?action=updateStudent" method="post" id="registerForm" name="registerForm" >
  19.               <input name="sid" id="sid" value="${student.id }" type="hidden" class="layui-input" /> 
  20.               <div class="layui-form-item">
  21.                 <label class="layui-form-label">姓名:</label>
  22.                 <div class="layui-input-inline">
  23. 				<input name="name" id="name" value="${student.name }"  class="layui-input" /> 
  24. 				  <span id="msg3" style="color:red">${message}</span>
  25.                 </div>
  26.               </div>
  27.               
  28.                 <div class="layui-form-item">
  29.                 <label class="layui-form-label">学号:</label>
  30.                 <div class="layui-input-inline">
  31. 				<input name="stno" id="stno" value="${student.stno }" class="layui-input" /> 
  32.                 </div>
  33.               </div>
  34.               
  35.               <div class="layui-form-item">
  36. 	               <label class="layui-form-label">性别:</label>
  37. 	                    <select name="sex" id ="sex" style="width:13%;height:38px">
  38. 				        <option value="">请选择性别</option>
  39. 				        <c:if test="${student.sex == '男' }">
  40. 					         <option value="男" selected>男</option>
  41. 					        <option value="女">女</option>
  42. 				        </c:if>
  43. 				       <c:if test="${student.sex == '女' }">
  44. 					         <option value="男" >男</option>
  45. 					        <option value="女" selected>女</option>
  46. 				        </c:if>
  47. 				      </select>
  48.               </div>
  49.               
  50.               <div class="layui-form-item">
  51.                 <label class="layui-form-label">班级:</label>
  52.                 <div class="layui-input-inline">
  53. 				<input name="classes" id="classes" value="${student.classes }" class="layui-input" /> 
  54.                 </div>
  55.               </div>
  56.               
  57.                <div class="layui-form-item">
  58.                 <label class="layui-form-label">学院:</label>
  59.                 <div class="layui-input-inline">
  60. 				<input name="xy" id="xy" value="${student.xy }" class="layui-input" /> 
  61.                 </div>
  62.               </div>
  63.               
  64.                <div class="layui-form-item">
  65.                 <label class="layui-form-label">入学时间:</label>
  66.                 <div class="layui-input-inline">
  67. 				<input name="time" id="time" value="${student.time }" class="layui-input" /> 
  68.                 </div>
  69.               </div>
  70.               
  71.                <div class="layui-form-item">
  72.                 <label class="layui-form-label">手机号:</label>
  73.                 <div class="layui-input-inline">
  74. 				<input name="phone" id="phone" value="${student.phone }" class="layui-input" /> 
  75.                 </div>
  76.               </div>
  77.               
  78.                <div class="layui-form-item">
  79.                 <label class="layui-form-label">登录密码:</label>
  80.                 <div class="layui-input-inline">
  81. 				<input name="pwd" id="pwd" value="${student.pwd }" class="layui-input" /> 
  82.                 </div>
  83.               </div>
  84.               
  85.               <br>
  86.                 <div class="layui-form-item">
  87.                 <div class="layui-input-block">
  88.                   <button class="layui-btn" type="submit" id="sub_btn">提交</button>
  89.                   <c:if test="${flag == 1 }">
  90.                     <a href="StudentServlet?action=studentList" class="layui-btn layui-btn-primary" >返回</a>
  91.                   </c:if>
  92.                   <c:if test="${flag == 2 }">
  93.                      <a href="StudentServlet?action=toUpdateStudent&id=${student.id }" class="layui-btn layui-btn-primary" >重置</a>
  94.                   </c:if>
  95.                  
  96.                 </div>
  97.               </div>  
  98.               </form>
  99.             </div>
  100.             
  101.           </div>
  102.         </div>
  103.       </div>
  104.     </div>
  105. 		
  106.  
  107. <script src="layui/layui.js"></script>
  108. <script src="layui/jquery-1.9.1.min.js"></script>
  109. <script>
  110.  
  111. layui.use([ 'form','jquery','layer','laydate' ], function() {
  112. 	var form = layui.form,
  113. 	 layer = layui.layer,
  114. 	 laydate=layui.laydate,
  115. 	 $= layui.jquery;
  116. 	 form.render();//这句一定要加，占坑
  117. 	 
  118. 	 laydate.render({
  119. 		    elem: '#time'
  120. 		  });
  121. 	 
  122. 	 $(function () {
  123. 		    // 给注册绑定单击事件
  124. 		      $("#sub_btn").click(function () {
  125. 		        var name = $("#name").val();
  126. 		        var sex = $("#sex").val();
  127. 		        var classes = $("#classes").val();
  128. 		        var time = $("#time").val();
  129. 		        var xy = $("#xy").val();
  130. 		        var phone = $("#phone").val();
  131. 		        var pwd = $("#pwd").val();
  132. 		        var stno = $("#stno").val();
  133. 		        if(sex == null || sex== ""){
  134. 		        	layer.msg('性别不能为空！');
  135. 		        	return false;
  136. 		        }
  137. 		        if(name == null || name== ""){
  138. 		        	layer.msg('姓名不能为空！');
  139. 		        	return false;
  140. 		        }
  141. 		        if(classes == null || classes== ""){
  142. 		        	layer.msg('班级不能为空！');
  143. 		        	return false;
  144. 		        }
  145. 		        if(time == null || time== ""){
  146. 		        	layer.msg('入学时间不能为空！');
  147. 		        	return false;
  148. 		        }
  149. 		        if(xy == null || xy== ""){
  150. 		        	layer.msg('学院不能为空！');
  151. 		        	return false;
  152. 		        }
  153. 		        if(phone == null || phone== ""){
  154. 		        	layer.msg('手机号不能为空！');
  155. 		        	return false;
  156. 		        }
  157. 		        if(pwd == null || pwd== ""){
  158. 		        	layer.msg('密码不能为空！');
  159. 		        	return false;
  160. 		        }
  161. 		        if(stno == null || stno== ""){
  162. 		        	layer.msg('学号不能为空！');
  163. 		        	return false;
  164. 		        }
  165. 		    });
  166. 		    setTimeout(function(){ $("#errorMsg").html("")},3000);
  167. 	});
  168. 	 setTimeout(function(){ $("#msg3").html("")},3000);
  169.  
  170. });
  171. </script>
  172. </body>
  173. </html>
  1.  
  2. 	/**
  3. 	 * 修改学生信息
  4. 	 * @param request
  5. 	 * @param response
  6. 	 */
  7. 	private void updateStudent(HttpServletRequest request,
  8. 			HttpServletResponse response) {
  9. 		Object flag = request.getSession().getAttribute("flag");
  10. 		String sid = request.getParameter("sid");
  11. 		String name = request.getParameter("name");
  12. 		String sex = request.getParameter("sex");
  13. 		String classes = request.getParameter("classes");
  14. 		String time = request.getParameter("time");
  15. 		String xy = request.getParameter("xy");
  16. 		String phone = request.getParameter("phone");
  17. 		String pwd = request.getParameter("pwd");
  18. 		String stno = request.getParameter("stno");
  19. 		Student stu = new Student();
  20. 		stu.setClasses(classes);
  21. 		stu.setName(name);
  22. 		stu.setPhone(phone);
  23. 		stu.setPwd(pwd);
  24. 		stu.setSex(sex);
  25. 		stu.setStno(stno);
  26. 		stu.setTime(time);
  27. 		stu.setXy(xy);
  28. 		stu.setId(Integer.parseInt(sid));
  29. 		try {
  30. 			ss.updateStudent(stu);
  31. 			if(flag != null && flag.toString().equals("1")){
  32. 				response.sendRedirect(request.getContextPath()+"/StudentServlet?action=studentList");
  33. 			}else{
  34. 				response.sendRedirect(request.getContextPath()+"/StudentServlet?action=toUpdateStudent&id="+sid);
  35. 			}
  36.  			
  37. 		} catch (Exception e) {
  38. 			e.printStackTrace();
  39. 		}
  40. 	}

其他模块代码都是类似的，此项目适合初学者学习借鉴，项目整体比较简单！！！！！！！

喜欢的朋友的点赞加关注，感兴趣的同学可以研究！！！！！

感谢  = v =

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

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

  

闽ICP备14008679号