Data needs to be gathered in XML file from the database (MySql) using JSP

on index.jsp page, where the user will be able to search, with search buttons and search text box or drop down box with search button,,, to display all data regarding particular id from the database table.

Data needs to be gathered in XML file from the database (MySql) using appropriate JSP/Java Bean functions before sending back to the client appropriately transformed by pre-written xsl files.

using following database

create database music; use music;

CREATE TABLE AlbumCatalogue( id VARCHAR(10) NOT NULL, Band VARCHAR(60) NOT NULL, AlbumTitle VARCHAR(60) NOT NULL, Year VARCHAR(4) NOT NULL, ChartPosition VARCHAR(3) NOT NULL, Price VARCHAR(6) NOT NULL, Availability VARCHAR(4) NOT NULL);