java向mysql中插入音乐

java向mysql中插入音乐

环境

项目	版本
java	jdk-14.0.2
系统	ubuntu20.04
数据库	mysql8.0.23

步骤

准备数据

创建表：

create table `poc_oracle_conc` (
`col_uuid` varchar(40) character set utf8 collate utf8_bin not null,
`col_varchar_10` varchar(10) character set utf8 collate utf8_bin default null,
`col_varchar_4000` varchar(4000) character set utf8 collate utf8_bin default null,
`col_char_4000` char(10) character set utf8 collate utf8_bin default null,
`col_clob` longtext,
`col_blob` longblob,
`col_date` datetime default null,
`col_timestamp` datetime(6) default null,
`v_user` varchar(20) character set utf8 collate utf8_bin default null,
primary key (`col_uuid`)
) engine=greatdb default charset=utf8;

准备音频：自行准备即可.mp3

实施代码

package com.company;

import java.io.*;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class BatchInsert {

    // 将结果输出件
    public static class SayInFile {

        public void run() {
            try {
                //接收system.out.print输出内容，生成文件路径
                PrintStream ps_ansi = new PrintStream(
                        "/opt/java/program/BlobPic/src/com/company/case2.sql"
                );
                System.setOut(ps_ansi);
                e.printStackTrace();
            } catch (FileNotFoundException e) {
            }
        }
    }

    // 生成insert blob语句
    Main.ConnMysql conn = new Main.ConnMysql();

    public void run() throws SQLException, IOException {
        String[] arr_table = { "poc_oracle_conc", "poc_oracle_vol" };
        for (int i = 0; i < arr_table.length; i++) {
            for (
                    int j = 1;
                    j < 20956;
                    j++
            ) { // 20956
                PreparedStatement ps = conn
                        .run()
                        .prepareStatement(
                                "insert into " +
                                        arr_table[i] +
                                        "(col_uuid,col_varchar_10,col_varchar_4000,col_char_4000,col_blob,col_date,col_timestamp,v_user) values ((substring(MD5(RAND()),1,20)),(substring(MD5(RAND()),1,10)),substring(RAND(),1," +
                                        j +
                                        "),substring(MD5(rand()),1,10),?,now(),current_timestamp(),substring(MD5(rand()),1,20))"
                        );
                File file_avi = new File("/home/jiaona/文档/1003605.mp3");
                // input
                FileInputStream input_avi = new FileInputStream(file_avi);
                ps.setBinaryStream(1, input_avi, (int) file_avi.length());
                // 执行
                ps.executeUpdate();
                System.out.println("插入成功!");
                ps.close();
                input_avi.close();
            }
        }
    }

    public static void main(String[] args) throws IOException, SQLException {
        BatchInsert batch = new BatchInsert();
        Main.ConnMysql conn = new Main.ConnMysql();
        conn.run();
        SayInFile sif = new SayInFile();
        sif.run();
        batch.run();
    }
}

返回数据库查看表内容select * from poc_oracle_conc;

参考：https://www.matools.com/api/java8