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