Java源码社

基于javaweb的JSP+Servlet图书管理系统(java+jsp+servlet+javascript+mysql)

更新于

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

eclipse/idea/myeclipse/sts等均可配置运行

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

功能说明

150023442402

160023442402

170023442402

180023442402

190023442402

200023442402

基于javaweb的JSP+Servlet图书管理系统(java+jsp+servlet+javascript+mysql)

项目介绍

本项目为后台管理项目

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

环境需要

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

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
	}
}

/*********************** 添加图书类型信息 **************************/
private void bookTypeAdd(HttpServletRequest request,
		HttpServletResponse response) throws ServletException, IOException {
	BookTypeForm bookTypeForm = new BookTypeForm();
	bookTypeForm.setTypeName(request.getParameter("typeName"));
	bookTypeForm.setDays(Integer.parseInt(request.getParameter("days")));
	int a = bookTypeDAO.insert(bookTypeForm);
	if (a == 0) {
		request.setAttribute("error", "图书类型信息添加失败！");
		request.getRequestDispatcher("error.jsp")
				.forward(request, response);
	} else if (a == 2) {
		request.setAttribute("error", "该图书类型信息已经添加！");
		request.getRequestDispatcher("error.jsp")
				.forward(request, response);
	} else {
		request.getRequestDispatcher("bookType_ok.jsp?para=1").forward(
				request, response);
	}
}

/*********************** 查询全部图书类型信息 **************************/
private void bookTypeQuery(HttpServletRequest request,
		HttpServletResponse response) throws ServletException, IOException {
	String str = null;
	request.setAttribute("bookType", bookTypeDAO.query(str));
	request.getRequestDispatcher("bookType.jsp").forward(request, response);
}

/*********************** 查询修改图书类型信息 **************************/
private void bookTypeModifyQuery(HttpServletRequest request,
		HttpServletResponse response) throws ServletException, IOException {
	BookTypeForm bookTypeForm = new BookTypeForm();
	bookTypeForm.setId(Integer.valueOf(request.getParameter("ID")));
	request.setAttribute("bookTypeQueryif",
			bookTypeDAO.queryM(bookTypeForm));
	request.getRequestDispatcher("bookType_Modify.jsp").forward(request,
			response);
}

/*********************** 修改图书类型信息 **************************/
private void bookTypeModify(HttpServletRequest request,
		HttpServletResponse response) throws ServletException, IOException {
	BookTypeForm bookTypeForm = new BookTypeForm();
	bookTypeForm.setId(Integer.parseInt(request.getParameter("id")));
	bookTypeForm.setTypeName(request.getParameter("typeName"));
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
	/*********************** 删除图书信息 **************************/
	private void bookDel(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {
		BookForm bookForm = new BookForm();
		bookForm.setId(Integer.valueOf(request.getParameter("ID")));
		int ret = bookDAO.delete(bookForm);
		if (ret == 0) {
			request.setAttribute("error", "删除图书信息失败！");
			request.getRequestDispatcher("error.jsp")
					.forward(request, response);
		} else {
			request.getRequestDispatcher("book_ok.jsp?para=3").forward(request,
					response);
		}
	}

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		doGet(request, response);
	}
}
package com.action;



public class Reader extends HttpServlet {
	private ReaderDAO readerDAO = null;

	public Reader() {
		this.readerDAO = new ReaderDAO();
	}

	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		String action = request.getParameter("action");
		System.out.println("\nreader*********************action=" + action);
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
		if (ret == 0) {
			request.setAttribute("error", "修改书架信息失败！");
			request.getRequestDispatcher("error.jsp")
					.forward(request, response);
		} else {
			request.getRequestDispatcher("bookcase_ok.jsp?para=2").forward(
					request, response);
		}
	}

	/*********************** 删除书架信息 **************************/
	private void bookCaseDel(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {
		BookCaseForm bookCaseForm = new BookCaseForm();
		bookCaseForm.setId(Integer.valueOf(request.getParameter("ID")));
		int ret = bookCaseDAO.delete(bookCaseForm);
		if (ret == 0) {
			request.setAttribute("error", "删除书架信息失败！");
			request.getRequestDispatcher("error.jsp")
					.forward(request, response);
		} else {
			request.getRequestDispatcher("bookcase_ok.jsp?para=3").forward(
					request, response);
		}
	}

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		doGet(request, response);
	}
}
package com.action;




public class Library extends HttpServlet {
	LibraryDAO libraryDAO = null;

	public Library() {
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
	} else if ("readerModifyQuery".equals(action)) {
		readerModifyQuery(request, response);
	} else if ("readerModify".equals(action)) {
		readerModify(request, response);
	} else if ("readerDel".equals(action)) {
		readerDel(request, response);
	} else if ("readerDetail".equals(action)) {
		readerDetail(request, response);
	}
}

/*********************** 添加读者信息 **************************/
private void readerAdd(HttpServletRequest request,
		HttpServletResponse response) throws ServletException, IOException {
	ReaderForm readerForm = new ReaderForm();
	readerForm.setName(request.getParameter("name"));
	readerForm.setSex(request.getParameter("sex"));
	readerForm.setBarcode(request.getParameter("barcode"));
	readerForm.setVocation(request.getParameter("vocation"));
	readerForm.setBirthday(request.getParameter("birthday"));
	readerForm.setPaperType(request.getParameter("paperType"));
	readerForm.setPaperNO(request.getParameter("paperNO"));
	readerForm.setTel(request.getParameter("tel"));
	readerForm.setEmail(request.getParameter("email"));
	// 获取系统日期
	Date date1 = new Date();
	java.sql.Date date = new java.sql.Date(date1.getTime());
	readerForm.setCreateDate(date.toString());
	readerForm.setOperator(request.getParameter("operator"));
	readerForm.setRemark(request.getParameter("remark"));
	readerForm.setTypeid(Integer.parseInt(request.getParameter("typeid")));
	int a = readerDAO.insert(readerForm);
	if (a == 0) {
		request.setAttribute("error", "读者信息添加失败！");
		request.getRequestDispatcher("error.jsp")
				.forward(request, response);
	} else if (a == 2) {
		request.setAttribute("error", "该读者信息已经添加！");
		request.getRequestDispatcher("error.jsp")
				.forward(request, response);
	} else {
		request.getRequestDispatcher("reader_ok.jsp?para=1").forward(
				request, response);
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
		libraryForm.setCurator(request.getParameter("curator"));
		libraryForm.setTel(request.getParameter("tel"));
		libraryForm.setAddress(request.getParameter("address"));
		libraryForm.setEmail(request.getParameter("email"));
		libraryForm.setUrl(request.getParameter("url"));
		libraryForm.setCreateDate(request.getParameter("createDate"));
		libraryForm.setIntroduce(request.getParameter("introduce"));
		int ret = libraryDAO.update(libraryForm);
		if (ret == 0) {
			request.setAttribute("error", "图书馆信息修改失败！");
			request.getRequestDispatcher("error.jsp")
					.forward(request, response);
		} else {
			request.getRequestDispatcher("library_ok.jsp?para=2").forward(
					request, response);
		}

	}

	private void libraryModifyQuery(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {
		request.setAttribute("libraryModifyif", libraryDAO.query());
		request.getRequestDispatcher("library_modify.jsp").forward(request,
				response);
	}
}
package com.action;




public class Parameter extends HttpServlet {
	ParameterDAO parameterDAO = null;

	public Parameter() {
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
	private void managerDel(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {
		ManagerForm managerForm = new ManagerForm();
		managerForm.setId(Integer.valueOf(request.getParameter("id"))); // 获取并设置管理员ID号
		int ret = managerDAO.delete(managerForm); // 调用删除信息的方法delete()
		if (ret == 0) {
			request.setAttribute("error", "删除管理员信息失败！"); // 保存错误提示信息到error参数中
			request.getRequestDispatcher("error.jsp")
					.forward(request, response); // 转到错误提示页面
		} else {
			request.getRequestDispatcher("manager_ok.jsp?para=3").forward(
					request, response); // 转到删除管理员信息成功页面
		}
	}

	// 修改管理员密码
	private void modifypwd(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {
		ManagerForm managerForm = new ManagerForm();
		managerForm.setName(request.getParameter("name"));
		managerForm.setPwd(request.getParameter("pwd"));
		int ret = managerDAO.updatePwd(managerForm);
		if (ret == 0) {
			request.setAttribute("error", "更改口令失败！");
			request.getRequestDispatcher("error.jsp")
					.forward(request, response);
		} else {
			request.getRequestDispatcher("pwd_ok.jsp").forward(request,
					response);
		}
	}

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		doGet(request, response);
	}

}
package com.action;


项目链接：
https://javayms.github.io?id=191122522008200og
https://javayms.pages.dev?id=191122522008200og