hi friend,

MySQL contains no form or reporting tools. To write and represent a report using MySQL and Java, you must have to extract the data from the database and then you have to write java code for representing the report. You can read data from the database and can write it into the excel file.

You may go through the link to know how to read data from database and write it into the excel file.

http://www.roseindia.net/tutorial/java/poi/insertIntoExcelFileData.html

To assign database rows values in an array variables, you write your code like below

String sql = "SELECT * FROM register ";
    ps = con.prepareStatement(sql);
    ResultSet rs = ps.executeQuery();   
    rs.last();
    int numberOfRows = rs.getRow(); 
    int arr [] = new int [numberOfRows]; 
    rs.beforeFirst();
    for (int i = 0; i < arr.length; i++)
    {
    while(numberOfRows > 0 && rs.next())
    {
        arr[i] = rs.getInt("id");
        out.println("id = "+arr[i]);        
    }
    }

Thanks.