glyck.java

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

package chaoshi;
import java.awt.Component;
import java.awt.*;
import java.awt.Color.*;
import java.awt.event.*;
import java.sql.*;
class glyck extends Frame implements ActionListener{
    glyck parent=this;
    static String scts="";
    static String drivers="sun.jdbc.odbc.JdbcOdbcDriver";
    static String url="jdbc:odbc:chaoshi";
    static String zhanghao=new String();
    MenuBar mbcaidantiao=new MenuBar();
    Menu mzhgl=new Menu("帐号管理");
    MenuItem micjzh=new MenuItem("创建帐号");
    MenuItem mixgmm=new MenuItem("修改密码");
    Menu mxgsj=new Menu("修改数据");
    MenuItem mixgsj=new MenuItem("修改数据");
    MenuItem mitjsp=new MenuItem("添加商品");
    Menu msk=new Menu("收款");
    MenuItem misk=new MenuItem("收款");
    Menu mcxsj=new Menu("查询数据");
    Menu mcxczjl=new Menu("查询操作记录");
    MenuItem micxxs=new MenuItem("按条件查询");
    MenuItem micxqb=new MenuItem("查询全部");
    MenuItem micxkc=new MenuItem("商品库存信息");
    Menu mbfsj=new Menu("备份数据");
    MenuItem mibfsj=new MenuItem("备份数据");
    MenuItem mihfsj=new MenuItem("恢复数据");
    Menu mguanyu =new Menu("关于");
    MenuItem miguanyu=new MenuItem("关于");
    TextArea taxianshi=new TextArea("",0,0,java.awt.TextArea.SCROLLBARS_VERTICAL_ONLY);
    class dcjzh extends Dialog implements ActionListener{
        
        Label lsrzh=new Label("请输入帐号：");
        TextField tfsrzh=new TextField(20);
        Label lsrmm=new Label("请输入密码：");
        TextField tfsrmm=new TextField(20);
        Label lcfmm=new Label("再次输入密码以确认：");
        TextField tfcfmm=new TextField(20);
        Button bcj=new Button("创建");
        Button bqx=new Button("关闭");
        Label lts=new Label("");
        dcjzh(glyck parent,boolean modal){
            super(parent,modal);
            setTitle("创建帐号");
            setSize(324,208);
            setResizable(false);
            setLayout(null);
            setLocation(300,200);
            add(lsrzh);lsrzh.setBounds(40, 50, 100, 22);
            add(tfsrzh);tfsrzh.setBounds(170, 50, 110, 22);
            add(lsrmm); lsrmm.setBounds(40, 80, 90, 22);
            add(tfsrmm);tfsrmm.setBounds(170, 80, 110, 22);
            tfsrmm.setEchoChar('*');
            tfsrmm.enableInputMethods(false);
            add(lcfmm);lcfmm.setBounds(40, 110, 130, 22);
            add(tfcfmm);tfcfmm.setBounds(170, 110, 110, 22);
            tfcfmm.setEchoChar('*');
            tfcfmm.enableInputMethods(false);
            add(bcj);bcj.setBounds(90, 150, 57, 26);
            bcj.addActionListener(this);
            add(bqx);bqx.setBounds(180, 150, 57, 26);
            bqx.addActionListener(this);
            add(lts); lts.setBounds(40, 180, 240, 22);lts.setAlignment(java.awt.Label.CENTER);
            addWindowListener(new WindowAdapter(){
                public void windowClosing(WindowEvent e2){
                    dispose();
                }
            });
            setVisible(true);
        }
        public void actionPerformed(ActionEvent e){
            if(e.getSource()==bcj){
                if(!tfsrzh.getText().equals("")&&!tfsrmm.getText().equals("")&&!tfcfmm.getText().equals("")&&tfsrmm.getText().equals(tfcfmm.getText()) ){
                    if(tfsrzh.getText().length()<=20&&tfsrmm.getText().length()<=20){
                    try{
                        Class.forName(drivers);
                        Connection con=DriverManager.getConnection(url);
                        Statement stmt=con.createStatement();
                        String sql="insert into zhb(帐号,密码,权限) values('"+tfsrzh.getText()+"','"+tfsrmm.getText()+"','收银员')";
                        String sql1="select *  from zhb where 帐号='"+tfsrzh.getText()+"'";
                        
                        ResultSet rs=stmt.executeQuery(sql1);
                        if(rs.next()){
                            lts.setText("帐号已存在！");
                        } else{
                            
                            stmt.executeUpdate(sql);
                            tfsrzh.setText("");
                            tfsrmm.setText("");
                            tfcfmm.setText("");
                            lts.setText("创建成功！");
                        }
                        stmt.close();
                        con.close();
                    } 
                    catch(java.lang.Exception e1){
                        e1.printStackTrace();
                    }
                    }else{
                        lts.setText("帐号和密码的长度不能超过20！");
                    }
                } else {
                    lts.setText("有空输入框或两次密码不一致！");
                }
            }
            if(e.getSource()==bqx){
                dispose();
            }
        }
        
    }
    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(glyck parent,boolean modal){
            super(parent,modal);
            setTitle("修改密码");
            setSize(324,205);
            setResizable(false);
            setLayout(null);
            setLocation(300,200);
            add(lsrjmm);lsrjmm.setBounds(40, 50, 100, 22);
            add(tfsrjmm);tfsrjmm.setBounds(170, 50, 110, 22);
            tfsrjmm.enableInputMethods(false);
            tfsrjmm.setEchoChar('*');
            add(lsrxmm);lsrxmm.setBounds(40, 80, 90, 22);
            add(tfsrxmm);tfsrxmm.setBounds(170, 80, 110, 22);
            tfsrxmm.enableInputMethods(false);
            tfsrxmm.setEchoChar('*');
            add(lcfxmm);lcfxmm.setBounds(40, 110, 130, 22);
            add(tfcfxmm);tfcfxmm.setBounds(170, 110, 110, 22);
            tfcfxmm.setEchoChar('*');
            tfcfxmm.enableInputMethods(false);
            add(bxg);bxg.setBounds(90, 150, 57, 26);
            bxg.addActionListener(this);
            add(bqx);bqx.setBounds(180, 150, 57, 26);
            bqx.addActionListener(this);
            add(lts);lts.setBounds(40, 180, 240, 22);lts.setAlignment(java.awt.Label.CENTER);
            addWindowListener(new WindowAdapter(){
                public void windowClosing(WindowEvent e2){
                    dispose();
                }
            });
            setVisible(true);
        }
        public void actionPerformed(ActionEvent e){
            if(e.getSource()==bxg){
                if(tfsrxmm.getText().length()<=20){
                try{
                    Class.forName(drivers);
                    Connection con=DriverManager.getConnection(url);
                    Statement stmt=con.createStatement();
                    String sql="select *  from zhb where 帐号='"+glyck.zhanghao+"' and 密码='"+tfsrjmm.getText()+"'";
                    String sql1="Update zhb set 密码='"+tfsrxmm.getText()+"' where 帐号='"+glyck.zhanghao+"'";
                    ResultSet rs=stmt.executeQuery(sql);
                    if(rs.next()){
                        if(tfsrxmm.getText()!=""&&tfsrxmm.getText().equals(tfcfxmm.getText())){
                            stmt.executeUpdate(sql1);
                            tfsrjmm.setText("");
                            tfsrxmm.setText("");
                            tfcfxmm.setText("");
                            lts.setText("修改成功！");
                        } else {
                            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 dxgsj extends Dialog implements ActionListener{
        String spbh;
        Label lsrtxm=new Label("请输入商品的编号：");
        TextField tfsrtxm=new TextField(20);
        Label lspm=new Label("商品名：");
        TextField tfspm=new TextField(20);
        Label lspdj=new Label("商品单价：");
        TextField tfspdj=new TextField(20);
        Button bcx=new Button("查  询");
        Button bxg=new Button("修  改");
        Button bqx=new Button("关  闭");
        Label lts=new Label();
        dxgsj(glyck parent,boolean modal){
            super(parent,modal);
            setTitle("修改数据");
            setSize(347,153);
            setResizable(false);
            setLayout(null);
            addWindowListener(new WindowAdapter(){
                public void windowClosing(WindowEvent e){
                    dispose();
                }
            });
            setLocation(300,200);
            add(lsrtxm);lsrtxm.setBounds(50, 60, 120, 22);
            
            add(tfsrtxm);tfsrtxm.setBounds(180, 60, 110, 22);
            tfsrtxm.addActionListener(this);
            add(bcx);bcx.setBounds(100, 90, 57, 26);
            bcx.addActionListener(this);
            add(lspm);
            lspm.setVisible(false);
            add(tfspm);
            tfspm.setVisible(false);
            tfspm.addActionListener(this);
            add(lspdj);
            lspdj.setVisible(false);
            add(tfspdj);
            tfspdj.setVisible(false);
            tfspdj.addActionListener(this);
            add(bxg);
            bxg.setVisible(false);
            bxg.addActionListener(this);
            add(bqx);bqx.setBounds(190, 90, 57, 26);
            bqx.addActionListener(this);
            add(lts); lts.setBounds(70, 120, 210, 22);lts.setAlignment(java.awt.Label.CENTER);
            setVisible(true);
        }
        public void actionPerformed(ActionEvent e){
            
            if(e.getSource()==bcx){
                if(!tfsrtxm.getText().equals("")){
                    try{
                        Class.forName(drivers);