ÀûÓÃJAVAÏòOracleÊý¾Ý¿âÖвåÈë´ó¶ÔÏó

ͨ¹ýJDBC£¬ÎÒÃÇ¿ÉÒÔÏòoracle²åÈë´ó¶ÔÏó£¬ÈçͼƬ£¬ÒôƵ£¬³¤Îı¾µÈ£¬Æä²åÈë·½·¨Óкܶ࣬ÕâÀïÑÝʾһÏÂͨ¹ýÁ÷¸üиüеÄÐÎʽ²åÈëCLOB´ó¶ÔÏó¡£
ÕâÊÇÒ»¸ö´æ´¢Îı¾µÄÀý×Ó£¬½âÊÍÎÒ»áÔÚ³ÌÐòÖÐÒÔ×¢Ê͵ÄÐÎʽд³ö
/**
  * ½«Éú³ÉµÄ±íÑù´æ´¢µ½Êý¾Ý¿â
  *
  * @param htmlParam
  * @return
  */
 public static boolean addToDB(HtmlParam htmlParam) {
 
//´Ë´¦¶¨ÒåÊý¾Ý¿â²Ù×÷ʱʹÓõĶÔÏó
  Connection conn = null;
  //Óë²éѯ²Ù×÷Ôڴ˺¯ÊýÖжà´ÎʹÓÃ
  PreparedStatement stmt = null;
  ResultSet rs = null;
  //ORACLEÖеĴó¶ÔÏó
  CLOB clob = null;
//дÈë´ó¶ÔÏóËùÐèµÄÁ÷
  Writer write = null;
  try {
   // jdbcÁ¬½ÓÊý¾Ý¿â²ÎÊý
   Class.forName("oracle.jdbc.driver.OracleDriver");
   String url = "jdbc:oracle:thin:@192.168.1.210:1521:moe210";
   conn = DriverManager.getConnection(url, "tjdemo", "tjdemo");
   // ÏȲåÈëÏàÓ¦µÄÊý¾Ý
   String sql = "insert into html_demo values(SEQ_HTML.nextval, ?, ?, ?, ?, ?, ?, ?, empty_clob(), ?)";
   //×¢ÒâÉÏÒ»¾ä²åÈëµÄÊÇÒ»¸ö¿ÕµÄ´ó¶ÔÏó empty_clob(),£¬¼´Ã»ÓÐÏò´ó¶ÔÏóÖвåÈëÈκÎÊý¾Ý
   
   stmt = conn.prepareStatement(sql);
   stmt.setInt(1, htmlParam.getProjectId());
   stmt.setString(2, htmlParam.getReptName());
   stmt.setInt(3, htmlParam.getStartRow());
   stmt.setInt(4, htmlParam.getStartColumn());
   stmt.setInt(5, htmlParam.getEndRow());
   stmt.setInt(6, htmlParam.getEndColumn());
   stmt.setString(7, htmlParam.getCharset());
   stmt.setString(8, htmlParam.getPath());
   stmt.executeUpdate();
   // ²éѯµ±Ç°sequenceÖµ£¬¼´²éѯ¸Õ¸Õ²åÈëµ½Êý¾Ý¿âÖеÄ×ֶεÄid
   String seq = "select SEQ_HTML.currval from dual";
   stmt = conn.prepareStatemen