具有多个 SQL 语句的 MySQL ConnectorJ

发布于 2025-01-04 08:18:55 字数 577 浏览 4 评论 0原文

另一位开发人员告诉我，有一个可以打开/关闭的 MySQL ConnectorJ 选项。该开发人员表示，将此 jdbc 选项设置为“on”后，我可以按以下形式运行 java jdbc 查询：

Connection jdbc = session.connection();
PreparedStatement pstmt = jdbc.prepareStatement("Update myTable set myField = 1 where myId = 1; Update myTable set anotherField = 2 where myId = 2");
pstmt.execute();

运行此准备好的语句背后的想法是，它在一次执行中运行两个 sql 查询。我查看了 mysql 文档< /a>，但我还没找到这个选项。开发人员不记得此设置的名称，但确信它存在。有谁知道哪个 mysql 选项控制这种行为？

原文

Another developer tells me that there is a MySQL ConnectorJ option which can be turned on/off. This developer says that after turning this jdbc option to 'on', I can run a java jdbc query in the form:

Connection jdbc = session.connection();
PreparedStatement pstmt = jdbc.prepareStatement("Update myTable set myField = 1 where myId = 1; Update myTable set anotherField = 2 where myId = 2");
pstmt.execute();

The idea behind running this prepared statement is that it runs two sql queries in a single execution. I've looked at the mysql documentation, but I haven't been able to find this option. The developer does not recall the name of this setting, but is certain that it exists. Does anyone know which mysql option controls this behavior?

分享到QQ

分享到微博