File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Calculating the enteries of the database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Calculating the enteries of the database" Watch "Calculating the enteries of the database" New topic

Calculating the enteries of the database

jagruti patil

Joined: May 20, 2001
Posts: 7
I have made a project on Inventory Control System.
I have given two options ie an inward listing & issued listing.Whenever I make an entry in the inward list it gets added in the database but incase of similar entry the change in the quantity of the item should be at the same place where the earlier entry was made.
Similarly, when I issue or take any item from the database there should be deduction of the quantity in the database.Also if the same item is being taken out the change should be at the earlier place only.
Can someone please solve this problem for me? Thanks.

Jim Yingst

Joined: Jan 30, 2000
Posts: 18671
This forum is intended for questions and comments about this web site, It is not for questions about the Java language - that's what all the other forums are for. I'm moving this to the JDBC forum.

"I'm not back." - Bill Harding, Twister
Daniel Dunleavy
Ranch Hand

Joined: Mar 13, 2001
Posts: 276
I am having a little trouble understanding your post.
My guess at what your looking for is a method for keeping track of how many items you have in inventory. You need to pass the item number, qty change ( ex -2 or +2) and lock it during this process.
Raja Shekhar
Ranch Hand

Joined: Apr 02, 2001
Posts: 49
hi J
Hey...there is more of u r Functionality Stuff rathere than
u r Java Problem...
Just Explain u r Problem(Functionality) with java...
then I (. else any buudy)
will Help u
Consider Paul's rocket mass heater.
subject: Calculating the enteries of the database
jQuery in Action, 3rd edition