mysql存取图片实例_Java+MySql图片数据保存与读取的具体实例

1   mysql存储大容量的二进制文件的格式是blob，其实除了图片还可以存别的

2   要向数据库存储二进制的文件一定要把要存储的数据转换成二进制流

废话就不多说了，大家看看代码很容易明白，先来看一个app程序，当然首先您要在数据库中先建立一个用于保存图片的表和相应的列，数据格式为blob

2.编写图片流数据存取的工具类:

package jdbc.image;

import java.io.File;

import java.io.FileInputStream;

import java.io.FileNotFoundException;

import java.io.FileOutputStream;

import java.io.IOException;

import java.io.InputStream;

public class ImageUtil {

private static File file = null;

/**

* 从本地文件读取图像的二进制流

*

* @param infile

* @return

*/

public static FileInputStream getImageByte(String infile) {

FileInputStream imageByte = null;

file = new File(infile);

try {

imageByte = new FileInputStream(file);

} catch (FileNotFoundException e) {

e.printStackTrace();

}

return imageByte;

}

/**

* 将图片流读出为图片

*

* @param inputStream

* @param path

*/

public static void readBlob(InputStream inputStream, String path) {

try {

FileOutputStream fileOutputStream = new FileOutputStream(path);

byte[] buffer = new byte[1024];

int len = 0;

while ((len = inputStream.read(buffer)) != -1) {

fileOutputStream.write(buffer, 0, len);

}

inputStream.close();

fileOutputStream.close();

} catch (FileNotFoundException e) {

e.printStackTrace();

} catch (IOException e) {

e.printStackTrace();

}

}

}

3.将本地文件保存到数据库

需要添加MySql的数据库驱动--mysql-connector-java-5.1.24-bin.jar

package jdbc.image;

import java.io.IOException;

import java.io.InputStream;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.SQLException;

public class ImageInsert {

public static void main(String[] args) {

try {

Class.forName("com.mysql.jdbc.Driver").newInstance();

} catch (InstantiationException e) {

e.printStackTrace();

} catch (IllegalAccessException e) {

e.printStackTrace();

} catch (ClassNotFoundException e) {

e.printStackTrace();

}

String user = "root";

String password = "";

String url = "jdbc:mysql://192.168.1.100:3306/luxun?useUnicode=true&characterEncoding=utf-8";

Connection connection = null;

try {

connection = DriverManager.getConnection(url, user, password);

} catch (SQLException e) {

e.printStackTrace();

}

PreparedStatement preparedStatement = null;

InputStream inputStream = null;

inputStream = ImageUtil.getImageByte("/home/cristo/2.jpg");

try {

String sql = "insert into image(id,name,photo) values(?,?,?)";

preparedStatement = connection.prepareStatement(sql);

preparedStatement.setInt(1, 1);

preparedStatement.setString(2, "rtrerer");

preparedStatement.setBinaryStream(3, inputStream,

inputStream.available());

preparedStatement.execute();

} catch (SQLException e) {

e.printStackTrace();

} catch (IOException e) {

e.printStackTrace();

} finally {

try {

if (inputStream != null)

inputStream.close();

} catch (IOException e) {

e.printStackTrace();

} finally {

try {

if (preparedStatement != null)

preparedStatement.close();

} catch (SQLException e) {

e.printStackTrace();

} finally {

try {

connection.close();

} catch (SQLException e) {

e.printStackTrace();

}

}

}

}

}

}

4.从数据库中读取并生成图片

package jdbc.image;

import java.io.IOException;

import java.io.InputStream;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class ImageGet {

public static void main(String[] args) {

try {

Class.forName("com.mysql.jdbc.Driver").newInstance();

} catch (InstantiationException e) {

e.printStackTrace();

} catch (IllegalAccessException e) {

e.printStackTrace();

} catch (ClassNotFoundException e) {

e.printStackTrace();

}

String user = "root";

String password = "root";

String url = "jdbc:mysql://192.168.1.100:3306/luxun?useUnicode=true&characterEncoding=utf-8";

Connection connection = null;

try {

connection = DriverManager.getConnection(url, user, password);

} catch (SQLException e) {

e.printStackTrace();

}

Statement statement = null;

ResultSet resultSet = null;

InputStream inputStream = null;

try {

statement = connection.createStatement();

String sql = "select * from image where id = 1";

resultSet = statement.executeQuery(sql);

resultSet.next();

inputStream = resultSet.getBinaryStream("photo");

ImageUtil.readBlob(inputStream, "/home/cristo/52.jpg");

} catch (SQLException e) {

e.printStackTrace();

} finally {

try {

if (inputStream != null)

inputStream.close();

} catch (IOException e) {

e.printStackTrace();

} finally {

try {

if (resultSet != null)

resultSet.close();

} catch (SQLException e) {

e.printStackTrace();

} finally {

if (statement != null)

if (statement != null)

try {

statement.close();

} catch (SQLException e) {

e.printStackTrace();

} finally {

if (connection != null)

try {

connection.close();

} catch (SQLException e) {

e.printStackTrace();

}

}

}

}

}

}

}