glyck.java

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

                                        sql1="select distinct 日期 from ckrk where 日期 >= datevalue('"+chkssj.getSelectedItem()+"') and 品名='"+chxm.getSelectedItem()+"' and 操作类型='"+chczlx.getSelectedItem()+"'  order by 日期 desc ";
                                        if(chlb.getSelectedIndex()==0)rs=stmt.executeQuery(sql1);
                                        else  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();
		}
            }
            if(e.getSource()==chkssj){
                 chjssj.removeAll();
                 try{
                    ResultSet rs;
                    Class.forName(drivers);
                    Connection con=DriverManager.getConnection(url);
                    Statement stmt=con.createStatement();
                    String sql="select distinct 日期 from ckrk where 日期 >= datevalue('"+chkssj.getSelectedItem()+"') and 经手人='"+chxm.getSelectedItem()+"' and 操作类型='"+chczlx.getSelectedItem()+"'  order by 日期 desc ";
                    String sql1="select distinct 日期 from ckrk where 日期 >= datevalue('"+chkssj.getSelectedItem()+"') and 品名='"+chxm.getSelectedItem()+"' and 操作类型='"+chczlx.getSelectedItem()+"'  order by 日期 desc ";
                    if(chlb.getSelectedIndex()==0)rs=stmt.executeQuery(sql1);
                    else  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();
                }
            }
            if(e.getSource()==chxm){
                chczlx.removeAll();
                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()+"'";
                    String sql1="select distinct 操作类型 from ckrk where 品名='"+chxm.getSelectedItem()+"'";
                    if(chlb.getSelectedIndex()==0) rs=stmt.executeQuery(sql1);
                            else 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";
                                        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 ";
                                        sql1="select distinct 日期 from ckrk where 日期 >= datevalue('"+chkssj.getSelectedItem()+"') and 品名='"+chxm.getSelectedItem()+"' and 操作类型='"+chczlx.getSelectedItem()+"'  order by 日期 desc ";
                                            if(chlb.getSelectedIndex()==0)rs=stmt.executeQuery(sql1);
                                            else  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();
		}
            }
            if(e.getSource()==chlb){
                chxm.removeAll();
                chczlx.removeAll();
                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";
                        String sql1="select distinct 品名 from ckrk";
                        if(chlb.getSelectedIndex()==0) rs=stmt.executeQuery(sql1);
                        else rs=stmt.executeQuery(sql);
                        if(rs.next()){chxm.setEnabled(true);chxm.add(rs.getString(1));}
                        while(rs.next()) chxm.add(rs.getString(1));
                        setVisible(true);
                        chxm.select(0);
                        sql="select distinct 操作类型 from ckrk where 经手人='"+chxm.getItem(0)+"'";
                        sql1="select distinct 操作类型 from ckrk where 品名='"+chxm.getItem(0)+"'";
                        if(chlb.getSelectedIndex()==0) rs=stmt.executeQuery(sql1);
                        else rs=stmt.executeQuery(sql);
                        rs.next();chczlx.add(rs.getString(1));
                        while(rs.next())chczlx.add(rs.getString(1));
                        chczlx.select(0);
                        sql="select distinct 日期 from ckrk  where 经手人='"+chxm.getItem(0)+"' and 操作类型='"+chczlx.getSelectedItem()+"'order by 日期 desc";
                        sql1="select distinct 日期 from ckrk  where 品名='"+chxm.getItem(0)+"' 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)));
                        chkssj.select(0);
                        sql="select distinct 日期 from ckrk where 日期 >= datevalue('"+chkssj.getItem(0)+"') and 经手人='"+chxm.getSelectedItem()+"' and 操作类型='"+chczlx.getSelectedItem()+"'  order by 日期 desc ";
                        sql1="select distinct 日期 from ckrk where 日期 >= datevalue('"+chkssj.getItem(0)+"') and 品名='"+chxm.getSelectedItem()+"' and 操作类型='"+chczlx.getSelectedItem()+"'  order by 日期 desc ";
                        if(chlb.getSelectedIndex()==0)rs=stmt.executeQuery(sql1);
                        else  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();
		}
            }
        }
        public void actionPerformed(ActionEvent e){
            if(e.getSource()==bqx){
                dispose();
            }
            if(e.getSource()==bcx){
                if(chkssj.getSelectedItem()!=null&&chjssj.getSelectedItem()!=null){
                try{
                    ResultSet rs;
                    Class.forName(drivers);
                    Connection con=DriverManager.getConnection(url);
                    Statement stmt=con.createStatement();
                    String sql="select ckrk.条形码,品名,数量,单价,单价*数量 AS 总价,操作类型,日期,时间 from ckrk where 经手人='"+chxm.getSelectedItem()+"'and 操作类型='"+chczlx.getSelectedItem()+"' and 日期 between datevalue('"+chkssj.getSelectedItem()+"') and datevalue('"+chjssj.getSelectedItem()+"') order by 日期 desc";
                    String sql1="select ckrk.条形码,品名,数量,单价,单价*数量 AS 总价,操作类型,日期,时间 from ckrk where 品名='"+chxm.getSelectedItem()+"'and 操作类型='"+chczlx.getSelectedItem()+"' and 日期 between datevalue('"+chkssj.getSelectedItem()+"') and datevalue('"+chjssj.getSelectedItem()+"') order by 日期 desc";
                    if(chlb.getSelectedIndex()==0){
                        rs=stmt.executeQuery(sql1);
                    }
                    else{
                        rs=stmt.executeQuery(sql);
                    }
                    String tiaoxingma="";
                    String pinming="";
                    String shuliang="";
                    String danjia="";
                    String zongjia="";
                    String caozuoleixing="";
                    String riqi="";
                    String shijian="";
                    if(rs.next()){
                                                tiaoxingma=rs.getString(1);
                                                pinming=rs.getString(2);
                                                shuliang=rs.getString(3);
                                                danjia=rs.getString(4);
                                                zongjia=rs.getString(5);
                                                caozuoleixing=rs.getString(6);
                                                riqi=rs.getString(7);
                                                shijian=rs.getString(8);
                                                taxianshi.setText("编号                品名                                    数量      单价      总价      操作类型  日期         时间           "+'\n'+'\n');
                                                taxianshi.append(syyck.shengchengzichuan(tiaoxingma, 20)+syyck.shengchengzichuan1(pinming, 20)+syyck.shengchengzichuan(shuliang, 10)+syyck.shengchengzichuan(danjia, 10)+syyck.shengchengzichuan(zongjia, 10)+syyck.shengchengzichuan1(caozuoleixing,5)+syyck.shengchengzichuan(syyck.zhengliriqi(riqi),10)+syyck.shengchengzichuan(syyck.zhenglishijian(shijian),10)+'\n');
                    }
                    else taxianshi.setText("没有符合条件的记录！");
                     while(rs.next()){
                                                tiaoxingma=rs.getString(1);
                                                pinming=rs.getString(2);
                                                shuliang=rs.getString(3);
                                                danjia=rs.getString(4);
                                                zongjia=rs.getString(5);
                                                caozuoleixing=rs.getString(6);
                                                riqi=rs.getString(7);
                                                shijian=rs.getString(8);
                                                taxianshi.append(syyck.shengchengzichuan(tiaoxingma, 20)+syyck.shengchengzichuan1(pinming, 20)+syyck.shengchengzichuan(shuliang, 10)+syyck.shengchengzichuan(danjia, 10)+syyck.shengchengzichuan(zongjia, 10)+syyck.shengchengzichuan1(caozuoleixing,5)+syyck.shengchengzichuan(syyck.zhengliriqi(riqi),10)+syyck.shengchengzichuan(syyck.zhenglishijian(shijian),10)+'\n');
                                            
                     }
                        rs.close();
                        stmt.close();
                        con.close();
                }
                catch (java.lang.Exception e1){
                    e1.printStackTrace();
                }
                }
            }
        }
    }
    class dsk extends Dialog implements ActionListener,ItemListener{
        Label lxzzh=new Label("请选择帐号：");
        Choice chxzzh=new Choice();
        Label lwjje=new Label();
        Button bqd=new Button("收款");
        dsk(glyck parent,boolean modal){
            super(parent,modal);
            setTitle("收款");
            setSize(400,169);
            setResizable(false);
            setLayout(null);
            addWindowListener(new WindowAdapter(){
                public void windowClosing(WindowEvent e){
                    dispose();
                }
            });
            setLocation(250,200);
            add(lxzzh);
            lxzzh.setBounds(80, 50, 70, 22);
            add(chxzzh);
            chxzzh.setBounds(180, 50, 150, 22);
            chxzzh.addItemListener(this);
            add(lwjje);
            lwjje.setBounds(120, 80, 190, 22);
            add(bqd);
            bqd.setBounds(180, 110, 57, 26);
            bqd.addActionListener(this);
            try{
                Class.forName(drivers);
                Connection con=DriverManager.getConnection(url);
                Statement stmt=con.createStatement();
                String sql="select 帐号,未交 from zhb where 权限='收银员' and 未交<>0";
                ResultSet rs=stmt.executeQuery(sql);
                if(rs.next()){
                    chxzzh.add(rs.getString(1));
                    lwjje.setText("该帐号的未交款金额为："+rs.getString(2));
                } else {
                    chxzzh.setEnabled(false);
                    bqd.setEnabled(false);
                    lwjje.setText("没有未交款的帐号或收款完毕！");
                }
                while(rs.next()){
                    chxzzh.add(rs.getString(1));
                }
                        rs.close();
                        stmt.close();
                        con.close();
            } 
            catch(java.lang.Exception e1){
                e1.printStackTrace();
            }
            setVisible(true);
        }
        public void actionPerformed(ActionEvent e){
            if(e.getSource()==bqd){
                if(chxzzh.getSelectedItem()!=null){
                    try{
                        Class.forName(drivers);
                        Connection con=DriverManager.getConnection(url);
                        Statement stmt=con.createStatement();
                        String sql="update zhb set 未交 =0 where 帐号='"+chxzzh.getSelectedItem()+"'";
                        stmt.executeUpdate(sql);
                        chxzzh.remove(chxzzh.getSelectedItem());
                        String sql1="select 未交 from zhb where 帐号='"+chxzzh.getSelectedItem()+"'";
                        ResultSet rs=stmt.executeQuery(sql1);
                        if(rs.next())lwjje.setText("该帐号的未交款金额为："+rs.getString(1));
                        else {
                            chxzzh.setEnabled(false);
                            bqd.setEnabled(false);
                            lwjje.setText("没有未交款的帐号或收款完毕！");