博客园

大项目之网上书城（七）——书页面以及加入购物车Servlet

大项目之网上书城（七）——书页面以及加入购物车Servlet

目录

主要改动

时间不多是常事啊，话说今天去机房打的代码，可能是因为桌子比较低（还是高？）总之很不适应，敲了几个小时之后背疼得厉害。。

咳咳，那么说改动，就是完善了下书的显示页面，同时完善了下各分类的主页，还有写了个添加图书到购物车的Servlet。还有就是给所有的页面的body都加了个width:1400px;margin:0 auto;也就是把整体居中，并且把宽度固定。因为今天去机房，电脑比我笔记本宽，页面显示就很丑。于是干脆固定下。哦，对了，还在数据库加了个事件，每天凌晨1点自动判断每本书是否是新书。

1.shu.jsp

代码

这个是服装类图书的shu.jsp，其他分类的类似。都是复制粘贴加小修。

<%@page import="java.util.HashMap"%>
<%@page import="java.util.Map"%>
<%@page import="cn.edu.bdu.mc.utils.CookieUtil"%>
<%@page import="cn.edu.bdu.mc.services.impls.BookServiceImpl"%>
<%@page import="cn.edu.bdu.mc.services.BookService"%>
<%@page import="cn.edu.bdu.mc.beans.Book"%>
<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<!DOCTYPE html>
<html>
<head>
	<% Map<String,String>map = new HashMap<String,String>();
	map.put("clothing","服装");
	map.put("food","食品");
	map.put("net_literature","网络文学");
	map.put("pai","好书拍卖");
	map.put("residence","家居");
	map.put("sport","运动户外");
	map.put("nursery","育婴童");
	BookService bookService = new BookServiceImpl();
	int er_id = Integer.parseInt(request.getParameter("er_id"));
	Book book = bookService.findBookByClazzAndEr_id("clothing",er_id);
	bookService.click(book.getBook_id());
	Cookie[] cookies = request.getCookies();
	Cookie cookie = CookieUtil.findCookieByName(cookies, "bookHistory");
	cookie.setValue(book.getBook_id()+"#"+cookie.getValue());
	cookie.setPath("/bookstore");
	if(cookie.getValue().split("#").length>5){
		cookie.setValue(cookie.getValue().substring(0,cookie.getValue().lastIndexOf("#")));
	}
	response.addCookie(cookie);
	%>
<title><%=book.getBook_name() %></title>
<style type="text/css">
	.inc{
		float:left;
		margin-left:3%;
		margin-top:1%;
		width:16%;
		height:90%;
		background-color:rgba(160,128,255,0.8);
	}
</style>
<script type="text/javascript" src="${pageContext.request.contextPath}/jquery-3.3.1/jquery-3.3.1.min.js"></script>
<script type="text/javascript" src="${pageContext.request.contextPath}/client/js/shu.js"></script>
</head>
<body style="background-color:#bbb;width:1400px;margin:0 auto">
<!-- 调用头部页面 -->
<div style="width:100%;height:100px;float:left">
<jsp:include page="/client/head.jsp"></jsp:include>
</div>
<!-- 通用内容体大小 -->
<div style="width:70%;height:886px;float:left;margin-left:15%;">
	<!-- 二级导航 -->
	<jsp:include page="/client/head2.jsp"></jsp:include>	
	<!-- 通用界面 -->
	<div style="width:100%;height:800px;float:left;margin-top:2%;background-color:#ccc;">
		<div style="width:100%;height:48%;float:left;margin-top:2%;margin-left:2%;">
			<div style="width:30%;height:100%;background-color:rgba(111,123,145,0.8);float:left">
				<img alt="图书" src="${pageContext.request.contextPath}/ShuImgById?book_id=<%=book.getBook_id() %>" style="width:100%;"/>
			</div>
			<div style="width:60%;margin-left:8%;height:100%;float:left">
				<h2 style="margin-left:2%;float:left;width:94%"><%=book.getBook_name() %>(一本你不容错过的好书！)</h2>
				<p style="margin-left:2%;float:left;width:94%;height:30%;">详情：<%=book.getDescribtion() %><a style="margin-left:2%;" href="./">点击</a>查看更多同类好书！</p>
				<h2 style="margin-left:2%;margin-top:1%;float:left;width:94%;color:rgba(200,0,0,0.8);text-align:center;background-color:rgba(64,123,233,0.4);height:18%;line-height:200%;">惊爆价：<%=book.getPrice() %>&nbsp;元&nbsp;&nbsp;&nbsp;&nbsp;
					<font style="color:rgba(0,0,0,0.6);font-size:24px;"><del>原价：<%double price = (int)(book.getPrice()*1.4)-0.01; %><%=price %>&nbsp;元</del></font>
				</h2>
				<font style="margin-left:2%;margin-top:1%;float:left;width:94%;font-size:16px;">类别：<%=map.get(book.getClazz()) %></font>
				<font style="margin-left:2%;margin-top:1%;float:left;font-size:16px;">点击量：<%=book.getClick_num() %></font>
				<font style="margin-left:2%;margin-top:1%;float:left;font-size:16px;">购买量：<%=book.getBuy_num() %></font>
				<font style="margin-left:2%;margin-top:1%;float:left;font-size:16px;">热度：<%=book.getRe_du() %></font>
				<font style="margin-left:2%;margin-top:1%;float:left;width:94%;font-size:16px;">剩余数量：<%=book.getCount() %></font>
				<% if(request.getSession().getAttribute("user")==null){ %>
					<font style="margin-left:2%;margin-top:1%;float:left;"><a href="${pageContext.request.contextPath}/client/login.jsp">登录</a>后可购买书籍。</font>
				<% }else{ %>
					<a style="margin-left:2%;margin-top:1%;float:left;" href="${pageContext.request.contextPath}/AddIntoCart?book_id=<%=book.getBook_id() %>">加入购物车</a>&nbsp;&nbsp;&nbsp;&nbsp;
					<a style="margin-left:2%;margin-top:1%;float:left;" href="${pageContext.request.contextPath}/NewOrder?book_id_list=<%=book.getBook_id() %>">购买</a>
				<% } %>
			</div>
		</div>
		<div style="width:96%;height:40%;float:left;margin-top:2%;margin-left:2%;">
			<div style="width:100%;height:15%;text-align:center;line-height:50px;background-color:rgba(85,107,47,0.8);float:left">
				<font color="#ddd" style="font-size:20px;">为您推荐热门书籍</font>
			</div>
			<div style="width:100%;height:85%;text-align:center;line-height:45px;background-color:rgba(85,139,84,0.8);float:left">
				<div class="inc" style="margin-left:4%">
					<img alt="图书" src="${pageContext.request.contextPath}/XinShuImg?shu=1" style="width:100%;height:100%" id="re1"/>
				</div>
				<div class="inc">
					<img alt="图书" src="${pageContext.request.contextPath}/XinShuImg?shu=2" style="width:100%;height:100%" id="re2"/>
				</div>
				<div class="inc">
					<img alt="图书" src="${pageContext.request.contextPath}/XinShuImg?shu=3" style="width:100%;height:100%" id="re3"/>
				</div>
				<div class="inc">
					<img alt="图书" src="${pageContext.request.contextPath}/XinShuImg?shu=4" style="width:100%;height:100%" id="re4"/>
				</div>
				<div class="inc">
					<img alt="图书" src="${pageContext.request.contextPath}/XinShuImg?shu=5" style="width:100%;height:100%" id="re5"/>
				</div>
			</div>
		</div>
	</div>
</div>
<!-- 调用底部页面 -->
<div style="width:100%;height:60px;float:left">
<jsp:include page="/client/foot.jsp"></jsp:include>
</div>
</body>
</html>

效果图


2.shu.js

代码

$(function(){
	$("img").each(function(){
		$(this).css("height",$(this).parent().css("height"));
	});
	$("#re1").click(function(){
		$.post("../../XinShuMing?shu=1",function(data){
			window.location.href="../"+data.split("@")[2];
		});
	});
	$("#re2").click(function(){
		$.post("../../XinShuMing?shu=2",function(data){
			window.location.href="../"+data.split("@")[2];
		});
	});
	$("#re3").click(function(){
		$.post("../../XinShuMing?shu=3",function(data){
			window.location.href="../"+data.split("@")[2];
		});
	});
	$("#re4").click(function(){
		$.post("../../XinShuMing?shu=4",function(data){
			window.location.href="../"+data.split("@")[2];
		});
	});
	$("#re5").click(function(){
		$.post("../../XinShuMing?shu=5",function(data){
			window.location.href="../"+data.split("@")[2];
		});
	});
});

3.index.jsp

代码

同样只放服装类图书的主页。

<%@page import="cn.edu.bdu.mc.services.impls.BookServiceImpl"%>
<%@page import="cn.edu.bdu.mc.beans.Book"%>
<%@page import="java.util.List"%>
<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<!DOCTYPE html>
<html>
<head>
<title>主页</title>
<style type="text/css">
	.inc{
		float:left;
		margin-left:3%;
		margin-top:4%;
		width:16%;
		height:25%;
		background-color:rgba(160,128,255,0.8);
	}
</style>
<script type="text/javascript" src="${pageContext.request.contextPath}/jquery-3.3.1/jquery-3.3.1.min.js"></script>
<script type="text/javascript">
$(function(){
		$("img").click(function(){
			var book_id=$(this)[0].src.split("=")[1];
			if(book_id!=0){
				$.post("../../FindPageById?book_id="+book_id,function(data){
					window.location.href=data.split("/")[1];
				});
			}
		});
});
</script>
</head>
<body style="background-color:#bbb;width:1400px;margin:0 auto">
<!-- 调用头部页面 -->
<div style="width:100%;height:100px;float:left">
<jsp:include page="/client/head.jsp"></jsp:include>
</div>
<!-- 通用内容体大小 -->
<div style="width:70%;height:886px;float:left;margin-left:15%;">
	<!-- 二级导航 -->
	<jsp:include page="/client/head2.jsp"></jsp:include>	
	<img id="a1">
	<!-- 通用界面 -->
	<div style="width:100%;height:800px;float:left;margin-top:2%;background-color:#ccc;">
		<% List<Book>list = new BookServiceImpl().findBookByClazz("clothing");
			int i=1;
			for(Book book:list){
				if(i>15){break;}%>
			<div class="inc" <%if(i%5==1){ %>style="margin-left:4%"<%} %>>
				<img alt="图书" src="${pageContext.request.contextPath}/ShuImgById?book_id=<%=book.getBook_id() %>" style="width:100%;height:100%;float:left;"/>
			</div>
				<%
			};
		%>
	</div>
</div>
<!-- 调用底部页面 -->
<div style="width:100%;height:60px;float:left">
<jsp:include page="/client/foot.jsp"></jsp:include>
</div>
</body>
</html>

效果图

4.FindBookByClazz

代码

@Override
	public List<Book> findBookByClazz(String clazz) throws SQLException {
		List<Book> list = dao.findAllBook();
		List<Book> newList = new ArrayList<>();
		//lambda表达式，emmmm，的确可读性不太好的样子。
		list.forEach(book->{if(book.getClazz().equals(clazz)){newList.add(book);}});
		/*
        	相当于
			for (Book book : newList) {
				if(book.getClazz().equals(clazz)){
					newList.add(book);
				}
			}
        */
		return newList;
	}

5.mysql判断是否新书事件

代码

同样是从sql文件里摘出来的，不知道能不能行，我本身对事件不是太了解。

DELIMITER ;;
CREATE DEFINER=`root`@`localhost` EVENT `temp_event` ON SCHEDULE EVERY 1 DAY STARTS '2019-06-21 01:00:00' ON COMPLETION PRESERVE ENABLE DO update book set is_new=0 where TO_DAYS(now())-TO_DAYS(book.insert_date)>2
;;
DELIMITER ;

6.AddIntoCartServlet

代码

package cn.edu.bdu.mc.servlets;

import java.io.IOException;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

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 cn.edu.bdu.mc.beans.Book;
import cn.edu.bdu.mc.daos.impls.BookDaoImpl;
import cn.edu.bdu.mc.services.impls.BookServiceImpl;

/**
 * Servlet implementation class AddIntoCartServlet
 */
@WebServlet("/AddIntoCart")
public class AddIntoCartServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public AddIntoCartServlet() {
        super();
        // TODO Auto-generated constructor stub
    }

	/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		try {
			int book_id = Integer.parseInt(request.getParameter("book_id"));
			HttpSession session = request.getSession();
			List<Book> cart = (List<Book>) session.getAttribute("cart");
			if(cart==null) {
				cart = new ArrayList<Book>();
				session.setAttribute("cart", cart);
			}
			cart.add(new BookDaoImpl().findBookById(book_id));
			String htmlCode="<!DOCTYPE html>\n" + 
					"<html>"
					+ "<head>"
					+ "<link rel=\"stylesheet\" href=\""+request.getContextPath()+"/bootstrap-3.3.7-dist/css/bootstrap.min.css\">"
					+ "</head>"
					+ "<body>"
					+ "<div style=\"position:absolute;left:44%;top:46%;height:100px;width:240px;background-color:rgba(145, 162, 196, 0.9);border:1px;text-align:center;\"id=\"quit1\">\r\n" + 
					"	<h3>加入购物车成功！</h3><a class=\"btn btn-info\" href=\""+request.getContextPath()+"/client/index.jsp\">继续购买</a>&nbsp;&nbsp;&nbsp;&nbsp;"
							+"<a class=\"btn btn-info\" href=\""+request.getContextPath()+"/client/cart.jsp\">查看购物车</a>\n" + 
					"</div>"
					+ "</body>"
					+ "</html>";
			response.getWriter().write(htmlCode);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		doGet(request, response);
	}

}

效果图

posted @ 2019-06-20 22:38  return_false  阅读(1485)  评论(0)  编辑  收藏  举报