jdbc处理mysql大数据类型

try (Connection conn = DriverManager.getConnection(url, username, password);
     PreparedStatement pstmt = conn.prepareStatement("SELECT blob_column FROM table WHERE id = ?");
     InputStream inputStream;
     OutputStream outputStream) {
    pstmt.setInt(1, 1);
    ResultSet rs = pstmt.executeQuery();
    if (rs.next()) {
        inputStream = rs.getBinaryStream("blob_column");
        outputStream = new FileOutputStream("output.jpg");
        byte[] buffer = new byte[1024];
        int bytesRead;
        while ((bytesRead = inputStream.read(buffer)) != -1) {
            outputStream.write(buffer, 0, bytesRead);
        }
    }
} catch (SQLException | IOException e) {
    e.printStackTrace();
}

try (Connection conn = DriverManager.getConnection(url, username, password);
     PreparedStatement pstmt = conn.prepareStatement("INSERT INTO table (blob_column) VALUES (?)")) {
    File file = new File("input.jpg");
    try (FileInputStream fis = new FileInputStream(file)) {
        pstmt.setBinaryStream(1, fis, (int) file.length());
        pstmt.executeUpdate();
    }
} catch (SQLException | IOException e) {
    e.printStackTrace();
}