Monday, May 24, 2010

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();
}
}
}

No comments:

Post a Comment