📄 show1.jsp
字号:
<!---------------------------显示---------------------------------------------->
<%@ page import="javax.servlet.*" %>
<%@ page import="javax.servlet.http.*" %>
<%@ page import="java.io.*" %>
<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>
<%
String id =request.getParameter("id");
%>
<html>
<head>
<title>Untitled Document</title>
</head>
<body bgcolor="#FFFFFF" text="#000000">
<table>
<br>
<%
String driver="weblogic.jdbc.mssqlserver4.Driver";
String url="jdbc:weblogic:mssqlserver4:test@202.194.209.30:1433";
String user="teaching";
String password="0819";
Connection sqlConn;
PreparedStatement pstmt;
ResultSet rs;
int len = 10 * 1024 * 1024; //定义字符数组长度
byte [] buf=null; //用来存储二进制流数据的缓冲区
try
{
//连接数据库，自定义的数据库连接池管理类
Class.forName(driver);
Connection dbcon=DriverManager.getConnection(url,user,password);
sqlConn=DriverManager.getConnection(url,user,password);
String searchSql="SELECT Photo FROM NewStudInfo WHERE ExamiNo = '" + id + "'";
pstmt=sqlConn.prepareStatement(searchSql);
rs=pstmt.executeQuery(searchSql);
//将图片数据读入缓冲区
if (rs.next())
{
//buf = rs.getBytes(1);
//String aa=rs.getString("type");
InputStream in = rs.getBinaryStream("photo");
response.reset(); //返回在流中被标记过的位置
response.setContentType("image/jpeg");
/*if (!(aa.equals("htm") || aa.equals("HTM"))!)
else
response.setContentType("text/html;charset=gb2312");
if (aa.equals("doc") ||aa.equals("DOC"))
response.setContentType("application/msword");
else
if (aa.equals("jpg") ||aa.equals("JPG"))
response.setContentType("image/jpeg");//
else
if (aa.equals("pdf") ||aa.equals("PDF"))
response.setContentType("application/pdf");
else
response.setContentType("text/html;charset=gb2312"); */
OutputStream toClient = response.getOutputStream();
byte[] P_Buf = new byte[len];
int i;
while ((i = in.read(P_Buf)) != -1)
{
toClient.write(P_Buf, 0, i);
} in.close();
toClient.flush();
}
else
{
out.println("no picture");
} //end if
}
catch (Exception e)
{
System.out.println(e.toString());
}
finally
{
try {
//sqlConn.close();
}catch(Exception e) {System.out.println(e.toString()); }
}
%>
</td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -