mybatis存储过程

sql:

CREATE DEFINER=`root`@`%` PROCEDURE `updateAccount`(IN u_accountid varchar(50),IN u_userid VARCHAR(50), IN u_money decimal(10,0)) BEGIN  

DECLARE from_account_balance decimal(10);   DECLARE status_ int(2);  START TRANSACTION;  

SELECT balance INTO from_account_balance FROM t_account     WHERE uuid = u_accountid FOR UPDATE;   IF from_account_balance>=u_money THEN        UPDATE t_account SET balance = balance - u_money , update_time = sysdate()           WHERE uuid = u_accountid;           UPDATE sys_user SET role = role + u_money          WHERE uuid = u_userid;       COMMIT;  

    SET status_=1;   ELSE        ROLLBACK;       SET status_=0;   END IF;  

SELECT status_; END

 

mapper.xml

<select id="updateAccount" resultType="net.sf.json.JSONObject" parameterType="net.sf.json.JSONObject" statementType="CALLABLE"> {call updateAccount(#{u_accountid,mode=IN},#{u_userid,mode=IN},#{u_money,mode=IN})} </select>

mapper.java

JSONObject updateAccount(JSONObject jsonObject);