deleteframe1.java~4~

JAVA超市管理系统

package project1;

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

public class DeleteFrame1 extends JFrame {
    ImageIcon image20 = new ImageIcon(project1.MainFrame.class.getResource("image22.png"));
    public DeleteFrame1() {
        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(1, 1, 399, 298));
        jPanel1.setLayout(null);
        jLabel1.setFont(new java.awt.Font("华文行楷", Font.PLAIN, 20));
        jLabel1.setForeground(new Color(87, 237, 108));
        jLabel2.setIcon(image20);
        jLabel2.setBounds(new Rectangle(17, 98, 90, 41));
        jTextField1.setBounds(new Rectangle(124, 97, 195, 27));
        jButton1.setBounds(new Rectangle(76, 177, 74, 34));
        jButton1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        jButton1.setForeground(new Color(87, 237, 108));
        jButton1.setText("确定");
        jButton1.addActionListener(new DeleteFrame1_jButton1_actionAdapter(this));
        jButton2.setBounds(new Rectangle(211, 177, 74, 34));
        jButton2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        jButton2.setForeground(new Color(87, 237, 108));
        jButton2.setText("取消");
        jButton2.addActionListener(new DeleteFrame1_jButton2_actionAdapter(this));
        this.getContentPane().add(jPanel1);
        jPanel1.add(jLabel2);
        jPanel1.add(jButton2);
        jPanel1.add(jButton1);
        jPanel1.add(jTextField1);
        jPanel1.add(jLabel1);
        jLabel1.setText("请输入要删除的商品的商品编码");
        jLabel1.setBounds(new Rectangle(9, 37, 299, 40));
    }

    JPanel jPanel1 = new JPanel();
    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JTextField jTextField1 = new JTextField();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    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( str );
               rs.close();
               st.close();
               con.close();
       }catch(Exception err){}
       jTextField1.setText("");
       JOptionPane.showMessageDialog(null,"成功删除商品编码为"+str+"的商品");
    }
}


class DeleteFrame1_jButton1_actionAdapter implements ActionListener {
    private DeleteFrame1 adaptee;
    DeleteFrame1_jButton1_actionAdapter(DeleteFrame1 adaptee) {
        this.adaptee = adaptee;
    }

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


class DeleteFrame1_jButton2_actionAdapter implements ActionListener {
    private DeleteFrame1 adaptee;
    DeleteFrame1_jButton2_actionAdapter(DeleteFrame1 adaptee) {
        this.adaptee = adaptee;
    }

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