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

Output of program:

After executing the program:

Database Table: movies