package test;
import java.sql.Blob;
import java.sql.Clob;
import javax.sql.rowset.serial.SerialBlob;
import javax.sql.rowset.serial.SerialClob;
public class Hello {
public static void main(String[] args) {
String str="123456";
//也可以这样不传字符集名称,默认使用系统的
//Blob blob = new SerialBlob(str.getBytes());
//clob 转 String
String clobToString="";
//blob 转 String
String blobToString="";
try {
//String 转 clob
Clob clob = new SerialClob(str.toCharArray());
//String 转 blob
Blob blob = new SerialBlob(str.getBytes("GBK"));
clobToString = clob.getSubString(1, (int) clob.length());
blobToString = new String(blob.getBytes(1, (int) blob.length()), "GBK");
} catch (Exception e) {
// TODO: handle exception
System.err.println("======="+e.getMessage());
}
//前面若没传入字符集名称,则这里也不需要传入,以免出错
//String blobString = new String(blob.getBytes(1, (int) blob.length()));
System.out.println(clobToString);
System.out.println(blobToString);
}
}