java blob类型和字符串转换

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);
    }
}