Java???MySQL???????
???????????? ???????[ 2017/2/14 10:42:44 ] ????????Java ???????
	????import java.io.BufferedReader; 
	????import java.io.File; 
	????import java.io.FileOutputStream; 
	????import java.io.IOException; 
	????import java.io.InputStreamReader; 
	????import java.io.OutputStreamWriter; 
	????import java.io.PrintWriter; 
	????/**
	????* MySQL???????
	????* 
	????*/ 
	????public class MySQLDatabaseBackup { 
	????/**
	????* Java???????MySQL???????
	????* 
	????* @author GaoHuanjie
	????* @param hostIP MySQL?????????????????IP
	????* @param userName ?????????????????????
	????* @param password ????????????????????
	????* @param savePath ??????????????·??
	????* @param fileName ???????????????
	????* @param databaseName ??????????????
	????* @return ????true??????????????????false??
	????*/ 
	????public static boolean exportDatabaseTool(String hostIP?? String userName?? String password?? String savePath?? String fileName?? String databaseName) throws InterruptedException { 
	????File saveFile = new File(savePath); 
	????if (!saveFile.exists()) {// ??????????? 
	????saveFile.mkdirs();// ????????? 
	????} 
	????if(!savePath.endsWith(File.separator)){ 
	????savePath = savePath + File.separator; 
	????} 
	????PrintWriter printWriter = null; 
	????BufferedReader bufferedReader = null; 
	????try { 
	????printWriter = new PrintWriter(new OutputStreamWriter(new FileOutputStream(savePath + fileName)?? "utf8")); 
	????Process process = Runtime.getRuntime().exec(" mysqldump -h" + hostIP + " -u" + userName + " -p" + password + " --set-charset=UTF8 " + databaseName); 
	????InputStreamReader inputStreamReader = new InputStreamReader(process.getInputStream()?? "utf8"); 
	????bufferedReader = new BufferedReader(inputStreamReader); 
	????String line; 
	????while((line = bufferedReader.readLine())!= null){ 
	????printWriter.println(line); 
	????} 
	????printWriter.flush(); 
	????if(process.waitFor() == 0){//0 ??????????????? 
	????return true; 
	????} 
	????}catch (IOException e) { 
	????e.printStackTrace(); 
	????} finally { 
	????try { 
	????if (bufferedReader != null) { 
	????bufferedReader.close(); 
	????} 
	????if (printWriter != null) { 
	????printWriter.close(); 
	????} 
	????} catch (IOException e) { 
	????e.printStackTrace(); 
	????} 
	????} 
	????return false; 
	????} 
	????public static void main(String[] args){ 
	????try { 
	????if (exportDatabaseTool("172.16.0.127"?? "root"?? "123456"?? "D:/backupDatabase"?? "2014-10-14.sql"?? "test")) { 
	????System.out.println("????????????????"); 
	????} else { 
	????System.out.println("???????????????"); 
	????} 
	????} catch (InterruptedException e) { 
	????e.printStackTrace(); 
	????} 
	????} 
	????} 
??????
					
					???·???
App??С????H5?????????????????Щ??
2024/9/11 15:34:34?????????????????????????
2024/9/10 11:13:49P-One ???????????????????????????????????????
2024/9/10 10:14:12???????????????????????????
2024/9/9 18:04:26??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44
					
			
								
								
								
								
								
								
								
								
								
								
				
sales@spasvo.com