syyck.java

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

			}
            if(e.getSource()==misprk){
                new dsprk(this,true);
            }
            if(e.getSource()==tfsrtxm){
                                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(rs.getFloat(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("总价为："+zhenglishuzichuan(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();
                                }
                    }
            if(e.getSource()==bjiezhang){
                if(shuzuweibiao!=0) new djiezhang(this, true);
                else syyck.tfsrtxm.requestFocus();
            }
            if(e.getSource()==bqingchu){
                taxianshi.setText("编号           商品名                                  单价(元)"+'\n'+'\n');
                shuzubiaozhi=0;
                shuzuweibiao=0;
                for(int i=0;i<30;i++){linshi[i]=null;linshipinming[i]=null;linshidanjia[i]=0;shuliang[i]=0;}
                zongjia=0;
                lzongjia.setText("总价为："+zongjia);
                tfsrtxm.setEnabled(true);
                bjiezhang.setEnabled(true);
                syyck.tfsrtxm.requestFocus();
            }
            if(e.getSource()==miwjje){
                try{
                                        Class.forName(drivers);
                                        Connection con=DriverManager.getConnection(url);
                                        Statement stmt=con.createStatement();
                                        String sql="select * from zhb where 帐号='"+zhanghao+"'";
                                        ResultSet rs=stmt.executeQuery(sql);
                                        if(rs.next()){
                                        tishibiaoti="未交款金额";
                                        tishixinxi="未交款金额为："+rs.getString(4);
                                        new dhk(this, true);
                                        }
                        rs.close();
                        stmt.close();
                        con.close();
                }
                 catch(java.lang.Exception e1){
                                            e1.printStackTrace();
                }
            }

            if(e.getSource()==miguanyu){
                new dguanyu(this,true);
            }
            if(e.getSource()==mixsjl){
                tfsrtxm.setEnabled(false);
                bjiezhang.setEnabled(false);
                
                try{
                                        Class.forName(drivers);
                                        Connection con=DriverManager.getConnection(url);
                                        Statement stmt=con.createStatement();
                                        String sql="select 条形码,品名,数量,单价,单价*数量 AS 总价,操作类型,日期,时间 from ckrk  where 经手人='"+syyck.zhanghao+"'and 操作类型='出库'  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 {
                                                syyck.tishibiaoti="提示：";
                                                syyck.tishixinxi="没有销售记录！";
                                                new dhk(this,true);
                                            }
                                            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();
                }
            }
		
	}
        static public String shengchengzichuan(String zichuan,int chang){
                        do{
                zichuan=zichuan+" ";
            }
            while(zichuan.length()<chang);
            
            return zichuan;
        }
        static public String zhenglishuzichuan(float shuzichuan){
            String zichuan=""+shuzichuan;
            String jieguo=""+zichuan.charAt(0);
            for(int i=0;i<zichuan.length();i++){
                if(zichuan.charAt(i)=='.'){jieguo+=zichuan.charAt(i+1);break;}
                else jieguo+=zichuan.charAt(i+1);
            }
            return jieguo;
        }

        static public String shengchengzichuan1(String zichuan,int chang){
            int zichang=zichuan.length();
            for(int i=0;i<chang-zichang;i++){
                 zichuan=zichuan+"  ";
            }
            for(int i=0;i<zichang;i++){
                if(java.lang.Character.isLowerCase(zichuan.charAt(i))||zichuan.charAt(i)==' '||java.lang.Character.isUpperCase(zichuan.charAt(i))||java.lang.Character.isDigit(zichuan.charAt(i))) zichuan=zichuan+" ";
            }

            
            return zichuan;
        }
        static public String shengchengshijian(){
            java.util.Date xianzai=new java.util.Date();
            DateFormat shijian=DateFormat.getTimeInstance(DateFormat.LONG,Locale.CHINA);
            return shijian.format(xianzai);
        }
        static public String shengchengriqi(){
            java.util.Date xianzai=new java.util.Date();
            DateFormat riqi=DateFormat.getDateInstance(DateFormat.LONG, Locale.CHINA);
            return riqi.format(xianzai);
        }
        static public String zhengliriqi(String riqi){
            String jieguo="";
            for(int i=0;i<=10;i++){
                jieguo=jieguo+riqi.charAt(i);
            }
            return jieguo;
        }
        static public String zhenglishijian(String shijian){
            String jieguo="";
            for(int i=10;i<19;i++){
                jieguo=jieguo+shijian.charAt(i);
            }
            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();
                    syyck.tfsrtxm.requestFocus();
                }
            });
            setVisible(true);

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

}