businessstat.java

我做的第一个java MIS项目

//业务统计面板
package client;

import javax. swing. *;
import java.awt.*;
import com.borland.dbswing.JdbTable;
import com.borland.dx.sql.dataset.Database;
import com.borland.dx.sql.dataset.*;
import com.borland.dx.dataset.TableDataSet;
import com.borland.dbswing.DBTableModel;
import com.borland.dx.dataset.Column;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.border.TitledBorder;
import server.entity.Time;
import server.action.BusinessAction;
import java.util.Vector;
import com.borland.dx.dataset.*;

public class Businessstat extends JPanel
{
    //创建面板
    JTabbedPane bsntab = new JTabbedPane();
    JPanel bsn1=new JPanel();
    JPanel bsn2=new JPanel();
    JPanel bsn3=new JPanel();
    JdbTable jdbTable1 = new JdbTable();
    Database database1 = new Database();
    DBTableModel dBTableModel1 = new DBTableModel();
    Column column1 = new Column();
    String string1 = "";
    JButton jButton1 = new JButton();
    QueryDataSet querydate2 = new QueryDataSet();
    JButton jButton2 = new JButton();
    QueryDataSet query0 = new QueryDataSet();
    TitledBorder titledBorder1 = new TitledBorder("");
    Column column2 = new Column();
    Column column3 = new Column();
    Column column4 = new Column();
    Column column5 = new Column();
    Column column6 = new Column();
    QueryDataSet querydate1 = new QueryDataSet();
    JdbTable jdbTable2 = new JdbTable();
    JdbTable jdbTable3 = new JdbTable();
    JButton jButton4 = new JButton();
    JButton jButton5 = new JButton();
    JButton jButton7 = new JButton();
    JButton jButton8 = new JButton();
    QueryDataSet querydate3 = new QueryDataSet();

    QueryDataSet querydate4 = new QueryDataSet();
    QueryDataSet querydate5 = new QueryDataSet();
    QueryDataSet querydate6 = new QueryDataSet();
    JScrollPane jScrollPane1 = new JScrollPane();
    JScrollPane jScrollPane2 = new JScrollPane();
    JScrollPane jScrollPane3 = new JScrollPane();
    QueryDataSet querydate7 = new QueryDataSet();
    JButton jButton3 = new JButton();
    JButton jButton6 = new JButton();
    QueryDataSet querydate8 = new QueryDataSet();
    QueryDataSet querydate9 = new QueryDataSet();
    JButton jButton9 = new JButton();
    JLabel backpic = new JLabel(new ImageIcon(".\\pic\\mainback.jpg"));

    public Businessstat() {
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    private void jbInit() throws Exception {

        this.setLayout(null);
        bsntab.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        bsntab.setBounds(new Rectangle(115, 60, 570,310));
        bsn1.setLayout(null);
        column1.setColumnName("cdtype");
        column1.setDataType(com.borland.dx.dataset.Variant.INT);
        column1.setPrecision(50);
        column1.setTableName("cd");
        column1.setServerColumnName("cdtype");
        column1.setSqlType(12);
        jdbTable1.setFont(new Font("宋体", Font.PLAIN, 12));
        jdbTable1.setBorder(BorderFactory.createEtchedBorder());
        jdbTable1.setToolTipText(string1);
        jdbTable1.setAutoResizeMode(JTable.AUTO_RESIZE_ALL_COLUMNS);
        jdbTable1.setDataSet(query0);
        jdbTable1.setEditable(false);
        database1.setConnection(new ConnectionDescriptor("jdbc:odbc:mrs", "","", false, "sun.jdbc.odbc.JdbcOdbcDriver"));
        database1.setDatabaseName("");
        jButton2.setBounds(new Rectangle(164, 247, 98, 27));
        jButton2.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        jButton2.setToolTipText("查询当日已经归还的碟片详细信息");
        jButton2.setText("查询归还");
        jButton2.addActionListener(new Businessstat_jButton2_actionAdapter(this));
        column2.setColumnName("cdid");
        column2.setDataType(com.borland.dx.dataset.Variant.STRING);
        column2.setPrecision(50);
        column2.setTableName("cd");
        column2.setServerColumnName("cdid");
        column2.setSqlType(12);
        column3.setColumnName("cdname");
        column3.setDataType(com.borland.dx.dataset.Variant.STRING);
        column3.setPrecision(255);
        column3.setTableName("cd");
        column3.setServerColumnName("cdname");
        column3.setSqlType(12);
        column4.setColumnName("cdmtype");
        column4.setDataType(com.borland.dx.dataset.Variant.STRING);
        column4.setPrecision(50);
        column4.setTableName("cd");
        column4.setServerColumnName("cdmtype");
        column4.setSqlType(12);
        column5.setColumnName("cardid");
        column5.setDataType(com.borland.dx.dataset.Variant.STRING);
        column5.setPrecision(50);
        column5.setTableName("card");
        column5.setServerColumnName("cardid");
        column5.setSqlType(12);
        column6.setColumnName("cardusername");
        column6.setDataType(com.borland.dx.dataset.Variant.STRING);
        column6.setPrecision(100);
        column6.setTableName("card");
        column6.setServerColumnName("cardusername");
        column6.setSqlType(12);
        jButton1.addActionListener(new Businessstat_jButton1_actionAdapter(this));
        bsn2.setLayout(null);
        jdbTable2.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        jdbTable2.setBorder(BorderFactory.createEtchedBorder());
        jdbTable2.setToolTipText("");
        jdbTable2.setAutoResizeMode(JTable.AUTO_RESIZE_ALL_COLUMNS);
        jdbTable2.setDataSet(query0);
        jdbTable2.setHiddenColumns(null);
        jdbTable2.setEditable(false);
        bsn3.setLayout(null);
        jdbTable3.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        jdbTable3.setBorder(BorderFactory.createEtchedBorder());
        jdbTable3.setToolTipText("");
        jdbTable3.setAutoResizeMode(JTable.AUTO_RESIZE_ALL_COLUMNS);
        jdbTable3.setDataSet(query0);
        jdbTable3.setEditable(false);
        jButton4.setBounds(new Rectangle(164, 247, 98, 27));
        jButton4.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        jButton4.setToolTipText("查询当月已经归还的碟片详细信息");
        jButton4.setText("查询归还");
        jButton4.addActionListener(new Businessstat_jButton4_actionAdapter(this));
        jButton5.setBounds(new Rectangle(47, 247, 98, 27));
        jButton5.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        jButton5.setToolTipText("查询当月已经借出的碟片详细信息");
        jButton5.setText("查询借出");
        jButton5.addActionListener(new Businessstat_jButton5_actionAdapter(this));
        jButton7.setBounds(new Rectangle(164, 247, 98, 27));
        jButton7.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        jButton7.setToolTipText("查询当年已经归还的碟片详细信息");
        jButton7.setText("查询归还");
        jButton7.addActionListener(new Businessstat_jButton7_actionAdapter(this));
        jButton8.setBounds(new Rectangle(47, 247, 98, 27));
        jButton8.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        jButton8.setToolTipText("查询当年已经借出的碟片详细信息");
        jButton8.setText("查询借出");
        jButton8.addActionListener(new Businessstat_jButton8_actionAdapter(this));
        querydate4.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(
                database1, "select cd.cdid as \'碟片编号\',cd.cdname as \'电影名称\',cd.cdmtype as \'电影种类\',card.cardid " +
                "as \'帐户卡号\',card.cardusername as \'帐户名称\' 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\n" +
                "\n", null, true, Load.ALL));
        jButton5.addActionListener(new Businessstat_jButton5_actionAdapter(this));
        querydate1.setDisplayErrors(true);
        querydate1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(
                database1, "select cd.cdid as \'碟片编号\',cd.cdname as \'电影名称\',cd.cdmtype as \'电影种类\',card.cardid " +
                "as \'帐户卡号\',card.cardusername as \'帐户名称\' 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\n" +
                "  ", null, true, Load.AS_NEEDED));
        querydate2.setSchemaName("");
        querydate2.setResolveOrder(new String[] {"cd", "record", "card"});
        querydate2.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(
                database1, "select cd.cdid as \'碟片编号\',cd.cdname as \'电影名称\',cd.cdmtype as \'电影种类\',card.cardid " +
                "as \'帐户卡号\',card.cardusername as \'帐户名称\' 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\n  ", null, true,
                Load.ALL));
        querydate3.setDisplayErrors(true);
        querydate3.setProvider(null);
        querydate3.setResolveOrder(null);
        querydate3.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(
                database1, "select cd.cdid as \'碟片编号\',cd.cdname as \'电影名称\',cd.cdmtype as \'电影种类\',card.cardid " +
                "as \'帐户卡号\',card.cardusername as \'帐户名称\' 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\n", null, true,
                Load.ALL));

        querydate6.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(
                database1, "select cd.cdid as \'碟片编号\',cd.cdname as \'电影名称\',cd.cdmtype as \'电影种类\',card.cardid " +
                "as \'帐户卡号\',card.cardusername as \'帐户名称\' 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\n", null, true,
                Load.ALL));
        jButton1.setBounds(new Rectangle(47, 247, 98, 27));
        jButton1.setText("查询借出");
        jButton1.setFont(new Font("宋体",0,12));
        jButton1.setToolTipText("查询当日已经借出的碟片详细信息");
        jButton1.addActionListener(new Businessstat_jButton1_actionAdapter(this));
        jScrollPane1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        jScrollPane1.setBounds(new Rectangle(25, 25, 512, 207));
        jScrollPane2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        jScrollPane2.setBounds(new Rectangle(25, 25, 512, 207));
        jScrollPane3.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        jScrollPane3.setBounds(new Rectangle(25, 25, 512, 207));
        querydate5.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(
                database1, "select cd.cdid as \'碟片编号\',cd.cdname as \'电影名称\',cd.cdmtype as \'电影种类\',card.cardid " +
                "as \'帐户卡号\',card.cardusername as \'帐户名称\' 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\n", null, true,
                Load.ALL));
        querydate7.setProvider(null);
        querydate7.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(dd,getdate(),record.recendtime)=0)", null, true,
                Load.ALL));
        jButton3.setBounds(new Rectangle(281, 247, 98, 27));
        jButton3.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));