利用JSP存取图片,数据库采用mysql转载_MySQL

Java代码

1. 一、数据库端操作：
2. 1 在mysql下建一个数据库名字叫 testpic
3. ===>
4. mysql>create database testpic;
6. 2 在testpic库下建一数据表test，只有两字段
7. ===>
8. mysql>use testpic;
10. ===>
11. mysql>create table test (id int, pic blob);

一、数据库端操作：1 在mysql下建一个数据库名字叫 testpic     ===> mysql>create database testpic;2 在testpic库下建一数据表test，只有两字段 ===> mysql>use testpic;                                          ===> mysql>create table test (id int, pic blob);

二、相关的html jsp文件
**********************************************************************************************
登录界面 postblob.html
Java代码

10. id
    file

  
    
id 
    
  
  
    
file
    
  
  
    
     

**********************************************************************************************
readblob.jsp界面源码
Java代码

1. <%@ page language="java" cOntentType="text/html; charset=UTF-8"
2. pageEncoding="UTF-8"%>
3. <%@ page import="java.sql.*, javax.sql.*" %>
4. <%@ page import="java.util.*"%>
5. <%@ page import="java.text.*"%>
6. <%@ page import="java.io.*"%>　
14. <%
16. java.sql.Connection conn;
17. ResultSet rs=null;
18. Class.forName("com.mysql.jdbc.Driver").newInstance();
19. cOnn= java.sql.DriverManager.getConnection("jdbc:mysql://localhost/testpic","root","root");
20. Statement stmt=conn.createStatement();
21. rs=stmt.executeQuery("select * from test where id=1");
22. if(rs.next())
23. {
24. Blob b = rs.getBlob("pic");
26. int size =(int)b.length();
27. out.print(size);
28. InputStream in=b.getBinaryStream();
29. byte[] by= new byte[size];
30. response.setContentType("image/jpeg");
31. ServletOutputStream sos = response.getOutputStream();
32. int bytesRead = 0;
33. while ((bytesRead = in.read(by)) != -1) {
34. sos.write(by, 0, bytesRead);
35. }
36. in.close();
37. sos.flush();
39. }
42. %>

<%@ page language="java" cOntentType="text/html; charset=UTF-8"    pageEncoding="UTF-8"%>    <%@ 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("com.mysql.jdbc.Driver").newInstance();    cOnn= java.sql.DriverManager.getConnection("jdbc:mysql://localhost/testpic","root","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();      }   %>

**********************************************************************************************
testblob.jsp界面源码
Java代码

1. <%@ page language="java" cOntentType="text/html; charset=UTF-8"
2. pageEncoding="UTF-8"%>
3. <%@ page import="java.sql.*" %>
4. <%@ page import="java.util.*"%>
5. <%@ page import="java.text.*"%>
6. <%@ page import="java.io.*"%>　
14. <%
15. String id=request.getParameter("id");
16. String file=request.getParameter("file");
17. out.print(id);
18. out.print(file);
19. FileInputStream str=new FileInputStream(file);
20. out.print(str.available());
21. java.sql.Connection conn;
22. java.lang.String strConn;
23. Class.forName("com.mysql.jdbc.Driver").newInstance();
24. cOnn= java.sql.DriverManager.getConnection("jdbc:mysql://localhost/testpic","root","root");
25. String sql="insert into test(id,pic) values(?,?)";
26. PreparedStatement pstmt=conn.prepareStatement(sql);
27. pstmt.setString(1,id);
28. pstmt.setBinaryStream(2,str,str.available());
29. pstmt.execute();
30. out.println("Success,You Have Insert an Image Successfully");
31. pstmt.close();
32. %>
33. 查看图片
34. 返回
36.