package gui.listener;

import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.io.File;
import java.io.IOException;

import javax.swing.JFileChooser;
import javax.swing.JOptionPane;
import javax.swing.filechooser.FileFilter;

import gui.panel.BackupPanel;
import gui.panel.ConfigPanel;
import gui.panel.MainPanel;
import service.ConfigService;
import util.MysqlUtil;

public class RecoverListener implements ActionListener {

	@Override
	public void actionPerformed(ActionEvent e) {
		BackupPanel p  =BackupPanel.instance;
		String mysqlPath= new ConfigService().get(ConfigService.mysqlPath);
		if(0==mysqlPath.length()){
			JOptionPane.showMessageDialog(p, "恢复前请事先配置mysql的路径");
			MainPanel.instance.workingPanel.show(ConfigPanel.instance);
			ConfigPanel.instance.tfMysqlPath.grabFocus();
			return;
		}
		JFileChooser fc = new JFileChooser();
		fc.setSelectedFile(new File("hutubill.sql"));
		fc.setFileFilter(new FileFilter() {
			
			@Override
			public String getDescription() {
				return ".sql";
			}
			
			@Override
			public boolean accept(File f) {
				return f.getName().toLowerCase().endsWith(".sql");
			}
		});

		 int returnVal =  fc.showOpenDialog(p);
         File file = fc.getSelectedFile();
         System.out.println(file);
         if (returnVal == JFileChooser.APPROVE_OPTION) {
    		try {
    			MysqlUtil.recover(mysqlPath,file.getAbsolutePath());
//				MysqlUtil.recover(mysqlPath, file.getAbsolutePath());
				JOptionPane.showMessageDialog(p, "恢复成功");
			} catch (Exception e1) {
				e1.printStackTrace();
				JOptionPane.showMessageDialog(p, "恢复失败\r\n,错误:\r\n"+e1.getMessage());	
			}
        	 
         }		
	}

}

package gui.panel;

import javax.swing.JButton;

import gui.listener.RecoverListener;
import util.ColorUtil;
import util.GUIUtil;

public class RecoverPanel extends WorkingPanel {
	static{
		GUIUtil.useLNF();
	}
	public static RecoverPanel instance = new RecoverPanel();

	JButton bRecover =new JButton("恢复");

	public RecoverPanel() {

		GUIUtil.setColor(ColorUtil.blueColor, bRecover);
		this.add(bRecover);
		
		addListener();
	}

	public static void main(String[] args) {
		GUIUtil.showPanel(RecoverPanel.instance);
	}

	@Override
	public void updateData() {
		// TODO Auto-generated method stub
		
	}

	@Override
	public void addListener() {
		RecoverListener listener = new RecoverListener();
		bRecover.addActionListener(listener);
	}

}