jspshop.sql

Struts+Spring+Hibernate在线购物系统

  basket_admincheck enum('True','False') default 'False',
  hw_name varchar(50) default NULL,
  hw_cash varchar(50) default NULL,
  sub_number varchar(50) default NULL,
  daili varchar(50) default NULL,
  PRIMARY KEY  (basket_id)
) TYPE=MyISAM;



#
# Dumping data for table 'basket'
#

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("194", "121", "oksina", "1", "2002-11-06 20:51:08", "True", "False", "武安热线?网上商店3.0测试版", "150", "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("197", "121", "123", "1", "2002-11-20 18:06:22", "True", "False", "武安热线网上商城3.0", "200", "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("202", "120", "123", "10", "2002-11-21 02:49:29", "True", "False", "金山毒霸", "50", "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("203", "121", "123", "1", "2002-11-21 09:57:57", "True", "False", "武安热线网上商城3.0", "200", "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("205", "121", "123", "1", "2002-11-21 21:55:42", "True", "False", "武安热线网上商城3.0", "200", "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("206", "121", "321", "1", "2002-11-22 10:08:11", "True", "False", "武安热线网上商城3.0", "150", "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("207", "120", "tanggang", "4", "2002-11-22 10:09:49", "True", "False", "金山毒霸", "50", "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("216", "121", "321", "1", "2002-11-22 17:32:37", "True", "False", "武安热线网上商城3.0", "150", "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("217", "124", "321", "1", "2002-11-22 17:34:55", "True", "False", "网上商店2.1", "49", "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("227", "193", "忆婷", "1", "2002-12-09 10:28:50", "True", "False", "摩托罗拉V8088", "1000", "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("232", "204", "xieshen", "1", "2002-12-13 14:37:35", "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("233", "148", "xieshen", "1", "2002-12-13 14:55:28", "True", "False", "阿尔卡特OT512", "1050", "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("234", "213", "hyboy", "1", "2002-12-13 22:29:39", "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("235", "140", "乖乖虎", "1", "2002-12-18 04:36:01", "True", "False", "三星N628", "1600", "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("236", "171", "andy zhu", "1", "2002-12-19 20:07:18", "True", "False", "诺基亚8850“高贵”", "1999", "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("237", "139", "mjjbenimaru", "1", "2002-12-21 07:40:40", "True", "False", "三星M188", "1300", "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("238", "166", "mjjbenimaru", "1", "2002-12-21 07:52:43", "True", "False", "诺基亚5210", "1100", "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("239", "204", "冷风", "1", "2003-04-01 00:07:12", "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("240", "204", "8888z", "1", "2003-04-02 21:06: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("242", "213", "aaa", "1", "2003-04-02 21:44:58", "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("243", "213", "hxyh", "1", "2003-04-02 22:17:07", "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("244", "161", "aaaaa", "1", "2003-04-02 23:12:58", "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("246", "131", "fg", "1", "2003-04-02 23:18:06", "True", "False", "三星男用A308", "2200", "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("247", "213", "rxf", "1", "2003-04-02 23:39:47", "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("248", "213", "rxf", "2", "2003-04-02 23:40: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("249", "213", "rxf", "2", "2003-04-02 23:40:44", "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("250", "201", "ccc", "1", "2003-04-03 01:01:21", "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("251", "204", "fg", "1", "2003-04-03 01:19:53", "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("252", "186", "jjkw", "6", "2003-04-03 03:29:32", "True", "False", "爱立信R600", "1180", "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("253", "213", "w4f2", "2", "2003-04-03 08:25:05", "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("254", "204", "9pts", "1", "2003-04-03 12:52:22", "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("255", "213", "benhack", "1", "2003-04-03 13:28:24", "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("256", "213", "response", "1", "2003-04-03 15:02:01", "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("257", "204", "ngqq", "1", "2003-04-03 15:11:32", "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("258", "213", "looklook", "1", "2003-04-03 15:55:12", "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("259", "128", "csycsy", "1", "2003-04-03 16:09:41", "True", "False", "三星彩色双屏SGH-T108", "3050", "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("260", "213", "方丈", "2", "2003-04-03 16:57:26", "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("261", "213", "killjin", "1", "2003-04-03 18:26: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("264", "213", "rabbit", "1", "2003-04-04 17:53:24", "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("268", "204", "jans", "1", "2003-04-04 19:26:30", "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("269", "147", "jans", "1", "2003-04-04 19:27:47", "True", "False", "三星Anycall-A188", "1250", "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("270", "213", "qw3", "1", "2003-04-05 22:47:04", "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("271", "213", "qw3", "2", "2003-04-05 23:04:50", "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("272", "175", "feelzjf", "1", "2003-04-05 23:34:51", "True", "False", "诺基亚7650", "3880", "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("275", "204", "xztxx", "1", "2003-04-06 12:09:53", "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("276", "147", "qw3", "1", "2003-04-06 18:20:32", "True", "False", "三星Anycall-A188", "1250", "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("278", "154", "youbing", "1", "2003-04-11 19:26:15", "True", "False", "松下GD68", "1550", "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("279", "213", "pzw", "1", "2003-04-13 23:05:40", "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("281", "213", "csycsy", "1", "2003-04-17 00:55:08", "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("282", "148", "csycsy", "1", "2003-04-17 00:55:29", "True", "False", "阿尔卡特OT512", "1050", "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("283", "204", "fily", "1", "2003-04-22 17:10:07", "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("284", "204", "qqqq", "1", "2003-04-23 12:19:29", "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("285", "175", "ljs2008", "1", "2003-04-23 20:33:24", "True", "False", "诺基亚7650", "3880", "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("286", "146", "5252", "1", "2003-04-26 17:16:43", "True", "False", "阿尔卡特OT700", "750", "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("288", "204", "aaaaaa", "1", "2003-08-25 18:14:33", "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("289", "213", "sharp", "3", "2003-09-20 11:47:28", "True", "False", "诺基亚6100", "3800", "1232004a2a15a20a31a50", "");