deleteframe2.java~4~

JAVA超市管理系统

package project1;

import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import java.sql.*;

public class DeleteFrame2 extends JFrame {
    ImageIcon image13 = new ImageIcon(project1.MainFrame.class.getResource("image15.png"));
    public DeleteFrame2() {
        super();
        setSize(385,285);
        setResizable(false);
        setLocation(290,150);

        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        jPanel1.setBackground(Color.white);
        jPanel1.setBounds(new Rectangle( -2, 1, 438, 340));
        jPanel1.setLayout(null);
        jLabel2.setIcon(image13);
        jButton1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        jButton1.setForeground(new Color(87, 237, 108));
        jButton1.setMnemonic('0');
        jButton1.addActionListener(new DeleteFrame2_jButton1_actionAdapter(this));
        jButton2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        jButton2.setForeground(new Color(87, 237, 108));
        jButton2.addActionListener(new DeleteFrame2_jButton2_actionAdapter(this));
        this.getContentPane().add(jPanel1);
        jButton1.setBounds(new Rectangle(87, 193, 74, 34));
        jButton1.setText("确定");
        jButton2.setBounds(new Rectangle(245, 193, 74, 34));
        jButton2.setText("取消");
        jLabel2.setText("");
        jLabel2.setBounds(new Rectangle(38, 121, 86, 33));
        jTextField1.setText("");
        jTextField1.setBounds(new Rectangle(133, 115, 195, 27));
        jLabel1.setFont(new java.awt.Font("华文行楷", Font.PLAIN, 20));
        jLabel1.setForeground(new Color(87, 237, 108));
        jLabel1.setText("请输入要删除的采购单的订单号");
        jPanel1.add(jLabel1);
        jPanel1.add(jTextField1);
        jPanel1.add(jLabel2);
        jPanel1.add(jButton1);
        jPanel1.add(jButton2);
        jLabel1.setBounds(new Rectangle(22, 38, 304, 46));
    }

    JPanel jPanel1 = new JPanel();
    JLabel jLabel1 = new JLabel();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    JLabel jLabel2 = new JLabel();
    JTextField jTextField1 = new JTextField();
    public void jButton2_actionPerformed(ActionEvent e) {
    this.dispose();
    }

    public void jButton1_actionPerformed(ActionEvent e) {
        String RL = "jdbc:microsoft:sqlserver://localhost;DatabaseName=pos_mis";
            String user ="sa";
            String password = "220300124";
            String str=jTextField1.getText();
            String sqlStr="delete from 采购单 where 订单号='"+str+"'";
            try{
                   Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
                   Connection con = DriverManager.getConnection(RL,user,password);
                   Statement st = con.createStatement();
                   ResultSet rs =st.executeQuery( sqlStr );
                   rs.close();
                   st.close();
                   con.close();
           }catch(Exception err){}
           jTextField1.setText("");
           JOptionPane.showMessageDialog(null,"成功删除订单号为"+str+"的采购单");
    }
}


class DeleteFrame2_jButton1_actionAdapter implements ActionListener {
    private DeleteFrame2 adaptee;
    DeleteFrame2_jButton1_actionAdapter(DeleteFrame2 adaptee) {
        this.adaptee = adaptee;
    }

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


class DeleteFrame2_jButton2_actionAdapter implements ActionListener {
    private DeleteFrame2 adaptee;
    DeleteFrame2_jButton2_actionAdapter(DeleteFrame2 adaptee) {
        this.adaptee = adaptee;
    }

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