I've included a downloadable SQL batch file ( see the Resources section ) that will create the table and insert five rows full of data. 我在本文的参考资料部分提供了一个可下载的SQL批文件,它会创建表并插入全部五行数据。
But a statement object submits different SQL statements to batch, while prepared statement submits a set of parameters to batch. 但语句对象提交不同的SQL语句进行批处理,而预置语句提交的是一组参数。
In addition, JDBC batching only supports adding different SQL statements to the batch as long as the SQL statements do not have any input parameters. 此外,只要SQL语句没有任何输入参数,JDBC批处理仅支持添加不同的SQL语句到批处理中。
If you are going to use heterogenous batch you might want to collect the SQL statements that you want to batch into one interface to make it simpler to use heterogeneous batch. 如果打算使用异构批处理,则可能需要将要批处理的SQL语句集中到一个接口中,以便于使用异构批处理。
SQL user-defined functions can simplify query coding for batch as well as online transactional programs. SQL用户定义函数可以简化批处理程序以及在线交易程序的编码工作。