mysql batch mode/running scripts

[Dillinger4]

Im trying to make some scrpits to run multiple queries but i dont want to do it from dos in batch mode. I want to actually run them from Java. How do i run a script instead of executing a query like this.

ResultSet rs = stmt.executeQuery("SELECT * FROM Users");

[CornedBee]

What kind of scripts?

[Dillinger4]

I was reading the MySql docs and they said you can make scripts that contain queries. I know how to run them in batch mode but not how to execute them from Java.

[CornedBee]

Can you refer me to the place in the MySQL docs?

[Dillinger4]

http://dev.mysql.com/doc/mysql/en/Batch_mode.html

[CornedBee]

That's only about the command line client, has nothing to do with JDBC.