读取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,len); ????} ????sos.close(); ????in.close();???}???rs.close();???conn.close();??} catch (InstantiationException e) {???// TODO Auto-generated catch block???e.printStackTrace();??} catch (IllegalAccessException e) {???// TODO Auto-generated catch block???e.printStackTrace();??} catch (ClassNotFoundException e) {???// TODO Auto-generated catch block???e.printStackTrace();??} catch (SQLException e) {???// TODO Auto-generated catch block???e.printStackTrace();??} catch (IOException e) {???// TODO Auto-generated catch block???e.printStackTrace();??}?}}

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!