Day 4: Databases, Best Practices, and Final Project

Getting Started Setting Up a Database Establishing a Connection Setting Up Tables Retrieving Values from Result Sets Updating Tables Milestone: The Basics of JDBC Using Prepared Statements Using Joins Using Transactions Stored Procedures SQL Statements for Creating a Stored Procedure

• Databases and JDBC
  • Getting things set up
  • Connecting to the database
    • Load the driver
    • Create the connection
  • Statements
  • getXXX methods
  • Updating the database
  • PreparedStatements
  • A real method
• JUnit
  • Is Testing Important?
  • Mars Orbiter
  • USS Yorktown
  • Types of tests
  • Unit Testing 101
    • Definitions of unit testing
  • Goals of unit testing?
  • Unit Testing with JUnit
    • How to create unit tests with JUnit
  • A sample JUnit session
  • Recap
• Best practices
• Refactoring
• Final project