Clob类型转换成String类型

 

/**
	 * Get the clob column's value and change it into a string
	 * 
	 * @param rs
	 *            the ResultSet to get data
	 * @param column
	 *            the clob column's name
	 * @return the clob column's value as a string
	 */
	synchronized public static String getClobAsString(ResultSet rs,
			String column) {
		try {
			Reader reader = rs.getCharacterStream(column);
			if (reader == null) {
				return null;
			}
			StringBuffer sb = new StringBuffer();
			char[] charbuf = new char[4096];
			for (int i = reader.read(charbuf); i > 0; i = reader.read(charbuf)) {
				sb.append(charbuf, 0, i);
			}
			return sb.toString();
		} catch (Exception e) {
			Log.error("getClobAsString:-->" + e.getMessage());
			return "";
		}
	}

	synchronized public static String getClobAsString2(ResultSet rs,
			String column) {
		String detailinfo = "";
		try {
			Clob clob = rs.getClob(column);// 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");
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
		return detailinfo;

	}