CREATE ? TABLE ?photo?(
photo_no? int ( 6 )?unsigned? NOT ? NULL ?auto_increment,
image ?blob,
PRIMARY ? KEY ?(`photo_no`)
)?

<% @?page?contentType = " text/html;?charset=gbk " ? %>
<% @?page? import = " java.io.* " %>
<% @?page? import = " java.sql.*,?javax.sql.* " ? %>
<% @?page? import = " java.util.* " %>
<% @?page? import = " java.math.* " %>

<%
?String?photo_no? = ?request.getParameter( " photo_no " );

? // mysql連接?
?Class.forName( " com.mysql.jdbc.Driver " ).newInstance();
?String?URL = " jdbc:mysql://localhost:3306/job?user=root&password=111111 " ;
?Connection?con? = ?DriverManager.getConnection(URL);

? // oracle連接?
? // String?URL="jdbc:oracle:thin@localhost:1521:orcl2";
? // user="system";
? // password="manager";
? // Connection?con?=?DriverManager.getConnection(URL,user,password);


? try {
?? // ?準備語句執行對象
??Statement?stmt? = ?con.createStatement();

??String?sql? = ? " ?SELECT?*?FROM?PHOTO?WHERE?photo_no?=? " + ?photo_no;
??ResultSet?rs? = ?stmt.executeQuery(sql);
?? if ?(rs.next())? {
???Blob?b? = ?rs.getBlob( " photo_image " );
??? long ?size? = ?b.length();
??? // out.print(size);
??? byte []?bs? = ?b.getBytes( 1 ,?( int )size);
???response.setContentType( " image/jpeg " );?
???OutputStream?outs? = ?response.getOutputStream();?
???outs.write(bs);
???outs.flush();
???rs.close();?
??}
?? else ? {
???rs.close();
???response.sendRedirect( " ./images/error.gif " );
??}
?}
? finally {
??con.close();
?}
%>

< HTML >
< HEAD >
< TITLE > ?圖像測試? </ TITLE >

</ HEAD >

< BODY >
< TABLE >
< TR >
< TD > 圖像測試 </ TD >
</ TR >
< TR >
< TD >< img? src ="show.jsp?photo_no=2" ></ TD >
</ TR >
</ TABLE >

</ BODY >
</ HTML >