在java中执行多个查询时出错[重复]

Question

在过去的几天里,我无法解决这个问题,我遇到了一个使用Java EE在同一个指令中进行多个查询的问题,

static public void transfer(String sender, String receiver, double amount) {
    try (Connection connection = DriverManager.getConnection(dbURL, dbLogin, dbPassword)) {


        String query = " insert into T_Transactions (sender, receiver, amount, date) values (?, ?, ?, ?) ; update T_Users set balance =? WHERE email = ?";


        Date d = new Date();

        PreparedStatement statement = connection.prepareStatement(query);
        statement.setString(1, sender);
        statement.setString(2, receiver);
        statement.setDouble(3, amount);
        statement.setString(4, new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.SSSSS").format(d));
        statement.setDouble(5, amount);
        statement.setString(6, sender);

        try {
            statement.executeUpdate();
        } catch (Exception e) {
            e.printStackTrace();
        }
    } catch (Exception e) {
        e.printStackTrace();
    }
}

我在mysql中尝试过这个查询，它工作得很好，但每次在代码中使用它时都会遇到以下错误

java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'update T_Users

Answer 1

我不知道为什么一起试。请分别使用插入和更新。否则就按程序走吧。我的理解是在Mysql和java中执行多个查询是不同的