stock_frame.java~91~

JAVA超市管理系统

               con.close();
           }catch(Exception err){
            err.printStackTrace(System.out);
        }


    }

    public void jButton2_actionPerformed(ActionEvent e) {
       jTextField10.setText("");
       jTextField11.setText("");
       jTextField12.setText("");
       jTextField13.setText("");
       jTextField14.setText("");
    }

    public void jTextField13_focusLost(FocusEvent e) {
     String am1=jTextField13.getText();
     int amount1= Integer.parseInt(am1);
     String am2=jTextField14.getText();
     float amount2=Float.parseFloat(am2);
     float sum=amount1*amount2;
     String money=String.valueOf(sum);
     jTextField12.setText(money);
    }

    public void jButton1_actionPerformed(ActionEvent e) {
           String RL = "jdbc:microsoft:sqlserver://localhost;DatabaseName=pos_mis";
           String user ="sa";
           String password = "220300124";
           String str1=jTextField2.getText();
           String str2=jTextField10.getText();
           String str3=jTextField11.getText();
           String str4=jTextField13.getText();
           String str5=jTextField14.getText();
           String str6=jTextField12.getText();
           String sqlStr = "insert into 采购清单 values('"+str1+"','"+str2+"','"+str3+"','"+str4+"','"
                           +str5+"','"+str6+"')";
           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){
         }
             jTextField10.setText("");
             jTextField11.setText("");
             jTextField12.setText("");
             jTextField13.setText("");
             jTextField14.setText("");
    }

    public void jMenuItem1_actionPerformed(ActionEvent e) {
    ViewTable1 vt=new ViewTable1();
    vt.show();
    }

    public void jMenuItem2_actionPerformed(ActionEvent e) {
    ViewTable2 vt=new ViewTable2();
    vt.show();
    }

    public void jMenuItem3_actionPerformed(ActionEvent e) {
        OosFrame o=new OosFrame();
        o.show();
    }

    public void jMenuItem4_actionPerformed(ActionEvent e) {
       ViewTable4 vt=new ViewTable4();
       vt.show();
    }

    public void jMenuItem5_actionPerformed(ActionEvent e) {
       ViewTable5 vt=new ViewTable5();
       vt.show();
    }

    public void jMenuItem8_actionPerformed(ActionEvent e) {
       OmendFrame1 of=new OmendFrame1();
       of.show();
    }

    public void jMenuItem9_actionPerformed(ActionEvent e) {
       OmendFrame2 of=new OmendFrame2();
       of.show();
    }

    public void jMenu6_actionPerformed(ActionEvent e) {
      this.dispose();
    }

    public void jMenu6_focusGained(FocusEvent e) {
    this.dispose();
    }

    public void jMenu6_keyPressed(KeyEvent e) {
   this.dispose();
    }

    public void jMenuItem10_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=jTextField6.getText();
        String str5=jTextField7.getText();
        String str6=jTextField8.getText();
        String str7=jTextField9.getText();
        String str8=jTextField4.getText();
        String str="insert into 采购单 values('"+str1+"','"+str2+"','"+str3+"','"+str4+"','"
                   +str5+"','"+str6+"','"+str7+"','"+str8+"')";
        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("");
        jTextField9.setText("");

    }
}


class Stock_Frame_jMenuItem10_actionAdapter implements ActionListener {
    private Stock_Frame adaptee;
    Stock_Frame_jMenuItem10_actionAdapter(Stock_Frame adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {

        adaptee.jMenuItem10_actionPerformed(e);
    }
}


class Stock_Frame_jMenuItem9_actionAdapter implements ActionListener {
    private Stock_Frame adaptee;
    Stock_Frame_jMenuItem9_actionAdapter(Stock_Frame adaptee) {
        this.adaptee = adaptee;
    }

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


class Stock_Frame_jMenuItem8_actionAdapter implements ActionListener {
    private Stock_Frame adaptee;
    Stock_Frame_jMenuItem8_actionAdapter(Stock_Frame adaptee) {
        this.adaptee = adaptee;
    }

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


class Stock_Frame_jMenuItem4_actionAdapter implements ActionListener {
    private Stock_Frame adaptee;
    Stock_Frame_jMenuItem4_actionAdapter(Stock_Frame adaptee) {
        this.adaptee = adaptee;
    }

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


class Stock_Frame_jMenuItem5_actionAdapter implements ActionListener {
    private Stock_Frame adaptee;
    Stock_Frame_jMenuItem5_actionAdapter(Stock_Frame adaptee) {
        this.adaptee = adaptee;
    }

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


class Stock_Frame_jMenuItem1_actionAdapter implements ActionListener {
    private Stock_Frame adaptee;
    Stock_Frame_jMenuItem1_actionAdapter(Stock_Frame adaptee) {
        this.adaptee = adaptee;
    }

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


class Stock_Frame_jMenuItem2_actionAdapter implements ActionListener {
    private Stock_Frame adaptee;
    Stock_Frame_jMenuItem2_actionAdapter(Stock_Frame adaptee) {
        this.adaptee = adaptee;
    }

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


class Stock_Frame_jMenuItem3_actionAdapter implements ActionListener {
    private Stock_Frame adaptee;
    Stock_Frame_jMenuItem3_actionAdapter(Stock_Frame adaptee) {
        this.adaptee = adaptee;
    }

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


class Stock_Frame_jButton1_actionAdapter implements ActionListener {
    private Stock_Frame adaptee;
    Stock_Frame_jButton1_actionAdapter(Stock_Frame adaptee) {
        this.adaptee = adaptee;
    }

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


class Stock_Frame_jTextField13_focusAdapter extends FocusAdapter {
    private Stock_Frame adaptee;
    Stock_Frame_jTextField13_focusAdapter(Stock_Frame adaptee) {
        this.adaptee = adaptee;
    }

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


class Stock_Frame_jButton2_actionAdapter implements ActionListener {
    private Stock_Frame adaptee;
    Stock_Frame_jButton2_actionAdapter(Stock_Frame adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {

        adaptee.jButton2_actionPerformed(e);
    }
}


class Stock_Frame_jTextField10_focusAdapter extends FocusAdapter {
    private Stock_Frame adaptee;
    Stock_Frame_jTextField10_focusAdapter(Stock_Frame adaptee) {
        this.adaptee = adaptee;
    }

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