JDBC GS Update with execute

How do we perform SQL Update with the execute() method contained in a JDBC-Statement object.

  1. First you need to Create a Database Connection.
  2. Then create a regular Statement object with the method, createStatement().
  3. The next step is to write your SQL Update statement and give this string as a parameter to the method:
    Method in Statement interface Description
    boolean execute(String sql) Executes the given SQL statement, and returns true if the first result is a ResultSet object; false if it is an update count or there are no results.
    Example of using this method to Update a database table:
    import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.ResultSet;
    import java.sql.SQLException;
    import java.sql.Statement;
    import java.util.logging.Level;
    import java.util.logging.Logger;
    public class SQLUpdate {
     public static void main(String[] args) {
      Connection conn = null;
      Statement stmt = null;
      try {
       // Register a driver for the MySQL database
       // Create a url for accessing the MySQL
       // database CarDB
       String url = "jdbc:mysql://localhost:3306/CarDB";
       // user and password to access the database
       String username = "root";
       String password = "root";
       // User the DriverManager to get a Connection to the database
       conn = DriverManager.getConnection(url, username, password);
       // Create a  Statement
       // that is non-updateable, non-scrollable conserning ResultSet
       stmt = conn.createStatement();
       // Calculate NewPrice for all cars using execute() method
       String query = "Update CarPark Set newPrice=dayPrice*0.8";
       boolean result = stmt.execute(query);
       // if result false it is a Update - not ResultSet
       if (!result) {
        System.out.println("New price for all cars are calculated");
       // Create a  ResultSet with a query that returns
       // all the columns  from the dB table Carpark
       // using the execute() method.
       result = stmt.execute("select * from Carpark ");
       ResultSet resultSet = null;
       // if result true it is a ResultSet
       if (result) {
        resultSet = stmt.getResultSet();
       // As cursor is at the before first row position
       // we use the next() method to
       // test and read the first row in the ResultSet.
       if (resultSet.next()) {
        // Then we use a loop to retrieve rows and column data
        // and creates a html coded table output
        System.out.println("<table border='1' >");
        do {
         System.out.print("<td>" + resultSet.getString("regNo") + "</td>");
         System.out.print("<td>" + resultSet.getString("cartype") + "</td>");
         System.out.println("<td>" + resultSet.getInt("model") + "</td>");
         System.out.println("<td>" + resultSet.getDouble("dayPrice") + "</td>");
         System.out.println("<td>" + resultSet.getDouble("newPrice") + "</td>");
        } while (resultSet.next());
      } catch (ClassNotFoundException ex) {
               log(Level.SEVERE, null, ex);
      } catch (SQLException e) {
      } finally {
       try {
        // Close the Statement, which also close the ResultSet
       } catch (Exception xe) {

    You should use the close() method in the Statement object when you do not need it anymore.

    You should also use the close() method in the Connection object when you do not need it anymore.

    You can download this example here (needed tools can be found in the right menu on this page).

    If we run this application the result should be:
    As pure output Translated by a Browser
    New price for all cars are calculated
    <table border='1' >
    New price for all cars are calculated
    AD23443BMW2001 300.0 240.0
    AX72345AUDI2003 350.0 280.0
    CE23473AUDI2001 400.0 320.0
    DE12345AUDI2003 250.0 200.0
    DE23453FORD2002 375.0 300.0
    DE34562OPEL2001 340.0 272.0
    RE23456FORD2005 350.0 280.0
    XY34567BMW2009 347.0 278.0

© 2010 by Finnesand Data. All rights reserved.
This site aims to provide FREE programming training and technics.
Finnesand Data as site owner gives no warranty for the correctness in the pages or source codes.
The risk of using this web-site pages or any program codes from this website is entirely at the individual user.