Java对sqlserver表的image字段图片读取和输出本地

Java代码实现对sqlserver数据库表的image字段图片的读取，和输出存储到本地

由于表image字段图片存的内容是二进制值，如何输出保存到本地：

代码示例：（注：连接sqlserver数据库需配置其驱动文件）

public static void main(String[] args) {
    try {
        Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
        Connection con = DriverManager.getConnection("jdbc:sqlserver://192.168.xx.xx:1433;DatabaseName=xxxxxx", "username", "password");
        Statement stmt = con.createStatement();
        ResultSet rs;
        String strSql = "SELECT ScanPage FROM table_name where field1 = 'xxxxxx'";
        rs = stmt.executeQuery(strSql);
        while (rs.next()) {
            Blob blob = rs.getBlob("ScanPage");
            InputStream in = blob.getBinaryStream();
            DataOutputStream dos= new DataOutputStream(new BufferedOutputStream(new FileOutputStream( "D:/work/testdata/" + "xxxxxx_" + System.currentTimeMillis() + ".jpg")));
            // 读出流
//            in = rs.getBinaryStream("ScanPage");
            int len = 0;
            byte[] b = new byte[1024];
            while ((len = in.read(b)) != -1) {
                dos.write(b, 0, len);
            }
            dos.close();
            in.close();
        }
        rs.close();
    } catch (Exception e) {
        e.printStackTrace();
    }
}

运行：