dbutils.java

来自「短信系统SMS：支持普通短信、长短信和wap push短信的发送。」· Java 代码 · 共 54 行

package com.ekun.common.util;

import java.io.BufferedReader;
import java.io.OutputStreamWriter;
import java.io.InputStreamReader;
import java.io.BufferedWriter;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2006</p>
 *
 * <p>Company: </p>
 *
 * @author ekun
 * @version 1.0
 */
public class DBUtils
{
  /**
   * 调用Oracle 的 Sqlldr实现数据装载
   * @param strCMD String
   * @return boolean
   */
  public static boolean oraSqlLdr(String strCMD)
  {
    try
    {
      Process p = Runtime.getRuntime().exec(strCMD);
      BufferedReader br = new BufferedReader(new InputStreamReader(p.
          getInputStream()));
      BufferedWriter bw = new BufferedWriter(new OutputStreamWriter(p.
          getOutputStream()));
      String strLine;
      while ( (strLine = br.readLine()) != null)
      {
        System.out.println(strLine);
      }
      br.close();
      bw.write("exit\n");
      bw.close();
      p.waitFor();
      return true;
    }
    catch (Exception ex)
    {
      ex.printStackTrace();
      return false;
    }
  }
}