Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.io.IOException;
- import java.io.InputStream;
- import java.io.OutputStream;
- import java.io.PrintWriter;
- import java.sql.Blob;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.PreparedStatement;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.sql.Statement;
- import java.util.Base64;
- import javax.servlet.ServletException;
- import javax.servlet.annotation.WebServlet;
- import javax.servlet.http.HttpServlet;
- import javax.servlet.http.HttpServletRequest;
- import javax.servlet.http.HttpServletResponse;
- import database.DatabaseConnection;
- /**
- * Servlet implementation class showImage
- */
- @WebServlet("/showImage")
- public class showImage extends HttpServlet {
- private static final long serialVersionUID = 1L;
- /**
- * @see HttpServlet#HttpServlet()
- */
- public showImage() {
- super();
- // TODO Auto-generated constructor stub
- }
- /**
- * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
- */
- protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
- String id = request.getParameter("id");
- System.out.println(id);
- ResultSet rs = null;
- try {
- DatabaseConnection baza = new DatabaseConnection();
- rs = baza.getUser("select * from proizvodi where id = " + id);
- if(rs.next()) {
- Blob blob = rs.getBlob("slika");
- response.setContentType("image/png");
- InputStream in = blob.getBinaryStream();
- OutputStream out = response.getOutputStream();
- int b;
- while((b = in.read()) != -1) {
- out.write(b);
- }
- in.close();
- out.flush();
- out.close();
- } else {
- System.out.println("Nije pronadjena slika!");
- }
- } catch (ClassNotFoundException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- } catch (SQLException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- }
- /**
- * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
- */
- protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
- // TODO Auto-generated method stub
- doGet(request, response);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement