Web框架课程设计报告住房公积金筹集管理系统.doc

软件职业技术学院CCUTSOFT2010-2011学年第一学期Web框架课程设计报告目 录一、团队构成及分工1二、进度计划2三、需求分析33.1 需求描述33.2 用况建模3四、项目功能设计44.1 总体设计44.2 算法设计5五、项目数据设计65.1 数据逻辑设计65.2 数据表设计7六、系统实现7七、关键代码17八、课程设计总结41一、团队构成及分工 指导教师签字： 年 月 日二、进度计划序号任务名称开始时间完成时间持续时间1分工、系统设计1-31-4一天2系统原型搭建1-41-5一天3模块编码开题答辩1-51-6一天4模块编码1- 61-11六天5进行系统测试1-111-12一天6程序的打包和发布、整理文档1-121-13一天7撰写课程设计报告、答辩1-131-14一天 三、需求分析3.1 需求描述筹集管理系统主要包括相关客户信息（单位开户、个人开户、单位资料修改、个人资料修改）、变更业务（封存、启封、比例变更、基数变更）、缴存登记入账（汇缴、补缴）、提取及销户（提取、个人注销、单位注销）、业务查询、凭证打印等业务。3.2 用况建模 图3. 1 用例图四、项目功能设计 4.1 总体设计柜员登录单位开户个人开户单位资料管理单位资料修改个人资料管理单位资料查询个人资料修改个人注销个人资料查询图4. 1 层次方框图4.2 算法设计 图4.2 活动图五、项目数据设计5.1 数据逻辑设计图5.1 数据库表5.2 数据表设计 表5-1用户信息表列名中文名列类型列注释可否为空USERID用户号DOUBLE主键自增不可以USERNAME用户姓名CHARACHER不可以USERPASS用户密码DOUBLE不可以LIMIT权限CHARACHER不可以表5-2系统参数表列名中文名列类型列注释可否为空默认值SEQNAME键值信息CHARACTER(20)可自定义序号键值信息,按此产生序号。不可以SEQ当前序号INTEGER从1开始，每次取完递增不可以MAXSEQ最大序号INTEGER不可以9999999DESC描述CHARACTER(40)不可以FREEUSE1备用1CHARACTER(20)可以表5-3单位信息表列名中文名列类型列注释可否为空默认值UNITACCNUM单位公积金账号CHARACTER(12)UNITACCNAME单位名称CHARACTER(100)不可以UNITADDR单位地址CHARACTER(60)不可以ORGCODE组织机构代码CHARACTER(20)不可以UNITCHAR单位类别CHARACTER(1)1-企业2-事业3-机关4-团体5-其他不可以UNITKIND企业类型CHARACTER(3)110-国有经济120-集体经济130-股份合作企业140-联营企业150-有限责任公司160-股份有限公司170-私营企业 190-其他企业200-港、澳、台商投资企业300-外商投资企业900-其他不可以SALARYDATE发薪日期CHARACTER(2)可以UNITPHONE联系电话CHARACTER(20)不可以UNITLINKMAN单位联系人CHARACTER(24)不可以UNITAGENTPAPNO经办人身份证号码CHARACTER(20)可以ACCSTATE账户状态CHARACTER(1)0正常9销户不可以BALANCE公积金余额DECIMAL(16,2)不可以BASENUMBER缴存基数DECIMAL(16,2)不可以UNITPROP单位比例DECIMAL(6,3)不可以PERPROP个人比例DECIMAL(6,3)不可以UNITPAYSUM单位月应缴额DECIMAL(16,2)不可以PERPAYSUM个人月应缴额DECIMAL(16,2)不可以PERSNUM单位人数INTEGER非销户人数不可以LASTPAYDATE最后汇缴月DATE不可以1899-12-01INSTCODE机构代码CHARACTER(8)不可以默认为0110OP柜员CHARACTER(4)不可以默认为111111CREATDATE建立日期DATE不可以REMARK备注CHARACTER(64)可以表5-4个人信息表列名中文名列类型列注释可否为空默认值ACCNUM个人公积金账号CHARACTER(12)0不可以UNITACCNUM单位公积金账号CHARACTER(12)0不可以OPENDATE开户日期DATEBALANCE公积金余额DECIMAL(16,2)PERACCSTATE个人账户状态CHARACTER(1)BASENUMBER缴存基数DECIMAL(16,2)UNITPROP单位比例DECIMAL(6,3)INDIPROP个人比例DECIMAL(6,3)LASTPAYDATE最后汇缴月DATE1899-12-01UNITMONPAYSUM单位月应缴额DECIMAL(16,2)PERMONPAYSUM个人月应缴额YPAYAMT本年汇补缴额DECIMAL(16,2)自然年度YDRAWAMT年提取额DECIMAL(16,2)自然年度YINTERESTBAL年度结息DECIMAL(16,2)INSTCODE机构代码CHARACTER(8)不可以默认为0110OP柜员CHARACTER(4)不可以默认为111111REMARK备注CHARACTER(64)可以六、系统实现1、柜员登录界面，柜员输入用户名、密码进入系统主页。如图6-1：图6-1登录2、成功登录后，进入主页面。如图6-2：图6-2主页3、点击单位业务，进入单位业务主页面。如图6-3：图6-3单位业务页面4、点击单位开户链接，进入单位开户页面。如图6-4：图6-4开户页面5、选择按单位公积金帐号搜索，并输入帐号，显示单位名及帐号。如图6-5：图6-5精确搜索6、选择按单位名称模糊搜索，输入“R”，显示含“R”单位。如图6-6:图6-6模糊搜索含“R”单位7、点击单位名称，显示单位详细资料。如图6-7：图6-7单位详细资料8、点击显示所有员工，显示所有员工姓名及帐号。如图6-8：图6-8显示所有员工9、点击员工姓名，可查到关于员工的基本信息。如图：6-9图6-9显示员工信息10、在单位资料页面，点击批量导入，进入批量导入页面。如图6-10：图6-10 Excel批量导入员工11、点击浏览，输入excel路径后，点击excel批量导入个人用户，进入成功页面。如图6-11：图6-11导入成功12、在主页面点击个人业务，进入个人业务主页。如图6-12：图6-12个人业务主页13、点击个人开户，进入个人开户页面。如图6-13：图6-13个人开户14、在个人业务主页点击查询个人帐户情况，进入个人帐户搜索页。如图6-14：图6-14个人帐户搜索15、个人帐户搜索页，输入个人帐号后，显示个人信息。如图：6-15图6-15搜索到的个人信息页面16、在个人信息修改页面，输入个人帐号，进入个人资料修改页面。如图6-16：图6-16个人资料修改七、关键代码1、 LoginActionpackage fund.action;import com.opensymphony.xwork2.ActionContext;import com.opensymphony.xwork2.ActionSupport;import fund.domain.User;import fund.service.UserFacade;import fund.service.UserFacadeImpl;public class LoginAction extends ActionSupport implements LoginActionImplprivate String username;private String userpass;public String getUsername() return username;public void setUsername(String username) this.username = username;public String getUserpass() return userpass;public void setUserpass(String userpass) this.userpass = userpass;private UserFacadeImpl userFacadeImpl;public LoginAction() userFacadeImpl= new UserFacade();public String login() boolean flag = false;User user=new User();user.setUsername(getUsername();user.setUserpass(getUserpass();try flag = userFacadeImpl.login(user);if (flag = true) ActionContext.getContext().getSession().put("op", user);return "loginSuccess" else return "loginError" catch (Exception e) e.printStackTrace();return "Error" 2、 UnitAddActionpackage fund.action;import java.sql.SQLException;import com.opensymphony.xwork2.ActionSupport;import fund.domain.Unit;import fund.service.UnitAddFacade;import fund.service.UnitAddFacadeImpl;public class UnitAddAction extends ActionSupport implements UnitAddActionImplprivate Unit unit;private UnitAddFacadeImpl unitAddFacadeImpl;public Unit getUnit() return unit;public void setUnit(Unit unit) this.unit = unit;public UnitAddAction()unitAddFacadeImpl=new UnitAddFacade();public String unitAdd()boolean flag=false;try flag=unitAddFacadeImpl.unitAdd(unit);System.out.print("gf"); catch (SQLException e) e.printStackTrace();if(flag=true)return "unitaddsuccess"elsereturn "unitaddfail"3、 UnitSearchActionpackage fund.action;import java.util.List;import com.opensymphony.xwork2.ActionSupport;import fund.domain.Unit;import fund.service.UnitSearchFacade;import fund.service.UnitSearchFacadeImpl;public class UnitSearchAction extends ActionSupport implements UnitSearchActionImplprivate String searchID;private String searchText;private List<Unit> unitlist;private UnitSearchFacadeImpl unitSearchFacadeImpl;public String getSearchID() return searchID;public void setSearchID(String searchID) this.searchID = searchID;public String getSearchText() return searchText;public void setSearchText(String searchText) this.searchText = searchText;public List<Unit> getUnitlist() Unit unit=new Unit();unit.setSearchID(getSearchID();unit.setSearchText(getSearchText();return unitSearchFacadeImpl.unitSearch(unit);public void setUnitlist(List<Unit> unitlist) this.unitlist = unitlist;public UnitSearchAction()unitSearchFacadeImpl=new UnitSearchFacade();public String unitSearch() if(getUnitlist().size()>0)System.out.println(getUnitlist().get(0)+"");return "unitsearchsuccess"else return "unitsearchfail"4、 UnitSearch2Actionpackage fund.action;import java.util.List;import com.opensymphony.xwork2.ActionSupport;import fund.domain.Unit;import fund.service.UnitSearch2Facade;import fund.service.UnitSearch2FacadeImpl;public class UnitSearch2Action extends ActionSupport implements UnitSearch2ActionImplprivate String searchID;public String getSearchID() return searchID;public void setSearchID(String searchID) this.searchID = searchID;public String getSearchText() return searchText;public void setSearchText(String searchText) this.searchText = searchText;private String searchText;private List<Unit> unitlist;public List<Unit> getUnitlist() Unit unit=new Unit();unit.setSearchID(getSearchID();unit.setSearchText(getSearchText();return unitSearch2FacadeImpl.unitSearch(unit);public void setUnitlist(List<Unit> unitlist) this.unitlist = unitlist;private UnitSearch2FacadeImpl unitSearch2FacadeImpl;public UnitSearch2Action()unitSearch2FacadeImpl=new UnitSearch2Facade();public String unitSearch() if(getUnitlist().size()>0)return "unitsearchsuccess"else return "unitsearchfail"5、 UnitUpdateActionpackage fund.action;import java.util.List;import com.opensymphony.xwork2.ActionSupport;import fund.domain.Unit;import fund.service.UnitSearchFacade;import fund.service.UnitSearchFacadeImpl;public class UnitUpdateAction extends ActionSupport implements UnitUpdateActionImplprivate String searchID;private String searchText;private List<Unit> unitlist;private UnitSearchFacadeImpl unitSearchFacadeImpl;public String getSearchID() return searchID;public void setSearchID(String searchID) this.searchID = searchID;public String getSearchText() return searchText;public void setSearchText(String searchText) this.searchText = searchText;public List<Unit> getUnitlist() Unit unit=new Unit();unit.setSearchID(getSearchID();unit.setSearchText(getSearchText();return unitSearchFacadeImpl.unitSearch(unit);public void setUnitlist(List<Unit> unitlist) this.unitlist = unitlist;public UnitUpdateAction()unitSearchFacadeImpl=new UnitSearchFacade();public String unitUpdate() if(getUnitlist().size()>0)System.out.println(getUnitlist().get(0)+"");return "unitupdatesuccess"else return "unitupdatefail"6、 UnitUpdate2Actionpackage fund.action;import com.opensymphony.xwork2.ActionSupport;import fund.domain.Unit;import fund.service.UnitUpdateFacade;import fund.service.UnitUpdateFacadeImpl;public class UnitUpdate2Action extends ActionSupport implements UnitUpdate2ActionImplprivate Unit unit;public Unit getUnit() return unit;public void setUnit(Unit unit) this.unit = unit;private UnitUpdateFacadeImpl unitUpdateFacadeImpl;public UnitUpdate2Action()unitUpdateFacadeImpl=new UnitUpdateFacade();public String unitUpdate() System.out.print("khskdjh$#$#$#$");System.out.print(unit.getUnitaccnum();System.out.print(unit.getOrgcode();System.out.print(unit.getSalarydate();boolean flag=false;flag=unitUpdateFacadeImpl.unitUpdate(unit);if(flag=true)return "unitupdatesuccess"elsereturn "unitupdatefail"7、 ShowAllPersonActionpackage fund.action;import java.util.List;import com.opensymphony.xwork2.ActionSupport;import fund.domain.Person;import fund.domain.Unit;import fund.service.ShowAllPersonFacade;import fund.service.ShowAllPersonFacadeImpl;public class ShowAllPersonAction extends ActionSupport implements ShowAllPersonActionImplprivate ShowAllPersonFacadeImpl showAllPersonFacadeImpl;private String unitaccnum;public String getUnitaccnum() return unitaccnum;public void setUnitaccnum(String unitaccnum) this.unitaccnum = unitaccnum;private List<Person> personlist;public List<Person> getPersonlist() Unit unit=new Unit();unit.setUnitaccnum(getUnitaccnum();return showAllPersonFacadeImpl.showAllPerson(unit);public void setPersonlist(List<Person> personlist) this.personlist = personlist;public ShowAllPersonAction()showAllPersonFacadeImpl=new ShowAllPersonFacade();public String showAllPerson() if(getPersonlist().size()>0)return "showallpersonsuccess" elsereturn "showallpersonfail"8、PersonAddActionpackage fund.action;import com.opensymphony.xwork2.ActionSupport;import fund.domain.Person;import fund.service.PersonAddFacade;import fund.service.PersonAddFacadeImpl;public class PersonAddAction extends ActionSupport implements PersonAddActionImplprivate Person person; public Person getPerson() return person;public void setPerson(Person person) this.person = person;private PersonAddFacadeImpl personAddFacadeImpl;public PersonAddAction() personAddFacadeImpl=new PersonAddFacade();public String personAdd()boolean flag=false;try flag =personAddFacadeImpl.personAdd(person);if(flag!=false) return "addSuccess" else return "addError" catch (Exception e) e.printStackTrace();return "Error"9、PersonSearchActionpackage fund.action;import java.util.List;import fund.domain.Person;import fund.service.PersonSearchFacade;import fund.service.PersonSearchFacadeImpl;public class PersonSearchAction private List<Person> list;Person person;public Person getPerson() return person;public void setPerson(Person person) this.person = person; private PersonSearchFacadeImpl personSearchFacadeImpl;public PersonSearchAction() personSearchFacadeImpl= new PersonSearchFacade();public String personSearch()try list = personSearchFacadeImpl.personSearch(person);if (list.size()>0) return "searchSuccess" else return "searchError" catch (Exception e) e.printStackTrace();return "Error"public List<Person> getList() return personSearchFacadeImpl.personSearch(person);public void setList(List<Person> list) this.list = list;10、PersonUpdateActionpackage fund.action;import java.util.List;import fund.domain.Person;import fund.service.PersonUpdateFacade;import fund.service.PersonUpdateFacadeImpl;public class PersonUpdateActionprivate Person person;private List<Person> list;public Person getPerson() return person;public void setPerson(Person person) this.person = person;private PersonUpdateFacadeImpl personUpdateFacadeImpl;public PersonUpdateAction()personUpdateFacadeImpl=new PersonUpdateFacade();public String personUpdate()try list = personUpdateFacadeImpl.personUpdate(person);if (list.size()>0) return "updateSuccess" else return "updateError" catch (Exception e) e.printStackTrace();return "Error"public List<Person> getList() return list;public void setList(List<Person> list) this.list = list;11、PersonUpdateInfoActionpackage fund.action;import java.util.List;import com.opensymphony.xwork2.ActionSupport;import fund.domain.Person;import fund.service.PersonUpdateInfoFacade;import fund.ser