Statement关闭(转) -

qjbagu

浏览: 23530 次
性别:
来自: 北京

最近访客更多访客>>

chen3775669

0519mch

博主相关

博客

微博

相册

留言

关于我

文章分类

社区版块

存档分类

Statement关闭(转)

JDBC

以前用JDBC处理多个Statement的时候，总会因为异常而无法完美的解决Statement正常关闭，今天无意看到老外写了以下一段代码，和大家分享一下：

 

Java代码 
private PreparedStatement psStmt1;   
private PreparedStatement psStmt2;   
private PreparedStatement psStmt3;   
    
........................   
........................   
  
/*  关闭代码  */  
public void cleanup() throws SQLException {   
  SQLException exception = null;   
  if (psStmt1 != null) {   
    try {   
      psStmt1.close();   
    } catch (SQLException e) {   
      exception = e;   
    } finally {   
      psStmt1 = null;   
    }   
  }   
    
  if (psStmt2 != null) {   
    try {   
      psStmt2.close();   
    } catch (SQLException e) {   
      if (exception != null) e.setNextException(exception);   
      exception = e;   
    } finally {   
      psStmt2 = null;   
    }   
  }   
    
  if (psStmt3 != null) {   
    try {   
      psStmt3.close();   
    } catch (SQLException e) {   
      if (exception != null) e.setNextException(exception);   
      exception = e;   
    } finally {   
      psStmt3 = null;   
    }   
  }   
    
  if (exception != null) {   
    throw exception;   
  }   
}  

private PreparedStatement psStmt1;
private PreparedStatement psStmt2;
private PreparedStatement psStmt3;
 
........................
........................

/*  关闭代码  */
public void cleanup() throws SQLException {
  SQLException exception = null;
  if (psStmt1 != null) {
    try {
      psStmt1.close();
    } catch (SQLException e) {
      exception = e;
    } finally {
      psStmt1 = null;
    }
  }
 
  if (psStmt2 != null) {
    try {
      psStmt2.close();
    } catch (SQLException e) {
      if (exception != null) e.setNextException(exception);
      exception = e;
    } finally {
      psStmt2 = null;
    }
  }
 
  if (psStmt3 != null) {
    try {
      psStmt3.close();
    } catch (SQLException e) {
      if (exception != null) e.setNextException(exception);
      exception = e;
    } finally {
      psStmt3 = null;
    }
  }
 
  if (exception != null) {
    throw exception;
  }
}

分享到：