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.
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
