使用spring jdbctemplate插入blob

import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.SqlLobValue;
import org.springframework.jdbc.core.support.AbstractLobCreatingPreparedStatementCallback;
import org.springframework.jdbc.support.lob.DefaultLobHandler;
import org.springframework.jdbc.support.lob.LobCreator;

import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.Types;

public class BlobInsertExample {
    private JdbcTemplate jdbcTemplate;

    public void insertBlobData(byte[] blobData) {
        String sql = "INSERT INTO your_table (blob_column) VALUES (?)";

        jdbcTemplate.execute(sql, new AbstractLobCreatingPreparedStatementCallback(new DefaultLobHandler()) {
            protected void setValues(PreparedStatement ps, LobCreator lobCreator) throws SQLException {
                lobCreator.setBlobAsBytes(ps, 1, blobData);
            }
        });
    }

    // 其他代码...
}