how to split sql queries and execute them using java?

Question

I have a files containing sql scripts both DDL and DML scripts like create, insert, update, delete, create views etc.

i need to split them correctly an execute them, any suggestions..

thanks in advance

what format will the file containing the SQL scripts have? i.e. will you have one SQL statement per line, or could SQL statements be spread over multiple lines? Or are comments allowed in the SQL script file? — DB5
– DB5, Commented Aug 13, 2012 at 14:39
sql statements in multiple line eg. formatted sql queries with more than 30 lines like views, and the file will also contains the commented lines — Samy
– Samy, Commented Aug 13, 2012 at 14:45

Community · Accepted Answer · 2017-05-23 12:20:08Z

-1

To execute you could use something like:

Statement stmt = conn.createStatement();
for(String statement : statements) {
    stmt.addBatch(statement);
}
stmt.executeBatch();

CommunityBot

11 silver badge

answered Aug 13, 2012 at 13:38

markus

6024 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1