I want to display output from 10 SQL queries in JSP page - what is my best structure?



I want to query SQL database tables to gather data on lab system and
services on an on-going basis, etc. I want to display all my gathered
data on single web page and have JSP started that can call SQL
statements.
But should I put all the SQL stuff in seperate JSP and reference that
from my index.jsp?
should I use 'preparedStatement' rather than running the SQL query
each time I want to get latest data from the SQK database?
is there a "refresh" button in JSP so that can reload the page (and
kick offf the SQL statements) and keep me up-to-date on the changes in
the database?
.