Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Servlets How to delete a table in mysql

Related Tutorials


 
 

Share on Google+Share on Google+

How to delete a table in mysql

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

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

Advertisements

If you enjoyed this post then why not add us on Google+? Add us to your Circles



Liked it!  Share this Tutorial


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: July 19, 2007

Related Tutorials

Discuss: How to delete a table in mysql   View All Comments

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:0
DMCA.com