revertpanel.java

自己做的超市管理系统

package shopingmanager;

import java.awt.BorderLayout;

import javax.swing.JPanel;
import java.awt.Dimension;
import javax.swing.JButton;
import java.awt.Rectangle;
import javax.swing.JLabel;
import javax.swing.JTextArea;
import javax.swing.BorderFactory;
import java.awt.Color;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.JOptionPane;
import java.awt.Font;
import java.awt.SystemColor;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2006</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class RevertPanel extends JPanel {
    public RevertPanel() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        this.setLayout(null);
        this.setOpaque(false);
        this.setPreferredSize(new Dimension(600, 450));
        btnOk.setBounds(new Rectangle(134, 194, 113, 32));
        btnOk.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        btnOk.setForeground(SystemColor.activeCaption);
        btnOk.setBorder(BorderFactory.createRaisedBevelBorder());
        btnOk.setOpaque(false);
        btnOk.setContentAreaFilled(false);
        btnOk.setText("确定");
        btnOk.addActionListener(new RevertPanel_btnOk_actionAdapter(this));
        txaRevert.setFont(new java.awt.Font("Dialog", Font.PLAIN, 16));
        txaRevert.setOpaque(false);
        txaRevert.setText("执行此功能必须要进行数据备份!");
        txaRevert.setBounds(new Rectangle(77, 83, 210, 33));
        this.add(btnOk);
        this.add(txaRevert);
    }

    JButton btnOk = new JButton();
    JTextArea txaRevert = new JTextArea();
    public void btnOk_actionPerformed(ActionEvent e) {
      int i= JOptionPane.showConfirmDialog(this,"您确定要还原数据库吗","警告", JOptionPane.OK_CANCEL_OPTION);
       if(i==JOptionPane.OK_OPTION)
         { //String sql = "sp_attach_db @dbname = 'ShopAssDataBase', @filename1 ='D:\\超市管理\\ShopAssDataBase_Data.MDF', @filename2 = 'D:\\超市管理\\ShopAssDataBase_Log.LDF' ";
             ConnectSQL s = new ConnectSQL("SuperMarketMIB");
            // s.ResultSql(sql);
            String sql="EXEC sp_detach_db 'SuperMarketMIB', 'true'";
             String sq="RESTORE DATABASE SuperMarketMIB FROM SuperMarketMIB_2";
             s.ResultSql(sql);
             s.ResultSql(sq);
             JOptionPane.showMessageDialog(this,"数据还原成功","提示", JOptionPane.OK_CANCEL_OPTION);
         }
    }
}


class RevertPanel_btnOk_actionAdapter implements ActionListener {
    private RevertPanel adaptee;
    RevertPanel_btnOk_actionAdapter(RevertPanel adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnOk_actionPerformed(e);
    }
}