$dbh = DBI->connect();

$dbh->do();
$sth = $dbh->prepare();
$sth->execute();
# And other methods for dealing with your data

$dbh->commit() or $dbh->rollback();

$dbh->disconnect();