How to clear textfield after successfully inserting data to database

[victaino]

My program clears textfield even when data are not successfully inserted into the database. obviously my logic is wrong. i need help pls.

[Fubarable]

My program clears textfield even when data are not successfully inserted into the database. obviously my logic is wrong. i need help pls.

Yep your logic is wrong.

If you need more help, consider telling us more and showing code.

[victaino]

Am new to programming and java please consider helping me

   private boolean Update = false;

private void jButton16ActionPerformed(java.awt.event.ActionEvent evt) {                                          
        // TODO add your handling code here:
        // adding data to database
        // create connection and prepare statement
          
        try{ 
            
            connection = DriverManager.getConnection(DATABASE_URL);
            insertNewData = connection.prepareStatement("INSERT INTO Customer" +
               "(Name, Phone,Email, Address, Fax, Website, Remarks)" +
                "VALUES (?,?,?,?,?,?,?)");   
         
            // declare variables to store textfield data
            String t1,t2,t3,t4,t5,t6,t7;
            t1 = txtName.getText();
            t2 = txtPhone.getText();
            t3 = txtEmail.getText();
            t4 = txaAddress.getText();
            t5 = txtFax.getText();
            t6 = txtWebsite.getText();
            t7 = txaRemarks.getText();
        
        
         //add entries
        int result = 0;
        
       // set parameters, then execute insertNewData
        
        insertNewData.setString(1,t1);
        insertNewData.setString(2, t2);
        insertNewData.setString(3, t3);
        insertNewData.setString(4, t4);
        insertNewData.setString(5, t5);
        insertNewData.setString(6, t6);
        insertNewData.setString(7, t7);
        
        
        // insert the new data
        result = insertNewData.executeUpdate();
        
       
        }catch (Exception e){
            e.printStackTrace();
            JOptionPane.showMessageDialog(null, e.getMessage(), "Error", JOptionPane.ERROR_MESSAGE);
        
            try{
            connection.close();
            Update = true;
            }
            catch(SQLException sql){
            
            
        }
            
                
        lblUpdate.setText("Record Added");
        
        // reset text fields
        txtName.setText("");
        txtPhone.setText("");
        txtEmail.setText("");
        txaAddress.setText("");
        txtFax.setText("");
        txtWebsite.setText(""); 
        txaRemarks.setText("");
        txtFilter.setText("");
            
            // call method refresh
            Refresh();
        }
           
    }

[victaino]

Am new to programming and java please consider helping me

   private boolean Update = false;

private void jButton16ActionPerformed(java.awt.event.ActionEvent evt) {                                          
        // TODO add your handling code here:
        // adding data to database
        // create connection and prepare statement
          
        try{ 
            
            connection = DriverManager.getConnection(DATABASE_URL);
            insertNewData = connection.prepareStatement("INSERT INTO Customer" +
               "(Name, Phone,Email, Address, Fax, Website, Remarks)" +
                "VALUES (?,?,?,?,?,?,?)");   
         
            // declare variables to store textfield data
            String t1,t2,t3,t4,t5,t6,t7;
            t1 = txtName.getText();
            t2 = txtPhone.getText();
            t3 = txtEmail.getText();
            t4 = txaAddress.getText();
            t5 = txtFax.getText();
            t6 = txtWebsite.getText();
            t7 = txaRemarks.getText();
        
        
         //add entries
        int result = 0;
        
       // set parameters, then execute insertNewData
        
        insertNewData.setString(1,t1);
        insertNewData.setString(2, t2);
        insertNewData.setString(3, t3);
        insertNewData.setString(4, t4);
        insertNewData.setString(5, t5);
        insertNewData.setString(6, t6);
        insertNewData.setString(7, t7);
        
        
        // insert the new data
        result = insertNewData.executeUpdate();
        
       
        }catch (Exception e){
            e.printStackTrace();
            JOptionPane.showMessageDialog(null, e.getMessage(), "Error", JOptionPane.ERROR_MESSAGE);
        
            try{
            connection.close();
            Update = true;
            }
            catch(SQLException sql){
            
            
        }
            
                
        lblUpdate.setText("Record Added");
        
        // reset text fields
        txtName.setText("");
        txtPhone.setText("");
        txtEmail.setText("");
        txaAddress.setText("");
        txtFax.setText("");
        txtWebsite.setText(""); 
        txaRemarks.setText("");
        txtFilter.setText("");
            
            // call method refresh
            Refresh();
        }
           
    }

[Fubarable]

What happens if you move your block of code that calls xxxx.setText("") above the catch block and right after result = insertNewData.executeUpdate();? this way if an exception occurs, xxxx. setText("") code is never called.

Do you see how your question is absolutely impossible to answer without you giving us the information requested? Consider reading my link below on how to ask smart questions, so we don't have to ask you this in the future, and you'll be able to save us and yourself a lot of time.

[victaino]

Thank you so much. u are a life saver.

[Fubarable]

You're welcome!