mysql blob 字段_mysql blob字段存储图片操作示例

表结构：

create table view(id int unsigned NOT NULL AUTO_INCREMENT, catid int,title varchar(256),picture MEDIUMBLOB, content TEXT,PRIMARY KEY (id));

java类操作：

import java.awt.Image;

import java.io.*;

import java.nio.ByteBuffer;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.logging.Level;

import java.util.logging.Logger;

import javax.swing.ImageIcon;

import org.bean.View;

/**

*

* @author weijian.zhongwj

*/

public class ViewPointDao {

public static View getView(Integer catId) {

View view = new View();

try {

String sql2 = "SELECT title, content, picture FROM view where catid=? limit 1";

PreparedStatement stmt2 = BaseDaoFactory.getInstance().prepareStatement(sql2);

stmt2.setInt(1, catId);

ResultSet resultSet = stmt2.executeQuery();

while (resultSet.next()) {

String name = resultSet.getString(1);

String description = resultSet.getString(2);

ByteBuffer bb = ByteBuffer.allocate(1024 * 1024);

byte[] buffer = new byte[1];

InputStream is = resultSet.getBinaryStream(3);

while (is != null && is.read(buffer) > 0) {

bb.put(bu