基于javaweb+mysql的网上书店图书商城(前台、后台)

基于javaweb+mysql的网上书店图书商城(前台、后台)

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

eclipse/idea/myeclipse/sts等均可配置运行

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

功能说明

前台：登录注册、管理个人信息、修改密码、收藏图书、下单购买

后台：管理个人信息、书籍管理、分类管理、图书管理、订单管理、用户管理、添加管理员，销售统计信息

前台

后台

技术框架

JSP Servlet MySQL JDBC Tomcat CSS JavaScript bootstrap jquery

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

    <div class="container-fluid">
        <div id="carousel-example-generic" class="carousel slide"
             data-ride="carousel">
            <!-- 轮播图的中的小点 -->
            <ol class="carousel-indicators">
                <li data-target="#carousel-example-generic" data-slide-to="0"
                    class="active"></li>
                <li data-target="#carousel-example-generic" data-slide-to="1"></li>
                <li data-target="#carousel-example-generic" data-slide-to="2"></li>
                <li data-target="#carousel-example-generic" data-slide-to="3"></li>
                <li data-target="#carousel-example-generic" data-slide-to="4"></li>
            </ol>
            <!-- 轮播图的轮播图片 -->
            <div class="carousel-inner" role="listbox">

		if (op.equals("faHuo")) {
			faHuo(req, resp);
		}
		//删除订单
		if(op.equals("deletes")) {
			deletes(req,resp);
		}
	}

	private void deletes(HttpServletRequest req, HttpServletResponse resp) throws IOException {
		String orderNumber = req.getParameter("orderNum");
		Order findOrderByNum = service.findOrderByNum(orderNumber);
		if(findOrderByNum.getItems().size()!=0) {
			resp.getWriter().print("<script>alert('该订单下有订单子项不可删除,请先删除订单子项!')</script>");

	// 添加到收藏
	@Override
	public void addfavorite(String favorite_id, String user_id, String book_id) {
   
		try {
   
			Connection connection = Util.getConnection();
			PreparedStatement prepareStatement = connection
					.prepareStatement("insert into favorite (favorite_id,user_id,book_id) values (?,?,?)");
			prepareStatement.setString(1, favorite_id);
			prepareStatement.setString(2, user_id);
			prepareStatement.setString(3, book_id);
			prepareStatement.executeUpdate();
		} catch (SQLException e) {
   
			e.printStackTrace();
		}

	}

	// 根据用户查找收藏

			ResultSet rs = preparedStatement.executeQuery();
			while (rs.next()) {
   
				Category category = new Category();
				category.setCategory_id(rs.getString("category_id"));
				category.setCategory_name(rs.getString("category_name"));
				category.setCategory_desc(rs.getString("category_desc"));
				list.add(category);
			}
		} catch (Exception e) {
   
			e.printStackTrace();
		}
		return list;
	}

	// ͨ跟据分类id查询分类
	@Override
	public Category findCategoryById(String categoryid) {
   
		Category category = new Category();
		try {
   
			Connection connection = Util.getConnection();
			PreparedStatement prepareStatement = connection
					.prepareStatement("select * from category where category_id = ?");
			prepareStatement.setString(1, categoryid);
			ResultSet rs = prepareStatement.executeQuery();
			if (rs.next()) {
   

				cate