從數(shù)據(jù)庫中讀出圖片并顯示的示例代碼

字號:

從數(shù)據(jù)庫中讀出圖片并顯示的示例代碼
    < !-- -- -- --Servlet-- -- -- -- -->
    package Photo;
    import Javax.servlet.*;
    import javax.servlet.http.*;
    import java.io.*;
    import java.util.*;
    import java.lang.*;
    import java.sql.*;
    /**
    *
    Title:
    *
    Description:
    *
    Copyright: Copyright (c) 2002
    *
    Company:
    * @author unascribed
    * @version 1.0
    */
    public class ShowImage extends HttpServlet {
    private static final String CONTENT_TYPE = "image/*";
    /**
    * 定義數(shù)據(jù)庫連接字符串,JDBC.odbc橋
    */
    private String driver_class = "Oracle.jdbc.driver.OracleDriver";
    private String connect_string =
    "jdbc:oracle:thin:xxw/xxw@192.168.1.50:1521:ORCL";
    Connection conn = null;
    ResultSet rs = null;
    Statement stmt = null;
    /********************************************
    * 定義應(yīng)用變量
    ******************************************/
    private String SQLString = ""; //定義查詢語句\\r
    public String M_EorrMenage = ""; //定義錯(cuò)誤信息變量
    private InputStream in = null; //定義輸入流\\r
    private int len = 10 * 1024 * 1024; //定義字符數(shù)組長度
    //Initialize global variables
    public void init() throws ServletException {
    /**
    * 連接數(shù)據(jù)庫\\r
    */
    try {
    Class.forName(driver_class);
    } catch (java.lang.ClassNotFoundException e) {
    //異常
    System.err.println("databean():" + e.getMessage());
    }
    }
    //Process the HTTP Get request
    public void doGet(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
    response.setContentType(CONTENT_TYPE);
    PrintWriter out = response.getWriter();
    //在數(shù)據(jù)庫中的照片的ID
    int PHOTOID = 0;
    /*********************************************
    * 接受上文傳遞的圖片ID號
    * 上文傳輸文件名稱為photoid
    *********************************************/
    try {
    PHOTOID = Integer.parseInt(request.getParameter("photoid"));
    SQLString = "select * from xxw_photo where p_id=" + PHOTOID;
    } catch (Exception e) {
    e.printStackTrace();
    response.setContentType("text/html; charset=gb2312");
    M_EorrMenage = "請輸入圖片ID號";
    M_EorrMenage =
    new String(M_EorrMenage.getBytes("ISO8859_1"), "GBK");
    out.println("<%@ page contentType=\'text/html; charset=gb2312\' %>");
    out.println("");
    out.println("id
    ");
    out.println("");
    out.println("
    " + M_EorrMenage + "
    ");
    out.println("

    ");
    }
    /*****************************************************
    * 執(zhí)行查詢語句\\r
    *****************************************************/