package?bean;

import?java.io.BufferedReader;
import?java.io.FileInputStream;
import?java.io.FileOutputStream;
import?java.io.InputStream;
import?java.io.InputStreamReader;
import?java.io.OutputStream;
import?java.io.OutputStreamWriter;

public?class?BackupAndRecorver?{

	public?boolean?backup（String?tableName）?{
		try?{
			Runtime?rt?=?Runtime.getRuntime（）;

			//?調用?mysql?的?cmd:
			Process?child?=?rt
					.exec（“C://Program?Files?（x86）//MySQL//MySQL?Server?5.5//bin//mysqldump?-uroot?-p123456??addressbook?linkman“）;
							//+?tableName）;//?設置導出編碼為utf8。這里必須是utf8

			//?把進程執行中的控制臺輸出信息寫入.sql文件，即生成了備份文件。注：如果不對控制臺信息進行讀出，則會導致進程堵塞無法運行
			InputStream?in?=?child.getInputStream（）;//?控制臺的輸出信息作為輸入流

			InputStreamReader?xx?=?new?InputStreamReader（in?“utf8“）;//?設置輸出流編碼為utf8。這里必須是utf8，否則從流中讀入的是亂碼

			String?inStr;
			StringBuffer?sb?=?new?StringBuffer（““）;
			String?outStr;
			//?組合控制臺輸出信息字符串
			BufferedReader?br?=?new?BufferedReader（xx）;
			while?（（inStr?=?br.readLine（））?!=?null）?{
				sb.append（inStr?+?“\r\n“）;
			}
			outStr?=?sb.toString（）;

			//?要用來做導入用的sql目標文件：
			FileOutputStream?fout?=?new?FileOutputStream（“E:/JSP/Address_Book/“+tableName+“.sql“）;
			OutputStreamWriter?writer?=?new?OutputStreamWriter（fout?“utf8“）;
			writer.write（outStr）;
			//?注：這里如果用緩沖方式寫入文件的話，會導致中文亂碼，用flush（）方法則可以避免
			writer.flush（）;

			//?別忘記關閉輸入輸出流
			in.close（）;
			xx.close（）;
			br.close（）;
			writer.close（）;
			fout.close（）;
			/*
			?*?System.out.println（““）;
			?*/
			return?true;
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
			return?false;
		}

	}

	public?boolean?load（String?tableName）?{
		try?{
			/*String?fPath?=?“E://JSP//Address_Book//address_book.sql“;*/
			String?fPath?=?“E:/JSP/Address_Book/“+tableName+“.sql“;
			Runtime?rt?=?Runtime.getRuntime（）;

			//?調用?mysql?的?cmd:
			Process?child?=?rt.exec（
					“C://Program?Files?（x86）//MySQL//MySQL?Server?5.5//bin//mysql.exe?-uroot?-p123456?addressbook?“）;
			OutputStream?out?=?child.getOutputStream（）;//?控制臺的輸入信息作為輸出流
			String?inStr;
			StringBuffer?sb?=?new?StringBuffer（““）;
			String?outStr;
			BufferedReader?br?=?new?BufferedReader（new?InputStreamReader（new?FileInputStream（fPath）?“utf8“））;
			while?（（inStr?=?br.readLine（））?!=?null）?{
				sb.append（inStr?+?“\r\n“）;
			}
			outStr?=?sb.toString（）;

			OutputStreamWriter?writer?=?new?OutputStreamWriter（out?“utf8“）;
			writer.write（outStr）;
			//?注：這里如果用緩沖方式寫入文件的話，會導致中文亂碼，用flush（）方法則可以避免
			writer.flush（）;
			//?別忘記關閉輸入輸出流
			out.close（）;
			br.close（）;
			writer.close（）;
			/*
			?*?System.out.println（““）;
			?*/

			return?true;
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
			return?false;
		}

	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????841??2015-12-28?10:24??Address_Book\.classpath

?????文件???????1045??2015-12-28?10:24??Address_Book\.project

?????文件????????567??2015-12-28?10:24??Address_Book\.settings\.jsdtscope

?????文件????????364??2015-12-28?10:24??Address_Book\.settings\org.eclipse.jdt.core.prefs

?????文件????????488??2015-12-28?10:24??Address_Book\.settings\org.eclipse.wst.common.component

?????文件????????345??2015-12-28?10:24??Address_Book\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2015-12-28?10:24??Address_Book\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2015-12-28?10:24??Address_Book\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????3209??2016-01-04?15:31??Address_Book\build\classes\bean\BackupAndRecorver.class

?????文件???????1543??2016-01-01?19:39??Address_Book\build\classes\bean\SearchBean.class

?????文件???????2935??2016-01-04?15:55??Address_Book\build\classes\bean\ShowBean.class

?????文件???????2682??2016-01-01?19:39??Address_Book\build\classes\bean\SqlQuery.class

?????文件???????1821??2016-01-01?19:39??Address_Book\build\classes\bean\SqlUpdate.class

?????文件???????3178??2016-01-01?19:39??Address_Book\build\classes\bean\TextShow.class

?????文件???????3073??2016-01-04?15:53??Address_Book\build\classes\servlet\AddServlet.class

?????文件???????2261??2016-01-01?19:39??Address_Book\build\classes\servlet\BackupServlet.class

?????文件???????2620??2016-01-01?19:39??Address_Book\build\classes\servlet\ChangePasswdServlet.class

?????文件???????2424??2016-01-04?15:24??Address_Book\build\classes\servlet\DelAllServlet.class

?????文件???????2845??2016-01-04?15:20??Address_Book\build\classes\servlet\DelServlet.class

?????文件???????1335??2016-01-01?21:30??Address_Book\build\classes\servlet\ExitServlet.class

?????文件???????3478??2016-01-04?15:54??Address_Book\build\classes\servlet\FormatServlet.class

?????文件???????3804??2016-01-04?14:52??Address_Book\build\classes\servlet\LoginServlet.class

?????文件???????2292??2016-01-01?19:53??Address_Book\build\classes\servlet\RecorverServlet.class

?????文件???????2604??2016-01-04?15:00??Address_Book\build\classes\servlet\RegisterServlet.class

?????文件???????4343??2016-01-04?15:54??Address_Book\build\classes\servlet\SearchServlet.class

?????文件???????5276??2016-01-04?15:54??Address_Book\build\classes\servlet\ShowAllServlet.class

?????文件???????4127??2016-01-01?19:39??Address_Book\build\classes\servlet\UpdateMeServlet.class

?????文件???????3606??2016-01-04?15:53??Address_Book\build\classes\servlet\UpdateServlet.class

?????文件???????2693??2016-01-01?19:39??Address_Book\build\classes\servlet\ValidationServlet.class

?????文件???????3219??2016-01-04?15:31??Address_Book\src\bean\BackupAndRecorver.java

............此處省略48個文件信息