面向?qū)ο髷?shù)據(jù)庫(kù)試驗(yàn)應(yīng)用實(shí)現(xiàn)報(bào)告資料

1、面向?qū)ο髷?shù)據(jù)庫(kù)實(shí)驗(yàn)一一應(yīng)用實(shí)現(xiàn)報(bào)告1系統(tǒng)設(shè)計(jì)1.1 面向?qū)ο髷?shù)據(jù)庫(kù)實(shí)驗(yàn)體系架構(gòu)該系統(tǒng)采用J2EE的三層結(jié)構(gòu)，分為表示層、業(yè)務(wù)邏輯層和數(shù)據(jù)服務(wù)層。三層體系將業(yè) 務(wù)規(guī)則、數(shù)據(jù)訪問(wèn)等工作放到中間層處理，客戶端不直接與數(shù)據(jù)庫(kù)交互，而是通過(guò)控制器與中間層建立連接，再由中間層與數(shù)據(jù)庫(kù)交互。表本層米用JSP。中間層采用，為了分離控制層與業(yè)務(wù)邏輯層，又可細(xì)分為：Web層，就是MVC模式中的“ C”，負(fù)責(zé)表示層與業(yè)務(wù)邏輯層的交互，調(diào)用業(yè)務(wù)邏 輯層，并將業(yè)務(wù)數(shù)據(jù)返回給表示層顯示。MVC框架采用流行的Struts。DAO層（數(shù)據(jù)訪問(wèn)對(duì)象層），負(fù)責(zé)與持久化對(duì)象交互，封裝了數(shù)據(jù)的增、刪、改、 查等原子操作。PO層（持久

2、化又象層）,以面向?qū)ο蠓绞讲僮鲾?shù)據(jù)庫(kù)。數(shù)據(jù)服務(wù)層使用面向?qū)ο髷?shù)據(jù)庫(kù)Versant。表示層采用struts框架，負(fù)責(zé)界面的更新，數(shù)據(jù)的校驗(yàn)、讀取、顯示。數(shù)據(jù)訪問(wèn)對(duì)象層 采用JVI接口，對(duì)不同的對(duì)象建立一個(gè)類，并提供相應(yīng)服務(wù)，供表示層使用，并以 VO在表 示層與DAO層進(jìn)行消息傳遞。持久化層對(duì)象采用經(jīng)過(guò)JVI加強(qiáng)過(guò)的模型類，執(zhí)行新增、編輯、刪除等操作。1.2 模塊劃分模塊劃分的目標(biāo)是： 高內(nèi)聚，低耦合。我們盡量減少模塊和模塊之間的交互，而把處理 流程相似的功能歸到同一模塊，最大限度的實(shí)現(xiàn)代碼的重用，模塊劃分如下：模塊編號(hào)模塊名稱M1主界囿M2立方體模塊M3圓錐體模塊M4圓柱體模塊M5球體模塊M6模

3、型預(yù)覽1.3 包的體系結(jié)構(gòu)及功能描述name.zzz.hd.action面向?qū)ο髷?shù)據(jù)庫(kù)界面 Action包 mon面向?qū)ο髷?shù)據(jù)庫(kù)實(shí)驗(yàn)常用工具包 name.zzz.hd.dao面向?qū)ο髷?shù)據(jù)庫(kù)實(shí)驗(yàn)的數(shù)據(jù)訪問(wèn)對(duì)象 name.zzz.hd.model面向?qū)ο髷?shù)據(jù)庫(kù)實(shí)驗(yàn)的各個(gè)模型實(shí)體類包 name.zzz.hd.vo面向?qū)ο髷?shù)據(jù)庫(kù)模型顯示對(duì)象包2各模塊詳細(xì)設(shè)計(jì)2.1 主界面（M1）詳細(xì)設(shè)計(jì)2.1.1 程序描述：主界面顯示程序所能執(zhí)行的各種操作，并以菜單的形式顯示出來(lái)。另外頁(yè)面的底部顯示小組成員名單。通過(guò)點(diǎn)擊頁(yè)面頂部的不同功能，進(jìn)入不同的操作。2.1.2 流程邏輯：2.1.3 類圖:2.2 立方體(M2)

4、模塊詳細(xì)設(shè)計(jì)2.2.1 程序描述：該模塊包括對(duì)立方體的增刪改查操作，新增立方體時(shí)輸入立方體的原點(diǎn)和在坐標(biāo)系中的x、y、z三個(gè)坐標(biāo)點(diǎn)，然后保存立方體信息。立方體模塊還對(duì)立方體進(jìn)行列表，并能進(jìn)行編 輯和刪除操作。在列表上方的快速搜索里面可以輸入立方體的名稱進(jìn)行模糊查詢。2.2.2 流程邏輯：addCube.jspCubeAction-cubeDao: CubeDao = new CubeDao()+add(mapping: ActionMapping, form: ActionForm, request: HttpServletRequest, response: HttpServletRespo

5、nse): ActionForward +preview(mapping: ActionMapping, form: ActionForm, request: HttpServletRequest, response: HttpServletResponse): ActionForward +insert(mapping: ActionMapping, form: ActionForm, request: HttpServletRequest, response: HttpServletResponse): ActionForward +edit(mapping: ActionMapping,

6、 form: ActionForm, request: HttpServletRequest, response: HttpServletResponse): ActionForward +update(mapping: ActionMapping, form: ActionForm, request: HttpServletRequest, response: HttpServletResponse): ActionForward +delete(mapping: ActionMapping, form: ActionForm, request: HttpServletRequest, re

7、sponse: HttpServletResponse): ActionForward +list(mapping: ActionMapping, form: ActionForm, request: HttpServletRequest, response: HttpServletResponse): ActionForwardCubeDao+delete(String) +getCount() +getCube() +getCubeVo() +list() +save() +update()2.3 圓錐體(M3)模塊詳細(xì)設(shè)計(jì)2.3.1 程序描述：該模塊包括對(duì)圓錐體的增刪改查操作，新增圓錐體

8、時(shí)輸入圓錐體的頂點(diǎn)和底面頂點(diǎn)半徑，然后保存圓錐體信息。圓錐體模塊還對(duì)圓錐體進(jìn)行列表，并能進(jìn)行編輯和刪除操作。在列表上方的快速搜索里面可以輸入圓錐體的名稱進(jìn)行模糊查詢。2.3.2 流程邏輯：選擇圓錐體的操作ConeDaoaddCone.jspConeAction+delete(String) +getCount() +getCone() +getConeVo() +list() +save() +update()-ConeDao: ConeDao = new ConeDao() +add(mapping: ActionMapping, form: ActionForm, request: Htt

9、pServletRequest, response: HttpServletResponse): ActionForward +preview(mapping: ActionMapping, form: ActionForm, request: HttpServletRequest, response: HttpServletResponse): ActionForward +insert(mapping: ActionMapping, form: ActionForm, request: HttpServletRequest, response: HttpServletResponse):

10、ActionForward +edit(mapping: ActionMapping, form: ActionForm, request: HttpServletRequest, response: HttpServletResponse): ActionForward +update(mapping: ActionMapping, form: ActionForm, request: HttpServletRequest, response: HttpServletResponse): ActionForward +delete(mapping: ActionMapping, form:

11、ActionForm, request: HttpServletRequest, response: HttpServletResponse): ActionForward +list(mapping: ActionMapping, form: ActionForm, request: HttpServletRequest, response: HttpServletResponse): ActionForward2.4 圓柱體(M4)模塊詳細(xì)設(shè)計(jì)2.4.1 程序描述：該模塊包括對(duì)圓柱體的增刪改查操作，新增圓柱體時(shí)輸入圓柱體的頂點(diǎn)和底面頂點(diǎn)半徑，然后保存圓柱體信息。圓柱體模塊還對(duì)圓柱體進(jìn)行列表

12、，并能進(jìn)行編輯和刪除操作。在列表上方的快速搜索里面可以輸入圓柱體的名稱進(jìn)行模糊查詢。2.4.2 流程邏輯：選擇圓柱體的操作listCylinder.jsp遼CylinderActioneditCylinder.jsp-CylinderDao: CylinderDao = new CylinderDao()+add(mapping: ActionMapping, form: ActionForm, request: HttpServletRequest, response: HttpServletResponse): ActionForward +preview(mapping: ActionM

13、apping, form: ActionForm, request: HttpServletRequest, response: HttpServletResponse): ActionForward +insert(mapping: ActionMapping, form: ActionForm, request: HttpServletRequest, response: HttpServletResponse): ActionForward +edit(mapping: ActionMapping, form: ActionForm, request: HttpServletReques

14、t, response: HttpServletResponse): ActionForward +update(mapping: ActionMapping, form: ActionForm, request: HttpServletRequest, response: HttpServletResponse): ActionForward +delete(mapping: ActionMapping, form: ActionForm, request: HttpServletRequest, response: HttpServletResponse): ActionForward +

15、list(mapping: ActionMapping, form: ActionForm, request: HttpServletRequest, response: HttpServletResponse): ActionForwardCylinderDao+delete(String) +getCount() +getCylinder() +getCylinderVo() +list() +save() +update()2.5 球體(M5)模塊詳細(xì)設(shè)計(jì)2.5.1 程序描述：該模塊包括對(duì)球體的增刪改查操作，新增球體時(shí)輸入球體的圓點(diǎn)和半徑，然后保存球體信息。球體模塊還對(duì)球體進(jìn)行列表，并能

16、進(jìn)行編輯和刪除操作。在列表上方的快速搜索里面 可以輸入球體的名稱進(jìn)行模糊查詢。2.5.2 流程邏輯：列表保存球體信息到數(shù)據(jù)庫(kù)SphereAction-SphereDao: sphereDao = new SphereDao() +add(mapping: ActionMapping, form: ActionForm, request: HttpServletRequest, response: HttpServletResponse): ActionForward +preview(mapping: ActionMapping, form: ActionForm, request: Http

17、ServletRequest, response: HttpServletResponse): ActionForward +insert(mapping: ActionMapping, form: ActionForm, request: HttpServletRequest, response: HttpServletResponse): ActionForward +edit(mapping: ActionMapping, form: ActionForm, request: HttpServletRequest, response: HttpServletResponse): Acti

18、onForward +update(mapping: ActionMapping, form: ActionForm, request: HttpServletRequest, response: HttpServletResponse): ActionForward +delete(mapping: ActionMapping, form: ActionForm, request: HttpServletRequest, response: HttpServletResponse): ActionForwardSphereDaoaddSphere.jspeditSphere.jsp+list

19、(mapping: ActionMapping, form: ActionForm, request: HttpServletRequest, response: HttpServletResponse): ActionForward+delete(String) +getCount() +getSphere() +getSphereVo() +list() +save() +update()2.6 模型預(yù)覽（M6）模塊詳細(xì)設(shè)計(jì)2.6.1 程序描述：該模塊包括對(duì)立方體、圓錐體、圓柱體、球體的預(yù)覽，首先輸入 4種不同模型的名稱, 然后進(jìn)入預(yù)覽界面，預(yù)覽四種不同的模型。2.6.2 流程邏輯：2.6.3 類圖：previewShowPreviewModel1PreviewAction-cubeDao: CubeDao = new CubeDao() -sphereDao: SphereDao = new SphereDao() -cylinderDao: CylinderDao = new