MySQL with Java: A Practical Tutorial

Connect and Query MySQL Database

Write a Java program that connects to a MySQL database and retrieves all records from a table named 'products'. Print the product ID and name.

Expected output: Printed list of product IDs and names from the 'products' table.

Hint: Use JDBC DriverManager to connect and Statement to execute a SELECT query.

Use PreparedStatement for Parameterized Query

Modify the previous program to accept a product category as input and retrieve products only from that category using PreparedStatement.

Expected output: Printed list of products filtered by the specified category.

Hint: Use '?' placeholders in SQL and set parameters with setString().

JDBC (Java Database Connectivity) is an API that allows Java applications to connect and interact with databases like MySQL. It provides methods to execute SQL queries and retrieve results, making database operations seamless in Java.

By using PreparedStatement objects with parameterized queries instead of concatenating SQL strings, you can prevent SQL injection attacks.

Try-with-resources automatically closes JDBC resources like Connection, Statement, and ResultSet, ensuring no resource leaks occur.