Contract renewal back write error bug fix (Learning jar package)

1 PrivateBasedao Basedao;2  PublicBasedao Getbasedao () {3 if(Basedao = =NULL ){4Basedao =NewBasedao ();5 }6 returnBasedao;7 }8 9 @OverrideTen  Publicstring QUERYHIPSNDOCCTRTBYPK (String pk_psndoc_sub, string pk_psndoc) One throwsbusinessexception { AString sql = "SELECT * from HI_PSNDOC_CTRT where pk_psndoc_sub= '" +pk_psndoc_sub+ "' and Pk_psndoc = '" +pk_psndoc + "' and N VL (dr,0) = 0 "; -List<ctrtvo> Listvo = (list<ctrtvo>) Getbasedao (). ExecuteQuery (SQL,NewBeanlistprocessor (Ctrtvo.class));  - if(Listvo! =NULL&& listvo.size () > 0) { the return(String) listvo.get (0). Getpk_psndoc_sub (); -}Else{ - return""; - } +  -}

Write in an Access port

PrivateBasedao Basedao; PublicBasedao Getbasedao () {if(Basedao = =NULL) {Basedao=NewBasedao ();}returnBasedao;} @Override Publicstring QUERYHIPSNDOCCTRTBYPK (String pk_psndoc_sub, string pk_psndoc)throwsbusinessexception {String SQL= "SELECT * from HI_PSNDOC_CTRT where pk_psndoc_sub= '" +pk_psndoc_sub+ "' and Pk_psndoc = '" +pk_psndoc + "' and NVL (dr,0) = 0 "; List<CtrtVO> Listvo = (list<ctrtvo>) Getbasedao (). ExecuteQuery (SQL,NewBeanlistprocessor (Ctrtvo.class)); if(Listvo! =NULL&& listvo.size () > 0) {return(String) listvo.get (0). Getpk_psndoc_sub ();}Else{return"";}}/*** Based on primary key and people primary key query whether there is a person recorded in the HI_PSNDOC_CTRT table *@parampk_psndoc_sub*@parampk_psndoc*@return* @throwsbusinessexception*@author[email protected] Eric Tsang*/ PublicString QUERYHIPSNDOCCTRTBYPK (String pk_psndoc_sub,string pk_psndoc)throwsBusinessexception;

Contract renewal back write error bug fix (Learning jar package)