CLOB数据转换

第一种：

	Clob clob = rs.getClob("remark");//Java.sql.Clob
	String detailinfo = "";
	if(clob != null){
	　　detailinfo = clob.getSubString((long)1,(int)clob.length());
	}

第二种：

    Clob clob = rs.getClob("remark");//java.sql.Clob
        int i = 0;
        if (clob != null) {
            InputStream input = clob.getAsciiStream();
            int len = (int) clob.length();
            byte by[] = new byte[len];
            while (-1 != (i = input.read(by, 0, by.length))) {
                input.read(by, 0, i);
            }
            detailinfo = new String(by, "utf-8");
        }

第三种：

	Clob clob = rs.getClob("remark");//java.sql.Clob
    String reString = "";
    Reader is = clob.getCharacterStream();// 得到流
    BufferedReader br = new BufferedReader(is);
    tring s = br.readLine();
    StringBuffer sb = new StringBuffer();
    // 执行循环将字符串全部取出付值给StringBuffer由StringBuffer转成STRING
    while (s != null) {
        sb.append(s);
        s = br.readLine();
    }
    reString = sb.toString();

重点：

获取Clob必须从rs对象中获取，否则会报连接关闭异常

	ResultSet rs = statement.executeQuery(sb.toString());