Store DB field to File

Question

I have a String field in the DB (mySQL) and on click of a button on a JSP page I want to download the contents of that field to a file on the client machine.

The client can give a name or a default name I should be able to give.

My server is tomcat.

Answer 1

Basically :

1. Create Java class for stored object, make it serializable
2. Map DB table to your Java class (use JPA or Hibernate or raw JDBC)
3. Write object to File using ObjectOutputStream, you can ask for name, use for example JFileChooser or something similar

Answer 2

I would just link the JSP to a servlet that sets a content disposition header then just prints out the value of the DB field

response.setHeader("Content-disposition","attachment; filename=something.txt" );