jspshop.sql

网络购物系统jsp版（JAVASHOP）程序设计合理

INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("290", "213", "sharp", "1", "2003-09-20 11:50:16", "True", "False", "诺基亚6100", "3800", "1232004a2a15a20a31a50", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("291", "213", "admin", "1", "2003-11-02 16:03:15", "True", "False", "诺基亚6100", "3750", "1232004a2a15a20a31a50", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("292", "204", "shnxn", "1", "2004-02-03 20:35:11", "True", "False", "索尼爱立信T300", "2980", "1232004a2a15a20a31a50", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("293", "213", "shnxn", "1", "2004-02-03 21:41:25", "True", "False", "诺基亚6100", "3800", "1232004a2a15a20a31a50", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("295", "204", "shnxn", "1", "2004-02-04 14:34:45", "True", "False", "索尼爱立信T300", "2980", "1232004a2a15a20a31a50", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("300", "204", "shnxn", "1", "2004-02-04 16:34:42", "True", "False", "索尼爱立信T300", "2980", "1232004a2a15a20a31a50", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("303", "213", "karry", "8", "2004-02-15 16:24:14", "True", "False", "诺基亚6100", "3800", "1232004a2a15a20a31a50", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("304", "204", "karry", "10", "2004-02-15 16:26:36", "True", "False", "索尼爱立信T300", "2980", "1232004a2a15a20a31a50", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("305", "190", "karry", "6", "2004-02-15 16:51:56", "True", "False", "摩托罗拉C300", "1150", "1232004a2a15a20a31a50", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("306", "143", "123", "9", "2004-02-15 16:54:21", "True", "False", "阿尔卡特OT511", "950", "1232004a2a15a20a31a50", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("307", "161", "123", "4", "2004-02-15 16:54:52", "True", "False", "西门子6688", "1500", "1232004a2a15a20a31a50", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("308", "213", "123", "31", "2004-02-15 16:55:55", "True", "False", "诺基亚6100", "3800", "1232004a2a15a20a31a50", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("309", "201", "123", "6", "2004-02-15 17:03:54", "True", "False", "摩托罗拉V70", "2500", "1232004a2a15a20a31a50", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("310", "204", "123", "8", "2004-02-15 17:22:43", "True", "False", "索尼爱立信T300", "2980", "1232004a2a15a20a31a50", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("311", "213", "123", "5", "2004-02-15 17:35:48", "True", "False", "诺基亚6100", "3750", "1232004a2a15a20a31a50", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("312", "204", "123", "1", "2004-02-15 17:36:03", "True", "False", "索尼爱立信T300", "2980", "1232004a2a15a20a31a50", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("314", "213", "123", "24", "2004-02-15 19:22:23", "True", "False", "诺基亚6100", "3750", "1232004a2a15a20a31a50", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("315", "204", "123", "7", "2004-02-15 19:51:01", "True", "False", "索尼爱立信T300", "2980", "1232004a2a15a20a31a50", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("316", "213", "123", "3", "2004-02-15 19:52:15", "True", "False", "诺基亚6100", "3750", "1232004a2a15a20a31a50", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("317", "201", "123", "5", "2004-02-15 19:52:29", "True", "False", "摩托罗拉V70", "2480", "1232004a2a15a20a31a50", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("318", "213", "123", "8", "2004-02-15 20:05:49", "True", "False", "诺基亚6100", "3750", "1232004a2a15a20a31a50", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("319", "213", "123", "7", "2004-02-15 20:17:55", "True", "False", "诺基亚6100", "3750", "1232004a2a15a20a31a50", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("320", "213", "123", "9", "2004-02-15 20:26:55", "True", "False", "诺基亚6100", "3750", "1232004a2a15a20a31a50", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("321", "213", "123", "8", "2004-02-15 20:31:46", "True", "False", "诺基亚6100", "3750", "1232004a2a15a20a31a50", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("325", "213", "123", "10", "2004-02-15 21:04:37", "True", "False", "诺基亚6100", "3750", "1232004a2a15a21a04a51", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("326", "213", "123", "8", "2004-02-15 21:09:09", "True", "False", "诺基亚6100", "3750", "1232004a2a15a21a09a55", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("327", "190", "123", "4", "2004-02-15 21:11:19", "True", "False", "摩托罗拉C300", "1120", "1232004a2a15a21a11a57", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("328", "183", "123", "5", "2004-02-15 21:16:29", "True", "False", "爱立信T66", "1480", "1232004a2a15a21a19a32", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("329", "213", "123", "8", "2004-02-15 21:23:23", "True", "False", "诺基亚6100", "3750", "1232004a2a15a21a23a27", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("330", "204", "123", "5", "2004-02-15 21:25:06", "True", "False", "索尼爱立信T300", "2980", "1232004a2a15a21a25a10", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("331", "183", "123", "1", "2004-02-15 21:26:53", "True", "False", "爱立信T66", "1480", "1232004a2a15a21a26a57", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("332", "175", "123", "6", "2004-02-15 21:28:15", "True", "False", "诺基亚7650", "3750", "1232004a2a15a21a28a22", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("333", "213", "123", "7", "2004-02-15 21:29:55", "True", "False", "诺基亚6100", "3750", "1232004a2a15a21a31a20", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("334", "204", "123", "6", "2004-02-15 21:33:15", "True", "False", "索尼爱立信T300", "2980", "1232004a2a15a21a33a19", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("335", "175", "123", "5", "2004-02-15 21:36:28", "True", "False", "诺基亚7650", "3750", "1232004a2a15a21a36a33", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("336", "201", "123", "7", "2004-02-15 21:37:41", "True", "False", "摩托罗拉V70", "2480", "1232004a2a15a21a37a45", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("337", "190", "123", "6", "2004-02-15 21:38:33", "True", "False", "摩托罗拉C300", "1120", "1232004a2a15a21a38a37", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("338", "201", "123", "6", "2004-02-15 21:39:15", "True", "False", "摩托罗拉V70", "2480", "1232004a2a15a21a39a19", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("339", "163", "123", "5", "2004-02-15 21:40:43", "True", "False", "诺基亚7210", "3950", "1232004a2a15a21a40a48", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("340", "183", "123", "7", "2004-02-15 21:42:02", "True", "False", "爱立信T66", "1480", "1232004a2a15a21a42a06", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("341", "175", "123", "7", "2004-02-15 21:44:23", "True", "False", "诺基亚7650", "3750", "1232004a2a15a21a44a27", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("342", "175", "123", "2", "2004-02-15 21:51:27", "True", "False", "诺基亚7650", "3750", "1232004a2a15a21a51a57", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("343", "183", "123", "16", "2004-02-15 21:51:40", "True", "False", "爱立信T66", "1480", "1232004a2a15a21a51a57", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("370", "213", "karry", "4", "2004-03-19 20:16:27", "True", "False", "诺基亚6100", "3750", "karry200413119220317340", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("371", "204", "karry", "6", "2004-03-19 20:16:37", "True", "False", "索尼爱立信T300", "2980", "karry200413119220317340", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("372", "190", "karry", "7", "2004-03-19 20:17:05", "True", "False", "摩托罗拉C300", "1120", "karry200413119220317340", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("344", "213", "123", "20", "2004-02-15 21:52:16", "True", "False", "诺基亚6100", "3750", "1232004a2a15a21a53a44", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("346", "204", "1234", "5", "2004-02-16 20:19:05", "True", "False", "索尼爱立信T300", "2980", "12342004a2a16a20a19a08", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("347", "213", "1234", "6", "2004-02-16 20:20:45", "True", "False", "诺基亚6100", "3750", "12342004a2a16a20a20a47", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("348", "175", "1234", "5", "2004-02-16 20:27:03", "True", "False", "诺基亚7650", "3750", "12342004a2a16a20a27a06", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("349", "174", "1234", "7", "2004-02-16 20:28:27", "True", "False", "诺基亚8310", "1850", "12342004a2a16a20a28a29", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("350", "175", "1234", "4", "2004-02-16 20:29:23", "True", "False", "诺基亚7650", "3750", "12342004a2a16a20a29a30", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("351", "163", "1234", "5", "2004-02-16 20:29:27", "True", "False", "诺基亚7210", "3950", "12342004a2a16a20a29a30", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("353", "190", "1234", "1", "2004-02-16 20:31:45", "True", "False", "摩托罗拉C300", "1120", "12342004a2a16a20a31a48", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("354", "190", "1234", "7", "2004-02-16 20:33:44", "True", "False", "摩托罗拉C300", "1120", "12342004a2a16a20a33a46", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("355", "190", "1234", "6", "2004-02-16 20:36:29", "True", "False", "摩托罗拉C300", "1120", "1234200412116220336337", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("356", "190", "1234", "6", "2004-02-16 20:45:49", "True", "False", "摩托罗拉C300", "1120", "1234200412116220345351", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("357", "201", "1234", "7", "2004-02-16 21:04:50", "True", "False", "摩托罗拉V70", "2480", "1234200412116221337305", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("358", "213", "1234", "8", "2004-02-16 21:39:23", "False", "False", "诺基亚6100", "3750", "", "");
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("373", "213", "123456123456", "4", NULL, NULL, NULL, "诺基亚6100", "3750", NULL, NULL);
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("374", "204", "123456123456", "3", NULL, NULL, NULL, "索尼爱立信T300", "2980", NULL, NULL);
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("375", "201", "123456123456", "3", NULL, NULL, NULL, "摩托罗拉V70", "2480", NULL, NULL);
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("376", "175", "123456123456", "4", NULL, NULL, NULL, "诺基亚7650", "3750", NULL, NULL);
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("377", "174", "123456123456", "6", NULL, NULL, NULL, "诺基亚8310", "1850", NULL, NULL);
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("378", "190", "123456123456", "6", NULL, NULL, NULL, "摩托罗拉C300", "1120", NULL, NULL);
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("379", "174", "123456123456", "5", NULL, NULL, NULL, "诺基亚8310", "1850", NULL, NULL);
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("380", "213", "123456123456", "3", NULL, NULL, NULL, "诺基亚6100", "3750", NULL, NULL);
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("381", "204", "123456123456", "4", NULL, NULL, NULL, "索尼爱立信T300", "2980", NULL, NULL);
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("382", "213", "123456123456", "4", NULL, NULL, NULL, "诺基亚6100", "3750", NULL, NULL);
INSERT INTO basket (basket_id, hw_id, user_name, basket_count, basket_date, basket_check, basket_admincheck, hw_name, hw_cash, sub_number, daili) VALUES("383", "201", "123456123456", "3", NULL, NULL, NULL, "摩托罗拉V70", "2480", NULL, NULL);