how to call multiple sql statements in java

[sandeep43]

Hi,

I have to execute a sql statement, based on that result i have to executed i have to fetch another data using select statement, based on the second sql i have to execute create statement, and i have thousands of rows of data to handle, how to accomplish that?

basically the flow is Select --> Select --> create Statements.


Regards
Sandeep

[FlyNn]

Connection conn = DriverManager.getConnection(<path>,<username>,<password>);

Statement s = conn.prepareStatement("Select * from <tablename>");

ResultSet rs = s.executeQuery();

so for multiple selects you would just need to replace values in prepareStatament. Or use a String variable and change its values after each executeQuery in prepareStatement.

[Tolls]

And before you do that, make sure you can't do this as a single SQL.
Or at least merge the two SELECTs.

If all you;re doing is:

SELECT x FROM y WHERE (some criteria);
if (x == somethingOrOther) {
    SELECT a FROM b WHERE c = x;
    INSERT INTO n (someColumn) VALUES (a);
}

because that there should be a single SQL statement, not 3.

[doWhile]

Just nest your JDBC calls. Keep in mind that only one ResultSet associated with a Statement can be open at the same time.
Lesson: JDBC Basics (The Java™ Tutorials > JDBC(TM) Database Access)

[ontonio]

This should help. JDBC 2.0 allows you to use the addBatch method, but mysql will not allow multiple queries unles you set that security (allowMultiQueries)property. I hope this helps!

[Tolls]

Unlikely to be able to use batching, since the later SQL statements are dependent on the previous ones.