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: https://youtu.be/qoStery3oeE * Part 02: https://youtu.be/y-Dwjt2JTP4 My Github where you can find the source code: * https://github.com/MooseValley/Database-SQL-Server-Basics-for-Students My Java Software Development YouTube channel: * http://tinyurl.com/MikesJavaVideos My web page: * Moose's Software Valley - Established July, 1996. https://rebrand.ly/MoosesSoftware
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: https://youtu.be/qoStery3oeE * Part 02: https://youtu.be/y-Dwjt2JTP4 My Github where you can find the source code: * https://github.com/MooseValley/Database-SQL-Server-Basics-for-Students My Java Software Development YouTube channel: * http://tinyurl.com/MikesJavaVideos My web page: * Moose's Software Valley - Established July, 1996. https://rebrand.ly/MoosesSoftware