- String s1="Holle world!";
- Clob c = new SerialClob(s1.toCharArray());//String 转 clob
- Blob b = new SerialBlob(s1.getBytes("GBK"));//String 转 blob
- //也可以不传字符集名称,那么默认使用系统的
- //Blob b = new SerialBlob(s1.getBytes());
- String clobString = c.getSubString(1, (int) c.length());//clob 转 String
- String blobString = new String(b.getBytes(1, (int) b.length()),"GBK");//blob 转 String
- //前面若没传入字符集名称,则这里也不需要传入,以免出错
- //String blobString = new String(b.getBytes(1, (int) b.length()));
PS(直接点的语句):
String转Clob:java.sql.Clob c = new javax.sql.rowset.serial.SerialClob("abc".toCharArray());
转载自:https://blog.csdn.net/inforstack/article/details/49907595