数据库课程设计报告精选.doc

数据库课程设计报告 “onlinefood sales management system”, articlefirst analyzed,through analyzing problems putsforward systemdesign thought,use structurecomplete online sales managementfunctions, JSP,use Struts2 classicframe structure systems,easy maintain,stratified clear representation layer Struts2 management, business logiclayer management,data persistence layer Hibernate management Reportfrom requirements analysis systembegan, overall design, including systemfunction module design, process analysis overalldesign, databasedesign detail,including database concept design logicaldesign safetymodel design, etc. Final document presented system realization ways, including program module design mainfunction modules testresults, :Online food sales, JSP, Struts2,Spring, Hibernate, database design 广西大学计算机与电子信息学院 本科课程设计报告 系统可行性研究…………………………………………………………………………….….… 问题的提出………………………………………………………………………………….……3 分析问题…………………………………………………………………………………….……3 系统设计思想……………………………………………………………………………….……3 总体设计……………………………………………………………………………………….…... 系统功能模块设计及流程分析……………………………………………………………….….5 用户模块：……………………………………………………………………………….…5 管理员模块：…………………………………………………………………………….…6 架构总体设计………………………………………………………………………………….…6 Struts ……………………………………………………………………………………....6 Hibernate…………………………………………………………………………………..7 系统开发环境与运行环境……………………………………………………………………….7 数据库设计………………………………………………………………………………………... 数据库概念设计………………………………………………………………………………….7 数据库分析………………………………………………………………………………..7 1）食品购物系统关系到的实体…………………………………………………………8 2）实体属性………………………………………………………………………………8 3）实体之间的联系………………………………………………………………………8 E-R 图转换成关系模式…………………………………………………………………...9 1）由实体得到关系模式…………………………………………………………………9 2）由联系得到关系模式…………………………………………………………………9 数据库逻辑设计………………………………………………………………………………….9 安全模式设计…………………………………………………………………………………….13 数据库完整性设计………………………………………………………………………..13 数据库权限控制…………………………………………………………………………..13 系统实现…………………………………………………………………………………………… 程序模块设计…………………………………………………………………………………...13 程序目录结构……………………………………………………………………………..13 JSP 页面分为会员页面与管理员页面………………………