家庭理财系统的设计与实现毕业论文

毕业论文（设计）论文(设计)题目家庭理财系统的设计与实现院系名称专业（班级）姓名（学号）指导教师系负责人完成时间I家庭理财系统的设计与实现中文摘要家庭财务管理系统就是我们常说的管理信息系统MIS(ManagementInformationSystem)中的一种，它是一个计算机软硬件资源以及数据库的人-机系统。随着信息技术，计算机技术的发展，在社会各领域都已经离不开信息系统的支持。本系统是在对当代社会家庭财务状况进行了全面分析的基础上，制做的关于处理家庭财产，家庭副业，家庭生活，家庭经营等方面的管理系统可以完成对各类信息的查看、查询、添加、删除、编辑、报表等功能。该系统是典型的财务管理系统,包括“账簿管理”、“家庭成员管理”、“收支项目管理”、“报表统计”四个项目模型，可对家庭成员、收支项目、收支金额等进行管理统计，配有多个快捷按钮使用简单。其开发主要包括后台数据库的建立链接和维护以及前端应用程序的开发两个方面。对于前者建立起数据一致性和完整性强、数据安全性好的库。而对于后者则要求应用程序功能完备,易使用等特点。经过分析以微软公司的SQLServer2000、以及MyEclipse和Tomcat为工具开发出来的系统,它有着最为灵活的数据库结构，对数据库应用有着良好的支持。本系统采用的是基于B/S模式的体系结构。关键词：家庭财务管理系统；SQLServer2000；JSP；B/SIITheManagementSystemoftheFamilyFinanceABSTRACTThemanagementsystemofthefamilyfinanceisthemanagementinformationsystem（MIS）thatweoftensay.Itisahuman-machinesystemofhardwareandsoftwareresourcesaswellasdatabase.Alongwithinformationtechnology,computertechnologydevelopment,wearenotallalreadygotawayfromsupportoftheinformationsysteminthesocialvariousdomains.Thissystemisthebasisofacomprehensiveanalysisofcontemporarysocialandfamilyfinancialsituation,makingfordealingwithfamilypropertyinhouseholdsidelineproduction,familylife,family-runmanagementsystemcancompleteallkindsofinformationtoview,query,add,delete,edit,reportandotherfunctions.Thesystemistypicalofthefinancialmanagementsystem,includingthebooks,familymanagement,thebalanceofpaymentsprojectmanagement,statisticalreportsfourprojectmodel,familymembers,incomeandexpenditureitems,theamountofmanagementstatistics,withmorethanoneshortcutbuttonsimpletouse.Includesthedevelopmentofback-enddatabasetoestablishthelink,andmaintenance,andfront-endapplicationdevelopmentaspects.Fortheformertoestablishdataconsistencyandintegrity,datasecurity,agoodlibrary.Forthelatterrequirestheapplicationfullyfunctional,easytousefeatures.MicrosoftSQLServer2000,aswellasMyEclipseandTomcatasatooltodevelopsystemsthroughanalysis,ithasthemostflexibledatabasestructure,haveagoodsupportfordatabaseapplications.ThesystemusestheB/Smodel-basedarchitecture.Keyword：familyfinancialmanagementsystem，structuredquerylanguageserver2000database，javascript，browser/serverIII目录中文摘要.................................................................................IABSTRACT................................................................................II第一章绪论..............................................................................11.1课题简介.........................................................................11.2系统可行性分析...................................................................11.3MyEclipse的介绍.................................................................21.4SQLServer2000数据库...........................................................21.5B/S体系结构.....................................................................31.6环境需求.........................................................................31.6.1软件环境需求...............................................................31.6.2硬件环境需求...............................................................4第二章系统需求分析......................................................................52.1系统结构分析初步.................................................................52.2系统设计思想.....................................................................52.3系统架构.........................................................................52.4数据库需求分析...................................................................6第三章系统总体设计......................................................................73.1系统功能模块细分.................................................................73.2数据库设计.......................................................................83.2.1数据库概念结构设计.........................................................83.2.2数据库逻辑结构设计.........................................................93.2.3数据库建表................................................................103.3．系统整体详细设计..............................................................12第四章系统实现.........................................................................134.1JDBC建立数据库连接的设计.......................................................134.2系统登录界面的设计..............................................................154.3主界面的设计....................................................................174.4账簿管理模块的设计..............................................................194.4.1.新增收支记录............................................................204.4.2.编辑收支记录............................................................224.4.3.查找收支记录............................................................244.4.4.删除收支记录............................................................264.5家庭成员管理模块的设计..........................................................264.5.1.新增用户................................................................274.5.2.删除已有用户............................................................294.5.3.编辑用户信息............................................................294.6收支项目模块的设计..............................................................314.7报表统计模块的设计..................................