JDBC-处理图片等大的字节数据

最新推荐文章于 2022-11-23 15:46:41 发布

飞洒地方HHHH

最新推荐文章于 2022-11-23 15:46:41 发布

阅读量208

点赞数 1

分类专栏： Java 文章标签： JDBC

本文链接：https://blog.csdn.net/u013400245/article/details/52809933

版权

Java 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

该博客演示了如何使用Java JDBC进行Blob类型数据的操作，包括从数据库读取和写入大字节流，如图片文件。示例代码展示了创建表、插入带有图片的记录以及从数据库读取并保存到本地文件的流程。

摘要由CSDN通过智能技术生成

import java.io.BufferedInputStream;
import java.io.BufferedOutputStream;
import java.io.BufferedReader;
import java.io.BufferedWriter;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.FileReader;
import java.io.FileWriter;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.io.Reader;
import java.io.Writer;
import java.sql.SQLException;

import com.mysql.jdbc.Clob;
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.PreparedStatement;
import com.mysql.jdbc.ResultSet;
import com.mysql.jdbc.Statement;


public class BlobTest {

	/**
	 * 
	 * 数据库中读写大的字节流
	 * @param args
	 * @throws SQLException 
	 * @throws IOException 
	 */
	public static void main(String[] args) throws SQLException, IOException {
		// TODO Auto-generated method stub
//		create();
		read();
	}
	
	static void create() throws SQLException, FileNotFoundException {
		Connection conn = null;
		PreparedStatement ps = null;	
		ResultSet rs = null;
		try {

			conn = JdbcUtil.getConnection();

			String sql = "insert into blob_t values(1 ,?)";
			
			ps = (PreparedStatement) conn.prepareStatement(sql);
			
			File file = new File("src/OK.jpg");
			InputStream input = new BufferedInputStream(new FileInputStream(file));

			ps.setBinaryStream(1, input, (int)file.length());
			
			int count = ps.executeUpdate();

			System.out.println(count + " row affected");
			
			try {
				input.close();
			} catch (IOException e) {
				e.printStackTrace();
			}

		} finally {
			JdbcUtil.free(rs, ps, conn);
		}
	}
	
	static void read() throws SQLException, IOException {
		Connection conn = null;
		Statement stat = null;
		ResultSet rs = null;
		try {

			conn = JdbcUtil.getConnection();

			stat = (Statement) conn.createStatement();

			rs = (ResultSet) stat.executeQuery("select blob_bit from blob_t");

			// 处理结果
			while (rs.next()) {
//				Clob clob =  (Clob) rs.getClob("blob_bit");
//				Reader reader  = clob.getCharacterStream();
				InputStream input = rs.getBinaryStream(1);
				File file = new File("OK_mysql.jpg");
				OutputStream output = new BufferedOutputStream(new FileOutputStream(file));
				byte[] buf = new byte[2048];
				int count = 0;
				while((count=input.read(buf)) >0 ){
					output.write(buf, 0, count);
				}
				output.close();
				input.close();
			}
		} finally {
			JdbcUtil.free(rs, stat, conn);
		}
	}

}

注意，对应的mysql属性段的类型为blob