java代码开启事务

同时操作多条sql语句向数据库内添加数据的代码开启事务例子

@Autowired
private PlatformTransactionManager ptm;

public string add(){
	DefaultTransactionDefinition def = new DefaultTransactionDefinition();
	def.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED);
	TransactionStatus transaction = ptm.getTransaction(def);
	try {
		sql语句1
		sql语句2
		sql语句3
		sql语句...
	} catch (Exception e) {
		ptm.rollback(transaction);
	    e.printStackTrace();
	    return "no";
	}
	ptm.commit(transaction);
	return "ok";
}