使用ssh存儲過程實現(xiàn)購物車添加和商品列表的數(shù)據減少,程序執(zhí)行成功但是數(shù)據庫數(shù)據沒變java調用public int add(int sid,int num,double total,int uid) { try { this.getSession().getNamedQuery("update").setParameter(0, sid).setParameter(1, num)
.setParameter(2, total).setParameter(3, uid); return 1;
} catch (Exception e) { // TODO: handle exception e.printStackTrace(); return 0;
}
}調用mysql存儲過程代碼 <sql-query name="update" callable="true">
{call zcxg(?,?,?,?)} </sql-query>mysql的存儲過程詳細代碼create procedure `zcxg`(in sid int,in num int,in total double,in uid int)beginupdate shop as s set s.`number`=(s.`number`-`num`) where s.`id`=`sid`;insert into cart(number,sid,total,uid) values(`num`,`sid`,`total`,`uid`);commit;end
ssh存儲過程無法改變數(shù)據庫數(shù)據
慕娘9325324
2018-08-24 10:09:29