4. 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

• 4.1 Databases and JDBC
  • 4.1.1 Getting things set up
  • 4.1.2 Connecting to the database
    • 4.1.2.1 Load the driver
    • 4.1.2.2 Create the connection
  • 4.1.3 Statements
  • 4.1.4 getXXX methods
  • 4.1.5 Updating the database
  • 4.1.6 PreparedStatements
  • 4.1.7 A real method
  
  
• 4.2 JUnit
  • 4.2.1 Is Testing Important?
  • 4.2.2 Mars Orbiter
  • 4.2.3 USS Yorktown
  • 4.2.4 Types of tests
  • 4.2.5 Unit Testing 101
    • 4.2.5.1 Definitions of unit testing
  • 4.2.6 Goals of unit testing?
  • 4.2.7 Unit Testing with JUnit
    • 4.2.7.1 How to create unit tests with JUnit
  • 4.2.8 A sample JUnit session
  • 4.2.9 Recap
  
  
• 4.3 Best practices
• 4.4 Refactoring
• 4.5 Final project

Up: java_oo Previous: 3.14 Survey of other Next: 4.1 Databases and JDBC   Contents