Java Web 汽车网站系统程序设计

Love The Way You Lie 2023-07-24 03:18 2阅读 0赞

eclipse开发 Tomcat 8 MySQL数据库 JDK1.8

## 功能： ##

前台：登陆注册，汽车浏览，购物车，我的订单，公告展示  
后台：车辆管理，类别管理，公告管理，订单管理，用户管理

## 代码： ##

**Servlet**

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { 
            int id = Integer.parseInt(request.getParameter("id"));
            String method = request.getParameter("method");
            int typeTarget=Integer.parseInt(request.getParameter("typeTarget"));
            if(method.equals("add")) { 
                gService.addRecommend(id, typeTarget);
            }else { 
                gService.removeRecommend(id, typeTarget);
            }
            request.getRequestDispatcher("/admin/goods_list").forward(request, response);
        }

**servers**

public Page getGoodsRecommendPage(int type,int pageNumber) { 
            Page p = new Page();
            p.setPageNumber(pageNumber);
            int totalCount = 0;
            try { 
                totalCount = gDao.getRecommendCountOfGoodsByTypeID(type);
            } catch (SQLException e) { 
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
            p.SetPageSizeAndTotalCount(8, totalCount);
            List list=null;
            try { 
                list = gDao.selectGoodsbyRecommend(type, pageNumber, 8);
                for(Goods g : (List<Goods>)list) { 
                    g.setScroll(gDao.isScroll(g));
                    g.setHot(gDao.isHot(g));
                    g.setNew(gDao.isNew(g));
                }
            } catch (SQLException e) { 
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
            p.setList(list);
            return p;
        }

**dao**

public int getRecommendCountOfGoodsByTypeID(int type) throws SQLException { 
            if(type==0)return getCountOfGoodsByTypeID(0);
            QueryRunner r = new QueryRunner(DBUtil.getDataSource());
            String sql = "select count(*) from recommend where type=?";
            return r.query(sql, new ScalarHandler<Long>(),type).intValue();
        }

## 展示图片： ##

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Blbmd4aWFuZzE5OTg_size_16_color_FFFFFF_t_70]

## 网站首页：新品与热销展示 ##

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Blbmd4aWFuZzE5OTg_size_16_color_FFFFFF_t_70 1]

## 车辆展示：按照车辆类别进行分类 ##

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Blbmd4aWFuZzE5OTg_size_16_color_FFFFFF_t_70 2]

## 详情界面：展示车辆详情 ##

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Blbmd4aWFuZzE5OTg_size_16_color_FFFFFF_t_70 3]

## 公告中心：商城公告展示 ##

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Blbmd4aWFuZzE5OTg_size_16_color_FFFFFF_t_70 4]

## 订单管理：未付款 已付款 未发货 已完成状态 ##

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Blbmd4aWFuZzE5OTg_size_16_color_FFFFFF_t_70 5]

## 车辆管理：编辑车辆，加入热销与新品 ##

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Blbmd4aWFuZzE5OTg_size_16_color_FFFFFF_t_70 6]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Blbmd4aWFuZzE5OTg_size_16_color_FFFFFF_t_70]: /images/20230528/80dd6bb6aa4b45d7afe1d750f7bb32df.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Blbmd4aWFuZzE5OTg_size_16_color_FFFFFF_t_70 1]: /images/20230528/5c96ec99e0624355b2df0e2ef9b1009c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Blbmd4aWFuZzE5OTg_size_16_color_FFFFFF_t_70 2]: /images/20230528/098bcd9ef79f44de885f05a5e04d36c1.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Blbmd4aWFuZzE5OTg_size_16_color_FFFFFF_t_70 3]: /images/20230528/225d64a1f0fa43cdac95f53e0526d3a4.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Blbmd4aWFuZzE5OTg_size_16_color_FFFFFF_t_70 4]: /images/20230528/8837639ff8694ff2b61d9836652c9095.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Blbmd4aWFuZzE5OTg_size_16_color_FFFFFF_t_70 5]: /images/20230528/eeab12b369564e2d8ff30b7c9381ed30.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Blbmd4aWFuZzE5OTg_size_16_color_FFFFFF_t_70 6]: /images/20230528/d2eb41967f8c4b2fb2bbba9e745b03a9.png