Connecting to MYSQL without using a dummy database

[Mastermind]

Hi everyone,

Is it possible to create a database from java (e.g name supplied by the user at the beginning instead using a pre-created or a dummy one) ?It seems that I have to connect to an already existing database before executing any statement (look at the following codes).

Code:

public void createDatabase(String DBName) throws Exception {                Connection conn;                  Statement st=null;                  ResultSet rs=null; Class.forName("com.mysql.jdbc.Driver"); conn = DriverManager.getConnection("jdbc:mysql://localhost/ttdatabase");  // look at this line                  st = conn.createStatement(); . . . . . .

_________________
Keep your own dignity, both online and offline throughout your life !!!

[dude]

I read in a Java book that creating a database is not defined as part of the ANSI SQL/DDL language, and it is not in JDBC.

This means that you need to inspect your database vendors documentation how databases can be created, plus whether this is somehow supported via their JDBC drivers (which is not in most cases).

[kaeud31]

Hi everyone :
You first need to create a database with MYSQL they use the java program to display the data contained in the database.I did java in class last semester.