sql Statemente execute 返回值为false

今天用jdbc写了一句sql语句,通过PreparedStatement对象来插入记录,发现一个奇怪的问题,我明明是成功插入记录,可是pstmt.execute()确返回的是false,狂晕中。
Java代码 复制代码 收藏代码
  1. String sqlText = "insert into problem(title, " +  
  2.         "description, input, output, sample_input, " +  
  3.         "sample_output, hint, source, uploader) " +  
  4.         "values(?, ?, ?, ?, ?, ?, ?, ?, ?)";  
  5.     PreparedStatement pstmt = null;  
  6. ......   
  7. res = pstmt.execute();  

 

   呵呵,感到比较困惑。查看sun的API后恍然大悟。

sun API 写道
public boolean execute()
throws SQLExceptionExecutes the SQL statement in thisPreparedStatement object, which may be any kind of SQL statement.Some prepared statements return multiple results; the executemethod handles these complex statements as well as the simpler formof statements handled by the methods executeQuery andexecuteUpdate.
The execute method returns a boolean to indicate the form of thefirst result. You must call either the method getResultSet orgetUpdateCount to retrieve the result; you must call getMoreResultsto move to any subsequent result(s).


Returns:
true if the first result is a ResultSet object; false if the firstresult is an update count or there is no result
Throws:
SQLException - if a database access error occurs or an argument issupplied to this method

    再次发现一个小问题,我将如何判断这条记录是否插入成功呢?我选择了不用execut方法,而改用executeUpdate方法。

Java代码 复制代码 收藏代码
  1. if(pstmt.executeUpdate() == 1)  
  2.     return true;  
  3. else  
  4.     return false;  

    executeUpdate()返回数据库中更新记录的条数。那哪位大侠出来说一下execute该在什么情况下使用哇?

阅读更多
个人分类: JSP相关
想对作者说点什么? 我来说一句

没有更多推荐了,返回首页

关闭
关闭
关闭