QuestionAsk Questions?
Shailander Sharma
Sir,
I am saving the images in mysql database with Blob. An I am retrieving the images with this code:-
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<%@ page import="servlets.MySqlConnect" %>
<%
MySqlConnect sc = new MySqlConnect();
Connection con = sc.getConnection();
InputStream sImage;
ServletOutputStream o = response.getOutputStream();
ResultSet rs =null;
Blob image=null;
PreparedStatement psmnt =null;
try{
psmnt = con.prepareStatement("SELECT img FROM Test WHERE img_id = ?");
psmnt.setString(1, "ss");
rs = psmnt.executeQuery();
if (rs.next()) {
image = rs.getBlob(1);
} else {
response.setContentType("text/html");
out.println("<html><head><title>Display Blob Example</title></head>");
out.println("<body><h4><font color='red'>image not found for given id</font></h4></body></html>");
return;
}
response.setContentType("image/gif");
InputStream in = image.getBinaryStream();
int length = (int) image.length();
int bufferSize = 1024;
byte[] buffer = new byte[bufferSize];
while ((length = in.read(buffer)) != -1) {
o.write(buffer, 0, length);
}
in.close();
o.flush();
}
catch(Exception ex){
out.println("error :"+ex);
}
finally {
// close all the connections.
rs.close();
psmnt.close();
con.close();
}
%>
I am getting my image with this code but all I need that I want to resize that image automatically according to given dimension after retrieving on web page.
If you will help me, I will be very grateful to you.
Thanking You,
Shailander Sharma
I am saving the images in mysql database with Blob. An I am retrieving the images with this code:-
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<%@ page import="servlets.MySqlConnect" %>
<%
MySqlConnect sc = new MySqlConnect();
Connection con = sc.getConnection();
InputStream sImage;
ServletOutputStream o = response.getOutputStream();
ResultSet rs =null;
Blob image=null;
PreparedStatement psmnt =null;
try{
psmnt = con.prepareStatement("SELECT img FROM Test WHERE img_id = ?");
psmnt.setString(1, "ss");
rs = psmnt.executeQuery();
if (rs.next()) {
image = rs.getBlob(1);
} else {
response.setContentType("text/html");
out.println("<html><head><title>Display Blob Example</title></head>");
out.println("<body><h4><font color='red'>image not found for given id</font></h4></body></html>");
return;
}
response.setContentType("image/gif");
InputStream in = image.getBinaryStream();
int length = (int) image.length();
int bufferSize = 1024;
byte[] buffer = new byte[bufferSize];
while ((length = in.read(buffer)) != -1) {
o.write(buffer, 0, length);
}
in.close();
o.flush();
}
catch(Exception ex){
out.println("error :"+ex);
}
finally {
// close all the connections.
rs.close();
psmnt.close();
con.close();
}
%>
I am getting my image with this code but all I need that I want to resize that image automatically according to given dimension after retrieving on web page.
If you will help me, I will be very grateful to you.
Thanking You,
Shailander Sharma
View Answers
Related Pages:
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
Tutorial Topics
