有 Java 编程相关的问题?

你可以在下面搜索框中键入要查询的问题!

java在HTML文件中引用servlet。Tomcat中的war文件

我创建了一个索引。我在tomcat上部署的Java(.war)应用程序的html文件

我已经有了一个Java Servlet文件,可以在远程数据库服务器上查询我存储在那里的图片

java servlet文件称为ImageServlet。爪哇

我需要HTML页面来显示ImageServlet显示的图像。java查询

我只是不知道如何在servlet检索我的图片时引用它

下面是ImageServlet文件:

package test;

import java.io.ByteArrayOutputStream;
import java.io.IOException;
import java.io.PrintStream;
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 javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.xml.bind.DatatypeConverter;

public class ImageServlet extends HttpServlet
{
  Connection con = null;

  public Connection getConnection()
  {
    try {
      Class.forName("com.mysql.jdbc.Driver");
      String url = System.getenv("FUJI_MYSQL_URL");
      return DriverManager.getConnection(url,             
System.getenv("FUJI_MYSQL_USER"), System.getenv("FUJI_MYSQL_PASS"));
    }
    catch (Exception ex)
    {
      System.out.println(ex.getMessage());
    }return null;
  }

  public static byte[] getImageById(Connection con)
  {
    String query = "select photo from photos where picid = 1";
    try
    {
      PreparedStatement stmt = con.prepareStatement(query);

      stmt.execute();
      ResultSet resultSet = stmt.getResultSet();
      resultSet.first();
      Blob blob = resultSet.getBlob(1);
      stmt.close();
      con.close();
      return blob.getBytes(1L, (int)blob.length());
    } catch (Exception ex) {
      System.out.println(ex.getMessage());
    }return null;
  }

  public void doGet(HttpServletRequest req, HttpServletResponse res)
    throws ServletException, IOException
  {
    PrintWriter out = res.getWriter();

    Connection con = null;
    con = getConnection();
    byte[] data = getImageById(con);

    ByteArrayOutputStream baos = new ByteArrayOutputStream();
    baos.write(data);

    out.println("<!DOCTYPE html><html xmlns=\"http://www.w3.org/1999/xhtml\"><head><title>PI_SQLogo.png</title></head><body><img src='data:image/png;base64," + DatatypeConverter.printBase64Binary(baos.toByteArray()) + "'></body></html>");
    out.close();
  }
}

共 (0) 个答案