Describes how to read and manage data from relational databases such as MySQL and SQL Server using the Java Database Connectivity (JDBC) API in applications programmed with Java.
Overview
Syllabus
Introduction
- Welcome
- What you should know before starting this course
- Using the exercise files
- Testing your Java development environment
- Importing a MySQL database
- Creating a database user in MySQL
- What is JDBC?
- Choosing a JDBC driver
- Connecting to a MySQL database server
- Connecting to a HyperSQL database file
- Executing a static SQL statement
- Connecting to multiple databases
- Handling JDBC exceptions
- Closing database resources in Java 7
- Looping through result sets
- Moving the cursor in scrollable result sets
- Limiting the number of fetched rows
- Filtering data with prepared statements
- Calling stored procedures
- Handling multiple values from stored procedures
- Using generic getter methods in Java SE 7
- Managing data entities with JavaBean classes
- Retrieving a single row as a JavaBean object
- Inserting rows with prepared statements
- Updating rows with prepared statements
- Deleting rows with prepared statements
- Managing data with updatable result sets
- Using a persistent database connection
- Committing and rolling back transactions
- Getting the DatabaseMetaData object
- Getting column and data type information
- Next steps
Taught by
David Gassner