omendframe1.java~14~

JAVA超市管理系统

package project1;

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

public class OmendFrame1 extends JFrame //修改采购清单窗口
{
    ImageIcon image13 = new ImageIcon(project1.MainFrame.class.getResource("image15.png"));
    ImageIcon image20 = new ImageIcon(project1.MainFrame.class.getResource("image22.png"));
    ImageIcon image22 = new ImageIcon(project1.MainFrame.class.getResource("image24.png"));
    ImageIcon image21 = new ImageIcon(project1.MainFrame.class.getResource("image23.png"));
    ImageIcon image23 = new ImageIcon(project1.MainFrame.class.getResource("image25.png"));
    ImageIcon image24 = new ImageIcon(project1.MainFrame.class.getResource("image26.png"));
    public OmendFrame1() {
            super();
            setSize(450, 442);
            setLocation(250,120);
            setResizable(false);

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

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        panel.setBackground(Color.white);
        panel.setBounds(new Rectangle(1, 0, 466, 418));
        panel.setLayout(null);
        jLabel1.setIcon(image20);
        jLabel1.setText("");
        jLabel1.setBounds(new Rectangle(39, 83, 94, 32));
        jLabel2.setIcon(image22);
        jLabel2.setText("");
        jLabel2.setBounds(new Rectangle(56, 136, 91, 37));
        jLabel3.setIcon(image21);
        jLabel3.setText("");
        jLabel3.setBounds(new Rectangle(58, 195, 82, 29));
        jLabel4.setIcon(image23);
        jLabel4.setText("");
        jLabel4.setBounds(new Rectangle(57, 243, 83, 41));
        jLabel5.setIcon(image24);
        jLabel5.setText("");
        jLabel5.setBounds(new Rectangle(58, 305, 76, 26));
        jTextField1.setBounds(new Rectangle(152, 73, 242, 29));
        jTextField2.setBounds(new Rectangle(152, 129, 242, 29));
        jTextField3.setBounds(new Rectangle(152, 185, 242, 29));
        jTextField4.setBounds(new Rectangle(152, 241, 242, 29));
        jTextField4.addFocusListener(new OmendFrame1_jTextField4_focusAdapter(this));
        jTextField5.setBounds(new Rectangle(152, 297, 242, 29));
        jButton1.setBounds(new Rectangle(84, 355, 99, 36));
        jButton1.setText("确定");
        jButton1.addActionListener(new OmendFrame1_jButton1_actionAdapter(this));
        jButton2.setBounds(new Rectangle(258, 355, 99, 36));
        jButton2.setText("取消");
        jButton2.addActionListener(new OmendFrame1_jButton2_actionAdapter(this));
        jLabel6.setIcon(image13);
        jLabel6.setText("");
        jLabel6.setBounds(new Rectangle(52, 33, 79, 28));
        jTextField6.setText("");
        jTextField6.setBounds(new Rectangle(152, 21, 242, 29));
        this.getContentPane().add(panel);
        panel.add(jButton2);
        panel.add(jTextField3);
        panel.add(jTextField2);
        panel.add(jTextField6);
        panel.add(jTextField1);
        panel.add(jTextField5);
        panel.add(jTextField4);
        panel.add(jLabel2);
        panel.add(jLabel1);
        panel.add(jLabel6);
        panel.add(jLabel3);
        panel.add(jLabel4);
        panel.add(jLabel5);
        panel.add(jButton1);
        this.setTitle("修改采购清单");
    }

    JPanel panel = new JPanel();
    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JLabel jLabel3 = new JLabel();
    JLabel jLabel4 = new JLabel();
    JLabel jLabel5 = new JLabel();
    JTextField jTextField1 = new JTextField();
    JTextField jTextField2 = new JTextField();
    JTextField jTextField3 = new JTextField();
    JTextField jTextField4 = new JTextField();
    JTextField jTextField5 = new JTextField();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    JLabel jLabel6 = new JLabel();
    JTextField jTextField6 = 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 str1=jTextField1.getText();
     String str2=jTextField2.getText();
     String str3=jTextField3.getText();
     String str4=jTextField4.getText();
     String str5=jTextField5.getText();
     String str6=jTextField6.getText();
     String str="update 采购清单 set 订单号="+str6+",商品编码="+str1+",单位="+str3+",数量="+str2
     +",单价="+str4+",金额="+str5+"where 定单号='"+str6+"';";
           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("");
           jTextField2.setText("");
           jTextField3.setText("");
           jTextField4.setText("");
           jTextField5.setText("");
           jTextField6.setText("");
           JOptionPane.showMessageDialog(null,"采购清单项已成功修改");
     }

    public void jTextField4_focusLost(FocusEvent e) {
     String str1=jTextField2.getText();
     String str2=jTextField4.getText();
     float f1=Float.parseFloat(str1);
     float f2=Float.parseFloat(str2);
     float f=f1*f2;
     String sum=String.valueOf(f);
     jTextField5.setText(sum);
    }
}


class OmendFrame1_jTextField4_focusAdapter extends FocusAdapter {
    private OmendFrame1 adaptee;
    OmendFrame1_jTextField4_focusAdapter(OmendFrame1 adaptee) {
        this.adaptee = adaptee;
    }

    public void focusLost(FocusEvent e) {
        adaptee.jTextField4_focusLost(e);
    }
}


class OmendFrame1_jButton2_actionAdapter implements ActionListener {
    private OmendFrame1 adaptee;
    OmendFrame1_jButton2_actionAdapter(OmendFrame1 adaptee) {
        this.adaptee = adaptee;
    }

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


class OmendFrame1_jButton1_actionAdapter implements ActionListener {
    private OmendFrame1 adaptee;
    OmendFrame1_jButton1_actionAdapter(OmendFrame1 adaptee) {
        this.adaptee = adaptee;
    }

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