connection 关闭方法

最新推荐文章于 2018-12-14 10:32:57 发布

zwhfyy

最新推荐文章于 2018-12-14 10:32:57 发布

阅读量1.2k

点赞数

分类专栏： Java 文章标签： exception null insert

本文链接：https://blog.csdn.net/zwhfyy/article/details/4615675

版权

Java 专栏收录该内容

156 篇文章 2 订阅

订阅专栏

Connection conn = null;
ResultSet rs = null;
preparedStatement pss = null;
try
{
        conn = dataSource.getConnection(USERID,pASSWORD);
        pss = conn.prepareStatement("SELECT SAVESERIALZEDDATA FROM SESSION.pINGSESSION3DATA WHERE SESSIONKEY = ?");
        pss.setString(1,sessionKey);
        rs = pss.executeQuery();
        pss.close();
        conn.close();
}
catch (Throwable t)
{
        // Insert Appropriate Error Handling Here
}
finally
{
        // The finally clause is always executed - even in error
        // conditions preparedStatements and Connections will always be closed
        try
        {
                  if (pss != null)
                              pss.close();
        }
        catch(Exception e) {}
        try
        {
                  if (conn != null)
                              conn.close();
        }
        catch (Exception e){}
        }
}