資料庫關閉連接配接

    try{

    if (conn != null && stm != null && res != null) {

      conn.close();

      stm.close();

      res.close();

    }

    }catch(Exception e){

      e.printStackTrace();

      System.out.println("關閉資料庫連接配接出錯！");

上述代碼會導緻報錯，因為stm關閉時res也同時關閉，執行res.close()時res已經關閉，是以導緻報錯。

以下代碼為正确。

                try {

                        if (res != null)

                                res.close();

                } catch (Exception e) {

                        e.printStackTrace();

                }

                        if (stm != null)

                                stm.close();

                        if (conn != null) {

                          conn.close();

                        }