MySQL操作blob的经验研讨

 
 
 
 
 
 
 
 
 
 
id 
 
 
 
 
file
 
 
 
 
 
 
 
 
 
 
testblob.jsp(SUN企业级应用的首选) 
<%@ page contentType="text/html;charset=gb2312"%>　 
<%@ page import="java.sql.*" %> 
<%@ page import="java.util.*"%> 
<%@ page import="java.text.*"%> 
<%@ page import="java.io.*"%>　 
 
 
 
 
 
 
<% 
String id=request.getParameter("id"); 
String file=request.getParameter("file"); 
out.print(id); 
out.print(file); 
FileInputStream str=new FileInputStream(file); 
out.print(str.available()); 
java.sql.Connection conn; 
java.lang.String strConn; 
Class.forName("org.gjt.mm.MySQL(和PHP搭配之最佳组合).Driver").newInstance(); 
conn= java.sql.DriverManager.getConnection("jdbc:MySQL(和PHP搭配之最佳组合)://localhost/test","root",""); 
String sql="insert into test(id,pic) values(?,?)"; 
PreparedStatement pstmt=conn.prepareStatement(sql); 
pstmt.setString(1,id); 
pstmt.setBinaryStream(2,str,str.available()); 
pstmt.execute(); 
out.println("Success,You Have Insert an Image Successfully"); 
pstmt.close(); 
%> 
查看图片 
返回 
 
 
readblob.jsp(SUN企业级应用的首选) 
<%@ page contentType="text/html;charset=gb2312"%>　 
<%@ page import="java.sql.*, javax.sql.*" %> 
<%@ page import="java.util.*"%> 
<%@ page import="java.text.*"%> 
<%@ page import="java.io.*"%>　 
 
 
 
 
 
 
 
<% 
java.sql.Connection conn; 
ResultSet rs=null; 
Class.forName("org.gjt.mm.MySQL(和PHP搭配之最佳组合).Driver").newInstance(); 
conn= java.sql.DriverManager.getConnection("jdbc:MySQL(和PHP搭配之最佳组合)://localhost/test","root",""); 
Statement stmt=conn.createStatement(); 
rs=stmt.executeQuery("select * from test where id='1'"); 
if(rs.next()) 
{ 
Blob b = rs.getBlob("pic"); 
int size =(int)b.length(); 
out.print(size); 
InputStream in=b.getBinaryStream(); 
byte[] by= new byte[size]; 
response.setContentType("image/jpeg"); 
ServletOutputStream sos = response.getOutputStream(); 
int bytesRead = 0; 
while ((bytesRead = in.read(by)) != -1) { 
sos.write(by, 0, bytesRead); 
} 
in.close(); 
sos.flush(); 
} 
%>