java 读取sqlserver image,读取sqlserver图片image数据生成图片文件

//test.java

import java.io.BufferedOutputStream;

import java.io.DataOutputStream;

import java.io.FileOutputStream;

import java.io.IOException;

import java.io.InputStream;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class test {

public static  void   main (String [] arge){

try {

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();

String url="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=TableName", user="username",

password="password";

Connection conn= DriverManager.getConnection(url,user,password);

Statement stmt = conn.createStatement();

ResultSet rs;

String strSql  = "select name,photo from patient where name='name";

InputStream   in   =   null;

FileOutputStream   fileOutStream   =   null;

rs=stmt.executeQuery(strSql);

while(rs.next()){

//Windows 系统下存储路径用2个反斜杠

DataOutputStream sos = new DataOutputStream(new BufferedOutputStream(new FileOutputStream("d:\\"+ rs.getString("name") +".jpg")));

//读出流用getBinaryStream()方法。

in = rs.getBinaryStream("photo");

//用缓存数组逐渐输出流

int len = 0;

byte[] b = new byte[1024];

while ((len = in.read(b)) != -1) {

sos.write(b,0,len);

}

sos.close();

in.close();

}

rs.close();

&nbs