java执行命令行的问题

博客专家认证

2012-08-23 05:21:18



StringBuilder result = new StringBuilder("");

        	result.append("cmd /c ");

        	result.append(" mysqldump ");

        	result.append(" -h192.168.1.241 ");

        	result.append(" -ukgoumovie ");

        	result.append(" -p1qaz2wsx");

        	result.append(" --default-character-set=gb2312 ");

        	result.append(" kgoumoviedb ");

        	result.append(" tzl_medias ");

        	result.append(" > ");

        	result.append(" e:/tzl_medias.sql");

            Process p = Runtime.getRuntime().exec(result.toString());

            p.waitFor();

我数据库有数据，执行了后文件也有，但是是空文件，何解？

...全文

187 10 打赏收藏转发到动态举报

写回复

用AI写文章

10 条回复

切换为时间正序

请发表友善的回复…

发表回复

scbb 2012-08-24

打赏
举报

[Quote=引用 2 楼的回复:]

引用 1 楼的回复:

还是不要用
exec(String cmd)这个方法
用exec(String[] cmd)吧！
把命令里空格分隔的部分分别存在数组的每一项里做。

能给个代码吗？谢谢
[/Quote]



public static void main(String[] args) {



		StringBuilder result = new StringBuilder("");

		result.append("cmd /c ");

		result.append(" mysqldump ");

		result.append(" -h192.168.1.241 ");

		result.append(" -ukgoumovie ");

		result.append(" -p1qaz2wsx");

		result.append(" --default-character-set=gb2312 ");

		result.append(" kgoumoviedb ");

		result.append(" tzl_medias ");

		result.append(" > ");

		result.append(" e:/tzl_medias.sql");

		

		String[] cmd = new String[] {"cmd", "/c", "mysqldump", "-h", "192.168.1.241",

				"-u", "kgoumovie", "-p",  "1qaz2wsx", "--default-character-set=gb2312",

				"kgoumoviedb", "tzl_medias", ">e:/tzl_medias.sql"};

		Process p;

		try {

			p = Runtime.getRuntime().exec(cmd);

			p.waitFor();

			int exitValue = p.exitValue();

			//System.out.println("exit: " + exitValue);

			if (exitValue != 0) {

				System.out.println(readInputStream(p.getErrorStream()));

			}

		} catch (Exception e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		}		



	}



	private static String readInputStream(InputStream is) throws IOException {



		BufferedReader br = new BufferedReader(new InputStreamReader(is,

				System.getProperty("sun.jnu.encoding")));



		StringBuffer lines = new StringBuffer();

		for (String line = br.readLine(); line != null; line = br.readLine()) {

			lines.append(line);

		}

		

		return lines.toString();   

	}