首先數據庫沒有源碼，我自己寫了幾條，結果可以跟老師的對上。大家不嫌棄可以直接用。

INSERT INTO goods VALUES (6,'華派手機',1200,1800,null);

INSERT INTO goods VALUES (7,'華派pad',800,1400,null);

INSERT INTO goods VALUES (8,'酷為手機',650,1100,null);

INSERT INTO goods VALUES (9,' 酷為pad',700,1500,null);

INSERT INTO goods VALUES (10,'遐想手機',800,1100,null);

INSERT INTO goods VALUES (11,'遐想pad',750,1100,null);

INSERT INTO goods VALUES (12,'助興手機',900,1600,null);

INSERT INTO goods VALUES (13,'助興pad',900,1700,null);

INSERT INTO goods VALUES (14,'棒槌手機',1300,3100,null);

INSERT INTO goods VALUES (15,'棒槌pad',1200,3100,null);

INSERT INTO tradinginf VALUES (4,6,123456,7);

INSERT INTO tradinginf VALUES (1,6,123456,0);

INSERT INTO tradinginf VALUES (2,6,123456,0);

INSERT INTO tradinginf VALUES (3,6,123456,0);

INSERT INTO tradinginf VALUES (5,7,123456,4);

INSERT INTO tradinginf VALUES (6,8,123456,7);

INSERT INTO tradinginf VALUES (7,8,123456,0);

INSERT INTO tradinginf VALUES (8,9,123456,3);

INSERT INTO tradinginf VALUES (9,10,123456,1);

INSERT INTO tradinginf VALUES (10,11,123456,2);

INSERT INTO tradinginf VALUES (11,12,123456,1);

INSERT INTO tradinginf VALUES (12,13,123456,2);

INSERT INTO tradinginf VALUES (13,14,123456,1);

INSERT INTO tradinginf VALUES (14,15,123456,4);

INSERT INTO tradinginf VALUES (15,15,123456,0);

第二個問題是結尾的時候jsp頁面點擊生成報表報錯404? ?

我的解決辦法是在web.xml文件中配置

?<servlet>

? ? <servlet-name>ShowReport</servlet-name>

? ? <servlet-class>servlet.ShowReport</servlet-class>

? </servlet>

? <servlet-mapping>

? ? <servlet-name>ShowReport</servlet-name>

? ? <url-pattern>/ShowReport</url-pattern>

? </servlet-mapping>?

然后就可以解決了。