create table-JDBC

 

 

import java.sql.*;

 

class CreateTable {

    public static void main(String args[])throws Exception

            {

         Class.forName("com.mysql.jdbc.Driver");

 Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3307/mca", "root", "");

                        Statement stmt = con.createStatement();

         

            String query = "CREATE TABLE class (cno INT, cname VARCHAR(10))";

            stmt.executeUpdate(query);

               System.out.println("Table created successfully");

                        con.close();

            }

}