How to Update a Record from a database?

hie, i have a very simple question, i am a java beginner, i am able to add a record to a database from my java which i am using MS Access as my database, i am able to add a record by using this code...
public void add() { // Add New Guest to Database
      
       String a = super.getLastName();
       String b = super.getFirstName();
       String c = address.getAddress();
       String d = address.getCity();
       String e = address.getPostCode();
       String f = address.getState();
       String g = address.getCountry();
       String h = super.getPhone();
       String i = super.getFax();
       String j = super.getRemarks();

       openConnection();
        
        try
             {
                   Statement statement = connection.createStatement();
                               
                  String query = "INSERT INTO guest (guest_ID,lastname,firstname,address," +
                                       " city,postcode, state, country, phone," +
                                        " fax, remarks) VALUES ('" +
                                                a +"','" +
                                                b +"','" +
                                             c +"','" +
                                             d +"','" +
                                             e +"','" +
                                             f +"','" +
                                             g +"','" +
                                             h +"','" +
                                             i +"','" +
                                             j +"')";
                        
                  int result = statement.executeUpdate(query);
                  
                  if (result == 1) {
                         JOptionPane.showMessageDialog(null, "Insertion succesfull");
                   } else {
                         JOptionPane.showMessageDialog(null, "Insertion Not succesfull");
                   }
      
                   statement.close();
            }
         catch(SQLException sqlex) {
       
         }
       }


and now i want to retrieve back my record and i am searching by the guest_id, so when i want to update the cord, what should i write ?please give me some guide

it should be write as this
public void update() {

//the code
}
kennykoidAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

InNoCenT_Ch1ldCommented:
something like:

            String query = "UPDATE addresses SET " +
                   "firstname='" + fields.first.getText() +
                   "', lastname='" + fields.last.getText() +
                   "', address='" + fields.address.getText() +
                   "', city='" + fields.city.getText() +
                   "', stateorprovince='" +
                   fields.state.getText() +
                   "', postalcode='" + fields.zip.getText() +
                   "', country='" + fields.country.getText() +
                   "', emailaddress='" +
                   fields.email.getText() +
                   "', homephone='" + fields.home.getText() +
                   "', faxnumber='" + fields.fax.getText() +
                   "' WHERE id=" + fields.id.getText();
                   output.append( "\nSending query: " +
                   connection.nativeSQL( query ) + "\n" );

            int result = statement.executeUpdate( query );
           
            if ( result == 1 )
               output.append( "\nUpdate successful\n" );
InNoCenT_Ch1ldCommented:
that's an example for you.
you can do like this:

               String query = "UPDATE guest SET" +
                                     "lastname='" + b +"' ," +
                                     "firstname="' + c +"' ," +
                                     //..and so on +
                                     "' WHERE guest_ID="a;

               int result = statement.executeUpdate(query);
               if(result == 1)
                    //update successful...(your code here)
                                   

hope it helps ;)
-Child-

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
KarthikAnandanCommented:
Hi,
  First you have to search whether the given guest_id is present or not. Then only u can update a record.

      String a = super.getLastName();
      String b = super.getFirstName();
      String c = address.getAddress();
      String d = address.getCity();
      String e = address.getPostCode();
      String f = address.getState();
      String g = address.getCountry();
      String h = super.getPhone();
      String i = super.getFax();
      String j = super.getRemarks();


Now to Search for the given guest_id

the query will be
        String query =  "select 1 from guest where guest_ID = '"+a+"'

If this query returns 1. then the Guestid is present. Now you have to update the table. for this
the query will be
     
"UPDATE guest set firstname = '"+a+"', lastname = '"+b+"', address = '"+c+"',city='"+d+"',
                        stateorprovince='"+e+"', postalcode = '"+f+"',country = '"+g+"',
                        emailaddress = '"+h+"',homephone = '"+i+"', faxnumber = '"+j+"' WHERE
                         guest_id = a;

this query will update the table with the specified guest id.

Now, If the first query, that is checking for guest_id in the table, if this fails then that means that the record is not present. The guest id is not present. So we have to go for inserting a new Guest rather than updating. The insert query is the same as what you said.
If you have any doubt over this then reply plz..

Mayank SAssociate Director - Product EngineeringCommented:
>> First you have to search whether the given guest_id is present or not. Then only u can update a record.

He says:

>> i want to retrieve back my record and i am searching by the guest_id,

Anyway, kennykoid, is it simply the update part which is troubling you or something else? If you're being able to insert a row, then I don't see a problem with updating it - merely, the query will change in your add () code. Is it something else that you want to know?

Mayank.
InNoCenT_Ch1ldCommented:
KarthikAnandan>> hello, you're just repeating my comment...but more complete. so i will hate you for the rest of my life if i dont get the pts.. hehehee ;p (just kidding)

-Child-
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Java

From novice to tech pro — start learning today.