关于操作数据库!

[vagrant2008]

Connection con = new Connection();
Statement stmt = con.createStatement();

int i = stmt.executeUpdate("delete from tableName");

请问stmt.executeUpdate("delete from tableName")的返回值有几种情况阿？分别是什么？
谢谢！！

[黑马]

public int executeUpdate(String sql)
throws SQLExceptionExecutes

the given SQL statement, which may be an INSERT, UPDATE, or DELETE statement or an SQL statement that returns nothing, such as an SQL DDL statement.

[little06]

stmt.executeUpdate("delete from tableName");
这个语句是没有返回值的

如果你想得到删除的记录数
在执行完上面的语句后
可以用select @@rowcount来得到

[vagrant2008]

谢谢大家