Java + SQL Server Database - Console App basics - Part 02
In this 2nd video in the series, I show you how to connect a basic Java Console Application to an SQL Server Database and execute queries to retrieve an 2D array / table of data from the database. I provide a basic Java template as a starting point, and I write the Java code to fill in the blanks and query the database, and explain what I am doing and why at every step.
Software used in this video:
Java SDK v1.7 or v1.8
TextPad, NotePad, NotePad+
SQL Server 2012 or later
Table of Contents:
00:05 Review of Part 01
02:07 Develop getNumberOfRowsInResultSet () Java code
06:13 Walkthrough of basics / starting Java code
09:35 Pre-emptive Compile and Run to make sure all OK
10:32 Develop getObjectArray2DFromSQLDatabase () Java code
25:11 Compile and run the code and review the results
27:15 Review all code for Parts 01 and 02, discuss code re-use, ORMs (Object Relationship Managers), etc
32:34 Ending
Java + SQL Server Database - Console App basics videos:
Part 01: • Java + SQL Server Database - Console ...
Part 02: • Java + SQL Server Database - Console ...
My Github where you can find the source code:
https://github.com/MooseValley/Databa...
My Java Software Development YouTube channel:
http://tinyurl.com/MikesJavaVideos
My web page:
Moose's Software Valley - Established July, 1996.
https://rebrand.ly/MoosesSoftware