如何将图片导入mysql数据库中

import java.io.File;
import java.io.FileInputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

public class ImageInsertion {
    public static void main(String[] args) {
        try {
            // 配置数据库连接信息
            String url = "jdbc:mysql://localhost:3306/database_name";
            String username = "username";
            String password = "password";

            // 加载MySQL JDBC驱动
            Class.forName("com.mysql.jdbc.Driver");

            // 建立数据库连接
            Connection connection = DriverManager.getConnection(url, username, password);

            // 准备插入图片的SQL语句
            String insertSql = "INSERT INTO image_table (image_name, image_data) VALUES (?, ?)";

            // 读取图片文件
            File imageFile = new File("path/to/image.jpg");
            FileInputStream fis = new FileInputStream(imageFile);

            // 创建预编译的语句对象
            PreparedStatement statement = connection.prepareStatement(insertSql);

            // 设置参数
            statement.setString(1, imageFile.getName());
            statement.setBinaryStream(2, fis, (int) imageFile.length());

            // 执行插入语句
            statement.executeUpdate();

            // 关闭连接和流
            statement.close();
            fis.close();
            connection.close();

            System.out.println("图片已成功导入数据库。");
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}