[JSP] Help with Design decision

From: Marcus Reiter (donotSPAMME_at_microsoft.com)
Date: 12/29/04 

Date: Wed, 29 Dec 2004 21:41:10 +0100

I have a list of data coming from the database that shows me
tests and wether or not people (showing their id) have signed up for them
already
or not yet.

Using plain JSP I need to create a checkbox for each of those values and if
that person
has already signed up for that test it needs to be checked, while it needs
to be unchecked if
the person has not yet signed up.

It also has should be possible to check / uncheck checkboxes and then to add
/ delete values from the database.

How would you design this?

For one person, I thought about an array that has the name of the test and
then in the next field wether or
not the person has signed up for this test or not.

Now in the jsp a new array will be created.

Would you compare both arrays and just update those values that have changed
or would you
just delete all entries of that person and recreate all entries?

What easier / better in performace / better design whise?

Any ideas?

Thanks,

Marcus

Relevant Pages

  • Re: Database suggestion
    ... ...will INSERT new entries and UPDATE existing entries in one swoop. ... in relation to the joint database. ... you can do the same thing with your current array in memory style using the same syntax: ...
    (comp.lang.php)
  • Re: [JSP] Help with Design decision
    ... > tests and wether or not people have signed up for them ... > / delete values from the database. ... public class TestPanel { ... > just delete all entries of that person and recreate all entries? ...
    (comp.lang.java.programmer)
  • Re: Inject SQL Statement in Rails
    ... @object will be referenced with an array of entries from database. ... okay so i put this statement in the model right? ...
    (comp.lang.ruby)
  • Re: A Question of design.
    ... checked against those in the database to confirm whether or not they ... database array of items. ... for the processing to cause a server timeout. ... There are just over 3600 entries at present. ...
    (comp.lang.php)
  • Re: KirbyBase
    ... creating objects from the database records was much easier. ... Hal, I don't know if you have had a chance to take a look at the beta yet, but I basically tried to implement a uniform way to specify one-to-one links, one-to-many links, and calculated fields in the ... I suppose it would in effect be embedding an array where all the ... My first couple of attempts at adding more complexity to KirbyBase did not honor this concept. ...
    (comp.lang.ruby)