Please help : handle database to jsp

[kalyana]

hi all.....
i want handle some data from database to jsp , but i don't know which the best way to handle it .for example the data are : date ,time and light condition(on/off) .The data gonna be big data cause by the time data will increase .how to get/access the date into JSP ? use hash table ,vector or directly ...
hope some one can show me ,how to do this...

[JosAH]

hi all.....
i want handle some data from database to jsp , but i don't know which the best way to handle it .for example the data are : date ,time and light condition(on/off) .The data gonna be big data cause by the time data will increase .how to get/access the date into JSP ? use hash table ,vector or directly ...
hope some one can show me ,how to do this...

Tip #1: never let a jsp handle database communication. Use another Java class for that and let a servlet populate a, say, List, with the results and pass that to your jsp so it can concentrate on generating the html code so your results look nice when it arrives at the client.

kind regards,

Jos

[kalyana]

thanks to Josah for your tips
in the java class ,is there must use hashtable /vector to get the data first ?and then show to client the data on hashtable .i mind there must have temp place to handle data or any others way...

[JosAH]

thanks to Josah for your tips
in the java class ,is there must use hashtable /vector to get the data first ?and then show to client the data on hashtable .i mind there must have temp place to handle data or any others way...

Yep, make that other class/object collect the database from the db and store in a temporary List or Vector or whatever suits you fine. Let the jsp just display that data from the List or whatever.

kind regards,

Jos

[Tolls]

Presumably each row of this data represents something, so create a class for that.
The database code will populate a List of these (that's the usual thing).
Your servelt will stick this list into the request, and then forward to your JSP.

All your JSP does is print it out.