java将MP3文件存入数据库并取出

package jdbc.demo;

import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.InputStream;
import java.io.OutputStream;
import java.sql.Blob;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

import javax.sql.rowset.serial.SerialBlob;

import jdbc.utils.JdbcUtils;

import org.apache.commons.io.IOUtils;
import org.junit.Test;

/*
 * 对mp3进行处理
 */
public class BigDataDmeo {
	@Test
	public void saveMp3() throws Exception{
		Connection con = JdbcUtils.getConnection();
		//给出模板
		String sql = "insert into tab_bin values(?,?,?)";
		//创建pstmt
		PreparedStatement pstmt = con.prepareStatement(sql);
//		设置参数
		pstmt.setInt(1, 1);
		pstmt.setString(2, "独角戏.mp3");
		//把文件变成byte再创建Blob
		byte[] bytes = IOUtils.toByteArray(new FileInputStream("d:\\独角戏.mp3"));
		Blob blob = new SerialBlob(bytes);
		pstmt.setBlob(3, blob);
		
		pstmt.executeUpdate();
	}
	
	/*