create new MySQL Database with SQL

okay ... but how do I use the URL ? that's the problem

I tried this:

Connection con= null;

Vector vct= new Vector();

try{

String drv = "org.gjt.mm.mysql.Driver";

String url = "jdbc:mysql://111.222.333.444:3306";

String name = "myname";

String pass = "mypass";

Class.forName(drv);

con = DriverManager.getConnection(url,name,pass);

String statement = "CREATE DATABASE TestDB_Don1";

Statement stm = con.createStatement();

stm.execute(statement);

stm.close();

con.close();

}

catch(Exception e){ e.printStackTrace(); }

but it doesen't work ............. what is wrong ?

Don-Lna at 2007-7-13 3:26:27 >