javaEE-课程设计-个人财务管理系统

软件学院课程设计报告书课程名称JavaEE课程设计设计题目个人财务系统专业班级软件工程学号xxxxxxxxx07姓名xxxxx指导教师姜彦吉2011年12月11设计时间2011年12月12日——12月16日2设计目的JavaEE课程设计是对所学JavaEE与中间件课程的小结，是提高学生对所学知识综合应用能力的一种方式，是集中实践性环节之一。要求同学们对课程中所学习到的知识综合运用，开发有一定规模的JavaWeb程序。3设计任务设计个人帐务管理系统，要求用户以合法的身份登录后可以对系统进行操作，用户可以查看，添加，删除和计算某段时间内帐务的收入和支出信息等。帐务信息包括收入和支出两种，还有日期和备注。4设计内容4.1设计题目个人财务管理系统4.1.1系统功能要求用只有拥有合法身份才能登录系统，用以合法身份登录后可以产看帐务信息、添加帐务信息、删除帐务信息、分别统计某个时间段内的收入和支出总额。4.1.2数据库存储要求数据的存储要求：收入数额，支出数额，备注，日期4.1.3数据库的设计表—1（数据存储要求）列名称数据类型长度idbigint8incomemoneymoney8costmoneymoney82recordvarchar50timevarchar8图—1（数据库存储数据）4.1.4系统构造关系noyes图—2（jsp页面构造）登陆窗口密码保存查询删除计算帐目操作界面3图—3（Java类功能调用）4.2Jsp页面设计4.2.1登录界面图—4（登录界面）代码如下：formaction=servlet/LoginServletmethod=postcenter欢迎登陆个人财务统计系统！/centercenter用户名称:inputtype=textname=usernamevalue=br/centercenter用户密码:inputtype=textname=passwordvalue=br/centerJsp页面传递参数调用servlet类参数保存方法servlet查询方法servlet删除方法servlet计算方法servlet保存方法dao类查询方法dao类删除方法dao类计算方法dao类4centerinputtype=submitname=subimtvalue=登录inputtype=resetname=resetvalue=重置/center/form4.2.2登录成功界面图—5（登录成功查询界面）代码如下：%Stringusername=(String)session.getAttribute(name);if(username!=null){%center欢迎登录：%=username%/center%}%formaction=servlet/AccountController?arg=2method=post增加帐目明细请输入：center收入数额：inputtype=textname=incomemoneyvalue=br支出数额：inputtype=textname=costmoneyvalue=br附加备注：inputtype=textname=recordvalue=br输入日期：inputtype=textname=timevalue=brinputtype=submitname=submit1value=保存brbr5/center/formformaction=servlet/AccountController?arg=1method=post查询帐目明细请点击：centerinputtype=submitname=submit2value=查询/centerbr/form删除帐目信息请如下：formaction=servlet/AccountController?arg=3method=post请输入要删除帐目的日期：centerinputtype=textname=time/centercenterinputtype=submitname=submit3value=删除/center/formformaction=servlet/AccountController?arg=4method=postcenter起始Id号:inputtype=textname=id1value=br/centercenter终止Id号:inputtype=textname=id2value=br/centercenterinputtype=submitname=submit4value=计算/center/form4.2.3查询结果界面图—6（查询结果界面）4.3Java方法设计4.3.1Servlet类6控制增删改操作的servlet类代码设计如下：publicclassAccountControllerextendsHttpServlet{protectedvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{doPost(request,response);}protectedvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{intarg=Integer.parseInt(request.getParameter(arg));switch(arg){case1:this.findAllAccount(request,response);break;case2:this.saveAllAccount(request,response);break;case3:this.deleteSomeAccount(request,response);break;case4:this.caculateAccount(request,response);break;}}protectedvoidcaculateAccount(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{inta=0;intb=0;a=Integer.parseInt(request.getParameter(id));b=Integer.parseInt(request.getParameter(id));7AccountDaoaccountDao=newAccountDao();Listlist2=accountDao.caculateAccount(a,b);request.setAttribute(result,list2);RequestDispatcherrdt1=request.getRequestDispatcher(/Result1.jsp);rdt1.forward(request,response);}publicvoidfindAllAccount(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{AccountDaoaccountDao=newAccountDao();Listlist=accountDao.findAllAccount();request.setAttribute(accounts,list);RequestDispatcherrdt=request.getRequestDispatcher(/Result.jsp);rdt.forward(request,response);}publicvoidsaveAllAccount(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{request.setCharacterEncoding(gbk);doubleincomemoney=0.0;doublecostmoney=0.0;incomemoney=Double.parseDouble(request.getParameter(incomemoney));costmoney=Double.parseDouble(request.getParameter(costmoney));Stringrecord=(String)request.getParameter(record);Stringtime=(String)request.getParameter(time);MyAccountmyAccount=newMyAccount();myAccount.setIncomemoney(incomemoney);myAccount.setCostmoney(costmoney);8myAccount.setRecord(record);myAccount.setTime(time);AccountDaoaccountDao=newAccountDao();try{accountDao.saveAllAccount(myAccount);}catch(Exceptione){e.printStackTrace();}this.findAllAccount(request,response);}publicvoiddeleteSomeAccount(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{request.setCharacterEncoding(gbk);Stringtime=request.getParameter(time);MyAccountmyAccount=newMyAccount();myAccount.setTime(time);AccountDaoaccountDao=newAccountDao();try{accountDao.deleteSomeAccount(myAccount);}catch(Exceptione){e.printStackTrace();}this.findAllAccount(request,response);}}9密码验证的Servlet类的代码如下：publicclassLoginServletextendsHttpServlet{publicvoiddoGet(HttpServletRequestreq,HttpServletResponseresp)throwsServletException,IOException{doGet(req,resp);}publicvoiddoPost(HttpServletRequestreq,HttpServletResponseresp)throwsServletException,IOException{Stringusername=req.getParameter(username);Stringpassword=req.getParameter(password);Useruser=newUser();user.setUsername(username);user.setPassword(password);HttpSessionsession=re