note

JSP - Oracle Clob 사용법 본문

JSP/기본

JSP - Oracle Clob 사용법

투한 2012. 2. 20. 10:39

package com.util;

import java.io.IOException;
import java.io.Reader;
import java.sql.ResultSet;
import java.sql.SQLException;

public class StringUtil {
	public static String clobToString(ResultSet rs, String msg)
			throws SQLException, IOException {
		StringBuffer sb = new StringBuffer();
		Reader rd = rs.getCharacterStream(msg);
		char[] buffer = new char[1024];
		int byteRead;
		while ((byteRead = rd.read(buffer, 0, 1024)) != -1) {
			sb.append(buffer, 0, byteRead);
		}
		rd.close();
		return sb.toString();
	}
}


String을 리턴함