dbsearch.java

我做的第一个java MIS项目

//～～～～～～～～～～～～～～～～～～～RECORD业务～～～～～～～～～～～～～～～～～//
    //rec重置按钮动作
    public void btnrecreset_actionPerformed(ActionEvent e) {
        cboxreccdid.setSelected(false);txfreccdid.setText("");txfreccdid.setEnabled(false);
        cboxreccardid.setSelected(false);txfreccardid.setText("");txfreccardid.setEnabled(false);
        cboxrecstarttime.setSelected(false);txfrecstarttime1.setText("");txfrecstarttime1.setEnabled(false);txfrecstarttime2.setText("");txfrecstarttime2.setEnabled(false);
        cboxrecendtime.setSelected(false);txfrecendtime1.setText("");txfrecendtime1.setEnabled(false);txfrecendtime2.setText("");txfrecendtime2.setEnabled(false);
    }
    //rec返回按钮动作
    public void btnrecback_actionPerformed(ActionEvent e) {
        //显示查询按钮
        btnrecsearch.setVisible(true);
        btnrecreset.setVisible(true);
        btnrecback.setBounds(new Rectangle(500, 400, 80, 26));
        //显示查询项目
        pnlrec.setBounds(new Rectangle(25, 22, 574, 263));
        pnl3.setBounds(new Rectangle(1083, 1065, 631, 359));
        //删除rs表
        rec.remove(pnl3);
    }
    //rec查询按钮动作
    public void btnrecsearch_actionPerformed(ActionEvent e) {
        //分别得到对应的SQL语句
        if(cboxreccdid.isSelected())
        {strreccdid=" and reccdid = '"+txfreccdid.getText()+"'";}
        else{strreccdid="";}
        if(cboxreccardid.isSelected())
        {strreccardid=" and reccardid = '"+txfreccardid.getText()+"'";}
        else{strreccardid="";}
        if(cboxrecstarttime.isSelected())
        {strrecstarttime=" and recstarttime between '"+txfrecstarttime1.getText()+"' and '"+txfrecstarttime2.getText()+"'";}
        else{strrecstarttime="";}
        if(cboxrecendtime.isSelected())
        {strrecendtime=" and recendtime between '"+txfrecendtime1.getText()+"' and '"+txfrecendtime2.getText()+"'";}
        else{strrecendtime="";}
        //组合sql语句
        String searchrec="select recid as '记录编号',reccdid as '记录影碟编号',reccardid as '记录客户编号',cardusername as '客户姓名',recstarttime as '借阅时间' ,recendtime as '归还时间' from record ,card where 1=1 and reccardid=cardid "+strreccdid+strreccardid+strrecstarttime+strrecendtime;
        queryDataSet1.close();
        queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1,searchrec, null, true, Load.ALL));
        queryDataSet1.open();
        //显示表
        rec.add(pnl3);
        pnl3.setBounds(new Rectangle(25, 22, 574, 263));
        pnlrec.setBounds(new Rectangle(1083, 1065, 631, 359));
        btnrecreset.setVisible(false);
        btnrecback.setBounds(new Rectangle(500, 299, 80, 26));
        //显示返回按钮
        btnrecsearch.setVisible(false);
        btnrecreset.setVisible(false);
        btnrecback.setBounds(new Rectangle(500, 299, 80, 26));
    }
    //rec界面点击选择时的动作
    public void cboxreccdid_actionPerformed(ActionEvent e) {
        if(!cboxreccdid.isSelected())
        {txfreccdid.setEnabled(false);}
        else
        {txfreccdid.setEnabled(true);}
    }
    public void cboxreccardid_actionPerformed(ActionEvent e) {
        if(!cboxreccardid.isSelected())
        {txfreccardid.setEnabled(false);}
        else
        {txfreccardid.setEnabled(true);}
    }
    public void cboxrecstarttime_actionPerformed(ActionEvent e) {
        if(!cboxrecstarttime.isSelected())
        {txfrecstarttime1.setEnabled(false);txfrecstarttime2.setEnabled(false);}
        else
        {txfrecstarttime1.setEnabled(true);txfrecstarttime2.setEnabled(true);}
    }
    public void cboxrecendtime_actionPerformed(ActionEvent e) {
        if(!cboxrecendtime.isSelected())
        {txfrecendtime1.setEnabled(false);txfrecendtime2.setEnabled(false);}
        else
        {txfrecendtime1.setEnabled(true);txfrecendtime2.setEnabled(true);}
    }
//～～～～～～～～～～～～～～～～～～～RECORD业务～～～～～～～～～～～～～～～～～//
}












//监听器
class Dbsearch_cboxcdbalance_actionAdapter implements ActionListener {
    private Dbsearch adaptee;
    Dbsearch_cboxcdbalance_actionAdapter(Dbsearch adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.cboxcardbalance_actionPerformed(e);
    }
}
class Dbsearch_cboxcdrestnum_actionAdapter implements ActionListener {
    private Dbsearch adaptee;
    Dbsearch_cboxcdrestnum_actionAdapter(Dbsearch adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.cboxcardrestnum_actionPerformed(e);
    }
}
class Dbsearch_cboxcdusername_actionAdapter implements ActionListener {
    private Dbsearch adaptee;
    Dbsearch_cboxcdusername_actionAdapter(Dbsearch adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.cboxcardusername_actionPerformed(e);
    }
}
class Dbsearch_btncardback_actionAdapter implements ActionListener {
    private Dbsearch adaptee;
    Dbsearch_btncardback_actionAdapter(Dbsearch adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btncardback_actionPerformed(e);
    }
}
class Dbsearch_cboxcardid_actionAdapter implements ActionListener {
    private Dbsearch adaptee;
    Dbsearch_cboxcardid_actionAdapter(Dbsearch adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.cboxcardid_actionPerformed(e);
    }
}
class Dbsearch_cboxcdid_actionAdapter implements ActionListener {
    private Dbsearch adaptee;
    Dbsearch_cboxcdid_actionAdapter(Dbsearch adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.cboxcdid_actionPerformed(e);
    }
}
class Dbsearch_cboxcdnotes_actionAdapter implements ActionListener {
    private Dbsearch adaptee;
    Dbsearch_cboxcdnotes_actionAdapter(Dbsearch adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.cboxcdnotes_actionPerformed(e);
    }
}
class Dbsearch_cboxcdexist_actionAdapter implements ActionListener {
    private Dbsearch adaptee;
    Dbsearch_cboxcdexist_actionAdapter(Dbsearch adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.cboxcdexist_actionPerformed(e);
    }
}
class Dbsearch_cboxcdname_actionAdapter implements ActionListener {
    private Dbsearch adaptee;
    Dbsearch_cboxcdname_actionAdapter(Dbsearch adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.cboxcdname_actionPerformed(e);
    }
}
class Dbsearch_cboxcdtype_actionAdapter implements ActionListener {
    private Dbsearch adaptee;
    Dbsearch_cboxcdtype_actionAdapter(Dbsearch adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.cboxcdtype_actionPerformed(e);
    }
}
class Dbsearch_cboxcdmtype_actionAdapter implements ActionListener {
    private Dbsearch adaptee;
    Dbsearch_cboxcdmtype_actionAdapter(Dbsearch adaptee) {
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
        adaptee.cboxcdmtype_actionPerformed(e);
    }
}
class Dbsearch_cboxcdactor_actionAdapter implements ActionListener {
    private Dbsearch adaptee;
    Dbsearch_cboxcdactor_actionAdapter(Dbsearch adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.cboxcdactor_actionPerformed(e);
    }
}
class Dbsearch_btncardreset_actionAdapter implements ActionListener {
    private Dbsearch adaptee;
    Dbsearch_btncardreset_actionAdapter(Dbsearch adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {

        adaptee.btncardreset_actionPerformed(e);
    }
}
class Dbsearch_btncdreset_actionAdapter implements ActionListener {
    private Dbsearch adaptee;
    Dbsearch_btncdreset_actionAdapter(Dbsearch adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btncdreset_actionPerformed(e);
    }
}
class Dbsearch_btncdback_actionAdapter implements ActionListener {
    private Dbsearch adaptee;
    Dbsearch_btncdback_actionAdapter(Dbsearch adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btncdback_actionPerformed(e);
    }
}
class Dbsearch_btncardsearch_actionAdapter implements ActionListener {
    private Dbsearch adaptee;
    Dbsearch_btncardsearch_actionAdapter(Dbsearch adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {

        adaptee.btncardsearch_actionPerformed(e);
    }
}
class Dbsearch_btncdsearch2_actionAdapter implements ActionListener {
    private Dbsearch adaptee;
    Dbsearch_btncdsearch2_actionAdapter(Dbsearch adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btncdsearch2_actionPerformed(e);
    }
}
class Dbsearch_cboxrecendtime_actionAdapter implements ActionListener {
    private Dbsearch adaptee;
    Dbsearch_cboxrecendtime_actionAdapter(Dbsearch adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.cboxrecendtime_actionPerformed(e);
    }
}
class Dbsearch_cboxrecstarttime_actionAdapter implements ActionListener {
    private Dbsearch adaptee;
    Dbsearch_cboxrecstarttime_actionAdapter(Dbsearch adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.cboxrecstarttime_actionPerformed(e);
    }
}
class Dbsearch_cboxreccardid_actionAdapter implements ActionListener {
    private Dbsearch adaptee;
    Dbsearch_cboxreccardid_actionAdapter(Dbsearch adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.cboxreccardid_actionPerformed(e);
    }
}
class Dbsearch_cboxreccdid_actionAdapter implements ActionListener {
    private Dbsearch adaptee;
    Dbsearch_cboxreccdid_actionAdapter(Dbsearch adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.cboxreccdid_actionPerformed(e);
    }
}
class Dbsearch_btnrecsearch_actionAdapter implements ActionListener {
    private Dbsearch adaptee;
    Dbsearch_btnrecsearch_actionAdapter(Dbsearch adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnrecsearch_actionPerformed(e);
    }
}
class Dbsearch_btnrecback_actionAdapter implements ActionListener {
    private Dbsearch adaptee;
    Dbsearch_btnrecback_actionAdapter(Dbsearch adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnrecback_actionPerformed(e);
    }
}
class Dbsearch_btnrecreset_actionAdapter implements ActionListener {
    private Dbsearch adaptee;
    Dbsearch_btnrecreset_actionAdapter(Dbsearch adaptee) {
        this.adaptee = adaptee;
    }

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