Home Jdbc Jdbc-mysql Deleting All Rows from a Database Table
Questions:Ask|Latest

 
 

Share on Google+Share on Google+

Deleting All Rows from a Database Table

Advertisement
This section describes for deleting all rows from a specific database table.

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.

Advertisement

If you enjoyed this post then why not add us on Google+? Add us to your Circles



Liked it!  Share this Tutorial


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: April 13, 2007

Related Tutorials

Ask Questions?    Discuss: Deleting All Rows from a Database Table   View All Comments

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments
DMCA.com