Skip to content
Related Articles
Get the best out of our app
GeeksforGeeks App
Open App

Related Articles

Java JDBC – Update a Column in a Table

Improve Article
Save Article
Like Article
Improve Article
Save Article
Like Article

Java has its own API which JDBC API which uses JDBC drivers for database connections. JDBC API provides the applications-to-JDBC connection and JDBC driver provides a manager-to-driver connection. Following are the 5 important steps to connect java application to our database using JDBC.

  • Registering the Java class
  • Creating a Connection
  • Creating a Statement
  • Executing queries
  • Closing connection

Note: Load mysqlconnector.jar into your program.


  • Download MySQLConnect/J (JDBC connector jar file) from the following link
  • Select platform-independent in select OS option
  • Copy mysql-connector-java-5.1.34-bin.jar file in your project
  • Right-click on it , select Build Path-> Configure Build path -> libraries -> Add JARS
  • In JAR selection window, select mysql-connector-java-5.1.34-bin.jar library under your project
  • Click OK
  • Create a Database, add a table with records using MySQL cmd.  


// Update a Column in a Table
// dont forget to import below package
import java.sql.*;
public class Database {
    // url that points to mysql database, 'db' is database
    // name
    static final String url
        = "jdbc:mysql://localhost:3306/db";
    public static void main(String[] args)
        throws ClassNotFoundException
        try {
            // this Class.forName() method is user for
            // driver registration with name of the driver
            // as argument i have used MySQL driver
            // getConnection() establishes a connection. It
            // takes url that points to your database,
            // username and password of MySQL connections as
            // arguments
            Connection conn = DriverManager.getConnection(
                url, "root", "1234");
            // create.Statement() creates statement object
            // which is responsible for executing queries on
            // table
            Statement stmt = conn.createStatement();
            // Executing the query, student is the table
            // name and RollNo is the new column
            String query
                = "ALTER TABLE student RENAME COLUMN roll_no TO RollNo";
            // executeUpdate() is used for INSERT, UPDATE,
            // DELETE statements.It returns number of rows
            // affected by the execution of the statement
            int result = stmt.executeUpdate(query);
            // if result is greater than 0, it means values
            // has been added
            if (result > 0)
                    "table successfully updated.");
                System.out.println("unable to update");
            // closing connection
        catch (SQLException e) {

Update a column in a tableUpdated table

My Personal Notes arrow_drop_up
Last Updated : 08 Dec, 2020
Like Article
Save Article
Similar Reads
Related Tutorials