Thread: Changing update query in SQL

Basically in this image when I enter the account number the balance will be found, that part is okay. Now when it comes to deposit, I want it to take the existing Account balance and update the table with the deposit amount entered. How do I change the update query according to that?

Here's my code for the find button

private void btnFindActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
try
{
PreparedStatement stmt=con.prepareStatement("select * from Customer_Details where AccountNumber=?");
stmt.setString(1,txtMAccNo.getText());


ResultSet rs=stmt.executeQuery();

if (rs.next())
{

txtMAccBalance.setText(rs.getString("AccountBalanc e"));
JOptionPane.showMessageDialog(null, "Customer Found");
}

else
{
JOptionPane.showMessageDialog(null,"Customer not Found.","CustomerDetails",JOptionPane.ERROR_MESSAG E);
}



}

catch(Exception ex)
{
JOptionPane.showMessageDialog(null,"Error encountered while entering data in the database: " +ex, "CustomerDetails",JOptionPane.ERROR_MESSAGE);
}
}

Originally Posted by John Joe

where is your update query?

lol it isn't bro, this is my query. I know I have to change something in the update bracket but I just dont know what. I also have to include the deposit variable somewhere.




private void btnDepositActionPerformed(java.awt.event.ActionEve nt evt) {
// TODO add your handling code here:
try
{
PreparedStatement statUpdate=con.prepareStatement
("update Customer_Details set AccountBalance=? where AccountNumber=?");



statUpdate.setString(1,txtMAccBalance.getText());
statUpdate.setString(2,txtMAccNo.getText());

// call executeUpdate to execute our sql update statement
int rowsAffected=statUpdate.executeUpdate();
if(rowsAffected>0)
{
JOptionPane.showMessageDialog(null,"Data Updated..");
}
}
catch(Exception ex)
{
JOptionPane.showMessageDialog(null,"Error encountered while updating data in the database: " +ex, "ManageTransaction",JOptionPane.ERROR_MESSAGE) ;
}