?? page.jsp
字號:
<%-- Document : page Created on : 2009-4-20, 4:01:53 Author : Administrator--%><%@page contentType="text/html" pageEncoding="GBK"%><%@page import="java.io.*,java.sql.*,javax.sql.*,javax.naming.*"%><%@page import="javax.servlet.*,javax.servlet.http.*" %><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><%Connection conn=null;java.lang.String strConn;request.setCharacterEncoding("GBK");//PreparedStatement preparedStmt=null;//語句對象java.sql.Statement sqlStmt=null;//語句對象ResultSet sqlRst=null;//結果集對象ServletOutputStream op=response.getOutputStream();String tuname=request.getParameter("name");try{ Class.forName("org.gjt.mm.mysql.Driver").newInstance(); conn=java.sql.DriverManager.getConnection("jdbc:mysql://localhost:3306/student","root","root"); sqlStmt=conn.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE); String SQLString="select* from ff where name='"+tuname+"'"; System.out.println(SQLString); sqlRst=sqlStmt.executeQuery(SQLString); while(sqlRst.next()){ java.sql.Blob blob=sqlRst.getBlob("data"); byte[] ab=blob.getBytes(1,(int)blob.length()); response.setContentType("image/gif"); response.reset(); op.write(ab); op.flush(); op.close(); }}catch(java.sql.SQLException e){ e.printStackTrace();}finally{ //if(preparedStmt!=null) preparedStmt.close(); if(sqlStmt!=null) sqlStmt.close(); if(conn!=null) conn.close();}%>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -