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

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);

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.