📄 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 + -