Re: What does everyone else do for graphically displaying data?
- From: mdR <mrafn@xxxxxxxxxxx>
- Date: Thu, 20 Dec 2007 06:12:47 -0800 (PST)
<snip>
I like to work with a PostgreSQL database hookup, and just build and tear down
tables in parallel with the application programming. NetBeans and Eclipse
both have active editor windows that know what to do with a database link.
From time to time I pop into a command window and use psql, the command-line
interpreter. (That also lets me experience concurrent access.)
When in an RDBMS, don't think like a Java programmer. Think like a database
person.
Architecturally, this separates the business logic from the data layer by
messages. "I need to know all the addresses for this company," your business
logic demands. The database serves up a set of rows, the DAO loads the
columsn into object fields, and Bob's your uncle.
<snip>
first off--thanks for such a concise reply, it helps...
i think it's easy enough to do as you say to simply display data, but
editing and updating the data is where i'm having problems--coming
from an environment where all the objects are data-aware and the
updating happens automatically behind the curtain. so given a set of
rows from a JOIN, populate text fields, then edit one of the details,
how to get the updated data back to the db? i've looked at some good
examples and it ~appears things are managed by sync'ing a primary key
in all the objects needed to display data. fire a change event in the
graphical objects, which lets the data object know to retrieve values
from the display and execute an update to the db. but what tables to
update? or do i simply update the rowset initially served up by the
join and send that back to the db and it is distributed automatically
to the appropriate joined tables? hmmm... i've got to check into
that... maybe that's part of knowing SQL well...
anyway, one good example i've traced worked with only one table and
even that got kind of complicated managing one key id between db
objects and various gui objects. i guess there was ~a lot~ happening
behind the curtain that i've got to learn ;) iyo-does it ever get
easy?
-mark
.
- Follow-Ups:
- References:
- What does everyone else do for graphically displaying data?
- From: mdR
- Re: What does everyone else do for graphically displaying data?
- From: RedGrittyBrick
- Re: What does everyone else do for graphically displaying data?
- From: mdR
- Re: What does everyone else do for graphically displaying data?
- From: Lew
- What does everyone else do for graphically displaying data?
- Prev by Date: Beginner question about JDO best practice
- Next by Date: Re: Beginner question about JDO best practice
- Previous by thread: Re: What does everyone else do for graphically displaying data?
- Next by thread: Re: What does everyone else do for graphically displaying data?
- Index(es):
Relevant Pages
|
