Deleting All Rows from a Database Table - Java JDBC

Description

Deleting All Rows from a Database Table

Demo Code

import java.sql.Connection;
import java.sql.Statement;

public class Main {
  public void m() throws Exception {
    Connection connection = null;
    Statement stmt = connection.createStatement();

    // Use TRUNCATE
    String sql = "TRUNCATE my_table";

    // Use DELETE
    sql = "DELETE FROM my_table";

    // Execute deletion
    stmt.executeUpdate(sql);/*www  . j  a  v a2 s  . c  o m*/
  }
}

• Previous
• Next

Related Tutorials

• Wrap database table with Java Class
• Wrap Swing TableModel into database table
• Table creation, drop table, insert and select
• Inserting a Row into a Database Table
• Getting Rows from a Database Table