基于s2sh架构的课程设计实训教学示例项目——《客户关系管理crm系统》——完成添加企业客户信息的后台逻辑处理功能

基于S2SH架构的课程设计实训教学示例项目客户关系管理CRM系统完成添加企业客户信息的后台逻辑处理功能111完成添加企业客户信息的后台逻辑处理1、添加包装与企业信息管理相关的表单数据的ACTIONFORM组件（1）类名称为ENTERPRISECUSTOMERINFOACTIONFORM，包名称为COMPX1987BLUEDREAMCRMACTIONFORM（2）添加如下的成员属性/下面的数据为包装添加企业信息表单的各个成员变量/PRIVATESTRINGENTERPRISECUSTOMER_ID/主键编号IDPRIVATESTRINGCORPORATION_NAMENULL/企业名称PRIVATESTRINGMANAGER_NAMENULL/法人代表姓名PRIVATESTRINGCONTACTPERSON_ID/联系人编号PRIVATESTRINGBANKNAME_SELECTTAGIDNULL/开户银行的选择框的选择值PRIVATESTRINGBANK_NAMENULL/开户银行PRIVATESTRINGBANK_ACCOUNTNULL/银行帐号PRIVATESTRINGMOBILE_NUMBERNULL/联系电话PRIVATESTRINGPOSTCODE_INFONULL/邮政编码PRIVATESTRINGWEBSITE_URLINFONULL/企业网址PRIVATESTRINGADDRESS_INFONULL/法定地址PRIVATESTRINGSUPERVISOR_NAMENULL/上级主管部门PRIVATESTRINGPROVINCES_NAMENULL/企业所在的省名PRIVATESTRINGCITY_NAMENULL/企业所在的省中的一级城市名PRIVATESTRINGCOUNTY_NAMENULL/企业所在的二级市及县名/下面的数据为包装查询企业信息表单的各个成员变量/PRIVATEBYTEQUERYMETHODRADIOBUTTONID/查询表单中的查询方式PRIVATEINTENTERPRISECUSTOMER_IDOPERATOR/客户编号的操作符PRIVATEINTCORPORATION_NAMEOPERATOR/企业名称的操作符PRIVATEINTMANAGER_NAMEOPERATOR/法人姓名的的操作符PRIVATEINTBANK_NAMEOPERATOR/商业银行名称的操作符PRIVATEINTBANK_ACCOUNTOPERATOR/银行帐号的操作符PRIVATESTRINGCORPORATION_NAMEADVANCE/高级查询表单中的企业名称PRIVATEINTCORPORATION_NAMEADVANCEOPERATOR/高级查询表单中的企业名称的操作符PRIVATESTRINGMANAGER_NAMEADVANCE/高级查询表单中的法人姓名PRIVATEINTMANAGER_NAMEADVANCEOPERATOR/高级查询表单中的法人姓名的的操作符PRIVATESTRINGBANK_NAMEADVANCE/高级查询表单中的商业银行名称PRIVATEINTBANK_NAMEADVANCEOPERATOR/高级查询表单中的商业银行名称的操作符PRIVATESTRINGBANK_ACCOUNTADVANCE/高级查询表单中的银行帐号PRIVATEINTBANK_ACCOUNTADVANCEOPERATOR/高级查询表单中的银行帐号的操作符PRIVATEINTMOBILE_NUMBEROPERATOR/高级查询表单中的手机号的操作符PRIVATEINTPOSTCODE_INFOOPERATOR/高级查询表单中的邮政编码的操作符PRIVATEINTCONTACTPERSON_IDOPERATOR/高级查询表单中的联系人编号的操作符PRIVATEINTSUPERVISOR_NAMEOPERATOR/高级查询表单中的上级主管的操作符/下面的数据为包装分页查询企业信息超链接的各个查询参数字符串/PRIVATEBYTETARGETPAGECOUNTER/分页查询中的目标页数PRIVATESTRINGSQLQUERYWHERESTRING/分页查询中的上次的查询SQL条件（3）为各个成员属性变量提供GET/SET方法2、添加对企业信息管理进行后台处理的ACTION组件（1）类名称为ENTERPRISECUSTOMERINFOMANAGEACTION，包名称为COMPX1987BLUEDREAMCRMACTION，继承于COMOPENSYMPHONYXWORK2ACTIONSUPPORT类，实现COMOPENSYMPHONYXWORK2MODELDRIVEN接口注意本项目采用实现MODELDRIVEN接口的方式编程实现ACTION类。（2）编程该ACTION类PACKAGECOMPX1987BLUEDREAMCRMACTIONIMPORTJAVAIOUNSUPPORTEDENCODINGEXCEPTIONIMPORTJAVAUTILLISTIMPORTJAVAXSERVLETHTTPHTTPSERVLETREQUESTIMPORTORGAPACHESTRUTS2SERVLETACTIONCONTEXTIMPORTCOMOPENSYMPHONYXWORK2ACTIONSUPPORTIMPORTCOMOPENSYMPHONYXWORK2MODELDRIVENIMPORTCOMPX1987BLUEDREAMCRMACTIONFORMENTERPRISECUSTOMERINFOACTIONFORMIMPORTCOMPX1987BLUEDREAMCRMDAOIMPLEENTERPRISECUSTOMERINFOCRUDIMPLEIMPORTCOMPX1987BLUEDREAMCRMDAOINTERENTERPRISECUSTOMERINFOCRUDINTERFACEIMPORTCOMPX1987BLUEDREAMCRMDAOPOENTERPRISECUSTOMERINFOPOIMPORTCOMPX1987BLUEDREAMCRMDAOPOPAGESTATEPOIMPORTCOMPX1987BLUEDREAMCRMUTILALLCONSTANTITEMSIMPORTCOMPX1987BLUEDREAMCRMUTILSYSTEMUTILPUBLICCLASSENTERPRISECUSTOMERINFOMANAGEACTIONEXTENDSACTIONSUPPORTIMPLEMENTSMODELDRIVEN/本类的唯一ID/PRIVATESTATICFINALLONGSERIALVERSIONUID1LPRIVATEENTERPRISECUSTOMERINFOACTIONFORMENTERPRISECUSTOMERINFOACTIONFORMNEWENTERPRISECUSTOMERINFOACTIONFORMPUBLICENTERPRISECUSTOMERINFOMANAGEACTIONOVERRIDEPUBLICENTERPRISECUSTOMERINFOACTIONFORMGETMODELRETURNENTERPRISECUSTOMERINFOACTIONFORM/下面的方法是响应添加企业客户信息的表单请求/PUBLICSTRINGADDENTERPRISECUSTOMERINFO/构建出包装企业信息数据库表的PO对象/ENTERPRISECUSTOMERINFOPOONEENTERPRISECUSTOMERINFOPONEWENTERPRISECUSTOMERINFOPO/将缓存在表单对象中的各个成员属性值转存到PO对象中/ONEENTERPRISECUSTOMERINFOPOSETCORPORATION_NAMEENTERPRISECUSTOMERINFOACTIONFORMGETCORPORATION_NAMEONEENTERPRISECUSTOMERINFOPOSETMANAGER_NAMEENTERPRISECUSTOMERINFOACTIONFORMGETMANAGER_NAMEONEENTERPRISECUSTOMERINFOPOSETADDRESS_INFOENTERPRISECUSTOMERINFOACTIONFORMGETADDRESS_INFOONEENTERPRISECUSTOMERINFOPOSETBANK_NAMEENTERPRISECUSTOMERINFOACTIONFORMGETBANK_NAMEONEENTERPRISECUSTOMERINFOPOSETBANK_ACCOUNTENTERPRISECUSTOMERINFOACTIONFORMGETBANK_ACCOUNTONEENTERPRISECUSTOMERINFOPOSETMOBILE_NUMBERENTERPRISECUSTOMERINFOACTIONFORMGETMOBILE_NUMBERONEENTERPRISECUSTOMERINFOPOSETPOSTCODE_INFOENTERPRISECUSTOMERINFOACTIONFORMGETPOSTCODE_INFOONEENTERPRISECUSTOMERINFOPOSETWEBSITE_URLINFOENTERPRISECUSTOMERINFOACTIONFORMGETWEBSITE_URLINFO/下面的代码识别表单中所提交的联系人编号是否为空，如果为空，则不将字符串转换为数字；只有在字符串为有效的数据时，再进行转换。/IFENTERPRISECUSTOMERINFOACTIONFORMGETCONTACTPERSON_IDNULL|“EQUALSENTERPRISECUSTOMERINFOACTIONFORMGETCONTACTPERSON_IDONEENTERPRISECUSTOMERINFOPOSETCONTACTPERSON_ID0ELSEONEENTERPRISECUSTOMERINFOPOSETCONTACTPERSON_IDINTEGERPARSEINTENTERPRISECUSTOMERINFOACTIONFORMGETCONTACTPERSON_IDONEENTERPRISECUSTOMERINFOPOSETPROVINCES_NAMEENTERPRISECUSTOMERINFOACTIONFORMGETPROVINCES_NAMEONEENTERPRISECUSTOMERINFOPOSETCITY_NAMEENTERPRISECUSTOMERINFOACTIONFORMGETCITY_NAMEONEENTERPRISECUSTOMERINFOPOSETCOUNTY_NAMEENTERPRISECUSTOMERINFOACTIONFORMGETCOUNTY_NAMEONEENTERPRISECUSTOMERINFOPOSETSUPERVISOR_NAMEENTERPRISECUSTOMERINFOACTIONFORMGETSUPERVISOR_NAME/调用通过SPRINGIOC获得的DAO对象实现对企业客户信息进行保存操作，最终达到将PO对象中的数据保存到相关的数据库表中/BOOLEANINSERTRESULTSTATEENTERPRISECUSTOMERINFOCRUDIMPLEINSERTONEENTERPRISECUSTOMERINFOONEENTERPRISECUSTOMERINFOPO/识别数据保存是否成功，如果出现错误，则跳转到错误显示页面中进行错误信息的显示/IFINSERTRESULTSTATEHTTPSERVLETREQUESTREQUESTSERVLETACTIONCONTEXTGETREQUESTREQUESTSETATTRIBUTE“ERRORTEXT“,“在添加企业客户信息时，系统出现了错误，请重新添加该企业客户的信息“RETURN“GOTOSHOWERRORINFO“/如果数据保存成功，则跳转到成功信息显示页面中进行状态信息的显示/RETURN“ADDENTERPRISECUSTOMERINFOSUCCESS“/下面的方法是响应查询企业客户信息的表单请求/PUBLICSTRINGQUERYENTERPRISECUSTOMERINFO/获得当前的查询方式，并根据当前的查询方式分别动态地构建出对应的HQL语句中的WHERE条件部分的子字符串/INTQUERYMETHODRADIOBUTTONIDENTERPRISECUSTOMERINFOACTIONFORMGETQUERYMETHODRADIOBUTTONIDSTRINGTARGETHQLWHERESTRINGNULLSWITCHQUERYMETHODRADIOBUTTONIDCASE1/查询所有企业客户，此时的条件为空不需要WHERE部分/TARGETHQLWHERESTRING“BREAKCASE2/按照ID查询企业客户信息，此时构建出如下的条件部分字符串/TARGETHQLWHERESTRINGGETWHERESTRINGBYCUSTOMERINFOIDQUERYMETHODBREAKCASE3/综合查询企业客户信息/TARGETHQLWHERESTRINGGETWHERESTRINGINCOMPLEXQUERYMETHODBREAKCASE4/高级查询企业客户信息/TARGETHQLWHERESTRINGGETWHERESTRINGINADVANCEQUERYMETHODBREAK/构建出分页数据查询状态数据的PO对象，由于目前是第一次访问，因此获得第一页的数据/PAGESTATEPOONEPAGESTATEPONEWPAGESTATEPOONEPAGESTATEPOSETCURRENTPAGENUMBER1ONEPAGESTATEPOSETONEPAGESIZEALLCONSTANTITEMSONEPAGESIZE_INDATAQUERY/调用通过SPRINGIOC获得的DAO对象实现对企业客户信息进行查询满足条件的数据/LISTRETURNALLENTERPRISECUSTOMERINFOPOENTERPRISECUSTOMERINFOCRUDIMPLESELECTSOMEENTERPRISECUSTOMERINFOTARGETHQLWHERESTRING,ONEPAGESTATEPO/将查询的结果保存到REQUESTSCOPE作用域中，实现在页面中显示输出数据/HTTPSERVLETREQUESTREQUESTSERVLETACTIONCONTEXTGETREQUESTREQUESTSETATTRIBUTE“ALLENTERPRISECUSTOMERINFOPOINLIST“,RETURNALLENTERPRISECUSTOMERINFOPO/将分页状态对象保存到REQUESTSCOPE作用域中，在页面中显示分页状态有关的各个数据/REQUESTSETATTRIBUTE“ONEPAGESTATEPO“,ONEPAGESTATEPOREQUESTSETATTRIBUTE“SQLQUERYWHERESTRING“,SYSTEMUTILREMOVESOMEONECHARINSTRINGTARGETHQLWHERESTRING,/跳转到查询结果的显示目标页面中显示输出所查询的结果信息/RETURN“QUERYENTERPRISECUSTOMERINFOSUCCESS“/下面的方法是响应分页查询中的显示目标页的企业客户信息的超链接的请求/PUBLICSTRINGQUERYTARGETPAGEENTERPRISECUSTOMERINFO/获得在查询参数字符串中所提交的目标页码/BYTETARGETPAGECOUNTERENTERPRISECUSTOMERINFOACTIONFORMGETTARGETPAGECOUNTER/获得在查询参数字符串中所提交的HQL语句中的WHERE条件子字符串/STRINGTARGETHQLWHERESTRINGENTERPRISECUSTOMERINFOACTIONFORMGETSQLQUERYWHERESTRINGIFTARGETHQLWHERESTRINGNULL/下面的代码实现对通过GET提交的SQL语句中的中文字符串进行编码转换以获得正确的中文字符串/TRYTARGETHQLWHERESTRINGNEWSTRINGTARGETHQLWHERESTRINGGETBYTES“ISO88591“,“GBK“CATCHUNSUPPORTEDENCODINGEXCEPTIONEEPRINTSTACKTRACE/将目标页码缓存在分页状态的PO对象中/PAGESTATEPOONEPAGESTATEPONULLONEPAGESTATEPONEWPAGESTATEPOONEPAGESTATEPOSETCURRENTPAGENUMBERTARGETPAGECOUNTER/获得指定页数据ONEPAGESTATEPOSETONEPAGESIZEALLCONSTANTITEMSONEPAGESIZE_INDATAQUERY/调用通过SPRINGIOC获得的DAO对象实现对企业客户信息进行查询满足条件的数据/LISTRETURNALLENTERPRISECUSTOMERINFOPOENTERPRISECUSTOMERINFOCRUDIMPLESELECTSOMEENTERPRISECUSTOMERINFOTARGETHQLWHERESTRING,ONEPAGESTATEPO/将查询的结果保存到REQUESTSCOPE作用域中，实现在页面中显示输出数据/HTTPSERVLETREQUESTREQUESTSERVLETACTIONCONTEXTGETREQUESTREQUESTSETATTRIBUTE“ALLENTERPRISECUSTOMERINFOPOINLIST“,RETURNALLENTERPRISECUSTOMERINFOPO/将分页状态对象保存到REQUESTSCOPE作用域中，在页面中显示分页状态有关的各个数据/REQUESTSETATTRIBUTE“ONEPAGESTATEPO“,ONEPAGESTATEPOREQUESTSETATTRIBUTE“SQLQUERYWHERESTRING“,SYSTEMUTILREMOVESOMEONECHARINSTRINGTARGETHQLWHERESTRING,/跳转到查询结果的显示目标页面中显示输出所查询的结果信息/RETURN“QUERYENTERPRISECUSTOMERINFOSUCCESS“/下面的方法是响应查询结果中的修改某个企业客户信息的超链接的请求/PUBLICSTRINGQUERYUPDATESOMEONEENTERPRISECUSTOMERINFO/获得在查询参数字符串中所提交的待修改的企业客户信息的编号/STRINGUPDATEDENTERPRISECUSTOMERIDENTERPRISECUSTOMERINFOACTIONFORMGETENTERPRISECUSTOMER_ID/获得在查询参数字符串中所提交的目标页码/BYTETARGETPAGECOUNTERENTERPRISECUSTOMERINFOACTIONFORMGETTARGETPAGECOUNTER/获得在查询参数字符串中所提交的HQL语句中的WHERE条件子字符串/STRINGTARGETHQLWHERESTRINGENTERPRISECUSTOMERINFOACTIONFORMGETSQLQUERYWHERESTRING/调用通过SPRINGIOC获得的DAO对象实现对企业客户信息进行查询满足条件的数据/ENTERPRISECUSTOMERINFOPORETURNUPDATEDENTERPRISECUSTOMERINFOPOENTERPRISECUSTOMERINFOCRUDIMPLESELECTONEENTERPRISECUSTOMERINFOINTEGERPARSEINTUPDATEDENTERPRISECUSTOMERID/将待修改的企业客户信息对象保存到REQUESTSCOPE作用域中，在修改页面中显示该对象中的各个数据/HTTPSERVLETREQUESTREQUESTSERVLETACTIONCONTEXTGETREQUESTREQUESTSETATTRIBUTE“ONEUPDATEDENTERPRISECUSTOMERINFOPO“,RETURNUPDATEDENTERPRISECUSTOMERINFOPO/将分页状态对象保存到REQUESTSCOPE作用域中，在页面中显示分页状态有关的各个数据/REQUESTSETATTRIBUTE“TARGETPAGECOUNTER“,TARGETPAGECOUNTER/将上次的查询条件保存到REQUESTSCOPE作用域中，有助于分页跳转继续保持相同的查询条件/REQUESTSETATTRIBUTE“SQLQUERYWHERESTRING“,TARGETHQLWHERESTRING/跳转到显示待修改的企业客户信息的表单页面/RETURN“SHOWUPDATESOMEONEENTERPRISECUSTOMERINFOFORM“/下面的方法是响应查询结果中的删除某个企业客户信息的超链接的请求/PUBLICSTRINGDELETESOMEONEENTERPRISECUSTOMERINFO/获得在查询参数字符串中所提交的待删除的企业客户信息的编号/STRINGDELETEDENTERPRISECUSTOMERIDENTERPRISECUSTOMERINFOACTIONFORMGETENTERPRISECUSTOMER_ID/获得在查询参数字符串中所提交的目标页码/BYTETARGETPAGECOUNTERENTERPRISECUSTOMERINFOACTIONFORMGETTARGETPAGECOUNTER/获得在查询参数字符串中所提交的HQL语句中的WHERE条件子字符串/STRINGTARGETHQLWHERESTRINGENTERPRISECUSTOMERINFOACTIONFORMGETSQLQUERYWHERESTRINGIFTARGETHQLWHERESTRINGNULL/下面的代码实现对通过GET提交的SQL语句中的中文字符串进行编码转换以获得正确的中文字符串/TRYTARGETHQLWHERESTRINGNEWSTRINGTARGETHQLWHERESTRINGGETBYTES“ISO88591“,“GBK“CATCHUNSUPPORTEDENCODINGEXCEPTIONEEPRINTSTACKTRACE/调用通过SPRINGIOC获得的DAO对象实现对企业客户信息进行删除操作/BOOLEANRETURNSTATERESULTENTERPRISECUSTOMERINFOCRUDIMPLEDELETEONEENTERPRISECUSTOMERINFOINTEGERPARSEINTDELETEDENTERPRISECUSTOMERID/识别数据删除是否成功，如果出现错误，则跳转到错误显示页面中进行错误信息的显示/IFRETURNSTATERESULTHTTPSERVLETREQUESTREQUESTSERVLETACTIONCONTEXTGETREQUESTREQUESTSETATTRIBUTE“ERRORTEXT“,“在删除企业客户信息时，系统出现了错误，请重新删除该企业客户的信息“RETURN“GOTOSHOWERRORINFO“/如果数据删除成功，则继续查询当前页码所对应的信息在页面中继续显示，下面的代码实现将目标页码缓存在分页状态的PO对象中/PAGESTATEPOONEPAGESTATEPONULLONEPAGESTATEPONEWPAGESTATEPOONEPAGESTATEPOSETCURRENTPAGENUMBERTARGETPAGECOUNTER/获得指定页数据ONEPAGESTATEPOSETONEPAGESIZEALLCONSTANTITEMSONEPAGESIZE_INDATAQUERY/调用通过SPRINGIOC获得的DAO对象实现对企业客户信息进行查询满足条件的数据/LISTRETURNALLENTERPRISECUSTOMERINFOPOENTERPRISECUSTOMERINFOCRUDIMPLESELECTSOMEENTERPRISECUSTOMERINFOTARGETHQLWHERESTRING,ONEPAGESTATEPO/将查询的结果保存到REQUESTSCOPE作用域中，实现在页面中显示输出数据/HTTPSERVLETREQUESTREQUESTSERVLETACTIONCONTEXTGETREQUESTREQUESTSETATTRIBUTE“ALLENTERPRISECUSTOMERINFOPOINLIST“,RETURNALLENTERPRISECUSTOMERINFOPO/将分页状态对象保存到REQUESTSCOPE作用域中，在页面中显示分页状态有关的各个数据/REQUESTSETATTRIBUTE“ONEPAGESTATEPO“,ONEPAGESTATEPOREQUESTSETATTRIBUTE“SQLQUERYWHERESTRING“,SYSTEMUTILREMOVESOMEONECHARINSTRINGTARGETHQLWHERESTRING,/跳转到查询结果的显示目标页面中显示输出所查询的结果信息/RETURN“QUERYENTERPRISECUSTOMERINFOSUCCESS“/下面的方法是响应修改查询结果中的某个企业客户信息的表单请求/PUBLICSTRINGUPDATEENTERPRISECUSTOMERINFO/获得在查询参数字符串中所提交的目标页码/BYTETARGETPAGECOUNTERENTERPRISECUSTOMERINFOACTIONFORMGETTARGETPAGECOUNTER/获得在查询参数字符串中所提交的HQL语句中的WHERE条件子字符串/STRINGTARGETHQLWHERESTRINGENTERPRISECUSTOMERINFOACTIONFORMGETSQLQUERYWHERESTRINGIFTARGETHQLWHERESTRINGNULL/下面的代码实现对通过GET提交的SQL语句中的中文字符串进行编码转换以获得正确的中文字符串/TRYTARGETHQLWHERESTRINGNEWSTRINGTARGETHQLWHERESTRINGGETBYTES“ISO88591“,“GBK“CATCHUNSUPPORTEDENCODINGEXCEPTIONEEPRINTSTACKTRACE/构建出包装待修改的企业信息数据库表的PO对象/ENTERPRISECUSTOMERINFOPOUPDATEDENTERPRISECUSTOMERINFOPONEWENTERPRISECUSTOMERINFOPO/将缓存在表单对象中的各个成员属性值转存到PO对象中/UPDATEDENTERPRISECUSTOMERINFOPOSETCORPORATION_NAMEENTERPRISECUSTOMERINFOACTIONFORMGETCORPORATION_NAMEUPDATEDENTERPRISECUSTOMERINFOPOSETMANAGER_NAMEENTERPRISECUSTOMERINFOACTIONFORMGETMANAGER_NAMEUPDATEDENTERPRISECUSTOMERINFOPOSETADDRESS_INFOENTERPRISECUSTOMERINFOACTIONFORMGETADDRESS_INFOUPDATEDENTERPRISECUSTOMERINFOPOSETBANK_NAMEENTERPRISECUSTOMERINFOACTIONFORMGETBANK_NAMEUPDATEDENTERPRISECUSTOMERINFOPOSETBANK_ACCOUNTENTERPRISECUSTOMERINFOACTIONFORMGETBANK_ACCOUNTUPDATEDENTERPRISECUSTOMERINFOPOSETMOBILE_NUMBERENTERPRISECUSTOMERINFOACTIONFORMGETMOBILE_NUMBERUPDATEDENTERPRISECUSTOMERINFOPOSETPOSTCODE_INFOENTERPRISECUSTOMERINFOACTIONFORMGETPOSTCODE_INFOUPDATEDENTERPRISECUSTOMERINFOPOSETWEBSITE_URLINFOENTERPRISECUSTOMERINFOACTIONFORMGETWEBSITE_URLINFO/下面的代码识别表单中所提交的联系人编号是否为空，如果为空，则不将字符串转换为数字；只有在字符串为有效的数据时，再进行转换。/IFENTERPRISECUSTOMERINFOACTIONFORMGETCONTACTPERSON_IDNULL|“EQUALSENTERPRISECUSTOMERINFOACTIONFORMGETCONTACTPERSON_IDUPDATEDENTERPRISECUSTOMERINFOPOSETCONTACTPERSON_ID0ELSEUPDATEDENTERPRISECUSTOMERINFOPOSETCONTACTPERSON_IDINTEGERPARSEINTENTERPRISECUSTOMERINFOACTIONFORMGETCONTACTPERSON_IDUPDATEDENTERPRISECUSTOMERINFOPOSETPROVINCES_NAMEENTERPRISECUSTOMERINFOACTIONFORMGETPROVINCES_NAMEUPDATEDENTERPRISECUSTOMERINFOPOSETCITY_NAMEENTERPRISECUSTOMERINFOACTIONFORMGETCITY_NAMEUPDATEDENTERPRISECUSTOMERINFOPOSETCOUNTY_NAMEENTERPRISECUSTOMERINFOACTIONFORMGETCOUNTY_NAMEUPDATEDENTERPRISECUSTOMERINFOPOSETSUPERVISOR_NAMEENTERPRISECUSTOMERINFOACTIONFORMGETSUPERVISOR_NAME/获得在修改客户信息表单中通过隐藏表单成员传递的客户信息编号，并缓存在PO对象中/UPDATEDENTERPRISECUSTOMERINFOPOSETENTERPRISECUSTOMER_IDINTEGERPARSEINTENTERPRISECUSTOMERINFOACTIONFORMGETENTERPRISECUSTOMER_ID/调用通过SPRINGIOC获得的DAO对象实现对企业客户信息进行修改操作/BOOLEANRETURNSTATERESULTENTERPRISECUSTOMERINFOCRUDIMPLEUPDATEONEENTERPRISECUSTOMERINFOUPDATEDENTERPRISECUSTOMERINFOPO/识别数据修改是否成功，如果出现错误，则跳转到错误显示页面中进行错误信息的显示/IFRETURNSTATERESULTHTTPSERVLETREQUESTREQUESTSERVLETACTIONCONTEXTGETREQUESTREQUESTSETATTRIBUTE“ERRORTEXT“,“在修改企业客户信息时，系统出现了错误，请重新修改该企业客户的信息“RETURN“GOTOSHOWERRORINFO“/如果数据修改成功，则继续查询当前页码所对应的信息在页面中继续显示，下面的代码实现将目标页码缓存在分页状态的PO对象中/PAGESTATEPOONEPAGESTATEPONULLONEPAGESTATEPONEWPAGESTATEPOONEPAGESTATEPOSETCURRENTPAGENUMBERTARGETPAGECOUNTER/获得指定页数据ONEPAGESTATEPOSETONEPAGESIZEALLCONSTANTITEMSONEPAGESIZE_INDATAQUERY/调用通过SPRINGIOC获得的DAO对象实现对企业客户信息进行查询满足条件的数据/LISTRETURNALLENTERPRISECUSTOMERINFOPOENTERPRISECUSTOMERINFOCRUDIMPLESELECTSOMEENTERPRISECUSTOMERINFOTARGETHQLWHERESTRING,ONEPAGESTATEPO/将查询的结果保存到REQUESTSCOPE作用域中，实现在页面中显示输出数据/HTTPSERVLETREQUESTREQUESTSERVLETACTIONCONTEXTGETREQUESTREQUESTSETATTRIBUTE“ALLENTERPRISECUSTOMERINFOPOINLIST“,RETURNALLENTERPRISECUSTOMERINFOPO/将分页状态对象保存到REQUESTSCOPE作用域中，在页面中显示分页状态有关的各个数据/REQUESTSETATTRIBUTE“ONEPAGESTATEPO“,ONEPAGESTATEPOREQUESTSETATTRIBUTE“SQLQUERYWHERESTRING“,SYSTEMUTILREMOVESOMEONECHARINSTRINGTARGETHQLWHERESTRING,/跳转到查询结果的显示目标页面中显示输出所查询的结果信息/RETURN“QUERYENTERPRISECUSTOMERINFOSUCCESS“/下面为辅助的功能服务方法/按照企业客户信息编号查询方式中动态构建出不同条件的HQL条件WHERE语句/PRIVATESTRINGGETWHERESTRINGBYCUSTOMERINFOIDQUERYMETHODSTRINGBUFFERSOMEONESQLQUERYWHERESTRINGNEWSTRINGBUFFERSWITCHENTERPRISECUSTOMERINFOACTIONFORMGETENTERPRISECUSTOMER_IDOPERATORCASE1SOMEONESQLQUERYWHERESTRINGAPPEND“WHEREONEENTERPRISECUSTOMERINFOPOENTERPRISECUSTOMER_ID“BREAKCASE2SOMEONESQLQUERYWHERESTRINGAPPEND“WHEREONEENTERPRISECUSTOMERINFOPOENTERPRISECUSTOMER_ID“BREAKCASE3SOMEONESQLQUERYWHERESTRINGAPPEND“WHEREONEENTERPRISECUSTOMERINFOPOENTERPRISECUSTOMER_ID“BREAKCASE5SOMEONESQLQUERYWHERESTRINGAPPEND“WHEREONEENTERPRISECUSTOMERINFOPOENTERPRISECUSTOMER_ID0IFENTERPRISECUSTOMERINFOACTIONFORMGETCORPORATION_NAMEOPERATOR1SOMEONESQLQUERYWHERESTRINGAPPEND“ONEENTERPRISECUSTOMERINFOPOCORPORATION_NAMELIKE“SOMEONESQLQUERYWHERESTRINGAPPENDENTERPRISECUSTOMERINFOACTIONFORMGETCORPORATION_NAMESOMEONESQLQUERYWHERESTRINGAPPEND“AND“ELSESOMEONESQLQUERYWHERESTRINGAPPEND“ONEENTERPRISECUSTOMERINFOPOCORPORATION_NAME“SOMEONESQLQUERYWHERESTRINGAPPENDENTERPRISECUSTOMERINFOACTIONFORMGETCORPORATION_NAMESOMEONESQLQUERYWHERESTRINGAPPEND“AND“IFENTERPRISECUSTOMERINFOACTIONFORMGETMANAGER_NAMELENGTH0IFENTERPRISECUSTOMERINFOACTIONFORMGETMANAGER_NAMEOPERATOR1SOMEONESQLQUERYWHERESTRINGAPPEND“ONEENTERPRISECUSTOMERINFOPOMANAGER_NAMELIKE“SOMEONESQLQUERYWHERESTRINGAPPENDENTERPRISECUSTOMERINFOACTIONFORMGETMANAGER_NAMESOMEONESQLQUERYWHERESTRINGAPPEND“AND“ELSESOMEONESQLQUERYWHERESTRINGAPPEND“ONEENTERPRISECUSTOMERINFOPOMANAGER_NAME“SOMEONESQLQUERYWHERESTRINGAPPENDENTERPRISECUSTOMERINFOACTIONFORMGETMANAGER_NAMESOMEONESQLQUERYWHERESTRINGAPPEND“AND“IFENTERPRISECUSTOMERINFOACTIONFORMGETBANK_NAMELENGTH0IFENTERPRISECUSTOMERINFOACTIONFORMGETBANK_NAMEOPERATOR1SOMEONESQLQUERYWHERESTRINGAPPEND“ONEENTERPRISECUSTOMERINFOPOBANK_NAMELIKE“SOMEONESQLQUERYWHERESTRINGAPPENDENTERPRISECUSTOMERINFOACTIONFORMGETBANK_NAMESOMEONESQLQUERYWHERESTRINGAPPEND“AND“ELSESOMEONESQLQUERYWHERESTRINGAPPEND“ONEENTERPRISECUSTOMERINFOPOBANK_NAME“SOMEONESQLQUERYWHERESTRINGAPPENDENTERPRISECUSTOMERINFOACTIONFORMGETBANK_NAMESOMEONESQLQUERYWHERESTRINGAPPEND“AND“IFENTERPRISECUSTOMERINFOACTIONFORMGETBANK_ACCOUNTLENGTH0IFENTERPRISECUSTOMERINFOACTIONFORMGETBANK_ACCOUNTOPERATOR1SOMEONESQLQUERYWHERESTRINGAPPEND“ONEENTERPRISECUSTOMERINFOPOBANK_ACCOUNTLIKE“SOMEONESQLQUERYWHERESTRINGAPPENDENTERPRISECUSTOMERINFOACTIONFORMGETBANK_ACCOUNTSOMEONESQLQUERYWHERESTRINGAPPEND“ELSESOMEONESQLQUERYWHERESTRINGAPPEND“ONEENTERPRISECUSTOMERINFOPOBANK_ACCOUNT“SOMEONESQLQUERYWHERESTRINGAPPENDENTERPRISECUSTOMERINFOACTIONFORMGETBANK_ACCOUNTSOMEONESQLQUERYWHERESTRINGAPPEND“/下面的代码是除掉SQL语句字符串的最后可能出现的“AND“结尾的子字符串/INTANDSTRINGINDEXSOMEONESQLQUERYWHERESTRINGINDEXOF“AND“,SOMEONESQLQUERYWHERESTRINGLENGTH4IFANDSTRINGINDEX1/找到了“AND”字符串后，再将最后面的“AND”字符串删除掉/SOMEONESQLQUERYWHERESTRINGDELETEANDSTRINGINDEX,SOMEONESQLQUERYWHERESTRINGLENGTH/将最终动态构建出的WHERE条件字符串返回/RETURNSOMEONESQLQUERYWHERESTRINGTOSTRING/高级查询方式中动态构建出不同条件的HQL条件WHERE语句/PRIVATESTRINGGETWHERESTRINGINADVANCEQUERYMETHOD/下面的代码首先识别是否没有选中任何的项目，但要注意对下面的字符串不能判断是否为NULL而应该要判断其长度，因为在PO类中的各个成员属性并不为NULL。/BOOLEANCHECKALLSELECTITEMISNULLENTERPRISECUSTOMERINFOACTIONFORMGETCORPORATION_NAMEADVANCELENGTH0IFCHECKALLSELECTITEMISNULLRETURN“/没有选中任何的项目时，将不创建出SQL语句中的WHERE条件语句/如果有输入的条件，则添加“WHERE”/STRINGBUFFERSOMEONESQLQUERYWHERESTRINGNEWSTRINGBUFFERSOMEONESQLQUERYWHERESTRINGAPPEND“WHERE“IFENTERPRISECUSTOMERINFOACTIONFORMGETMOBILE_NUMBERLENGTH0IFENTERPRISECUSTOMERINFOACTIONFORMGETMOBILE_NUMBEROPERATOR1SOMEONESQLQUERYWHERESTRINGAPPEND“ONEENTERPRISECUSTOMERINFOPOMOBILE_NUMBERLIKE“SOMEONESQLQUERYWHERESTRINGAPPENDENTERPRISECUSTOMERINFOACTIONFORMGETMOBILE_NUMBERS