File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
Java Interview Guide
this week in the
JDBC and Relational Databases
data persistence -- help with some logic
Joined: Oct 06, 2006
Jan 27, 2010 00:59:27
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
, 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.
Description: my table
File size: 615 Kbytes
I agree. Here's the link:
subject: data persistence -- help with some logic
How do I get auto-generated key by DB2
oracle sequence id
Long waiting for connect from pool
How di i insert multiple selectOneMenu in one html page?
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015