java sql execute,如何使用java执行一批SQL语句？(How to execute a batch of SQL statements using java?)...

如何使用java执行一批SQL语句？(How to execute a batch of SQL statements using java?)

问题描述 (Problem Description)

如何同时在数据库上执行多个SQL命令？

解决方案 (Solution)

以下示例使用addBatch和executeBatch命令同时执行多个SQL命令。import java.sql.*;

public class jdbcConn {

public static void main(String[] args) throws Exception {

Class.forName("org.apache.derby.jdbc.ClientDriver");

Connection con = DriverManager.getConnection(

"jdbc:derby://localhost:1527/testDb","name","pass");

Statement stmt = con.createStatement(

ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);

String insertEmp1 = "insert into emp values(10,'jay','trainee')";

String insertEmp2 = "insert into emp values(11,'jayes','trainee')";

String insertEmp3 = "insert into emp values(12,'shail','trainee')";

con.setAutoCommit(false);

stmt.addBatch(insertEmp1);

stmt.addBatch(insertEmp2);

stmt.addBatch(insertEmp3);

ResultSet rs = stmt.executeQuery("select * from emp");

rs.last();

System.out.println("rows before batch execution= "+ rs.getRow());

stmt.executeBatch();

con.commit();

System.out.println("Batch executed");

rs = stmt.executeQuery("select * from emp");

rs.last();

System.out.println("rows after batch execution = "+ rs.getRow());

}

}

结果 (Result)

上面的代码示例将产生以下结果。 结果可能会有所不同。rows before batch execution= 6

Batch executed

rows after batch execution= = 9