java 執行預存程序例子

  private String addcwform(String recordsumid) {

    CallableStatement proc = null;
    Connection conn = null;
    try {
      conn = DBUtil.getConn();
      proc = conn.prepareCall("{ ? = call cwnew_pack.addCwform(?) }");
      proc.registerOutParameter(1, Types.CHAR);
      proc.setString(2, recordsumid);

      proc.execute();
      String str = proc.getString(1);
      return str;

    }
    catch (SQLException e) {
      Log.fetal("失敗:" + e + "cwnew_pack.addCwform" + ",recordsumid=" +
                recordsumid);
    }
    finally {

      freeclose(proc, conn);
    }
    return "";
  }

 

 private void freeclose(CallableStatement proc, Connection conn) {
    try {
      proc.close();
    }
    catch (Exception ex) {
      Log.fetal("關閉:proc,失敗," + ex.toString());
    }
    this.closeConn(conn);

  }

/**
   * 關閉所有的串連
   */
  public void closeConn(Connection conn) {

    try {
      conn.close();
    }
    catch (Exception e) {
      Log.fetal("資料庫連接，關閉錯誤:" + e);
    }

  }