bookslogoutpanel1.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 BooksLogOutPanel1 extends JPanel {
    Dbcom dd = new Dbcom();

    public BooksLogOutPanel1() {

        try {
            jbInit();
            loginTree();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    DefaultMutableTreeNode books = new DefaultMutableTreeNode("所有图书");
    String[] title = {"图书名称","图书编号","图书类别编号","作者名","出版社","可借数量","定价","语言种类","书架位置","入库时间","是否可用"};
    String type1="";
    IxTable ixTable1 = new IxTable();
   JTable jTeaRightTop = new JTable();
   JScrollPane jScright = new JScrollPane();
   JScrollPane jScleft = new JScrollPane();
    JTree jTreBooks = new JTree(books,true);
   JSplitPane jSpSystemPanel = new JSplitPane();
    JPanel jPanRight = new JPanel();
   JTabbedPane jTpRightBottom = new JTabbedPane();
   JPanel jPaneRightBottom = new JPanel();
    JPanel jPanelRightTop = new JPanel();
   JScrollPane jScrollPane1 = new JScrollPane();
    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();
    String beizhu="";
    //类型编号
    String bh="";
    JButton btnQueRen2 = new JButton();
    JButton btnReset2 = new JButton();
    JTextArea jtxLogOut = new JTextArea();
    JLabel jLabel2 = new JLabel();
    JScrollPane jScrollPane2 = new JScrollPane();
    TitledBorder titledBorder3 = new TitledBorder("");
    private void jbInit() throws Exception {
        jScright.addHierarchyBoundsListener(new
                BooksLogOutPanel1_jScright_hierarchyBoundsAdapter(this));
        this.setLayout(null);
       this.setBounds(new Rectangle(3, 60, 790, 535));
        this.addComponentListener(new BooksLogOutPanel1_this_componentAdapter(this));

        jTeaRightTop.setFont(new java.awt.Font("宋体", Font.PLAIN, 13));
       jTeaRightTop.setForeground(Color.blue);

        jSpSystemPanel.setBounds(new Rectangle(1, 1, 863, 505));
        jSpSystemPanel.addComponentListener(new
                BooksLogOutPanel1_jSpSystemPanel_componentAdapter(this));

        jPanRight.setLayout(null);
       jTpRightBottom.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
       jTpRightBottom.setForeground(Color.blue);
        jTpRightBottom.setBounds(new Rectangle( -2, 1, 704, 311));

       jPanelRightTop.setBounds(new Rectangle(1, 318, 693, 185));
       jPaneRightBottom.setBounds(new Rectangle(4, 2, 702, 316));
        jPaneRightBottom.addComponentListener(new
                BooksLogOutPanel1_jPaneRightBottom_componentAdapter(this));

        jPaneRightBottom.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 BooksLogOutPanel1_jTreBooks_mouseAdapter(this));

        jLabel12.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel12.setForeground(Color.blue);
        jLabel12.setText("图书作者");
        jLabel12.setBounds(new Rectangle(25, 63, 61, 14));
        jLabel13.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel13.setForeground(Color.blue);
        jLabel13.setText("图书语种");
        jLabel13.setBounds(new Rectangle(25, 89, 61, 14));
        jtxBookName2.setEnabled(false);
        jtxBookName2.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxBookName2.setForeground(Color.blue);
        jtxBookName2.setEditable(true);
        jtxBookName2.setBounds(new Rectangle(95, 7, 187, 21));
        jtxBookBeginHandlers2.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxBookBeginHandlers2.setForeground(Color.blue);
        jtxBookBeginHandlers2.setEditable(false);
        jtxBookBeginHandlers2.setText("当前系统操作员");
        jtxBookBeginHandlers2.setBounds(new Rectangle(448, 110, 187, 21));
        jtxBookStation2.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxBookStation2.setForeground(Color.blue);
        jtxBookStation2.setBounds(new Rectangle(448, 85, 187, 21));
        jLabel14.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel14.setForeground(Color.blue);
        jLabel14.setText("操作人员");
        jLabel14.setBounds(new Rectangle(371, 114, 61, 14));
        jLabel15.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel15.setForeground(Color.blue);
        jLabel15.setText("书架位置");
        jLabel15.setBounds(new Rectangle(371, 89, 61, 14));
        jLabel16.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel16.setForeground(Color.blue);
        jLabel16.setText("图书编号");
        jLabel16.setBounds(new Rectangle(25, 37, 61, 14));
        jtxBookPurchaseMoney2.setEnabled(false);
        jtxBookPurchaseMoney2.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxBookPurchaseMoney2.setForeground(Color.blue);
        jtxBookPurchaseMoney2.setBounds(new Rectangle(448, 59, 187, 21));
        jtxBookConcern2.setEnabled(false);
        jtxBookConcern2.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxBookConcern2.setForeground(Color.blue);
        jtxBookConcern2.setEditable(true);
        jtxBookConcern2.setBounds(new Rectangle(448, 33, 187, 21));
        jtxBookType2.setEnabled(false);
        jtxBookType2.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxBookType2.setForeground(Color.blue);
        jtxBookType2.setEditable(true);
        jtxBookType2.setBounds(new Rectangle(448, 7, 187, 21));
        jLabel17.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel17.setForeground(Color.blue);
        jLabel17.setText("当前数量");
        jLabel17.setBounds(new Rectangle(25, 114, 61, 14));
        jtxBookLanguage2.setEnabled(false);
        jtxBookLanguage2.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxBookLanguage2.setForeground(Color.blue);
        jtxBookLanguage2.setEditable(true);
        jtxBookLanguage2.setBounds(new Rectangle(95, 85, 187, 21));
        jLabel18.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel18.setForeground(Color.blue);
        jLabel18.setText("图书名称");
        jLabel18.setBounds(new Rectangle(26, 11, 61, 14));
        jtxBookAuthor2.setEnabled(false);
        jtxBookAuthor2.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxBookAuthor2.setForeground(Color.blue);
        jtxBookAuthor2.setEditable(true);
        jtxBookAuthor2.setBounds(new Rectangle(95, 59, 187, 21));
        jtxBookNum2.setEnabled(false);
        jtxBookNum2.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxBookNum2.setForeground(Color.blue);
        jtxBookNum2.setEditable(true);
        jtxBookNum2.setBounds(new Rectangle(95, 33, 187, 21));
        jtxBookBorrowMoneyNum2.setEnabled(false);

        jtxBookBorrowMoneyNum2.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jtxBookBorrowMoneyNum2.setForeground(Color.red);
        jtxBookBorrowMoneyNum2.setEditable(true);
        jtxBookBorrowMoneyNum2.setText("");
        jtxBookBorrowMoneyNum2.setBounds(new Rectangle(95, 110, 187, 21));
        jLabel19.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel19.setForeground(Color.blue);
        jLabel19.setText("图书定价");
        jLabel19.setBounds(new Rectangle(371, 63, 61, 14));
        jLabel20.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel20.setForeground(Color.blue);
        jLabel20.setText("出 版 社");
        jLabel20.setBounds(new Rectangle(371, 37, 61, 14));
        jLabel21.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jLabel21.setForeground(Color.blue);
        jLabel21.setText("图书分类");
        jLabel21.setBounds(new Rectangle(371, 11, 61, 14));
        jTpRightBottomPanel2.setLayout(null);
        jTeaRightTop.getTableHeader().setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jTeaRightTop.getTableHeader().setForeground(Color.blue);
        jTeaRightTop.setGridColor(Color.black);
        jTeaRightTop.setRowHeight(20);
        jTeaRightTop.addMouseListener(new
                BooksLogOutPanel1_jTeaRightTop_mouseAdapter(this));
        jPanelRightTopjPanel.setBounds(new Rectangle(1, 0, jTeaRightTop.getWidth()-1, 26));
        jPanelRightTopjPanel.setLayout(null);
        jScrollPane1.setBorder(null);
        jlbM.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        jlbM.setForeground(Color.magenta);
        jlbM.setText("图书列表");
        jlbM.setBounds(new Rectangle(275, 6, 57, 20));
        btnQueRen2.setBounds(new Rectangle(74, 206, 123, 30));
        btnQueRen2.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        btnQueRen2.setForeground(Color.red);
        btnQueRen2.setText("确认注销");
        btnReset2.setBounds(new Rectangle(419, 206, 123, 30));
        btnReset2.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
        btnReset2.setForeground(Color.blue);
        btnReset2.setText("数据重置");
        jScright.addComponentListener(new
                BooksLogOutPanel1_jScright_componentAdapter(this));
        jPanRight.addHierarchyBoundsListener(new
                BooksLogOutPanel1_jPanRight_hierarchyBoundsAdapter(this));
        jScrollPane2.setBorder(BorderFactory.createLineBorder(Color.black));
        jScrollPane2.setBounds(new Rectangle(97, 144, 537, 54));
        jtxLogOut.setBounds(2,2,jScrollPane2.getWidth()-10,jScrollPane2.getHeight()-10);
        jtxLogOut.setFont(new java.awt.Font("宋体", Font.PLAIN, 16));
        jtxLogOut.setForeground(Color.red);
        jtxLogOut.setBorder(BorderFactory.createEtchedBorder());
        jtxLogOut.setToolTipText("");
        jtxLogOut.setMargin(new Insets(10, 10, 10, 10));
        jtxLogOut.setText("必添");
        jtxLogOut.setLineWrap(true);
        jLabel2.setFont(new java.awt.Font("宋体", Font.BOLD, 16));
        jLabel2.setForeground(Color.red);
        jLabel2.setText("注销原因");
        jLabel2.setBounds(new Rectangle(24, 150, 71, 27));
        jPanRight.addComponentListener(new
                BooksLogOutPanel1_jPanRight_componentAdapter(this));

        jSpSystemPanel.add(jScleft, JSplitPane.LEFT);
        jSpSystemPanel.add(jScright, JSplitPane.RIGHT);
        jScright.getViewport().add(jPanRight);
        jScleft.getViewport().add(jTreBooks);
        jPanRight.add(jPaneRightBottom);
        jPaneRightBottom.add(jTpRightBottom);
        jTpRightBottom.add(jTpRightBottomPanel2, "图书注销业务   ");
        jPanelRightTop.add(jScrollPane1);
        jPanelRightTop.add(jPanelRightTopjPanel);
        jPanelRightTopjPanel.add(jlbM);
        jScrollPane1.getViewport().add(jTeaRightTop);
        jTpRightBottomPanel2.add(jLabel18);
        jTpRightBottomPanel2.add(jtxBookName2);
        jTpRightBottomPanel2.add(jLabel16);
        jTpRightBottomPanel2.add(jtxBookNum2);
        jTpRightBottomPanel2.add(jLabel12);
        jTpRightBottomPanel2.add(jtxBookAuthor2);
        jTpRightBottomPanel2.add(jLabel13);
        jTpRightBottomPanel2.add(jtxBookLanguage2);
        jTpRightBottomPanel2.add(jLabel17);
        jTpRightBottomPanel2.add(jtxBookBorrowMoneyNum2);
        jTpRightBottomPanel2.add(jLabel2);
        jTpRightBottomPanel2.add(btnReset2);
        jTpRightBottomPanel2.add(btnQueRen2);
        jTpRightBottomPanel2.add(jScrollPane2);
        jTpRightBottomPanel2.add(jtxBookStation2);
        jTpRightBottomPanel2.add(jtxBookType2);
        jTpRightBottomPanel2.add(jLabel21);
        jTpRightBottomPanel2.add(jLabel20);
        jTpRightBottomPanel2.add(jtxBookConcern2);
        jTpRightBottomPanel2.add(jtxBookPurchaseMoney2);
        jTpRightBottomPanel2.add(jLabel19);
        jTpRightBottomPanel2.add(jLabel15);
        jTpRightBottomPanel2.add(jLabel14);
        jTpRightBottomPanel2.add(jtxBookBeginHandlers2);
        jScrollPane2.getViewport().add(jtxLogOut);
        jPanRight.add(jPanelRightTop);
        this.add(jSpSystemPanel);
    }
    public void loginTree()
    {

        ResultSet re = null;
        DefaultMutableTreeNode bookstype[];

        int size=0;
        int j =0;
        int i=0;
        int arry[] = new int[26];
        //连接数据库
        Dbcom dd = new Dbcom();
      //  if (db.getconn()) {
                //获得结果集
            re = dd.searchTree();
            try {
                while(re.next())
                    size++;
                bookstype = new DefaultMutableTreeNode[size];
                boolean a=re.first();
                for(i=0,j=0;a;i++)
                {
                    String booktypeNum = re.getString(1).trim();
                    String booktypeName = re.getString(2).trim();
                    //创建树的枝
                    if (booktypeNum.length() == 1) {
                        arry[j]=i;
                        j++;
                        bookstype[i] = new DefaultMutableTreeNode(booktypeName);
                    }
                    else
                    {
                            //创建树的叶
                        bookstype[i] = new DefaultMutableTreeNode(booktypeName);
                       // bookstype[j-1].add(bookstype[i]);
                    }
                    a=re.next();
                }
                for(i=0,j=0;i<bookstype.length;i++)
                {