How do I drop table from database?

This example is to show you how to delete or drop a table from your database. Basically we just send a drop table command and specify the table name to be deleted to the database. The example below show you how to do it in Oracle database.

package org.kodejava.example.sql;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

public class DropTableExample {
    public static void main(String[] args) throws Exception {
        Connection connection = null;
        try {
            // This is the JDBC driver class for Oracle database
            Class.forName("oracle.jdbc.driver.OracleDriver");

            // We use an Oracle express database for this example
            String url = "jdbc:oracle:thin:@localhost:1521:xe";

            // Define the username and password for connection to
            // our database.
            String username = "kodejava";
            String password = "kodejava123";

            // To delete a table from database we use the DROP TABLE
            // command and specify the table name to be dropped
            String sql = "DROP TABLE books";

            // Connect to database
            connection = DriverManager.getConnection(url, username, password);
            // Create a statement
            Statement statement = connection.createStatement();
            // Execute the statement to delete the table
            statement.execute(sql);
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            try {
                if (connection != null && !connection.isClosed()) {
                    connection.close();
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}

How do I create a table in database?

In this example you can see how to create a table in an Oracle database. We create a table called books with two fields, id and title. We start by registering the Oracle database drive, create a connection to the database a execute the create table statement.

package org.kodejava.example.sql;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

public class CreateTableExample {
    public static void main(String[] args) throws Exception {
        Connection connection = null;
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");

            String url = "jdbc:oracle:thin:@localhost:1521:xe";
            String username = "kodejava";
            String password = "kodejava123";

            String sql = "CREATE TABLE books (id NUMBER(11), title VARCHAR2(64))";
            connection = DriverManager.getConnection(url, username, password);
            Statement statement = connection.createStatement();
            statement.execute(sql);
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            try {
                if (connection != null && !connection.isClosed()) {
                    connection.close();
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}