how to getting the value from data base and store into the temp file

[kaleeswaran]

hi!
i am going to display list of 200 titles in my drop down box.it is from data base and show it over the jsp page.so each time i open the page then the drop down box value also loaded again and again.so what is my idea is it should be loaded once and have to select the particular thing that will be going to affect the sever...can i do that thing?...so my thinging is from the very first time the data will be loaded from the data base and i store into the some temp file and call it from the jsp page....
is it good idea?,,,
if so how can i do this?...give me solution
thank you,
kaleeswaran

[r035198x]

hi!
i am going to display list of 200 titles in my drop down box.it is from data base and show it over the jsp page.so each time i open the page then the drop down box value also loaded again and again.so what is my idea is it should be loaded once and have to select the particular thing that will be going to affect the sever...can i do that thing?...so my thinging is from the very first time the data will be loaded from the data base and i store into the some temp file and call it from the jsp page....
is it good idea?,,,
if so how can i do this?...give me solution
thank you,
kaleeswaran

How often is the titles list changed/updated in the database?

[kaleeswaran]

NO NO...
i am not going to change the title and all other thing.,..i am just displaying the list of things that's all...i want to make a copy of thing into my java file itself that's it....

[r035198x]

NO NO...
i am not going to change the title and all other thing.,..i am just displaying the list of things that's all...i want to make a copy of thing into my java file itself that's it....

So you don't need to be requerying the database everytime do you?
In fact you can even store all the titles in one field in the database(perhaps as a long string separated by commas). I suggest that you use a static method called say getTitles() which returns an ArrayList of the titles. The arraylist should be populated only once when the server is started (perhaps in a static initializer block of some utils class).