i want the insert statement in jdbc for the following
name gs al ts
madhu 1000 500
sud 2000 600
now i want to access gs and al from the database table by using
select statement
now i want to add gs and al like
totalsalary=gs+al;
now i want to insert this totalsalary in ts of the database table
please send me the statement

please do your own work. And, even if people are willing to do your (home)work for you (and not despise you for so shamelessly asking it), you would find them at an SQL forum (which is what this question is about) and not a Java forum.

And if you are to post this in an sql forum try to make it a little bit more readable, because I didn't understand much about what you are trying to do

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.