service层
public int processingData(InfoPO infoPO) {
dao.processingData(infoPO);
int fdcount = infoPO.getFdcount();
return fdcount;
}
dao层
public interface InfoDao{
Integer processingData(InfoPO infoPO);
}
mapper中xml文件
<select id="processingData" statementType="CALLABLE" parameterType="com.info.entity.InfoPO"
resultType="integer">
{call USP_INFO(
#{id,mode=IN,jdbcType=VARCHAR},
#{fdcount,mode=OUT,jdbcType=VARCHAR})}
</select>
存储过程 (oracle)
CREATE OR REPLACE
PROCEDURE usp_info (tempid IN VARCHAR2, fdcount OUT INT)
AS
BEGIN
UPDATE info A SET A.re_id ='aaaa' WHERE A.temp_id = tempid;
SELECT count(1) INTO fdcount from info a where a.TEMP_ID = tempid;
END;