ibatis調用mysql帶OUT類型參數的存儲過程,存儲過程的參數:
P_SAVEOBJ( IN I_ID_OBJ INT, IN STR_OBJNAME VARCHAR(255), OUT o_ret VARCHAR(100) )
xml配置:
{call P_SAVEOBJ(?, ?, ?)}
java調用:
HashMap paramMap = new HashMap(); paramMap.put("I_ID_OBJ",jobId);//INT;1 paramMap.put("STR_OBJNAME",jobName);//VARCHAR(255);2 this.getSqlMapClientTemplate().update("saveObjByProcedure", paramMap);