magazinelogoutpanel.java~19~

一个功能强大的图书管理系统,是个人版,适合学习swing的初学者阅读.

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 MagazineLogOutPanel extends JPanel {
    Dbcom dd = new Dbcom();
    String fenlei="";
   public MagazineLogOutPanel() {

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

   DefaultMutableTreeNode books = new DefaultMutableTreeNode("所有期刊");
   String[] title = {"期刊名称","期刊编号","期刊类别编号","作者名","出版社","可借数量","定价","语言种类","书架位置","入库时间","是否可用"};
   String type1="";
   IxTable ixTable1 = new IxTable();
   JTable jTeaRightTop2 = 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 {

       this.setLayout(null);
       this.setBounds(new Rectangle(3, 60, 790, 535));
        this.addComponentListener(new MagazineLogOutPanel_this_componentAdapter(this));
        this.addHierarchyBoundsListener(new
                MagazineLogOutPanel_this_hierarchyBoundsAdapter(this));

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

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

       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(3, 318, 693, 185));
        jPanelRightTop.addMouseListener(new
                MagazineLogOutPanel_jPanelRightTop_mouseAdapter(this));
        jPaneRightBottom.setBounds(new Rectangle(4, 2, 702, 316));
        jPaneRightBottom.addComponentListener(new
                MagazineLogOutPanel_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
                                  MagazineLogOutPanel_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.setText("点击输入期刊编号");
       jtxBookNum2.setBounds(new Rectangle(95, 33, 187, 21));
       jtxBookNum2.addMouseListener(new
                                    MagazineLogOutPanel_jtxBookNum2_mouseAdapter(this));
       jtxBookNum2.addActionListener(new
                                     MagazineLogOutPanel_jtxBookNum2_actionAdapter(this));
       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);
       jTeaRightTop2.getTableHeader().setFont(new java.awt.Font("宋体", Font.PLAIN,
               14));
       jTeaRightTop2.getTableHeader().setForeground(Color.blue);
       jTeaRightTop2.setGridColor(Color.black);
       jTeaRightTop2.setRowHeight(20);
       jTeaRightTop2.addMouseListener(new
                                     MagazineLogOutPanel_jTeaRightTop_mouseAdapter(this));
      jPanelRightTopjPanel.setBorder(BorderFactory.createEtchedBorder());
      jPanelRightTopjPanel.setBounds(new Rectangle(1, 0, 607, 26));
      jPanelRightTopjPanel.setLayout(null);
      jScrollPane1.setBorder(null);
      jScrollPane1.setBounds(new Rectangle(1  , 29, 562, 240));
      jlbM.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
      jlbM.setForeground(Color.magenta);
      jlbM.setHorizontalAlignment(SwingConstants.CENTER);
      jlbM.setHorizontalTextPosition(SwingConstants.CENTER);
      jlbM.setText("期刊信息列表");
      jlbM.setBounds(new Rectangle(7, 6, 598, 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("数据重置");

       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));
        jScright.addComponentListener(new
                MagazineLogOutPanel_jScright_componentAdapter(this));
        jScright.addHierarchyBoundsListener(new
                MagazineLogOutPanel_jScright_hierarchyBoundsAdapter(this));
        jPanRight.addHierarchyBoundsListener(new
                MagazineLogOutPanel_jPanRight_hierarchyBoundsAdapter(this));

        jSpSystemPanel.add(jScleft, JSplitPane.LEFT);
        jScleft.getViewport().add(jTreBooks);
        jSpSystemPanel.add(jScright, JSplitPane.RIGHT);
       jScright.getViewport().add(jPanRight);
        jPanRight.add(jPaneRightBottom);
       jPaneRightBottom.add(jTpRightBottom);
        jPanRight.add(jPanelRightTop);
        jTpRightBottom.add(jTpRightBottomPanel2, "期刊注销业务   ");
        jPanelRightTop.add(jPanelRightTopjPanel);
        jPanelRightTopjPanel.add(jlbM);
        jPanelRightTop.add(jScrollPane1);
        jScrollPane1.getViewport().add(jTeaRightTop2);
        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);
        this.add(jSpSystemPanel);
      // jPanelRightTopjPanel
   }

   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++)
               {
                   if(i!=arry[j])
                   {
                       bookstype[arry[j-1]].add(bookstype[i]);
                   }
                  else
                   {
                       j++;
                       books.add(bookstype[i]);
                   }
               }