But a statement object submits different SQL statements to batch, while prepared statement submits a set of parameters to batch.
但语句对象提交不同的sql语句进行批处理,而预置语句提交的是一组参数。
Create a profile for every batch, and tune the parameters to achieve the best result.
创建每批表单的配置文件,并调整参数以实现最佳结果。
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语句到批处理中。
应用推荐