businessstat.java

我做的第一个java MIS项目

        jButton3.setToolTipText("查询当日归还并超期的碟片详细信息");
        jButton3.setText("查询超期");
        jButton3.addActionListener(new Businessstat_jButton3_actionAdapter(this));
        jButton6.setBounds(new Rectangle(281, 247, 98, 27));
        jButton6.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        jButton6.setToolTipText("查询当年归还并超期的碟片详细信息");
        jButton6.setText("查询超期");
        jButton6.addActionListener(new Businessstat_jButton6_actionAdapter(this));
        querydate8.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(
                database1,
                "select pntrecid as \'超期记录号\' ,cardusername as \'客户名\' , cdname as \'碟片名称\' " +
                ", cdid as \'碟片编号\',cdtype as \'碟片载体\',pntmomey as \'罚款(元)\'  from penalty " +
                ",cd,card,record where penalty.pntrecid=record.recid and record.reccdid=cd.cdid " +
                "and record.reccardid=card.cardid and cdid in (select reccdid from " +
                "record where datediff(mm,getdate(),record.recendtime)=0)", null, true,
                Load.ALL));
        jButton9.setBounds(new Rectangle(281, 247, 98, 27));
        jButton9.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        jButton9.setToolTipText("查询当月归还并超期的碟片详细信息");
        jButton9.setText("查询超期");
        jButton9.addActionListener(new Businessstat_jButton9_actionAdapter(this));
        querydate9.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(
                database1,
                "select pntrecid as \'超期记录号\' ,cardusername as \'客户名\' , cdname as \'碟片名称\' " +
                ", cdid as \'碟片编号\',cdtype as \'碟片载体\',pntmomey as \'罚款(元)\'  from penalty " +
                ",cd,card,record where penalty.pntrecid=record.recid and record.reccdid=cd.cdid " +
                "and record.reccardid=card.cardid and cdid in (select reccdid from " +
                "record where datediff(yy,getdate(),record.recendtime)=0)", null, true,
                Load.ALL));
        this.add(bsntab);
        bsn1.add(jButton1);
        bsn1.add(jButton2);
        bsn1.add(jScrollPane1);
        bsn1.add(jButton3);
        jScrollPane1.getViewport().add(jdbTable1);
        bsn2.add(jButton4);
        bsn2.add(jButton5);
        bsn2.add(jScrollPane2);
        bsn2.add(jButton9);
        jScrollPane2.getViewport().add(jdbTable2);
        bsn3.add(jButton7);
        bsn3.add(jButton8);
        bsn3.add(jScrollPane3);
        bsn3.add(jButton6);
        jScrollPane3.getViewport().add(jdbTable3);
        bsntab.add(bsn1, "本日统计");
        bsntab.add(bsn2, "本月统计");
        bsntab.add(bsn3, "本年统计");
        backpic.setBounds(new Rectangle(0, 0, 796, 476));
        this.add(backpic);

    }
    //查询当日借出
    public void jButton1_actionPerformed(ActionEvent e) {
        //备份SQL
        //select cd.cdid,cd.cdname,cd.cdmtype,card.cardid,card.cardusername, record.recstarttime from cd,record,card where cdid in (select reccdid from record where datediff(day,getdate(),record.recstarttime)=0 and recendtime='1970-01-01')and record.reccdid=cd.cdid and card.cardid=record.reccardid
        jdbTable1.setDataSet(querydate1);
    }

    //查询当日归还
    public void jButton2_actionPerformed(ActionEvent e) {
        //备份SQL
        //select cd.cdid,cd.cdname,cd.cdmtype,card.cardid,card.cardusername from cd,record,card where cdid in (select reccdid from record where datediff(day,getdate(),record.recendtime)=0 )and record.reccdid=cd.cdid and card.cardid=record.reccardid
        jdbTable1.setDataSet(querydate2);
    }

    //查询当月借出
    public void jButton5_actionPerformed(ActionEvent e) {
        //备份SQL
        //select cd.cdid,cd.cdname,cd.cdmtype,card.cardid,card.cardusername from cd,record,card where cdid in (select reccdid from record where datediff(mm,getdate(),record.recstarttime)=0 and recendtime='1970-01-01')and record.reccdid=cd.cdid and card.cardid=record.reccardid
        jdbTable2.setDataSet(querydate3);
    }

    //查询当月归还
    public void jButton4_actionPerformed(ActionEvent e) {
        //备份SQL
        //select cd.cdid,cd.cdname,cd.cdmtype,card.cardid,card.cardusername, record.recstarttime from cd,record,card where cdid in (select reccdid from record where datediff(mm,getdate(),record.recstarttime)=0 and recendtime!='1970-01-01')and record.reccdid=cd.cdid and card.cardid=record.reccardid
        jdbTable2.setDataSet(querydate4);
    }

    //查询当年借出
    public void jButton8_actionPerformed(ActionEvent e) {
        //备份SQL
        //select cd.cdid,cd.cdname,cd.cdmtype,card.cardid,card.cardusername from cd,record,card where cdid in (select reccdid from record where datediff(yy,getdate(),record.recstarttime)=0 and recendtime='1970-01-01')and record.reccdid=cd.cdid and card.cardid=record.reccardid
        jdbTable3.setDataSet(querydate5);
    }

    //查询当年归还
    public void jButton7_actionPerformed(ActionEvent e) {
        //备份SQL
        //select cd.cdid,cd.cdname,cd.cdmtype,card.cardid,card.cardusername from cd,record,card where cdid in (select reccdid from record where datediff(yy,getdate(),record.recstarttime)=0 and recendtime!='1970-01-01')and record.reccdid=cd.cdid and card.cardid=record.reccardid
        jdbTable3.setDataSet(querydate6);
    }
    //查询当日超期记录
    public void jButton3_actionPerformed(ActionEvent e) {
        //备份SQL
        //select pntrecid as '超期记录号' ,cardusername as '客户名' , cdname as '碟片名称' , cdid as '碟片编号',cdtype as '碟片载体',pntmomey as '罚款(元)'  from penalty ,cd,card,record where penalty.pntrecid=record.recid and record.reccdid=cd.cdid and record.reccardid=card.cardid and cdid in (select reccdid from record where datediff(dd,getdate(),record.recendtime)=0)
        jdbTable1.setDataSet(querydate7);
    }
    //查询当年超期记录
    public void jButton6_actionPerformed(ActionEvent e) {
        //备份SQL
        //select pntrecid as '超期记录号' ,cardusername as '客户名' , cdname as '碟片名称' , cdid as '碟片编号',cdtype as '碟片载体',pntmomey as '罚款(元)'  from penalty ,cd,card,record where penalty.pntrecid=record.recid and record.reccdid=cd.cdid and record.reccardid=card.cardid and cdid in (select reccdid from record where datediff(yy,getdate(),record.recendtime)=0)
        jdbTable3.setDataSet(querydate9);
    }
    //查询当月超期记录
    public void jButton9_actionPerformed(ActionEvent e) {
        //备份SQL
        //select pntrecid as '超期记录号' ,cardusername as '客户名' , cdname as '碟片名称' , cdid as '碟片编号',cdtype as '碟片载体',pntmomey as '罚款(元)'  from penalty ,cd,card,record where penalty.pntrecid=record.recid and record.reccdid=cd.cdid and record.reccardid=card.cardid and cdid in (select reccdid from record where datediff(mm,getdate(),record.recendtime)=0)
        jdbTable2.setDataSet(querydate8);
    }
}


class Businessstat_jButton9_actionAdapter implements ActionListener {
    private Businessstat adaptee;
    Businessstat_jButton9_actionAdapter(Businessstat adaptee) {
        this.adaptee = adaptee;
    }

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


class Businessstat_jButton6_actionAdapter implements ActionListener {
    private Businessstat adaptee;
    Businessstat_jButton6_actionAdapter(Businessstat adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {

        adaptee.jButton6_actionPerformed(e);
    }
}


class Businessstat_jButton3_actionAdapter implements ActionListener {
    private Businessstat adaptee;
    Businessstat_jButton3_actionAdapter(Businessstat adaptee) {
        this.adaptee = adaptee;
    }

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


//以下监听器

class Businessstat_jButton8_actionAdapter implements ActionListener {
    private Businessstat adaptee;
    Businessstat_jButton8_actionAdapter(Businessstat adaptee) {
        this.adaptee = adaptee;
    }

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


class Businessstat_jButton4_actionAdapter implements ActionListener {
    private Businessstat adaptee;
    Businessstat_jButton4_actionAdapter(Businessstat adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {

        adaptee.jButton4_actionPerformed(e);
    }
}


class Businessstat_jButton2_actionAdapter implements ActionListener {
    private Businessstat adaptee;
    Businessstat_jButton2_actionAdapter(Businessstat adaptee) {
        this.adaptee = adaptee;
    }

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


class Businessstat_jButton1_actionAdapter implements ActionListener {
    private Businessstat adaptee;
    Businessstat_jButton1_actionAdapter(Businessstat adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {

        adaptee.jButton1_actionPerformed(e);
    }
}


class Businessstat_jButton7_actionAdapter implements ActionListener {
    private Businessstat adaptee;
    Businessstat_jButton7_actionAdapter(Businessstat adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {

        adaptee.jButton7_actionPerformed(e);
    }
}


class Businessstat_jButton5_actionAdapter implements ActionListener {
    private Businessstat adaptee;
    Businessstat_jButton5_actionAdapter(Businessstat adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {

        adaptee.jButton5_actionPerformed(e);
    }
}