The code you mention is for Azure Synapse. If you want to use plain Azure SQL, your options are limited.

You can use JDBC, but there is no update functionality.

Or you can use the optimized spark connector, but that lacks DML support:

Executing custom SQL through the connector

The previous Azure SQL Connector for Spark provided the ability to execute custom SQL code like DML or DDL statements through the connector. This functionality is out-of-scope of this connector since it is based on the DataSource APIs. This functionality is readily provided by libraries like pyodbc or you can use the standard java sql interfaces as well.