Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

how to update data of a field in one table from other table using jsp or java?

 
Rd Dari
Ranch Hand
Posts: 212
Java Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi all,

I am making a project and in this project my requirement is that I fill quantity in one dynamic table and using same quantity in other dynamic table. When I fill quantity in second table then how minus last table quantity automatic by coding in java or jsp.

please help me giving some solution............

Thanks in advanced!!!.............
 
Vijitha Kumara
Bartender
Posts: 3913
9
Chrome Fedora Hibernate
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am making a project and in this project my requirement is that I fill quantity in one dynamic table and using same quantity in other dynamic table

What kind of table are you talking about here (HTML, any third party library etc..)?
When I fill quantity in second table then how minus last table quantity automatic by coding in java or jsp.

What you mean by this. Where you have these table(s), in a JSP?

 
sourabh girdhar
Ranch Hand
Posts: 71
Java Spring Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Are you using some custom tags like display tag etc for tables in jsp .

or

are you using javascript tables like jquery/ Yahoo UI.

It can be done easily, once you clear about how you are clearing tables.

Thanks
Sourabh
 
Rd Dari
Ranch Hand
Posts: 212
Java Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi I am using these code and tablesssssss.....
and jsp page for insertion and updation these are so lenthy so







I am using these tables......








 
sourabh girdhar
Ranch Hand
Posts: 71
Java Spring Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Why are you posting subject as JSP and in JSP forum..
The first thing which comes to mind is UI components/rendering table in jsp page.

This is plain database/jdbc issue. Move it to that forum.

What is the issue?. anyways when you insert into database you have all values, whats the problem in calculating while inserting.
Simply write a static method in another util class which provides you desired value and use that while inserting other object.

Anyways you can't insert into more than one table at one point of time, So you have to fire two queries. So use values in first for calculations and getting value for secodn query.
It can also be done on pure database side by writing triggers. But it will be more complex as plain java/jdbc.

Sourabh
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic