• Java项目：JSP实现的图书管理系统

    作者主页：夜未央5788

     简介：Java领域优质创作者、Java项目、学习资料、技术互助

    文末获取源码

    项目介绍

    本项目为后台管理项目；

    管理员角色包含以下功能：

    管理员登录,系统设置,管理员管理,办证费用管理,书架管理,读者类型管理,读者管理,图书管理,图书类型管理,图书借阅,图书归还,图书续借,图书查询等功能。

    环境需要

    1.运行环境：最好是java jdk 1.8，我们在这个平台上运行的。其他版本理论上也可以。
    2.IDE环境：IDEA，Eclipse,Myeclipse都可以。推荐IDEA;
    3.tomcat环境：Tomcat 7.x,8.x,9.x版本均可
    4.硬件环境：windows 7/8/10 1G内存以上；或者 Mac OS； 

    5.数据库：MySql 5.7版本；

    6.是否Maven项目：否；

    技术栈

    JSP+CSS+JavaScript+mysql+servlet

    使用说明

    1. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件；
    2. 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven;
    若为maven项目，导入成功后请执行maven clean;maven install命令，然后运行；
    3. 将项目中connDB.properties及core/ConnDB.java配置文件中的数据库配置改为自己的配置;
    4. 运行项目，输入http://localhost:8080/jsp_online_library_sys/ 登录 注：Tomcat中配置项目路径必须为jsp_online_library_sys，否则会有问题；

    管理员账号/密码：admin/111

    运行截图

     

     

     

     

     

     

     

     

     

    相关代码 

    Book

    1. package com.action;
    2.  
    3. import javax.servlet.ServletException;
    4. import javax.servlet.http.HttpServlet;
    5. import javax.servlet.http.HttpServletRequest;
    6. import javax.servlet.http.HttpServletResponse;
    7. import com.actionForm.BookForm;
    8. import com.dao.BookDAO;
    9.  
    10. import java.io.IOException;
    11. import java.util.Date;
    12.  
    13. public class Book extends HttpServlet {
    14. 	private BookDAO bookDAO = null;
    15.  
    16. 	public Book() {
    17. 		this.bookDAO = new BookDAO();
    18. 	}
    19.  
    20. 	public void doGet(HttpServletRequest request, HttpServletResponse response)
    21. 			throws ServletException, IOException {
    22. 		String action = request.getParameter("action");
    23. 		System.out.println("\nbook*********************action=" + action);
    24. 		if (action == null || "".equals(action)) {
    25. 			request.setAttribute("error", "您的操作有误！");
    26. 			request.getRequestDispatcher("error.jsp")
    27. 					.forward(request, response);
    28. 		} else if ("bookAdd".equals(action)) {
    29. 			bookAdd(request, response);
    30. 		} else if ("bookQuery".equals(action)) {
    31. 			bookQuery(request, response);
    32. 		} else if ("bookModifyQuery".equals(action)) {
    33. 			bookModifyQuery(request, response);
    34. 		} else if ("bookModify".equals(action)) {
    35. 			bookModify(request, response);
    36. 		} else if ("bookDel".equals(action)) {
    37. 			bookDel(request, response);
    38. 		} else if ("bookDetail".equals(action)) {
    39. 			bookDetail(request, response);
    40. 		} else if ("bookifQuery".equals(action)) {
    41. 			bookifQuery(request, response);
    42. 		}
    43. 	}
    44.  
    45. 	/*********************** 添加图书信息 **************************/
    46. 	private void bookAdd(HttpServletRequest request,
    47. 			HttpServletResponse response) throws ServletException, IOException {
    48. 		BookForm bookForm = new BookForm();
    49. 		bookForm.setBarcode(request.getParameter("barcode"));
    50. 		bookForm.setBookName(request.getParameter("bookName"));
    51. 		bookForm.setTypeId(Integer.parseInt(request.getParameter("typeId")));
    52. 		bookForm.setAuthor(request.getParameter("author"));
    53. 		bookForm.setTranslator(request.getParameter("translator"));
    54. 		bookForm.setIsbn(request.getParameter("isbn"));
    55. 		bookForm.setPrice(Float.valueOf(request.getParameter("price")));
    56. 		bookForm.setPage(request.getParameter("page") == "" ? 0 : Integer
    57. 				.parseInt(request.getParameter("page")));
    58. 		bookForm.setBookcaseid(Integer.parseInt(request
    59. 				.getParameter("bookcaseid")));
    60. 		// 获取系统日期
    61. 		Date date1 = new Date();
    62. 		java.sql.Date date = new java.sql.Date(date1.getTime());
    63. 		bookForm.setInTime(date.toString());
    64. 		bookForm.setOperator(request.getParameter("operator"));
    65. 		int a = bookDAO.insert(bookForm);
    66. 		if (a == 1) {
    67. 			request.getRequestDispatcher("book_ok.jsp?para=1").forward(request,
    68. 					response);
    69. 		} else if (a == 2) {
    70. 			request.setAttribute("error", "该图书信息已经添加！");
    71. 			request.getRequestDispatcher("error.jsp")
    72. 					.forward(request, response);
    73. 		} else {
    74. 			request.setAttribute("error", "图书信息添加失败！");
    75. 			request.getRequestDispatcher("error.jsp")
    76. 					.forward(request, response);
    77. 		}
    78. 	}
    79.  
    80. 	/*********************** 查询全部图书信息 **************************/
    81. 	private void bookQuery(HttpServletRequest request,
    82. 			HttpServletResponse response) throws ServletException, IOException {
    83. 		String str = null;
    84. 		request.setAttribute("book", bookDAO.query(str)); // 将查询结果保存到book中
    85. 		request.getRequestDispatcher("book.jsp").forward(request, response);
    86. 	}
    87.  
    88. 	/*********************** 条件查询图书信息 **************************/
    89. 	private void bookifQuery(HttpServletRequest request,
    90. 			HttpServletResponse response) throws ServletException, IOException {
    91. 		String str = null;
    92. 		if (request.getParameter("f") != null) {
    93. 			str = request.getParameter("f") + " like '%"
    94. 					+ request.getParameter("key") + "%";
    95. 		}
    96. 		request.setAttribute("ifbook", bookDAO.query(str));
    97. 		System.out.print("条件查询图书信息时的str:" + str);
    98. 		request.getRequestDispatcher("bookQuery.jsp")
    99. 				.forward(request, response);
    100. 	}
    101.  
    102. 	/*********************** 查询修改图书信息 **************************/
    103. 	private void bookModifyQuery(HttpServletRequest request,
    104. 			HttpServletResponse response) throws ServletException, IOException {
    105. 		BookForm bookForm = new BookForm();
    106. 		System.out.println("查询修改图书信息：" + request.getParameter("ID"));
    107. 		bookForm.setId(Integer.valueOf(request.getParameter("ID")));
    108. 		request.setAttribute("bookQueryif", bookDAO.queryM(bookForm));
    109. 		request.getRequestDispatcher("book_Modify.jsp").forward(request,
    110. 				response);
    111. 	}
    112.  
    113. 	/*********************** 查询图书详细信息 **************************/
    114. 	private void bookDetail(HttpServletRequest request,
    115. 			HttpServletResponse response) throws ServletException, IOException {
    116. 		BookForm bookForm = new BookForm();
    117. 		bookForm.setId(Integer.valueOf(request.getParameter("ID")));
    118. 		request.setAttribute("bookDetail", bookDAO.queryM(bookForm));
    119. 		request.getRequestDispatcher("book_detail.jsp").forward(request,
    120. 				response);
    121. 	}
    122.  
    123. 	/*********************** 修改图书信息 **************************/
    124. 	private void bookModify(HttpServletRequest request,
    125. 			HttpServletResponse response) throws ServletException, IOException {
    126. 		BookForm bookForm = new BookForm(); // 实例化BookForm类
    127. 		bookForm.setId(Integer.parseInt(request.getParameter("id")));
    128. 		bookForm.setBarcode(request.getParameter("barcode")); // 获取并设置条形码属性
    129. 		bookForm.setBookName(request.getParameter("bookName"));
    130. 		bookForm.setTypeId(Integer.parseInt(request.getParameter("typeId")));
    131. 		bookForm.setAuthor(request.getParameter("author"));
    132. 		bookForm.setTranslator(request.getParameter("translator"));
    133. 		bookForm.setIsbn(request.getParameter("isbn"));
    134. 		bookForm.setPrice(Float.valueOf(request.getParameter("price")));
    135. 		bookForm.setPage(request.getParameter("page") == "" ? 0 : Integer
    136. 				.parseInt(request.getParameter("page")));
    137. 		bookForm.setBookcaseid(Integer.parseInt(request
    138. 				.getParameter("bookcaseid")));
    139. 		bookForm.setOperator(request.getParameter("operator"));
    140. 		int ret = bookDAO.update(bookForm); // 调用修改图书信息的方法update()
    141. 		if (ret == 0) {
    142. 			request.setAttribute("error", "修改图书信息失败！");
    143. 			request.getRequestDispatcher("error.jsp")
    144. 					.forward(request, response); // 转到错误提示页面
    145. 		} else {
    146. 			request.getRequestDispatcher("book_ok.jsp?para=2").forward(request,
    147. 					response); // 转到修改成功页面
    148. 		}
    149. 	}
    150.  
    151. 	/*********************** 删除图书信息 **************************/
    152. 	private void bookDel(HttpServletRequest request,
    153. 			HttpServletResponse response) throws ServletException, IOException {
    154. 		BookForm bookForm = new BookForm();
    155. 		bookForm.setId(Integer.valueOf(request.getParameter("ID")));
    156. 		int ret = bookDAO.delete(bookForm);
    157. 		if (ret == 0) {
    158. 			request.setAttribute("error", "删除图书信息失败！");
    159. 			request.getRequestDispatcher("error.jsp")
    160. 					.forward(request, response);
    161. 		} else {
    162. 			request.getRequestDispatcher("book_ok.jsp?para=3").forward(request,
    163. 					response);
    164. 		}
    165. 	}
    166.  
    167. 	public void doPost(HttpServletRequest request, HttpServletResponse response)
    168. 			throws ServletException, IOException {
    169.  
    170. 		doGet(request, response);
    171. 	}
    172. }

    BookCase

    1. package com.action;
    2.  
    3. import java.io.IOException;
    4.  
    5. import javax.servlet.ServletException;
    6. import javax.servlet.http.HttpServlet;
    7. import javax.servlet.http.HttpServletRequest;
    8. import javax.servlet.http.HttpServletResponse;
    9. import com.actionForm.BookCaseForm;
    10. import com.dao.BookCaseDAO;
    11.  
    12. public class BookCase extends HttpServlet {
    13. 	private BookCaseDAO bookCaseDAO = null;
    14.  
    15. 	public BookCase() {
    16. 		this.bookCaseDAO = new BookCaseDAO();
    17. 	}
    18.  
    19. 	public void doGet(HttpServletRequest request, HttpServletResponse response)
    20. 			throws ServletException, IOException {
    21. 		String action = request.getParameter("action");
    22. 		System.out.println("\nbookCase*********************action=" + action);
    23. 		if (action == null || "".equals(action)) {
    24. 			request.getRequestDispatcher("error.jsp")
    25. 					.forward(request, response);
    26. 		} else if ("bookCaseAdd".equals(action)) {
    27. 			bookCaseAdd(request, response);
    28. 		} else if ("bookCaseQuery".equals(action)) {
    29. 			bookCaseQuery(request, response);
    30. 		} else if ("bookCaseModifyQuery".equals(action)) {
    31. 			bookCaseModifyQuery(request, response);
    32. 		} else if ("bookCaseModify".equals(action)) {
    33. 			bookCaseModify(request, response);
    34. 		} else if ("bookCaseDel".equals(action)) {
    35. 			bookCaseDel(request, response);
    36. 		}
    37. 	}
    38.  
    39. 	/*********************** 添加书架信息 **************************/
    40. 	private void bookCaseAdd(HttpServletRequest request,
    41. 			HttpServletResponse response) throws ServletException, IOException {
    42. 		BookCaseForm bookCaseForm = new BookCaseForm();
    43. 		bookCaseForm.setName(request.getParameter("name"));
    44. 		int a = bookCaseDAO.insert(bookCaseForm);
    45. 		if (a == 0) {
    46. 			request.setAttribute("error", "书架信息添加失败！");
    47. 			request.getRequestDispatcher("error.jsp")
    48. 					.forward(request, response);
    49. 		} else if (a == 2) {
    50. 			request.setAttribute("error", "该书架信息已经添加！");
    51. 			request.getRequestDispatcher("error.jsp")
    52. 					.forward(request, response);
    53. 		} else {
    54. 			request.getRequestDispatcher("bookcase_ok.jsp?para=1").forward(
    55. 					request, response);
    56. 		}
    57. 	}
    58.  
    59. 	/*********************** 查询全部书架信息 **************************/
    60. 	private void bookCaseQuery(HttpServletRequest request,
    61. 			HttpServletResponse response) throws ServletException, IOException {
    62. 		String str = null;
    63. 		request.setAttribute("bookcase", bookCaseDAO.query(str));
    64. 		request.getRequestDispatcher("bookcase.jsp").forward(request, response);
    65. 	}
    66.  
    67. 	/*********************** 查询修改书架信息 **************************/
    68. 	private void bookCaseModifyQuery(HttpServletRequest request,
    69. 			HttpServletResponse response) throws ServletException, IOException {
    70. 		BookCaseForm bookCaseForm = new BookCaseForm();
    71. 		bookCaseForm.setId(Integer.valueOf(request.getParameter("ID")));
    72. 		request.setAttribute("bookCaseQueryif",
    73. 				bookCaseDAO.queryM(bookCaseForm));
    74. 		request.getRequestDispatcher("bookCase_Modify.jsp").forward(request,
    75. 				response);
    76. 	}
    77.  
    78. 	/*********************** 修改书架信息 **************************/
    79. 	private void bookCaseModify(HttpServletRequest request,
    80. 			HttpServletResponse response) throws ServletException, IOException {
    81. 		BookCaseForm bookCaseForm = new BookCaseForm();
    82. 		bookCaseForm.setId(Integer.parseInt(request.getParameter("id")));
    83. 		bookCaseForm.setName(request.getParameter("name"));
    84. 		int ret = bookCaseDAO.update(bookCaseForm);
    85. 		if (ret == 0) {
    86. 			request.setAttribute("error", "修改书架信息失败！");
    87. 			request.getRequestDispatcher("error.jsp")
    88. 					.forward(request, response);
    89. 		} else {
    90. 			request.getRequestDispatcher("bookcase_ok.jsp?para=2").forward(
    91. 					request, response);
    92. 		}
    93. 	}
    94.  
    95. 	/*********************** 删除书架信息 **************************/
    96. 	private void bookCaseDel(HttpServletRequest request,
    97. 			HttpServletResponse response) throws ServletException, IOException {
    98. 		BookCaseForm bookCaseForm = new BookCaseForm();
    99. 		bookCaseForm.setId(Integer.valueOf(request.getParameter("ID")));
    100. 		int ret = bookCaseDAO.delete(bookCaseForm);
    101. 		if (ret == 0) {
    102. 			request.setAttribute("error", "删除书架信息失败！");
    103. 			request.getRequestDispatcher("error.jsp")
    104. 					.forward(request, response);
    105. 		} else {
    106. 			request.getRequestDispatcher("bookcase_ok.jsp?para=3").forward(
    107. 					request, response);
    108. 		}
    109. 	}
    110.  
    111. 	public void doPost(HttpServletRequest request, HttpServletResponse response)
    112. 			throws ServletException, IOException {
    113.  
    114. 		doGet(request, response);
    115. 	}
    116. }

    如果也想学习本系统，下面领取。关注并回复：103jsp

  • 相关阅读:
    注册公司资本认缴和实缴有何区别？
    LED灯亮灭
    基于nodejs+vue酒店综合服务[程序+论文+开题]-计算机毕业设计
    网站SEO优化有哪些要点?
    SK 注意力模块 原理分析与代码实现
    android studio项目实例-基于Uniapp+SSM实现的作业管理app
    为什么IN操作符一般比OR操作符清单执行更快
    jupyter notebook anaconda环境下查看｜加载｜更换内核
    Egg.js初步使用
    微服务基础，分布式核心，常见微服务框架，SpringCloud概述，搭建SpringCloud微服务项目详细步骤，含源代码
  • 原文地址：https://blog.csdn.net/hanyunlong1989/article/details/126964203