Solved

How to Update a Record from a database?

Posted on 2003-11-27
5
261 Views
Last Modified: 2010-03-31
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
}
0
Comment
Question by:kennykoid
  • 3
5 Comments
 
LVL 3

Expert Comment

by:InNoCenT_Ch1ld
Comment Utility
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" );
0
 
LVL 3

Accepted Solution

by:
InNoCenT_Ch1ld earned 20 total points
Comment Utility
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-
0
 

Expert Comment

by:KarthikAnandan
Comment Utility
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..

0
 
LVL 30

Expert Comment

by:mayankeagle
Comment Utility
>> 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.
0
 
LVL 3

Expert Comment

by:InNoCenT_Ch1ld
Comment Utility
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-
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

For customizing the look of your lightweight component and making it look lucid like it was made of glass. Or: how to make your component more Apple-ish ;) This tip assumes your component to be of rectangular shape and completely opaque. (COD…
Java had always been an easily readable and understandable language.  Some relatively recent changes in the language seem to be changing this pretty fast, and anyone that had not seen any Java code for the last 5 years will possibly have issues unde…
Viewers learn about the “for” loop and how it works in Java. By comparing it to the while loop learned before, viewers can make the transition easily. You will learn about the formatting of the for loop as we write a program that prints even numbers…
Viewers will learn about basic arrays, how to declare them, and how to use them. Introduction and definition: Declare an array and cover the syntax of declaring them: Initialize every index in the created array: Example/Features of a basic arr…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now