<%@ page contentType="image/jpeg" %>
<%@page language="java" import="java.sql.*, java.util.*, oracle.jdbc.driver.*, oracle.sql.*,java.io.*, javax.servlet.*"%>
<%
int length = 0;
try{
.......................
Statement stmt=conn.createStatement();
String t="tea.gif";
ResultSet rs =stmt.executeQuery("SELECT photo_name,photo_data FROM binary_data where photo_name='"+t+"'");
if (rs.next())
{
String a=rs.getString("photo_name");
out.println(a);
BLOB my_blob = (BLOB)rs.getObject("photo_data");
length = (int)my_blob.length();
byte [] byte_array = my_blob.getBytes(1, length);
response.setContentType("photo_data/gif");
ServletOutputStream sos = response.getOutputStream(); for(int i=0;i<byte_array.length;i++)
{
sos.write(byte_array[i]);
}out.println(byte_array.length); }
rs.close();
stmt.close();
conn.close();
}catch(Exception e){
out.println("An error occurs:"+e.toString());
}%>
是不是要把<%@ page contentType="image/jpeg" %>改为
<%@ page contentType="text/html;charset=Gb2312"%>才对啊?
<%@page language="java" import="java.sql.*, java.util.*, oracle.jdbc.driver.*, oracle.sql.*,java.io.*, javax.servlet.*"%>
<%
int length = 0;
try{
.......................
Statement stmt=conn.createStatement();
String t="tea.gif";
ResultSet rs =stmt.executeQuery("SELECT photo_name,photo_data FROM binary_data where photo_name='"+t+"'");
if (rs.next())
{
String a=rs.getString("photo_name");
out.println(a);
BLOB my_blob = (BLOB)rs.getObject("photo_data");
length = (int)my_blob.length();
byte [] byte_array = my_blob.getBytes(1, length);
response.setContentType("photo_data/gif");
ServletOutputStream sos = response.getOutputStream(); for(int i=0;i<byte_array.length;i++)
{
sos.write(byte_array[i]);
}out.println(byte_array.length); }
rs.close();
stmt.close();
conn.close();
}catch(Exception e){
out.println("An error occurs:"+e.toString());
}%>
是不是要把<%@ page contentType="image/jpeg" %>改为
<%@ page contentType="text/html;charset=Gb2312"%>才对啊?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货