How to create a table in Java with JDBC Connection?

By using CREATE TABLE query we can create table.

Syntax

CREATE TABLE table_name(
column1 datatype,
column2 datatype,
column3 datatype,
.....
columnN datatype,
PRIMARY KEY( columns )
);

To create a table with JDBC we need to follow these steps

Register the driver − Register the driver class using the registerDriver() method of the DriverManager class. Pass the driver class name to it, as parameter.
Establish a connection − Connect ot the database using the getConnection() method of the DriverManager class. Passing URL (String), username (String), password (String) as parameters to it.
Create Statement − Create a Statement object using the createStatement() method of the Connection interface.
Execute the Query − Execute the query using the execute() method of the Statement interface.

Example

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 SQLException {
      //Registering the Driver
      DriverManager.registerDriver(new com.mysql.jdbc.Driver());
      //Getting the connection
      String mysqlUrl = "jdbc:mysql://localhost/Mydatabase";
      Connection con = DriverManager.getConnection(mysqlUrl, "root", "password");
      System.out.println("Connection established......");
      //Creating the Statement
      Statement stmt = con.createStatement();
      //Query to create a table
      String query = "CREATE TABLE Employees("
         + "ID INT NOT NULL, "
         + "NAME VARCHAR (20) NOT NULL, "
         + "AGE INT NOT NULL, "
         + "SALARY DECIMAL (18, 2), "
         + "ADDRESS VARCHAR (25) , "
         + "PRIMARY KEY (ID))";
      stmt.execute(query);
      System.out.println("Table Created......");
   }
}

Output

while run the above program will return following output

Connection established......
Table Created......

Can we declare the main method as private in Java?

What is the Difference between Path and ClassPath in java?

What is Method Overloading in Java ?

How to Create Objects in Java?

Can we define a static constructor in Java?

Can we overload the main method in Java?

What is Instance variable?

Memory Allocation in Java

What are the important features of Java 8?

What is a Class/Static Variables?

What is the difference between JDK and JRE?

How to check Java version?

Convert given time in String format to seconds

Can we declare the main () method as final in Java?

How to create a table in Java with JDBC Connection?

Can we declare a static variable within a method in java?

Projects By category