my dog learned polymorphism*
The moose likes JDBC and the fly likes data persistence -- help with some logic Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "data persistence -- help with some logic" Watch "data persistence -- help with some logic" New topic

data persistence -- help with some logic

jite eghagha
Ranch Hand

Joined: Oct 06, 2006
Posts: 127
Hi, i attached a picture of my table.

You'll notice, that on insert or update, a row can have a datetime value or not.

A player (player_id) earns $1 per second, so long as that row contains a datetime value.

If a row that once contained a datetime vaule is updated, or if that row is deleted, so that it no longer contains a datetime value, how do i ensure that the players total earning are not lost.

further more, a player may insert a new row at any time that could add more $ per second to the total earnings.

I know i need a second table for the total earnings, but how should i go about regularly updating the total earnings.

I'd appreciate any thoughts.

[Download bd_pic.bmp] Download

I agree. Here's the link:
subject: data persistence -- help with some logic
Similar Threads
Long waiting for connect from pool
oracle sequence id
Please help with the 3 Hardest Javascript problems in the world
How di i insert multiple selectOneMenu in one html page?
How do I get auto-generated key by DB2