Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.java.gui > #3402

Re: I want to display out

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" <lew@THRWHITE.remove-dii-this>
Subject Re: I want to display out
Message-ID <a7-dnWHIJfeHqZrVnZ2dnUVZ_gOdnZ2d@comcast.com> (permalink)
X-Comment-To comp.lang.java.gui
Newsgroups comp.lang.java.gui
In-Reply-To <fff0fa6e-3ff1-4287-a64a-48f9f929ef07@26g2000hsk.googlegroups.com
References <fff0fa6e-3ff1-4287-a64a-48f9f929ef07@26g2000hsk.googlegroups.com
Content-Type text/plain; charset=IBM437
Content-Transfer-Encoding 8bit
X-Gateway time.synchro.net [Synchronet 3.15a-Win32 NewsLink 1.92]
Lines 34
Date Wed, 27 Apr 2011 15:44:40 GMT
NNTP-Posting-Host 96.60.20.240
X-Complaints-To news@tds.net
X-Trace newsreading01.news.tds.net 1303919080 96.60.20.240 (Wed, 27 Apr 2011 10:44:40 CDT)
NNTP-Posting-Date Wed, 27 Apr 2011 10:44:40 CDT
Organization TDS.net
Xref x330-a1.tempe.blueboxinc.net comp.lang.java.gui:3402

Show key headers only | View raw


  To: comp.lang.java.gui
terry433iid@yahoo.com wrote:
> 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

Back to comp.lang.java.gui | Previous | Next | Find similar | Unroll thread


Thread

Re: I want to display out "Lew" <lew@THRWHITE.remove-dii-this> - 2011-04-27 15:44 +0000

csiph-web