Update Database

[Sander Silva]

Hi All!

I'm trying to create an Update Gui for my Access database.
I create a insert GUi successfull, but I failed to convert it for Updating.
my updating code is full of errors, so i decided to post my Select
code, it is properly working. Please help me to create and Updating GUI.
in UPDATE statement WHERE clause should be equal to SVID

should be something like this

UPDATE Main
SET Family=(Family)
SET Genus=(Genus)
SET Species=(Species)
WHERE SVID=(SVID);

Updated values should pass from UpdateGui.java file.

UpdateGui.java

public class UpdateGui extends javax.swing.JFrame {

    public UpdateGui() {
        initComponents();
    }

        int SVID = Integer.parseInt(jTextField1.getText());
        String Family = jTextField2.getText();
        String Genus = jTextField3.getText();
        String Species = jTextField4.getText();

        UpdateCode d = new UpdateCode();
        d.openDb();
        d.UpdateCode(SVID, Family, Genus, Species);
}

UpdateCode.java (Here is my Select query, please help to use it for Updating)

public void UpdateCode(int SVID,String Family, String Genus, String Species) {  
    try {  
        s = DBConn.createStatement();  
        s.execute("insert into Main (SVID,Family,Genus,Species)"
                + "values ("+SVID+","
                + "'"+Family+"','"+Genus+"','"+Species+"')");  
    }  
    catch (Exception e) {  
        System.out.println("Error: " + e);  
    }  
}  

Please kindly help me, I'm new to Java and SQL.

[Fatih Keles]

Here is what you need.

JDBC Tutorial

[Sander Silva]

Thank you very much!

Please can you give me a little help on the Query statement
What's wrong with this one,

public void UpdateCode(int SVID,String Family, String Genus, String Species) {    
    try {    
        s = DBConn.createStatement();    
        s.execute("Update Main (SVID,Family,Genus,Species)"  
                + "values (''"+Family+"','"+Genus+"','"+Species+"') Where SVID='"+SVID+"'");    
    }    
    catch (Exception e) {    
        System.out.println("Error: " + e);    
    }    
} 

[Jan Cumps]

(''

two single quotes?

While you are reading the tutorial, have a look at PreparedStatement. It would resolve errors like this.

[Fatih Keles]

Your update query has to be in this format.

update my_table set col1 = ?, col2 = ?, col3 = ? where col4 = ?

[Paul Sturrock]

...if you are using a PreparedStatement.

[Jan Cumps]

And you have 4 columns, but provide values to only the last three.