Path: csiph.com!x330-a1.tempe.blueboxinc.net!feeder1.hal-mli.net!news.glorb.com!news-out.readnews.com!news-xxxfer.readnews.com!news-out.news.tds.net!newsreading01.news.tds.net!86597e80!not-for-mail From: "Lew" Subject: Re: I want to display out Message-ID: X-Comment-To: comp.lang.java.gui Newsgroups: comp.lang.java.gui In-Reply-To: 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? Maybe, maybe not. Almost certainly, you will have many pages besides index.jsp. Instead of naming your page 'index.jsp', design screens with their own names. > should I use 'preparedStatement' [sic] rather than running the SQL query > each time I want to get latest data from the SQK database? You should use a PreparedStatement to run your SQL query each time you want the latest data. > 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? There is if you code one. Look up the "Model 2" (as Sun calls it) Model-View-Controller (MVC) architecture. -- Lew --- * Synchronet * The Whitehouse BBS --- whitehouse.hulds.com --- check it out free usenet! --- Synchronet 3.15a-Win32 NewsLink 1.92 Time Warp of the Future BBS - telnet://time.synchro.net:24