JavaWeb购物系统

 

 

 

 

 

 

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本

在购买算法与数据结构:

点击删除算法与数据结构:

 

 

  • 4
    点赞
  • 38
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 1
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

喵俺第一专栏

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值