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.

Related Tags for Deleting All Rows from a Database Table:
java, c, database, api, ide, table, data, interface, delete, io, methods, interfaces, help, method, int, this, id, tab, case, row, cas, if, for, rows, where, with, to, base, ci, ws, e, it, des, section, pe, from, ce, in, no, deleting, as, m, nt, sid, side, ca, let, j, ace, es, faces, spec, ase, all, pi, me, describe, s, sp, so, del, ee, at, apis, is, ha, ll, iv, and, cons, specific, va, scr, s, s, ri, th, av, bes, ab, abl, ap, face, nd, ods, on, om, o

«Previous Index Next»