Java/Database SQL JDBC/Delete

Delete record from table

   <source lang="java">
 

import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; public class Main {

 public static void main(String[] args) throws Exception {
   String url = "jdbc:mysql://localhost/sampledb";
   String username = "root";
   String password = "";
   Class.forName("com.mysql.jdbc.Driver");
   Connection connection = DriverManager.getConnection(url, username, password);
   String sql = "DELETE FROM users WHERE user_id = ?";
   int userId = 2;
   PreparedStatement statement = connection.prepareStatement(sql);
   statement.setInt(1, userId);
   int rows = statement.executeUpdate();
   System.out.println(rows + " record(s) deleted.");
   connection.close();
 }

}

 </source>