JSP 오라클 연동 사진파일 보여주기 소스

<%@ page language="java" contentType="image/jpeg"%>

<%@ page import= "java.sql.*" %>

<%@ page import= "java.io.*" %>

<%

String sabun = request.getParameter("sabun");

out.clear(); //  사용전에 비워줘야됨

out = pageContext.pushBody(); // 필요하다는데 없어도됨

Connection  conn = null;

Statement   stmt = null;

ResultSet   rs   = null;

InputStream is   = null;

OutputStream os  = response.getOutputStream();

String sql = "select photo from 테이블명 where sabun = '" +sabun+"'";

Class.forName("oracle.jdbc.driver.OracleDriver");

conn = DriverManager.getConnection("jdbc:oracle:thin:@IP주소:1521(포트명):SID명", "유저계정", "암호");

stmt = conn.createStatement();

rs = stmt.executeQuery(sql);

while(rs.next()){

 is = rs.getBinaryStream("PHOTO");

 

 int binaryRead;

 while((binaryRead=is.read()) != -1){

  os.write(binaryRead);

 }

}

os.flush();

conn.close();

stmt.close();

rs.close();

is.close();

os.close();

%>