Robot Management API: Add, Delete, and Modify Robot Records

This Java Servlet class, annotated with @WebServlet("/welcome"), implements a RESTful API for managing robot records within a database. It utilizes PreparedStatement to ensure secure and parameterized SQL queries, preventing SQL injection vulnerabilities. The API handles three primary actions:

1. Adding a new robot:

   • Takes input parameters for robot name, weight, and size.
   • Constructs a SQL INSERT statement using PreparedStatement.
   • Sets the input parameters to the prepared statement.
   • Executes the statement, inserting the new robot record.
   • Redirects to the welcome.jsp page upon successful insertion.

2. Deleting an existing robot:

   • Accepts the ID of the robot to be deleted as an input parameter.
   • Constructs a SQL DELETE statement using PreparedStatement.
   • Sets the robot ID to the prepared statement.
   • Executes the statement, deleting the specified robot record.
   • Redirects to the welcome.jsp page upon successful deletion.

3. Modifying an existing robot:

   • Takes input parameters for the robot's new name, weight, and size, along with the robot ID.
   • Constructs a SQL UPDATE statement using PreparedStatement.
   • Sets the new robot information and the ID to the prepared statement.
   • Executes the statement, updating the specified robot record.
   • Redirects to the welcome.jsp page upon successful modification.

The code leverages a try-catch-finally block to handle potential SQLExceptions and ensure proper database connection closure. Each action utilizes PreparedStatement to execute parameterized SQL queries, enhancing security and maintainability of the code.