從數(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 = ""; //定義錯誤信息變量
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
*****************************************************/
< !-- -- -- --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 = ""; //定義錯誤信息變量
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("
");
out.println("");
out.println("
" + M_EorrMenage + "
");
out.println("
");
}
/*****************************************************
* 執(zhí)行查詢語句\\r
*****************************************************/