omendframe2.java

JAVA超市管理系统

package project1;

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

public class OmendFrame2 extends JFrame //修改采购单
{
    ImageIcon image12 = new ImageIcon(project1.MainFrame.class.getResource("image14.png"));
    ImageIcon image13 = new ImageIcon(project1.MainFrame.class.getResource("image15.png"));
    ImageIcon image14 = new ImageIcon(project1.MainFrame.class.getResource("image16.png"));
    ImageIcon image15 = new ImageIcon(project1.MainFrame.class.getResource("image17.png"));
    ImageIcon image16 = new ImageIcon(project1.MainFrame.class.getResource("image18.png"));
    ImageIcon image17 = new ImageIcon(project1.MainFrame.class.getResource("image19.png"));
    ImageIcon image18 = new ImageIcon(project1.MainFrame.class.getResource("image20.png"));
    ImageIcon image19 = new ImageIcon(project1.MainFrame.class.getResource("image21.png"));

    public OmendFrame2() {
        super();
        setSize(598, 435);
        setLocation(250,110);
        setResizable(false);

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

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        jPanel1.setBackground(Color.white);
        jPanel1.setBounds(new Rectangle(0, 1, 592, 435));
        jPanel1.setLayout(null);
        jLabel1.setIcon(image12);
        jLabel1.setText("");
        jLabel1.setBounds(new Rectangle(7, 50, 95, 22));
        jTextField1.setText("");
        jTextField1.setBounds(new Rectangle(104, 40, 186, 26));
        jLabel2.setIcon(image13);
        jLabel2.setText("");
        jLabel2.setBounds(new Rectangle(300, 47, 75, 28));
        jTextField2.setText("");
        jTextField2.setBounds(new Rectangle(385, 40, 186, 26));
        jLabel3.setIcon(image14);
        jLabel3.setText("");
        jLabel3.setBounds(new Rectangle(20, 129, 78, 23));
        jTextField3.setText("");
        jTextField3.setBounds(new Rectangle(104, 120, 186, 26));
        jLabel4.setIcon(image15);
        jLabel4.setText("");
        jLabel4.setBounds(new Rectangle(290, 128, 89, 25));
        jTextField4.setText("");
        jTextField4.setBounds(new Rectangle(385,120, 186, 26));
        jLabel5.setIcon(image16);
        jLabel5.setText("");
        jLabel5.setBounds(new Rectangle(8, 198, 89, 24));
        jTextField5.setText("");
        jTextField5.setBounds(new Rectangle(104, 190, 186, 26));
        jLabel6.setIcon(image17);
        jLabel6.setText("");
        jLabel6.setBounds(new Rectangle(291, 193, 91, 30));
        jTextField6.setText("");
        jTextField6.setBounds(new Rectangle(385, 190, 186, 26));
        jLabel7.setIcon(image18);
        jLabel7.setText("");
        jLabel7.setBounds(new Rectangle(7, 268, 91, 28));
        jTextField7.setText("");
        jTextField7.setBounds(new Rectangle(104, 260, 186, 26));
        jLabel8.setIcon(image19);
        jLabel8.setText("");
        jLabel8.setBounds(new Rectangle(302, 268, 76, 25));
        jTextField8.setText("");
        jTextField8.setBounds(new Rectangle(385, 260, 186, 26));
        jButton1.setBounds(new Rectangle(171, 338, 85, 37));
        jButton1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        jButton1.setForeground(new Color(87, 237, 108));
        jButton1.setText("确定");
        jButton1.addActionListener(new OmendFrame2_jButton1_actionAdapter(this));
        jButton2.setBounds(new Rectangle(362, 339, 85, 37));
        jButton2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        jButton2.setForeground(new Color(87, 237, 108));
        jButton2.setText("取消");
        jButton2.addActionListener(new OmendFrame2_jButton2_actionAdapter(this));
        this.getContentPane().add(jPanel1);
        jPanel1.add(jTextField5);
        jPanel1.add(jTextField4);
        jPanel1.add(jTextField6);
        jPanel1.add(jTextField3);
        jPanel1.add(jTextField7);
        jPanel1.add(jTextField8);
        jPanel1.add(jTextField1);
        jPanel1.add(jTextField2);
        jPanel1.add(jLabel7);
        jPanel1.add(jLabel5);
        jPanel1.add(jLabel3);
        jPanel1.add(jLabel1);
        jPanel1.add(jLabel4);
        jPanel1.add(jLabel2);
        jPanel1.add(jLabel6);
        jPanel1.add(jLabel8);
        jPanel1.add(jButton2);
        jPanel1.add(jButton1);
        this.setTitle("修改采购单");
    }

    JPanel jPanel1 = new JPanel();
    JLabel jLabel1 = new JLabel();
    JTextField jTextField1 = new JTextField();
    JLabel jLabel2 = new JLabel();
    JTextField jTextField2 = new JTextField();
    JLabel jLabel3 = new JLabel();
    JTextField jTextField3 = new JTextField();
    JLabel jLabel4 = new JLabel();
    JTextField jTextField4 = new JTextField();
    JLabel jLabel5 = new JLabel();
    JTextField jTextField5 = new JTextField();
    JLabel jLabel6 = new JLabel();
    JTextField jTextField6 = new JTextField();
    JLabel jLabel7 = new JLabel();
    JTextField jTextField7 = new JTextField();
    JLabel jLabel8 = new JLabel();
    JTextField jTextField8 = 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 str1=jTextField1.getText();
       String str2=jTextField2.getText();
       String str3=jTextField3.getText();
       String str4=jTextField4.getText();
       String str5=jTextField5.getText();
       String str6=jTextField6.getText();
       String str7=jTextField7.getText();
       String str8=jTextField8.getText();
       String str="update 采购单 set 供应商代码="+str1+",订单号="+str2+",合同号="+str3+",订购日期="+str4+",到货日期="
                  +str5+",到货方式="+str6+",到货地点="+str7+",采购员="+str8+"where 订单号='"+str2+"';";
       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("");
       jTextField7.setText("");
       jTextField8.setText("");
       JOptionPane.showMessageDialog(null,"采购单已成功修改");
    }
}


class OmendFrame2_jButton1_actionAdapter implements ActionListener {
    private OmendFrame2 adaptee;
    OmendFrame2_jButton1_actionAdapter(OmendFrame2 adaptee) {
        this.adaptee = adaptee;
    }

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


class OmendFrame2_jButton2_actionAdapter implements ActionListener {
    private OmendFrame2 adaptee;
    OmendFrame2_jButton2_actionAdapter(OmendFrame2 adaptee) {
        this.adaptee = adaptee;
    }

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