Oracle,blob、clob与字符串互转
String s1="1231dsdgasd的飒飒大";
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()));
System.out.println(clobString);
System.out.println(blobString);
---------------------
作者:清风掠影_XQ
来源:CSDN
原文:https://blog.csdn.net/xqq580231/article/details/78091918
版权声明:本文为博主原创文章,转载请附上博文链接!
__________________________________________
oracle数据库中,blob对应javabean字段 java.sql.Blob
clob可以对应JavaBean字段String