use?bookstore;
/*用戶表*/
CREATE?TABLE?tb_user(
uid?CHAR(32)?PRIMARY?KEY,/*主鍵*/ username?VARCHAR(50)?NOT?NULL,/*用戶名*/ password?VARCHAR(50)?NOT?NULL,/*密碼*/ email?VARCHAR(50)?NOT?NULL,/*郵箱*/ code?CHAR(64)?NOT?NULL,/*激活碼*/ state?int/*用戶狀態,有兩種是否激活*/)
SELECT?*?FROM?tb_user;
/*分類*/
CREATE?TABLE?category?(
cid?CHAR(32)?PRIMARY?KEY,/*主鍵*/ cname?VARCHAR(100)?NOT?NULL/*分類名稱*/)
INSERT?INTO?category(cid,cname)?VALUES?('1','JavaSE');
INSERT?INTO?category(cid,cname)?VALUES?('2','JavaEE');
INSERT?INTO?category(cid,cname)?VALUES?('3','Javascript');
SELECT?*?FROM?category;
/*圖書表*/
CREATE?TABLE?book?(
bid?CHAR(32)?PRIMARY?KEY,/*主鍵*/ bname?VARCHAR(100),/*圖書名*/ price?DECIMAL(5,1),/*單價*/ author?VARCHAR(20),/*作者*/ image?VARCHAR(200),/*圖片*/ cid?CHAR(32),/*所屬分類*/ FOREIGN?KEY?(cid)?REFERENCES?category(cid)/*建立主外鍵關系*/)
INSERT?INTO?book?VALUES?('1','Java編程思想(第4版)','75.6','qdmmy6','book_img/9317290-1_l.jpg','1');
INSERT?INTO?book?VALUES?('2','Java核心技術卷1','68.5','qdmmy6','book_img/20285763-1_l.jpg','1');
INSERT?INTO?book?VALUES?('3','Java就業培訓教程','39.9','張孝祥','book_img/8758723-1_l.jpg','1');
INSERT?INTO?book?VALUES?('4','Head?First?java','47.5','(美)塞若','book_img/9265169-1_l.jpg','1');
INSERT?INTO?book?VALUES?('5','JavaWeb開發詳解','83.3','孫鑫','book_img/22788412-1_l.jpg','2');
INSERT?INTO?book?VALUES?('6','Struts2深入詳解','63.2','孫鑫','book_img/20385925-1_l.jpg','2');
INSERT?INTO?book?VALUES?('7','精通Hibernate','30.0','孫衛琴','book_img/8991366-1_l.jpg','2');
INSERT?INTO?book?VALUES?('8','精通Spring2.x','63.2','陳華雄','book_img/20029394-1_l.jpg','2');
INSERT?INTO?book?VALUES?('9','Javascript權威指南','93.6','(美)弗蘭納根','book_img/22722790-1_l.jpg','3');
SELECT?*?FROM?book;
/*訂單表*/
CREATE?TABLE?orders?(
oid?CHAR(32)?PRIMARY?KEY,/*主鍵*/ ordertime?DATETIME,/*訂單生成時間*/ total?DECIMAL(10,0),/*訂單合計*/ state?SMALLINT,/*訂單狀態:未付款、已付款但未發貨、已發貨但未確認收貨、收貨已結束*/ uid?CHAR(32),/*訂單的主人*/ address?VARCHAR(200),/*訂單的收貨地址*/ FOREIGN?KEY?(uid)?REFERENCES?tb_user(uid)/*建立主外鍵關系*/)
SELECT?*?FROM?orders;
/*訂單項表*/
CREATE?TABLE?orderitem?(
iid?CHAR(32)?PRIMARY?KEY,/*主鍵*/ count?INT,/*數量*/ subtotal?DECIMAL(10,0),/*小計*/ oid?CHAR(32),/*所屬訂單*/ bid?CHAR(32),/*訂單項所指的商品*/ FOREIGN?KEY?(oid)?REFERENCES?orders?(oid),/*建立主外鍵關系*/ FOREIGN?KEY?(bid)?REFERENCES?book?(bid)/*建立主外鍵關系*/)
SELECT?*?FROM?orderitem;
1 先把妳的這個工程的sql代碼在sql2008裏面執行 ,創建數據庫。
2 然後導入整個工程到eclipse中去,導入外部工程方法去網上搜索。
3 再導入servlet的jar包,servlet.jar包網上有下載,導入方法網上有,再導入sqlserver2008的數據庫驅動jar包 ? ,這個jar包網上也有,導入方法和servlet壹致, 還要導入c標簽的jar包(兩個:jstl.jar 和standard.jar),網上也有。
4 把bookstore工程發布到eclipse的tomcat服務器中,至於eclipse中配置tomcat服務器,發布web工程方法,網上也有方法、
5 啟動tomcat服務器,瀏覽器訪問:?
http: // localhost:8080/bookstore/index.jsp
上面地址去掉空格訪問,(直接發網址會被屏蔽)
6 訪問結果如下: