本文接著上一篇圖書(shū)商城分類模塊進(jìn)行學(xué)習(xí)，供大家參考，具體內(nèi)容如下
1、創(chuàng)建相關(guān)類
cn.itcast.bookstore.book
domain：Book
dao：BookDao
service :BookService
web.servle：BookServlet
Book
|
1
2
3
4
5
6
7
8
9
|
public class Book { private String bid; private String bname; private double price; private String author; private String image; private Category category; private boolean del;} |
BookDao
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
|
public class BookDao { private QueryRunner qr = new TxQueryRunner(); /** * 查詢所有圖書(shū) * @return */ public List<Book> findAll() { try { String sql = "select * from book where del=false"; return qr.query(sql, new BeanListHandler<Book>(Book.class)); } catch(SQLException e) { throw new RuntimeException(e); } } /** * 按分類查詢 * @param cid * @return */ public List<Book> findByCategory(String cid) { try { String sql = "select * from book where cid=? and del=false"; return qr.query(sql, new BeanListHandler<Book>(Book.class), cid); } catch(SQLException e) { throw new RuntimeException(e); } } /** * 加載方法 * @param bid * @return */ public Book findByBid(String bid) { try { /* * 我們需要在Book對(duì)象中保存Category的信息 */ String sql = "select * from book where bid=?"; Map<String,Object> map = qr.query(sql, new MapHandler(), bid); /* * 使用一個(gè)Map，映射出兩個(gè)對(duì)象，再給這兩個(gè)對(duì)象建立關(guān)系！ */ Category category = CommonUtils.toBean(map, Category.class); Book book = CommonUtils.toBean(map, Book.class); book.setCategory(category); return book; } catch(SQLException e) { throw new RuntimeException(e); } } /** * 查詢指定分類下的圖書(shū)本數(shù) * @param cid * @return */ public int getCountByCid(String cid) { try { String sql = "select count(*) from book where cid=?"; Number cnt = (Number)qr.query(sql, new ScalarHandler(), cid); return cnt.intValue(); } catch(SQLException e) { throw new RuntimeException(e); } } /** * 添加圖書(shū) * @param book */ public void add(Book book) { try { String sql = "insert into book values(?,?,?,?,?,?)"; Object[] params = {book.getBid(), book.getBname(), book.getPrice(), book.getAuthor(), book.getImage(), book.getCategory().getCid()}; qr.update(sql, params); } catch(SQLException e) { throw new RuntimeException(e); } } /** * 刪除圖書(shū) * @param bid */ public void delete(String bid) { try { String sql = "update book set del=true where bid=?"; qr.update(sql, bid); } catch(SQLException e) { throw new RuntimeException(e); } } public void edit(Book book) { try { String sql = "update book set bname=?, price=?,author=?, image=?, cid=? where bid=?"; Object[] params = {book.getBname(), book.getPrice(), book.getAuthor(), book.getImage(), book.getCategory().getCid(), book.getBid()}; qr.update(sql, params); } catch(SQLException e) { throw new RuntimeException(e); } }} |
BookService
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
|
public class BookService { private BookDao bookDao = new BookDao(); /** * 查詢所有圖書(shū) * @return */ public List<Book> findAll() { return bookDao.findAll(); } /** * 按分類查詢圖書(shū) * @param cid * @return */ public List<Book> findByCategory(String cid) { return bookDao.findByCategory(cid); } public Book load(String bid) { return bookDao.findByBid(bid); } /** * 添加圖書(shū) * @param book */ public void add(Book book) { bookDao.add(book); } public void delete(String bid) { bookDao.delete(bid); } public void edit(Book book) { bookDao.edit(book); }} |
BookServlet
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
|
public class BookServlet extends BaseServlet { private BookService bookService = new BookService(); public String load(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { /* * 1. 得到參數(shù)bid * 2. 查詢得到Book * 3. 保存，轉(zhuǎn)發(fā)到desc.jsp */ request.setAttribute("book", bookService.load(request.getParameter("bid"))); return "f:/jsps/book/desc.jsp"; } /** * 查詢所有圖書(shū) * @param request * @param response * @return * @throws ServletException * @throws IOException */ public String findAll(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setAttribute("bookList", bookService.findAll()); return "f:/jsps/book/list.jsp"; } /** * 按分類查詢 * @param request * @param response * @return * @throws ServletException * @throws IOException */ public String findByCategory(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String cid = request.getParameter("cid"); request.setAttribute("bookList", bookService.findByCategory(cid)); return "f:/jsps/book/list.jsp"; }} |
2、查詢所有圖書(shū)
流程：left.jsp（全部分類） -> BookServlet#findAll() -> /jsps/book/list.jsp
3、按分類查詢圖書(shū)
流程：left.jsp -> BookServlet#findByCategory() -> list.jsp
4、查詢?cè)敿?xì)信息（加載）
流程：list.jsp（點(diǎn)擊某一本書(shū)） -> BookServlet#load() -> desc.jsp
以上就是本文的全部?jī)?nèi)容，希望對(duì)大家的學(xué)習(xí)有所幫助，也希望大家多多支持服務(wù)器之家。
