mybatis读取blob类型

mybatis 读取blob数据

mybatis读取blob数据过程：

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

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

Customer.java

public class Customer {
    private String cuscode;
    private byte[] qrcode;
public String getCuscode() {
    return cuscode;
}

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

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

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

}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

springmvc中的请求

@RequestMapping(value = "/web/showerweima")
    @ResponseBody
    public String showerweima() {
        Map<String,Object> params = new HashMap<String, Object>();
        params.put("cuscode","vvcc");
        Map<String,Object> resMap = memberManagementServices.getQrcode(params);
        byte[] buffer = (byte[])resMap.get("imgstr");
        File file = new File("d:/temp/cccc.png");
        FileOutputStream fos = null;
        try {
            fos = new FileOutputStream(file);
        } catch (FileNotFoundException e) {
            e.printStackTrace();
        }
        BufferedOutputStream bos = new BufferedOutputStream(fos);
        try {
            bos.write(buffer);
        } catch (IOException e) {
            e.printStackTrace();
        }
        return "123";
    }
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22

对应的dao层

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

xml文件中的内容：

<select id="getQrcode" parameterType="map" resultType="com.xueyou.model.Customer">
        SELECT  * from t_customer where cuscode = #{cuscode}
    </select>
1
2
3

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