code088.jsp
1<%@page import="pack02.code086"%> 2<%@page import="java.util.List"%> 3<%@ page language="java" contentType="text/html; charset=UTF-8" 4 pageEncoding="UTF-8"%> 5<!DOCTYPE html> 6<html> 7<head> 8<meta charset="UTF-8"> 9<title>通过存储过程获取数据</title> 10</head> 11<body> 12<jsp:useBean id="findBook" class="pack02.code087"></jsp:useBean> 13<table border="1"> 14 <tr> 15 <td colspan="5">所有图书信息</td> 16 </tr> 17 <tr> 18 <td>ID</td> 19 <td>图书名称</td> 20 <td>价格</td> 21 <td>数量</td> 22 <td>作者</td> 23 </tr> 24 <% 25 List<code086> list1 = findBook.findAll(); 26 if(list1 == null || list1.size() < 1) 27 { 28 out.println("没有数据！"); 29 } 30 else 31 { 32 for(code086 book : list1) 33 { 34 %> 35 36 <tr> 37 <td><%= book.getId() %></td> 38 <td><%= book.getName() %></td> 39 <td><%= book.getPirce() %></td> 40 <td><%= book.getBookCount() %></td> 41 <td><%= book.getAuthor() %></td> 42 </tr> 43 44 <% 45 } 46 } 47 %> 48 49<%-- 50mysql中的存储过程 51delimiter $$ 52create procedure findAllBook() 53begin 54 select * from tb_books order by id desc; 55end $$ 56delimiter; 57--%> 58</table> 59</body> 60</html>