客车网上售票系统04

一、今日完成任务

　　订单统计

　　功能要求：根据日期和车次，统计总金额。通俗一点来说，就是统计每天每辆车卖了多少张票，挣了多少钱

二、核心源码

　　sql语句的编写：包含订单表和车次表，并根据车次和时间分组查询

select count(*) num,DATE(savetime) date,ticket.carnum,ticket.price,ticketid from order1,ticket where fkstatus=1 and order1.ticketid=ticket.id group by ticketid ,DATE(savetime) order by date desc

public List<Statement> orderShowAll() {
        String sql = "select count(*) num,DATE(savetime) date,ticket.carnum,ticket.price,ticketid from order1,ticket"
                + " where fkstatus=1 and order1.ticketid=ticket.id group by ticketid ,DATE(savetime) order by date desc";
        Object[] obj = {};
        ResultSet rs = DBUtil.select(sql, obj);
        List<Statement> list = new ArrayList<Statement>();
        try {
            while(rs.next()){
                int num = rs.getInt("num");
                int price = rs.getInt("price");
                String date = rs.getString("date");
                String carnum = rs.getString("carnum");
                int money = num * price;
                Statement statement = new Statement(num, price, date, carnum, money);
                list.add(statement);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return list;
    }

protected void orderShowAll(HttpServletRequest req, HttpServletResponse resp)
            throws ServletException, IOException {
        List<Statement> list = ud.orderShowAll();
        req.getSession().setAttribute("StatementList", list);
        resp.sendRedirect("afterpage/orderList.jsp");
    }

三、页面展示

四、遇到的问题

　　无

五、燃尽图