myShop網(wǎng)上商城實(shí)驗(yàn)

攀枝花學(xué)院實(shí)驗(yàn)報(bào)告實(shí)驗(yàn)課程:JAVA應(yīng)用開(kāi)發(fā) 實(shí)驗(yàn)項(xiàng)目：網(wǎng)上商城實(shí)現(xiàn) 實(shí)驗(yàn)日期：2013.5 系：計(jì)算機(jī) 班級(jí)：10計(jì)本1班 姓名：蔣志勇 學(xué)號(hào)：201010801035指導(dǎo)老師：范勝波 成績(jī)：實(shí)驗(yàn)?zāi)康膶W(xué)會(huì)對(duì)購(gòu)物車(chē)，訂單，商品信息，商品分類(lèi)用MVC設(shè)計(jì)模式的實(shí)現(xiàn)。了解Ajax，Json，Jquery的使用。初步認(rèn)識(shí)框架的使用。實(shí)驗(yàn)設(shè)備Eclipse，Mysql數(shù)據(jù)庫(kù)，Tomact實(shí)驗(yàn)內(nèi)容網(wǎng)上商城的功能用戶(hù)的登錄與注銷(xiāo)。動(dòng)態(tài)商品分類(lèi)查詢(xún)。商品搜索功能的實(shí)現(xiàn)。首頁(yè)商品的展示及進(jìn)行分頁(yè)顯示。商品詳細(xì)功能的實(shí)現(xiàn)。購(gòu)物車(chē)的實(shí)現(xiàn)及進(jìn)行總價(jià)的計(jì)算。數(shù)據(jù)庫(kù)設(shè)計(jì)用戶(hù)表：customerCREATETABLE`customer`(`ID`int(11)NOTNULLAUTO_INCREMENT,`LoginName`varchar(50)NOTNULL,`Password`varchar(50)NOTNULL,`Name`varchar(50)NOTNULL,`Gender`char(2)DEFAULTNULL,`Birthday`dateDEFAULTNULL,`Adress`varchar(128)DEFAULTNULL,`Email`varchar(64)DEFAULTNULL,`Phone`varchar(32)DEFAULTNULL,PRIMARYKEY(`ID`))ENGINE=InnoDBAUTO_INCREMENT=2DEFAULTCHARSET=utf8;商品分類(lèi)表：categoryCREATETABLE`category`(`ID`int(11)NOTNULL,`Name`varchar(30)NOTNULL,`ParentID`int(11)DEFAULTNULL,`Status`char(6)DEFAULTNULL,PRIMARYKEY(`ID`))ENGINE=InnoDBDEFAULTCHARSET=utf8;（3）商品表：goodsCREATETABLE`goods`(`ID`int(11)NOTNULLAUTO_INCREMENT,`Name`varchar(64)NOTNULL,`Price`float(8,0)NOTNULL,`Inventory`int(11)NOTNULL,`Status`char(6)NOTNULL,`ImgUrl`varchar(64)DEFAULTNULL,`Description`text,`CategoryID`int(11)NOTNULL,PRIMARYKEY(`ID`),KEY`RefCategory1`(`CategoryID`),CONSTRAINT`RefCategory1`FOREIGNKEY(`CategoryID`)REFERENCES `category`(`ID`))ENGINE=InnoDBAUTO_INCREMENT=41DEFAULTCHARSET=utf8;（4）訂單表：orderCREATETABLE`order`(`ID`int(11)NOTNULLAUTO_INCREMENT,`CustomerID`int(11)NOTNULL,`GoodsID`int(11)NOTNULL,`GoodsCount`int(11)NOTNULL,`Price`float(8,0)NOTNULL,`Total`float(8,0)DEFAULTNULL,`Address`varchar(64)NOTNULL,`Contact`varchar(32)NOTNULL,`Phone`varchar(30)DEFAULTNULL,`Status`varchar(6)DEFAULTNULL,`Note`varchar(255)DEFAULTNULL,PRIMARYKEY(`ID`),KEY`RefCustomers2`(`CustomerID`),KEY`RefGoods3`(`GoodsID`),CONSTRAINT`RefCustomers2`FOREIGNKEY(`CustomerID`)REFERENCES `customer`(`ID`),CONSTRAINT`RefGoods3`FOREIGNKEY(`GoodsID`)REFERENCES`goods`(`ID`))ENGINE=InnoDBAUTO_INCREMENT=3DEFAULTCHARSET=utf8;系統(tǒng)代碼表：syscodeCREATETABLE`syscode`(`CODE`char(6)NOTNULL,`Name`varchar(50)NOTNULL,`CodeType`char(3)NOTNULL,PRIMARYKEY(`CODE`))ENGINE=InnoDBDEFAULTCHARSET=utf8;功能實(shí)現(xiàn)過(guò)程。Myshop框架的搭建與myshop數(shù)據(jù)庫(kù)的創(chuàng)建。將Myshop解壓，然后點(diǎn)擊Eclipse的File->Import導(dǎo)入項(xiàng)目。打開(kāi)NavicatforMySQL新建myshop數(shù)據(jù)庫(kù)，選擇utf-8編碼，然后選擇新建查詢(xún)， 導(dǎo)入shop.sql數(shù)據(jù)庫(kù)sql語(yǔ)句運(yùn)行。點(diǎn)擊運(yùn)行，將Myshop數(shù)據(jù)庫(kù)加載到tomact中出現(xiàn)如下結(jié)果，則框架搭建成功。分類(lèi)導(dǎo)航的實(shí)現(xiàn)。新建一個(gè)category.jsp頁(yè)面。編寫(xiě)CategoryServlet.java和CategoryDao實(shí)現(xiàn)對(duì)分類(lèi)導(dǎo)航。代碼如下:publicList<Category>getCategoriesByParentId(intparentId){ Stringsql="SELECTID,NAME,ParentID,StatusFROMcategoryWHEREParentID=?and Status=?"; returnthis.list(sql,parentId,MyShopConstant.category_type_active); }登錄和注銷(xiāo)功能的實(shí)現(xiàn)。1)新建一個(gè)topbar.jsp用于用戶(hù)登錄和顯示用戶(hù)相關(guān)信息。2)編寫(xiě)CustomerServlet.java和CustomerDao實(shí)現(xiàn)用戶(hù)登錄的數(shù)據(jù)庫(kù)查詢(xún)。代碼如下：publicCustomergetCustomer(StringloginName){ StringgetCustomerSQL="SELECTID,LoginName,Password,Name,Gender,Birthday,Adress, Email,Phone"+"FROMcustomerWHERELoginName=?"; returnthis.get(getCustomerSQL,loginName); }商品展示，商品詳細(xì)信息和查詢(xún)的顯示。新建goodsList.jsp和goodsDetail.jsp分別用于商品的首頁(yè)顯示和商品詳細(xì) 信息顯示。編寫(xiě)GoodsServlet和GoodsDao分別用于商品操作的轉(zhuǎn)發(fā)和數(shù)據(jù)庫(kù)操作。代碼如下：publicclassGoodsDaoextendsMyShopBasicDAO<Goods>{ //查詢(xún)?nèi)可唐?publicPage<Goods>getAllGoods(intcurpage){ StringcountGoodsSQL="SELECTcount(*)FROMGoodsWHEREStatus=?"; StringgetAllGoods="SELECTID,NAME,Price,Inventory,Status,ImgUrl,Description,CategoryID" +"FROMGoodsWHEREStatus=?limit?,?"; longtotal=this.getValue(countGoodsSQL,MyShopConstant.goods_status_available); Page<Goods>page=newPage<Goods>(total,curpage); page.setItems(this.list(getAllGoods,MyShopConstant.goods_status_available,page.startIndex(),page.getPageSize())); returnpage; } //分類(lèi)查詢(xún),用于商品分類(lèi)導(dǎo)航的顯示 publicPage<Goods>getGoods(intcategoryId,intcurpage){ StringcountGoodsSQL="SELECTcount(*)FROMGoodsWHEREStatus=?ANDCategoryID=?"; StringgetAllGoods="SELECTID,NAME,Price,Inventory,Status,ImgUrl,Description,CategoryID" +"FROMGoodsWHEREStatus=?ANDCategoryID=?limit?,?"; longtotal=this.getValue(countGoodsSQL,MyShopConstant.goods_status_available,categoryId); Page<Goods>page=newPage<Goods>(total,curpage); page.setItems(this.list(getAllGoods,MyShopConstant.goods_status_available,categoryId,page.startIndex(),page.getPageSize())); returnpage; } //用于商品名字的模糊搜索 publicPage<Goods>getGoods(Stringnamelike,intcurpage){ StringcountGoodsSQL="SELECTcount(*)FROMGoodsWHEREStatus=?ANDNamelike?"; StringgetAllGoods="SELECTID,NAME,Price,Inventory,Status,ImgUrl,Description,CategoryID" +"FROMGoodsWHEREStatus=?ANDNamelike?limit?,?"; longtotal=this.getValue(countGoodsSQL,MyShopConstant.goods_status_available,"%"+namelike+"%"); Page<Goods>page=newPage<Goods>(total,curpage); page.setItems(this.list(getAllGoods,MyShopConstant.goods_status_available,"%"+namelike+"%",page.startIndex(),page.getPageSize())); returnpage; } //通過(guò)商品ID進(jìn)行商品的詳細(xì)顯示 publicGoodsgetGoods(intid){ StringgetGoodsSQL="SELECTID,NAME,Price,Inventory,Status,ImgUrl,Description,CategoryID" +"FROMGoodsWHEREID=?"; returnthis.get(getGoodsSQL,id); }}購(gòu)物車(chē)功能的實(shí)現(xiàn)。1)編寫(xiě)cartList.jsp用于進(jìn)行購(gòu)物車(chē)頁(yè)面的顯示并用javascript計(jì)算總價(jià)錢(qián)。Javascript代碼如下：functiontotal(){ vartotalMoney=0; $('#cartListspan[id*="price_"]').each(function(index,priceSpan){ varpriceSpanId=$(this).attr('id'); varid=priceSpanId.substring(priceSpanId.indexOf("_")+1); varcountId="count_"+id; varprice=$(this).text(); varcount=$('#'+countId).val(); totalMoney+=price*count; }); $('#cartListspan[id="total"]').text(totalMoney.toFixed(2)); } $(document).ready(function($){ $('#selectAllCKB').on('click',function(){ var$chkAll=$(this); if($chkAp('checked')==true){ $('input[type="checkbox"][name="itemId"]').prop('checked',"checked"); }else{ $('input[type="checkbox"][name="itemId"]').removeProp('checked'); } }); //計(jì)算總價(jià) total(); //注冊(cè)數(shù)量變化重新計(jì)算總價(jià) $('#car