create database using jdbc

[Kiran Kudtarkar]

How do i create database using jdbc.
Please help me out with the syntax.

[Snigdha Solanki]

If you want to create tables, you can use executeUpdate method of java.sql.Statement interface.executeUpdate is used to execute an SQL INSERT, UPDATE or DELETE statement.

  
Statement stmt = con.createStatement();
String createTableCoffees = "CREATE TABLE COFFEES " +
    "(COF_NAME VARCHAR(32), SUP_ID INTEGER, PRICE FLOAT, " +
    "SALES INTEGER, TOTAL INTEGER)";
stmt.executeUpdate(createTableCoffees);

[Jamie Robertson]

Originally posted by Kiran Kudtarkar:
How do i create database using jdbc.
Please help me out with the syntax.

Sorry not an option through jdbc. You can call a VB function via JNI to create an access database or some other native code to create a database.
Jamie