[Sandippatel.nvs]

Hi i am new to java, i am developing a POS application. I am using two database table (1)Stock- for maintaining the purchase and sell product transactions (2)Sold_product-- to keep the record of sold product.

Please help me, how can i subtract the number of sold item from the table of Stock

i.e Stock of coke bottle is 25, when manager sold 2 bottles out of them then the stock of coke deduced to 25-2=23 dynamically.

[CasiOo]

It depends on how you have made your database table.

You could use an UPDATE PreparedStatement, and update the number of coke bottles in your database if that's how you have made it.

[pbl]

first select the row that contains your part number from your inventory database
subtract 1 from the quantity column
update that row with the new quantity

[Sandippatel.nvs]

pbl, on 21 July 2011 - 10:04 PM, said:

first select the row that contains your part number from your inventory database
subtract 1 from the quantity column
update that row with the new quantity

Thank you, sir
But how can i use select statement in java

[macosxnerd101]

Take a look into JDBC, specifically the PreparedStatement class which was mentioned above.