Home Jdbc Jdbc-mysql Update Records using Prepared Statement

Related Tutorials


 
 

Share on Google+Share on Google+

Update Records using Prepared Statement

Advertisement
In this JDBC tutorial we are going to learn about the process of updating the records by using the PreparedStatement.

Update Records using Prepared Statement

     

The JDBC provides you the facility for updating the records. In this JDBC tutorial we are going to learn about the process of updating the records by using the PreparedStatement.  Here arise a question, what is updating the records. In the case of relational database management system (RDBMS) we use the SQL "UPDATE" statement for updating the data in one or more records. See brief description below: 

Description of program:

In this program we are going to establish the connection with MySQL database by using the JDBC driver. When the connection has been established then we pass a SQL statement with some conditions in it for selecting the specific records and pass this query in the prepareStatement method. This method returns an object of PreparedStatement. If the query gets executed then give a message "Updating Successfully!" otherwise it displays "SQL statement is not executed!".

Here is the code of program:

import java.sql.*;

public class UpdatesRecords{
  public static void main(String[] args) {
  System.out.println("Updates Records Example through Prepared Statement!");
  Connection con = null;
  try{
  Class.forName("com.mysql.jdbc.Driver");
  con = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/jdbctutorial","root","root");
  try{
  String sql = "UPDATE movies SET title = ? WHERE year_made = ?";
  PreparedStatement prest = con.prepareStatement(sql);
  prest.setString(1,"Sanam We wafafa");
  prest.setInt(2,2005);
  prest.executeUpdate();
  System.out.println("Updating Successfully!");
  con.close();
  }
  catch (SQLException s){
  System.out.println("SQL statement is not executed!");
  }
  }
  catch (Exception e){
  e.printStackTrace();
  }
  }
} 

Download this example.

Database Table: movies

title year_made
alam ara 1945
Karan 2005
Karan 2005
Bagal bali 2002
Raja Hindistani 1998
Diwar 1980
Nadia ke par 1975

Output of program:

C:\vinod\jdbc\jdbc\PreparedStatement>javac UpdatesRecords.java

C:\vinod\jdbc\jdbc\PreparedStatement>java UpdatesRecords
Updates Records Example through Prepared Statement!
Updating Successfully!

After executing the program:

Database Table: movies

title year_made
alam ara 1945
Sanam We wafafa 2005
Sanam We wafafa 2005
Bagal bali 2002
Raja Hindistani 1998
Diwar 1980
Nadia ke par 1975
Advertisements

If you enjoyed this post then why not add us on Google+? Add us to your Circles



Liked it!  Share this Tutorial


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: April 13, 2007

Related Tutorials

Discuss: Update Records using Prepared Statement   View All Comments

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:3
Rock Martin
May 5, 2012
dynamic update query

can we use strings parameters from outside instead of hardcoding the setString parameters?
Amit
June 23, 2012
query

what would be the syntax of "UPDATE <table> SET <column1> = ? WHERE <column5> = ?" if i have multiple columns to update??
snehal jain
July 26, 2013
update

m getting error as: syntax error at or near where how can i resolve it? plz reply asap...
DMCA.com