从数据库中读出图片并显示的示例代码
从数据库中读取图片并显示它们的示例代码。
< !-----Servlet------>
包照片;
导入javax . servlet . *;
导入javax . servlet . http . *;
导入Java . io . *;
导入Java . util . *;
导入Java . lang . *;
导入Java . SQL . *;
/**
*标题:
*
描述:
*
版权:版权所有(c) 2002
*
公司:
* @author unascribed
* @version 1.0
*/公共类ShowImage扩展http servlet {
private static final String CONTENT _ TYPE = " image/* ";
/**
*定义数据库连接字符串,JDBC.odbc Bridge
*/
私有字符串Driver _ class = " Oracle . JDBC . Driver . Oracle Driver ";
私有字符串connect _ String =
" JDBC:Oracle:thin:xxw/xxw @ 192 . 168 . 1 . 50:1521:ORCL ";
连接连接=空;
ResultSet RS = null;
语句stmt = null
/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
*定义应用程序变量
//定义查询语句\ \ r
public string m _ eormenage = " ";//定义错误信息变量
private inputstream in = null;//定义输入流\ \ r
private int len = 10 * 1024 * 1024;//定义字符数组长度
//初始化全局变量
public void init()抛出servlet异常{
/* *
*连接数据库\ \ r
*/
try {
class . forname(driver)
} catch(Java . lang . classnotfoundexception e){
/exception
system . err . println(" data bean():+e . get message()));
}
}
//处理HTTP Get请求
public void doGet(HTTP servlet request请求,HttpServletResponse响应)
throws ServletException,io exception {
response . set CONTENT TYPE(CONTENT _ TYPE);
PrintWriter out = response . getwriter();
//数据库中照片的ID
int photo ID = 0;
/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
PHOTOID = integer . parse int(request . getparameter(" PHOTOID "));
SQLString = " select * from xxw _ photo where p _ id = "+PHOTOID;
} catch(Exception e){
e . printstacktrace();
response . set content type(" text/html;charset = GB 2312 ");
M_EorrMenage = "请输入图片ID号";
M _ eormenage =
new String(M _ eormenage . getbytes(" ISO8859 _ 1 ")," GBK ");
out . println(" ");
out . println(" ");
out . println(" id ");
out . println(" ");
out . println("+M _ EOR manager+"
out.println("");}
/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *[/br 位律师回复
0条评论