Deleting table using DBCP

This tutorial demonstrate how to drop table from MySQL using DBCP.

This tutorial demonstrate how to drop table from MySQL using DBCP.

Code:


import java.sql.*;

	
import org.apache.commons.dbcp.BasicDataSource;

	

	
class DeleteTable {

	
  public static void main(String[] args) {

	
    BasicDataSource bds = new BasicDataSource();

	
    bds.setDriverClassName("com.mysql.jdbc.Driver");

	
    bds.setUrl("jdbc:mysql://localhost:3306/mydb");

	
    bds.setUsername("root");

	
    bds.setPassword("");

	
    try {

	
      Connection con = bds.getConnection();

	
      try {

	
        Statement st = con.createStatement();

	
        st.executeUpdate("DROP TABLE user_master1");

	
        con.close();

	
      } catch (SQLException s) {

	
        System.out.println("SQL code does not execute.");

	
      }

	
    } catch (Exception e) {

	
      e.printStackTrace();

	
    }

	
  }

	
}

Directory structure of files

In the lib folder place all required jar files ie. commons-collections.jar, commons-dbcp.jar, commons-pool.jar, j2ee.jar and mysql-connector-java-5.1.7-bin.jar

In the pathset.bat write following statement

set classpath=.;lib/commons-collections.jar;lib/commons-dbcp.jar;lib/commons-pool.jar;lib/j2ee.jar;lib/mysql-connector-java-5.1.7-bin.jar

Output:

Ads