java 读取sqlserver image_JSP 读取 SQL Server 2000 中 image 型数据生成图片文件

//建立连接对象

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

.newInstance();

String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test", user = "sa", password = "sa";

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

Statement stmt = conn.createStatement();

ResultSet rs;

String strSql = "select id, data FROM test";

InputStream in = null;

FileOutputStream fileOutStream = null;

rs = stmt.executeQuery(strSql);

while (rs.next())

{

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

DataOutputStream sos = new DataOutputStream(

new BufferedOutputStream(new FileOutputStream("c:\\"

+ rs.getString("id") + ".jpg")));

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

in = rs.getBinaryStream("data");

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

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();

conn.close(); %>