Java sql update row in database

Question

I have got adding a member to the database working. I am trying to work out how to update a row in the table using the same system of passing in the values just not adding a new row, just altering the row using the passed in username.

Here is my method for inserting a new member:

 public static void insertMember(String username,String firstName)
{

    try 
     {  
        Class.forName("com.mysql.jdbc.Driver");
        Connection connection = DriverManager.getConnection(url, username, password);

        PreparedStatement st = connection.prepareStatement("INSERT INTO Members VALUES (?,?)");
        st.setString(1, username);
        st.setString(2, firstName);
        st.executeUpdate();    
     } 

     catch (SQLException e) 
     {
        System.out.println("SQL Exception: "+ e.toString());
     } 

     catch (ClassNotFoundException cE) 
     {
        System.out.println("Class Not Found Exception: "+ cE.toString());
     }


}

INSERT statement will insert rows in a table, while UPDATE statement will update a row (or a group of rows) in a table. — Luiggi Mendoza
– Luiggi Mendoza, Commented Feb 4, 2014 at 5:20

MadProgrammer · Accepted Answer · 2014-02-04 05:20:24Z

3

You need to use an UPDATE command instead of INSERT command.

Take a look at SQL UPDATE statement.

You will need to provide some means by which you can identify the row which needs to be updated, but this is dependent upon the structure of your table

answered Feb 4, 2014 at 5:20

MadProgrammer

348k22 gold badges243 silver badges379 bronze badges

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

Comments

SpringLearner · Accepted Answer · 2014-02-04 05:19:04Z

2

I have got adding a member to the database working. I am trying to work out how to update a row in the table using the same system of passing in the values just not adding a new row, just altering the row using the passed in username.

you need Update command

like

UPDATE Members set username='somename',firstname='firstname' where condition

answered Feb 4, 2014 at 5:19

SpringLearner

13.9k20 gold badges82 silver badges117 bronze badges

Comments

Dark Knight · Accepted Answer · 2014-02-04 05:19:50Z

0

Need to change SQL command instead of INSERT , uses UPDATE. Below code will update username for matching firstname provided in where clause.

          PreparedStatement st = connection.prepareStatement("UPDATE Members set username=? where firstName=?)");
         st.setString(1, username);
         st.setString(2, firstName);
         int updateStatus=st.executeUpdate();

answered Feb 4, 2014 at 5:19

Dark Knight

8,3674 gold badges41 silver badges58 bronze badges

2 Comments

Luiggi Mendoza Over a year ago

I guess you should update the first name of the user based on the username, not backwards :).

MadProgrammer Over a year ago

Wouldn't that require a where statement so you knew which row was to be updated?

Collectives™ on Stack Overflow

Java sql update row in database

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related