Java mysql blob 数据读写操作

package com.lw.database;import java.io.FileInputStream;import java.io.FileOutputStream;import java.io.IOException;import java.io.InputStream;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;/** * CREATE: CREATE TABLE IDCard ( id char(18),pic BLOB); * @author fhadmin * from www.fhadmin.cn */public class LOBTest { protected static final String DEFAULT_URL = "jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf8"; protected static final String DRIVER_NAME = "com.mysql.jdbc.Driver";  private Connection connection = null;  public LOBTest() throws ClassNotFoundException, SQLException {  Class.forName(DRIVER_NAME);  connection = DriverManager.getConnection(DEFAULT_URL, "user", "password"); }  public void insert(String id,String path) throws SQLException, IOException {  PreparedStatement preparedStatement = connection.prepareStatement("INSERT INTO IDCard VALUES (?,?)");  preparedStatement.setString(1, id);  FileInputStream fileInputStream = new FileInputStream(path);  preparedStatement.setBlob(2, fileInputStream,fileInputStream.available());  preparedStatement.execute(); }  public void get(String id) throws SQLException, IOException {  PreparedStatement preparedStatement = connection.prepareStatement("SELECT pic FROM IDCard WHERE id = ?");  preparedStatement.setString(1, id);  ResultSet results = preparedStatement.executeQuery();  while(results.next()) {   FileOutputStream outputStream = new FileOutputStream("/Users/liuwei/temp.png");   InputStream inputStream = results.getBinaryStream(1);   int num = -1;   while((num=inputStream.read())!=-1) {    outputStream.write(num);   }   outputStream.flush();   inputStream.close();   outputStream.close();  } }  public static void main(String[] args) throws ClassNotFoundException, SQLException, IOException {  LOBTest test = new LOBTest();  test.insert("78907656784323", "/Users/liuwei/Documents/bt_next_nor.png");  test.get("78907656784323"); }}

 

注意：

　　MySQL的四种BLOB类型 

　　　　类型  大小(单位：字节) 

 　　　  TinyBlob  最大 255B

 　　     Blob  最大 ......

原文转载：http://www.shaoqun.com/a/852309.html

跨境电商：https://www.ikjzd.com/

环球易购：https://www.ikjzd.com/w/1034

parser：https://www.ikjzd.com/w/680

文化衫事件：https://www.ikjzd.com/w/1932

packagecom.lw.database;importjava.io.FileInputStream;importjava.io.FileOutputStream;importjava.io.IOException;importjava.io.InputStream;importjava.sql.Connection;importjava.sql.DriverManager;importjav
kk馆：https://www.ikjzd.com/w/1713
新手做亚马逊都有哪些坑？：https://www.ikjzd.com/articles/103910
亚马逊与联邦快递"七夕分手"：没有你我照样过得好！：https://www.ikjzd.com/articles/103912
现在做亚马逊是不是太晚了？什么人适合做亚马逊？：https://www.ikjzd.com/articles/103914
Wish蓝海产品类目分享2019（一）：法国蓝海产品类目：https://www.ikjzd.com/articles/103917
一下子就弄进去了岳 好湿好紧好浪好大好爽：http://lady.shaoqun.com/a/247919.html
老师慢慢张开腿坐上去 轻轻的顶开老师的两瓣：http://lady.shaoqun.com/m/a/247348.html
喜欢让人㖭我下面啊 女人口述被亲下面的感觉：http://www.30bags.com/m/a/249841.html
2021深圳粤港澳大湾区车展主办方是谁：http://www.30bags.com/a/477639.html
离异的孩子和父亲或母亲：http://lady.shaoqun.com/a/406833.html
"日常"这个词:all use[典故[；隐含的；引用]：http://lady.shaoqun.com/a/406834.html
零基础英语单词(提议、目的、谜题等。)：http://lady.shaoqun.com/a/406835.html