下面是完整代码
1.BookDao.java
package dao;
import vo.Book;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.HashMap;
public class BookDao {
private Connection
conn=null;
public HashMap getAllBook() throws Exception{
HashMap hm=new HashMap();
this.intConnection();
Statement stat=conn.createStatement();
String sql=
"SELECT BOOKNO,BOOKNAME,BOOKPRICE FROM T_BOOK";
ResultSet rs =stat.executeQuery(sql);
while(rs.next()){
Book book=new Book();
book=new Book();
book.setBookno(rs.getString("bookno"));
book.setBookname(rs.getString("bookname"));
book.setBookprice(rs.getFloat("bookprice"));
hm.put(book.getBookno(),book);
}
this.closeConnection();
return hm;
}
private void intConnection() throws Exception{
Class.forName("sun.jdbc.odnc.JdbcOdbcDriver");
conn =
DriverManager.getConnection(“jdbc:mysql://localhost:3306/t_book”, “root”, “hedy201801”);
}
public void closeConnection()throws Exception{
conn.close();
}
}
2.Book.java(vo)
package vo;
public class Book {
private String bookno;
private String bookname;
private float bookprice;
private int booknumber;
public String getBookno(){
return bookno;
}
public void setBookno(String bookno) {
this.bookno = bookno;
}
public String getBookname() {
return bookname;
}
public void setBookname(String bookname) {
this.bookname = bookname;
}
public float getBookprice() {
return bookprice;
}
public void setBookprice(float bookprice) {
this.bookprice = bookprice;
}
public int getBooknumber() {
return booknumber;
}
public void setBooknumber(int booknumber) {
this.booknumber = booknumber;
}
}
3.showAllBook.jsp
<%@ page import=“java.util.HashMap” %>
<%@ page import=“java.util.Set” %>
<%@ page import=“java.util.Iterator” %>
<%@ page import=“dao.BookDao” %>
<%@ page import=“vo.Book” %><%–
Created by IntelliJ IDEA.
User: 97422
Date: 2020/7/10 0010
Time: 13:37
To change this template use File | Settings | File Templates.
–%>
<%@ page contentType=“text/html;charset=UTF-8” language=“java” pageEncoding=“gb2312” %>
<title>显示所有图书</title>
欢迎选购图书
<%
%>
<tr bgcolor="#ffc0cb">
<td>书本名称</td>
<td>书本价格</td>
<td>购买</td>
<tr/>
<%
HashMap allbook=(HashMap)session.getAttribute("allbook");
Set set = allbook.keySet();
Iterator ite=set.iterator();
while(ite.hasNext()){
String bookno =(String)ite.next();
Book book=(Book)allbook.get(bookno);
%>
<tr bgcolor="yellow">
<td><%=book.getBookname()%></td>
<td><%=book.getBookprice()%></td>
<td>< a href ="buyForm.jsp?bookno =<%=bookno%>">购买</>a></td>
<%}%>
4.showCart.jsp
<%@ page import=“java.util.Iterator” %>
<%@ page import=“java.util.Set” %>
<%@ page import=“java.util.HashMap” %>
<%@ page import=“vo.Book” %><%–
Created by IntelliJ IDEA.
User: 97422
Date: 2020/7/10 0010
Time: 13:38
To change this template use File | Settings | File Templates.
–%>
<%@ page contentType=“text/html;charset=UTF-8” language=“java” %>
<title>显示购物车内容</title>
<tr bgcolor="#ffc0cb">
<td>书本名称</td>
<td>书本价格</td>
<td>数量</td>
<td>删除</td>
</tr>
<%
HashMap books =(HashMap)session.getAttribute("books");
Set set=books.keySet();
Iterator ite =set.iterator();
while(ite.hasNext()){
String bookno=(String)ite.next();
Book book =(Book)books.get(bookno);
%>
<tr bagcolor ="yellow">
<td><%=book.getBookname()%></>td>
<td><%=book.getBookprice()%></>td>
<td><%=book.getBooknumber()%></>td>
<td><a href ="RemoveServlet?bookno=<%=book.getBookno()%>">删除</a></td>
</tr>
<%
}
%>
现金总额:<%=session.getAttribute(“money”)%>