syyck.java

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

package chaoshi;
import java.text.*;
import java.util.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
class syyck extends Frame implements ActionListener,TextListener{
                static String drivers="sun.jdbc.odbc.JdbcOdbcDriver";
                static String url="jdbc:odbc:chaoshi"; 
                static String zhanghao="";
                static float zongjia=0;
                static String linshi[]=new String[30];
                static String linshipinming[]=new String[30];
                static float linshidanjia[]=new float[30];
                static int shuliang[]=new int[30];
                static int shuzubiaozhi=0;
                static int shuzuweibiao=0;
                static String tishixinxi="";
                static String tishibiaoti="";
		MenuBar mb=new MenuBar();
		Menu mzhgl=new Menu("帐号管理");
		MenuItem mixgmm=new MenuItem("修改密码");
		Menu msprk=new Menu("商品入库");
                MenuItem misprk=new MenuItem("商品入库");
		Menu msjcx=new Menu("数据查询");
		MenuItem miwjje=new MenuItem("未交款金额");
		MenuItem mixsjl=new MenuItem("全部销售记录");
                Menu mguanyu =new Menu("关于");
                MenuItem miguanyu=new MenuItem("关于");
                Label lzongjia =new Label("总价为："+zongjia);
		static TextField tfsrtxm = new TextField();
		Label lsrtxm = new Label("请输入编号：");
		Button bjiezhang = new Button("结帐");
                Button bqingchu=new Button("清除");
		TextArea taxianshi = new TextArea("",0,0,java.awt.TextArea.SCROLLBARS_VERTICAL_ONLY);
	syyck(String zhanghao){
		super(zhanghao+"-收银员界面-小型超市前台收款系统");
                syyck.zhanghao=zhanghao;
		setSize(800,400);
		setLocation(112,100);
		setLayout(null);
		setResizable(false);
		addWindowListener(new WindowAdapter(){
			public void windowClosing(WindowEvent e1){
				System.exit(0);
			}
		});
		
		mzhgl.add(mixgmm);
		mixgmm.addActionListener(this);
                msprk.add(misprk);
                misprk.addActionListener(this);
		msjcx.add(miwjje);
		miwjje.addActionListener(this);
		msjcx.add(mixsjl);
                mixsjl.addActionListener(this);
                mguanyu.add(miguanyu);
		miguanyu.addActionListener(this);
		mb.add(mzhgl);
		mb.add(msprk);
		mb.add(msjcx);
                mb.add(mguanyu);
		setMenuBar(mb);
                add(lzongjia);
                lzongjia.setBounds(20, 56, 118, 16);
		add(lsrtxm);
                tfsrtxm.addActionListener(this);
                tfsrtxm.addTextListener(this);
		add(tfsrtxm);
		add(bjiezhang);
                bjiezhang.addActionListener(this);
                add(bqingchu);
                bqingchu.addActionListener(this);
		add(taxianshi);
                taxianshi.setText("编号           商品名                                  单价(元)   "+'\n'+'\n');
  		tfsrtxm.setBounds(new Rectangle(223, 51, 161, 22));
  		lsrtxm.setBounds(new Rectangle(138, 56, 80, 16));
  		bjiezhang.setBounds(new Rectangle(395, 48, 50, 24));
                bqingchu.setBounds(new Rectangle(450,48,50,24));
  		taxianshi.setBounds(new Rectangle(3, 74, 795, 324));
		
	}

class dhk extends Dialog implements ActionListener{
    Label lcuowu=new Label(tishixinxi);
    Button bqueding =new Button("确定");
    dhk(Frame parent,boolean model){
        super(parent,model);
	setTitle(tishibiaoti);
	setSize(400,120);
	setResizable(false);
	setLayout(null);
	setLocation(300,200);
        add(lcuowu);
        lcuowu.setAlignment(java.awt.Label.CENTER);
        lcuowu.setBounds(0, 50, 400, 22);
        add(bqueding);
        bqueding.setBounds(170, 80, 57, 26);
        addWindowListener(new WindowAdapter(){
				public void windowClosing(WindowEvent e2){
					dispose();
                                        syyck.tfsrtxm.requestFocus();
				}
			});
        bqueding.addActionListener(this);
        setVisible(true);



    }
    public void actionPerformed(ActionEvent e){
        if(e.getSource()==bqueding){
            tfsrtxm.setText("");
            dispose();
            syyck.tfsrtxm.requestFocus();
        }
    }
}
        class dsprk extends Dialog implements ActionListener{
                private java.awt.Button bguanbi=new Button();
                private java.awt.Button bqueding=new Button();
                private java.awt.Label lsrsl=new Label();
                private java.awt.Label lsrtxm=new Label();
                private java.awt.TextField tfsrsl=new TextField();
                private java.awt.TextField tfsrtxm=new TextField();
                private java.awt.Label lts=new Label();
                dsprk(syyck parent,boolean modal){
                        super(parent,modal);
                        setTitle("商品入库");
                        setSize(329,179);
			setResizable(false);
			setLayout(null);
			setLocation(300,200);
                        addWindowListener(new WindowAdapter(){
				public void windowClosing(WindowEvent e2){
					dispose();
                                        syyck.tfsrtxm.requestFocus();
				}
			});
                        lsrtxm.setText("请输入要入库的商品的编号：");
                        add(lsrtxm);
                        lsrtxm.setBounds(20, 50, 170, 22);

                        add(tfsrtxm);
                        tfsrtxm.setBounds(200, 50, 110, 22);

                        lsrsl.setText("请输入要入库的商品的数量：");
                        add(lsrsl);
                        lsrsl.setBounds(20, 80, 160, 22);

                        add(tfsrsl);
                        tfsrsl.setBounds(200, 80, 110, 22);

                        bqueding.setLabel("确定");
                        add(bqueding);
                        bqueding.setBounds(100, 120, 40, 26);
                        bqueding.addActionListener(this);

                        bguanbi.setLabel("关闭");
                        add(bguanbi);
                        bguanbi.setBounds(190, 120, 40, 26);
                        bguanbi.addActionListener(this);
                        add(lts);lts.setAlignment(java.awt.Label.CENTER);
                        lts.setBounds(70, 150, 180, 22);
                        setVisible(true);
                }
            public void actionPerformed(ActionEvent e){
                if(e.getSource()==bqueding){
                    if(tfsrtxm.getText().length()!=0&&tfsrsl.getText().length()!=0){
                        
                    
                     try{
                                        Class.forName(drivers);
                                        Connection con=DriverManager.getConnection(url);
                                        Statement stmt=con.createStatement();
                                   if(glyck.ceshizichuan(tfsrtxm.getText())){
                                        ResultSet rs;
                                        String sql="select 条形码,品名,数量,单价 from sjb where 条形码='"+tfsrtxm.getText()+"'";
                                        rs=stmt.executeQuery(sql);
                                        if(rs.next()&&glyck.ceshizichuan(tfsrtxm.getText())&&glyck.ceshizichuan(tfsrsl.getText())&&!tfsrtxm.getText().equals("")&&!tfsrsl.getText().equals("")){
                                            String pinming=rs.getString(2);
                                            String danjia=rs.getString(4);
                                            String sql2="insert into ckrk(条形码,品名,单价,数量,经手人,日期,时间,操作类型)  values('"+tfsrtxm.getText()+"','"+pinming+"',"+danjia+","+java.lang.Integer.valueOf(tfsrsl.getText())+",'"+syyck.zhanghao+"','"+shengchengriqi()+"','"+shengchengshijian()+"','入库')";
                                            stmt.executeUpdate(sql2);
                                            String sql1="Update sjb set 数量=数量+"+java.lang.Integer.valueOf(tfsrsl.getText())+" where 条形码='"+tfsrtxm.getText()+"'";
                                            stmt.executeUpdate(sql1);
                                            lts.setText("添加成功！如还要添加请继续...");
                                            tfsrtxm.setText("");
                                            tfsrsl.setText("");
                                            tfsrtxm.requestFocus();
                                        }
                                        else {
                                            lts.setText("无此商品！");
                                        }
                                        stmt.close();
                                        con.close();
                                   }
                                   else lts.setText("编号必须为数字！");
                        
                     }
                     catch(java.lang.Exception e1){
                         e1.printStackTrace();
                     }
                    }
                    else lts.setText("输入框不能为空！");
                }
                if(e.getSource()==bguanbi){
                    dispose();
                    syyck.tfsrtxm.requestFocus();
                }
            }
        }
    class dxgmm extends Dialog implements ActionListener{
        Label lsrjmm=new Label("请输入当前密码：");
        TextField tfsrjmm=new TextField(20);
        Label lsrxmm=new Label("请输入新密码：");
        TextField tfsrxmm=new TextField(20);
        Label lcfxmm=new Label("再次输入新密码以确认：");
        TextField tfcfxmm=new TextField(20);
        Button bxg=new Button("修改");
        Button bqx=new Button("关闭");
        Label lts=new Label("");
        dxgmm(syyck parent,boolean modal){
            super(parent,modal);
            setTitle("修改密码");
            setSize(383,205);
            setResizable(false);
            setLayout(null);
            setLocation(300,200);
            add(lsrjmm);lsrjmm.setBounds(70, 50, 100, 22);
            add(tfsrjmm);tfsrjmm.setBounds(200, 50, 110, 22);
            tfsrjmm.enableInputMethods(false);
            tfsrjmm.setEchoChar('*');