package demo;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
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 java.sql.SQLException;
import javax.sql.rowset.serial.SerialBlob;
import org.apache.commons.io.IOUtils;
import org.junit.Test;
public class Demo {
//存放文件到数据库
@Test
public void fun1() throws SQLException, FileNotFoundException, IOException
{
Connection con=JdbcUtils.getConnection();
String sql="INSERT INTO music VALUES (?,?,?)";
PreparedStatement pps=con.prepareStatement(sql);
pps.setInt(1, 001);
pps.setString(2, "多啦A梦");
byte [] bytes=IOUtils.toByteArray(new FileInputStream("D://A梦.mp3"));
Blob blob=new SerialBlob(bytes);
pps.setBlob(3, blob);
pps.executeUpdate();
从数据库存储mp3和提取mp3
最新推荐文章于 2024-05-16 09:27:32 发布