商铺管理系统

#2・2・7Admin管理员表FieldTypeCollationNullKeyDefaultCommentanoint(20)(NULL)NOPRInull编号sexvarchar(50)utf8generalciYESnull性别namevarchar(40)utf8generalciYESnull姓名idvarchar(lOO)(NULL)YESnull身份证号telInt(20)utf8generalciYESnullxaddressvarchar(100)(NULL)YESnull地址salaryint(20)utf8generalciYESnull工资salaryaddint(20)(NULL)YESnull工资津贴passwordvarchar(20)(NULL)YESMULnull密码图表2.2.7Bank银行表FieldTypeCollationNullKeyDefaultCommentnoint(20)(NULL)NOPRInull编号namevarchar(40)utf8generalciYESnull账户名称remainderdouble(NULL)YESnull期初余额add_moneydouble(NULL)YESnull本期增加余额less_moneydouble(NULL)YESnull本期减少余额terminaldouble(NULL)YESnull期末余额图表2.2.8Storehouse商品管理表FieldTypeCollationNullKeyDefaultCommentStore_noint(20)(NULL)NOPRInull编号Storenamevarchar(40)utf8generalciYESnull仓库名称StoreadminInt(20)(NULL)YESnull负责人remarksVarchar(20)utf8generalciYESnull备注

OederlOrIncome釆购付款单表FieldTypeCollationNullKeyDefaultCommentnoint(20)(NULL)NOPRInull编号occurdatedate(NULL)YESnull发成日期allmoneydouble(NULL)YESnull总金额rebatemoneydouble(NULL)YESnull折扣金额incomemoneydouble(NULL)YESnull已收金额noincomemoneydouble(NULL)YESnull未收金额presentmoneydouble(NULL)YESnull本次收款sellutilidint(ll)(NULL)YESnull付款单位adminidint(ll)(NULL)YESnull收款账户banknameidint(11)(NULL)YESMULnull经办人员图表2.2.102.2.12数据库架构图nanteCM-5con-1eunrt.prDp^ar^y.idU唱k*工.F-宇尸unlCpropenvJdunit_prap«rtv«ddr«HH5-SlDryi^larv_addD&s^v-ordp^o^Snce-[|忸RYK>事'nanteCM-5con-1eunrt.prDp^ar^y.idU唱k*工.F-宇尸unlCpropenvJdunit_prap«rtv«ddr«HH5-SlDryi^larv_addD&s^v-ordp^o^Snce-[|忸RYK>事'pr&vin=«_idprovince■ddFHSBSDlS^5BlBr¥_&(ldp«..iA*ard^5M-CrZ1■5lDF_nO«1口r・_n・snoi^e：_BdmlnramarRaenoun!<_namc-unit_■日Pr«・・2lp_-：Od4bankaccounCnuniMr口p««r_■cccunt_n■e■pro¥^nce_8dunit_pnapBrtY_J^^Sni*rk5p^-ceJ」DM*k_up:-■i<i_ardHr_nurrt3-«rhaM_ardcT-_prlccr-BHierarnMindar严C!xnm!Kirc¥_ivpe_'duuernndityhcarnmndlcy-iyM-'ducmE=dity_nHiE・el_numtM-rr«：hn5e_emry_nurnfrernd-iHa«_rBfcurrii_nurnbHrIi_jorH■■jnueb■ro^der_p^c«e：cut_nurrto«rrefrum_numberin-=am«i_nurrti«ropierjdigincorrmndrcy_codHII_priEBLII_P<-ieb2<«jr_d.&rek3mik_datHstore_nsrinie-min_nHm«_idcoinni'：'d'^Y_.coiJeoomm.：.d!Cv_nBAiemedal_numbHrunitnumb-arincome-Ftore.nflme^idai_rl_irtar»_nBm«_idadm!n_namejdincorne_nioneY-naincam«i_rnan<iYtxss*nt_rnonev■■ll_util_id■■dmin_„idtf&nJfl&Edldbanksdd_m&nevterminal3性能需求3.1数据精确度由于采用MySql数据库存储，在本程序设计时全部采用utf-8编码，数据精确度为java自带类型各自精确度，基本可以确保使用需要。3・2数据安全性由于采用MySql数据库存储，密码及权限系统设置，使得本程序的安全性有了保证，在数据库的密码采取MD5方式进行加密操作。3.3时间特性本系统的数据库较小，所以程序在响应时间，数据更新处理时间上性能是比较突出的。而且也正由于数据量相对较少，故在数据传输时间和系统运行时间上表现的较让人满意。3.3适应性B/S架构以及java的跨平台特性，使得本系统的适应性很高，用户只需要在客户端有IE6以上版本的浏览器即可正常使用本系统。4核心代码及技术4.1属性开发及运行环境：开发工具：Eclipes(JavaEE)数据库：mysql开发语言：Java具体用到的技术：Servlet、JSP、Struts2、JDBC、Hibernate、Spring等功能简介:…用户界面要求友好、绚丽，操作方便。首先用户登录,登陆完毕后按权限显示功能列表,通过点击功能列表中某一功能将所要—点功能页面打开,然后可以查看相应功能的详细信息，并对相关信息进行增加修改,删除等编辑。4.2.1数据库描述米用utf-8编码，支持中文。Spring中数据库配置如下：〈beanid二"dataSource"class二"org.apachexmons.dbcp.BasicDataSource"destroy-method二"close"〉〈propertyname二"driverClassName"〉〈value〉com.mysql.jdbc.Driver〈/value〉〈/property〉〈propertyname二"url"〉〈value〉jdbc:mysql://localhost:3306/dataj?useUnicode二true&characterEncoding二utf8〈/value〉</property〉<propertyname二"username"〉〈value〉root〈/value></property〉<propertyname二"password"〉〈value〉root〈/value></property〉〈/bean〉4.2.2struts・xml〈struts〉〈packagename="login"namespace="/"extends="struts-default〉<!--配置action--〉<!——================Login==================——〉<actionname="LoginAction"class="LoginAction"method="login"><resultname="success>/index.jsp</result〉<resultname="false">loginErr.jsp〈/result〉</action〉4.3员工表查询〈s:formaction="insertpurchase_payment"method="post">收款单位：收款账号：〈scripttype="text/javascript"src="../My97DatePicker/WdatePicker.j></script>付款日期：〈inputid="oederOrIncome.occurDate"name="oederOrIncome.occurDate"value=<imgonclick="WdatePicker({el:$dp.$('oederOrIncome.occurDate')})"src="My97DatePicker/skin/datePicker.gif"_fcksavedurl="My97DatePicker/skin/datePicker.gifwidth="16"height="22"align="absmiddle><hrwidth="800"color="yellow">〈!--添加下划线一>经办人员<tableborder="1"cellspacing="0"bordercolor="yellow"width="800px"><tr><td><s:textfieldname="oederOrIncome.allMoney"label="总金额'value="%{oederOrIncome.allMoney}/>〈/td><td>〈s:textfieldname="oederOrIncome.rebateMoney"label="折扣金额'value="%{oederOrIncome.rebateMoney/>〈/td>〈td>〈s:textfieldname="oederOrIncome.incomeMoney"label="已收金额'value="%{oederOrIncome.incomeMoney/>〈/td>〈td>〈s:textfieldname="oederOrIncome.noincomeMoneylabel="未收金额’value="%{oederOrIncome.noincomeMoney/>〈/td><td>〈s:textfieldname="oederOrIncome.presentMoney"label="本次收款'value="%{oederOrIncome.presentMoney/>〈/td></tr><tr>〈tdcolspan="3"align="center"><s:submitvalue="提交付款单'align="center"onclick="window.close()/></td>

</tr></table〉4.4程序部分结构一呼JavaResciizfcez1曰於+-1+飞++*£(■ci：-Ti-zhcipm:iTLigt!.acticin廿COTi-shupm：!TL=±ge.d=i-i：»■i-rcon-Ehopni:irLige.die-.1rripljj-COTi-zhupn注工L耳呂E:.d-：ifTi：=Lin+i:十ii；+"i+>1++i:1+++“ii；+-ii:++++-++ii；+-ii+rru'?ti・吕hQpm:■巨已.s叱rviq哙rrcOTi-shopm:inige.zervice.impll^rcOTi-zhopm!iTL：igy.口til營hib^rn:Ltefg.xmlKetmte_：=l»1^：=ltlce.>:m]_JCs七riite_cu三t■:<mer.:<ml托stmte_1■:>p;itl.xnl勘sti_iits_L'tiier1xnlJC〔etrntE_pnn-chaze_entry.xmlJC|wtmts_fnn_nhaErder.兀istrutt：J-ijiTient.::mlKs七mtE_pnu-ckase_r&tm~rL.xm1JCetmte_eell_urder.xmlKetmts_Eel_l_uut.:<ml勘5s_s^ll_return.北ml)C|呂ti_nts_stiir«hems«.xml勘£tmtS_SUpplLQI-.K(TilJC|EtrutE.KRil—=話Lil«r：u-1+£+芒岂」EjVRLiTir：i2-1ee首」JT1ES7rstemLlbr：=Lry[J：=l^：=lSE-1.6]岂」'ffsbAppLibrari已=4.5.jsp及配置结构+(_■imagfI・niiTLSge+0META-IHT+._■MySYBatePicker+」script-&WEB-IN?j[+&lib+XapplicatiQnContext.xmlI由龌web.i:nil得i1■明g]申遍由”遛得i1■明g]申遍由”遛*—hibeiTLate.reveng.xml4.6整体结构严JavaJieiinifCHE-謬src匡)•…田匚ijFi.shuprTi：±TLag已.也匚ticjlL|H"*curri.5hop[Ti：±rLage.dao由…l：l：irT,-shi：iprTi：=LTL：igt!.il：±i：i.lmpl十！.-cufri.stLupfTHiTLag已.dijiri呂in.Icurri.zhop[Ti：±rLagQ.zvice由•••{^corri.Ehi：iprTi==LTL：kgs.iriiplji-十！.「CufTl.zhopfTHiTLag已.LltllIhiber口Pt2-cfg.MfTil£)-[Xjstruts_：Lilv：=JiCa.irriilii_i0"lK]5trutz_custrim.snlistrute_10gin.2-[ml田…圍5truts_Qther.ii_j0-lXjstrutzjurchaze_eiLtry.irnl©■■■[Xjstrutsjurchawp_iji-dyr.ktiL亠}{5ti-u+s_piirchase_pajinsni.ij_j0-iXjstrutsjiirchase_retui-n.Kdili0,,,|xstrutweelliji_der.ktiI田…園atruts_5ell_ont.xvnli_0-[X