Dynamically connecting data sources and transaction rollback

** demand ：** Read data connection from database , Insert some data into a table in the connection , If one of the insertion fails , Then all data will be rolled back .
** Ideas ：** Because it is a dynamic configuration data source ,@Transactional Only applicable to the current database connection , And only support spring Built in database connection , therefore @Transactional Easy to fail and troublesome .
solve ： java.sql.DriverManager Provides getConnection() Method , adopt getConnection() Create connection Connection, take Connection Is set to false, Reuse Connection Of CreateStatement() Method generation Statement, function SQL sentence , call connection Of commit() Method submission , Use try catch Surround ,catch When an exception occurs, call connection Of rollback() Method rollback ,finally Closed in connection and Statement, complete .
code

Connection connection = null;
Statement statement = null;
try {
    
	connection = DriverManager.getConnection(url,username,password);// Create connection 
	connection .setAutoCommit=false;// Set not to submit automatically , Otherwise, only the wrong piece of data will be rolled back 
	statement = connection.createStatement();
    for () {
    // Loop execution SQL
        String sql = "";
        statement.executeUpdate(sql);// function sql sentence 
    }
    connection.commit();// Commit transaction 
    } catch (Exception e) {
    
       connection.rollback();// Transaction rollback , The current transactions under this connection will be rolled back 
       e.printStackTrace();
       return false;
    } finally {
    
      statement.close();
      connection.close();// Close the connection 
 }