experim data.sql

基于J2EE技术的 电子购物商城系统

/* users 表: */
insert into users values('linky', 'linky', 'linky', '男', 5000, 'my name is linky.');
insert into users values('lily', 'lily', 'lily', '女', 5000, 'my name is lily.');
insert into users values('05083224', '05083224', '谢少斌', '男', 5000, '我住在6-605.');

/* categories表: */
insert into categories#1 values('图书');
insert into categories#1 values('生活用品');
insert into categories#1 values('消费电子产品');

insert into categories#2 values('计算机');
insert into categories#2 values('数学');
insert into categories#2 values('台灯');
insert into categories#2 values('MP3');
insert into categories#2 values('手机');

insert into categories#3 values('Java系列');
insert into categories#3 values('计算机网络');
insert into categories#3 values('离散数学');
insert into categories#3 values('概率统计');
insert into categories#3 values('应急台灯');
insert into categories#3 values('魅族MP3');
insert into categories#3 values('popo mp3');
insert into categories#3 values('Nokie 手机');
insert into categories#3 values('联想笔记本电脑');
insert into categories#3 values('HP笔记本电脑');

/* goods表: */
insert into goods values('20080103100752lily', 'SUNCA SF845应急台灯', 20, 20, 'lily', '生活用品', '台灯', '应急台灯', 1);
insert into goods values('20080103100712lily', '魅族 1200 MP3', 120, 20, 'lily', '消费电子产品', 'MP3', '魅族MP3', 1);
insert into goods values('20080103102045lily', 'popo 122 mp3', 220, 120, 'linky', '消费电子产品', 'MP3', 'popo mp3', 1);
insert into goods values('20080103112032linky', 'nokie 6100 手机', 120, 20, 'linky', '消费电子产品', '手机', 'Nokie 手机', 1);
insert into goods values('20080103101612linky', 'nokie 7200 手机', 300, 20, 'linky', '消费电子产品', '手机', 'Nokie 手机', 1);
insert into goods values('20080103101752lily', '联想Thinkpad6700', 3820, 20, 'lily', '消费电子产品', '计算机', '联想笔记本电脑', 1);
insert into goods values('20080103102012lily', 'HP compaq7300笔记本电脑', 4600, 20, 'lily', '消费电子产品', '计算机', 'HP笔记本电脑', 1);

/* books表: */
insert into books values('2008010310242305083224', 'J2EE实用教程', 12, 62, '05083224', '计算机', 'Java系列', '郝玉龙', '北京交通大学出版社', 1, '7-115-1409-4/TP*456', 'TP312/JA152', 1);
insert into books values('2008010310282405083224', '计算机网络教程', 8.5, 62, '05083224', '计算机', '计算机网络', '谢希仁', '人民邮电出版社', 1, '7-115-1409-4/TP*5373', 'TP312/NET52', 1);
insert into books values('2008010310292505083224', '离散数学', 5, 32, '05083224', '数学', '离散数学', '屈琬玲', '清华大学出版社', 1, '7-115-1409-4/MA*456', 'M153312/DSM152', 1);
insert into books values('2008010310303305083224', '概率统计', 6, 62, '05083224', '数学', '概率统计', '无名', '同济大学出版社', 1, '7-115-1409-4/MA*1556', 'M153312/PM152', 1);

/* carts表: */

/* trades表: */

commit;