How to delete a table in mysql

Consider a situation where we need to delete a table from a database.

How to delete a table in mysql

How to Delete a Table in MySQL

     

Consider a situation where we need to delete a table from a database. 

To delete a table from the database firstly we need to make a connection with the database. When the connection has been established pass a query for deleting a table inside the prepareStatement() method and it will return the PreparedStatement object. Now call the method executeUpdate() of the  PreparedStatement interface which will helps us to know the status of the program.

The code of the program is given below:

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;

public class ServletDeletingTable extends HttpServlet{
  public void doGet(HttpServletRequest request, 
 HttpServletResponse response) throws
 ServletException, IOException{
  response.setContentType("text/html");
  PrintWriter pw = response.getWriter();
  String connectionURL = "jdbc:mysql://localhost/zulfiqar";
  Connection connection;
  try{
  Class.forName("org.gjt.mm.mysql.Driver");
  connection = DriverManager.getConnection
   (connectionURL, "root", "admin");
  PreparedStatement pst = 
  connection.prepareStatement("drop table emp_sal");
  int i = pst.executeUpdate();
  if (i==0){
  pw.println("Table has been deleted");
  }
  else{
  pw.println("Table has not been deleted");
  }
  }
  catch(Exception e){
  pw.println("The exception is " + e);
  }
  }
}

XML File for this program:

<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE web-app
 PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
 "http://java.sun.com/dtd/web-app_2_3.dtd">

<web-app>
 <servlet>
 <servlet-name>Zulfiqar</servlet-name>
 <servlet-class>ServletDeletingTable</servlet-class>
 </servlet>
 <servlet-mapping>
 <servlet-name>Zulfiqar</servlet-name>
 <url-pattern>/ServletDeletingTable</url-pattern>
 </servlet-mapping>
</web-app>

Table in the database before deletion:

mysql> select * from emp_sa
+----------+--------+
| EmpName | salary |
+----------+--------+
| zulfiqar | 15000 |
| vinod | 12000 |
+----------+--------+
2 rows in set (0.00 sec)

The output of the program is given below:

Table in the database after deletion:

mysql> select * from emp_sal;
ERROR 1146 (42S02): Table 'zulfiqar.emp_sal' doesn't exist

Download this program

Tutorials

  1. Accessing Database from servlets through JDBC!
  2. History of web application
  3. Web Server
  4. Servlet Container
  5. Life cycle of Servlet
  6. Features of Servlets 2.4
  7. How to run a servlet
  8. Snooping Headers
  9. Dice Roller
  10. Simple Counter In Servlet
  11. Getting Init Parameter Names
  12. Multiple values for a single parameter
  13. Snooping the server
  14. Send Redirect in Servlet
  15. Session Tracking
  16. To Determine whether the Session is New or Old
  17. Pre- Existing Session
  18. Get Session Id
  19. Inserting Data In Database table using Statement
  20. Retrieving Data from the table using Statement
  21. Inserting data from the HTML page to the database
  22. Retrieving Data from the table using PreparedStatement
  23. Getting Columns Names using Servlets
  24. Getting Number of Columns
  25. Getting Number of Rows
  26. Deleting Rows From Table
  27. Deleting All Rows From the database Table
  28. How to add a column in a table
  29. Changing column name
  30. insert into statement in sql using servlets
  31. join tables mysql
  32. Natural Left Join
  33. Servlet Tutorials Links
  34. sendRedirect
  35. Random Redirector
  36. Servlet Context
  37. HttpSessionListener
  38. Inserting Image in a database Table
  39. say hello in spanish
  40. How to delete a table in mysql