java中用process备份还原mysql数据库

/**
* 备份数据库.
*/
public int dataBack(String sqldir,String dbname,String dbpwd,String filename,String filedir){
   int flag2=0;
   try{
    String batdir=System.getProperty("user.dir")+"\\DataBack.bat";
    log.info("bat file path=========>"+batdir);
    Process process=Runtime.getRuntime().exec(batdir+" "+sqldir+" "+dbname+" "+dbpwd+" "+filename+" "+filedir);
    String line=null;
    BufferedReader reader=new BufferedReader(new InputStreamReader(process.getInputStream()));
    while((line=reader.readLine())!=null){
     log.info(line);
    }
    flag2=1;
   }catch(Exception ex){

   }
   return flag2;
}

/**
* 还原数据库.
*/
public int dataRestore(String sqldir,String dbname,String dbpwd,String filename,String filedir){
   int flag3=0;
   try{
    String batdir=System.getProperty("user.dir")+"\\DataRestore.bat";
        Process process =Runtime.getRuntime().exec(batdir+" "+sqldir+" "+dbname+" "+dbpwd+" "+filename+" "+filedir);
            String line = null;
            BufferedReader reader = new BufferedReader(new InputStreamReader(process.getInputStream()));
            while((line = reader.readLine()) != null)
            {
                System.out.println(line);
                flag3=1;
            }

   }catch(Exception ex){
    ex.printStackTrace();
   }
   return flag3;
}

.bat 文件如下：

DataBack.bat如下：

if "%2"=="root" goto 1
if "%3"=="root" goto 2
if "%4"=="root" goto 3
if "%5"=="root" goto 4
if "%6"=="root" goto 5
:1
"%1\bin\mysqldump" -u%2 -p%3 --database OnlineExamSystem > %5\%4
goto 6
:2
"%1 %2\bin\mysqldump" -u%3 -p%4 --database OnlineExamSystem > %6\%5
goto 6
:3
"%1 %2 %3\bin\mysqldump" -u%4 -p%5 --database OnlineExamSystem > %7\%6
goto 6
:4
"%1 %2 %3 %4\bin\mysqldump" -u%5 -p%6 --database OnlineExamSystem > %8\%7
goto 6
:5
"%1 %2 %3 %4 %5\bin\mysqldump" -u%6 -p%7 --database OnlineExamSystem > %9\%8
:6

DataRestore.bat如下；

if "%2"=="root" goto 1
if "%3"=="root" goto 2
if "%4"=="root" goto 3
if "%5"=="root" goto 4
if "%6"=="root" goto 5
:1
"%1\bin\mysql" -u%2 -p%3 < %5\%4
goto 6
:2
"%1 %2\bin\mysql" -u%3 -p%4 < %6\%5
goto 6
:3
"%1 %2 %3\bin\mysql" -u%4 -p%5 < %7\%6
goto 6
:4
"%1 %2 %3 %4\bin\mysql" -u%5 -p%6< %8\%7
goto 6
:5
"%1 %2 %3 %4 %5\bin\mysql" -u%6 -p%7< %9\%8
:6