Clob类型转换成String类型

分享一下我老师大神的人工智能教程！零基础，通俗易懂！http://blog.csdn.net/jiangjunshow

也欢迎大家转载本篇文章。分享知识，造福人民，实现我们中华民族伟大复兴！

               

oracle中表结构如下：

create table GRID_RESOURCE(  ID         VARCHAR2(50),  CNNAME     VARCHAR2(50),  TYPE       VARCHAR2(50),  PARENTID   VARCHAR2(50),  VIEWWIDTH  VARCHAR2(50),  REQUESTURL VARCHAR2(256),  COUNTSQL   CLOB,  ISDISPLAY  VARCHAR2(50),  TREEINDEX  VARCHAR2(256),  TABLES     VARCHAR2(256),  NOTE3      VARCHAR2(256))

COUNTSQL字段为CLOB类型，索引为6

import java.io.BufferedReader;import java.io.IOException;import java.io.Reader;import java.sql.Clob;import java.sql.SQLException;import java.util.ArrayList;import java.util.HashMap;import java.util.List;import java.util.Map;import org.hibernate.SessionFactory;import org.hibernate.cfg.Configuration;public class T { public static final SessionFactory sessionFactory; static {  try {   sessionFactory = new Configuration().configure()     .buildSessionFactory();  } catch (Throwable ex) {   throw new ExceptionInInitializerError(ex);  } } /**  * @param args  */ public static void main(String[] args) {  new T().getList(); } public void getList() {  String querySQL = "select * from GRID_RESOURCE";  String countSQL = "";  List<Object[]> list = new ArrayList<Object[]>();  // List o_list = new ArrayList();  try {   list = sessionFactory.openSession().createSQLQuery(querySQL).list();   for (Object[] obj : list) {    Map<String, Object> map = new HashMap<String, Object>();    Clob sc = (Clob) obj[6];    countSQL = ClobToString(sc);    System.out.println(countSQL);   }   // 另一个遍历方法   /*    * for(Object obj:o_list){ Object oo[] = (Object[])obj;    * System.out.println(oo[6]); }    */  } catch (Exception e) {   e.printStackTrace();  } } // 将字Clob转成String类型 public String ClobToString(Clob sc) throws SQLException, IOException {  String reString = "";  Reader is = sc.getCharacterStream();// 得到流  BufferedReader br = new BufferedReader(is);  String s = br.readLine();  StringBuffer sb = new StringBuffer();  while (s != null) {// 执行循环将字符串全部取出付值给StringBuffer由StringBuffer转成STRING   sb.append(s);   s = br.readLine();  }  reString = sb.toString();  return reString; }}

           

给我老师的人工智能教程打call！http://blog.csdn.net/jiangjunshow