执行命令zip加密文件

1. 在java code中调用以下代码：

Process process = Runtime.getRuntime().exec(new String[] { "/bin/csh", "-c","zip -P "+alarmKey+" "+zipName+" "+fileName });

2. 在PLSQL环境下：

2.1.在PLSQL code中可以先创建以下Store Procedure去调用java source code：

CREATE OR REPLACE PROCEDURE host_command (p_command  IN  VARCHAR2)
AUTHID Current_User
AS LANGUAGE JAVA
NAME 'Host.executeCommand (java.lang.String)';

2.2.在数据库中定义以下java source code：

create or replace and compile java source named host as
import java.io.*;
public class Host {
  public static void executeCommand(String command) {
    try {
      String[] finalCommand;
      if (isWindows()) {
        finalCommand = new String[4];
        // Use the appropriate path for your windows version.
        finalCommand[0] = "C:\\windows\\system32\\cmd.exe";  // Windows XP/2003
        //finalCommand[0] = "C:\\winnt\\system32\\cmd.exe";  // Windows NT/2000
        finalCommand[1] = "/y";
        finalCommand[2] = "/c";
        finalCommand[3] = command;
      }
      else {
        finalCommand = new String[3];
        finalCommand[0] = "/bin/sh";
        finalCommand[1] = "-c";
        finalCommand[2] = command;
      }
      final Process pr = Runtime.getRuntime().exec(finalCommand);
      pr.waitFor();
      new Thread(new Runnable(){
        public void run() {
          BufferedReader br_in = null;
          try {
            br_in = new BufferedReader(new InputStreamReader(pr.getInputStream()));
            String buff = null;
            while ((buff = br_in.readLine()) != null) {
              System.out.println("Process out :" + buff);
              try {Thread.sleep(100); } catch(Exception e) {}
            }
            br_in.close();
          }
          catch (IOException ioe) {
            System.out.println("Exception caught printing process output.");
            ioe.printStackTrace();
          }
          finally {
            try {
              br_in.close();
            } catch (Exception ex) {}
          }
        }
      }).start();
      new Thread(new Runnable(){
        public void run() {
          BufferedReader br_err = null;
          try {
            br_err = new BufferedReader(new InputStreamReader(pr.getErrorStream()));
            String buff = null;
            while ((buff = br_err.readLine()) != null) {
              System.out.println("Process err :" + buff);
              try {Thread.sleep(100); } catch(Exception e) {}
            }
            br_err.close();
          }
          catch (IOException ioe) {
            System.out.println("Exception caught printing process error.");
            ioe.printStackTrace();
          }
          finally {
            try {
              br_err.close();
            } catch (Exception ex) {}
          }
        }
      }).start();
    }
    catch (Exception ex) {
      System.out.println(ex.getLocalizedMessage());
    }
  }
  public static boolean isWindows() {
    if (System.getProperty("os.name").toLowerCase().indexOf("windows") != -1)
      return true;
    else
      return false;
  }
};

2.3.在Store Procedure中调用：

-- The following command Use for HK site.
--host_command (p_command => '/usr/bin/zip -P ' || v_RPT_PWD || ' -j ' || v_directory_path || v_zip_file_name || ' '|| v_directory_path || v_data_file_name );
-- The following command Use for testing.
host_command (p_command => 'zip -j '|| v_directory_path || v_zip_file_name || ' '|| v_directory_path || v_data_file_name );