如何在micronaut中使方法成为事务性的

implementation "io.micronaut:micronaut-data-tx"

<dependency>
    <groupId>io.micronaut</groupId>
    <artifactId>micronaut-data-tx</artifactId>
    <scope>compile</scope>
</dependency>

import io.micronaut.transaction.annotation.Transactional;

@Transactional
public void performTransactionalOperation() {
    // 在这里执行需要进行事务管理的操作
}

datasources:
  default:
    url: jdbc:mysql://localhost:3306/mydb
    driverClassName: com.mysql.jdbc.Driver
    username: myuser
    password: mypassword
    transactionIsolation: TRANSACTION_READ_COMMITTED
    schema-generate: CREATE_DROP

import io.micronaut.transaction.SynchronousTransactionManager;
import javax.inject.Inject;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

@Transactional
public void performTransactionalDatabaseOperation() throws SQLException {
    Connection connection = transactionManager.getConnection().orElseThrow(SQLException::new);
    try (PreparedStatement statement = connection.prepareStatement("INSERT INTO my_table (column1, column2) VALUES (?, ?)")) {
        statement.setString(1, "value1");
        statement.setString(2, "value2");
        statement.executeUpdate();
    }
}