glyck.java

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

                        }
                        rs.close();
                        stmt.close();
                        con.close();
                    } catch(java.lang.Exception e1){
                        e1.printStackTrace();
                    }
                }
            }
        }
        public void itemStateChanged(ItemEvent e){
            if(e.getSource()==chxzzh){
                try{
                    Class.forName(drivers);
                    Connection con=DriverManager.getConnection(url);
                    Statement stmt=con.createStatement();
                    String sql="select 未交 from zhb where 帐号='"+chxzzh.getSelectedItem()+"'";
                    ResultSet rs=stmt.executeQuery(sql);
                    rs.next();
                    lwjje.setText("该帐号的未交款金额为："+rs.getString(1));
                        rs.close();
                        stmt.close();
                        con.close();
                } catch(java.lang.Exception e1){
                    e1.printStackTrace();
                }
            }
        }
    }
    
        /*class dbfsj extends Dialog implements ActionListener{
        }
        class dhfsj extends Dialog implements ActionListener{
        }*/
    
    glyck(String zhanghao){
        super(zhanghao+"-管理员界面-小型超市前台收款系统");
        glyck.zhanghao=zhanghao;
        setSize(800,400);
        setLocation(112,100);
        setResizable(false);
        addWindowListener(new WindowAdapter(){
            public void windowClosing(WindowEvent e1){
                System.exit(0);
            }
        });
        mzhgl.add(micjzh);
        micjzh.addActionListener(this);
        mzhgl.add(mixgmm);
        mixgmm.addActionListener(this);
        mxgsj.add(mixgsj);
        mixgsj.addActionListener(this);
        mxgsj.add(mitjsp);
        mitjsp.addActionListener(this);
        mcxsj.add(mcxczjl);
        mcxczjl.add(micxxs);
        micxxs.addActionListener(this);
        mcxczjl.add(micxqb);
        micxqb.addActionListener(this);
        mcxsj.add(micxkc);
        micxkc.addActionListener(this);
        msk.add(misk);
        misk.addActionListener(this);
        mguanyu.add(miguanyu);
        miguanyu.addActionListener(this);
        mbfsj.add(mibfsj);
        mibfsj.addActionListener(this);
        mbfsj.add(mihfsj);
        mihfsj.addActionListener(this);
        mbcaidantiao.add(mzhgl);
        mbcaidantiao.add(mxgsj);
        mbcaidantiao.add(mcxsj);
        mbcaidantiao.add(msk);
        mbcaidantiao.add(mguanyu);
        //mbcaidantiao.add(mbfsj);
        setMenuBar(mbcaidantiao);
        add(taxianshi);
    }
    
    public void actionPerformed(ActionEvent e){
        if(e.getSource()==micjzh){
            new dcjzh(this,true);
        }
        if(e.getSource()==mixgmm){
            new dxgmm(this,true);
        }
        if(e.getSource()==mixgsj){
            new dxgsj(this,true);
        }
        if(e.getSource()==mitjsp){
            new dtjsp(this,true);
        }
        if(e.getSource()==micxqb){
            try{
                                        Class.forName(drivers);
                                        Connection con=DriverManager.getConnection(url);
                                        Statement stmt=con.createStatement();
                                        String sql="select 条形码,品名,数量,单价,单价*数量 AS 总价,操作类型,日期,时间 from ckrk   order by 日期 desc";
                                        ResultSet 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();
                }
        }
        if(e.getSource()==micxxs){
            new dcxsj(this,false);
        }
        if(e.getSource()==micxkc){
            try{
                            Class.forName(drivers);
                            Connection con=DriverManager.getConnection(url);
                            Statement stmt=con.createStatement();
                            String sql="select * from sjb";
                            ResultSet rs =stmt.executeQuery(sql);
                            if(rs.next()){
                                taxianshi.setText("编号           商品名                                  单价(元)  数量        "+'\n'+'\n');
                                taxianshi.append(syyck.shengchengzichuan(rs.getString(1), 15)+syyck.shengchengzichuan1(rs.getString(2), 20)+syyck.shengchengzichuan(rs.getString(4), 10)+syyck.shengchengzichuan(rs.getString(3), 10)+'\n');
                            }
                            else taxianshi.setText("无商品数据！");
                            while(rs.next()){
                                taxianshi.append(syyck.shengchengzichuan(rs.getString(1), 15)+syyck.shengchengzichuan1(rs.getString(2), 20)+syyck.shengchengzichuan(rs.getString(4), 10)+syyck.shengchengzichuan(rs.getString(3), 10)+'\n');
                            }
                        rs.close();
                        stmt.close();
                        con.close();
            }
            catch(java.lang.Exception e1){
                    e1.printStackTrace();
                }
            
            
        }
        if(e.getSource()==misk){
            new dsk(this, true);
        }
        if(e.getSource()==miguanyu){
            new dguanyu(this, true);
        }
        
        
    }
    public static boolean ceshizichuan(String zichuan){
        boolean jieguo=true;
        int zichang=zichuan.length();
        char zi;
        for(int i=0;i<zichang;i++){
            zi=zichuan.charAt(i);
            if(zi!='1'&&zi!='2'&&zi!='3'&&zi!='4'&&zi!='5'&&zi!='6'&&zi!='7'&&zi!='8'&&zi!='9'&&zi!='0'&&zi!='.')   {
                jieguo=false;
                break;
            }
        }
        return jieguo;
    }
      public static boolean ceshizichuan2(String zichuan){
        boolean jieguo=true;
        int zichang=zichuan.length();
        char zi;
        for(int i=0;i<zichang;i++){
            zi=zichuan.charAt(i);
            if(zi=='　'||zi==' '||zi==' ')   {
                jieguo=false;
                break;
            }
        }
        
        return jieguo;
    }
    public static boolean ceshizichuan1(String zichuan){
        boolean jieguo=true;
        int zichang=zichuan.length();
        char zi;
        for(int i=0;i<zichang;i++){
            zi=zichuan.charAt(i);
            if(zi!='1'&&zi!='2'&&zi!='3'&&zi!='4'&&zi!='5'&&zi!='6'&&zi!='7'&&zi!='8'&&zi!='9'&&zi!='0')   {
                jieguo=false;
                break;
            }
        }
        return jieguo;
    }
    class dguanyu extends Dialog{
        dguanyu(Frame parent,boolean model){
            super(parent,model);
            setTitle("关于");
            setSize(300,100);
            setResizable(false);
            setLayout(null);
            setLocation(350,250);
            addWindowListener(new WindowAdapter(){
                public void windowClosing(WindowEvent e2){
                    dispose();
                }
            });
            setVisible(true);

        }
        public void paint(Graphics g){
            g.drawString("芸义于至2006年5月1日至5月7日为毕业设计而做",20,60);
            g.drawString("版权所有   翻版必究",100,80);
        }
    }
    
}