锘跨敤鎴疯〃create table users(id number primary key,name varchar2(50) not null,pwd varchar2(50) not null,email varchar2(100) not null,tel varchar2(20) not null,grade number(2) default 1 not null)鍟嗗搧琛�create table book(id number primary key,name varchar2(50) not null,author varchar2(100) not null,publishHouse varchar2(100) not null,price number not null,nums number default 1000 not null)娴嬭瘯鏁版嵁(鐢ㄦ埛)insert into users values(100,'hxw','hxw','512592151@qq.com','110',1);insert into users values(101,'鐜嬭嫳璞�','wyh','512592151@qq.com','111',1);鑷闀�create sequence book_seqstart with 1increment by 1minvalue 1maxvalue 9999999nocyclenocache娴嬭瘯鏁版嵁(鍟嗗搧)insert into book values(book_seq.nextval,'jsp搴旂敤寮�鍙戣瑙�','灏忛','鐢靛瓙宸ヤ笟鍑虹増绀�',59,400);insert into book values(book_seq.nextval,'JAVA WEB 寮�鍙�','灏忛粍','鐢靛瓙宸ヤ笟鍑虹増绀�',43,734);insert into book values(book_seq.nextval,'java 缂栫▼鎬濇兂','灏忚姳','鐢靛瓙宸ヤ笟鍑虹増绀�',120,130);insert into book values(book_seq.nextval,'j2ee鎸囧崡','灏忕帇','鐢靛瓙宸ヤ笟鍑虹増绀�',65,1320);insert into book values(b
