clob 大文本类型与String 互转
import java.io.BufferedReader;
import java.io.IOException;import java.sql.Clob;
import java.sql.SQLException;
import javax.sql.rowset.serial.SerialClob;
import javax.sql.rowset.serial.SerialException;
/**
* 大文本操作类
*
*/
public class ClobUtils{
/**
* 获得String
*
* @param c
*
* @return String
*/
public static String getString(Clob c) {
StringBuffer s = new StringBuffer();
if (c != null) {
try {
BufferedReader bufferRead = new BufferedReader(c.getCharacterStream());
try {
String str;
while ((str = bufferRead.readLine()) != null) {
s.append(str);
}
} catch (IOException e) {
e.printStackTrace();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
return s.toString();
}
/**
* 获得Clob
*
* @param s
*
* @return java.sql.Clob
*/
public static Clob getClob(String s) {
Clob c = null;
try {
if (s != null) {
c = new SerialClob(s.toCharArray());
}
} catch (SerialException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return c;
}
}