电子拍卖系统的设计与实现

毕业设计(论文)题目电子拍卖系统的设计与实现学生姓名专业班级机械04-3所在院系软件学院指导教师职称所在单位大连交通大学软件学院教研室主任完成日期2009年6月23日摘要本系统采用微软的WindowsXP为开发平台，MySQL为后台数据库，JSP为开发工具，最终开发出电子拍卖系统。并从技术和设计实现两方面论述了系统的设计和开发过程。在技术上，深入探讨了电子拍卖系统的工作原理，分析了拍卖过程的总流程。在设计实现上，以拍卖物资管理，客户管理，卖方拍卖项目管理，买方拍卖项目管理等主要模块来实现其功能。客户管理模块主要功能是删除存在不良记录的用户帐号，可随时撤掉劣质上传的产品，可以对数据库内的数据进行添加及删改，对用户可以进行权限设置。卖方拍卖项目管理功能是发布拍卖项目，制定拍卖规则，买方资质管理，拍卖监控等。买方拍卖项目管理功能是业务项目分配，在线质疑，在线申请，在线竞拍。该系统对其他拍卖系统的设计开发具有借鉴意义，它的投入运行将产生一定的经济利益。这篇论文的主要内容包括系统概述，系统需求分析，系统总体设计，数据库设计，系统详细设计和实现，系统测试六个方面，详细地阐述了电子拍卖的全过程。关键词：电子拍卖MySQLJSPB/S结构ABSTRACTThissystemusesMicrosoft'sWindowsXPisdevelopstheplatform,MySQListhebackstagedatabase,JSPisthedevelopmentkit,finallydevelopstheelectronicauctionsystem.Andfromatechnicalanddesignaspectstoachieveboththedesignanddevelopmentprocess.Technically,in-depthexplorationintotheworkoftheelectronicauctionsystemtheory,ananalysisoftheoverallprocessoftheauctionprocess.Inthedesigntoachieveinordertoauctionmaterialsmanagement,customermanagement,projectmanagementauctionseller,thebuyerauctionmanagementandothermajorprojectstoachieveitsfunctionmodules.Customermanagementmodulemainfunctionistodeletethebadrecordoftheexistenceoftheuseraccountcanberemovedatanytimetouploadlow-qualityproducts,thedatabasecanaddanddeletethedata,theusercansetuppermissions.Projectmanagementfunctionsoftheauctionthesellerisreleasedauctionitems,thedevelopmentofauctionrules,thebuyerqualifiedmanagement,monitoringtheauction.Buyer'sauctionbusinessprojectmanagementfunctionistheallocationofitems,onlinequery,onlineapplications,onlineauction.Theauctionsystemtoothersystemdesignanddevelopmentbelearned,anditsoperationwillhaveacertaindegreeofeconomicinterests.Themaincontentsofthispaper,includingsystemoverview,systemrequirementsanalysis,systemdesign,databasedesign,systemdesignandimplementationofadetailed,sixareasofsystemtesting,Detailthewholeprocessoftheelectronicauction.Keywords:EquipmentMySQLJSPB/Sstructure目录第一章系统概述..........................................................11.1课题来源及意义.................................................................................................................11.2国内外发展状况.................................................................................................................11.3系统开发环境及技术介绍.................................................................................................2第二章系统需求分析......................................................42.1功能需求.............................................................................................................................42.2性能需求分析.....................................................................................................................42.3可行性分析.........................................................................................................................52.4数据管理需求.....................................................................................................................52.5故障处理需求.....................................................................................................................62.6运行环境需求.....................................................................................................................6第三章系统总体设计......................................................73.1总体设计的原则.................................................................................................................73.2总体设计的原理................................................................................................................73.3系统功能版块划分.............................................................................................................73.4系统流程分析.....................................................................................................................83.5系统功能模块图.................................................................................................................9第四章数据库设计.......................................................104.1MySQL数据库管理系统.....................................................................................................104.2数据库的需求分析...........................................................................................................104.3外部设计...........................................................................................................................114.4实体关系E-R图设计.......................................................................................................114.5创建数据库.......................................................................................................................134.6数据库设计.......................................................................................................................134.7数据库保密设计...............................................................................................................164.8数据库的连接...................................................................................................................16第五章系统详细设计与实现...............................................175.1电子拍卖管理系统的登陆页设计...........................