--Ads--

Deleting All Rows from a Database Table

Consider a case where we have been given one database table, now we have to delete all the rows from the table. This section describes for deleting all rows from a specific database table. Deleting all rows with the help of some java methods and APIs interfaces that is given below:

Description of program:

This program establishes the connection between the MySQL database and java file with the help of a jdbc driver. After that deletes all rows by the SQL statement and shows a message "All rows are completely deleted!". If SQL statement is not executed then displays "SQL statement is not executed!".

Here is the code of program:


import java.sql.*;



public class DeleteAllRows{

  public static void main(String[] args) {

  System.out.println

("Example for Deleting All Rows from a database Table!");

  Connection con = null;

  try{

  Class.forName("com.mysql.jdbc.Driver");

  con = DriverManager.getConnection

("jdbc:mysql://localhost:3306/jdbctutorial", "root", "root");

  try{

  Statement st = con.createStatement();

  String sql = "DELETE FROM employee6";

  int delete = st.executeUpdate(sql);

  if(delete == 0){

  System.out.println("All rows are completelly deleted!");

  }

  }

  catch(SQLException s){

  System.out.println("SQL statement is not executed!");

  }

  }

  catch (Exception e){

  e.printStackTrace();

  }

  }

}

Download this example.

Deleting All Rows from a Database Table

Deleting All Rows from a Database Table

Deleting All Rows from a Database Table

Tutorials