基于s2sh架构的课程设计实训教学示例项目——《客户关系管理crm系统》——分页查询显示企业客户信息

基于S2SH架构的课程设计实训教学示例项目客户关系管理CRM系统分页查询显示企业客户信息111了解数据分页显示的实现原理1、编程实现分为两个阶段（1）第1次访问时默认显示第1页的数据，并且显示出分页导航条（2）第2次访问时将显示指定页号的目标页中的数据2、第1次访问的程序流程设置包装分页状态的PAGESTATEPO中的CURRENTPAGENUMBE为1和ONEPAGESIZE为指定的值（每页为20条数据）按照分页状态的要求进行数据访问，获得目标页中的具体数据将查询的目标页数据LIST集合和分页状态对象PAGESTATEPO保存到REQUEST对象中跳转到显示查询结果的页面中显示出目标页中的数据，在页面中获得分页状态对象PAGESTATEPO中的相关数据，动态构建出分页导航条和控制分页按钮3、第2次访问的程序流程设置包装分页状态的PAGESTATEPO中的CURRENTPAGENUMBE为目标页数和ONEPAGESIZE为指定的值（每页为20条数据）按照分页状态的要求进行数据访问，获得目标页中的具体数据将查询的目标页数据LIST集合和分页状态对象PAGESTATEPO保存到REQUEST对象中跳转到显示查询结果的页面中显示出目标页中的数据，在页面中获得分页状态对象PAGESTATEPO中的相关数据，构建出分页导航条4、设计分页导航条中的导航按钮（1）分页导航条中的导航按钮应用表格定位各个导航超链接（2）各个导航按钮的状态判断共有ONEPAGESTATEPOTOTALNUMBEROFELEMENTS条记录，当前是第ONEPAGESTATEPOCURRENTPAGENUMBER/ONEPAGESTATEPOTOTALPAGENUMBER页转到第页5、编程分页导航条中的控制功能的JAVASCRIPT脚本程序FUNCTIONFASTGOTOFIRSTTARGETPAGECREATELOADSTATUSIMAGECSSFILTERWINDOWLOCATIONHREF“PAGECONTEXTREQUESTCONTEXTPATH/ENTERPRISECUSTOMERINFOMANAGEACTIONQUERYTARGETPAGEENTERPRISECUSTOMERINFOACTION“TARGETPAGECOUNTER1“FUNCTIONFASTGOTOBACKTARGETPAGECREATELOADSTATUSIMAGECSSFILTERWINDOWLOCATIONHREF“PAGECONTEXTREQUESTCONTEXTPATH/ENTERPRISECUSTOMERINFOMANAGEACTIONQUERYTARGETPAGEENTERPRISECUSTOMERINFOACTION“TARGETPAGECOUNTERONEPAGESTATEPOPREVIOUSPAGENUMBER“FUNCTIONFASTGOTONEXTTARGETPAGECREATELOADSTATUSIMAGECSSFILTERWINDOWLOCATIONHREF“PAGECONTEXTREQUESTCONTEXTPATH/ENTERPRISECUSTOMERINFOMANAGEACTIONQUERYTARGETPAGEENTERPRISECUSTOMERINFOACTION“TARGETPAGECOUNTERONEPAGESTATEPONEXTPAGENUMBER“FUNCTIONFASTGOTOLASTTARGETPAGECREATELOADSTATUSIMAGECSSFILTERWINDOWLOCATIONHREF“PAGECONTEXTREQUESTCONTEXTPATH/ENTERPRISECUSTOMERINFOMANAGEACTIONQUERYTARGETPAGEENTERPRISECUSTOMERINFOACTION“TARGETPAGECOUNTERONEPAGESTATEPOLASTPAGENUMBER“FUNCTIONCHECKTARGETPAGECOUNTERISDIGITSTARGETPAGECOUNTERINPUTFIELDOBJECT,USERINPUTTARGETPAGECOUNTERIFUSERINPUTTARGETPAGECOUNTERNULL|USERINPUTTARGETPAGECOUNTERLENGTH0RETURNTRUE/如果待检查的字符串为空字符串，则不进行检查/检查所输入的目标页码值是否为数字IFISDIGITSININPUTEDSTRINGUSERINPUTTARGETPAGECOUNTERWINDOWALERT“要转向的目标页码值应该为数字“TARGETPAGECOUNTERINPUTFIELDOBJECTVALUE“TARGETPAGECOUNTERINPUTFIELDOBJECTFOCUSRETURNFALSERETURNTRUEFUNCTIONFASTGOTOTARGETPAGEVARTARGETPAGECOUNTERVARTOTALPAGENUMBERTOTALPAGENUMBERONEPAGESTATEPOTOTALPAGENUMBERTARGETPAGECOUNTERDOCUMENTGETELEMENTBYID“TARGETPAGECOUNTERTAGID“VALUEIFTARGETPAGECOUNTERNULL|TARGETPAGECOUNTER“|TARGETPAGECOUNTERLENGTH0ALERT“请输入要转向的具体目标页码值“RETURNFALSEIFTARGETPAGECOUNTER0ALERT“要转向的目标页码值不应该为0“DOCUMENTGETELEMENTBYID“TARGETPAGECOUNTERTAGID“VALUE“RETURNFALSEIFTARGETPAGECOUNTERTOTALPAGENUMBERALERT“要转向的目标页码值应该小于最大页数“TOTALPAGENUMBER“DOCUMENTGETELEMENTBYID“TARGETPAGECOUNTERTAGID“VALUE“RETURNFALSECREATELOADSTATUSIMAGECSSFILTERWINDOWLOCATIONHREF“PAGECONTEXTREQUESTCONTEXTPATH/ENTERPRISECUSTOMERINFOMANAGEACTIONQUERYTARGETPAGEENTERPRISECUSTOMERINFOACTION“TARGETPAGECOUNTER“TARGETPAGECOUNTER“112应用分页查询相关技术实现显示企业客户信息的功能1、与企业信息查询结果显示页面相关的资源文件（1）CSS样式文件RIGHTQUERYENTERPRISECUSTOMERRESULTCSSCHARSET“GB18030“IMPORTURL“/INDEXCOMMONSTYLECSS“THEOUTERWARPERWIDTH100FIRSTROW_THEOUTERWARPERHEIGHT30PXWIDTH100MARGINBOTTOM0PXMARGINTOP0PXFIRSTCOLUMN_FIRSTROW_THEOUTERWARPERFLOATLEFTWIDTH12PXHEIGHT30PXMARGINLEFT0PXFIRSTCOLUMN_FIRSTROW_THEOUTERWARPERIMGWIDTH12PXHEIGHT30PXMARGINLEFT0PXSECONDCOLUMN_FIRSTROW_THEOUTERWARPERFLOATLEFTPOSITIONRELATIVETOP5PXSECONDCOLUMN_FIRSTROW_THEOUTERWARPERIMGPOSITIONRELATIVETOP3PXSECONDCOLUMN_FIRSTROW_THEOUTERWARPERSPANFONTWEIGHTBOLDTHIRDCOLUMN_FIRSTROW_THEOUTERWARPERFLOATRIGHTWIDTH16PXHEIGHT30PXFOURCOLUMN_FIRSTROW_THEOUTERWARPERFLOATRIGHTHEIGHT30PXPADDINGTOP5PXFOURCOLUMN_FIRSTROW_THEOUTERWARPERIMGWIDTH14PXHEIGHT14PXMARGINLEFT5PXSELECTINPUTSTYLEBORDERTOPSTYLENONEBORDERRIGHTSTYLENONEBORDERBOTTOMSTYLENONEBORDERLEFTSTYLENONEFONTSIZE12PXFONTFAMILY“宋体“MARGINRIGHT10PXDATATABLETAGIDWIDTH100BORDERTOPWIDTH0PXBORDERRIGHTWIDTH0PXBORDERBOTTOMWIDTH0PXBORDERLEFTWIDTH0PXBORDERTOPSTYLENONEBORDERRIGHTSTYLENONEBORDERBOTTOMSTYLENONEBORDERLEFTSTYLENONELITTLEINPUTSTYLE_INDATAFORMWIDTH100PXHEIGHT20PXBORDERSOLID1PXCCCFIRSTROWFIRSTCOLUMNTDTAGIDWIDTH8PXSECONDCOLUMNDATATABLETAGIDWIDTH100BORDER0PXNONEFFFFFFDATATHEADCELLCSSCLASSSTYLEHEIGHT22PXTEXTALIGNCENTERFIRSTCOLUMNTDTAGIDWIDTH5PXSECONDCOLUMNTDTAGIDWIDTH40PXTHIRDCOLUMNTDTAGIDWIDTH50PXFOURCOLUMNTDTAGIDWIDTH50PXFIFTHCOLUMNTDTAGIDWIDTH65PXSIXTHCOLUMNTDTAGIDWIDTH100PXSERVENCOLUMNTDTAGIDWIDTH70PXEIGHTTHCOLUMNTDTAGIDWIDTH70PXNINETHCOLUMNTDTAGIDWIDTH70PXTENTHCOLUMNTDTAGIDWIDTH90PXELEVENTHCOLUMNTDTAGIDWIDTHAUTODATACELLCSSCLASSSTYLEHEIGHT20PXTEXTALIGNCENTERFIRSTROWTHIRDCOLUMNTDTAGIDWIDTH8PXTHIRDROW_THEOUTERWARPERHEIGHT35PXWIDTH100MARGINBOTTOM0PXMARGINTOP0PXFIRSTCOLUMN_THIRDROW_THEOUTERWARPERFLOATLEFTWIDTH12PXHEIGHT35PXMARGINLEFT0PXFIRSTCOLUMN_THIRDROW_THEOUTERWARPERIMGWIDTH12PXHEIGHT35PXMARGINLEFT0PXSECONDCOLUMN_THIRDROW_THEOUTERWARPERFLOATLEFTSECONDCOLUMN_THIRDROW_THEOUTERWARPERSPANCOLOR03515DPOSITIONRELATIVETOP10PXTHIRDCOLUMN_THIRDROW_THEOUTERWARPERFLOATRIGHTWIDTH16PXHEIGHT35PXFOURCOLUMN_THIRDROW_THEOUTERWARPERFLOATRIGHTDATAITEMSPERPAGESELECTIDPOSITIONRELATIVETOP7PXSOMEONEORDERMETHODSELECTIDPOSITIONRELATIVETOP7PXGOFIRSTPAGEIMGIDWIDTH37PXHEIGHT15PXPOSITIONRELATIVETOP7PXGOBACKPAGEIMGIDWIDTH43PXHEIGHT15PXPOSITIONRELATIVETOP7PXGONEXTPAGEIMGIDWIDTH43PXHEIGHT15PXPOSITIONRELATIVETOP7PXGOLASTPAGEIMGIDWIDTH37PXHEIGHT15PXPOSITIONRELATIVETOP7PXGOTARGETPAGEIMGIDWIDTH37PXHEIGHT15PXPOSITIONRELATIVETOP7PXTARGETPAGECOUNTERTAGIDHEIGHT12PXWIDTH20PXBORDER1PXSOLID999999FOURCOLUMN_THIRDROW_THEOUTERWARPERSPANCOLOR03515DPOSITIONRELATIVETOP3PXFOURCOLUMN_THIRDROW_THEOUTERWARPERIMGCURSORPOINTER（2）JAVASCRIPT函数代码QUERYRESULTCOMMONCODEJS/下面的代码为全部选中表格数据和取消全部选中方式的代码/FUNCTIONSELECTALLDATAITEMINTABLESELECTALLDATAITEMCHECKBOXFORVARLOOPINDEX0LOOPINDEX标签后/CURRENTTAGINSTANCECURRENTTAGINSTANCEPARENTELEMENTALLTDCHILDTAGS_INSOMEONEROWCURRENTTAGINSTANCECHILDREN/通过所获得的某个标签的父标签，再获得该父标签下的所有子标签/IFALLTDCHILDTAGS_INSOMEONEROW1STYLEBACKGROUNDCOLORHIGHLIGHTCOLORI企业信息查询结果显示页面FUNCTIONQUERYENTERPRISECUSTOMERINFOBYADDESINFOVARPROVINCES_NAMESELECTOBJDOCUMENTGETELEMENTBYID“PROVINCES_NAME“VARCITY_NAMESELECTOBJDOCUMENTGETELEMENTBYID“CITY_NAME“VARCOUNTY_NAMESELECTOBJDOCUMENTGETELEMENTBYID“COUNTY_NAME“VARPROVINCES_NAMESELECTOBJVALUEPROVINCES_NAMESELECTOBJOPTIONSPROVINCES_NAMESELECTOBJSELECTEDINDEXVALUEVARCITY_NAMESELECTOBJVALUECITY_NAMESELECTOBJOPTIONSCITY_NAMESELECTOBJSELECTEDINDEXVALUEVARCOUNTY_NAMESELECTOBJVALUECOUNTY_NAMESELECTOBJOPTIONSCOUNTY_NAMESELECTOBJSELECTEDINDEXVALUEVARISSELECTSOMEONECITYPROVINCES_NAMESELECTOBJVALUE“省份“IFISSELECTSOMEONECITYWINDOWALERT“没有选择任何的省份或者城市名称信息项目，N请选择具体的省、市、县的名称信息“RETURNCREATELOADSTATUSIMAGECSSFILTERIFPROVINCES_NAMESELECTOBJVALUE“省份“ELSEIFPROVINCES_NAMESELECTOBJVALUE“省份“ELSEIFPROVINCES_NAMESELECTOBJVALUE“省份“WINDOWLOCATIONHREF“PAGECONTEXTREQUESTCONTEXTPATH/ENTERPRISECUSTOMERINFOMANAGESERVLETACTION“REQUESTACTIONTYPECODING11ELSEIFCITY_NAMESELECTOBJVALUE“地级市“ELSEIFCITY_NAMESELECTOBJVALUE“地级市“WINDOWLOCATIONHREF“PAGECONTEXTREQUESTCONTEXTPATH/ENTERPRISECUSTOMERINFOMANAGESERVLETACTION“REQUESTACTIONTYPECODING11ELSEIFCOUNTY_NAMESELECTOBJVALUE“市、县级市、县“WINDOWLOCATIONHREF“PAGECONTEXTREQUESTCONTEXTPATH/ENTERPRISECUSTOMERINFOMANAGESERVLETACTION“REQUESTACTIONTYPECODING11企业客户信息查询结果省份地级市市、县级市、县全选临时删除永久删除取消删除编号名称法人姓名联系人号地址开户行帐号电话网址基本操作ONEENTERPRISECUSTOMERINFOPOENTERPRISECUSTOMER_IDONEENTERPRISECUSTOMERINFOPOCORPORATION_BRIEFNAMEONEENTERPRISECUSTOMERINFOPOMANAGER_NAMEONEENTERPRISECUSTOMERINFOPOCONTACTPERSON_IDONEENTERPRISECUSTOMERINFOPOADDRESS_BRIEFINFOONEENTERPRISECUSTOMERINFOPOBANK_BRIEFNAMEONEENTERPRISECUSTOMERINFOPOBANK_ACCOUNTONEENTERPRISECUSTOMERINFOPOMOBILE_NUMBERONEENTERPRISECUSTOMERINFOPOWEBSITE_URLINFO修改删除共有ONEPAGESTATEPOTOTALNUMBEROFELEMENTS条记录，当前是第ONEPAGESTATEPOCURRENTPAGENUMBER/ONEPAGESTATEPOTOTALPAGENUMBER页按客户编号升序显示按客户编号降序显示按联系人编号升序显示按联系人编号降序显示按银行帐号升序显示按银行帐号降序显示按电话号码升序显示按电话号码降序显示按客户编号升序显示按客户编号降序显示按联系人编号升序显示按联系人编号降序显示按银行帐号升序显示按银行帐号降序显示按电话号码升序显示按电话号码降序显示按客户编号升序显示按客户编号降序显示按联系人编号升序显示按联系人编号降序显示按银行帐号升序显示按银行帐号降序显示按电话号码升序显示按电话号码降序显示按客户编号升序显示按客户编号降序显示按联系人编号升序显示按联系人编号降序显示按银行帐号升序显示按银行帐号降序显示按电话号码升序显示按电话号码降序显示按客户编号升序显示按客户编号降序显示按联系人编号升序显示按联系人编号降序显示按银行帐号升序显示按银行帐号降序显示按电话号码升序显示按电话号码降序显示按客户编号升序显示按客户编号降序显示按联系人编号升序显示按联系人编号降序显示按银行帐号升序显示按银行帐号降序显示按电话号码升序显示按电话号码降序显示按客户编号升序显示按客户编号降序显示按联系人编号升序显示按联系人编号降序显示按银行帐号升序显示按银行帐号降序显示按电话号码升序显示按电话号码降序显示按客户编号升序显示按客户编号降序显示按联系人编号升序显示按联系人编号降序显示按银行帐号升序显示按银行帐号降序显示按电话号码升序显示按电话号码降序显示按客户编号升序显示按客户编号降序显示按联系人编号升序显示按联系人编号降序显示按银行帐号升序显示按银行帐号降序显示按电话号码升序显示按电话号码降序显示每页2条数据每页5条数据每页10条数据每页15条数据每页20条数据每页2条数据每页5条数据每页10条数据每页15条数据每页20条数据每页2条数据每页5条数据每页10条数据每页15条数据每页20条数据每页2条数据每页5条数据每页10条数据每页15条数据每页20条数据每页2条数据每页5条数据每页10条数据每页15条数据每页20条数据每页2条数据每页5条数据每页10条数据每页15条数据每页20条数据转到第页FUNCTIONREQUERYDATABYSOMEONEORDERMETHODSOMEONEORDERMETHODSELECTOBJSOMEONEORDERMETHODSELECTVALUESOMEONEORDERMETHODSELECTOBJOPTIONSSOMEONEORDERMETHODSELECTOBJSELECTEDINDEXVALUECREATELOADSTATUSIMAGECSSFILTERWINDOWLOCATIONHREF“PAGECONTEXTREQUESTCONTEXTPATH/ENTERPRISECUSTOMERINFOMANAGESERVLETACTION“REQUESTACTIONTYPECODING16FUNCTIONCHANGEDATAITEMSPERPAGEDATAITEMSPERPAGESELECTOBJVARNEWDATAITEMSPERPAGEVALUEDATAITEMSPERPAGESELECTOBJOPTIONSDATAITEMSPERPAGESELECTOBJSELECTEDINDEXVALUECREATELOADSTATUSIMAGECSSFILTERWINDOWLOCATIONHREF“PAGECONTEXTREQUESTCONTEXTPATH/ENTERPRISECUSTOMERINFOMANAGESERVLETACTION“REQUESTACTIONTYPECODING15FUNCTIONFASTGOTOUPDATESOMEONEENTERPRISECUSTOMERINFOTARGETPAGEUPDATEDENTERPRISECUSTOMERIDWINDOWLOCATIONHREF“PAGECONTEXTREQUESTCONTEXTPATH/ENTERPRISECUSTOMERINFOMANAGEACTIONQUERYUPDATESOMEONEENTERPRISECUSTOMERINFOACTION“ENTERPRISECUSTOMER_ID“UPDATEDENTERPRISECUSTOMERID“FUNCTIONFASTGOTODELETESOMEONEENTERPRISECUSTOMERINFOTARGETPAGEDELETEDENTERPRISECUSTOMERIDVARDELETEQUERYSTRINGDELETEQUERYSTRING“PAGECONTEXTREQUESTCONTEXTPATH/ENTERPRISECUSTOMERINFOMANAGEACTIONDELETESOMEONEENTERPRISECUSTOMERINFOACTION“ENTERPRISECUSTOMER_ID“DELETEDENTERPRISECUSTOMERID“/下面的函授是在QUERYRESULTCOMMONCODEJS文件中定义的/CONFIRMDELETESOMEONEENTERPRISECUSTOMERDATAITEMDELETEQUERYSTRINGFUNCTIONFASTGOTOFIRSTTARGETPAGECREATELOADSTATUSIMAGECSSFILTERWINDOWLOCATIONHREF“PAGECONTEXTREQUESTCONTEXTPATH/ENTERPRISECUSTOMERINFOMANAGEACTIONQUERYTARGETPAGEENTERPRISECUSTOMERINFOACTION“TARGETPAGECOUNTER1“FUNCTIONFASTGOTOBACKTARGETPAGECREATELOADSTATUSIMAGECSSFILTERWINDOWLOCATIONHREF“PAGECONTEXTREQUESTCONTEXTPATH/ENTERPRISECUSTOMERINFOMANAGEACTIONQUERYTARGETPAGEENTERPRISECUSTOMERINFOACTION“TARGETPAGECOUNTERONEPAGESTATEPOPREVIOUSPAGENUMBER“FUNCTIONFASTGOTONEXTTARGETPAGECREATELOADSTATUSIMAGECSSFILTERWINDOWLOCATIONHREF“PAGECONTEXTREQUESTCONTEXTPATH/ENTERPRISECUSTOMERINFOMANAGEACTIONQUERYTARGETPAGEENTERPRISECUSTOMERINFOACTION“TARGETPAGECOUNTERONEPAGESTATEPONEXTPAGENUMBER“FUNCTIONFASTGOTOLASTTARGETPAGECREATELOADSTATUSIMAGECSSFILTERWINDOWLOCATIONHREF“PAGECONTEXTREQUESTCONTEXTPATH/ENTERPRISECUSTOMERINFOMANAGEACTIONQUERYTARGETPAGEENTERPRISECUSTOMERINFOACTION“TARGETPAGECOUNTERONEPAGESTATEPOLASTPAGENUMBER“FUNCTIONCHECKTARGETPAGECOUNTERISDIGITSTARGETPAGECOUNTERINPUTFIELDOBJECT,USERINPUTTARGETPAGECOUNTERIFUSERINPUTTARGETPAGECOUNTERNULL|USERINPUTTARGETPAGECOUNTERLENGTH0RETURNTRUE/如果待检查的字符串为空字符串，则不进行检查/检查所输入的目标页码值是否为数字IFISDIGITSININPUTEDSTRINGUSERINPUTTARGETPAGECOUNTERWINDOWALERT“要转向的目标页码值应该为数字“TARGETPAGECOUNTERINPUTFIELDOBJECTVALUE“TARGETPAGECOUNTERINPUTFIELDOBJECTFOCUSRETURNFALSERETURNTRUEFUNCTIONFASTGOTOTARGETPAGEVARTARGETPAGECOUNTERVARTOTALPAGENUMBERTOTALPAGENUMBERONEPAGESTATEPOTOTALPAGENUMBERTARGETPAGECOUNTERDOCUMENTGETELEMENTBYID“TARGETPAGECOUNTERTAGID“VALUEIFTARGETPAGECOUNTERNULL|TARGETPAGECOUNTER“|TARGETPAGECOUNTERLENGTH0ALERT“请输入要转向的具体目标页码值“RETURNFALSEIFTARGETPAGECOUNTER0ALERT“要转向的目标页码值不应该为0“DOCUMENTGETELEMENTBYID“TARGETPAGECOUNTERTAGID“VALUE“RETURNFALSEIFTARGETPAGECOUNTERTOTALPAGENUMBERALERT“要转向的目标页码值应该小于最大页数“TOTALPAGENUMBER“DOCUMENTGETELEMENTBYID“TARGETPAGECOUNTERTAGID“VALUE“RETURNFALSECREATELOADSTATUSIMAGECSSFILTERWINDOWLOCATIONHREF“PAGECONTEXTREQUESTCONTEXTPATH/ENTERPRISECUSTOMERINFOMANAGEACTIONQUERYTARGETPAGEENTERPRISECUSTOMERINFOACTION“TARGETPAGECOUNTER“TARGETPAGECOUNTER“FUNCTIONDYNAMATICSELECT/定义DYNAMATICSELECT对象中的ITEMS成员属性，该成员属性存放省、市县名THISITEMSDYNAMATICSELECTPROTOTYPEADDFUNCTIONID,IARRAYTHISITEMSIDIARRAYDYNAMATICSELECTPROTOTYPEEXISTSFUNCTIONIDIFTYPEOFTHISITEMSID“UNDEFINED“RETURNFALSERETURNTRUEFUNCTIONINITANDCHANGESELECTVVARSOMEONESTRING“0“FORI0I0|VIFONEDYNAMATICSELECTOBJEXISTSSOMEONESTRINGARONEDYNAMATICSELECTOBJ