mysql blob无法显示二进制文件_mysql用blob添加二进制文件，歌曲，图片，电影

package Io流;

import Utils.JdbcUtils;

import org.junit.Test;

import java.io.*;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

/**

* Blob字节

* 1、MySQL有四种BLOB类型:

* 　　·tinyblob:仅255个字符

* 　　·blob:最大限制到65K字节

* 　　·mediumblob:限制到16M字节

* 　　·longblob:可达4GB

*/

public class Demo09 {

@Test

public void test(){

String sql = null;

Connection con = null;

PreparedStatement ps = null;

ResultSet rs = null;

int updateRow = 0;

FileInputStream fis = null;

try {

sql = "insert into data_blob values (?,?,?)";

con = JdbcUtils.getCon();

ps = con.prepareStatement(sql);

ps.setInt(1,1);

ps.setString(2,"tom");

File file = new File("d:\\可可托海的牧羊人 - 王琪.mp3");

fis = new FileInputStream(file);

ps.setBinaryStream(3,fis,file.length());

updateRow = ps.executeUpdate();

if (updateRow > 0){

System.out.println("success");

}

} catch (Exception e) {

e.printStackTrace();

} finally {

try {

fis.close();

} catch (IOException e) {

e.printStackTrace();

}

JdbcUtils.close(con,ps,rs);

}

}

@Test

public void test1(){

String sql = null;

Connection con = null;

PreparedStatement ps = null;

ResultSet rs = null;

int updateRow = 0;

FileOutputStream fos = null;

int len = 0;

try {

sql = "select * from data_blob where id=?";

con = JdbcUtils.getCon();

ps = con.prepareStatement(sql);

ps.setInt(1,1);

rs = ps.executeQuery();

if (rs.next()){

InputStream songs = rs.getBinaryStream("songs");

fos = new FileOutputStream("resoures\\歌曲.mp4");

byte[] bytes = new byte[1024];

while ((len = songs.read(bytes))!= -1){

fos.write(bytes,0,len);

}

}

System.out.println("success");

} catch (Exception e) {

e.printStackTrace();

} finally {

try {

fos.close();

} catch (IOException e) {

e.printStackTrace();

}

JdbcUtils.close(con,ps,rs);

}

}

}