syyck.java

程序名称（小型超市前台收款系统）压缩包内包含源文件和数据库

            add(lsrxmm);lsrxmm.setBounds(70, 80, 90, 22);
            add(tfsrxmm);tfsrxmm.setBounds(200, 80, 110, 22);
            tfsrxmm.enableInputMethods(false);
            tfsrxmm.setEchoChar('*');
            add(lcfxmm);lcfxmm.setBounds(70, 110, 130, 22);
            add(tfcfxmm);tfcfxmm.setBounds(200, 110, 110, 22);
            tfcfxmm.setEchoChar('*');
            tfcfxmm.enableInputMethods(false);
            add(bxg);bxg.setBounds(110, 150, 57, 26);
            bxg.addActionListener(this);
            add(bqx);bqx.setBounds(200, 150, 57, 26);
            bqx.addActionListener(this);
            add(lts);lts.setBounds(70, 180, 240, 22);lts.setAlignment(java.awt.Label.CENTER);
            addWindowListener(new WindowAdapter(){
                public void windowClosing(WindowEvent e2){
                    dispose();
                    syyck.tfsrtxm.requestFocus();
                }
            });
            setVisible(true);
        }
        public void actionPerformed(ActionEvent e){
            if(e.getSource()==bxg){
                if(!tfsrjmm.getText().equals("")&&!tfsrxmm.getText().equals("")&&!tfcfxmm.getText().equals("")){
                try{
                    Class.forName(drivers);
                    Connection con=DriverManager.getConnection(url);
                    Statement stmt=con.createStatement();
                    String sql="select *  from zhb where 帐号='"+syyck.zhanghao+"' and 密码='"+tfsrjmm.getText()+"'";
                    String sql1="Update zhb set 密码='"+tfsrxmm.getText()+"' where 帐号='"+syyck.zhanghao+"'";
                    ResultSet rs=stmt.executeQuery(sql);
                    if(rs.next()){
                        if(tfsrxmm.getText().length()<=20){
                        if(tfsrxmm.getText().equals(tfcfxmm.getText())){
                            stmt.executeUpdate(sql1);
                            tfsrjmm.setText("");
                            tfsrxmm.setText("");
                            tfcfxmm.setText("");
                            lts.setText("修改成功！");
                        } else {
                            lts.setText("两次新密码不一致！");
                        }
                        }else lts.setText("新密码的长度不能超过20");
                    } else{
                        lts.setText("旧密码错误！");
                    }
                        stmt.close();
                        con.close();
                } catch(java.lang.Exception e1){
                    e1.printStackTrace();
                }
                }
                else lts.setText("不能有输入框为空！");
            }
            if(e.getSource()==bqx){
                dispose();
                syyck.tfsrtxm.requestFocus();
            }
        }
    }
    public void textValueChanged(TextEvent e){
        if(e.getSource()==tfsrtxm){
            
            if(tfsrtxm.getText().length()==13){
                                try{
                                        Class.forName(drivers);
                                        Connection con=DriverManager.getConnection(url);
                                        Statement stmt=con.createStatement();
                                        String sql="select * from sjb where 条形码='"+tfsrtxm.getText()+"'";
                                        ResultSet rs=stmt.executeQuery(sql);
                                        if(rs.next()){
                                            if(java.lang.Float.valueOf(rs.getString(3))>0){
                                                String tiaoxingma=rs.getString(1);
                                                String pinming=rs.getString(2);
                                                float danjia=rs.getFloat(4);
                                                if(shuzuweibiao<30){
                                                    boolean biaozhi=true;
                                                    for(int i=0;i<shuzuweibiao;i++){
                                                        if(tiaoxingma.equals(linshi[i])){
                                                            shuliang[i]++;
                                                            biaozhi=false;
                                                        }
                                                    }
                                                    if(biaozhi) {
                                                        linshi[shuzuweibiao]=tiaoxingma;
                                                        linshipinming[shuzuweibiao]=pinming;
                                                        linshidanjia[shuzuweibiao]=danjia;
                                                        shuliang[shuzuweibiao]++;
                                                        shuzuweibiao++;
                                                    }
                                                    taxianshi.append(shengchengzichuan(tiaoxingma, 15)+shengchengzichuan1(pinming, 20)+danjia+'\n');
                                                    zongjia=zongjia+danjia;
                                                    lzongjia.setText("总价为："+zongjia);
                                                    }
 
                                                else {
                                                    tishibiaoti="错误";
                                                    tishixinxi="一次销售的商品种类不能超过30种！";
                                                    new dhk(this,true);
                                                }
                                            }
                                            else{
                                                tishibiaoti="错误";
                                                tishixinxi="此商品数量为‘0’无法出售！";
                                                new dhk(this,true);
                                            }
                                        }

                                        tfsrtxm.setText("");
                                        rs.close();
                                        stmt.close();
                                        con.close();
                                }
                                catch(java.lang.Exception e1){
                                            e1.printStackTrace();
                                        }
            }
        }
    }
    class djiezhang extends Dialog implements ActionListener{
    Label lysje=new Label("应收金额:"+zongjia);
    Label lssje=new Label("实收金额:");
    TextField tfssje=new TextField();
    Label lzl=new Label();
    Button bqd=new Button("确定");
    Button bqx=new Button("取消");
    Label lts=new Label("输入实收金额后按回车！");
    djiezhang(syyck parent,boolean model){
        super(parent,model);
	setTitle("结帐-单位(人民币元)");
	setSize(275,223);
	setResizable(false);
	setLayout(null);
	setLocation(370,200);
        addWindowListener(new WindowAdapter(){
				public void windowClosing(WindowEvent e2){
					dispose();
				}
			});
        lysje.setAlignment(java.awt.Label.CENTER);
        lysje.setFont(new java.awt.Font("宋体", 1, 24));
        add(lysje);lysje.setBounds(0, 40, 280, 30);
        lssje.setFont(new java.awt.Font("宋体", 1, 24));
        add(lssje);lssje.setBounds(25, 80, 110, 30);
        tfssje.setFont(new Font("宋体",1,24));
        add(tfssje);tfssje.setBounds(140, 80, 90, 30);
        tfssje.addActionListener(this);
        lzl.setFont(new Font("宋体",1,30));
        lzl.setText("找零:0.0");lzl.setAlignment(java.awt.Label.CENTER);
        add(lzl);lzl.setBounds(0, 120, 280, 30);
        lzl.setVisible(false);
        add(bqd);bqd.setBounds(90, 160, 40, 26);
        bqd.setEnabled(false);
        bqd.addActionListener(this);
        add(bqx);bqx.setBounds(150, 160, 40, 26);
        bqx.setEnabled(false);
        bqx.addActionListener(this);
        lts.setAlignment(java.awt.Label.CENTER);
        add(lts);lts.setBounds(-2, 200, 280, 22);
        setVisible(true);
    }
    
    public void actionPerformed(ActionEvent e){
        if(e.getSource()==bqd){
            for(int i=0;i<shuzuweibiao;i++){
                    if(shuzuweibiao!=0){
                                try{
                                        Class.forName(drivers);
                                        Connection con=DriverManager.getConnection(url);
                                        Statement stmt=con.createStatement();
                                        String sql="Update sjb set 数量=数量-"+shuliang[i]+" where 条形码='"+linshi[i]+"'";
                                        String sql1="insert into ckrk(条形码,品名,单价,数量,经手人,日期,时间,操作类型)  values('"+linshi[i]+"','"+linshipinming[i]+"',"+linshidanjia[i]+","+shuliang[i]+",'"+syyck.zhanghao+"','"+shengchengriqi()+"', '"+shengchengshijian()+"','出库')";
                                        stmt.executeUpdate(sql);
                                        stmt.executeUpdate(sql1);
                                        
                                        stmt.close();
                                        con.close();
                                }
                                catch(java.lang.Exception e1){
                                            e1.printStackTrace();
                                }

                }
            }
            try{
                                        Class.forName(drivers);
                                        Connection con=DriverManager.getConnection(url);
                                        Statement stmt=con.createStatement();
                                        String sql="update zhb set 未交=未交+"+zongjia+"  where 帐号='"+zhanghao+"'";
                                        stmt.executeUpdate(sql);
                                        stmt.close();
                                        con.close();
             }
                catch(java.lang.Exception e1){
                                            e1.printStackTrace();
             }
                syyck.tfsrtxm.requestFocus(); 
                taxianshi.setText("编号           商品名                                  单价(元)"+'\n'+'\n');
                shuzubiaozhi=0;
                shuzuweibiao=0;
                for(int i=0;i<shuzuweibiao;i++){linshi[i]=null;linshipinming[i]=null;linshidanjia[i]=0;shuliang[i]=0;}
                zongjia=0;
                lzongjia.setText("总价为："+zongjia);
                syyck.tfsrtxm.requestFocus();
                dispose();
        }
        if(e.getSource()==bqx){
            lts.setText("输入实收金额后按回车！");
            tfssje.setEnabled(true);
            tfssje.setText("");
            tfssje.requestFocus();
            lzl.setVisible(false);
            bqd.setEnabled(false);
            bqx.setEnabled(false);
        }
        if(e.getSource()==tfssje){
            lts.setText("若无误单击“确定”结帐，否则单击“取消”返回");
            if(glyck.ceshizichuan(tfssje.getText())&&java.lang.Float.valueOf(tfssje.getText())>=zongjia){
                lzl.setText("找零:"+zhenglishuzichuan(java.lang.Float.valueOf(tfssje.getText())-zongjia));
                tfssje.setEnabled(false);
                lzl.setVisible(true);
                bqx.setEnabled(true);
                bqd.setEnabled(true);
                bqd.requestFocus();
            }
            else {lts.setText("输入数据格式错误或应收金额不够！");tfssje.setText("");}
        }
    }

}
	public  void actionPerformed(ActionEvent e){
            if(e.getSource()==mixgmm){
				new dxgmm(this,true);