程序中调用批处理执行Mysql数据库导入导出

最新推荐文章于 2022-06-15 09:26:20 发布

comeonliming

最新推荐文章于 2022-06-15 09:26:20 发布

阅读量9.7k

点赞数

分类专栏： java 文章标签： MySQL SQL Server SQL C C++

java 专栏收录该内容

13 篇文章 0 订阅

订阅专栏

     /**
     * @param cmdStr
     * @return
     */
    public static void exec(String cmdStr)throws IOException {
    //��ʽ��ִ�е�exe Ŀ¼           ��"cmd.exe","   dir"
//        String cmd = "cmd /c start C:/WSCA-ENU-06-12/setpassword.bat";
         String cmd="cmd /c start "+cmdStr;

            Process ps = Runtime.getRuntime().exec(cmd);
            System.out.print(loadStream(ps.getInputStream()));
            System.err.print(loadStream(ps.getErrorStream()));

    }

------------------------------------------------------------------------------------------------------

import.cmd

set path=d:/axonsams.sql
set path="C:\Program Files\MySQL\MySQL Server 5.0\bin"

@ECHO OFF
CLS

ECHO.
ECHO.
ECHO.
ECHO 进入Mysql目录....
ECHO
pause
ECHO 数据库正在执行中....
mysql --host=localhost --user=root --password=liming -D mysql <%sql%
ECHO.
ECHO 数据库执行完毕
ECHO.
pause
exit

------------------------------------------------------------------------------------------------------

export.bat

set path="C:\Program Files\MySQL\MySQL Server 5.0\bin"
@ECHO OFF
CLS

ECHO.
ECHO.
ECHO.

ECHO 进入Mysql目录....
ECHO.
ECHO.
ECHO 数据库正在保存中....
mysqldump --host=localhost --user=root --password=liming axonsams>d:\axonsams%DATE:~0,4%%DATE:~5,2%%DATE:~8,2%.sql
ECHO.
ECHO.
ECHO 数据库保存路径为ID:\axonsams%DATE:~0,4%%DATE:~5,2%%DATE:~8,2%.sql
ECHO.
ECHO.

exit