BookDao.java类 :
package Dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.HashMap;
import Vo.Book;
public class BookDao {
private Connection conn = null;
//连接数据库的方法
public void initConnection() throws Exception{
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/book130?useUnicode=true&characterEncodeing=utf-8","root","123456");
}
//获取所有图书,并存入到Book的属性中,返回一个HshMap集合
public HashMap getAllBook() throws Exception{
HashMap hm = new HashMap();
this.initConnection();
Statement stat = conn.createStatement();
String sql = "select bookno,bookname,bookprice from 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;
}
//关闭数据库
public void closeConnection() throws Exception{
conn.close();
}
}
Book.java类:
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;
}
@Override
public String toString() {
return "Book [bookno=" + bookno + ", bookname=" + bookname + ", bookprice=" + bookprice + ", booknumber="
+ booknumber + "]";
}
}
SessionListener.java监听器类:监听Session创建购物车
本例中自己用监听器出现了空指针异常,所以,把创建购物车的代码也写到了InitServlet.java里面
package Listener;
import java.util.HashMap;
import javax.servlet.annotation.WebListener;
import javax.servlet.http.HttpSession;
import javax.servlet.http.HttpSessionEvent;
import javax.servlet.http.HttpSessionListener;
//@WebListener
public class SessionListener implements HttpSessionListener{
@Override
public void sessionCreated(HttpSessionEvent event) {
System.out.println("sessionCreated1111111");
HttpSession session = event.getSession();
//初始化购物车
HashMap books = new HashMap();
session.setAttribute("books",books);
System.out.println("books"+books);
//初始化总钱数
session.setAttribute("money",0F);
}
@Override
public void sessionDestroyed(HttpSessionEvent arg0) {
// TODO Auto-generated method stub
}
}
index.jsp页面跳转到InitServlet.java从数据库获取数据,跳转到展示页面进行展示
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'index.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body>
<jsp:forward page="InitServlet"/>
</body>
</html>
InitServlet.java:
package Servlet;
import java.io.IOException;
import java.util.HashMap;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import Dao.BookDao;
@WebServlet("/InitServlet")
public class InitServlet extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
//初始化购物车
HttpSession session = request.getSession();
//初始化购物车
HashMap books = new HashMap();
session.setAttribute("books",books);
//初始化总钱数
session.setAttribute("money",0F);
BookDao bdao = new BookDao();
HashMap allbook = null;
try {
allbook = bdao.getAllBook();//获取所有图书
} catch (Exception e) {
e.printStackTrace();
}
request.getSession().setAttribute("allbook", allbook);//将所有图书存入到session集合
response.sendRedirect("showAllBook.jsp");//跳转到显示图书页面
}
}
展示页面showAllBook.jsp:
<%@page import="Vo.Book"%>
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'showAllBook.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body>
欢迎选购图书<br>
<%
HashMap allbook = (HashMap)session.getAttribute("allbook");//获取所有图书,进行显示
%>
<table border="1">
<tr bgcolor="pink">
<td>书本名称</td>
<td>书本价格</td>
<td>购买</td>
</tr>
<%
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>
</tr>
<%} %>
</table>
<a href="showCart.jsp">查看购物车</a>
</body>
</html>
购买页面,buyForm.jsp:
<%@page import="Vo.Book"%>
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'buyForm.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body>
<%
String bookno = request.getParameter("bookno");//获取上个页面的图书编号
HashMap allbook = (HashMap)session.getAttribute("allbook");//获取所有图书集合
Book book = (Book)allbook.get(bookno);//获取指定的图书
%>
欢迎购买:<%=book.getBookname()%>
<form action="AddServlet" method="post">
书本价格:<%=book.getBookprice()%><br>
<input name="bookno" type="hidden" value="<%=book.getBookno()%>">
<input name="bookname" type="hidden"
value="<%=book.getBookname()%>">
<input name="bookprice" type="hidden"
value="<%=book.getBookprice()%>">
数量:
<input name="booknumber" type="text">
<input type="submit" value="购买">
</form>
</body>
</html>
AddServlet.java:
package Servlet;
import java.io.IOException;
import java.util.HashMap;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import Vo.Book;
@WebServlet("/AddServlet")
public class AddServlet extends HttpServlet {
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("UTF-8");
//获取购物车session
HttpSession session = request.getSession();
//获取购物车books集合
HashMap books = (HashMap) session.getAttribute("books");
//获取提交的内容
String bookno = request.getParameter("bookno");
System.out.println(bookno + "--图书编号");
String bookname = request.getParameter("bookname");
String strBookprice = request.getParameter("bookprice");
String strBooknumber = request.getParameter("booknumber");
//存入购物车
Book book = new Book();
//为book对象赋值
book.setBookno(bookno);
float money = 0;
if(books.containsKey(bookno)){//第二次购买同一本书,判断集合中是否含有这本书,进行改变这本书的购买数量
book.setBookname(bookname);
float bookprice = Float.parseFloat(strBookprice);
book.setBookprice(bookprice);
int booknumber = Integer.parseInt(strBooknumber);//新购买的数量
System.out.println(booknumber);//控制台输出,测试新购买的数量
int number =((Book) books.get(bookno)).getBooknumber(); //获取原来的数量
System.out.println(number);//控制台输出,测试原来数量
int booknumber2=number+booknumber;
System.out.println(booknumber2);//测试控制台输出,总数量
book.setBooknumber(booknumber2);//控制台输出,测试重质量
books.put(bookno, book);//往购物车books集合里面存入购买的books
money = (Float) session.getAttribute("money");
money = money + bookprice * booknumber ; //计算总钱数
System.out.println(books + " second");
}else{//第一次购买执行else里面的操作
book.setBookname(bookname);
float bookprice = Float.parseFloat(strBookprice);
book.setBookprice(bookprice);
int booknumber = Integer.parseInt(strBooknumber);
book.setBooknumber(booknumber);
books.put(bookno, book);//往购物车books集合里面存入购买的books
//总钱数增加
money = (Float) session.getAttribute("money");
money = money + bookprice * booknumber;
System.out.println(books + " first");
}
session.setAttribute("money", money);//往购物车里存入钱数
session.setAttribute("books", books); //往购物车里存入书
response.sendRedirect("showCart.jsp");//跳转到展示购物车页面
}
}
购物车页面,showCart.jsp:
<%@page import="Vo.Book"%>
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'showCart.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body>
<table border="1">
<tr bgcolor="pink">
<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 bgcolor="yellow">
<td><%=book.getBookname()%></td>
<td><%=book.getBookprice()%></td>
<td><%=book.getBooknumber()%></td>
<td><a href="RemoveServlet?bookno=<%=book.getBookno()%>">删除</a></td>
</tr>
<%
}
%>
</table>
现金总额:<%=session.getAttribute("money")%><HR>
<a href="showAllBook.jsp">继续买书</a>
</body>
</html>
RemoveServlet.java:
package Servlet;
import java.io.IOException;
import java.util.HashMap;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import Vo.Book;
@WebServlet("/RemoveServlet")
public class RemoveServlet extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("UTF-8");
String bookno = request.getParameter("bookno");
HttpSession session = request.getSession();
HashMap books = (HashMap)session.getAttribute("books");//获取总的books
Book book = (Book)books.get(bookno);//获取删除的book
//总钱数减少
float money = (Float)session.getAttribute("money");//获取总钱数
//System.out.println("money总" + money);
//System.out.println("book.getBooknumber()" + book.getBooknumber());
//System.out.println("book.getBookprice()" + book.getBookprice());
money = money - book.getBooknumber()*book.getBookprice();//总钱数减去要删除的书的价格
session.setAttribute("money", money);//重新把价格存入购物车
//System.out.println("money删除后" + money);
//移除相应图书
books.remove(bookno);
response.sendRedirect("showCart.jsp");
}
}
结果:
点击购买Java:购买1本
在点击继续购买:Java2本
在购买算法与数据结构:
点击删除算法与数据结构: