420-ENU-MT – DEBUGGING PROGRAMS – Fall 2019 – MAD312

GENERAL COURSE DESCRIPTION
The student will be shown how to find avenues for solving problems. He or she will develop a logical approach. The student will be confronted with the problems most frequently found in the industry. He or she will be called on to make corrections to the buggy code. The student will see the problem solving habits used by industry professionals and will learn to manage bugs in projects of varying size.

Course Plan

Important dates

Project – December 7, 2019

Final Exam – December 14, 2019

Course 1

Exception Part 1

JSON: The Basics

JSON

catalog.json

JSON Libraries Information

Libraries

JSONLint

ReadFile.java

Java JSON Example 1

Java JSON Example 2

Java JSON Example 3

student.json

Java JSON Example 3

Course 2

Exception Part 2

FileWriter

JSON Parsing Example 2

Example 1

Student Json Example

Example 2 – Student JSON 

Student JSON file Result

Example 3 Array

Practice

Solution

Course 3

JAVA – SQL libraries

Java – SQL – Example 1

Java – SQL – Example 2

Java – SQL – Example 3

Database Connection:

Host : 144.217.163.57

User Name : hr

Password : inf5180

Course 4

Netbeans Refactoring Notes

Refactoring in Netbeans

https://github.com/INF2015-H16/refactoring1.git

https://github.com/INF2015-H16/refactoring2.git

Using Git Support in NetBeans IDE

Version control concepts and best practices by Michael Ernst

Database vs Tables

Database Connection:

Host : 144.217.163.57

User Name : sales

Password : anypw

Solution With Finally

Solution With Finally

Practice

Solution

Practice Solution

employeeList output

Solution – Java – Employee List – option 1

Solution – Java – Employee List – Option 2

Course 5

Example Web Service

Example AP-GP

Area of Plane Shapes JSON

JAVA call Area of Plane Shapes JSON