QN047. Write a program to delete all records of database table.

---

1. Objective

To delete all record of database table.

2. Theory

In this program, we create statement and execute mysql query to delete all record of database table.

3. Source Code

import java.sql.*;

class JDBC47{
public static void main(String[] args){
try{
Class.forName("com.mysql.cj.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/bca_third_2020?serverTimezone=UTC";
String un = "root";
String pw = "";
Connection cn = DriverManager.getConnection(url,un,pw);
deleteAll(cn);
}catch(Exception e){
System.out.println(e);
}
}

private static void deleteAll(Connection cn) throws SQLException {
Statement stat = cn.createStatement(); // statment create

String query = "delete from student";
stat.executeUpdate(query); // execute query

System.out.println("All Record deleted!");
}
}


4. Output

All Record deleted!

5. Conclusion

In this way, I would like to conclude that, we can delete all record of database table by using this program.