mybatis 读取blob数据

mybatis 读取blob数据

mybatis读取blob数据过程：

1、从数据库中读出blob数据类型，用pojo中的byte[]接收。

2、把文件保存成文件（或者变成base64也行）。

public class Customer {
    private String cuscode;
    private byte[] qrcode;

    public String getCuscode() {
        return cuscode;
    }

    public void setCuscode(String cuscode) {
         = cuscode;
    }

    public byte[] getQrcode() {
        return qrcode;
    }

    public void setQrcode(byte[] qrcode) {
         = qrcode;
    }
}

springmvc中的请求

@RequestMapping(value = "/web/showerweima")
    @ResponseBody
    public String showerweima() {
        Map<String,Object> params = new HashMap<String, Object>();
        ("cuscode","vvcc");
        Map<String,Object> resMap = (params);
        byte[] buffer = (byte[])("imgstr");
        File file = new File("d:/temp/");
        FileOutputStream fos = null;
        try {
            fos = new FileOutputStream(file);
        } catch (FileNotFoundException e) {
            ();
        }
        BufferedOutputStream bos = new BufferedOutputStream(fos);
        try {
            (buffer);
        } catch (IOException e) {
            ();
        }
        return "123";
    }

对应的dao层

Customer getQrcode(Map<String, Object> params);

xml文件中的内容：

<select  parameterType="map" resultType="">
        SELECT  * from t_customer where cuscode = #{cuscode}
    </select>

这样能够把图片保存成文件。