protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { BookDao dao = new BookDao(); if (request.getParameter("type") == null || request.getParameter("type").equals("全部类型")) { request.getSession().setAttribute("queryBooks", dao.queryBook(null, BookDao.QUERY_BY_TYPE)); } else { LinkedList<Book> list = dao.queryBook(request.getParameter("type"), BookDao.QUERY_BY_TYPE); request.getSession().setAttribute("queryBooks", list); } request.getSession().setAttribute("who", "book"); request.getRequestDispatcher("/back_stage.jsp").forward(request, response); dao.giveBack(); }
public List<BookMarkVo> getUserBookSimilar(int user1, int user2) { BookDao bd = new BookDao(); List<BookMarkVo> m1 = bd.getBookAndGradeByUserId(user1); List<BookMarkVo> m2 = bd.getBookAndGradeByUserId(user2); List<BookMarkVo> list = new ArrayList<BookMarkVo>(); int i = 0; for (BookMarkVo bookMarkVo : m1) { if (Tribuscontains(m2, bookMarkVo)) { i++; list.add(bookMarkVo); } } return list; }
public static void bindBook(String sql) { DefaultTableModel dtm = new DefaultTableModel() { @Override public boolean isCellEditable(int arg0, int arg1) { // TODO Auto-generated method stub return false; // 表中数据不能改 } }; dtm.addColumn("书籍ID"); dtm.addColumn("图书"); dtm.addColumn("出版社"); dtm.addColumn("价格"); dtm.addColumn("作者"); dtm.addColumn("ISDN码"); dtm.addColumn("条形码"); dtm.addColumn("是否在库"); BookDao dao = new BookDao(); ArrayList<Book> list = dao.getAllBook(sql); for (Book book : list) { Vector vec = new Vector(); int bkid = book.getBkid(); String bkname = book.getBkname(); String bkconcern = book.getBkconcern(); String bkprice = book.getBkprice(); String bkwriter = book.getBkwriter(); String bkisdn = book.getBkisdn(); String bkbarcord = book.getBkbarcord(); int a = book.getBkstatus(); String ee = (a == 1 ? "在库" : "不在库"); vec.add(bkid); vec.add(bkname); vec.add(bkconcern); vec.add(bkprice); vec.add(bkwriter); vec.add(bkisdn); vec.add(bkbarcord); vec.add(ee); dtm.addRow(vec); } table.setModel(dtm); }
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String bookname = request.getParameter("bookname"); byte[] bytes = bookname.getBytes("ISO-8859-1"); bookname = new String(bytes, "UTF-8"); HttpSession session = request.getSession(); BookDao dao = new BookDao(); LinkedList<Book> list = new LinkedList<>(); LinkedList<Book> sessionkList = (LinkedList<Book>) session.getAttribute("queryBooks"); if (sessionkList != null) { for (Book book : sessionkList) { if (book.getName().contains(bookname)) { list.add(book); break; } } } session.setAttribute("queryBooks", list); session.setAttribute("who", "book"); // 显示书 request.getRequestDispatcher("/back_stage.jsp").forward(request, response); dao.giveBack(); }
public static void bindBook() { BookDao dao = new BookDao(); ArrayList<Book> list = dao.getAllBook(); DefaultTableModel dtm = new DefaultTableModel() { @Override public boolean isCellEditable(int row, int column) { // TODO Auto-generated method stub return false; } }; dtm.addColumn("书籍ID"); dtm.addColumn("图书"); dtm.addColumn("出版社"); dtm.addColumn("价格"); dtm.addColumn("作者"); dtm.addColumn("ISDN码"); dtm.addColumn("条形码"); dtm.addColumn("是否在库"); for (Book book : list) { Vector vec = new Vector(); int bkid = book.getBkid(); String bkname = book.getBkname(); String bkconcern = book.getBkconcern(); String bkprice = book.getBkprice(); String bkwriter = book.getBkwriter(); String bkisdn = book.getBkisdn(); String bkbarcord = book.getBkbarcord(); int a = book.getBkstatus(); String ee = (a == 1 ? "在库" : "不在库"); vec.add(bkid); vec.add(bkname); vec.add(bkconcern); vec.add(bkprice); vec.add(bkwriter); vec.add(bkisdn); vec.add(bkbarcord); vec.add(ee); dtm.addRow(vec); } table.setModel(dtm); table.getColumnModel().getColumn(0).setMaxWidth(40); table.getColumnModel().getColumn(0).setMinWidth(40); table.getColumnModel().getColumn(1).setMaxWidth(220); table.getColumnModel().getColumn(1).setMinWidth(220); table.getColumnModel().getColumn(1).setPreferredWidth(220); table.getColumnModel().getColumn(2).setMaxWidth(130); table.getColumnModel().getColumn(2).setMinWidth(130); table.getColumnModel().getColumn(2).setPreferredWidth(130); table.getColumnModel().getColumn(3).setMaxWidth(50); table.getColumnModel().getColumn(3).setMinWidth(50); table.getColumnModel().getColumn(3).setPreferredWidth(50); table.getColumnModel().getColumn(4).setMaxWidth(220); table.getColumnModel().getColumn(4).setMinWidth(220); table.getColumnModel().getColumn(4).setPreferredWidth(220); table.getColumnModel().getColumn(5).setMaxWidth(130); table.getColumnModel().getColumn(5).setMinWidth(130); table.getColumnModel().getColumn(5).setPreferredWidth(130); table.getColumnModel().getColumn(6).setMaxWidth(130); table.getColumnModel().getColumn(6).setMinWidth(130); table.getColumnModel().getColumn(6).setPreferredWidth(130); table.getColumnModel().getColumn(7).setMaxWidth(90); table.getColumnModel().getColumn(7).setMinWidth(90); table.getColumnModel().getColumn(7).setPreferredWidth(90); }