Delete Record

gistfile1.txt

import jdk.jshell.spi.SPIResolutionException;

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 deleteRecord = connection.prepareStatement(
                "delete from students where id = ?"
        );

        deleteRecord.setInt(1, 6);

        deleteRecord.execute();
    }
}