·¢²¼Ê±¼ä : ÐÇÆÚÒ» ÎÄÕÂ(¾«Æ·)»ùÓÚJavaµÄwebÍøÉÏÊé³Ç±ÏÒµÂÛÎÄÂÛÎĸüÐÂÍê±Ï¿ªÊ¼ÔĶÁ8c9662a8e109581b6bd97f19227916888586b942
ͼÊé·ÖÀà»ù±¾ÐÅÏ¢±í
DROP TABLE bookcat CASCADE CONSTRAINTS; CREATE TABLE bookcat( );
ͼÊé»ù±¾ÐÅÏ¢±í
DROP TABLE book CASCADE CONSTRAINTS; CREATE TABLE book( );
¿Í»§»ù±¾ÐÅÏ¢±í
DROP TABLE storeuser CASCADE CONSTRAINTS; CREATE TABLE storeuser( );
username VARCHAR2 (20) PRIMARY KEY, password VARCHAR2 (20) NOT NULL, name tel
VARCHAR2 (20) NOT NULL,
id catid
NUMBER
PRIMARY KEY,
NOT NULL
id
NUMBER
PRIMARY KEY,
catname VARCHAR2 (40) NOT NULL
NUMBER
REFERENCES bookcat(id) ON DELETE CASCADE,
VARCHAR2 (50) NOT NULL, NUMBER NOT NULL, NUMBER NOT NULL,
name price
saleprice
descript VARCHAR2 (500) NOT NULL, author contents image
VARCHAR2 (50) NOT NULL, VARCHAR2 (2000) NULL, VARCHAR2 (50) NULL
VARCHAR2 (20) NOT NULL,
VARCHAR2 (100) NOT NULL, VARCHAR2 (50) NULL
address email
¶©µ¥ÐÅÏ¢±í
DROP TABLE orders CASCADE CONSTRAINTS; CREATE TABLE orders( );
¶©µ¥ÌõÄ¿ÏêϸÐÅÏ¢±í
DROP TABLE orderdetail CASCADE CONSTRAINTS; CREATE TABLE orderdetail( );
_____________________________________________________________________
orderid
NUMBER NOT NULL
id
NUMBER
PRIMARY KEY,
username VARCHAR2 (20) NOT NULL
REFERENCES storeuser(username) ON DELETE CASCADE,
DATE
NOT NULL,
time
delivery VARCHAR2 (20) NOT NULL, payment
VARCHAR2 (20) NOT NULL
REFERENCES orders(id) ON DELETE CASCADE,
NUMBER NOT NULL
bookid
REFERENCES book(id) ON DELETE CASCADE,
NUMBER NOT NULL, NUMBER NOT NULL
count price
3-5 ÍøÉÏÊéµê»ù±¾Á÷³Ì
ÍøÉÏÊéµêÔÚÔËÐйý³ÌÖÐÒ³ÃæµÄ»ù±¾Á÷³ÌÈçÏÂͼ£º
3-6 ÍøÉÏÊéµê¸÷Ò³Ã湦ÄÜ
3-6-1 ÍøÉÏÊéµêÊ×Ò³bookMain.jspÏêϸ¹¦Äܼ°ÃèÊö
? »ñȡͼÊé·ÖÀàÐÅÏ¢ÒÔ¼°Í¼Êé»ù±¾ÐÅÏ¢¼¯ºÏ ? Ñ»·ÏÔʾͼÊé·ÖÀàÐÅÏ¢
? Ìá½»ÏÔʾָ¶¨·ÖÀàͼÊéÐÅÏ¢µÄÇëÇó£¬Í¬Ê±´«µÝ¶ÔӦͼÊé·ÖÀà±àºÅ ? Ìá½»ÊéÄ¿ËÑË÷ÇëÇó¼°ËÑË÷Ìõ¼þµÄ±íµ¥ ? Ìá½»ËÑË÷¹Ø¼ü×ÖµÄ±íµ¥ÔªËØ ? Ñ¡ÔñËÑË÷Ìõ¼þµÄ±íµ¥ÔªËØ
? ÏÔʾͼÊé¼Ç¼×ÜÊý¡¢µ±Ç°Ò³Ãæ±àºÅÒÔ¼°×ÜÒ³Êý ? Ñ»·ÏÔʾ¶ÔӦͼÊéÊéÄ¿ÐÅÏ¢
? ÏÔʾͼÊéÃû³Æ¡¢¼Û¸ñ¡¢ÏúÊÛ¼Û¸ñ¡¢×÷ÕßÐÅÏ¢ ? Ìá½»ÏÔʾͼÊéÏêϸÐÅÏ¢ÇëÇóµÄ³¬Á´½Ó
? Ìá½»·ÖÒ³ÏÔʾÇëÇóµÄ³¬Á´½Ó£¬Í¬Ê±Ìá½»Ö¸¶¨Ò³Ãæ±àºÅ
ÔÚ±¾Ò³ÃæÖУ¬µ±µ¥»÷Ñ¡ÔñÊéÄ¿·ÖÀàʱ£¬½«Ìá½»
¡°bookSearch.do?bookCatId=<%=bookCat.getId()%mode=1¡±ÇëÇó£¬ÒÔ±ãÓÚ»ñÈ¡¶ÔӦͼÊé·ÖÀàµÄÏà¹ØÐÅÏ¢¡£µ±Ñ¡ÔñÁ˲éѯÒÀ¾Ý£¬²¢ÇÒÊäÈëÁ˶ÔÓ¦¹Ø¼ü×Ö£¬µ¥»÷¡°ËÑË÷¡±°´Å¥Ê±£¬½«Ìá½»¡°bookSearch.do¡±ÇëÇó£¬Í¬Ê±Ìá½»²éѯÌõ¼þ£¬½øÐкóÐøÊéÄ¿ÐÅÏ¢ËÑË÷µÄ´¦Àí¡£µ±ÔÚÊéÄ¿ÁбíÖе¥»÷²é¿´ÏêϸÐÅÏ¢ÇëÇóʱ£¬½«·¢³ö¡°bookDetail.do¡±ÇëÇó£¬Í¬Ê±´«µÝ¶ÔӦͼÊé¼Ç¼µÄ±àºÅ£¬ÒÔ»ñÈ¡Ö¸¶¨Í¼Êé¸ü¼ÓÏêϸµÄÐÅÏ¢¡£´ËÍ⣬ÔÚµ¥»÷¡°Ê×Ò³¡±¡¢¡°ÉÏÒ³¡±¡¢¡°ÏÂÒ³¡±³¬Á´½Óºó£¬½«·Ö±ðÌá½»¡°bookPage.dopageId=<%=0%>¡±¡¢¡°bookPage.dopageId=<%=schSta.getPageId()-1%>¡±schSta.getPageId()+1%>¡±µÈÇëÇó£¬ÒÔʵÏÖÒ³ÃæµÄÌøת
¡¢
¡°bookPage.dopageId=<%=
3-6-2 ÏÔʾͼÊéÏêϸÐÅÏ¢bookShow.jspÒ³ÃæÏêϸ¹¦Äܼ°ÃèÊö
? ÒÀ¾ÝͼÊé¼Ç¼±àºÅ»ñÈ¡´ýÏÔʾÏêϸÐÅÏ¢µÄͼÊéÀàÐ͵ĶÔÏó ? ·Ö±ðÏÔʾ¸ÃͼÊé¶ÔÏóµÄÏêϸÐÅÏ¢
? ÏÔʾͼÊé·âÃæͼƬ¡¢Ãû³Æ¡¢Ïêϸ½éÉÜ¡¢¼Û¸ñ¡¢ÏúÊÛ¼Û¸ñ ? µ¥»÷¡°¹ºÂò¡±°´Å¥ºó£¬½«Ìá½»·ÅÈ빺Îï³µµÄÇëÇó