Share on Google+Share on Google+

JDBC Prepared Statement Update

The Tutorial illustrates a code that help you in understanding JDBC Prepared Statement Update.

JDBC Prepared Statement Update


The Update  Statement in SQL updates the existing records in a table. In JDBC the Prepared Statement Update is used to update the SQL statement, using where clause, that specify which records is updated.

Understand with Example

The Tutorial illustrates a code that help you in understanding JDBC Prepared Statement Update. The code include a class Jdbc Prepared Statement, this class include a main method ( ), Inside the main method we have a list of steps -

 Importing a package java.sql - This package provides you a network interface, that enables you to communicate between front end application -back end. Loading a driver by calling a class.forName ( ),that accept a driver class as argument.

  DriverManager.get Connection ( ) -The Driver Manager call a getConnection ( ) method, return you a connection object, built a connection between url and database.

 The connection object call a prepareStatement ( ),that is used to update the table stu using where clause, specify the name of record to be updated at runtime. The set String XXX return you a set value in the place of question mark holder. The executeQuery ( ) return you the record set from a updated table in the database.

  Finally the println print the updated table from the database in output. The catch block caught the exception in try block.

import java.sql.*;

public class JdbcPreparedstatementUpdate {

  public static void main(String args[]) {

  Connection con = null;
  PreparedStatement pst = null;
  ResultSet rs = null;

  String url = "jdbc:mysql://localhost:3306/";
  String db = "komal";
  String driver = "com.mysql.jdbc.Driver";
  String user = "root";
  String pass = "root";

  try {
  con = DriverManager.getConnection(url + db, user, pass);
  pst = con.prepareStatement("update stu set class=? where id =?");
  pst.setString(1, "11");
  pst.setString(2, "1");
  pst = con.prepareStatement("select * from stu");
  rs = pst.executeQuery();

  while ( {
  System.out.print(rs.getString(1) + "\t");
  System.out.print(rs.getString(2) + "\t ");

  } catch (Exception e) {


Id	Name	Class
1	komal	 11
2	santosh	 11
3	rakesh	 9
4	ajay	 11
5	bhanu	 10

Download code


Posted on: November 19, 2008 If you enjoyed this post then why not add us on Google+? Add us to your Circles

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.

Discuss: JDBC Prepared Statement Update   View All Comments

Post your Comment

Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
August 28, 2013

sir,if we want to update two or more attributes.