Java JDBC with Oracle: Build a CRUD Application

Learn how Java applications use JDBC to interact with relational databases via SQL queries, acting as a database-agnostic API between the application and an RDBMS such as Oracle.

Explore four types of JDBC drivers—type 1 (odbc bridge), type 2 (native API), type 3 (network protocol), and type 4 (thin driver)—and how they translate JDBC calls to database protocols.

Explore the core JDBC classes and interfaces, including driver manager, connection, statement, prepared statement, callable statement, resultset, and resultset metadata to execute and manage SQL queries.

Load and register the Oracle JDBC driver, then obtain a connection with DriverManager.getConnection. Create a statement, execute a query, process the result set, and close the connection.

Establish a jdbc connection to an Oracle database by loading the Oracle driver. Create the connection with DriverManager using localhost:1521, service sc, and system user; import Oracle driver jar.

Learn to read data from an Oracle database using Java JDBC. Connect, create a statement, execute a select, and iterate a ResultSet to print ID and NAME.

Create an employee table with id, name, and salary using a statement in Java JDBC with Oracle, covering driver loading, connection, statement creation, and execute update.

Insert records into the employee table using the insert statement, handle string values with single quotes, specify columns when needed, and verify results with select and order by.

Update an employee's salary in a Java JDBC with Oracle using a statement, verify the affected rows, and observe the statement's return value indicating how many rows were updated.

Execute delete operations in Java JDBC with Oracle using a statement to remove specific rows or clear the employees table, and verify the number of affected rows.

Compare statement and prepared statement in Java JDBC with Oracle, showing how statements recompile with hardcoded values, while prepared statements bind runtime parameters and reuse a compiled plan for efficiency.

Insert records into the employee table using prepared statements with placeholders for id, name, and salary. Bind values with setInt and setString, then executeUpdate to return rows affected.

Learn to update records using prepared statements in Java JDBC with Oracle by binding parameters to the question marks, executing the update, and verifying the number of affected rows.

Learn to delete records with prepared statements in Java JDBC with Oracle. Build a prepared statement, bind parameters, execute update, and verify deletions on the employee table.

Use a Java callable statement to execute an Oracle stored procedure that inserts an employee with three input parameters and verify the result.

Call an Oracle stored procedure from Java using a callable statement, set the input parameter, register two output parameters for name and salary, execute, and read the results.

Explore how resultset metadata reveals data about columns in a resultset, including column count, column name, and data type, and verify auto increment status using JDBC.

Create a database metadata object and display driver name and version, database product name, username, max columns in a table, and whether stored procedures are supported by the database.

Store an image in a database table by using a file input stream and a prepared statement to insert an image name and blob content into the image test table.

Retrieve an image blob from the image test table using a statement and getBlob, then write the bytes to a local file with a file output stream to verify storage.

Store a text file in an Oracle database using Java jdbc by reading the file and inserting it into a clob column with a prepared statement.

Retrieve a file stored as a blob using JDBC by querying the database, reading the character stream with a buffered reader, and printing every line until end of file.

Introduce a console-based product management crud app built in Java JDBC, outlining a modular project structure (app, dao, db, pojo) and six user options.

Create a product POJO with id, name, and price fields, and a DBUtil class that provides a static getConnection and a closeConnection method for database operations.

Create a data access object (dao) to interact with the database by implementing get all products and get product by id, using the List interface and DB utility.

Create DAO methods for adding, updating, and deleting products using prepared statements and a JDBC connection. Check a status value to confirm successful insertions or updates.

Develop the main application logic for a product management CRUD app using a console menu, buffered input, and a DAO to handle view, add, update, delete, and search.

Develop and display a product list, then implement add, update, delete, and search operations by reading user input, creating product objects, and interfacing with the database.

Run the Java JDBC application to manage products: view initial entries, add, update, delete, and search a product, then exit.

Conclude the course by practicing concepts, trying more complex queries, and integrating the JDBC CRUD project with UI tech like Swing or JavaFX using a UI button.