事务传播机制实例
方法运行在test中
下边是建表SQL
DROP TABLE IF EXISTS tmp_employee;
CREATE TABLE tmp_employee (
id int(10) NOT NULL AUTO_INCREMENT,
dept_id int(10) DEFAULT NULL,
name varchar(255) DEFAULT NULL,
address varchar(255) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS tmp_department;
CREATE TABLE tmp_department (
id int(10) NOT NULL AUTO_INCREMENT,
name varchar(255) NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;