Magento2使用sql语句

$objectManager = \Magento\Framework\App\ObjectManager::getInstance();
$resource = $objectManager->get('Magento\Framework\App\ResourceConnection');
$connection = $resource->getConnection();

$sql = "select * from tablename";
$list = $connection->fetchAll($sql);

$sql = "delete from tablename";
$result = $connection->query($sql);

// pdo
$sql = "INSERT INTO `users`(‘username`) VALUES (:username);
$stmt = $connection->prepare($sql);
$stmt->bindValue(":username","fljj");
$stmt->execute();