booksinfochaxunpanel.java

图书管理系统源代码,05年某人写的,还算不错

package booksboeeowreadsystem;

import java.awt.*;
import javax.swing.*;
import java.awt.*;
import com.borland.internetbeans.IxTable;
import java.awt.event.HierarchyEvent;
import java.awt.event.HierarchyBoundsAdapter;
import java.awt.event.ComponentEvent;
import java.awt.event.ComponentAdapter;
import javax.swing.tree.DefaultMutableTreeNode;
import java.sql.ResultSet;
import java.sql.*;
import java.awt.event.MouseEvent;
import java.awt.event.MouseAdapter;
import javax.swing.table.DefaultTableModel;
import com.borland.jbcl.layout.XYLayout;
import javax.swing.*;

/**
 * <p>Title: 图书借阅系统</p>
 *
 * <p>Description: 科学的管理系统</p>
 *
 * <p>Copyright: 吴明卫小组</p>
 *
 * <p>Company: </p>
 *
 * @author 吴明卫
 * @version 1.0
 */
public class BooksInfoChaxunPanel extends JPanel {
    BorderLayout borderLayout1 = new BorderLayout();
    DefaultMutableTreeNode books = new DefaultMutableTreeNode("所有图书");
    String[] title = {"图书名称","图书编号","图书类别编号","作者名","出版社","可借数量","定价","语言种类","书架位置","入库时间","是否可用"};
    IxTable ixTable1 = new IxTable();
    JTable jTeaRightTop = new JTable();
    JScrollPane jScright = new JScrollPane();
    JScrollPane jScleft = new JScrollPane();
    JPanel jPanelSystemTop = new JPanel();
    JButton jBtyqqk = new JButton();
    JButton jBttsdacx = new JButton();
    JTree jTreBooks = new JTree(books, true);
    JSplitPane jSpSystemPanel = new JSplitPane();
    FlowLayout flowLayout1 = new FlowLayout();
    JPanel jPanRight = new JPanel();
    JPanel jTpRightBottom = new JPanel();
    JPanel jPaneRightBottom = new JPanel();
    JPanel jTpRightBottomjPanel4 = new JPanel();
    JPanel jPanelRightTop = new JPanel();
    JScrollPane jScrollPane1 = new JScrollPane();
    JButton jBttsrkcx = new JButton();
    JButton jBttszxcx = new JButton();
    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JLabel jLabel3 = new JLabel();
    JLabel jLabel4 = new JLabel();
    JLabel jLabel5 = new JLabel();
    JLabel jLabel6 = new JLabel();
    JLabel jLabel7 = new JLabel();
    JLabel jLabel8 = new JLabel();
    JLabel jLabel9 = new JLabel();
    JLabel jLabel10 = new JLabel();
    JTextField jtxBookConcern1 = new JTextField();
    JTextField jtxBookPurchaseMoney = new JTextField();
    JTextField jtxRuKuCaozuo = new JTextField();
    JTextField jtxBookBeginHandlers1 = new JTextField();
    JTextField jtxBookType1 = new JTextField();
    JTextField jtxBookAuthor = new JTextField();
    JTextField jtxBookNum1 = new JTextField();
    JTextField jtxRuKuTime = new JTextField();
    JTextField jtxBookName1 = new JTextField();
    JTextField jtxLogOutTime = new JTextField();
    Dbcom db ;
    javax.swing.JTextField jtxBookLanguage = new JTextField();
    javax.swing.JLabel jLabel11 = new JLabel();
    javax.swing.JLabel jLabel22 = new JLabel();
    javax.swing.JTextField jtxBookStation = new JTextField();
    javax.swing.JLabel jLabel23 = new JLabel();
    javax.swing.JLabel jLabel24 = new JLabel();
    javax.swing.JTextField jtxBookBorrowMoneyNum1 = new JTextField();
    javax.swing.JTextField jTextField4 = new JTextField();
    public BooksInfoChaxunPanel(Dbcom db) {
        try {
            this.db=db;
            jbInit();
            loginTree();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }


    private void jbInit() throws Exception {
        this.setLayout(null);
        this.setBounds(new Rectangle(3, 60, 790, 535));
        this.addHierarchyBoundsListener(new
                BooksInfoChaxunPanel_this_hierarchyBoundsAdapter(this));
        jTeaRightTop.setFont(new java.awt.Font("宋体", Font.PLAIN, 13));
        jTeaRightTop.setForeground(Color.blue);
        jPanelSystemTop.setBounds(new Rectangle(3, 0, 860, 30));
        jPanelSystemTop.setLayout(flowLayout1);
        jBtyqqk.setEnabled(false);
        jBtyqqk.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jBtyqqk.setForeground(Color.blue);
        jBtyqqk.setText("图书借阅查询");
        jBttsdacx.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jBttsdacx.setForeground(Color.blue);
        jBttsdacx.setText("图书档案查询");
        jSpSystemPanel.setBounds(new Rectangle(2, 30, 863, 505));
        flowLayout1.setAlignment(FlowLayout.LEFT);
        flowLayout1.setHgap(0);
        flowLayout1.setVgap(0);
        jPanRight.setLayout(null);
        jTpRightBottom.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jTpRightBottom.setForeground(Color.blue);
        jTpRightBottom.setBorder(BorderFactory.createEtchedBorder());
        jTpRightBottom.setBounds(new Rectangle(2, 2, 704, 311));
        jTpRightBottom.setLayout(null);
        jPaneRightBottom.setBounds(new Rectangle( -1, 187, 705, 316));
        jPaneRightBottom.addComponentListener(new
                BooksInfoChaxunPanel_jPaneRightBottom_componentAdapter(this));
        jPaneRightBottom.setLayout(null);
        jTpRightBottomjPanel4.setLayout(null);
        jPanelRightTop.setBorder(BorderFactory.createEtchedBorder());
        jPanelRightTop.setBounds(new Rectangle(1, 2, 693, 185));

        jPanelRightTop.setLayout(null);
        jTreBooks.setFont(new java.awt.Font("宋体", Font.PLAIN, 13));
        jTreBooks.setForeground(Color.blue);
        jTreBooks.addMouseListener(new
                                   BooksInfoChaxunPanel_jTreBooks_mouseAdapter(this));
        jBttsrkcx.setEnabled(false);
        jBttsrkcx.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jBttsrkcx.setForeground(Color.blue);
        jBttsrkcx.setText("图书入库查询");
        jBttszxcx.setEnabled(false);
        jBttszxcx.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jBttszxcx.setForeground(Color.blue);
        jBttszxcx.setText("图书注销查询");
        jLabel1.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel1.setForeground(Color.blue);
        jLabel1.setText("注销操作员");
        jLabel1.setBounds(new Rectangle(337, 197, 70, 20));
        jLabel2.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel2.setForeground(Color.blue);
        jLabel2.setText("注销时间");
        jLabel2.setBounds(new Rectangle(36, 197, 58, 20));
        jLabel3.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel3.setForeground(Color.blue);
        jLabel3.setText("损坏数量");
        jLabel3.setBounds(new Rectangle(337, 138, 58, 20));
        jLabel4.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel4.setForeground(Color.blue);
        jLabel4.setText("入库时间");
        jLabel4.setBounds(new Rectangle(36, 171, 58, 20));
        jLabel5.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel5.setForeground(Color.blue);
        jLabel5.setText("图书分类");
        jLabel5.setBounds(new Rectangle(337, 20, 58, 20));
        jLabel6.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel6.setForeground(Color.blue);
        jLabel6.setText("图书名称");
        jLabel6.setBounds(new Rectangle(36, 20, 58, 20));
        jLabel7.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel7.setForeground(Color.blue);
        jLabel7.setText("图书编号");
        jLabel7.setBounds(new Rectangle(36, 49, 58, 20));
        jLabel8.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel8.setForeground(Color.blue);
        jLabel8.setText("图书作者");
        jLabel8.setBounds(new Rectangle(36, 80, 58, 20));
        jLabel9.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel9.setForeground(Color.blue);
        jLabel9.setText("图书定价");
        jLabel9.setBounds(new Rectangle(337, 79, 58, 20));
        jLabel10.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel10.setForeground(Color.blue);
        jLabel10.setText("出 版 社");
        jLabel10.setBounds(new Rectangle(338, 48, 58, 20));
        jtxBookConcern1.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxBookConcern1.setForeground(Color.blue);
        jtxBookConcern1.setBounds(new Rectangle(410, 45, 165, 23));
        jtxBookPurchaseMoney.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxBookPurchaseMoney.setForeground(Color.blue);
        jtxBookPurchaseMoney.setText("");
        jtxBookPurchaseMoney.setBounds(new Rectangle(409, 76, 165, 23));
        jtxRuKuCaozuo.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxRuKuCaozuo.setForeground(Color.blue);
        jtxRuKuCaozuo.setText("");
        jtxRuKuCaozuo.setBounds(new Rectangle(409, 168, 165, 23));
        jtxBookBeginHandlers1.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxBookBeginHandlers1.setForeground(Color.blue);
        jtxBookBeginHandlers1.setText("");
        jtxBookBeginHandlers1.setBounds(new Rectangle(410, 196, 165, 23));
        jtxBookType1.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxBookType1.setForeground(Color.blue);
        jtxBookType1.setText("");
        jtxBookType1.setBounds(new Rectangle(409, 16, 165, 23));
        jtxBookAuthor.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxBookAuthor.setForeground(Color.blue);
        jtxBookAuthor.setText("");
        jtxBookAuthor.setBounds(new Rectangle(100, 78, 165, 23));
        jtxBookNum1.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxBookNum1.setForeground(Color.blue);
        jtxBookNum1.setText("");
        jtxBookNum1.setBounds(new Rectangle(101, 47, 165, 23));
        jtxRuKuTime.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxRuKuTime.setForeground(Color.blue);
        jtxRuKuTime.setText("");
        jtxRuKuTime.setBounds(new Rectangle(100, 168, 165, 23));
        jtxBookName1.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxBookName1.setForeground(Color.blue);
        jtxBookName1.setText("");
        jtxBookName1.setBounds(new Rectangle(100, 18, 165, 23));
        jtxLogOutTime.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxLogOutTime.setForeground(Color.blue);
        jtxLogOutTime.setText("");
        jtxLogOutTime.setBounds(new Rectangle(101, 196, 165, 23));
        jScright.addHierarchyBoundsListener(new
                BooksInfoChaxunPanel_jScright_hierarchyBoundsAdapter(this));
        jScright.addComponentListener(new
                BooksInfoChaxunPanel_jScright_componentAdapter(this));
        jPanRight.addHierarchyBoundsListener(new
                BooksInfoChaxunPanel_jPanRight_hierarchyBoundsAdapter(this));
        jtxBookLanguage.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxBookLanguage.setForeground(Color.blue);
        jtxBookLanguage.setBounds(new Rectangle(102, 107, 165, 23));
        jLabel11.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel11.setForeground(Color.blue);
        jLabel11.setText("图书语种");
        jLabel11.setBounds(new Rectangle(36, 111, 58, 20));
        jLabel22.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel22.setForeground(Color.blue);
        jLabel22.setText("数    量");
        jLabel22.setBounds(new Rectangle(36, 138, 58, 20));
        jtxBookStation.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxBookStation.setForeground(Color.blue);
        jtxBookStation.setBounds(new Rectangle(410, 107, 165, 23));
        jLabel23.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel23.setForeground(Color.blue);
        jLabel23.setText("入库操作员");
        jLabel23.setBounds(new Rectangle(336, 169, 70, 20));
        jLabel24.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel24.setForeground(Color.blue);
        jLabel24.setText("书架位置");
        jLabel24.setBounds(new Rectangle(337, 110, 58, 20));
        jtxBookBorrowMoneyNum1.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxBookBorrowMoneyNum1.setForeground(Color.blue);
        jtxBookBorrowMoneyNum1.setBounds(new Rectangle(101, 137, 165, 23));
        jTextField4.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jTextField4.setForeground(Color.blue);
        jTextField4.setBounds(new Rectangle(409, 137, 165, 23));
        jTeaRightTop.getTableHeader().setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jTeaRightTop.getTableHeader().setForeground(Color.blue);
        jTeaRightTop.setGridColor(Color.cyan);
        jTeaRightTop.setRowHeight(20);
        jTeaRightTop.addMouseListener(new
                BooksInfoChaxunPanel_jTeaRightTop_mouseAdapter(this));
        jTpRightBottomjPanel4.setBounds(new Rectangle(1,1, jTpRightBottom.getWidth()-2,jTpRightBottom.getHeight()-2 ));

        this.add(jPanelSystemTop);
        jPanelSystemTop.add(jBttsdacx);
        jPanelSystemTop.add(jBtyqqk);
        jPanelSystemTop.add(jBttsrkcx);
        jPanelSystemTop.add(jBttszxcx);
        this.add(jSpSystemPanel);
        jScright.getViewport().add(jPanRight);
        jPanRight.add(jPaneRightBottom);
        jPanRight.add(jPanelRightTop);
        jPanelRightTop.add(jScrollPane1);
        jScrollPane1.getViewport().add(jTeaRightTop);
        jPaneRightBottom.add(jTpRightBottom);
        jTpRightBottomjPanel4.add(jtxLogOutTime);
        jTpRightBottomjPanel4.add(jLabel6);
        jTpRightBottomjPanel4.add(jtxBookName1);
        jTpRightBottomjPanel4.add(jtxBookNum1);
        jTpRightBottomjPanel4.add(jLabel7);
        jTpRightBottomjPanel4.add(jLabel8);
        jTpRightBottomjPanel4.add(jtxBookAuthor);
        jTpRightBottomjPanel4.add(jtxBookLanguage);
        jTpRightBottomjPanel4.add(jLabel11);
        jTpRightBottomjPanel4.add(jLabel22);
        jTpRightBottomjPanel4.add(jtxBookBorrowMoneyNum1);
        jTpRightBottomjPanel4.add(jtxRuKuTime);
        jTpRightBottomjPanel4.add(jLabel4);
        jTpRightBottomjPanel4.add(jLabel2);
        jTpRightBottomjPanel4.add(jLabel23);
        jTpRightBottomjPanel4.add(jLabel5);
        jTpRightBottomjPanel4.add(jtxBookType1);
        jTpRightBottomjPanel4.add(jLabel10);
        jTpRightBottomjPanel4.add(jtxBookConcern1);
        jTpRightBottomjPanel4.add(jLabel9);
        jTpRightBottomjPanel4.add(jtxBookPurchaseMoney);
        jTpRightBottomjPanel4.add(jLabel24);
        jTpRightBottomjPanel4.add(jtxBookStation);
        jTpRightBottomjPanel4.add(jLabel3);
        jTpRightBottomjPanel4.add(jTextField4);
        jTpRightBottomjPanel4.add(jtxRuKuCaozuo);