JAVA执行SQL语句,组合成一条和分开执行,哪个效率高些?
例如删除数据:
delete from test where sid=1;
delete from test where sid=2;
delete from test where sid=3;
方法1:
statement.executeUpdate("delete from test where sid=1;delete from test where sid=2;delete from test where sid=3;");
方法2:
statement.executeUpdate("delete from test where sid=1")
statement.executeUpdate("delete from test where sid=2")
statement.executeUpdate("delete from test where sid=3")
哪个执行的效率高些?还是两个一样?