tools.java

根据设定时间自动备份数据库。用java编写的

package com.oracle;
import java.io.*;
public class Tools{
	public  void runBat(String date){
        String cmd = "cmd /c start .\\com\\oracle\\expDatabase.bat";

        try{
            Process ps = Runtime.getRuntime().exec(cmd);
            cmd=null;
            System.out.println("--------begin execute success--date:"+date+"----");
        } catch(IOException ioe){
        	System.out.println("----------error-------");
            ioe.printStackTrace();
        }
    } 
    public  void printBat(OracleBack orabak,String date){
    	try{  
    	
    	  String batSql="exp "+orabak.userName+"/"+orabak.password+"@"+orabak.databaseName+" file="+orabak.backPath+"\\"+date+"_DB.dmp  log="+orabak.backPath+"\\"+date+".log owner=("+orabak.ownerUsers+")";   
    	  
	      PrintWriter   out=new   PrintWriter(new FileWriter(".\\com\\oracle\\expDatabase.bat"));   
	      out.println("@ ECHO OFF");
	      out.println("@ ECHO ---------------开始备份数据库----------------");
	      out.println(batSql);
	      out.println("@ ECHO -----------开始压缩备份文件-------------");
	      out.println("set path="+orabak.winRarPath);
	      out.println("rar a  "+orabak.backPath+"\\"+date+"_DB.rar  " +orabak.backPath+"\\"+date+"_DB.dmp");
	      out.println("@ ECHO -------------删除批处理-----------------");
	      out.println("del .\\com\\oracle\\expDatabase.bat");
	      out.println("exit");
	      batSql=null;
	      out.close();
	  	} catch(IOException ex){
	  		System.out.println("----------error-------");
	  	}   	
    } 
 
}