在Java中使用PreparedStatement执行SQL更新语句时，可以通过调用executeUpdate()方法来获取受影响的行数。例如，对于更新user_table中Level为'Super'的用户，可以先设置参数，然后执行executeUpdate()，它将返回更新的记录数。
I'm using a MySQL database and accessing it through Java.
PreparedStatement prep1 = this.connection.prepareStatement("UPDATE user_table
SET Level = 'Super'
WHERE Username = ?");
prep1.setString(1, username);
The update statement above works fine however I'd like to get the number of rows affected with this statement. Is this possible please?
解决方案
Calling executeUpdate() on your PreparedStatement should return an int, the number of updated records.
2312
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
