Java implementation MySQL database backup (i)

After work, use your spare time to summarize how to use the Java language for MySQL database backup:

[Java]View PlainCopy

2. Import Java.io.BufferedReader;
4. Import Java.io.File;
6. Import Java.io.FileOutputStream;
8. Import java.io.IOException;
10. Import Java.io.InputStreamReader;
12. Import Java.io.OutputStreamWriter;
14. Import Java.io.PrintWriter;
18. /**
20. * MySQL Database backup
22. *
24. * @author Gaohuanjie
26. */
28. Public class Mysqldatabasebackup {
32. /** 
34. * Java code Implementation MySQL database export
36. *
38. * @author Gaohuanjie
40. * @param hostip MySQL database is located on the server address IP
42. * @param userName User name required to enter the database
44. * @param password The password required to enter the database
46. * @param savepath Database Export File save path
48. * @param filename Export file name of the filename database
50. * @param databaseName The name of the database to be exported
52. * @return returns True to indicate that the export was successful, otherwise false.
54. */
56. public Static boolean Exportdatabasetool (String HostIP, String userName, string password, string savepath, St Ring FileName, String databaseName) throws interruptedexception {
58. File SaveFile = new File (Savepath);
60. if (!savefile.exists ()) {//If the directory does not exist
62. Savefile.mkdirs (); //Create a folder
64. }
66. if (!savepath.endswith (File.separator)) {
68. Savepath = Savepath + file.separator;
70. }
74. PrintWriter printwriter = null;
76. BufferedReader BufferedReader = null;
78. try {
80. PrintWriter = new PrintWriter (Newoutputstreamwriter (new FileOutputStream (Savepath + fileName), "UTF8"  ));
82. Process process = Runtime.getruntime (). EXEC ("mysqldump-h" + HostIP + "-u" + userName + "-P" + Password + "  c3> "--set-charset=utf8" + databaseName);
84. InputStreamReader InputStreamReader = new InputStreamReader (Process.getinputstream (), "UTF8");
86. BufferedReader = new BufferedReader (InputStreamReader);
88. String Line;
90. While (line = Bufferedreader.readline ()) = null) {
92. Printwriter.println (line);
94. }
96. Printwriter.flush ();
98. if (process.waitfor () = = 0) {//0 indicates normal termination of the thread.
100. return true;
102. }
104. }catch (IOException e) {
106. E.printstacktrace ();
108. } finally {
110. try {
112. if (bufferedreader! = null) {
114. Bufferedreader.close ();
116. }
118. if (printwriter! = null) {
120. Printwriter.close ();
122. }
124. } catch (IOException e) {
126. E.printstacktrace ();
128. }
130. }
132. return false;
134. }
138. public static void Main (string[] args) {
140. try {
142. if (Exportdatabasetool ("172.16.0.127", "root", " 123456", "D:/backupdatabase", "2014-10-14.") SQL ", " test ")) {
144. SYSTEM.OUT.PRINTLN ("database successfully backed up!!!  ");
146. } Else {
148. SYSTEM.OUT.PRINTLN ("Database backup failed!!!  ");
150. }
152. } catch (Interruptedexception e) {
154. E.printstacktrace ();
156. }
158. }
160. }

Java implementation MySQL database backup (i)