网上书店 jsp附有源码

conn system/admin; drop user books cascade; create user books identified by books; grant resource,connect to books; conn books/books; create table userinfo ( username varchar2(50) primary key, password varchar2(50), email varchar2(50) ); create table orders ( oid number primary key, username varchar2(50) references userinfo (username) ); create table books ( bid number primary key, bookname varchar2(50), b_price varchar2(10), image varchar2(100), stock number ); create table items ( iid number primary key, oid number references orders(oid), bid number references books(bid), createdate varchar2(50), count number, price varchar2(50), total_price varchar(50) ); insert into userinfo values('tom','123','931655570@qq.com'); insert into userinfo values('admin','123','931655570@qq.com'); insert into userinfo values('system','123','931655570@qq.com'); insert into orders values(1001,'tom'); insert into orders values(1002,'admin'); insert into orders values(1003,'system'); insert into books values(1,'泰戈尔诗集','18.00','book_01.gif',999); insert into books values(2,'痕记','22.80','book_02.gif',999); insert into books values(3,'天堂之旅','25.00','book_03.gif',999); insert into books values(4,'钱钟书集（全10册）','332.50','book_04.gif',999); insert into books values(5,'赵俪生高昭—夫妻回忆录','38.00','book_05.gif',999); insert into books values(6,'无聊斋（张绍刚首部随笔杂文作品）','28.00','book_06.gif',999); insert into books values(7,'一颗热土豆是一张温馨的床','38.00','book_07.gif',999); insert into books values(8,'李戡戡乱记','22.00','book_08.gif',999); insert into books values(9,'生生世世未了缘','17.50','book_09.gif',999); insert into books values(10,'一生有多少爱','17.50','book_10.gif',999); insert into books values(11,'天堂之旅','25.00','book_03.gif',999); insert into books values(12,'钱钟书集（全10册）','332.50','book_04.gif',999); insert into books values(13,'赵俪生高昭—夫妻回忆录','38.00','book_05.gif',999); insert into books values(14,'无聊斋（张绍刚首部随笔杂文作品）','28.00','book_06.gif',999); insert into books values(15,'一颗热土豆是一张温馨的床','38.00','book_07.gif',999); insert into books values(16,'李戡戡乱记','22.00','book_08.gif',999); insert into books values(17,'生生世世未了缘','17.50','book_09.gif',999); insert into books values(18,'一生有多少爱','17.50','book_10.gif',999); insert into books values(19,'天堂之旅','25.00','book_03.gif',999); insert into books values(20,'钱钟书集（全10册）','332.50','book_04.gif',999); insert into books values(21,'赵俪生高昭—夫妻回忆录','38.00','book_05.gif',999); insert into books values(22,'无聊斋（张绍刚首部随笔杂文作品）','28.00','book_06.gif',999); insert into books values(23,'一颗热土豆是一张温馨的床','38.00','book_07.gif',999); insert into books values(24,'李戡戡乱记','22.00','book_08.gif',999); insert into books values(25,'生生世世未了缘','17.50','book_09.gif',999); insert into books values(26,'反倒笑了','17.50','book_10.gif',999); commit;