How to update multiple columns in mysql

Question

I am creating a GUI bank project in netbeans that uses mysql database. I set the account numbers as primary key and I want the user to deposit money only if they put in their correct account number. When I tried to do this, only one row works, how do I make so that whenever the account number is entered and the amount for the deposit is entered, it will update the balance column. Here is my query statement:

String Query = "UPDATE ACCOUNTINFO SET BALANCE = '"+txtAmount.getText()+"'
                WHERE ACCOUNTNUMBER = '"+txtAccountNum.getText()+"'";

The error I am getting is that only the first account number (which is the first column in the database) gets deposited. Then it doesn't deposit anything for any other account number except for the first one. — Nasim Ahmed
– Nasim Ahmed, Commented May 7, 2016 at 22:34
I figured it out. I just created a new window for each deposit because it only updates the database one at a time. — Nasim Ahmed
– Nasim Ahmed, Commented May 7, 2016 at 22:45

rawdog · Accepted Answer · 2016-05-05 16:53:29Z

1

Updating multiple columns works like this:

UPDATE table SET colum1 = value1, column2 = value2 WHERE key_column = compare_value;

answered May 5, 2016 at 16:53

rawdog

7309 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Alex Martian Over a year ago

man, looks like you have a tipo in your profile I have startet, maybe started ?. I will delete this comment later. There is no way to send PM except from QAs...

Abhishek Panjabi · Accepted Answer · 2016-05-05 12:51:18Z

0

You can make menu driven program. Firstly you print all the functions that is available like show balance, withdraw money,Deposite money,etc .Give numbers to choices and then take input number and then use switch case and match the choice and ask inputs accordingly like you want only acc number or acc number and amount. And after operation is complete you can ask user if he want continue ? Check if he types yes or no in do..while loops condition if he pressed yes then show menu again.

answered May 5, 2016 at 12:51

Abhishek Panjabi

4395 silver badges23 bronze badges

2 Comments

Nasim Ahmed Over a year ago

I created a homepage GUI where the user selects deposit, withdraw, balance, etc. So the above part is for the deposit function.

Abhishek Panjabi Over a year ago

OK . Then you simply use UPDATE table_name SET col1= value, col2=value WHERE condition;

DD77 · Accepted Answer · 2016-05-05 13:08:28Z

0

Remove + " which you have written before WHERE clause in your query. and its UPDATE not UPDATA Please correct it.

answered May 5, 2016 at 13:08

DD77

8162 gold badges9 silver badges27 bronze badges

Comments

Gangaraju · Accepted Answer · 2016-05-05 17:25:32Z

0

String Query = "UPDATE ACCOUNTINFO SET 
    BALANCE = '"+txtAmount.getText()+"',
    WITHDRAWL_LIMIT = '"+txtLimit.getText()+"'
  WHERE ACCOUNTNUMBER = '"+txtAccountNum.getText()+"'";

answered May 5, 2016 at 17:25

Gangaraju

4,57211 gold badges48 silver badges81 bronze badges

1 Comment

Nasim Ahmed Over a year ago

That is what I did except for the withdrawal limit. It only updates the first account number entered. If you enter another account number for the database, it does not deposit that amount the user enters for the account numbers.

Collectives™ on Stack Overflow

How to update multiple columns in mysql

4 Answers 4

1 Comment

2 Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related