datacopypanel.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.JSlider;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.JOptionPane;
import javax.swing.JTextArea;
import java.awt.Font;
import javax.swing.BorderFactory;
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 DataCopyPanel extends JPanel {
    public DataCopyPanel() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        this.setLayout(null);
        this.setOpaque(false);
        this.setPreferredSize(new Dimension(600, 450));
        btnCopy.setBounds(new Rectangle(140, 178, 127, 35));
        btnCopy.setForeground(SystemColor.activeCaption);
        btnCopy.setBorder(BorderFactory.createRaisedBevelBorder());
        btnCopy.setOpaque(false);
        btnCopy.setContentAreaFilled(false);
        btnCopy.setText("数据备份");
        btnCopy.addActionListener(new DataCopyPanel_btnCopy_actionAdapter(this));
        txaCopy.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        txaCopy.setOpaque(false);
        txaCopy.setText("运行此系统之后,建议每次备份系统,以做他日只需!");
        txaCopy.setBounds(new Rectangle(41, 99, 318, 49));
        this.add(btnCopy);
        this.add(txaCopy);
    }

    JButton btnCopy = new JButton();
    JTextArea txaCopy = new JTextArea();
    public void btnCopy_actionPerformed(ActionEvent e) {
        String sql="USE SuperMarketMIB exec sp_addumpdevice 'DISK', 'SuperMarketMIB_1','C:\\Program Files\\Microsoft SQL Server\\MSSQL\\BACKUP' BACKUP DATABASE SuperMarketMIB TO SuperMarketMIB_1";
        int i= JOptionPane.showConfirmDialog(this,"您确定要备份数据库吗","警告", JOptionPane.OK_CANCEL_OPTION);
       if(i==JOptionPane.OK_OPTION)
       {
           ConnectSQL conn=new ConnectSQL("SuperMarketMIB");
           conn.ResultSql(sql);
           JOptionPane.showMessageDialog(this,"数据备份成功","提示", JOptionPane.OK_CANCEL_OPTION);
       }
    }
}


class DataCopyPanel_btnCopy_actionAdapter implements ActionListener {
    private DataCopyPanel adaptee;
    DataCopyPanel_btnCopy_actionAdapter(DataCopyPanel adaptee) {
        this.adaptee = adaptee;
    }

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