booksinfosystempanel.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.border.TitledBorder;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;

/**
 * <p>Title: 图书借阅系统</p>
 *
 * <p>Description: 科学的管理系统</p>
 *
 * <p>Copyright: 吴明卫小组</p>
 *
 * <p>Company: </p>
 *
 * @author 吴明卫
 * @version 1.0
 */
public class BooksInfoSystemPanel extends JPanel {
    Dbcom db;
    String fenlei="";
    public BooksInfoSystemPanel(Dbcom db) {
        this.db=db;
        try {
            jbInit();
            loginTree();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }
    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 jBttszxgl = new JButton();
   JButton jBttsbmrk = new JButton();
   JTree jTreBooks = new JTree(books,true);
   JSplitPane jSpSystemPanel = new JSplitPane();
   FlowLayout flowLayout1 = new FlowLayout();
   JPanel jPanRight = new JPanel();
   JTabbedPane jTpRightBottom = new JTabbedPane();
   JPanel jPaneRightBottom = new JPanel();
    JPanel jTpRightBottomjPanel4 = new JPanel();
    JPanel jPanelRightTop = new JPanel();
   JScrollPane jScrollPane1 = new JScrollPane();
    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 jtxBookStation = new JTextField();
    JTextField jtxBookBeginHandlers1 = new JTextField();
    JTextField jtxBookType1=new JTextField() ;
    JTextField jtxBookAuthor = new JTextField();
    JTextField jtxBookNum1 = new JTextField();
    JTextField jtxBookLanguage = new JTextField();
    JTextField jtxBookName1 = new JTextField();
    JTextField jtxBookBorrowMoneyNum1 = new JTextField();
    JLabel jLabel12 = new JLabel();
    JLabel jLabel13 = new JLabel();
    JTextField jtxBookName2 = new JTextField();
    JTextField jtxBookBeginHandlers2 = new JTextField();
    JTextField jtxBookStation2 = new JTextField();
    JLabel jLabel14 = new JLabel();
    JLabel jLabel15 = new JLabel();
    JLabel jLabel16 = new JLabel();
    JTextField jtxBookPurchaseMoney2 = new JTextField();
    JTextField jtxBookConcern2 = new JTextField();
    JTextField jtxBookType2 = new JTextField();
    JLabel jLabel17 = new JLabel();
    JTextField jtxBookLanguage2 = new JTextField();
    JLabel jLabel18 = new JLabel();
    JTextField jtxBookAuthor2 = new JTextField();
    JTextField jtxBookNum2 = new JTextField();
    JTextField jtxBookBorrowMoneyNum2 = new JTextField();
    JLabel jLabel19 = new JLabel();
    JPanel jTpRightBottomPanel2 = new JPanel();
    JLabel jLabel20 = new JLabel();
    JLabel jLabel21 = new JLabel();
    TitledBorder titledBorder1 = new TitledBorder("");
    TitledBorder titledBorder2 = new TitledBorder("");
    JPanel jPanelRightTopjPanel = new JPanel();
    JLabel jlbM = new JLabel();
    JButton btnReset = new JButton();
    JButton btnQueRen = new JButton();
    JButton btnAddInfo = new JButton();
    String beizhu="";
    //类型编号
    String bh="";
    JButton btnQueRen2 = new JButton();
    JButton btnReset2 = new JButton();
    JButton btnAddInfo2 = new JButton();
    BooksLogOutPanel1 booksLogOutPanel1 = new BooksLogOutPanel1();

    private void jbInit() throws Exception {
       this.setLayout(null);
       this.setBounds(new Rectangle(3, 60, 790, 535));
       this.addHierarchyBoundsListener(new
                BooksInfoSystemPanel_this_hierarchyBoundsAdapter(this));
        jTeaRightTop.setFont(new java.awt.Font("宋体", Font.PLAIN, 13));
       jTeaRightTop.setForeground(Color.blue);

       jPanelSystemTop.setBounds(new Rectangle(3, 0, 860, 30));
        jSpSystemPanel.setBounds(new Rectangle(2, 30, 863, 505));

        booksLogOutPanel1.setBounds(new Rectangle(1, 30, 863, 505));

       jPanelSystemTop.setLayout(flowLayout1);
        jBttszxgl.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jBttszxgl.setForeground(Color.blue);
        jBttszxgl.setSelectedIcon(null);
        jBttszxgl.setText("图书注销管理");
        jBttszxgl.addActionListener(new
                BooksInfoSystemPanel_jBttszxgl_actionAdapter(this));
        jBttsbmrk.setBackground(SystemColor.menu);
        jBttsbmrk.setEnabled(true);
        jBttsbmrk.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jBttsbmrk.setForeground(Color.blue);
        jBttsbmrk.setText("图书编目入库");
        jBttsbmrk.addActionListener(new
                BooksInfoSystemPanel_jBttsbmrk_actionAdapter(this));

        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.setBounds(new Rectangle(2, 2, 704, 311));

       jPanelRightTop.setBounds(new Rectangle(1, 318, 693, 185));
       jPaneRightBottom.setBounds(new Rectangle( 1, 2, 705, 316));

        jPaneRightBottom.addComponentListener(new
                BooksInfoSystemPanel_jPaneRightBottom_componentAdapter(this));

        jPaneRightBottom.setLayout(null);
        jTpRightBottomjPanel4.setLayout(null);
        jPanelRightTop.setBorder(BorderFactory.createEtchedBorder());
        jPanelRightTop.setLayout(null);
        jTreBooks.setFont(new java.awt.Font("宋体", Font.PLAIN, 13));
        jTreBooks.setForeground(Color.blue);
        jTreBooks.addMouseListener(new
                                   BooksInfoSystemPanel_jTreBooks_mouseAdapter(this));
        jScright.addHierarchyBoundsListener(new
                BooksInfoSystemPanel_jScright_hierarchyBoundsAdapter(this));
        jScright.addComponentListener(new
                BooksInfoSystemPanel_jScright_componentAdapter(this));
        jPanRight.addHierarchyBoundsListener(new
                BooksInfoSystemPanel_jPanRight_hierarchyBoundsAdapter(this));
        jLabel1.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel1.setForeground(Color.blue);
        jLabel1.setText("操作人员");
        jLabel1.setBounds(new Rectangle(381, 142, 58, 20));
        jLabel2.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel2.setForeground(Color.blue);
        jLabel2.setText("数    量");
        jLabel2.setBounds(new Rectangle(22, 142, 58, 20));
        jLabel3.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel3.setForeground(Color.blue);
        jLabel3.setText("书架位置");
        jLabel3.setBounds(new Rectangle(381, 112, 58, 20));
        jLabel4.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel4.setForeground(Color.blue);
        jLabel4.setText("图书语种");
        jLabel4.setBounds(new Rectangle(22, 112, 58, 20));
        jLabel5.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel5.setForeground(Color.blue);
        jLabel5.setText("图书分类");
        jLabel5.setBounds(new Rectangle(381, 18, 58, 20));
        jLabel6.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel6.setForeground(Color.blue);
        jLabel6.setText("图书名称");
        jLabel6.setBounds(new Rectangle(22, 18, 58, 20));
        jLabel7.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel7.setForeground(Color.blue);
        jLabel7.setText("图书编号");
        jLabel7.setBounds(new Rectangle(22, 49, 58, 20));
        jLabel8.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel8.setForeground(Color.blue);
        jLabel8.setText("图书作者");
        jLabel8.setBounds(new Rectangle(22, 81, 58, 20));
        jLabel9.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel9.setForeground(Color.blue);
        jLabel9.setText("图书定价");
        jLabel9.setBounds(new Rectangle(381, 81, 58, 20));
        jLabel10.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel10.setForeground(Color.blue);
        jLabel10.setText("出 版 社");
        jLabel10.setBounds(new Rectangle(381, 49, 58, 20));
        jtxBookConcern1.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxBookConcern1.setForeground(Color.blue);
        jtxBookConcern1.setBounds(new Rectangle(453, 49, 197, 23));
        jtxBookPurchaseMoney.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxBookPurchaseMoney.setForeground(Color.blue);
        jtxBookPurchaseMoney.setText("");
        jtxBookPurchaseMoney.setBounds(new Rectangle(453, 81, 197, 23));
        jtxBookStation.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxBookStation.setForeground(Color.blue);
        jtxBookStation.setText("");
        jtxBookStation.setBounds(new Rectangle(453, 112, 197, 23));
        jtxBookBeginHandlers1.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxBookBeginHandlers1.setForeground(Color.blue);
        jtxBookBeginHandlers1.setEditable(false);
        jtxBookBeginHandlers1.setText("默认当前操作人员");
        jtxBookBeginHandlers1.setBounds(new Rectangle(453, 142, 197, 23));
        // 下拉菜单
        jtxBookType1.setText("请点击左边的类型选择");
        jtxBookType1.setEnabled(false);
        //
        jtxBookType1.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxBookType1.setForeground(Color.magenta);
        jtxBookType1.setEditable(true);

        jtxBookType1.setBounds(new Rectangle(453, 18, 197, 23));
        jtxBookAuthor.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxBookAuthor.setForeground(Color.blue);
        jtxBookAuthor.setText("");
        jtxBookAuthor.setBounds(new Rectangle(86, 81, 197, 23));
        jtxBookNum1.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxBookNum1.setForeground(Color.magenta);
        jtxBookNum1.setToolTipText("");
        jtxBookNum1.setText("填写完信息点击获取编号");
        jtxBookNum1.setBounds(new Rectangle(86, 49, 197, 23));
        jtxBookNum1.addMouseListener(new
                BooksInfoSystemPanel_jtxBookNum1_mouseAdapter(this));
        jtxBookLanguage.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxBookLanguage.setForeground(Color.blue);
        jtxBookLanguage.setText("");
        jtxBookLanguage.setBounds(new Rectangle(87, 112, 197, 23));
        jtxBookName1.setEnabled(true);
        jtxBookName1.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxBookName1.setForeground(Color.blue);
        jtxBookName1.setText("");
        jtxBookName1.setBounds(new Rectangle(86, 18, 197, 23));
        jtxBookBorrowMoneyNum1.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxBookBorrowMoneyNum1.setForeground(Color.blue);
        jtxBookBorrowMoneyNum1.setText("");
        jtxBookBorrowMoneyNum1.setBounds(new Rectangle(87, 142, 197, 23));
        jLabel12.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel12.setForeground(Color.blue);
        jLabel12.setText("图书作者");
        jLabel12.setBounds(new Rectangle(27, 81, 61, 14));
        jLabel13.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel13.setForeground(Color.blue);
        jLabel13.setText("图书语种");
        jLabel13.setBounds(new Rectangle(27, 110, 61, 14));
        jtxBookName2.setEnabled(false);
        jtxBookName2.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxBookName2.setForeground(Color.blue);
        jtxBookName2.setText("请点击输入名称");
        jtxBookName2.setBounds(new Rectangle(96, 19, 189, 23));
        jtxBookBeginHandlers2.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxBookBeginHandlers2.setForeground(Color.blue);
        jtxBookBeginHandlers2.setEditable(false);
        jtxBookBeginHandlers2.setText("默认当前操作人员");
        jtxBookBeginHandlers2.setBounds(new Rectangle(465, 136, 189, 23));