使用java进行mysql数据库的备份和恢复

/*
	 * 备份操作
	 */
	@Test
	public void testMySqlBackup(){
		String cmd = "cmd /c mysqldump -uroot -p111 cms";
		BufferedReader br = null;
		BufferedWriter bw = null;
		try {
			Process process = Runtime.getRuntime().exec(cmd);
			br = new BufferedReader(new InputStreamReader(process.getInputStream(),"UTF-8"));
			bw = new BufferedWriter(new FileWriter("F:\\SpingSourceTools\\cmsworkspace\\cms\\WebContent\\sql\\cms.sql"));
			String str = null;
			while((str=br.readLine())!= null){
				bw.write(str);
				bw.newLine();
			}
		} catch (IOException e) {
			e.printStackTrace();
		}finally{
			try {
				if(br!=null) br.close();
				if(bw!=null) bw.close();
			} catch (IOException e) {
				e.printStackTrace();
			}
		}
	}
	/*
	 * 恢复操作
	 */
	@Test
	public void testResume(){
		String cmd = "cmd /c mysql -uroot -p111 cms";
		BufferedReader br = null;
		BufferedWriter bw = null;
		try {
			Process process = Runtime.getRuntime().exec(cmd);
			bw = new BufferedWriter(new OutputStreamWriter(process.getOutputStream(), "UTF-8"));
			br = new BufferedReader(new FileReader("F:/SpingSourceTools/cmsworkspace/cms/WebContent/sql/cms.sql"));
			String str = null;
			while((str=br.readLine())!=null){
				bw.write(str);
				bw.newLine();
			}
		} catch (IOException e) {
			e.printStackTrace();
		}finally{
			try {
				if(br!=null) br.close();
				if(bw!=null) bw.close();
			} catch (IOException e) {
				e.printStackTrace();
			}
		}
	}