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

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

Re: I want to display out

Show all headers | 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