本地图片如何保存到mysql_将本地图片保存到数据库二进制存放

package toke;

import java.io.File;

import java.io.FileInputStream;

import java.io.FileOutputStream;

import java.io.IOException;

import java.io.InputStream;

import java.sql.*;

import sun.misc.BASE64Decoder;

import sun.misc.BASE64Encoder;

public class SaveEleName {

//封装读取图片的流

// 读取本地图片获取输入流

public static FileInputStream readImage(String path) throws IOException {

return new FileInputStream(new File(path));

}

// 读取表中图片获取输出流

public static void readBin2Image(InputStream in, String targetPath) {

File file = new File(targetPath);

String path = targetPath.substring(0, targetPath.lastIndexOf("/"));

if (!file.exists()) {

new File(path).mkdir();

}

FileOutputStream fos = null;

try {

fos = new FileOutputStream(file);

int len = 0;

byte[] buf = new byte[1024];

while ((len = in.read(buf)) != -1) {

fos.write(buf, 0, len);

}

fos.flush();

} catch (Exception e) {

e.printStackTrace();

} finally {

if (null != fos) {

try {

fos.close();

} catch (IOException e) {

e.printStackTrace();

}

}

}

}

/**

* @author Administrator 测试写入数据库以及从数据库中读取

*/

// 将图片插入数据库

public static void readImage2DB() {

String path = "E:/1.png";

String path1 = "E:/1.jpg";

Connection conn = null;

PreparedStatement ps = null;

FileInputStream in = null;

FileInputStream in1 = null;

try {

in =readImage(path);

in1 =readImage(path1);

conn = getConn();

String sql = "INSERT INTO ningbo_305 (Id, Code,DevicePlanPath) VALUES (?,?,?);";

ps = conn.prepareStatement(sql);

// '1', '1', '1', '1', '1', '1', '1', '1', '1', '11111', '2017-10-12 14:46:58', '1', '1'

ps.setString(1, "1");

ps.setString(2, "01");

// ps.setBinaryStream(3, in, in.available());

ps.setBinaryStream(3, in1, in1.available());

int count = ps.executeUpdate();

if (count > 0) {

System.out.println("插入成功！");

} else {

System.out.println("插入失败！");

}

} catch (Exception e) {

e.printStackTrace();

} finally {

closeConn(conn);

if (null != ps) {

try {

ps.close();

} catch (SQLException e) {

e.printStackTrace();

}

}

}

}

// 读取数据库中图片

public static void readDB2Image() {

String targetPath = "E:/image/1.jpg";

Connection conn = null;

PreparedStatement ps = null;

ResultSet rs = null;

try {

conn = getConn();

String sql = "select * from ningbo_303 where id =?";

ps = conn.prepareStatement(sql);

ps.setInt(1, 1);

rs = ps.executeQuery();

while (rs.next()) {

InputStream in = rs.getBinaryStream("ningbo_303");

readBin2Image(in, targetPath);

}

} catch (Exception e) {

e.printStackTrace();

} finally {

closeConn(conn);

if (rs != null) {

try {

rs.close();

} catch (SQLException e) {

e.printStackTrace();

}

}

if (ps != null) {

try {

ps.close();

} catch (SQLException e) {

e.printStackTrace();

}

}

}

}

// 定义数据库连接参数

public static final String DRIVER_CLASS_NAME = "com.mysql.jdbc.Driver";

public static final String URL = "jdbc:mysql://localhost:3306/dataexchange?useUnicode=true&characterEncoding=utf-8";

public static final String USERNAME = "root";

public static final String PASSWORD = "root";

// 注册数据库驱动

static {

try {

Class.forName(DRIVER_CLASS_NAME);

} catch (ClassNotFoundException e) {

System.out.println("注册失败！");

e.printStackTrace();

}

}

// 获取连接

public static Connection getConn() throws SQLException {

return DriverManager.getConnection(URL, USERNAME, PASSWORD);

}

// 关闭连接

public static void closeConn(Connection conn) {

if (null != conn) {

try {

conn.close();

} catch (SQLException e) {

System.out.println("关闭连接失败！");

e.printStackTrace();

}

}

}

/**

* 二进制流转Base64字符串

*

* @param data 二进制流

* @return data

* @throws IOException 异常

*/

public static String getImageString(byte[] data) throws IOException {

BASE64Encoder encoder = new BASE64Encoder();

return data != null ? encoder.encode(data) : "";

}

/**

* Base64字符串转 二进制流

*

* @param base64String Base64

* @return base64String

* @throws IOException 异常

*/

public static byte[] getStringImage(String base64String) throws IOException {

BASE64Decoder decoder = new sun.misc.BASE64Decoder();

return base64String != null ? decoder.decodeBuffer(base64String) : null;

}

public static void main(String[] args) {

readImage2DB();

// readDB2Image();

}

}