How can I retrieve the selected value from a drop-down list in a JSP page and use it to execute a MySQL query?

To retrieve the selected value from a drop-down list in a JSP page and use it to execute a MySQL query, you can follow these steps:

```html

```

In your JSP page (query.jsp), you can retrieve the selected value from the drop-down list using the following Java code:

```java

```

Make sure to replace 'your_database' and 'your_table' with your actual database name and table name. Also, ensure proper error handling and security measures are implemented to prevent SQL injection attacks.