14 mybatis转钱和查询余额(优化后)

package service.impl; import entity.Account; import mapper.AccountMapper; import org.apache.ibatis.session.SqlSession; import service.AccountService; import utils.DButil; public class AccountServiceImpl implements AccountService { @Override public boolean toMoney(Account account1, Account account2, int money) { // int row1 = 0; int row2 = 0; SqlSession sqlSession = null; try { sqlSession = DButil.getSqlSession(); AccountMapper mapper = sqlSession.getMapper(AccountMapper.class); account1.setAcmoney(account1.getAcmoney()-money); account2.setAcmoney(account2.getAcmoney() +money); row1 = mapper.updateById(account1); // 1 //int x = 10/0; // exception row2 = mapper.updateById(account2); // 1 sqlSession.commit(); } catch (Exception e) { sqlSession.rollback(); } finally { DButil.closeSqlSession(sqlSession); } if(row1+row2 >=2) return true; else return false; } public Account getById(int id) { SqlSession sqlSession = DButil.getSqlSession(); AccountMapper mapper = sqlSession.getMapper(AccountMapper.class); Account account = mapper.selectById(id); DButil.closeSqlSession(sqlSession); return account; } }