敲代碼遇到的問題
首先數據庫沒有源碼,我自己寫了幾條,結果可以跟老師的對上。大家不嫌棄可以直接用。
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>?
然后就可以解決了。
2019-08-29
謝謝!