dbsearch.java

我做的第一个java MIS项目

package client;

import java.awt.*;
import javax.swing.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import com.borland.dx.sql.dataset.Database;
import com.borland.dx.sql.dataset.QueryDataSet;
import com.borland.dbswing.JdbTable;
import com.borland.dx.sql.dataset.*;

//数据查询模块
public class Dbsearch extends JPanel
{
    public Dbsearch() {
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        this.setLayout(null);
        tabpnl.setBounds(new Rectangle(83, 45, 631, 359));
        card.setLayout(null);
        cd.setLayout(null);
        rec.setLayout(null);
        pnlcard.setBorder(BorderFactory.createEtchedBorder());
        pnlcard.setLayout(null);
        btncardback.setBounds(new Rectangle(366, 400, 80, 26));
        btncardsearch.setBounds(new Rectangle(366, 299, 80, 26));
        btncardsearch.addActionListener(new
                                        Dbsearch_btncardsearch_actionAdapter(this));
        btncardback.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        btncardback.setText("返  回");
        btncardback.addActionListener(new Dbsearch_btncardback_actionAdapter(this));
        txfcdactor.setEnabled(false);
        txfcdactor.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        txfcdactor.setToolTipText("主演名中包含的字词");
        txfcdactor.setBounds(new Rectangle(414, 152, 121, 25));
        cboxcdexist.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        cboxcdexist.setToolTipText("");
        cboxcdexist.setText("是否在库：");
        cboxcdexist.setBounds(new Rectangle(317, 67, 94, 18));
        cboxcdexist.addActionListener(new Dbsearch_cboxcdexist_actionAdapter(this));
        txfcdname.setEnabled(false);
        txfcdname.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        txfcdname.setToolTipText("影片名中包含的字词");
        txfcdname.setBounds(new Rectangle(152, 109, 121, 23));
        txfcdid.setEnabled(false);
        txfcdid.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        txfcdid.setToolTipText("碟片编号的限定条件");
        txfcdid.setBounds(new Rectangle(152, 64, 121, 25));
        cboxcdid.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        cboxcdid.setToolTipText("");
        cboxcdid.setText("碟片编号：");
        cboxcdid.setBounds(new Rectangle(61, 67, 89, 18));
        cboxcdid.addActionListener(new Dbsearch_cboxcdid_actionAdapter(this));
        pnlcd.setBorder(BorderFactory.createEtchedBorder());
        pnlcd.setBounds(new Rectangle(25, 22, 574, 263));
        pnlrec.setBorder(BorderFactory.createEtchedBorder());
        pnlrec.setBounds(new Rectangle(25, 22, 574, 263));
        pnlcard.setBounds(new Rectangle(25, 22, 574, 263));
        pnlcd.setLayout(null);
        btncdreset.setBounds(new Rectangle(500, 299, 80, 26));






        btncdreset.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        btncdreset.setToolTipText("");
        btncdreset.setText("重  置");
        btncdreset.addActionListener(new Dbsearch_btncdreset_actionAdapter(this));
        btncdback.setBounds(new Rectangle(366, 400, 80, 26));
        btncdback.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        btncdback.setText("返  回");
        btncdback.addActionListener(new Dbsearch_btncdback_actionAdapter(this));
        cboxcdexistyes.setEnabled(false);
        cboxcdexistyes.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        cboxcdexistyes.setToolTipText("选中表示碟片未借出");
        cboxcdexistyes.setText("在 库");
        cboxcdexistyes.setBounds(new Rectangle(414, 67, 82, 18));
        cboxcdtype.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        cboxcdtype.setToolTipText("");
        cboxcdtype.setText("载体种类：");
        cboxcdtype.setBounds(new Rectangle(317, 111, 85, 18));
        cboxcdtype.addActionListener(new Dbsearch_cboxcdtype_actionAdapter(this));
        cboxcdname.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        cboxcdname.setToolTipText("");
        cboxcdname.setText("影片名称：");
        cboxcdname.setBounds(new Rectangle(61, 111, 86, 18));
        cboxcdname.addActionListener(new Dbsearch_cboxcdname_actionAdapter(this));
        cobcdtype.setEnabled(false);
        cobcdtype.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        cobcdtype.setToolTipText("选择碟片种类");
        cobcdtype.setBounds(new Rectangle(414, 109, 121, 23));
        cboxcdmtype.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        cboxcdmtype.setToolTipText("");
        cboxcdmtype.setText("影片种类：");
        cboxcdmtype.setBounds(new Rectangle(61, 154, 89, 18));
        cboxcdmtype.addActionListener(new Dbsearch_cboxcdmtype_actionAdapter(this));
        cobcdmtype.setEnabled(false);
        cobcdmtype.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        cobcdmtype.setToolTipText("选择影片类型");
        cobcdmtype.setBounds(new Rectangle(152, 153, 121, 23));
        cboxcdactor.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        cboxcdactor.setToolTipText("");
        cboxcdactor.setText("主  演：");
        cboxcdactor.setBounds(new Rectangle(317, 155, 89, 18));
        cboxcdactor.addActionListener(new Dbsearch_cboxcdactor_actionAdapter(this));
        cboxcdnotes.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        cboxcdnotes.setToolTipText("");
        cboxcdnotes.setText("备  注：");
        cboxcdnotes.setBounds(new Rectangle(61, 198, 89, 18));
        cboxcdnotes.addActionListener(new Dbsearch_cboxcdnotes_actionAdapter(this));
        txacdnotes.setBackground(new Color(210, 210, 210));
        txacdnotes.setEnabled(false);
        txacdnotes.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        txacdnotes.setBorder(BorderFactory.createEtchedBorder());
        txacdnotes.setToolTipText("影片备注中包含的字词");
        txacdnotes.setText("");
        txacdnotes.setBounds(new Rectangle(152, 198, 385, 46));
        jLabel5.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        jLabel5.setDisplayedMnemonic('0');
        jLabel5.setBounds(new Rectangle(23, 11, 174, 31));
        cboxcardid.addActionListener(new Dbsearch_cboxcardid_actionAdapter(this));
        btncardreset.addActionListener(new Dbsearch_btncardreset_actionAdapter(this));
        btncardreset.addActionListener(new Dbsearch_btncardreset_actionAdapter(this));
        btncdsearch2.setBounds(new Rectangle(366, 299, 80, 26));
        btncdsearch2.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        btncdsearch2.setText("查  询");
        btncdsearch2.addActionListener(new Dbsearch_btncdsearch2_actionAdapter(this));
        jdbTable2.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        jdbTable2.setAutoResizeMode(JTable.AUTO_RESIZE_ALL_COLUMNS);
        jdbTable2.setCellSelectionEnabled(true);
        jdbTable2.setDataSet(queryDataSet1);
        jdbTable2.setEditable(false);
        spnlcd.setBounds(new Rectangle(0, 0, 746, 572));
        spnlrec.setBorder(BorderFactory.createEtchedBorder());
        spnlrec.setBounds(new Rectangle(0, 0, 181, 165));
        pnl2.setLayout(null);
        pnl3.setLayout(null);
        pnl3.setBounds(new Rectangle(0, 0, 1, 1));
        jdbTable3.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        jdbTable3.setDoubleBuffered(true);
        jdbTable3.setAutoResizeMode(JTable.AUTO_RESIZE_ALL_COLUMNS);
        jdbTable3.setDataSet(queryDataSet1);
        jdbTable3.setEditable(false);
        pnlrec.setLayout(null);
        jLabel7.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        jLabel7.setDisplayedMnemonic('0');
        jLabel7.setBounds(new Rectangle(23, 11, 174, 31));
        cboxreccardid.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        cboxreccardid.setToolTipText("");
        cboxreccardid.setText("记录客户卡号：");
        cboxreccardid.setBounds(new Rectangle(61, 111, 114, 18));
        cboxreccardid.addActionListener(new
                                        Dbsearch_cboxreccardid_actionAdapter(this));
        jLabel8.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        jLabel8.setText("到");
        jLabel8.setBounds(new Rectangle(315, 192, 23, 30));
        txfreccardid.setEnabled(false);
        txfreccardid.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        txfreccardid.setToolTipText("会员卡号的限定条件");
        txfreccardid.setBounds(new Rectangle(190, 108, 208, 25));
        jLabel10.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        jLabel10.setText("到");
        jLabel10.setBounds(new Rectangle(315, 148, 23, 30));
        txfrecendtime2.setEnabled(false);
        txfrecendtime2.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        txfrecendtime2.setToolTipText("归还时间限定的结束时间");
        txfrecendtime2.setBounds(new Rectangle(353, 195, 107, 25));
        txfrecstarttime2.setEnabled(false);
        txfrecstarttime2.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        txfrecstarttime2.setToolTipText("借阅时间限定的结束时间");
        txfrecstarttime2.setBounds(new Rectangle(353, 151, 107, 25));
        txfrecstarttime1.setEnabled(false);
        txfrecstarttime1.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        txfrecstarttime1.setToolTipText("借阅时间限定的起始时间");
        txfrecstarttime1.setText("");
        txfrecstarttime1.setBounds(new Rectangle(190, 151, 107, 25));
        txfrecendtime1.setEnabled(false);
        txfrecendtime1.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        txfrecendtime1.setToolTipText("归还时间限定的起始时间");
        txfrecendtime1.setText("");
        txfrecendtime1.setBounds(new Rectangle(190, 195, 107, 25));
        cboxrecstarttime.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        cboxrecstarttime.setToolTipText("");
        cboxrecstarttime.setText("借阅时间：");
        cboxrecstarttime.setBounds(new Rectangle(61, 154, 88, 18));
        cboxrecstarttime.addActionListener(new
                Dbsearch_cboxrecstarttime_actionAdapter(this));
        cboxreccdid.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        cboxreccdid.setToolTipText("");
        cboxreccdid.setText("记录影碟编号：");
        cboxreccdid.setBounds(new Rectangle(61, 67, 113, 18));
        cboxreccdid.addActionListener(new Dbsearch_cboxreccdid_actionAdapter(this));
        cboxrecendtime.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        cboxrecendtime.setToolTipText("");
        cboxrecendtime.setText("归还时间：");
        cboxrecendtime.setBounds(new Rectangle(61, 198, 119, 18));
        cboxrecendtime.addActionListener(new
                                         Dbsearch_cboxrecendtime_actionAdapter(this));
        txfreccdid.setEnabled(false);
        txfreccdid.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        txfreccdid.setToolTipText("碟片编号的限定条件");
        txfreccdid.setBounds(new Rectangle(190, 64, 208, 25));
        btnrecback.setBounds(new Rectangle(500, 400, 80, 26));
        btnrecback.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        btnrecback.setText("返  回");
        btnrecback.addActionListener(new Dbsearch_btnrecback_actionAdapter(this));
        btnrecreset.setBounds(new Rectangle(269, 328, 80, 26));
        btnrecreset.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        btnrecreset.setText("重  置");
        btnrecreset.addActionListener(new Dbsearch_btnrecreset_actionAdapter(this));
        btnrecsearch.setBounds(new Rectangle(366, 299, 80, 26));
        btnrecreset.setBounds(new Rectangle(500, 299, 80, 26));
        btnrecsearch.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        btnrecsearch.setText("查  询");
        btnrecsearch.addActionListener(new Dbsearch_btnrecsearch_actionAdapter(this));
        spnlcard.setBorder(BorderFactory.createEtchedBorder());
        pnl2.setBorder(BorderFactory.createEtchedBorder());
        txfcardid.setToolTipText("会员卡号的限定条件");
        txfcardusername.setToolTipText("会员卡帐户名的限定条件");
        txfcardbalance1.setToolTipText("会员卡余额的限定条件");
        txfcardbalance2.setToolTipText(
                "会员卡余额的限定条件");
        txfcardrestnum1.setToolTipText("还可以租借碟片数量的限定条件");
        txfcardrestnum2.setToolTipText("还可以租借碟片数量的限定条件");
        jdbTable1.setEditable(false);
        spnlcard.getViewport().add(jdbTable1);
        jdbTable1.setFont(new Font("宋体",0,12));
        pnl1.add(spnlcard);
        jLabel1.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        jLabel1.setDisplayedMnemonic('0');
        jLabel1.setText("请选择需要查询的项目：");
        jLabel1.setBounds(new Rectangle(23, 11, 402, 31));
        txfcardid.setEnabled(false);
        txfcardid.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        txfcardid.setText("");
        txfcardid.setBounds(new Rectangle(190, 64, 253, 25));
        txfcardusername.setEnabled(false);
        txfcardusername.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        txfcardusername.setText("");
        txfcardusername.setBounds(new Rectangle(190, 108, 253, 25));
        txfcardbalance1.setEnabled(false);
        txfcardbalance1.setText("");
        txfcardbalance1.setBounds(new Rectangle(190, 153, 76, 25));
        txfcardbalance2.setEnabled(false);
        txfcardbalance2.setText("");
        txfcardbalance2.setBounds(new Rectangle(337, 153, 76, 25));
        txfcardrestnum1.setEnabled(false);
        txfcardrestnum1.setText("");
        txfcardrestnum1.setBounds(new Rectangle(190, 199, 76, 25));
        txfcardrestnum2.setEnabled(false);
        txfcardrestnum2.setText("");
        txfcardrestnum2.setBounds(new Rectangle(337, 199, 76, 25));
        cboxcardid.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        cboxcardid.setText("帐户卡号：");
        cboxcardid.setBounds(new Rectangle(61, 67, 119, 18));
        cboxcardusername.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        cboxcardusername.setText("帐户名：");
        cboxcardusername.setBounds(new Rectangle(61, 111, 119, 18));
        cboxcardusername.addActionListener(new Dbsearch_cboxcdusername_actionAdapter(this));
        cboxcardbalance.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        cboxcardbalance.setText("帐户余额：");
        cboxcardbalance.setBounds(new Rectangle(61, 154, 119, 18));
        cboxcardbalance.addActionListener(new Dbsearch_cboxcdbalance_actionAdapter(this));
        cboxcardrestnum.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        cboxcardrestnum.setText("可借碟数：");
        cboxcardrestnum.setBounds(new Rectangle(61, 198, 119, 18));
        cboxcardrestnum.addActionListener(new Dbsearch_cboxcdrestnum_actionAdapter(this));
        jLabel2.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        jLabel2.setText("张  到");
        jLabel2.setBounds(new Rectangle(269, 196, 54, 30));
        jLabel3.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        jLabel3.setText("元");
        jLabel3.setBounds(new Rectangle(421, 150, 54, 30));
        jLabel4.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        jLabel4.setText("元  到");
        jLabel4.setBounds(new Rectangle(269, 150, 54, 30));
        jLabel6.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        jLabel6.setText("张");
        jLabel6.setBounds(new Rectangle(421, 196, 54, 30));
        btncardreset.setBounds(new Rectangle(500, 299, 80, 26));
        btncardreset.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        btncardreset.setToolTipText("");
        btncardreset.setText("重  置");

        btncardsearch.setFont(new java.awt.Font("宋体", Font.PLAIN, 12));
        btncardsearch.setToolTipText("");
        btncardsearch.setText("查  询");
        database1.setConnection(new ConnectionDescriptor("jdbc:odbc:mrs", "","", false, "sun.jdbc.odbc.JdbcOdbcDriver"));
        pnl1.setLayout(null);

        jdbTable1.setAutoResizeMode(JTable.AUTO_RESIZE_ALL_COLUMNS);
        jdbTable1.setDataSet(queryDataSet1);
        queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from cd", null, true, Load.ALL));
        this.add(tabpnl);
        tabpnl.setFont(new Font("宋体",0,12));
        card.add(pnlcard);
        rec.add(pnlrec);
        rec.add(btnrecreset);
        rec.add(btnrecsearch);
        rec.add(btnrecback);
        pnlrec.add(jLabel7);
        pnlrec.add(cboxrecstarttime);
        pnlrec.add(txfrecstarttime1);
        pnlrec.add(txfrecendtime1);
        pnlrec.add(cboxreccdid);
        pnlrec.add(cboxreccardid);
        pnlrec.add(txfreccardid);
        pnlrec.add(cboxrecendtime);
        pnlrec.add(txfreccdid);
        pnlrec.add(txfrecstarttime2);
        pnlrec.add(jLabel8);
        pnlrec.add(txfrecendtime2);
        pnlrec.add(jLabel10);
        pnlcard.add(jLabel1);
        spnlcard.setBounds(new Rectangle(0, 0, 574, 263));
        pnlcard.add(txfcardusername);
        pnlcard.add(txfcardbalance1);
        pnlcard.add(txfcardbalance2);
        pnlcard.add(txfcardrestnum1);
        pnlcard.add(txfcardrestnum2);
        pnlcard.add(cboxcardbalance);
        pnlcard.add(cboxcardid);
        pnlcard.add(cboxcardusername);
        pnlcard.add(cboxcardrestnum);
        pnlcard.add(txfcardid);
        pnlcard.add(jLabel2);
        pnlcard.add(jLabel4);
        pnlcard.add(jLabel6);
        pnlcard.add(jLabel3);
        card.add(btncardreset);