Delete Records form Database

[Sander Silva]

Hi all!

I need to delete all records form my (MS Access) database
when I give a particular name (String) of a record.
When I click the button all records related to particular name should be deleted.
There's something wrong in my code. please help

public void DeleteSin(String Sinhala) {      
    try {      
        String sql = "delete from main where Sinhala = ? ";  
        PreparedStatement ps2 = DBConn.prepareStatement(sql);  
        ps2.setString(1,Sinhala);  
        ps2.executeUpdate();  
    }catch (Exception e) {      
        System.out.println("Error: " + e);      
    }finally {  
    }      
} 

    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                         

        String Sinhala = String.getText(jTextField2.getText());
        
        DeleteCode de = new DeleteCode();
        de.openDb();

        de.DeleteSin (Sinhala);
        
        de.closeDb();
    }         

please help,

[Zandis Murāns]

So what message comes with exception?

[Sander Silva]

Thank you for quick reply,

here's the error

cannot find symbol
symbol: method getText(java.lang.String)
location: class java.lang.String

[Paul Clapham]

Well, it's true. The String class doesn't have a static getText() method.

However I have no idea what you meant to use that nonexistent getText() method for, so I can't make any suggestions about what you should replace it by. Could you explain what it was supposed to do?

[Jesper de Jong]

This line is wrong:

String Sinhala = String.getText(jTextField2.getText());

You are trying to call the method getText on the String class. But class String does not have such a method. You probably meant this:

String Sinhala = jTextField2.getText();