[学习笔记]二进制数据的处理（1）普通二进制数据处理 B -------读取数据库中二进制数据

来源：互联网发布：重庆软件行业工资编辑：程序博客网时间：2024/05/16 18:55

<%@page contentType="text/html" pageEncoding="UTF-8"%>

<%@page import="cn.java.*"%>

<%@page import="java.sql.*"%>

<%@page import="java.text.*"%>

<%@page import="java.io.*"%>

<%@page import="java.util.*"%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"

"http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

</head>

<body>

Connection conn = null;

Statement stmt=null;

ResultSet rs=null;

try {

String sql = "select binfile from bindata where id=5";

conn = DBUtil.getConnection();

stmt=conn.createStatement();

rs=stmt.executeQuery(sql);

while(rs.next()){

ServletOutputStream sout=response.getOutputStream();

InputStream in=rs.getBinaryStream(1);

byte b[] = new byte[0x7a120];//获得二进制输入流

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

sout.write(b);//输出字符流

}

sout.flush();

sout.close();//关闭sout输出流

}

} catch (SQLException ex) {

out.println(ex.getMessage());

}

finally {

try {

DBUtil.close(rs, stmt, conn);

} catch (Exception ex) {

out.println(ex.getMessage());

}

</body>

</html>

[学习笔记]二进制数据的处理（1） 普通二进制数据处理 B -------读取数据库中二进制数据