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;

	}

 

 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值