dbmanage.java

我做的第一个java MIS项目

    //—————————————————CD表操作—————————————————
    //CD表增加按钮动作
    public void dbcdbtnadd_actionPerformed(ActionEvent e) {
        dialogtemp.setflag(1);
        new dbcdDialog().show();
        qdbcd.refresh();
    }
    //CD表修改按钮动作
    public void dbcdbtnmdf_actionPerformed(ActionEvent e) {
        dialogtemp.setflag(2);
        //存入到临时Vector
        Vector mdf=new Vector();
        mdf.addElement(mdfcdid.getText());
        mdf.addElement(mdfcdexist.getText());
        mdf.addElement(mdfcdusername.getText());
        mdf.addElement(mdfcdtype.getText());
        mdf.addElement(mdfcdmtype.getText());
        mdf.addElement(mdfcdactor.getText());
        mdf.addElement(mdfcdnote.getText());
        dialogtemp.cleanvector();
        dialogtemp.setmdfvector(mdf);

        new dbcdDialog().show();
        qdbcd.refresh();
    }
    //CD表双击表的动作
    public void dbtablecd_mouseClicked(MouseEvent e){
        if(e.getClickCount()==2)
        {
            //修改表记录
            dialogtemp.setflag(2);
            //存入到临时Vector
            Vector mdf=new Vector();
            mdf.addElement(mdfcdid.getText());
            mdf.addElement(mdfcdexist.getText());
            mdf.addElement(mdfcdusername.getText());
            mdf.addElement(mdfcdtype.getText());
            mdf.addElement(mdfcdmtype.getText());
            mdf.addElement(mdfcdactor.getText());
            mdf.addElement(mdfcdnote.getText());
            dialogtemp.cleanvector();
            dialogtemp.setmdfvector(mdf);

            new dbcdDialog().show();
            qdbcd.refresh();
        }
    }
    //CD表删除按钮动作
    public void dbcdbtndel_actionPerformed(ActionEvent e) {
        //再次确定
        int confirm=0;
        confirm=JOptionPane.showConfirmDialog(this,"是否删除选定的记录？","删除确认",JOptionPane.YES_NO_OPTION,JOptionPane.QUESTION_MESSAGE);
        if(confirm==0)
        {
            new RunSQL().runsql("delete cd where cdid='"+ mdfcdid.getText()+"'");
            qdbcd.refresh();
        }
    }
//—————————————————CD表操作—————————————————



//————————————————CARD表操作————————————————
    //CARD表增加按钮动作
    public void dbcardbtnadd_actionPerformed(ActionEvent e) {
        dialogtemp.setflag(3);
        new dbcdDialog().show();
        qdbcard.refresh();
    }
    //CARD表修改按钮动作
    public void dbcardbtnmdf_actionPerformed(ActionEvent e) {
        dialogtemp.setflag(4);
        //存入到临时Vector
        Vector mdfcard=new Vector();
        mdfcard.addElement(mdfcardid.getText());
        mdfcard.addElement(mdfcardpwd.getText());
        mdfcard.addElement(mdfcardusername.getText());
        mdfcard.addElement(mdfcardbalance.getText());
        mdfcard.addElement(mdfcardrestnum.getText());
        dialogtemp.cleanvector();
        dialogtemp.setmdfvector(mdfcard);

        new dbcdDialog().show();
        qdbcard.refresh();
    }
    //CARD表删除按钮动作
    public void dbcardbtndel_actionPerformed(ActionEvent e) {
        //再次确定
        int confirm=0;
        confirm=JOptionPane.showConfirmDialog(this,"是否删除选定的记录？","删除确认",JOptionPane.YES_NO_OPTION,JOptionPane.QUESTION_MESSAGE);
        if(confirm==0)
        {
            new RunSQL().runsql("delete card where cardid='"+ mdfcardid.getText()+"'");
            qdbcard.refresh();
        }
    }
    //CARD表双击表的动作
    public void dbtablecard_mouseClicked(MouseEvent e) {
        if(e.getClickCount()==2)
        {
            dialogtemp.setflag(4);
            //存入到临时Vector
            Vector mdfcard=new Vector();
            mdfcard.addElement(mdfcardid.getText());
            mdfcard.addElement(mdfcardpwd.getText());
            mdfcard.addElement(mdfcardusername.getText());
            mdfcard.addElement(mdfcardbalance.getText());
            mdfcard.addElement(mdfcardrestnum.getText());
            dialogtemp.cleanvector();
            dialogtemp.setmdfvector(mdfcard);

            new dbcdDialog().show();
            qdbcard.refresh();
        }
    }
//————————————————CARD表操作————————————————



//————————————————REC表操作————————————————
    //REC表增加按钮动作
    public void dbrecbtnadd_actionPerformed(ActionEvent e) {
        dialogtemp.setflag(5);
        new dbcdDialog().show();
        qdbrec.refresh();
    }
    //REC表编辑按钮动作
    public void dbrecbtnmdf_actionPerformed(ActionEvent e) {
        dialogtemp.setflag(6);
        //存入到临时Vector
        Vector mdfrec=new Vector();
        mdfrec.addElement(mdfrecid.getText());
        mdfrec.addElement(mdfreccardid.getText());
        mdfrec.addElement(mdfreccdid.getText());
        mdfrec.addElement(mdfrecstarttime.getText());
        mdfrec.addElement(mdfrecendtime.getText());
        dialogtemp.cleanvector();
        dialogtemp.setmdfvector(mdfrec);

        new dbcdDialog().show();
        qdbrec.refresh();
    }
    //REC表删除按钮动作
    public void dbrecbtndel_actionPerformed(ActionEvent e) {
        //再次确定
        int confirm=0;
        confirm=JOptionPane.showConfirmDialog(this,"是否删除选定的记录？","删除确认",JOptionPane.YES_NO_OPTION,JOptionPane.QUESTION_MESSAGE);
        if(confirm==0)
        {
            new RunSQL().runsql("delete record where recid='"+ mdfrecid.getText()+"'");
            qdbrec.refresh();
        }
    }
    //REC表双击表的动作
    public void dbtablerec_mouseClicked(MouseEvent e) {
        if(e.getClickCount()==2)
        {
            dialogtemp.setflag(6);
            //存入到临时Vector
            Vector mdfrec=new Vector();
            mdfrec.addElement(mdfrecid.getText());
            mdfrec.addElement(mdfreccardid.getText());
            mdfrec.addElement(mdfreccdid.getText());
            mdfrec.addElement(mdfrecstarttime.getText());
            mdfrec.addElement(mdfrecendtime.getText());
            dialogtemp.cleanvector();
            dialogtemp.setmdfvector(mdfrec);

            new dbcdDialog().show();
            qdbrec.refresh();
        }
    }
//————————————————REC表操作————————————————
}


class Dbmanage_dbtablerec_mouseAdapter extends MouseAdapter {
    private Dbmanage adaptee;
    Dbmanage_dbtablerec_mouseAdapter(Dbmanage adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseClicked(MouseEvent e) {
        adaptee.dbtablerec_mouseClicked(e);
    }
}


class Dbmanage_dbrecbtndel_actionAdapter implements ActionListener {
    private Dbmanage adaptee;
    Dbmanage_dbrecbtndel_actionAdapter(Dbmanage adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.dbrecbtndel_actionPerformed(e);
    }
}


class Dbmanage_dbrecbtnmdf_actionAdapter implements ActionListener {
    private Dbmanage adaptee;
    Dbmanage_dbrecbtnmdf_actionAdapter(Dbmanage adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.dbrecbtnmdf_actionPerformed(e);
    }
}


class Dbmanage_dbrecbtnadd_actionAdapter implements ActionListener {
    private Dbmanage adaptee;
    Dbmanage_dbrecbtnadd_actionAdapter(Dbmanage adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.dbrecbtnadd_actionPerformed(e);
    }
}


//监听器
class Dbmanage_dbtablecard_mouseAdapter extends MouseAdapter {
    private Dbmanage adaptee;
    Dbmanage_dbtablecard_mouseAdapter(Dbmanage adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseClicked(MouseEvent e) {
        adaptee.dbtablecard_mouseClicked(e);
    }
}
class Dbmanage_dbcardbtnadd_actionAdapter implements ActionListener {
    private Dbmanage adaptee;
    Dbmanage_dbcardbtnadd_actionAdapter(Dbmanage adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.dbcardbtnadd_actionPerformed(e);
    }
}
class Dbmanage_dbcardbtnmdf_actionAdapter implements ActionListener {
    private Dbmanage adaptee;
    Dbmanage_dbcardbtnmdf_actionAdapter(Dbmanage adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.dbcardbtnmdf_actionPerformed(e);
    }
}
class Dbmanage_dbcardbtndel_actionAdapter implements ActionListener {
    private Dbmanage adaptee;
    Dbmanage_dbcardbtndel_actionAdapter(Dbmanage adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.dbcardbtndel_actionPerformed(e);
    }
}
class Dbmanage_dbcdbtnmdf_actionAdapter implements ActionListener {
    private Dbmanage adaptee;
    Dbmanage_dbcdbtnmdf_actionAdapter(Dbmanage adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.dbcdbtnmdf_actionPerformed(e);
    }
}
class Dbmanage_dbcdbtndel_actionAdapter implements ActionListener {
    private Dbmanage adaptee;
    Dbmanage_dbcdbtndel_actionAdapter(Dbmanage adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {

        adaptee.dbcdbtndel_actionPerformed(e);
    }
}
class Dbmanage_dbtablecd_mouseAdapter extends MouseAdapter {
    private Dbmanage adaptee;
    Dbmanage_dbtablecd_mouseAdapter(Dbmanage adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseClicked(MouseEvent e) {
        adaptee.dbtablecd_mouseClicked(e);
    }
}
class Dbmanage_dbcdbtnadd_actionAdapter implements ActionListener {
    private Dbmanage adaptee;
    Dbmanage_dbcdbtnadd_actionAdapter(Dbmanage adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {

        adaptee.dbcdbtnadd_actionPerformed(e);
    }
}