基于EJB的财务管理系统文档

基于Ejb的财务管理系统设计与实现一、环境配置数据库：oracle9iWeb服务应用服务器：jboss6.0.0FinalIDE开发环境：myeclipse9.0操作系统：winXPorupdate二、数据库表/*==============================================================*//*Table:t_Account*//*==============================================================*/createtablet_Account(idINTEGERnotnull,codeVARCHAR2(30)notnull,nameVARCHAR2(40)notnull,indexVARCHAR2(30),moneyFLOATnotnull,memoVARCHAR2(200),isdeleteSMALLINTnotnull,constraintPK_T_ACCOUNTprimarykey(id))//*==============================================================*//*Table:t_AccountIn*//*==============================================================*/createtablet_AccountIn(idINTEGERnotnull,codeVARCHAR2(100)notnull,thedateTIMESTAMPnotnull,companyVARCHAR2(50)notnull,billcodeVARCHAR2(50),productVARCHAR2(50)notnull,accountVARCHAR2(30),numberVARCHAR2(30)notnull,numbertypeVARCHAR2(10),priceVARCHAR2(30)notnull,moneytogetFLOATnotnull,moneygetdFLOATnotnull,moneynotgetdFLOATnotnull,paytypeVARCHAR2(20)notnull,rakeoffFLOAT,rakeofftypeVARCHAR2(10),deadlineTIMESTAMP,departmentidINTEGERnotnull,personVARCHAR2(30)notnull,categoryinidINTEGERnotnull,indexVARCHAR2(100),memoVARCHAR2(150),isdeleteSMALLINTnotnull,constraintPK_T_ACCOUNTINprimarykey(id))//*==============================================================*//*Table:t_AccountMoneyGet*//*==============================================================*/createtablet_AccountMoneyGet(idINTEGERnotnull,accountidINTEGERnotnull,timeTIMESTAMPnotnull,companyVARCHAR2(40)notnull,moneyFLOATnotnull,categoryinidINTEGERnotnull,personVARCHAR2(30)notnull,memoVARCHAR2(150),isdeleteSMALLINTnotnull,constraintPK_T_ACCOUNTMONEYGETprimarykey(id))//*==============================================================*//*Table:t_AccountMoneyPay*//*==============================================================*/createtablet_AccountMoneyPay(idINTEGERnotnull,accountidINTEGERnotnull,timeTIMESTAMPnotnull,companyVARCHAR2(40)notnull,moneyFLOATnotnull,categoryoutidINTEGERnotnull,personVARCHAR2(30)notnull,memoVARCHAR2(150),isdeleteSMALLINTnotnull,constraintPK_T_ACCOUNTMONEYPAYprimarykey(id))//*==============================================================*//*Table:t_AccountOut*//*==============================================================*/createtablet_AccountOut(idINTEGERnotnull,codeVARCHAR2(100)notnull,thedateTIMESTAMPnotnull,companyVARCHAR2(50)notnull,billcodeVARCHAR2(50),productVARCHAR2(50)notnull,accountVARCHAR2(30),numberVARCHAR2(30)notnull,numbertypeVARCHAR2(10),priceVARCHAR2(30)notnull,moneytopayFLOATnotnull,moneypaidFLOATnotnull,moneynotpaidFLOATnotnull,paytypeVARCHAR2(20)notnull,rakeoffFLOAT,rakeofftypeVARCHAR2(10),deadlineTIMESTAMP,departmentidINTEGERnotnull,categoryoutidINTEGERnotnull,personVARCHAR2(30)notnull,indexVARCHAR2(100),memoVARCHAR2(150),isdeleteSMALLINTnotnull,constraintPK_T_ACCOUNTOUTprimarykey(id))//*==============================================================*//*Table:t_AccountTransfer*//*==============================================================*/createtablet_AccountTransfer(idINTEGERnotnull,accountfromidINTEGERnotnull,accounttoidINTEGERnotnull,timeTIMESTAMPnotnull,moneyFLOATnotnull,personVARCHAR2(30)notnull,memoVARCHAR2(150),isdeleteSMALLINTnotnull,constraintPK_T_ACCOUNTTRANSFERprimarykey(id))//*==============================================================*//*Table:t_Asset*//*==============================================================*/createtablet_Asset(idINTEGERnotnull,codeVARCHAR2(100)notnull,nameVARCHAR2(40)notnull,specificationsVARCHAR2(40),manufacturerVARCHAR2(50),productiontimeTIMESTAMP,thewaytogetVARCHAR2(40)notnull,departmentidINTEGER,statusVARCHAR2(20)notnull,numberVARCHAR2(30)notnull,priceFLOATnotnull,originalpriceFLOATnotnull,predictyearINTEGERnotnull,oldpercentINTEGER,computemethodVARCHAR2(20)notnull,internationcodeVARCHAR2(100),placeholdVARCHAR2(30)notnull,peopleholdVARCHAR2(20)notnull,memoVARCHAR2(150),assettypeidINTEGERnotnull,isdeleteSMALLINT,constraintPK_T_ASSETprimarykey(id))//*==============================================================*//*Table:t_AssetPicture*//*==============================================================*/createtablet_AssetPicture(idINTEGERnotnull,assetidINTEGERnotnull,constraintPK_T_ASSETPICTUREprimarykey(id))//*==============================================================*//*Table:t_AssetType*//*==============================================================*/createtablet_AssetType(idINTEGERnotnull,codeCHAR(10),nameVARCHAR2(40)notnull,parentidINTEGERnotnull,isdeleteCHAR(10)notnull,constraintPK_T_ASSETTYPEprimarykey(id))//*==============================================================*//*Table:t_CategoryIn*//*==============================================================*/createtablet_CategoryIn(idINTEGERnotnull,codeVARCHAR2(30)notnull,nameVARCHAR2(40)notnull,isdeleteSMALLINTnotnull,constraintPK_T_CATEGORYINprimarykey(id))//*==============================================================*//*Table:t_CategoryOut*//*==============================================================*/cr