Drops the Access/SQL table - Java Database Connectivity

Home	»	Java	»	Advance Java	»	Java Database Connectivity	»	Drops table

This example drops the Access table 'StudentTable' on the harddisk, using classes of the java.sql package and 'Views' the rows inserted.

•  A JDBC-ODBC bridge driver is loaded
•  A Connection to the database is made, using getConnection method()
•  Using the Connection object, SQL's 'Drop' statement is sent to the database
•  A message is printed on the command line indicating the command was successful
•  Minimal exception handling is done

To drop the entire table 'StudentTable' the executeUpdate() method is used.

/* =========================================================== File Name : DropsTable.java WebSite : http://javaproglang.blogspot.in/ Facebook : https://www.facebook.com/AdvanceJavaProgramming Twitter ID : https://twitter.com/AdvanceJava Created By : Bintu Chaudhary =========================================================== */ //Dropping the Access table 'StudentTable' using Java code import java.sql.*; public class DropsTable { public static void main(String args[ ] ) { Connection conn; Statement stmt; try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); } catch(ClassNotFoundException e) { System.err.print("ClassNotFoundException : "); System.err.println(e.getMessage( )); } try { conn = DriverManager.getConnection("jdbc:odbc:MyDsn"); stmt = conn.createStatement( ); //Deleting the table 'StudentTable', using the executeUpdate() method stmt.executeUpdate("Drop table StudentTable"); // Printing a message at the system prompt indicating rows inserted System.out.println("\nTable StudentTable Deleted\n\n"); // Closing the Statement object stmt stmt.close( ); // Closing the connection object conn conn.close( ); } // End of try block // Minimal exception handling done here catch(SQLException ex) { System.err.println("SQLException: " + ex.getMessage( )); } } // End of main() method } // End of class InsertProduct


The Output of Drops table is as shown below:

Diagram 22.19 Drops the Access table StudentTable

	Create the Database.
	Creating a DSN.
	Connecting to a Database.
	Creating & Executing Statements.
	Closing a database connection.

JDBC - Programming:

	View records from the Access/SQL table.
	Inserts records into the Access/SQL table.
	Updates records into the Access/SQL table.
	Deletes records from the Access/SQL table.
	Drops the Access/SQL table.

JDBC - Working With User Interfaces - Using Swing Compoents

	Inserts records into the Access/SQL table using Swing Components
	View records from the Access table/SQL using Swing JTable
	Updates records into the Access/SQL table using Swing Components
	Deletes records from the Access/SQL table using Swing Components

• Next Inserts records into the Access/SQL table using Swing Components
• Previous Deletes Records from Access/SQL table - Java Database Connectivity