Update Record

gistfile1.txt

import java.sql.*;

public class Main {
    public static void main(String... args) throws ClassNotFoundException, SQLException {
        Connection connection = null;
        //Loading of driver
        Class.forName("com.mysql.cj.jdbc.Driver");

        // Getting connection from driver
        connection = DriverManager.getConnection("jdbc:mysql://localhost/srgp?user=root&password=");

        PreparedStatement updateRecord = connection.prepareStatement(
                "update students set email = ? where id = ?"
        );

        updateRecord.setString(1, "kmgupta822000@gmail.com");
        updateRecord.setInt(2, 6);

        updateRecord.execute();
    }
}