Cara Backup Export Database dengan Java Swing

Cara Backup Export Database dengan Java Swing

  7:30 AM    Unknown

---

esNesia | Bagi Anda-Anda yang sedang cari tahu bagaimanakah cara membuat backup database dengan cara simple menggunakn Jframe atau Swing menggunakan bahasa pemrograman java?
nah.. Anda sedang beruntung mengunjungi artikle ini. dalam artikle ini akan dijelaskan bagaimananya.. langsung saja ikuti tutorial berikut ini:

1. 
   
   
   
   1. Buatlah Form seperti gambar berikut
      
      
      
      
      
      
      
      
      
      

      Form backup database java

      
      
   
   
   2. Rubahlah nama variable jTextfield secara berurutan dengan  txt_host, txt_dbname, txt_username, txt_pass, dan txt_path
   
   
   3. Buatlah methode getBackUpPath() dalam class form yang Anda buat seperti ini :
      
      
      
      
      
      
      
      
      
      

      method getBackupPath()

      
      
   
   
   4. Klik kanan pada tombol Browse --> Event --> Action --> ActionPerformed, ketikkan kode txt_path.setText(getBackUpPath());
   
   
   5. Buatlah Class Backup.java
   
   
   
   

Backup.java

[package Database;

import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.JOptionPane;

public class Backup{

private static ResultSet res;
private static Connection con;
private Statement st;
private final int BUFFER = 99999;
public String getData(String host, String port, String user, String password, String db) {
String Mysqlpath = getMysqlBinPath(user, password, db);
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (Exception e) {
JOptionPane.showMessageDialog(null, e);
}
try {
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/" + db, user, password);
st = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,                                                                          ResultSet.CONCUR_UPDATABLE);
} catch (Exception e) {
JOptionPane.showMessageDialog(null, e);
}
JOptionPane.showMessageDialog(null, Mysqlpath);
Process run = null;
try {
System.out.println(Mysqlpath + "mysqldump --host=" + host + " --port=" + port +
" --user=" + user + " --password=" + password +
" --compact --complete-insert --extended-insert " +
"--skip-comments --skip-triggers " + db);
run = Runtime.getRuntime().exec(Mysqlpath + "mysqldump --host=" + host +
" --port=" + port + " --user=" + user + " --password=" +
password + "  " + "--skip-comments --skip-triggers " + db);
} catch (IOException ex) {
// Logger.getLogger(Backup.class.getName()).log(Level.SEVERE, null, ex);
}
InputStream in = run.getInputStream();
BufferedReader br = new BufferedReader(new InputStreamReader(in));
StringBuffer temp = new StringBuffer();
int count;
char[] cbuf = new char[BUFFER];
try {
while ((count = br.read(cbuf, 0, BUFFER)) != -1) {
temp.append(cbuf, 0, count);
}
} catch (IOException ex) {
Logger.getLogger(Backup.class.getName()
).log(Level.SEVERE, null, ex);
}
try {
br.close();
in.close();
} catch (IOException ex) {
Logger.getLogger(Backup.class.getName()
).log(Level.SEVERE, null, ex);
}
return temp.toString();
}
public  String getMysqlBinPath(String user, String password, String db) {
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (Exception e) {
e.printStackTrace();
System.out.print("yaha dekho");
}
try {
con = DriverManager.getConnection
("jdbc:mysql://localhost:3306/" + db, user, password);
st = con.createStatement
(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
} catch (Exception e) {
System.out.print("I am here yaaar");
e.printStackTrace();
}
String a = "";

try {
res = st.executeQuery("select @@basedir");
while (res.next()) {
a = res.getString(1);
}
} catch (Exception eee) {
eee.printStackTrace();
}
a = a + "bin\";
System.err.println("Mysql path is :" + a);
return a;
}
}]

1. Klik kanan pada tombol Export Databse  --> Event --> Action --> ActionPerformed, ketikkan kode
   
   
   
   
   
   
   
   
   
   

   Event Action Export Database

   
   


2. Selesai dan coba jalankan

semoga manfaat !

Read More