Does Java support mutliple sql statements in one call?

statment.executeUpdate("DROP DATABASE IF EXISTS diy55;CREATE DATABASE IF NOT EXISTS diy55 DEFAULT CHARACTER SET utf8;GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER,INDEX,USAGE on diy55.* TO 'diy55'@'localhost' identified by 'diy55';FLUSH PRIVILEGES;");

Java seemes doesn't support multiple sql statements in one call, just like PHP mysql_query(), is it?

[403 byte] By [roamera] at [2007-11-27 4:37:34]
# 1

Then just extend the java.sql.Statement to your own Statement class and write logic which splits the given query at the right places and executes them one by one.

That the mysql_query() already has it built-in wouldn't say that it isn't possible in Java. Comparing with PHP is a bit pointless, it is a completely different language.

BalusCa at 2007-7-12 9:47:50 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...