page.jsp

来自「这是一个基于J2EE的MVC model1架构的典型例子」· JSP 代码 · 共 47 行

JSP
47
字号
<%--     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 + =
减小字号Ctrl + -
显示快捷键?