Exemple #1
0
  @Override
  public List<?> extractData(ResultSet rs) {
    List<BCopies> bcopies = new ArrayList<BCopies>();
    BookDAO bdao = new BookDAO(conn);

    try {
      while (rs.next()) {
        BCopies a = new BCopies();
        Book book = new Book();
        Branch branch = new Branch();
        book.setBookId(rs.getInt("bookId"));
        try {
          book = bdao.getBook(book.getBookId());
        } catch (ClassNotFoundException e) {
          // TODO Auto-generated catch block
          e.printStackTrace();
        }
        branch.setBranchId(rs.getInt("branchId"));
        branch.setBranchName(rs.getString("branchName"));
        a.setNoofCopies(rs.getInt("noOfCopies"));
        a.setBook(book);
        a.setBranch(branch);
        bcopies.add(a);
      }
    } catch (SQLException e) {
      e.printStackTrace();
    }

    return bcopies;
  }
Exemple #2
0
  /** *******************图书借阅********************** */
  private void bookborrow(HttpServletRequest request, HttpServletResponse response)
      throws ServletException, IOException {
    // 查询读者信息
    readerForm.setBarcode(request.getParameter("barcode"));
    ReaderForm reader = (ReaderForm) readerDAO.queryM(readerForm);
    request.setAttribute("readerinfo", reader);
    // 查询读者的借阅信息
    request.setAttribute("borrowinfo", borrowDAO.borrowinfo(request.getParameter("barcode")));
    // 完成借阅
    String f = request.getParameter("f");
    String key = request.getParameter("inputkey");
    if (key != null && !key.equals("")) {
      String operator = request.getParameter("operator");
      BookForm bookForm = bookDAO.queryB(f, key);
      if (bookForm != null) {
        int ret = borrowDAO.insertBorrow(reader, bookDAO.queryB(f, key), operator);
        if (ret == 1) {
          request.setAttribute("bar", request.getParameter("barcode"));
          request.getRequestDispatcher("bookBorrow_ok.jsp").forward(request, response);

        } else {
          request.setAttribute("error", "添加借阅信息失败!");
          request.getRequestDispatcher("error.jsp").forward(request, response);
        }
      } else {
        request.setAttribute("error", "没有该图书!");
        request.getRequestDispatcher("error.jsp").forward(request, response);
      }
    } else {
      request.getRequestDispatcher("bookBorrow.jsp").forward(request, response);
    }
  }
 @RequestMapping(
     value = "/deleteBook",
     method = {RequestMethod.GET, RequestMethod.POST},
     consumes = "application/json")
 public List<Book> deleteBook(@RequestBody Book book) {
   bookdao.deleteBook(book);
   return bookdao.getAllBooks(1, 5);
 }
 @RequestMapping(
     value = "/getBooksCount",
     method = {RequestMethod.GET, RequestMethod.POST},
     produces = "application/json")
 public int getBooksCount() {
   return bookdao.getBooksCount();
 }
 @RequestMapping(
     value = "/editBook",
     method = {RequestMethod.GET, RequestMethod.POST},
     consumes = "application/json")
 public void editBook(@RequestBody List<Book> books) {
   for (Book book : books) bookdao.updateBook(book);
 }
 /*Admin Book*/
 @RequestMapping(
     value = "/getBooks/{pageNo}/{pageSize}",
     method = {RequestMethod.GET, RequestMethod.POST},
     produces = "application/json")
 public List<Book> getBooks(@PathVariable int pageNo, @PathVariable int pageSize) {
   return bookdao.getAllBooks(pageNo, pageSize);
 }
 @RequestMapping(
     value = "/getBooksByName/{searchString}/{pageNo}/{pageSize}",
     method = {RequestMethod.GET, RequestMethod.POST},
     produces = "application/json")
 public List<Book> getBooksByName(
     @PathVariable String searchString, @PathVariable int pageNo, @PathVariable int pageSize) {
   return bookdao.getBooksByName(searchString, pageNo, pageSize);
 }
 /**
  * The doPost method of the servlet. <br>
  * This method is called when a form has its tag value method equals to post.
  *
  * @param request the request send by the client to the server
  * @param response the response send by the server to the client
  * @throws ServletException if an error occurred
  * @throws IOException if an error occurred
  */
 public void doPost(HttpServletRequest request, HttpServletResponse response)
     throws ServletException, IOException {
   request.setCharacterEncoding("UTF-8");
   response.setContentType("text/html;charset=UTF-8");
   // System.out.println("test");
   // Get book ID from request header
   String id = request.getParameter("bookID");
   BookDAO bookDao = new BookDAO();
   try {
     Book book = bookDao.getBookById(id);
     if (book != null) {
       // Send it to next jsp to handle it
       request.setAttribute("book", book);
       request.getRequestDispatcher("/updateBook.jsp").forward(request, response);
     }
   } catch (DocumentException e) {
     e.printStackTrace();
   }
 }
Exemple #9
0
 @Override
 public List extractData(ResultSet rs) throws Exception {
   List<Genre> genres = new ArrayList<Genre>();
   BookDAO bdao = new BookDAO(getConnection());
   while (rs.next()) {
     Genre g = new Genre();
     g.setGenreId(rs.getInt("genre_id"));
     g.setGenreName(rs.getString("genre_name"));
     @SuppressWarnings("unchecked")
     List<Book> books =
         (List<Book>)
             bdao.readFirstLevel(
                 "select * from tbl_book where bookId In"
                     + "(select bookId from tbl_book_genres where genreId=?)",
                 new Object[] {rs.getInt("genreId")});
     genres.add(g);
   }
   return genres;
 }
Exemple #10
0
  @Override
  public List<Author> extractData(ResultSet rs) throws Exception {
    List<Author> authors = new ArrayList<Author>();
    BookDAO bDao = new BookDAO(getConnection());

    while (rs.next()) {
      Author a = new Author();
      a.setAuthorId(rs.getInt("authorId"));
      a.setAuthorName(rs.getString("authorName"));
      @SuppressWarnings("unchecked")
      List<Book> books =
          (List<Book>)
              bDao.readFirstLevel(
                  "select * from tbl_book where bookId In"
                      + "(select bookId from tbl_book_authors where authorId=?)",
                  new Object[] {rs.getInt("authorId")});
      a.setBooks(books);
      authors.add(a);
    }
    return authors;
  }