主题:请问图片传送问题
想重服务器的数据库获取图片然后传送到客户端
public Object getImage(String order_id) throws java.rmi.RemoteException
{
Object imageObj =null;
ObjectInputStream ois = null;
try
{
Connection conn =DriverManager.getConnection(url,user,DBpass);
Statement stmt =conn.createStatement();
stmt=conn.createStatement();
String sql = "select * from picture where order_id="+"'"+order_id+"'"+";";
ResultSet rs = stmt.executeQuery(sql);
while(rs.next())
{
Blob image = rs.getBlob("product_image");
InputStream fin = image.getBinaryStream();
ois =new ObjectInputStream(fin);
imageObj = ois.readObject();
System.out.println(ois);
}
ois.close();
rs.close();
stmt.close();
conn.close();
}catch(SQLException e)
{
System.out.println("SQLException: " + e.getMessage());
System.out.println("SQLState: " + e.getSQLState());
System.out.println("VendorError: " + e.getErrorCode());
}
catch(Exception e)
{
System.out.println(e);
}
return imageObj;
}
会出现错误
java.io.StreamCorruptedException: invalid stream header: FFD8FFE0
public Object getImage(String order_id) throws java.rmi.RemoteException
{
Object imageObj =null;
ObjectInputStream ois = null;
try
{
Connection conn =DriverManager.getConnection(url,user,DBpass);
Statement stmt =conn.createStatement();
stmt=conn.createStatement();
String sql = "select * from picture where order_id="+"'"+order_id+"'"+";";
ResultSet rs = stmt.executeQuery(sql);
while(rs.next())
{
Blob image = rs.getBlob("product_image");
InputStream fin = image.getBinaryStream();
ois =new ObjectInputStream(fin);
imageObj = ois.readObject();
System.out.println(ois);
}
ois.close();
rs.close();
stmt.close();
conn.close();
}catch(SQLException e)
{
System.out.println("SQLException: " + e.getMessage());
System.out.println("SQLState: " + e.getSQLState());
System.out.println("VendorError: " + e.getErrorCode());
}
catch(Exception e)
{
System.out.println(e);
}
return imageObj;
}
会出现错误
java.io.StreamCorruptedException: invalid stream header: FFD8FFE0