On 08/10/16 17:16, Thomas Kellerer wrote:
> Stephen Davies schrieb am 08.10.2016 um 02:57:
>> A follow-up question.
>> Once the bytea column is populated, how best to display the content in a
>> web page?
>>
>> I have :
>>
>> byte [] imgB;
>> ResultSet rs = st1.executeQuery("select pic from part where pno='" + p + "'");
>> if(rs.next()){
>> imgB = rs.getBytes(1);
>> if (imgB != null){
>> out.write("Content-type: image/jpeg");
>> out.write("Content-length: " + (int)imgB.length);
>> out.write(imgB.toString());
>> }
>> }
>>
>> but this does not work.
>> The toString() looks wrong but removing it makes the write fail.
>
> What is "out"?
>
> (And please use a PreparedStatement to run the SELECT for security reasons)
>
>
>
>
Thanks to all.
Both the update and display now work.
Cheers,
Stephen