作者主页:夜未央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
package com.action;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.actionForm.BookForm;
import com.dao.BookDAO;
import java.io.IOException;
import java.util.Date;
public class Book extends HttpServlet {
private BookDAO bookDAO = null;
public Book() {
this.bookDAO = new BookDAO();
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String action = request.getParameter("action");
System.out.println("\nbook*********************action=" + action);
if (action == null || "".equals(action)) {
request.setAttribute("error", "您的操作有误!");
request.getRequestDispatcher("error.jsp")
.forward(request, response);
} else if ("bookAdd".equals(action)) {
bookAdd(request, response);
} else if ("bookQuery".equals(action)) {
bookQuery(request, response);
} else if ("bookModifyQuery".equals(action)) {
bookModifyQuery(request, response);
} else if ("bookModify".equals(action)) {
bookModify(request, response);
} else if ("bookDel".equals(action)) {
bookDel(request, response);
} else if ("bookDetail".equals(action)) {
bookDetail(request, response);
} else if ("bookifQuery".equals(action)) {
bookifQuery(request, response);
}
}
/*********************** 添加图书信息 **************************/
private void bookAdd(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
BookForm bookForm = new BookForm();
bookForm.setBarcode(request.getParameter("barcode"));
bookForm.setBookName(request.getParameter("bookName"));
bookForm.setTypeId(Integer.parseInt(request.getParameter("typeId")));
bookForm.setAuthor(request.getParameter("author"));
bookForm.setTranslator(request.getParameter("translator"));
bookForm.setIsbn(request.getParameter("isbn"));
bookForm.setPrice(Float.valueOf(request.getParameter("price")));
bookForm.setPage(request.getParameter("page") == "" ? 0 : Integer
.parseInt(request.getParameter("page")));
bookForm.setBookcaseid(Integer.parseInt(request
.getParameter("bookcaseid")));
// 获取系统日期
Date date1 = new Date();
java.sql.Date date = new java.sql.Date(date1.getTime());
bookForm.setInTime(date.toString());
bookForm.setOperator(request.getParameter("operator"));
int a = bookDAO.insert(bookForm);
if (a == 1) {
request.getRequestDispatcher("book_ok.jsp?para=1").forward(request,
response);
} else if (a == 2) {
request.setAttribute("error", "该图书信息已经添加!");
request.getRequestDispatcher("error.jsp")
.forward(request, response);
} else {
request.setAttribute("error", "图书信息添加失败!");
request.getRequestDispatcher("error.jsp")
.forward(request, response);
}
}
/*********************** 查询全部图书信息 **************************/
private void bookQuery(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
String str = null;
request.setAttribute("book", bookDAO.query(str)); // 将查询结果保存到book中
request.getRequestDispatcher("book.jsp").forward(request, response);
}
/*********************** 条件查询图书信息 **************************/
private void bookifQuery(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
String str = null;
if (request.getParameter("f") != null) {
str = request.getParameter("f") + " like '%"
+ request.getParameter("key") + "%";
}
request.setAttribute("ifbook", bookDAO.query(str));
System.out.print("条件查询图书信息时的str:" + str);
request.getRequestDispatcher("bookQuery.jsp")
.forward(request, response);
}
/*********************** 查询修改图书信息 **************************/
private void bookModifyQuery(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
BookForm bookForm = new BookForm();
System.out.println("查询修改图书信息:" + request.getParameter("ID"));
bookForm.setId(Integer.valueOf(request.getParameter("ID")));
request.setAttribute("bookQueryif", bookDAO.queryM(bookForm));
request.getRequestDispatcher("book_Modify.jsp").forward(request,
response);
}
/*********************** 查询图书详细信息 **************************/
private void bookDetail(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
BookForm bookForm = new BookForm();
bookForm.setId(Integer.valueOf(request.getParameter("ID")));
request.setAttribute("bookDetail", bookDAO.queryM(bookForm));
request.getRequestDispatcher("book_detail.jsp").forward(request,
response);
}
/*********************** 修改图书信息 **************************/
private void bookModify(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
BookForm bookForm = new BookForm(); // 实例化BookForm类
bookForm.setId(Integer.parseInt(request.getParameter("id")));
bookForm.setBarcode(request.getParameter("barcode")); // 获取并设置条形码属性
bookForm.setBookName(request.getParameter("bookName"));
bookForm.setTypeId(Integer.parseInt(request.getParameter("typeId")));
bookForm.setAuthor(request.getParameter("author"));
bookForm.setTranslator(request.getParameter("translator"));
bookForm.setIsbn(request.getParameter("isbn"));
bookForm.setPrice(Float.valueOf(request.getParameter("price")));
bookForm.setPage(request.getParameter("page") == "" ? 0 : Integer
.parseInt(request.getParameter("page")));
bookForm.setBookcaseid(Integer.parseInt(request
.getParameter("bookcaseid")));
bookForm.setOperator(request.getParameter("operator"));
int ret = bookDAO.update(bookForm); // 调用修改图书信息的方法update()
if (ret == 0) {
request.setAttribute("error", "修改图书信息失败!");
request.getRequestDispatcher("error.jsp")
.forward(request, response); // 转到错误提示页面
} else {
request.getRequestDispatcher("book_ok.jsp?para=2").forward(request,
response); // 转到修改成功页面
}
}
/*********************** 删除图书信息 **************************/
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);
}
}
BookCase
package com.action;
import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.actionForm.BookCaseForm;
import com.dao.BookCaseDAO;
public class BookCase extends HttpServlet {
private BookCaseDAO bookCaseDAO = null;
public BookCase() {
this.bookCaseDAO = new BookCaseDAO();
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String action = request.getParameter("action");
System.out.println("\nbookCase*********************action=" + action);
if (action == null || "".equals(action)) {
request.getRequestDispatcher("error.jsp")
.forward(request, response);
} else if ("bookCaseAdd".equals(action)) {
bookCaseAdd(request, response);
} else if ("bookCaseQuery".equals(action)) {
bookCaseQuery(request, response);
} else if ("bookCaseModifyQuery".equals(action)) {
bookCaseModifyQuery(request, response);
} else if ("bookCaseModify".equals(action)) {
bookCaseModify(request, response);
} else if ("bookCaseDel".equals(action)) {
bookCaseDel(request, response);
}
}
/*********************** 添加书架信息 **************************/
private void bookCaseAdd(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
BookCaseForm bookCaseForm = new BookCaseForm();
bookCaseForm.setName(request.getParameter("name"));
int a = bookCaseDAO.insert(bookCaseForm);
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("bookcase_ok.jsp?para=1").forward(
request, response);
}
}
/*********************** 查询全部书架信息 **************************/
private void bookCaseQuery(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
String str = null;
request.setAttribute("bookcase", bookCaseDAO.query(str));
request.getRequestDispatcher("bookcase.jsp").forward(request, response);
}
/*********************** 查询修改书架信息 **************************/
private void bookCaseModifyQuery(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
BookCaseForm bookCaseForm = new BookCaseForm();
bookCaseForm.setId(Integer.valueOf(request.getParameter("ID")));
request.setAttribute("bookCaseQueryif",
bookCaseDAO.queryM(bookCaseForm));
request.getRequestDispatcher("bookCase_Modify.jsp").forward(request,
response);
}
/*********************** 修改书架信息 **************************/
private void bookCaseModify(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
BookCaseForm bookCaseForm = new BookCaseForm();
bookCaseForm.setId(Integer.parseInt(request.getParameter("id")));
bookCaseForm.setName(request.getParameter("name"));
int ret = bookCaseDAO.update(bookCaseForm);
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);
}
}
如果也想学习本系统,下面领取。关注并回复:103jsp