基于ssh2架构的课程设计实训教学示例项目——《客户关系管理crm系统》——合同信息的crud实现和测试

基于SSH2架构的课程设计实训教学示例项目客户关系管理CRM系统合同信息的CRUD实现和测试111合同信息的CRUD功能实现1、在项目中添加一个包装订单信息的PO类（1）类名称为CONTRACTINFOPO，包名称为COMPX1987BLUEDREAMCRMDAOPO（2）在PO类中添加如下的成员PRIVATEINTCONTRACT_ID/合同IDPRIVATESTRINGCONTRACT_KINDNUMBER/合同类型PRIVATESTRINGCONTRACT_TITLETEXT/合同标题PRIVATEINTCUSTOMER_ID/甲方签订人IDPRIVATESTRINGCONTRACT_SECONDNAME/乙方签订人姓名PRIVATESTRINGCONTRACT_CURRENTSTATE/合同状态PRIVATEDOUBLECONTRACT_TOTALMONEY/合同总金额PRIVATEJAVASQLDATECONTRACT_SIGNDATE/签订日期PRIVATEJAVASQLDATECONTRACT_DEADLINEDATE/截止日期PRIVATESTRINGCONTRACT_INSTRUCTIONTEXT/合同说明（3）为这些属性提供GET/SET方法（4）在该类中提供一个显示合同标题名称简称的方法PUBLICSTRINGGETCONTRACTINFO_BRIEFTITLETEXT/如果多于12个字符（汉字），则显示合同标题的简称IFCONTRACT_TITLETEXTLENGTH12RETURNCONTRACT_TITLETEXTSUBSTRING0,8“ELSERETURNCONTRACT_TITLETEXT（5）在该类中提供如下的获得日期中的“年、月、日”数据的方法PUBLICINTGETCONTRACT_SIGNDATEYEARRETURNCONTRACT_SIGNDATEGETYEAR1900PUBLICINTGETCONTRACT_SIGNDATEMONTHRETURNCONTRACT_SIGNDATEGETMONTH1PUBLICINTGETCONTRACT_SIGNDATEDATERETURNCONTRACT_SIGNDATEGETDATEPUBLICINTGETCONTRACT_DEADLINEDATEYEARRETURNCONTRACT_DEADLINEDATEGETYEAR1900PUBLICINTGETCONTRACT_DEADLINEDATEMONTHRETURNCONTRACT_DEADLINEDATEGETMONTH1PUBLICINTGETCONTRACT_DEADLINEDATEDATERETURNCONTRACT_DEADLINEDATEGETDATE2、添加一个对产品信息进行操作的DAO接口（1）接口的名称为CONTRACTINFOCRUDINTERFACE，包名称为COMPX1987BLUEDREAMCRMDAOINTER（2）设计该接口中的CRUD方法PACKAGECOMPX1987BLUEDREAMCRMDAOINTERIMPORTJAVAUTILLISTIMPORTCOMPX1987BLUEDREAMCRMDAOPOCONTRACTINFOPOIMPORTCOMPX1987BLUEDREAMCRMDAOPOPAGESTATEPOIMPORTCOMPX1987BLUEDREAMCRMEXCEPTIONCRMDATAACCESSEXCEPTIONPUBLICINTERFACECONTRACTINFOCRUDINTERFACE/分页查询所有的合同信息/PUBLICLISTSELECTALLCONTRACTINFOPAGESTATEPOONEPAGESTATEPOTHROWSCRMDATAACCESSEXCEPTION/分页查询满足条件的合同信息/PUBLICLISTSELECTSOMECONTRACTINFOSTRINGSQLWHERESTRING,PAGESTATEPOONEPAGESTATEPOTHROWSCRMDATAACCESSEXCEPTION/查询指定编号的合同信息/PUBLICCONTRACTINFOPOSELECTONECONTRACTINFOINTCONTRACTINFOIDTHROWSCRMDATAACCESSEXCEPTION/查询合同信息的总数/PUBLICINTSELECTTOTALCONTRACTINFOCOUNTERTHROWSCRMDATAACCESSEXCEPTION/添加一条合同信息/PUBLICBOOLEANINSERTONECONTRACTINFOCONTRACTINFOPOONECONTRACTINFOPOTHROWSCRMDATAACCESSEXCEPTION/添加一条合同信息，并再次查询出该合同信息/PUBLICCONTRACTINFOPOINSERTONECONTRACTINFOANDQUERYITCONTRACTINFOPOONECONTRACTINFOPOTHROWSCRMDATAACCESSEXCEPTION/修改一条合同信息/PUBLICBOOLEANUPDATEONECONTRACTINFOCONTRACTINFOPOONEUPDATEDCONTRACTINFOPOTHROWSCRMDATAACCESSEXCEPTION/删除一条合同信息/PUBLICBOOLEANDELETEONECONTRACTINFOINTCONTRACTINFOIDTHROWSCRMDATAACCESSEXCEPTION/批量删除一批合同信息/PUBLICBOOLEANBATCHDELETECONTRACTINFOLISTDELETEDCONTRACTINFOIDSTHROWSCRMDATAACCESSEXCEPTION3、为该CONTRACTINFOCRUDINTERFACE接口提供一个实现类（1）类名称为CONTRACTINFOCRUDIMPLE，包名称为COMPX1987BLUEDREAMCRMDAOIMPLE，并且实现COMPX1987BLUEDREAMCRMDAOINTERCONTRACTINFOCRUDINTERFACE接口（2）编程该实现类PACKAGECOMPX1987BLUEDREAMCRMDAOIMPLEIMPORTJAVASQLCONNECTIONIMPORTJAVASQLPREPAREDSTATEMENTIMPORTJAVASQLRESULTSETIMPORTJAVASQLSQLEXCEPTIONIMPORTJAVAUTILARRAYLISTIMPORTJAVAUTILITERATORIMPORTJAVAUTILLISTIMPORTJAVAUTILLOGGINGLEVELIMPORTJAVAUTILLOGGINGLOGGERIMPORTCOMPX1987BLUEDREAMCRMDAOINTERCONNECTDBINTERFACEIMPORTCOMPX1987BLUEDREAMCRMDAOINTERCONTRACTINFOCRUDINTERFACEIMPORTCOMPX1987BLUEDREAMCRMDAOPOCONTRACTINFOPOIMPORTCOMPX1987BLUEDREAMCRMDAOPOPAGESTATEPOIMPORTCOMPX1987BLUEDREAMCRMEXCEPTIONCRMDATAACCESSEXCEPTIONPUBLICCLASSCONTRACTINFOCRUDIMPLEIMPLEMENTSCONTRACTINFOCRUDINTERFACEPRIVATECONNECTDBINTERFACEONEDBCPCONNECTDBBEANNULLPRIVATECONNECTIONONEJDBCCONNECTIONNULLPRIVATELOGGERLOGGERLOGGERGETLOGGERTHISGETCLASSGETNAMEPUBLICCONTRACTINFOCRUDIMPLEONEDBCPCONNECTDBBEANNEWMYSQLCONNECTDBBEANOVERRIDEPUBLICBOOLEANBATCHDELETECONTRACTINFOLISTDELETEDCONTRACTINFOIDSTHROWSCRMDATAACCESSEXCEPTIONPREPAREDSTATEMENTONEPREPAREDSTATEMENTNULLSTRINGDELETECONTRACTINFOSQL“DELETEFROMCONTRACT_INFOWHERECONTRACT_ID“BOOLEANRETURNRESULTTRUEONEJDBCCONNECTIONONEDBCPCONNECTDBBEANGETCONNECTIONTRYTRYONEJDBCCONNECTIONSETAUTOCOMMITFALSE/开始事务ONEPREPAREDSTATEMENTONEJDBCCONNECTIONPREPARESTATEMENTDELETECONTRACTINFOSQLCATCHSQLEXCEPTIONELOGGERLOGLEVELINFO,EGETMESSAGETHROWNEWCRMDATAACCESSEXCEPTION“不能创建SQL语句对象，可能是SQL语句有错误“TRYITERATORALLDELETEEDCONTRACTINFOIDSDELETEDCONTRACTINFOIDSITERATORWHILEALLDELETEEDCONTRACTINFOIDSHASNEXTINTCONTRACTINFOIDTODELETEDINTEGERALLDELETEEDCONTRACTINFOIDSNEXTINTVALUEONEPREPAREDSTATEMENTSETINT1,CONTRACTINFOIDTODELETEDONEPREPAREDSTATEMENTADDBATCHCATCHSQLEXCEPTIONELOGGERLOGLEVELINFO,EGETMESSAGETHROWNEWCRMDATAACCESSEXCEPTION“不能对SQL语句对象中的参数赋值，可能是参数不正确“TRYONEPREPAREDSTATEMENTEXECUTEBATCHONEJDBCCONNECTIONCOMMITCATCHSQLEXCEPTIONETRYONEJDBCCONNECTIONROLLBACKCATCHSQLEXCEPTIONE1LOGGERLOGLEVELINFO,EGETMESSAGETHROWNEWCRMDATAACCESSEXCEPTION“在批处理删除回滚时出现了错误“LOGGERLOGLEVELINFO,EGETMESSAGETHROWNEWCRMDATAACCESSEXCEPTION“在执行批处理删除时出现了错误“TRYONEPREPAREDSTATEMENTCLOSECATCHSQLEXCEPTIONELOGGERLOGLEVELINFO,EGETMESSAGETHROWNEWCRMDATAACCESSEXCEPTION“不能正确地关闭SQL语句对象“FINALLYONEDBCPCONNECTDBBEANCLOSEDBCONNECTIONRETURNRETURNRESULTOVERRIDEPUBLICBOOLEANDELETEONECONTRACTINFOINTCONTRACTINFOIDTHROWSCRMDATAACCESSEXCEPTIONPREPAREDSTATEMENTONEPREPAREDSTATEMENTNULLINTRETURNRESULT0ONEJDBCCONNECTIONONEDBCPCONNECTDBBEANGETCONNECTIONSTRINGSQLDELETECUSTOMERSTATEMENT“DELETEFROMCONTRACT_INFOWHERECONTRACT_ID“TRYTRYONEPREPAREDSTATEMENTONEJDBCCONNECTIONPREPARESTATEMENTSQLDELETECUSTOMERSTATEMENTCATCHSQLEXCEPTIONELOGGERLOGLEVELINFO,EGETMESSAGETHROWNEWCRMDATAACCESSEXCEPTION“不能创建SQL语句对象，可能是SQL语句有错误“TRYONEPREPAREDSTATEMENTSETINT1,CONTRACTINFOIDCATCHSQLEXCEPTIONELOGGERLOGLEVELINFO,EGETMESSAGETHROWNEWCRMDATAACCESSEXCEPTION“不能对SQL语句对象中的参数赋值，可能是参数不正确“TRYRETURNRESULTONEPREPAREDSTATEMENTEXECUTEUPDATECATCHSQLEXCEPTIONELOGGERLOGLEVELINFO,EGETMESSAGETHROWNEWCRMDATAACCESSEXCEPTION“不能对SQL语句对象进行删除操作，可能是SQL不正确“TRYONEPREPAREDSTATEMENTCLOSECATCHSQLEXCEPTIONELOGGERLOGLEVELINFO,EGETMESSAGETHROWNEWCRMDATAACCESSEXCEPTION“不能正确地关闭SQL语句对象“FINALLYONEDBCPCONNECTDBBEANCLOSEDBCONNECTIONIFRETURNRESULT0RETURNFALSEELSERETURNTRUEOVERRIDEPUBLICBOOLEANINSERTONECONTRACTINFOCONTRACTINFOPOONECONTRACTINFOPOTHROWSCRMDATAACCESSEXCEPTIONPREPAREDSTATEMENTONEPREPAREDSTATEMENTNULLINTRETURNRESULT0ONEJDBCCONNECTIONONEDBCPCONNECTDBBEANGETCONNECTIONTRYSTRINGBUFFERSQLINSERTCONTRACTINFOSTATEMENTNEWSTRINGBUFFERSQLINSERTCONTRACTINFOSTATEMENTAPPEND“INSERTINTOCONTRACT_INFOCONTRACT_KINDNUMBER,CONTRACT_TITLETEXT,“SQLINSERTCONTRACTINFOSTATEMENTAPPEND“CUSTOMER_ID,CONTRACT_SECONDNAME,CONTRACT_CURRENTSTATE,CONTRACT_TOTALMONEY,“SQLINSERTCONTRACTINFOSTATEMENTAPPEND“CONTRACT_SIGNDATE,CONTRACT_DEADLINEDATE,CONTRACT_INSTRUCTIONTEXT,CONTRACT_ID“SQLINSERTCONTRACTINFOSTATEMENTAPPEND“VALUES,“TRYONEPREPAREDSTATEMENTONEJDBCCONNECTIONPREPARESTATEMENTSQLINSERTCONTRACTINFOSTATEMENTTOSTRINGCATCHSQLEXCEPTIONELOGGERLOGLEVELINFO,EGETMESSAGETHROWNEWCRMDATAACCESSEXCEPTION“不能创建SQL语句对象，可能是SQL语句有错误“TRYSETINSERTORUPDATESQLPARAMETERBYCONTRACTINFOPOONEPREPAREDSTATEMENT,ONECONTRACTINFOPOCATCHSQLEXCEPTIONELOGGERLOGLEVELINFO,EGETMESSAGETHROWNEWCRMDATAACCESSEXCEPTION“不能对SQL语句对象中的参数赋值，可能是参数不正确“TRYRETURNRESULTONEPREPAREDSTATEMENTEXECUTEUPDATECATCHSQLEXCEPTIONELOGGERLOGLEVELINFO,EGETMESSAGETHROWNEWCRMDATAACCESSEXCEPTION“不能对SQL语句对象进行插入操作，可能是SQL不正确“TRYONEPREPAREDSTATEMENTCLOSECATCHSQLEXCEPTIONELOGGERLOGLEVELINFO,EGETMESSAGETHROWNEWCRMDATAACCESSEXCEPTION“不能正确地关闭SQL语句对象“FINALLYONEDBCPCONNECTDBBEANCLOSEDBCONNECTIONIFRETURNRESULT0RETURNFALSEELSERETURNTRUEOVERRIDEPUBLICCONTRACTINFOPOINSERTONECONTRACTINFOANDQUERYITCONTRACTINFOPOONECONTRACTINFOPOTHROWSCRMDATAACCESSEXCEPTIONPREPAREDSTATEMENTONEPREPAREDSTATEMENTNULLINTRETURNRESULT0RESULTSETONERESULTSETNULLCONTRACTINFOPORETURNINSERTEDONECONTRACTINFOPONULLONEJDBCCONNECTIONONEDBCPCONNECTDBBEANGETCONNECTION/下面首先插入数据TRYSTRINGBUFFERSQLINSERTCONTRACTINFOSTATEMENTNEWSTRINGBUFFERSQLINSERTCONTRACTINFOSTATEMENTAPPEND“INSERTINTOCONTRACT_INFOCONTRACT_KINDNUMBER,CONTRACT_TITLETEXT,“SQLINSERTCONTRACTINFOSTATEMENTAPPEND“CUSTOMER_ID,CONTRACT_SECONDNAME,CONTRACT_CURRENTSTATE,CONTRACT_TOTALMONEY,“SQLINSERTCONTRACTINFOSTATEMENTAPPEND“CONTRACT_SIGNDATE,CONTRACT_DEADLINEDATE,CONTRACT_INSTRUCTIONTEXT,CONTRACT_ID“SQLINSERTCONTRACTINFOSTATEMENTAPPEND“VALUES,“TRYONEPREPAREDSTATEMENTONEJDBCCONNECTIONPREPARESTATEMENTSQLINSERTCONTRACTINFOSTATEMENTTOSTRINGCATCHSQLEXCEPTIONELOGGERLOGLEVELINFO,EGETMESSAGETHROWNEWCRMDATAACCESSEXCEPTION“不能创建SQL语句对象，可能是SQL语句有错误“TRYSETINSERTORUPDATESQLPARAMETERBYCONTRACTINFOPOONEPREPAREDSTATEMENT,ONECONTRACTINFOPOCATCHSQLEXCEPTIONELOGGERLOGLEVELINFO,EGETMESSAGETHROWNEWCRMDATAACCESSEXCEPTION“不能对SQL语句对象中的参数赋值，可能是参数不正确“TRYRETURNRESULTONEPREPAREDSTATEMENTEXECUTEUPDATECATCHSQLEXCEPTIONELOGGERLOGLEVELINFO,EGETMESSAGETHROWNEWCRMDATAACCESSEXCEPTION“不能对SQL语句对象进行插入操作，可能是SQL不正确“IFRETURNRESULT0THROWNEWCRMDATAACCESSEXCEPTION“该合同信息没有正确地插入到数据库表中，可能是数据库系统出现了异常“/插入成功后再读取该数据STRINGSQLSELECTCONTRACTINFOSTATEMENT“SELECTFROMCONTRACT_INFOWHERECONTRACT_ID“TRYONEPREPAREDSTATEMENTONEJDBCCONNECTIONPREPARESTATEMENTSQLSELECTCONTRACTINFOSTATEMENT,RESULTSETTYPE_SCROLL_SENSITIVE,RESULTSETCONCUR_UPDATABLECATCHSQLEXCEPTIONELOGGERLOGLEVELINFO,EGETMESSAGETHROWNEWCRMDATAACCESSEXCEPTION“不能创建SQL语句对象，可能是SQL语句有错误“TRYONEPREPAREDSTATEMENTSETINT1,ONECONTRACTINFOPOGETCONTRACT_IDCATCHSQLEXCEPTIONELOGGERLOGLEVELINFO,EGETMESSAGETHROWNEWCRMDATAACCESSEXCEPTION“不能对SQL语句对象中的参数赋值，可能是参数不正确“TRYONERESULTSETONEPREPAREDSTATEMENTEXECUTEQUERYIFONERESULTSETNEXTRETURNNULLCATCHSQLEXCEPTIONELOGGERLOGLEVELINFO,EGETMESSAGETHROWNEWCRMDATAACCESSEXCEPTION“不能对SQL语句对象进行查询操作，可能是SQL不正确“RETURNINSERTEDONECONTRACTINFOPONEWCONTRACTINFOPOTRYCONTRACTINFOPO_ORMAPPINGRETURNINSERTEDONECONTRACTINFOPO,ONERESULTSETCATCHSQLEXCEPTIONELOGGERLOGLEVELINFO,EGETMESSAGETHROWNEWCRMDATAACCESSEXCEPTION“不能从结果集中获得所需要的数据值，可能是字段名称不正确“TRYONEPREPAREDSTATEMENTCLOSECATCHSQLEXCEPTIONELOGGERLOGLEVELINFO,EGETMESSAGETHROWNEWCRMDATAACCESSEXCEPTION“不能正确地关闭SQL语句对象“FINALLYONEDBCPCONNECTDBBEANCLOSEDBCONNECTIONRETURNRETURNINSERTEDONECONTRACTINFOPOPRIVATEVOIDSETINSERTORUPDATESQLPARAMETERBYCONTRACTINFOPOPREPAREDSTATEMENTONEPREPAREDSTATEMENT,CONTRACTINFOPOONECONTRACTINFOPOTHROWSSQLEXCEPTIONONEPREPAREDSTATEMENTSETSTRING1,ONECONTRACTINFOPOGETCONTRACT_KINDNUMBERONEPREPAREDSTATEMENTSETSTRING2,ONECONTRACTINFOPOGETCONTRACT_TITLETEXTONEPREPAREDSTATEMENTSETINT3,ONECONTRACTINFOPOGETCUSTOMER_IDONEPREPAREDSTATEMENTSETSTRING4,ONECONTRACTINFOPOGETCONTRACT_SECONDNAMEONEPREPAREDSTATEMENTSETSTRING5,ONECONTRACTINFOPOGETCONTRACT_CURRENTSTATEONEPREPAREDSTATEMENTSETDOUBLE6,ONECONTRACTINFOPOGETCONTRACT_TOTALMONEYONEPREPAREDSTATEMENTSETDATE7,ONECONTRACTINFOPOGETCONTRACT_SIGNDATEONEPREPAREDSTATEMENTSETDATE8,ONECONTRACTINFOPOGETCONTRACT_DEADLINEDATEONEPREPAREDSTATEMENTSETSTRING9,ONECONTRACTINFOPOGETCONTRACT_INSTRUCTIONTEXTONEPREPAREDSTATEMENTSETINT10,ONECONTRACTINFOPOGETCONTRACT_IDPUBLICVOIDCONTRACTINFOPO_ORMAPPINGCONTRACTINFOPOONECONTRACTINFOPO,RESULTSETONERESULTSETTHROWSSQLEXCEPTIONONECONTRACTINFOPOSETCONTRACT_IDONERESULTSETGETINT“CONTRACT_ID“ONECONTRACTINFOPOSETCONTRACT_KINDNUMBERONERESULTSETGETSTRING“CONTRACT_KINDNUMBER“ONECONTRACTINFOPOSETCONTRACT_TITLETEXTONERESULTSETGETSTRING“CONTRACT_TITLETEXT“ONECONTRACTINFOPOSETCUSTOMER_IDONERESULTSETGETINT“CUSTOMER_ID“ONECONTRACTINFOPOSETCONTRACT_SECONDNAMEONERESULTSETGETSTRING“CONTRACT_SECONDNAME“ONECONTRACTINFOPOSETCONTRACT_CURRENTSTATEONERESULTSETGETSTRING“CONTRACT_CURRENTSTATE“ONECONTRACTINFOPOSETCONTRACT_TOTALMONEYONERESULTSETGETDOUBLE“CONTRACT_TOTALMONEY“ONECONTRACTINFOPOSETCONTRACT_SIGNDATEONERESULTSETGETDATE“CONTRACT_SIGNDATE“ONECONTRACTINFOPOSETCONTRACT_DEADLINEDATEONERESULTSETGETDATE“CONTRACT_DEADLINEDATE“ONECONTRACTINFOPOSETCONTRACT_INSTRUCTIONTEXTONERESULTSETGETSTRING“CONTRACT_INSTRUCTIONTEXT“OVERRIDEPUBLICLISTSELECTALLCONTRACTINFOPAGESTATEPOONEPAGESTATEPOTHROWSCRMDATAACCESSEXCEPTIONPREPAREDSTATEMENTONEPREPAREDSTATEMENTNULLRESULTSETONERESULTSETNULLCONTRACTINFOPOONECONTRACTINFOPONULLINTTOTALNUMBEROFELEMENTSLISTALLCONTRACTINFOPOSNEWARRAYLISTONEJDBCCONNECTIONONEDBCPCONNECTDBBEANGETCONNECTIONTRY/首先获得满足条件的总记录数STRINGGETTOTALCOUNTERSQLSTATEMENT“SELECTCOUNTFROMCONTRACT_INFO“TRYONEPREPAREDSTATEMENTONEJDBCCONNECTIONPREPARESTATEMENTGETTOTALCOUNTERSQLSTATEMENT,RESULTSETTYPE_SCROLL_SENSITIVE,RESULTSETCONCUR_UPDATABLECATCHSQLEXCEPTIONELOGGERLOGLEVELINFO,EGETMESSAGETHROWNEWCRMDATAACCESSEXCEPTION“不能创建SQL语句对象，可能是SQL语句有错误“TRYONERESULTSETONEPREPAREDSTATEMENTEXECUTEQUERYCATCHSQLEXCEPTIONELOGGERLOGLEVELINFO,EGETMESSAGETHROWNEWCRMDATAACCESSEXCEPTION“不能对SQL语句对象进行查询操作，可能是SQL不正确“TRYONERESULTSETNEXTTOTALNUMBEROFELEMENTSONERESULTSETGETINT1CATCHSQLEXCEPTIONETHROWNEWCRMDATAACCESSEXCEPTION“不能从结果集中获得所需要的数据值，可能是字段名称不正确“ONEPAGESTATEPOSETPAGESTATEPOMEMBERPROPERTYTOTALNUMBEROFELEMENTS/获得分页中的其它状态数据/然后再获得满足条件的具体记录数据STRINGBUFFERSQLSELECTCONTRACTINFOSTATEMENTNEWSTRINGBUFFERSQLSELECTCONTRACTINFOSTATEMENTAPPEND“SELECTFROMCONTRACT_INFOLIMIT“SQLSELECTCONTRACTINFOSTATEMENTAPPENDONEPAGESTATEPOGETTHISPAGEFIRSTELEMENTNUMBERSQLSELECTCONTRACTINFOSTATEMENTAPPEND“,“SQLSELECTCONTRACTINFOSTATEMENTAPPENDONEPAGESTATEPOGETONEPAGESIZETRYONEPREPAREDSTATEMENTONEJDBCCONNECTIONPREPARESTATEMENTSQLSELECTCONTRACTINFOSTATEMENTTOSTRING,RESULTSETTYPE_SCROLL_SENSITIVE,RESULTSETCONCUR_UPDATABLECATCHSQLEXCEPTIONELOGGERLOGLEVELINFO,EGETMESSAGETHROWNEWCRMDATAACCESSEXCEPTION“不能创建SQL语句对象，可能是SQL语句有错误“TRYONERESULTSETONEPREPAREDSTATEMENTEXECUTEQUERYCATCHSQLEXCEPTIONELOGGERLOGLEVELINFO,EGETMESSAGETHROWNEWCRMDATAACCESSEXCEPTION“不能对SQL语句对象进行查询操作，可能是SQL不正确“TRYWHILEONERESULTSETNEXTONECONTRACTINFOPONEWCONTRACTINFOPOCONTRACTINFOPO_ORMAPPINGONECONTRACTINFOPO,ONERESULTSETALLCONTRACTINFOPOSADDONECONTRACTINFOPOCATCHSQLEXCEPTIONELOGGERLOGLEVELINFO,EGETMESSAGETHROWNEWCRMDATAACCESSEXCEPTION“不能从结果集中获得所需要的数据值，可能是字段名称不正确“TRYONERESULTSETCLOSEONEPREPAREDSTATEMENTCLOSECATCHSQLEXCEPTIONELOGGERLOGLEVELINFO,EGETMESSAGETHROWNEWCRMDATAACCESSEXCEPTION“不能正确地关闭SQL语句对象“FINALLYONEDBCPCONNECTDBBEANCLOSEDBCONNECTIONRETURNALLCONTRACTINFOPOSOVERRIDEPUBLICCONTRACTINFOPOSELECTONECONTRACTINFOINTCONTRACTINFOIDTHROWSCRMDATAACCESSEXCEPTIONCONTRACTINFOPOONECONTRACTINFOPONULLPREPAREDSTATEMENTONEPREPAREDSTATEMENTNULLRESULTSETONERESULTSETNULLONEJDBCCONNECTIONONEDBCPCONNECTDBBEANGETCONNECTIONSTRINGSQLSELECTCONTRACTINFOSTATEMENT“SELECTFROMCONTRACT_INFOWHERECONTRACT_ID“TRYTRYONEPREPAREDSTATEMENTONEJDBCCONNECTIONPREPARESTATEMENTSQLSELECTCONTRACTINFOSTATEMENT,RESULTSETTYPE_SCROLL_SENSITIVE,RESULTSETCONCUR_UPDATABLECATCHSQLEXCEPTIONELOGGERLOGLEVELINFO,EGETMESSAGETHROWNEWCRMDATAACCESSEXCEPTION“不能创建SQL语句对象，可能是SQL语句有错误“TRYONEPREPAREDSTATEMENTSETINT1,CONTRACTINFOIDCATCHSQLEXCEPTIONELOGGERLOGLEVELINFO,EGETMESSAGETHROWNEWCRMDATAACCESSEXCEPTION“不能对SQL语句对象中的参数赋值，可能是参数不正确“TRYONERESULTSETONEPREPAREDSTATEMENTEXECUTEQUERYIFONERESULTSETNEXTRETURNNULLCATCHSQLEXCEPTIONELOGGERLOGLEVELINFO,EGETMESSAGETHROWNEWCRMDATAACCESSEXCEPTION“不能对SQL语句对象进行查询操作，可能是SQL不正确“ONECONTRACTINFOPONEWCONTRACTINFOPOTRYCONTRACTINFOPO_ORMAPPINGONECONTRACTINFOPO,ONERESULTSETCATCHSQLEXCEPTIONELOGGERLOGLEVELINFO,EGETMESSAGETHROWNEWCRMDATAACCESSEXCEPTION“不能从结果集中获得所需要的数据值，可能是字段名称不正确“TRYONERESULTSETCLOSEONEPREPAREDSTATEMENTCLOSECATCHSQLEXCEPTIONELOGGERLOGLEVELINFO,EGETMESSAGETHROWNEWCRMDATAACCESSEXCEPTION“不能正确地关闭SQL语句对象“FINALLYONEDBCPCONNECTDBBEANCLOSEDBCONNECTIONRETURNONECONTRACTINFOPOOVERRIDEPUBLICLISTSELECTSOMECONTRACTINFOSTRINGSQLWHERESTRING,PAGESTATEPOONEPAGESTATEPOTHROWSCRMDATAACCESSEXCEPTIONPREPAREDSTATEMENTONEPREPAREDSTATEMENTNULLRESULTSETONERESULTSETNULLCONTRACTINFOPOONECONTRACTINFOPONULLINTTOTALNUMBEROFELEMENTSLISTALLCONTRACTINFOPOSNEWARRAYLISTONEJDBCCONNECTIONONEDBCPCONNECTDBBEANGETCONNECTIONTRY/首先获得满足条件的总记录数STRINGGETTOTALCOUNTERSQLSTATEMENT“SELECTCOUNTFROMCONTRACT_INFO“SQLWHERESTRINGTRYONEPREPAREDSTATEMENTONEJDBCCONNECTIONPREPARESTATEMENTGETTOTALCOUNTERSQLSTATEMENT,RESULTSETTYPE_SCROLL_SENSITIVE,RESULTSETCONCUR_UPDATABLECATCHSQLEXCEPTIONELOGGERLOGLEVELINFO,EGETMESSAGETHROWNEWCRMDATAACCESSEXCEPTION“不能创建SQL语句对象，可能是SQL语句有错误“TRYONERESULTSETONEPREPAREDSTATEMENTEXECUTEQUERYCATCHSQLEXCEPTIONELOGGERLOGLEVELINFO,EGETMESSAGETHROWNEWCRMDATAACCESSEXCEPTION“不能对SQL语句对象进行查询操作，可能是SQL不正确“TRYONERESULTSETNEXTTOTALNUMBEROFELEMENTSONERESULTSETGETINT1CATCHSQLEXCEPTIONETHROWNEWCRMDATAACCESSEXCEPTION“不能从结果集中获得所需要的数据值，可能是字段名称不正确“ONEPAGESTATEPOSETPAGESTATEPOMEMBERPROPERTYTOTALNUMBEROFELEMENTS/获得分页中的其它状态数据/然后再获得满足条件的具体记录数据STRINGBUFFERSQLSELECTCONTRACTINFOSTATEMENTNEWSTRINGBUFFERSQLSELECTCONTRACTINFOSTATEMENTAPPEND“SELECTFROMCONTRACT_INFO“SQLSELECTCONTRACTINFOSTATEMENTAPPENDSQLWHERESTRINGSQLSELECTCONTRACTINFOSTATEMENTAPPEND“LIMIT“SQLSELECTCONTRACTINFOSTATEMENTAPPENDONEPAGESTATEPOGETTHISPAGEFIRSTELEMENTNUMBERSQLSELECTCONTRACTINFOSTATEMENTAPPEND“,“SQLSELECTCONTRACTINFOSTATEMENTAPPENDONEPAGESTATEPOGETONEPAGESIZETRYONEPREPAREDSTATEMENTONEJDBCCONNECTIONPREPARESTATEMENTSQLSELECTCONTRACTINFOSTATEMENTTOSTRING,RESULTSETTYPE_SCROLL_SENSITIVE,RESULTSETCONCUR_UPDATABLECATCHSQLEXCEPTIONELOGGERLOGLEVELINFO,EGETMESSAGETHROWNEWCRMDATAACCESSEXCEPTION“不能创建SQL语句对象，可能是SQL语句有错误“TRYONERESULTSETONEPREPAREDSTATEMENTEXECUTEQUERYCATCHSQLEXCEPTIONELOGGERLOGLEVELINFO,EGETMESSAGETHROWNEWCRMDATAACCESSEXCEPTION“不能对SQL语句对象进行查询操作，可能是SQL不正确“TRYWHILEONERESULTSETNEXTONECONTRACTINFOPONEWCONTRACTINFOPOCONTRACTINFOPO_ORMAPPINGONECONTRACTINFOPO,ONERESULTSETALLCONTRACTINFOPOSADDONECONTRACTINFOPOCATCHSQLEXCEPTIONELOGGERLOGLEVELINFO,EGETMESSAGETHROWNEWCRMDATAACCESSEXCEPTION“不能从结果集中获得所需要的数据值，可能是字段名称不正确“TRYONERESULTSETCLOSEONEPREPAREDSTATEMENTCLOSECATCHSQLEXCEPTIONELOGGERLOGLEVELINFO,EGETMESSAGETHROWNEWCRMDATAACCESSEXCEPTION“不能正确地关闭SQL语句对象“FINALLYONEDBCPCONNECTDBBEANCLOSEDBCONNECTIONRETURNALLCONTRACTINFOPOSOVERRIDEPUBLICINTSELECTTOTALCONTRACTINFOCOUNTERTHROWSCRMDATAACCESSEXCEPTIONRESULTSETONERESULTSETNULLINTTOTALCONTRACTINFOCOUNTERSTRINGSELECT_SQLSTATEMENT“SELECTCOUNTFROMCONTRACT_INFO“ONEJDBCCONNECTIONONEDBCPCONNECTDBBEANGETCONNECTIONJAVASQLPREPAREDSTATEMENTONEPREPAREDSTATEMENTNULLTRYTRYONEPREPAREDSTATEMENTONEJDBCCONNECTIONPREPARESTATEMENTSELECT_SQLSTATEMENT,RESULTSETTYPE_SCROLL_SENSITIVE,RESULTSETCONCUR_UPDATABLECATCHSQL