事务管理--------使用spring的transactionManager管理事务

事务管理--------使用spring的transactionManager管理事务

dao层

public class EmpDaoImpl extends JdbcDaoSupport implements EmpDao {
   
    
    @Override
    public Emp selectOneEmp(Integer id) throws SQLException {
   
        String sql = "select * from emp where empno=?";
        List<Emp> emps = getJdbcTemplate().query(sql, new RowMapper<Emp>() {
   
            @Override
            public Emp mapRow(ResultSet resultSet, int i) throws SQLException {
   
                Emp emp = new Emp();
                emp.setEname(resultSet.getString("ename"));
                emp.setEmpno(resultSet.getInt("empno"));
                emp.setJob(resultSet.getString("job"));
                emp.setHiredate(resultSet.getDate("hiredate"));
                emp.setSal(resultSet.getDouble("sal"));
                return emp;
            }
        },id);
        return emps.get(0);
    }
}

service层

public class EmpServiceImpl implements EmpService {
   
    
    @Override
    public Emp selectOneEmp(Integer id) throws SQLException {
   
        return empDao.selectOneEmp(id);
    }
    
    @Override
    public void sqlChange(Integer src,Integer target) {
   
        try {
   
            Emp srcEmp = empDao.selectOneEmp(src);
            srcEmp.setSal(srcEmp.getSal()-500);
            empDao.updateEmp(srcEmp);
            int i = 1/0;
            Emp targetEmp = empDao.selectOneEmp(</