天天看點

IDEA+Java+Servlet+JSP+Mysql實作Web圖書管理系統【建議收藏】一、系統介紹二、系統展示  三、部分代碼四、其他

目錄

一、系統介紹

1.開發環境

2.技術選型

3.系統功能

4.資料庫

5.工程截圖

二、系統展示 

1.登入系統

2.首頁面

3.圖書清單

4.圖書詳情

5.編輯删除

6.添加圖書

7.圖書借閱

8.圖書歸還

9.借閱記錄

10.使用者管理

 三、部分代碼

BookAction

IOAction

LoginAction

ReaderAction

四、其他

1.其他系統實作

1.JavaWeb系統系列實作

2.JavaSwing系統系列實作

2.擷取源碼

3.運作項目

4.備注

5.支援部落客

JavaWeb系統系列實作

Java+JSP實作學生圖書管理系統

Java+JSP實作學生資訊管理系統

Java+JSP實作使用者資訊管理系統

Java+Servlet+JSP實作航空訂票系統

Java+Servlet+JSP實作新聞釋出系統

Java+Servlet+JSP學生宿舍管理系統

Java+Servlet+JSP實作學生資訊管理系統

Java+Servlet+JSP實作學生選課管理系統

Java+Servlet+JSP實作學生成績管理系統-1

Java+Servlet+JSP實作學生成績管理系統-2

Java+Servlet+JSP實作寵物診所管理系統

Java+SSM+JSP實作網上考試系統

Java+SSH+JSP實作線上考試系統

Java+SSH+JSP實作醫院線上挂号系統

Java+Springboot+Mybatis+Bootstrap+Maven實作網上商城系統

一、系統介紹

1.開發環境

開發工具:IDEA2018.2

JDK版本:jdk1.8

Mysql版本:8.0.13

2.技術選型

後端:Java+Servlet進行開發。

前端:JSP+HTML+CSS。

3.系統功能

1.登入系統

2.圖書的增删改查

3.借書與還書

4.圖書進出記錄

5.使用者管理

6.登出

4.資料庫

/*
 Navicat Premium Data Transfer

 Source Server         : MySQL
 Source Server Type    : MySQL
 Source Server Version : 80013
 Source Host           : 127.0.0.1:3306
 Source Schema         : servlet_library

 Target Server Type    : MySQL
 Target Server Version : 80013
 File Encoding         : 65001

 Date: 21/08/2021 22:14:51
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for book
-- ----------------------------
DROP TABLE IF EXISTS `book`;
CREATE TABLE `book`  (
  `id` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '書本ID',
  `bookname` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '書本名稱',
  `author` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '書本作者',
  `publisher` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '出版社',
  `price` int(11) NULL DEFAULT NULL COMMENT '書本價格',
  `category` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '書本類目',
  `store` int(11) NULL DEFAULT NULL,
  `bookdesc` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `location` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '書籍資料庫' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of book
-- ----------------------------
INSERT INTO `book` VALUES ('000001', 'Java核心技術', '凱 S. 霍斯特曼', '機械工業出版社', 130, '程式設計類', 200, '《JAVA核心技術》(第8版)是2011年電子工業出版社出版的圖書,作者是昊斯特曼、Gary Cornell。本書針對JavaSE6平台進行了全面更新,囊括了Java平台标準版(JavaSE/J2SE)的全部基礎知識,提供了大量完整且具有實際意義的應用執行個體。', '3');
INSERT INTO `book` VALUES ('000003', '算法競賽入門經典', '劉汝佳', '清華大學出版社', 50, '程式設計類', 15, '《JAVA核心技術》(第8版)是2011年電子工業出版社出版的圖書,作者是昊斯特曼、Gary Cornell。本書針對JavaSE6平台進行了全面更新,囊括了Java平台标準版(JavaSE/J2SE)的全部基礎知識,提供了大量完整且具有實際意義的應用執行個體。', '3');
INSERT INTO `book` VALUES ('000004', '機率論與數理統計', '盛驟 謝式千 潘承毅', '高等教育出版社', 38, '數學類', 15, '《JAVA核心技術》(第8版)是2011年電子工業出版社出版的圖書,作者是昊斯特曼、Gary Cornell。本書針對JavaSE6平台進行了全面更新,囊括了Java平台标準版(JavaSE/J2SE)的全部基礎知識,提供了大量完整且具有實際意義的應用執行個體。', '1');
INSERT INTO `book` VALUES ('000005', '資料結構(C語言版)', '嚴蔚敏 吳偉民', '清華大學出版社', 29, '程式設計類', 8, '《JAVA核心技術》(第8版)是2011年電子工業出版社出版的圖書,作者是昊斯特曼、Gary Cornell。本書針對JavaSE6平台進行了全面更新,囊括了Java平台标準版(JavaSE/J2SE)的全部基礎知識,提供了大量完整且具有實際意義的應用執行個體。', '3');

-- ----------------------------
-- Table structure for iolog
-- ----------------------------
DROP TABLE IF EXISTS `iolog`;
CREATE TABLE `iolog`  (
  `bookid` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `readerid` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `service` int(11) NULL DEFAULT NULL,
  `borrowtime` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `borrowday` int(11) NULL DEFAULT NULL,
  `complete` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`borrowtime`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of iolog
-- ----------------------------
INSERT INTO `iolog` VALUES ('000001', '1', -1, '2021年08月21日 21時38分10秒', 7, 1);
INSERT INTO `iolog` VALUES ('000001', '1', 1, '2021年08月21日 21時38分20秒', NULL, 1);

-- ----------------------------
-- Table structure for reader
-- ----------------------------
DROP TABLE IF EXISTS `reader`;
CREATE TABLE `reader`  (
  `username` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '讀者使用者名',
  `password` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '讀者密碼',
  `name` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '讀者姓名',
  `sex` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '讀者性别',
  `status` int(11) NULL DEFAULT NULL COMMENT '讀者狀态(1.正常 -1.黑名單)',
  `mail` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '讀者郵箱',
  `tel` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '讀者電話',
  `grade` int(11) NULL DEFAULT -1 COMMENT '讀者年級',
  `classnum` int(11) NULL DEFAULT -1 COMMENT '讀者班級',
  PRIMARY KEY (`username`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '讀者表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of reader
-- ----------------------------
INSERT INTO `reader` VALUES ('1', '123456', '測試', '測試', 1, '測試', '測試', 1, 1);

-- ----------------------------
-- Table structure for tempadd
-- ----------------------------
DROP TABLE IF EXISTS `tempadd`;
CREATE TABLE `tempadd`  (
  `id` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `bookname` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '書本名稱',
  `author` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '書本作者',
  `publisher` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '出版社',
  `price` int(11) NULL DEFAULT NULL COMMENT '書本價格',
  `category` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '書本類目',
  `store` int(11) NULL DEFAULT NULL,
  `bookdesc` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `location` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tempadd
-- ----------------------------

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `user` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '使用者名',
  `password` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '使用者密碼',
  `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '使用者真實姓名',
  `sex` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '使用者性别',
  `department` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '使用者部門',
  `tel` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '使用者電話',
  PRIMARY KEY (`user`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('admin', 'admin', '管理者', '男', '圖書館', '12345678901');

SET FOREIGN_KEY_CHECKS = 1;
           

5.工程截圖

IDEA+Java+Servlet+JSP+Mysql實作Web圖書管理系統【建議收藏】一、系統介紹二、系統展示  三、部分代碼四、其他

二、系統展示 

1.登入系統

IDEA+Java+Servlet+JSP+Mysql實作Web圖書管理系統【建議收藏】一、系統介紹二、系統展示  三、部分代碼四、其他

2.首頁面

IDEA+Java+Servlet+JSP+Mysql實作Web圖書管理系統【建議收藏】一、系統介紹二、系統展示  三、部分代碼四、其他

3.圖書清單

IDEA+Java+Servlet+JSP+Mysql實作Web圖書管理系統【建議收藏】一、系統介紹二、系統展示  三、部分代碼四、其他

4.圖書詳情

IDEA+Java+Servlet+JSP+Mysql實作Web圖書管理系統【建議收藏】一、系統介紹二、系統展示  三、部分代碼四、其他

5.編輯删除

IDEA+Java+Servlet+JSP+Mysql實作Web圖書管理系統【建議收藏】一、系統介紹二、系統展示  三、部分代碼四、其他

6.添加圖書

IDEA+Java+Servlet+JSP+Mysql實作Web圖書管理系統【建議收藏】一、系統介紹二、系統展示  三、部分代碼四、其他

7.圖書借閱

IDEA+Java+Servlet+JSP+Mysql實作Web圖書管理系統【建議收藏】一、系統介紹二、系統展示  三、部分代碼四、其他

8.圖書歸還

IDEA+Java+Servlet+JSP+Mysql實作Web圖書管理系統【建議收藏】一、系統介紹二、系統展示  三、部分代碼四、其他

9.借閱記錄

IDEA+Java+Servlet+JSP+Mysql實作Web圖書管理系統【建議收藏】一、系統介紹二、系統展示  三、部分代碼四、其他

10.使用者管理

IDEA+Java+Servlet+JSP+Mysql實作Web圖書管理系統【建議收藏】一、系統介紹二、系統展示  三、部分代碼四、其他

 三、部分代碼

BookAction

package Action;

import Dao.BookDao;
import Entity.Book;
import Entity.User;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.ArrayList;

public class BookAction extends HttpServlet {
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doGet(request, response);
    }

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("UTF-8");
        response.setCharacterEncoding("UTF-8");
        String action = request.getParameter("action");
        if (action.equals("getall")) {
            this.getAll(request, response);
        } else if (action.equals("addtemp")) {
            this.addtemp(request, response);
        } else if (action.equals("gettemp")) {
            this.gettemp(request, response);
        } else if (action.equals("confirm")) {
            this.confirm(request, response);
        } else if (action.equals("querybookbyid")) {
            this.QueryBookById(request, response);
        } else if (action.equals("DeleteById")) {
            this.DeleteById(request, response);
        } else if (action.equals("EditDone")) {
            this.EditDone(request, response);
        }
    }

    private void getAll(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        BookDao bdao = new BookDao();
        ArrayList<Book> bookArrayList = bdao.getAllBook();
        HttpSession session = request.getSession();
        session.setAttribute("allbooklist", bookArrayList);
        request.getRequestDispatcher("/book-list.jsp").forward(request, response);
    }

    private void addtemp(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String next = request.getParameter("over");
        BookDao bdao = new BookDao();
        Book book = new Book();
        if (!request.getParameter("bookid").equals(""))
            book.setId(request.getParameter("bookid"));
        if (!request.getParameter("bookname").equals(""))
            book.setName(request.getParameter("bookname"));
        if (!request.getParameter("bookauthor").equals(""))
            book.setAuthor(request.getParameter("bookauthor"));
        if (!request.getParameter("bookpublisher").equals(""))
            book.setPublisher(request.getParameter("bookpublisher"));
        if (!request.getParameter("bookcategory").equals(""))
            book.setCategory(request.getParameter("bookcategory"));
        if (!request.getParameter("bookprice").trim().equals(""))
            book.setPrice(Integer.parseInt(request.getParameter("bookprice")));
        if (!request.getParameter("bookstore").trim().equals(""))
            book.setStore(Integer.parseInt(request.getParameter("bookstore")));
        if (!request.getParameter("booklocation").equals(""))
            book.setLocation(request.getParameter("booklocation"));
        if (!request.getParameter("bookdesc").equals(""))
            book.setDesc(request.getParameter("bookdesc"));
        if (!request.getParameter("bookid").equals(""))
            bdao.addtemp(book);
        if (next.equals("0"))
            request.getRequestDispatcher("/add-book.jsp").forward(request, response);
        else
            this.gettemp(request, response);
    }

    private void gettemp(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        BookDao bdao = new BookDao();
        ArrayList<Book> addbooklist = bdao.getadd();
        HttpSession session = request.getSession();
        session.setAttribute("addbooklist", addbooklist);
        request.getRequestDispatcher("/add-confirm.jsp").forward(request, response);
    }

    private void confirm(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        BookDao bdao = new BookDao();
        bdao.confirm();
        this.getAll(request, response);
    }

    private void QueryBookById(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        BookDao bdao = new BookDao();
        String id = request.getParameter("id");
        String next = request.getParameter("next");
        Book book = bdao.QueryBookById(id);
        HttpSession session = request.getSession();
        session.setAttribute("resultbook", book);
        PrintWriter out = response.getWriter();
        if (next.equals("check"))
            request.getRequestDispatcher("/detail.jsp").forward(request, response);
        else if (next.equals("edit"))
            request.getRequestDispatcher("/edit-book.jsp").forward(request, response);
        else if (next.equals("borrowcheck")) {
            out.write(book.getName() + "||" + book.getAuthor() + "||" + book.getPublisher() + "||" + book.getRemain());
        }
    }

    private void DeleteById(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        BookDao bdao = new BookDao();
        String id = request.getParameter("id");
        bdao.DeleteById(id);
        this.getAll(request, response);
    }

    private void EditDone(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        BookDao bdao = new BookDao();
        Book book = new Book();
        if (!request.getParameter("id").equals(""))
            book.setId(request.getParameter("id"));
        if (!request.getParameter("name").equals(""))
            book.setName(request.getParameter("name"));
        if (!request.getParameter("author").equals(""))
            book.setAuthor(request.getParameter("author"));
        if (!request.getParameter("publisher").equals(""))
            book.setPublisher(request.getParameter("publisher"));
        if (!request.getParameter("category").equals(""))
            book.setCategory(request.getParameter("category"));
        if (!request.getParameter("price").trim().equals(""))
            book.setPrice(Integer.parseInt(request.getParameter("price")));
        if (!request.getParameter("store").trim().equals(""))
            book.setStore(Integer.parseInt(request.getParameter("store")));
        if (!request.getParameter("location").equals(""))
            book.setLocation(request.getParameter("location"));
        if (!request.getParameter("desc").equals(""))
            book.setDesc(request.getParameter("desc"));
        if (!request.getParameter("id").equals(""))
            bdao.addtemp(book);
        bdao.EditDone(book);
        request.getRequestDispatcher("BookAction?action=querybookbyid&id=<%=b.getId()%>&next=check").forward(request, response);
    }
}
           

IOAction

package Action;

import Dao.IODao;
import Entity.Log;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import java.io.IOException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;

public class IOAction extends HttpServlet {
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String action = request.getParameter("action");
        if (action.equals("borrow")) {
            this.borrow(request, response);
        } else if (action.equals("getlog")) {
            this.getlog(request, response);
        } else if (action.equals("return")) {
            this.ReturnBook(request, response);
        }
    }

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        this.doPost(request, response);
    }

    protected void borrow(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        IODao ioDao = new IODao();
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy年MM月dd日 HH時mm分ss秒");
        Date date = new Date();
        String time = sdf.format(date);
        String readerid = request.getParameter("readerid");
        String bookid = request.getParameter("bookid");
        int borrowday = Integer.parseInt(request.getParameter("borrowday"));
        ioDao.borrow(bookid, readerid, time, borrowday);
        this.getlog(request, response);
    }

    protected void getlog(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        IODao ioDao = new IODao();
        ArrayList<Log> loglist = ioDao.getLogList();
        HttpSession session = request.getSession();
        session.setAttribute("loglist", loglist);
        request.getRequestDispatcher("/io-log.jsp").forward(request, response);
    }

    protected void ReturnBook(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        IODao ioDao = new IODao();
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy年MM月dd日 HH時mm分ss秒");
        Date date = new Date();
        String Returntime = sdf.format(date);
        String bookid = request.getParameter("bookid");
        String readerId = request.getParameter("ReaderId");
        String borrowtime = request.getParameter("borrowtime");
        ioDao.ReturnBook(bookid, readerId, borrowtime, Returntime);
        this.getlog(request, response);
    }


}
           

LoginAction

package Action;

import Dao.UserDao;
import Entity.User;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import java.io.IOException;
import java.io.PrintWriter;

public class LoginAction extends HttpServlet {
    UserDao udao = new UserDao();

    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String action = request.getParameter("action");
        if (action.equals("login")) {
            this.login(request, response);
        } else if (action.equals("logout")) {
            this.logout(request, response);
        }
    }

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doPost(request, response);
    }

    private void login(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String username = null;
        String password = null;
        PrintWriter out = response.getWriter();
        HttpSession session = request.getSession();
        username = request.getParameter("username");
        password = request.getParameter("password");
        User user = new User();
        user.setUsername(username);
        user.setPassword(password);
        String result = udao.login(user);
        if (result.equals("true")) {
            session.setAttribute("adminname", user.getName());
            request.getRequestDispatcher("/main.jsp").forward(request, response);
        } else {
            out.write(result);
        }
    }

    private void logout(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        HttpSession session = request.getSession();
        session.setMaxInactiveInterval(1);
        response.sendRedirect("/index.jsp");
    }

}
           

ReaderAction

package Action;
/**
 * 讀者管理
 */

import Dao.IODao;
import Dao.ReaderDao;
import Entity.Log;
import Entity.Reader;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.ArrayList;


public class ReaderAction extends HttpServlet {
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String action = request.getParameter("action");
        request.setCharacterEncoding("UTF-8");
        response.setCharacterEncoding("UTF-8");
        response.setContentType("text/html; charset=utf-8");
        if (action.equals("QueryReaderById")) {
            this.QueryReaderById(request, response);
        } else if (action.equals("GetBorrowListById")) {
            this.GetBorrowListById(request, response);
        } else if (action.equals("GetAllReader")) {
            this.GetAllReader(request, response);
        } else if (action.equals("SetBlackList")) {
            this.SetBlackList(request, response);
        }
    }

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doPost(request, response);
    }

    protected void QueryReaderById(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String readerid = request.getParameter("readerid");
        ReaderDao readerDao = new ReaderDao();
        Reader reader = readerDao.QueryReaderById(readerid);
        String stauts = (reader.getStatus() == 1) ? "正常" : "異常";
        String callback = reader.getName() + "||" + reader.getGrade() + "年級" + reader.getClassnum() + "班||" + stauts + "||" + reader.getBorrow();
        PrintWriter out = response.getWriter();
        out.write(callback);
    }

    protected void GetBorrowListById(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String id = request.getParameter("readerid");
        IODao ioDao = new IODao();
        ArrayList<Log> loglist = ioDao.QueryBorrowNumByReaderid(id);
        HttpSession session = request.getSession();
        session.setAttribute("loglist", loglist);
        request.getRequestDispatcher("/borrow-list.jsp").forward(request, response);
    }

    protected void GetAllReader(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        ReaderDao readerDao = new ReaderDao();
        ArrayList<Reader> readerlist = readerDao.GetAllReader();
        HttpSession session = request.getSession();
        session.setAttribute("readerlist", readerlist);
        request.getRequestDispatcher("/reader-list.jsp").forward(request, response);
    }

    protected void SetBlackList(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String username = request.getParameter("id");
        String edit = request.getParameter("edit");
        ReaderDao readerDao = new ReaderDao();
        if (edit.equals("設定為正常")) {
            readerDao.SetBlackList(username, true);
        } else {
            readerDao.SetBlackList(username, false);
        }
        this.GetAllReader(request, response);
    }
}
           

四、其他

1.其他系統實作

1.JavaWeb系統系列實作

Java+JSP實作學生圖書管理系統

Java+JSP實作學生資訊管理系統

Java+JSP實作使用者資訊管理系統

Java+Servlet+JSP實作航空訂票系統

Java+Servlet+JSP實作新聞釋出系統

Java+Servlet+JSP實作停車場管理系統

Java+Servlet+JSP實作學生資訊管理系統

Java+Servlet+JSP實作學生選課管理系統

Java+Servlet+JSP實作學生成績管理系統-1

Java+Servlet+JSP實作學生成績管理系統-2

Java+Servlet+JSP實作寵物診所管理系統

Java+SSM+JSP實作網上考試系統

Java+SSH+JSP實作線上考試系統

Java+SSH+JSP實作醫院線上挂号系統

Java+Springboot+Mybatis+Bootstrap+Maven實作網上商城系統

2.JavaSwing系統系列實作

Java+Swing實作鬥地主遊戲

Java+Swing實作圖書管理系統

Java+Swing實作醫院管理系統

Java+Swing實作考試管理系統

Java+Swing實作倉庫管理系統-1

Java+Swing實作倉庫管理系統-2

Java+Swing實作自助取款機系統

Java+Swing實作通訊錄管理系統

Java+Swing實作停車場管理系統

Java+Swing實作學生資訊管理系統

Java+Swing實作學生宿舍管理系統

Java+Swing實作學生選課管理系統

Java+Swing實作學生成績管理系統

Java+Swing實作學校教材管理系統

Java+Swing實作學校教務管理系統

Java+Swing實作企業人事管理系統

Java+Swing實作電子相冊管理系統

Java+Swing實作超市管理系統-TXT存儲資料

Java+Swing實作自助取款機系統-TXT存儲資料

Java+Swing實作寵物商店管理系統-TXT存儲資料

2.擷取源碼

點選以下連結擷取源碼,資料庫檔案在sql檔案下面。

Java+JSP+Servlet+Mysql實作Web圖書管理系統

3.運作項目

請點選以下連結,部署你的項目。

IDEA如何導入JavaWeb項目超詳細視訊教程

4.備注

如有侵權請聯系我删除。

5.支援部落客

如果您覺得此文對您有幫助,請點贊加關注加收藏。祝您生活愉快!想要擷取其他資源可關注左側微信公衆号擷取!

IDEA+Java+Servlet+JSP+Mysql實作Web圖書管理系統【建議收藏】一、系統介紹二、系統展示  三、部分代碼四、其他