如何用Java识别Oracle数据库中的zip压缩文件

import java.sql.*;
import java.io.*;
import java.util.zip.*;

public class OracleZipFileRecognition {

  public static void main(String[] args) {
    Connection conn = null;
    Statement stmt = null;
    ResultSet rs = null;

    try {
      // 连接到Oracle数据库
      Class.forName("oracle.jdbc.driver.OracleDriver");
      conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe", "username", "password");

      // 执行查询
      stmt = conn.createStatement();
      rs = stmt.executeQuery("SELECT zip_file FROM table_name WHERE condition = 'value'");

      // 处理查询结果
      while (rs.next()) {
        // 获取压缩文件数据
        InputStream zipData = rs.getBinaryStream("zip_file");

        // 解压缩文件
        ZipInputStream zipInputStream = new ZipInputStream(zipData);
        ZipEntry entry = zipInputStream.getNextEntry();

        while (entry != null) {
          // 处理解压缩后的文件
          String fileName = entry.getName();
          System.out.println("解压缩文件：" + fileName);

          // 读取文件内容
          ByteArrayOutputStream outputStream = new ByteArrayOutputStream();
          byte[] buffer = new byte[1024];
          int bytesRead;
          while ((bytesRead = zipInputStream.read(buffer)) != -1) {
            outputStream.write(buffer, 0, bytesRead);
          }

          // 输出文件内容
          System.out.println("文件内容：" + outputStream.toString("UTF-8"));

          // 关闭流
          outputStream.close();
          zipInputStream.closeEntry();
          entry = zipInputStream.getNextEntry();
        }

        // 关闭输入流
        zipInputStream.close();
      }

    } catch (ClassNotFoundException | SQLException | IOException e) {
      e.printStackTrace();
    } finally {
      // 关闭连接
      try {
        if (rs != null) rs.close();
        if (stmt != null) stmt.close();
        if (conn != null) conn.close();
      } catch (SQLException e) {
        e.printStackTrace();
      }
    }
  }
}