基于javaweb+mysql的jsp+servlet图书管理系统(java+jsp+servlet+javascript+mysql)
私信源码获取及调试交流
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的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
使用说明
- 使用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
public class Manager extends HttpServlet {
private ManagerDAO managerDAO = null; // 声明ManagerDAO的对象
public Manager() {
this.managerDAO = new ManagerDAO(); // 实例化ManagerDAO类
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String action = request.getParameter("action");
System.out.println("获取的查询字符串:" + action);
if (action == null || "".equals(action)) {
request.getRequestDispatcher("error.jsp")
.forward(request, response);
} else if ("login".equals(action)) {// 当action值为login时,调用managerLogin()方法验证管理员身份
managerLogin(request, response);
} else if ("managerAdd".equals(action)) {
managerAdd(request, response);// 添加管理员信息
} else if ("managerQuery".equals(action)) {
managerQuery(request, response);// 查询管理员及权限信息
} else if ("managerModifyQuery".equals(action)) {
managerModifyQuery(request, response);// 设置管理员权限时查询管理员信息
} else if ("managerModify".equals(action)) {
managerModify(request, response);// 设置管理员权限
} else if ("managerDel".equals(action)) {
managerDel(request, response);// 删除管理员
} else if ("querypwd".equals(action)) {
pwdQuery(request, response);// 更改口令时应用的查询
} else if ("modifypwd".equals(action)) {
modifypwd(request, response); // 更改口令
}
}
// 管理员身份验证
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);
}
}
public class Library extends HttpServlet {
LibraryDAO libraryDAO = null;
public Library() {
libraryDAO = new LibraryDAO();
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String str = request.getParameter("action");
if ("libraryQuery".equals(str)) {
libraryModifyQuery(request, response);
} else if ("libraryModify".equals(str)) {
libraryModify(request, response);
}
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doGet(request, response);
}
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();
public class Parameter extends HttpServlet {
ParameterDAO parameterDAO = null;
public Parameter() {
parameterDAO = new ParameterDAO();
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String str = request.getParameter("action");
if ("parameterQuery".equals(str)) {
parameterModifyQuery(request, response);
} else if ("parameterModify".equals(str)) {
parameterModify(request, response);
}
}
private void parameterModify(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
ParameterForm parameterForm = new ParameterForm();
parameterForm.setId(1);
parameterForm.setCost(Integer.parseInt(request.getParameter("cost")));
parameterForm.setValidity(Integer.parseInt(request
.getParameter("validity")));
int ret = parameterDAO.update(parameterForm);
if (ret == 0) {
request.setAttribute("error", "参数设置信息修改失败!");
request.getRequestDispatcher("error.jsp")
.forward(request, response);
} else {
request.getRequestDispatcher("parameter_ok.jsp?para=2").forward(
request, response);
}
}
private void parameterModifyQuery(HttpServletRequest request,
private void bookBorrowSort(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
request.setAttribute("bookBorrowSort", borrowDAO.bookBorrowSort());
request.getRequestDispatcher("bookBorrowSort.jsp").forward(request,
response);
}
/********************* 图书借阅查询 ***********************/
private void borrowQuery(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
String str = null;
String flag[] = request.getParameterValues("flag");
if (flag != null) {
String aa = flag[0];
if ("a".equals(aa)) {
if (request.getParameter("f") != null) {
str = request.getParameter("f") + " like '%"
+ request.getParameter("key") + "%'";
}
}
if ("b".equals(aa)) {
String sdate = request.getParameter("sdate");
String edate = request.getParameter("edate");
if (sdate != null && edate != null) {
str = "borrowTime between '" + sdate + "' and '" + edate
+ "'";
}
System.out.println("日期" + str);
}
// 同时选择日期和条件进行查询
if (flag.length == 2) {
if (request.getParameter("f") != null) {
str = request.getParameter("f") + " like '%"
+ request.getParameter("key") + "%'";
}
System.out.println("日期和条件");
String sdate = request.getParameter("sdate");
String edate = request.getParameter("edate");
String str1 = null;
if (sdate != null && edate != null) {
str1 = "borrowTime between '" + sdate + "' and '" + edate
+ "'";
}
str = str + " and borr." + str1;
System.out.println("条件和日期:" + str);
}
}
request.setAttribute("borrowQuery", borrowDAO.borrowQuery(str));
System.out.print("条件查询图书借阅信息时的str:" + str);
request.getRequestDispatcher("borrowQuery.jsp").forward(request,
response);
int ret = bookTypeDAO.delete(bookTypeForm);
if (ret == 0) {
request.setAttribute("error", "删除图书类型信息失败!");
request.getRequestDispatcher("error.jsp")
.forward(request, response);
} else {
request.getRequestDispatcher("bookType_ok.jsp?para=3").forward(
request, response);
}
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doGet(request, response);
}
}
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)) {
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,
ReaderForm readerForm = new ReaderForm();
System.out.println("查询修改读者信息:" + request.getParameter("ID"));
readerForm.setId(Integer.valueOf(request.getParameter("ID")));
request.setAttribute("readerQueryif", readerDAO.queryM(readerForm));
request.getRequestDispatcher("reader_Modify.jsp").forward(request,
response);
}
/*********************** 查询读者详细信息 **************************/
private void readerDetail(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
ReaderForm readerForm = new ReaderForm();
readerForm.setId(Integer.valueOf(request.getParameter("ID")));
request.setAttribute("readerDetail", readerDAO.queryM(readerForm));
request.getRequestDispatcher("reader_detail.jsp").forward(request,
response);
}
/*********************** 修改读者信息 **************************/
private void readerModify(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
ReaderForm readerForm = new ReaderForm();
readerForm.setId(Integer.parseInt(request.getParameter("id")));
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"));
readerForm.setOperator(request.getParameter("operator"));
readerForm.setRemark(request.getParameter("remark"));
readerForm.setTypeid(Integer.parseInt(request.getParameter("typeid")));
int ret = readerDAO.update(readerForm);
if (ret == 0) {
request.setAttribute("error", "修改读者信息失败!");
request.getRequestDispatcher("error.jsp")
.forward(request, response);
} else {
request.getRequestDispatcher("reader_ok.jsp?para=2").forward(
request, response);
}
}
/*********************** 删除读者信息 **************************/
private void readerDel(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
ReaderForm readerForm = new ReaderForm();
readerForm.setId(Integer.valueOf(request.getParameter("ID")));
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(
ManagerForm managerForm = new ManagerForm();
managerForm.setId(Integer.valueOf(request.getParameter("id")));// 获取并设置管理ID号
System.out.print("查询到的id:" + request.getParameter("id"));
request.setAttribute("managerQueryif",
managerDAO.query_update(managerForm));
request.getRequestDispatcher("manager_Modify.jsp").forward(request,
response); // 转到权限设置成功页面
}
// 修改密码时查询
private void pwdQuery(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
ManagerForm managerForm = new ManagerForm();
HttpSession session = request.getSession();
String manager = (String) session.getAttribute("manager");
managerForm.setName(manager);
System.out.print("查询到的manager:" + manager);
request.setAttribute("pwdQueryif", managerDAO.query_pwd(managerForm));
request.getRequestDispatcher("pwd_Modify.jsp").forward(request,
response);
}
// 管理员权限设置
private void managerModify(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
ManagerForm managerForm = new ManagerForm();
managerForm.setId(Integer.parseInt(request.getParameter("id"))); // 获取并设置管理员ID号
managerForm.setName(request.getParameter("name")); // 获取并设置管理员名称
managerForm.setPwd(request.getParameter("pwd")); // 获取并设置管理员密码
managerForm.setSysset(request.getParameter("sysset") == null ? 0
: Integer.parseInt(request.getParameter("sysset"))); // 获取并设置系统设置权限
managerForm.setReaderset(request.getParameter("readerset") == null ? 0
: Integer.parseInt(request.getParameter("readerset"))); // 获取并设置读者管理权限
managerForm.setBookset(request.getParameter("bookset") == null ? 0
: Integer.parseInt(request.getParameter("bookset"))); // 获取并设置图书管理权限
managerForm
.setBorrowback(request.getParameter("borrowback") == null ? 0
: Integer.parseInt(request.getParameter("borrowback"))); // 获取并设置图书借还权限
managerForm.setSysquery(request.getParameter("sysquery") == null ? 0
: Integer.parseInt(request.getParameter("sysquery"))); // 获取并设置系统查询权限
int ret = managerDAO.update(managerForm); // 调用设置管理员权限的方法
/*********************** 删除图书信息 **************************/
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);
}
}
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);
if (action == null || "".equals(action)) {
request.setAttribute("error", "您的操作有误!");
/*********************** 修改书架信息 **************************/
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);
}
}
public class Library extends HttpServlet {
request.getRequestDispatcher("error.jsp")
.forward(request, response); // 转到错误提示页面
}
}
// 查询修改管理员信息
private void managerModifyQuery(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
ManagerForm managerForm = new ManagerForm();
managerForm.setId(Integer.valueOf(request.getParameter("id")));// 获取并设置管理ID号
System.out.print("查询到的id:" + request.getParameter("id"));
request.setAttribute("managerQueryif",
managerDAO.query_update(managerForm));
request.getRequestDispatcher("manager_Modify.jsp").forward(request,
response); // 转到权限设置成功页面
}
// 修改密码时查询
private void pwdQuery(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
ManagerForm managerForm = new ManagerForm();
HttpSession session = request.getSession();
String manager = (String) session.getAttribute("manager");
managerForm.setName(manager);
System.out.print("查询到的manager:" + manager);
request.setAttribute("pwdQueryif", managerDAO.query_pwd(managerForm));
request.getRequestDispatcher("pwd_Modify.jsp").forward(request,
response);
}
// 管理员权限设置
private void managerModify(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
ManagerForm managerForm = new ManagerForm();
managerForm.setId(Integer.parseInt(request.getParameter("id"))); // 获取并设置管理员ID号
managerForm.setName(request.getParameter("name")); // 获取并设置管理员名称
managerForm.setPwd(request.getParameter("pwd")); // 获取并设置管理员密码
managerForm.setSysset(request.getParameter("sysset") == null ? 0
: Integer.parseInt(request.getParameter("sysset"))); // 获取并设置系统设置权限
managerForm.setReaderset(request.getParameter("readerset") == null ? 0
: Integer.parseInt(request.getParameter("readerset"))); // 获取并设置读者管理权限
managerForm.setBookset(request.getParameter("bookset") == null ? 0
: Integer.parseInt(request.getParameter("bookset"))); // 获取并设置图书管理权限
managerForm
.setBorrowback(request.getParameter("borrowback") == null ? 0
: Integer.parseInt(request.getParameter("borrowback"))); // 获取并设置图书借还权限
readerForm.setBarcode(request.getParameter("barcode"));
ReaderForm reader = (ReaderForm) readerDAO.queryM(readerForm);
request.setAttribute("readerinfo", reader);
// 查询读者的借阅信息
request.setAttribute("borrowinfo",
borrowDAO.borrowinfo(request.getParameter("barcode")));
if (request.getParameter("id") != null) {
int id = Integer.parseInt(request.getParameter("id"));
String operator = request.getParameter("operator");
if (id > 0) { // 执行归还操作
int ret = borrowDAO.back(id, operator);
if (ret == 0) {
request.setAttribute("error", "图书归还失败!");
request.getRequestDispatcher("error.jsp").forward(request,
response);
} else {
request.setAttribute("bar", request.getParameter("barcode"));
request.getRequestDispatcher("bookBack_ok.jsp").forward(
request, response);
}
}
} else {
request.getRequestDispatcher("bookBack.jsp").forward(request,
response);
}
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doGet(request, response);
}
}
public class Book extends HttpServlet {
private BookDAO bookDAO = null;
public Book() {
this.bookDAO = new BookDAO();
}
public void doGet(HttpServletRequest request, HttpServletResponse 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);
.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);
}
}
public class Reader extends HttpServlet {
private ReaderDAO readerDAO = null;
public Reader() {
this.readerDAO = new ReaderDAO();
* 查询修改读者类型信息
*
* @throws IOException
* @throws ServletException
* *
*************************/
private void readerTypeModifyQuery(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
ReaderTypeForm readerTypeForm = new ReaderTypeForm();
readerTypeForm.setId(Integer.valueOf(request.getParameter("ID")));
request.setAttribute("readerTypeQueryif",
readerTypeDAO.queryM(readerTypeForm));
request.getRequestDispatcher("readerType_Modify.jsp").forward(request,
response);
}
/***********************
* 修改读者类型信息
*
* @throws IOException
* @throws ServletException
* *
*************************/
private void readerTypeModify(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
ReaderTypeForm readerTypeForm = new ReaderTypeForm();
readerTypeForm.setId(Integer.parseInt(request.getParameter("id")));
readerTypeForm.setName(request.getParameter("name"));
readerTypeForm.setNumber(Integer.parseInt(request
.getParameter("number")));
int ret = readerTypeDAO.update(readerTypeForm);
if (ret == 0) {
request.setAttribute("error", "修改读者类型信息失败!");
request.getRequestDispatcher("error.jsp")
.forward(request, response);
} else {
request.getRequestDispatcher("readerType_ok.jsp?para=2").forward(
request, response);
}
}
/***********************
* 删除读者类型信息