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

基于S2SH架构的课程设计实训教学示例项目客户关系管理CRM系统分页查询显示个人客户信息111分页查询显示个人客户信息1、与个人信息查询结果显示页面相关的资源文件（1）CSS样式文件RIGHTQUERYPERSONALCUSTOMERRESULTCSSCHARSET“GB18030“IMPORTURL“/INDEXCOMMONSTYLECSS“THEOUTERWARPERWIDTH100FIRSTROW_THEOUTERWARPERHEIGHT30PXWIDTH100MARGINBOTTOM0PXMARGINTOP0PXFIRSTCOLUMN_FIRSTROW_THEOUTERWARPERFLOATLEFTWIDTH12PXHEIGHT30PXMARGINLEFT0PXFIRSTCOLUMN_FIRSTROW_THEOUTERWARPERIMGWIDTH12PXHEIGHT30PXMARGINLEFT0PXSECONDCOLUMN_FIRSTROW_THEOUTERWARPERFLOATLEFTPOSITIONRELATIVETOP5PXSECONDCOLUMN_FIRSTROW_THEOUTERWARPERIMGPOSITIONRELATIVETOP3PXSECONDCOLUMN_FIRSTROW_THEOUTERWARPERSPANFONTWEIGHTBOLDTHIRDCOLUMN_FIRSTROW_THEOUTERWARPERFLOATRIGHTWIDTH16PXHEIGHT30PXFOURCOLUMN_FIRSTROW_THEOUTERWARPERFLOATRIGHTHEIGHT30PXPADDINGTOP5PXFOURCOLUMN_FIRSTROW_THEOUTERWARPERIMGWIDTH14PXHEIGHT14PXMARGINLEFT5PXSELECTINPUTSTYLEBORDERTOPSTYLENONEBORDERRIGHTSTYLENONEBORDERBOTTOMSTYLENONEBORDERLEFTSTYLENONEFONTSIZE12PXFONTFAMILY“宋体“MARGINRIGHT10PXDATATABLETAGIDWIDTH100BORDERTOPWIDTH0PXBORDERRIGHTWIDTH0PXBORDERBOTTOMWIDTH0PXBORDERLEFTWIDTH0PXBORDERTOPSTYLENONEBORDERRIGHTSTYLENONEBORDERBOTTOMSTYLENONEBORDERLEFTSTYLENONEFIRSTROWFIRSTCOLUMNTDTAGIDWIDTH8PXSECONDCOLUMNDATATABLETAGIDWIDTH100BORDER0PXNONEFFFFFFDATATHEADCELLCSSCLASSSTYLEHEIGHT22PXTEXTALIGNCENTERFIRSTCOLUMNTDTAGIDWIDTH5PXSECONDCOLUMNTDTAGIDWIDTH50PXTHIRDCOLUMNTDTAGIDWIDTH50PXFOURCOLUMNTDTAGIDWIDTH45PXFIFTHCOLUMNTDTAGIDWIDTH40PXSIXTHCOLUMNTDTAGIDWIDTH60PXSERVENCOLUMNTDTAGIDWIDTH60PXEIGHTTHCOLUMNTDTAGIDWIDTH120PXNINETHCOLUMNTDTAGIDWIDTH100PXTENTHCOLUMNTDTAGIDWIDTH90PXELEVENTHCOLUMNTDTAGIDWIDTHAUTODATACELLCSSCLASSSTYLEHEIGHT20PXTEXTALIGNCENTERFIRSTROWTHIRDCOLUMNTDTAGIDWIDTH8PXTHIRDROW_THEOUTERWARPERHEIGHT35PXWIDTH100MARGINBOTTOM0PXMARGINTOP0PXFIRSTCOLUMN_THIRDROW_THEOUTERWARPERFLOATLEFTWIDTH12PXHEIGHT35PXMARGINLEFT0PXFIRSTCOLUMN_THIRDROW_THEOUTERWARPERIMGWIDTH12PXHEIGHT35PXMARGINLEFT0PXSECONDCOLUMN_THIRDROW_THEOUTERWARPERFLOATLEFTSECONDCOLUMN_THIRDROW_THEOUTERWARPERSPANCOLOR03515DPOSITIONRELATIVETOP10PXTHIRDCOLUMN_THIRDROW_THEOUTERWARPERFLOATRIGHTWIDTH16PXHEIGHT35PXFOURCOLUMN_THIRDROW_THEOUTERWARPERFLOATRIGHTDATAITEMSPERPAGESELECTIDPOSITIONRELATIVETOP7PXSOMEONEORDERMETHODSELECTIDPOSITIONRELATIVETOP7PXGOFIRSTPAGEIMGIDWIDTH37PXHEIGHT15PXPOSITIONRELATIVETOP7PXGOBACKPAGEIMGIDWIDTH43PXHEIGHT15PXPOSITIONRELATIVETOP7PXGONEXTPAGEIMGIDWIDTH43PXHEIGHT15PXPOSITIONRELATIVETOP7PXGOLASTPAGEIMGIDWIDTH37PXHEIGHT15PXPOSITIONRELATIVETOP7PXGOTARGETPAGEIMGIDWIDTH37PXHEIGHT15PXPOSITIONRELATIVETOP7PXTARGETPAGECOUNTERTAGIDHEIGHT12PXWIDTH20PXBORDER1PXSOLID999999FOURCOLUMN_THIRDROW_THEOUTERWARPERSPANCOLOR03515DPOSITIONRELATIVETOP3PXFOURCOLUMN_THIRDROW_THEOUTERWARPERIMGCURSORPOINTER（2）JAVASCRIPT函数代码QUERYRESULTCOMMONCODEJS2、显示查询结果的相关页面PERSONALCUSTOMERQUERYRESULTJSP个人信息查询结果显示页面个人客户信息的查询结果按企业规模快速查询大型企业中型企业小型企业个体企业按行业分类快速查询IT行业化工业航空业电子业全选临时删除永久删除取消删除编号姓名性别年龄行业类型企业规模企业名称电子邮箱联系电话基本操作ONEPERSONALCUSTOMERINFOPOCUSTOMER_IDONEPERSONALCUSTOMERINFOPOCUSTOMER_NAME男女男ONEPERSONALCUSTOMERINFOPOCUSTOMER_AGEONEPERSONALCUSTOMERINFOPOCUSTOMER_OCCUPATIONONEPERSONALCUSTOMERINFOPOCUSTOMER_UNITSIZEONEPERSONALCUSTOMERINFOPOCUSTOMER_BRIEFUNITNAMEONEPERSONALCUSTOMERINFOPOCUSTOMER_EMAILONEPERSONALCUSTOMERINFOPOCUSTOMER_MOBILENUMBER修改删除共有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条数据转到第页FUNCTIONCHANGEDATAITEMSPERPAGEDATAITEMSPERPAGESELECTOBJVARNEWDATAITEMSPERPAGEVALUEDATAITEMSPERPAGESELECTOBJOPTIONSDATAITEMSPERPAGESELECTOBJSELECTEDINDEXVALUECREATELOADSTATUSIMAGECSSFILTERWINDOWLOCATIONHREF“PAGECONTEXTREQUESTCONTEXTPATH/CUSTOMERINFOMANAGESERVLETACTION“REQUESTACTIONTYPECODING16FUNCTIONFASTGOTOUPDATESOMEONECUSTOMERINFOTARGETPAGEUPDATEDCUSTOMERIDWINDOWLOCATIONHREF“PAGECONTEXTREQUESTCONTEXTPATH/PERSONALCUSTOMERINFOMANAGEACTIONQUERYUPDATESOMEONEPERSONALCUSTOMERINFOACTION“CUSTOMER_ID“UPDATEDCUSTOMERID“FUNCTIONFASTGOTODELETESOMEONECUSTOMERINFOTARGETPAGEDELETEDCUSTOMERIDVARDELETEQUERYSTRINGDELETEQUERYSTRING“PAGECONTEXTREQUESTCONTEXTPATH/PAGECONTEXTREQUESTCONTEXTPATH/PERSONALCUSTOMERINFOMANAGEACTIONDELETESOMEONEPERSONALCUSTOMERINFOACTION“CUSTOMER_ID“DELETEDCUSTOMERID“/下面的函授是在QUERYRESULTCOMMONCODEJS文件中定义的/CONFIRMDELETESOMEONECUSTOMERDATAITEMDELETEQUERYSTRINGFUNCTIONFASTGOTOFIRSTTARGETPAGECREATELOADSTATUSIMAGECSSFILTERWINDOWLOCATIONHREF“PAGECONTEXTREQUESTCONTEXTPATH/PERSONALCUSTOMERINFOMANAGEACTIONQUERYTARGETPAGEPERSONALCUSTOMERINFOACTION“TARGETPAGECOUNTER1“FUNCTIONFASTGOTOBACKTARGETPAGECREATELOADSTATUSIMAGECSSFILTERWINDOWLOCATIONHREF“PAGECONTEXTREQUESTCONTEXTPATH/PERSONALCUSTOMERINFOMANAGEACTIONQUERYTARGETPAGEPERSONALCUSTOMERINFOACTION“TARGETPAGECOUNTERONEPAGESTATEPOPREVIOUSPAGENUMBER“FUNCTIONFASTGOTONEXTTARGETPAGECREATELOADSTATUSIMAGECSSFILTERWINDOWLOCATIONHREF“PAGECONTEXTREQUESTCONTEXTPATH/PERSONALCUSTOMERINFOMANAGEACTIONQUERYTARGETPAGEPERSONALCUSTOMERINFOACTION“TARGETPAGECOUNTERONEPAGESTATEPONEXTPAGENUMBER“FUNCTIONFASTGOTOLASTTARGETPAGECREATELOADSTATUSIMAGECSSFILTERWINDOWLOCATIONHREF“PAGECONTEXTREQUESTCONTEXTPATH/PERSONALCUSTOMERINFOMANAGEACTIONQUERYTARGETPAGEPERSONALCUSTOMERINFOACTION“TARGETPAGECOUNTERONEPAGESTATEPOLASTPAGENUMBER“FUNCTIONCHECKTARGETPAGECOUNTERISDIGITSTARGETPAGECOUNTERINPUTFIELDOBJECT,USERINPUTTARGETPAGECOUNTERIFUSERINPUTTARGETPAGECOUNTERNULL|USERINPUTTARGETPAGECOUNTERLENGTH0RETURNTRUE/如果待检查的字符串为空字符串，则不进行检查/检查所输入的目标页码值是否为数字IFISDIGITSININPUTEDSTRINGUSERINPUTTARGETPAGECOUNTERWINDOWALERT“要转向的目标页码值应该为数字“TARGETPAGECOUNTERINPUTFIELDOBJECTVALUE“TARGETPAGECOUNTERINPUTFIELDOBJECTFOCUSRETURNFALSERETURNTRUEFUNCTIONFASTGOTOTARGETPAGEVARTARGETPAGECOUNTERVARTOTALPAGENUMBERTOTALPAGENUMBERONEPAGESTATEPOTOTALPAGENUMBERTARGETPAGECOUNTERDOCUMENTGETELEMENTBYID“TARGETPAGECOUNTERTAGID“VALUEIFTARGETPAGECOUNTERNULL|TARGETPAGECOUNTER“|TARGETPAGECOUNTERLENGTH0ALERT“请输入要转向的具体目标页码值“RETURNFALSEIFTARGETPAGECOUNTER0ALERT“要转向的目标页码值不应该为0“DOCUMENTGETELEMENTBYID“TARGETPAGECOUNTERTAGID“VALUE“RETURNFALSEIFTARGETPAGECOUNTERTOTALPAGENUMBERALERT“要转向的目标页码值应该小于最大页数“TOTALPAGENUMBER“DOCUMENTGETELEMENTBYID“TARGETPAGECOUNTERTAGID“VALUE“RETURNFALSECREATELOADSTATUSIMAGECSSFILTERWINDOWLOCATIONHREF“PAGECONTEXTREQUESTCONTEXTPATH/PERSONALCUSTOMERINFOMANAGEACTIONQUERYTARGETPAGEPERSONALCUSTOMERINFOACTION“TARGETPAGECOUNTER“TARGETPAGECOUNTER“FUNCTIONREQUERYDATABYSOMEONEORDERMETHODSOMEONEORDERMETHODSELECTOBJSOMEONEORDERMETHODSELECTVALUESOMEONEORDERMETHODSELECTOBJOPTIONSSOMEONEORDERMETHODSELECTOBJSELECTEDINDEXVALUECREATELOADSTATUSIMAGECSSFILTERWINDOWLOCATIONHREF“PAGECONTEXTREQUESTCONTEXTPATH/CUSTOMERINFOMANAGESERVLETACTION“REQUESTACTIONTYPECODING17FUNCTIONCHECKANDSUBMITBYCUSTOMERUNITSIZECUSTOMERUNITSIZESELECTOBJSELECTEDCUSTOMERUNITSIZEVALUECUSTOMERUNITSIZESELECTOBJOPTIONSCUSTOMERUNITSIZESELECTOBJSELECTEDINDEXVALUEIFSELECTEDCUSTOMERUNITSIZEVALUE“0“RETURNCREATELOADSTATUSIMAGECSSFILTERWINDOWLOCATIONHREF“PAGECONTEXTREQUESTCONTEXTPATH/CUSTOMERINFOMANAGESERVLETACTION“REQUESTACTIONTYPECODING12FUNCTIONCHECKANDSUBMITBYCUSTOMEROCCUPATIONCUSTOMEROCCUPATIONSELECTSELECTEDCUSTOMEROCCUPATIONVALUECUSTOMEROCCUPATIONSELECTOPTIONSCUSTOMEROCCUPATIONSELECTSELECTEDINDEXVALUEIFSELECTEDCUSTOMEROCCUPATIONVALUE“0“RETURNCREATELOADSTATUSIMAGECSSFILTERWINDOWLOCATIONHREF“PAGECONTEXTREQUESTCONTEXTPATH/CUSTOMERINFOMANAGESERVLETACTION“REQUESTACTIONTYPECODING113、在PERSONALCUSTOMERINFOACTIONFORM类中添加与分页目标页码相关的成员属性和GET/SET方法PRIVATEINTTARGETPAGECOUNTERPUBLICINTGETTARGETPAGECOUNTERRETURNTARGETPAGECOUNTERPUBLICVOID