将网页文本(HTML)保存到ORACLE数据库CLOB字段

　　网上常见的例子总是将文本文件上传至数据库的方法。今天在做文档管理相关系统时，需要将网页上的文本输入框（textarea或input）中的内容，上传到ORACLE数据库的CLOB字段中去。在网上找了好长时间，总算有所收获，现将方法总结如下，其中部分代码为其它网友的源码：

　　一、上传

 private void updateContent(Connection conn, Information info) throws
      Exception {
    PreparedStatement pstmt = conn.prepareStatement(
        "SELECT CONTENT FROM INFO_CONTENT WHERE ID=? FOR UPDATE");
    pstmt.setInt(1, info.getId());
    ResultSet rs = pstmt.executeQuery();
    /* 取出此CLOB对象 */
    if (rs.next()) {
      //Weblogic这样写
      OracleThinClob clob = (OracleThinClob) rs.getClob(1);
      //其它服务器这样写
      //oracle.sql.CLOB clob = (oracle.sql.CLOB) rs.getClob(1);
      /* 向CLOB对象中写入数据 */
      /*
       //保存文件
       //BufferedWriter out = new BufferedWriter(clob.getCharacterOutputStream());
       //BufferedReader in = new BufferedReader(new FileReader(filename));
       */
      //保存字符串
      Writer out = clob.getCharacterOutputStream();
      out.write(info.getContent());
      out.flush();
      out.close();
      rs.close();
      pstmt.close();
    }
  }

 二、在jsp中显示

 public Information getInformation(int id) throws Exception {
    Information base = new Information();
    Connection conn = null;
    try {
      conn = DBConnect.GainDBConnect();
      PreparedStatement ps = conn.prepareStatement(
          "SELECT * FROM INFO_CONTENT WHERE ID=?");
      ps.setInt(1, id);
      ResultSet rs = ps.executeQuery();
      while (rs.next()) {

        java.sql.Clob clob = (java.sql.Clob) rs.getClob("CONTENT");
        /* 以字符形式输出 */
        Reader out = new BufferedReader(clob.getCharacterStream());
        BufferedReader bfClob = new BufferedReader(out);
        String strClob = bfClob.readLine();
        StringBuffer sbResult = new StringBuffer();
        while (strClob != null) {
          sbResult.append(strClob);
          strClob = bfClob.readLine();
        }
        base.setContent(sbResult.toString());
        out.close();

      }
      rs.close();
      ps.close();
    }
    catch (Exception ex) {
      System.out.println(ex);
      throw ex;
    }
    finally {
      conn.close();
    }
    return base;
  }

测试环境：１、weblogic8.1 sp3 　２、  Oracle9i　　３、JDBC thin Driver