glyck.java

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

                        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()){
                            bcx.setVisible(false);
                            lts.setText("");
                            lsrtxm.setVisible(false);
                            tfsrtxm.setVisible(false);
                            bqx.setBounds(180, 150, 57, 26);
                            lts.setBounds(70, 180, 210, 22);
                            spbh=rs.getString(1);
                            this.setSize(347,208);
                            lspm.setVisible(true);lspm.setBounds(100, 60, 50, 22);
                            tfspm.setVisible(true);
                            tfspm.setText(rs.getString(2));tfspm.setBounds(160, 60, 80, 22);
                            lspdj.setVisible(true);lspdj.setBounds(100, 100, 60, 22);
                            tfspdj.setVisible(true);
                            tfspdj.setText(rs.getString(4));tfspdj.setBounds(160, 100, 80, 22);
                            bxg.setVisible(true);bxg.setBounds(110, 150, 57, 26);
                            this.setVisible(true);
                        } else{
                            lts.setText("找不到编号！");
                        }
                        rs.close();
                        stmt.close();
                        con.close();
                    } catch(java.lang.Exception e1){
                        e1.printStackTrace();
                    }
                } else lts.setText("输入框不能为空！");
            }
            if(e.getSource()==bxg){
                if(tfspm.getText().length()<=20){
                try{
                    Class.forName(drivers);
                    Connection con=DriverManager.getConnection(url);
                    Statement stmt=con.createStatement();
                    if(!tfspm.getText().equals("")&&!tfspdj.getText().equals("")&&ceshizichuan(tfspdj.getText())){
                        String sql="Update sjb set  品名='"+tfspm.getText()+"' , 单价= "+tfspdj.getText()+"  where 条形码='"+spbh+"'";
                        stmt.executeUpdate(sql);
                        lts.setText("修改成功！");
                    } 
                    else{
                        lts.setText("有空输入框或单价非数字！");
                    }
                        stmt.close();
                        con.close();
                } catch(java.lang.Exception e1){
                    e1.printStackTrace();
                }
                }else lts.setText("商品名的长度不能超过20！");
            }
            if(e.getSource()==bqx){
                dispose();
            }
        }
    }
    class dtjsp extends Dialog implements ActionListener{
        Label lsrtxm=new Label("请输入编号：");
        TextField tfsrtxm=new TextField(35);
        Label lsrspm=new Label("请输入商品名：");
        TextField tfsrspm=new TextField(35);
        Label lsrspdj=new Label("输入商品单价：");
        TextField tfsrspdj=new TextField(35);
        Button btj=new Button("添  加");
        Button bqx=new Button("取  消");
        Label lts=new Label();
        dtjsp(glyck parent,boolean modal){
            super(parent,modal);
            setTitle("添加商品");
            setSize(302,210);
            setResizable(false);
            setLayout(null);
            addWindowListener(new WindowAdapter(){
                public void windowClosing(WindowEvent e){
                    dispose();
                }
            });
            setLocation(300,200);
            add(lsrtxm);lsrtxm.setBounds(50, 50, 80, 22);
            add(tfsrtxm);tfsrtxm.setBounds(140, 50, 120, 22);
            add(lsrspm);lsrspm.setBounds(50, 80, 80, 22);
            add(tfsrspm);tfsrspm.setBounds(140, 80, 120, 22);
            add(lsrspdj);lsrspdj.setBounds(50, 110, 80, 22);
            add(tfsrspdj);tfsrspdj.setBounds(140, 110, 120, 22);
            add(btj);btj.setBounds(80, 150, 57, 26);
            btj.addActionListener(this);
            add(bqx);bqx.setBounds(160, 150, 57, 26);
            bqx.addActionListener(this);
            add(lts);lts.setBounds(40, 180, 230, 22);lts.setAlignment(java.awt.Label.CENTER);
            setVisible(true);
        }
        public void actionPerformed(ActionEvent e){
            if(e.getSource()==btj){
                if(!tfsrtxm.getText().equals("")&&!tfsrspm.getText().equals("")&&!tfsrspdj.getText().equals("")){
                    if(tfsrtxm.getText().length()<=13&&tfsrspm.getText().length()<=20){
                    try{
                        Class.forName(drivers);
                        Connection con=DriverManager.getConnection(url);
                        Statement stmt=con.createStatement();
                        if(ceshizichuan1(tfsrtxm.getText())&&!tfsrspm.getText().equals("")&&ceshizichuan2(tfsrspm.getText())&&ceshizichuan(tfsrspdj.getText())){
                            String sql="Insert into sjb(条形码,品名,数量,单价) values('"+tfsrtxm.getText()+"','"+tfsrspm.getText()+"',0,"+tfsrspdj.getText() +")";
                            String sql1="select * from sjb where 条形码='"+tfsrtxm.getText()+"'";
                            ResultSet rs=stmt.executeQuery(sql1);
                            if(rs.next()){
                                lts.setText("编号已存在！");
                            } else{
                                stmt.executeUpdate(sql);
                                lts.setText("添加成功！");
                                tfsrtxm.setText("");
                                tfsrspm.setText("");
                                tfsrspdj.setText("");
                                tfsrtxm.requestFocus();
                            }
                        } else{
                            lts.setText("数据格式错误：编号=数字，单价=数字，品名不等于空格");
                        }
                        stmt.close();
                        con.close();
                    } catch(java.lang.Exception e1){
                        e1.printStackTrace();
                    }
                    }else lts.setText("编号过长（不能>13）或品名过长（不能>20）！");
                } else lts.setText("有空输入框！");
            }
            if(e.getSource()==bqx){
                dispose();
            }
        }
        
        
    }
        
    class dcxsj extends Dialog implements ActionListener,ItemListener{
        Label lxzcxtj=new Label("请选择查询的条件：");
        Choice chlb=new Choice();
        Choice chxm=new Choice();
        Label lkssj=new Label("从");
        Choice chkssj=new Choice();
        Label ljssj=new Label("到");
        Choice chjssj=new Choice();
        Label lde=new Label("的");
        Choice chczlx=new Choice();
        Label lqingkuang=new Label("情况");
        Button bcx=new Button("查询");
        Button bqx=new Button("关闭");
        dcxsj(glyck parent,boolean modal){
            super(parent,modal);
            setTitle("选择查询条件");
            setSize(495,130);
            setResizable(false);
            addWindowListener(new WindowAdapter(){
                public void windowClosing(WindowEvent e){
                    dispose();
                }
            });
            setLocation(262,200);
            setLayout(null);
            add(lxzcxtj);
            lxzcxtj.setBounds(18, 32, 130, 26);
            add(chlb);
            chlb.setBounds(18, 58, 60, 24);
            chlb.addItemListener(this);
            add(chxm);
            chxm.setBounds(80, 58, 100, 24);
            chxm.addItemListener(this);
            add(lkssj);
            lkssj.setBounds(270, 61, 13, 16);
            add(chkssj);
            chkssj.setBounds(285, 58, 90, 24);
            chkssj.addItemListener(this);
            add(ljssj);
            ljssj.setBounds(375, 61, 13, 16);
            add(chjssj);
            chjssj.setBounds(390, 58, 90, 24);
            chjssj.addItemListener(this);
            add(lde);
            lde.setBounds(180, 61, 13, 16);
            add(chczlx);
            chczlx.setBounds(195, 58, 50, 24);
            chczlx.addItemListener(this);
            add(lqingkuang);
            lqingkuang.setBounds(245, 61, 25, 16);
            add(bcx);
            bcx.setBounds(156, 95, 71, 25);
            bcx.addActionListener(this);
            add(bqx);
            bqx.setBounds(254, 95, 71, 25);
            bqx.addActionListener(this);
            chlb.add("商    品");
            chlb.add("收银员");
            chxm.setEnabled(false);
            chczlx.setEnabled(false);
            chkssj.setEnabled(false);
            chjssj.setEnabled(false);
            bcx.setEnabled(false);
            try
		{       ResultSet rs;
			Class.forName(drivers);
			Connection con=DriverManager.getConnection(url);
			Statement stmt=con.createStatement();
                        String sql="select distinct 品名 from ckrk";
                        rs=stmt.executeQuery(sql);
                        if(rs.next()){chxm.setEnabled(true);chczlx.setEnabled(true);chkssj.setEnabled(true);chjssj.setEnabled(true);bcx.setEnabled(true);chxm.add(rs.getString(1));}
                        else {lxzcxtj.setText("没有符合条件的记录！");chlb.setEnabled(false);}
                        if(chxm.getSelectedItem()!=null){
                            while(rs.next()) chxm.add(rs.getString(1));
                            sql="select distinct 操作类型 from ckrk where 品名='"+chxm.getSelectedItem()+"'";
                            rs=stmt.executeQuery(sql);
                            while(rs.next())   chczlx.add(rs.getString(1));
                            sql="select distinct 日期 from ckrk  where 品名='"+chxm.getSelectedItem()+"' and 操作类型='"+chczlx.getSelectedItem()+"' order by 日期 desc";
                            rs=stmt.executeQuery(sql);
                            while(rs.next()) chkssj.add(syyck.zhengliriqi(rs.getString(1)));
                            sql="select distinct 日期 from ckrk where 日期 >= datevalue('"+chkssj.getSelectedItem()+"') and 品名='"+chxm.getSelectedItem()+"' and 操作类型='"+chczlx.getSelectedItem()+"' order by 日期 desc ";
                            rs=stmt.executeQuery(sql);
                            while(rs.next())chjssj.add(syyck.zhengliriqi(rs.getString(1)));
                            rs.close();
                            stmt.close();
                            con.close();
                        }
		}
		catch(java.lang.Exception e1){
			e1.printStackTrace();
		}

            setVisible(true);
        }
        public void itemStateChanged(ItemEvent e){
            if(e.getSource()==chczlx){
                chkssj.removeAll();
                chjssj.removeAll();
                 try{
                    ResultSet rs;
                    Class.forName(drivers);
                    Connection con=DriverManager.getConnection(url);
                    Statement stmt=con.createStatement();
                                        String sql="select distinct 日期 from ckrk  where 经手人='"+chxm.getSelectedItem()+"' and 操作类型='"+chczlx.getSelectedItem()+"'  order by 日期 desc";
                                        String sql1="select distinct 日期 from ckrk  where 品名='"+chxm.getSelectedItem()+"' and 操作类型='"+chczlx.getSelectedItem()+"'  order by 日期 desc";
                                        if(chlb.getSelectedIndex()==0)rs=stmt.executeQuery(sql1);
                                        else rs=stmt.executeQuery(sql);
                                        while(rs.next()) chkssj.add(syyck.zhengliriqi(rs.getString(1)));
                                        sql="select distinct 日期 from ckrk where 日期 >= datevalue('"+chkssj.getSelectedItem()+"') and 经手人='"+chxm.getSelectedItem()+"' and 操作类型='"+chczlx.getSelectedItem()+"'  order by 日期 desc ";