How to Creating Table in Database using Java Program | Create Table in Database | JDBC
#databaseconnectivity #jdbc #jdbcconnectivity #javaunlocked #javaprogramming #javadatabaseconectivity
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
public class TableExample {
public static void main(String[] args) {
String dbUrl = "jdbc:mysql://localhost:3306/database_name";
String password = "database_password";
String username = "database_username";
String query = "CREATE TABLE users("+"id int auto_increment primary key," +
"username varchar(100) not null,"+"password varchar(100) not null)";
try{
Connection conn = DriverManager.getConnection(dbUrl, username, password);
System.out.println("Database Connection Successfully");
Statement state = conn.createStatement();
state.executeUpdate(query);
System.out.println("Users table created in database - table_example");
conn.close();
}catch(Exception e){
e.printStackTrace();
}
}
}