java导入导出mysql库或者某个表

项目的奇葩要求 要求从前端导出导出mysql数据 直接沾吧

import java.io.IOException;
import java.io.InputStream;
import java.util.Properties;

public class Data {
	/**
	 * 解析配置文件`
	 * 
	 * @param proName
	 * @return
	 */

	static String user = "root";
	static String password ="root";
	static String exportDatabaseName ="testdatasource";
	static String table ="zbss";
	static String exportPath = "D:\\sql\\"+table+".sql";
	static String host ="localhost";



	public static void exportSql() {

		System.out.println("执行命令");
		String command = new String(
				"cmd /k mysqldump -u " + user + " -p" + password + " " + exportDatabaseName +" >" + exportPath);//导出库
	//			"cmd /k mysqldump -u " + user + " -p" + password + " " + exportDatabaseName +" "+table+">" + exportPath);导出某个表
//		mysqldump -u wcnc -p smgp_apps_wcnc users> wcnc_users.sql
		String cm="cmd /k start";
		System.out.println(command);
		Runtime runtime = Runtime.getRuntime();

		try {
			Process process = runtime.exec(command);
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

	}

	public static void main(String[] args) {
	
	   exportSql();
	  //importSql();
	}
	
	
	public static void importSql() {


		System.out.println("执行命令");
		String command = new String(
				"cmd /k mysql"+" -h"+host+" -u"+user+" -p"+password+" "+exportDatabaseName+" <"+exportPath);
	
		System.out.println(command);
		Runtime runtime = Runtime.getRuntime();

		try {
			Process process = runtime.exec(command);
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

	}
	
}