Java on Azure SQL - How to use JDBC to perform CRUD on Azure SQL databases
Java on Azure SQL - How to use JDBC to perform CRUD on Azure SQL databases
Java can connect to most kinds of databases that can be found, and Azure SQL databases are no different. In this episode I’ll take you through how to use JDBC to connect to your Azure SQL databases found online. We’ll look at which jar file you’ll need to put in your project so that JDBC will work for CRUD on your database. I’ll demonstrate how to read data from an SQL query into a ResultSet, and how to perform an insert into a table and receive back the auto-generated ID created on an identity column, which you can then use to perform other operations without having to go back and look up that key.
I’ll be using Eclipse with JRE 16 and the matching JDBC driver downloaded from Microsoft.
Want to get access to premium content made just for you and have a chat with me? Find me on Patreon :
/ mackenziedataengineering
Demo of my BZ RDP Cloaker:
https://www.patreon.com/posts/how-to-...
Want to work with me 1:1? Contact me today and book your free 20 min consultation!
Contact form you can find at http://www.mackenziemackenzie.com/
Follow me on social media:
/ mackenziedataanalytics
/ seamacke
/ seamacke
/ seamacke
/ psmackenzie
Get Microsoft Office including Access:
https://click.linksynergy.com/fs-bin/...
Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try:
https://www.tubebuddy.com/seanmackenz...
For developers looking for a new role, check out:
https://www.toptal.com/qKaO2b/worlds-...
Want my team to do a project for you? Let's get to it!
https://system.billzone.com/smdeproje...
#Java #AzureSQL #SeanMackenzie
• Java on Azure SQL - How to use JDBC t...
