bookmanagermain.java

教材管理系统

package bookmanager;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import com.borland.jbcl.layout.*;
import com.borland.dx.sql.dataset.*;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2003</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */

public class BookManagerMain
    extends JFrame {
  JPanel contentPane;

  JMenuBar jMenuBar = new JMenuBar();
  JMenu jMenuSystem = new JMenu();
  JMenuItem jMenuFileExit = new JMenuItem();
  JMenu jMenuBookManager = new JMenu();
  JMenuItem jMenuItemLogin = new JMenuItem();
  JMenu jMenuUserManager = new JMenu();
  JMenuItem jMenuItemUserAdd = new JMenuItem();
  JMenuItem jMenuItemUserUpdate = new JMenuItem();
  JMenuItem jMenuItemUserDelete = new JMenuItem();
  JMenuItem jMenuItemBookorderUpdate = new JMenuItem();
  JMenu jMenuinBook = new JMenu();
  JMenuItem jMenuItemBookin = new JMenuItem();
  JMenu jMenuoutBook = new JMenu();
  JMenu jMenubookcost = new JMenu();
  JMenuItem jMenuItemregistationfees = new JMenuItem();
  JMenuItem jMenuItemusersearch = new JMenuItem();
  JMenuItem jMenuItembookorderAdd = new JMenuItem();
  JMenuItem jMenuItemorderbookquery = new JMenuItem();
  JMenu jMenu1 = new JMenu();
  JMenuItem jMenuIteminqbyISBN = new JMenuItem();
  JMenuItem jMenuIteminqbybookname = new JMenuItem();
  JMenuItem jMenuIteminqbybooktype = new JMenuItem();
  JMenuItem jMenuIteminqbyorderuser = new JMenuItem();
  JMenu jMenu4 = new JMenu();
  JMenuItem jMenuItemoutbookSquery = new JMenuItem();
  JMenu jMenu3 = new JMenu();
  JMenuItem jMenuItemxitongshuoming = new JMenuItem();
  BorderLayout borderLayout1 = new BorderLayout();
  JMenuItem jMenuItemoutbookS = new JMenuItem();
  JMenuItem jMenuItemoutqbyISBN = new JMenuItem();
  JMenuItem jMenuItemoutqbybookname = new JMenuItem();
  JMenu jMenu5 = new JMenu();
  JMenuItem jMenuItemrecordpayquery = new JMenuItem();
  JMenuItem jMenuItempayqbydepartment = new JMenuItem();
  JToolBar jToolBar1 = new JToolBar();
  ImageIcon icon1=new ImageIcon("pic217.gif");
  JButton jButtonuserUpdate = new JButton();
  JButton jButtonorderbookquery = new JButton();
  JButton jButtonbookList = new JButton();
  XYLayout xYLayout1 = new XYLayout();
  JButton jButtoninqbybookname = new JButton();
  JButton jButtonoutbookSquery = new JButton();
  JButton jButtonrecordpayquery = new JButton();
  JButton jButtonCalculator = new JButton();
  QueryResolver queryResolver1 = new QueryResolver();
  Database database1 = new Database();
  JLabel jLabel1 = new JLabel();
  JButton jButton1 = new JButton();
  JMenu jMenu2 = new JMenu();
  JMenuItem jMenuItembookqueryzonghe = new JMenuItem();
  JMenuItem jMenuItembookList = new JMenuItem();
  JMenuItem jMenuItemorderbookList = new JMenuItem();
  JMenuItem jMenuItembookAdd = new JMenuItem();
  JMenu jMenu6 = new JMenu();
  JMenuItem jMenuItemlianxiwomen = new JMenuItem();
  JMenuItem jMenuItemchakanliuyan = new JMenuItem();

  //Construct the frame
  public BookManagerMain() {
    enableEvents(AWTEvent.WINDOW_EVENT_MASK);
    try {
      jbInit();
    }
    catch (Exception e) {
      e.printStackTrace();
    }
  }

  //Component initialization
  private void jbInit() throws Exception {
    contentPane = (JPanel)this.getContentPane();
    contentPane.setLayout(borderLayout1);
    this.getContentPane().setBackground(SystemColor.controlLtHighlight);
    this.setDefaultCloseOperation(HIDE_ON_CLOSE);
    this.setFont(new java.awt.Font("Dialog", 0, 20));
    this.setSize(new Dimension(759, 633));
    this.setTitle("教材管理系统");
   jMenuSystem.setBackground(SystemColor.inactiveCaption);
    jMenuSystem.setFont(new java.awt.Font("Dialog", 0, 16));
    jMenuSystem.setText("系统管理");
    jMenuFileExit.setBackground(SystemColor.inactiveCaptionText);
    jMenuFileExit.setFont(new java.awt.Font("Dialog", 0, 16));
    jMenuFileExit.setText("退出");
    jMenuBookManager.setBackground(SystemColor.inactiveCaption);
    jMenuBookManager.setFont(new java.awt.Font("Dialog", 0, 16));
    jMenuBookManager.setActionCommand("教材管理");
    jMenuBookManager.setFocusPainted(true);
    jMenuBookManager.setText("教材管理");
    jMenuItemLogin.setBackground(SystemColor.inactiveCaptionText);
    jMenuItemLogin.setFont(new java.awt.Font("Dialog", 0, 16));
    jMenuItemLogin.setText("用户登陆");
    jMenuUserManager.setBackground(SystemColor.inactiveCaptionText);
    jMenuUserManager.setFont(new java.awt.Font("Dialog", 0, 16));
    jMenuUserManager.setText("用户管理");
    jMenuItemUserAdd.setBackground(SystemColor.inactiveCaptionText);
    jMenuItemUserAdd.setFont(new java.awt.Font("Dialog", 0, 16));
    jMenuItemUserAdd.setText("添加用户");
    jMenuItemUserUpdate.setBackground(SystemColor.inactiveCaptionText);
    jMenuItemUserUpdate.setFont(new java.awt.Font("Dialog", 0, 16));
    jMenuItemUserUpdate.setText("修改用户");
    jMenuItemUserDelete.setBackground(SystemColor.inactiveCaptionText);
    jMenuItemUserDelete.setFont(new java.awt.Font("Dialog", 0, 16));
    jMenuItemUserDelete.setText("删除用户");
    jMenuBar.setBackground(SystemColor.inactiveCaption);
    jMenuBar.setFont(new java.awt.Font("Dialog", 0, 16));
    jMenuItemBookorderUpdate.setBackground(SystemColor.inactiveCaptionText);
    jMenuItemBookorderUpdate.setFont(new java.awt.Font("Dialog", 0, 16));
    jMenuItemBookorderUpdate.setText("教材预订修改");
    jMenuinBook.setBackground(SystemColor.inactiveCaption);
    jMenuinBook.setFont(new java.awt.Font("Dialog", 0, 16));
    jMenuinBook.setText("教材入库管理");
    jMenuItemBookin.setBackground(SystemColor.inactiveCaptionText);
    jMenuItemBookin.setFont(new java.awt.Font("Dialog", 0, 16));
    jMenuItemBookin.setText("按预定入库教材");
    jMenuoutBook.setBackground(SystemColor.inactiveCaption);
    jMenuoutBook.setFont(new java.awt.Font("Dialog", 0, 16));
    jMenuoutBook.setActionCommand("教材出库管理");
    jMenuoutBook.setText("教材出库管理");

    this.addWindowListener(new BookManagerMain_this_windowAdapter(this));
    jMenuItemUserAdd.addActionListener(new BookManagerMain_jMenuItemUserAdd_actionAdapter(this));
    jMenuItemusersearch.addActionListener(new BookManagerMain_jMenuItemusersearch_actionAdapter(this));
    jMenuItemUserUpdate.addActionListener(new BookManagerMain_jMenuItemUserUpdate_actionAdapter(this));
    jMenuItemUserDelete.addActionListener(new  BookManagerMain_jMenuItemUserDelete_actionAdapter(this));
    jMenuFileExit.addActionListener(new    BookManagerMain_jMenuFileExit_actionAdapter(this));
    jMenuItemLogin.addActionListener(new   BookManagerMain_jMenuItemLogin_actionAdapter(this));
    jMenuItemBookorderUpdate.addActionListener(new  BookManagerMain_jMenuItemBookorderUpdate_actionAdapter(this));
    jMenuItembookorderAdd.addActionListener(new  BookManagerMain_jMenuItembookorderAdd_actionAdapter(this));
    jMenuItemorderbookquery.addActionListener(new  BookManagerMain_jMenuItemorderbookquery_actionAdapter(this));
    jMenuItemBookin.addActionListener(new   BookManagerMain_jMenuItemBookin_actionAdapter(this));
    jMenuItemregistationfees.addActionListener(new   BookManagerMain_jMenuItemregistationfees_actionAdapter(this));
    jMenuIteminqbybookname.addActionListener(new    BookManagerMain_jMenuIteminqbybookname_actionAdapter(this));
    jMenuIteminqbyISBN.addActionListener(new    BookManagerMain_jMenuIteminqbyISBN_actionAdapter(this));
    jMenuIteminqbybooktype.addActionListener(new    BookManagerMain_jMenuIteminqbybooktype_actionAdapter(this));
    jMenuIteminqbyorderuser.addActionListener(new    BookManagerMain_jMenuIteminqbyorderuser_actionAdapter(this));
    jMenuItemoutbookS.addActionListener(new    BookManagerMain_jMenuItemoutbookS_actionAdapter(this));
    jMenuItemoutbookSquery.addActionListener(new    BookManagerMain_jMenuItemoutbookSquery_actionAdapter(this));
    jMenuItemxitongshuoming.addActionListener(new    BookManagerMain_jMenuItemxitongshuoming_actionAdapter(this));
    jMenuItemoutqbyISBN.addActionListener(new    BookManagerMain_jMenuItemoutqbyISBN_actionAdapter(this));
    jMenuItemoutqbybookname.addActionListener(new    BookManagerMain_jMenuItemoutqbybookname_actionAdapter(this));
    jMenuItemrecordpayquery.addActionListener(new    BookManagerMain_jMenuItemrecordpayquery_actionAdapter(this));
    jMenuItempayqbydepartment.addActionListener(new    BookManagerMain_jMenuItempayqbydepartment_actionAdapter(this));
    jMenuItembookList.addActionListener(new    BookManagerMain_jMenuItembookList_actionAdapter(this));
    jMenuItembookqueryzonghe.addActionListener(new    BookManagerMain_jMenuItembookqueryzonghe_actionAdapter(this));
    jMenuItembookAdd.addActionListener(new    BookManagerMain_jMenuItembookAdd_actionAdapter(this));
    jMenuItemorderbookList.addActionListener(new    BookManagerMain_jMenuItemorderbookList_actionAdapter(this));
    jMenuItemchakanliuyan.addActionListener(new    BookManagerMain_jMenuItemchakanliuyan_actionAdapter(this));
    jMenuItemlianxiwomen.addActionListener(new    BookManagerMain_jMenuItemlianxiwomen_actionAdapter(this));
    jButtonuserUpdate.addActionListener(new    BookManagerMain_jButtonuserUpdate_actionAdapter(this));
    jButtonbookList.addActionListener(new    BookManagerMain_jButtonbookList_actionAdapter(this));

    jButtonorderbookquery.addActionListener(new    BookManagerMain_jButtonorderbookquery_actionAdapter(this));
    jButtoninqbybookname.addActionListener(new    BookManagerMain_jButtoninqbybookname_actionAdapter(this));
    jButtonoutbookSquery.addActionListener(new    BookManagerMain_jButtonoutbookSquery_actionAdapter(this));
    jButtonrecordpayquery.addActionListener(new    BookManagerMain_jButtonrecordpayquery_actionAdapter(this));
    jButtonCalculator.addActionListener(new    BookManagerMain_jButtonCalculator_actionAdapter(this));
    jMenubookcost.setBackground(SystemColor.inactiveCaption);
    jMenubookcost.setFont(new java.awt.Font("Dialog", 0, 16));
    jMenubookcost.setText("教材交费管理");
    jMenuItemregistationfees.setBackground(SystemColor.inactiveCaptionText);
    jMenuItemregistationfees.setFont(new java.awt.Font("Dialog", 0, 16));
    jMenuItemregistationfees.setText("交费登记");
    jMenuItemusersearch.setBackground(SystemColor.inactiveCaptionText);
    jMenuItemusersearch.setFont(new java.awt.Font("Dialog", 0, 16));
    jMenuItemusersearch.setText("用户信息查询");
    jMenuItembookorderAdd.setBackground(SystemColor.inactiveCaptionText);
    jMenuItembookorderAdd.setFont(new java.awt.Font("Dialog", 0, 16));
    jMenuItembookorderAdd.setText("教材预订");
    jMenuItemorderbookquery.setBackground(SystemColor.inactiveCaptionText);
    jMenuItemorderbookquery.setFont(new java.awt.Font("Dialog", 0, 16));
    jMenuItemorderbookquery.setText("用户预订情况查询");
    jMenu1.setBackground(SystemColor.inactiveCaptionText);
    jMenu1.setFont(new java.awt.Font("Dialog", 0, 16));
    jMenu1.setText("教材入库查询");
    jMenuIteminqbyISBN.setBackground(SystemColor.inactiveCaptionText);
    jMenuIteminqbyISBN.setFont(new java.awt.Font("Dialog", 0, 16));
    jMenuIteminqbyISBN.setText("按ISBN号查询");
    jMenuIteminqbybookname.setBackground(SystemColor.inactiveCaptionText);
    jMenuIteminqbybookname.setFont(new java.awt.Font("Dialog", 0, 16));
    jMenuIteminqbybookname.setText("按教材名称查询");
    jMenuIteminqbybooktype.setBackground(SystemColor.inactiveCaptionText);
    jMenuIteminqbybooktype.setFont(new java.awt.Font("Dialog", 0, 16));
    jMenuIteminqbybooktype.setText("按类别查询");
    jMenuIteminqbyorderuser.setBackground(SystemColor.inactiveCaptionText);
    jMenuIteminqbyorderuser.setFont(new java.awt.Font("Dialog", 0, 16));
    jMenuIteminqbyorderuser.setText("按预定用户需求");
    jMenu4.setBackground(SystemColor.inactiveCaptionText);
    jMenu4.setFont(new java.awt.Font("Dialog", 0, 16));
    jMenu4.setText("领书情况查询");
    jMenuItemoutbookSquery.setBackground(SystemColor.inactiveCaptionText);
    jMenuItemoutbookSquery.setFont(new java.awt.Font("Dialog", 0, 16));
    jMenuItemoutbookSquery.setAlignmentY((float) 0.5);
    jMenuItemoutbookSquery.setActionCommand("按领书用户类型查询");
    jMenuItemoutbookSquery.setText("按领书用户查询");
    jMenuItemoutbookSquery.setArmed(false);
    jMenu3.setBackground(SystemColor.inactiveCaption);
    jMenu3.setFont(new java.awt.Font("Dialog", 0, 16));
    jMenu3.setHorizontalTextPosition(SwingConstants.TRAILING);
    jMenu3.setText("关于");
    jMenuItemxitongshuoming.setBackground(SystemColor.inactiveCaptionText);
    jMenuItemxitongshuoming.setFont(new java.awt.Font("Dialog", 0, 16));
    jMenuItemxitongshuoming.setText("系统说明");
    contentPane.setBackground(UIManager.getColor("ComboBox.selectionBackground"));
    contentPane.setDebugGraphicsOptions(0);
    jMenuItemoutbookS.setBackground(SystemColor.inactiveCaptionText);
    jMenuItemoutbookS.setFont(new java.awt.Font("Dialog", 0, 16));
    jMenuItemoutbookS.setText("领书");
    jMenuItemoutqbyISBN.setBackground(SystemColor.inactiveCaptionText);
    jMenuItemoutqbyISBN.setFont(new java.awt.Font("Dialog", 0, 16));
    jMenuItemoutqbyISBN.setText("按ISBN查询领书情况");
    jMenuItemoutqbybookname.setBackground(SystemColor.inactiveCaptionText);
    jMenuItemoutqbybookname.setFont(new java.awt.Font("Dialog", 0, 16));
    jMenuItemoutqbybookname.setText("按书名查询领书情况");
    jMenu5.setBackground(SystemColor.inactiveCaptionText);
    jMenu5.setFont(new java.awt.Font("Dialog", 0, 16));
    jMenu5.setText("交费记录查询");
    jMenuItemrecordpayquery.setBackground(SystemColor.inactiveCaptionText);
    jMenuItemrecordpayquery.setFont(new java.awt.Font("Dialog", 0, 16));
    jMenuItemrecordpayquery.setText("按交费用户名查询");
    jMenuItempayqbydepartment.setBackground(SystemColor.inactiveCaptionText);
    jMenuItempayqbydepartment.setFont(new java.awt.Font("Dialog", 0, 16));
    jMenuItempayqbydepartment.setText("按院系查询");
    jButtonuserUpdate.setBackground(UIManager.getColor("InternalFrame.inactiveTitleBackground"));
    jButtonuserUpdate.setFont(new java.awt.Font("Dialog", 0, 16));
    jButtonuserUpdate.setForeground(UIManager.getColor("ColorChooser.foreground"));
    jButtonuserUpdate.setMinimumSize(new Dimension(109, 35));
    jButtonuserUpdate.setRolloverEnabled(false);
    jButtonuserUpdate.setSelectedIcon(null);
    jButtonuserUpdate.setIcon(null);

    jButtonorderbookquery.setBackground(UIManager.getColor("InternalFrame.inactiveTitleBackground"));
    jButtonorderbookquery.setFont(new java.awt.Font("Dialog", 0, 16));
    jButtonorderbookquery.setIcon(null);
    jButtonorderbookquery.setMargin(new Insets(2, 14, 2, 14));
    jButtonorderbookquery.setText("教材预订信息查询");
    jButtonbookList.setBackground(UIManager.getColor("InternalFrame.inactiveTitleBackground"));
    jButtonbookList.setFont(new java.awt.Font("Dialog", 0, 16));
    jButtonbookList.setText("书籍信息查询");
    jButtoninqbybookname.setBackground(UIManager.getColor("InternalFrame.inactiveTitleBackground"));
    jButtoninqbybookname.setFont(new java.awt.Font("Dialog", 0, 16));
    jButtoninqbybookname.setText("教材入库查询");
    jButtonoutbookSquery.setBackground(UIManager.getColor("InternalFrame.inactiveTitleBackground"));
    jButtonoutbookSquery.setFont(new java.awt.Font("Dialog", 0, 16));
    jButtonoutbookSquery.setIcon(null);
    jButtonoutbookSquery.setText("教材出库信息查询");
    jButtonrecordpayquery.setBackground(UIManager.getColor("InternalFrame.inactiveTitleBackground"));
    jButtonrecordpayquery.setFont(new java.awt.Font("Dialog", 0, 16));
    jButtonrecordpayquery.setText("交费信息查询");
    jButtonCalculator.setBackground(UIManager.getColor("InternalFrame.inactiveTitleBackground"));
    jButtonCalculator.setFont(new java.awt.Font("Dialog", 0, 16));
    jButtonCalculator.setText("计算器");
    jButtonorderbookquery.setIcon(new ImageIcon("9.jpg"));



    jButton1.setBackground(UIManager.getColor("InternalFrame.inactiveTitleBackground"));
    jButton1.setIcon(new ImageIcon("2.jpg"));
    jButtonuserUpdate.setIcon(new  ImageIcon ("7.jpg"));
    jButtonbookList.setIcon(new  ImageIcon ("6.jpg"));
     jButtoninqbybookname.setIcon(new  ImageIcon ("10.jpg"));
     jButtonoutbookSquery.setIcon(new  ImageIcon ("11.jpg"));
     jButtonrecordpayquery.setIcon(new  ImageIcon ("12.jpg"));
     jButtonCalculator.setIcon(new  ImageIcon ("13.jpg"));
    jButtonuserUpdate.setText("修改用户信息");

    jButton1.setText("");
    jMenu2.setBackground(SystemColor.inactiveCaptionText);
    jMenu2.setFont(new java.awt.Font("Dialog", 0, 16));
    jMenu2.setText("教材信息查询");
    jMenuItembookList.setFont(new java.awt.Font("Dialog", 0, 16));
    jMenuItembookList.setText("精确查询");
    jMenuItembookqueryzonghe.setFont(new java.awt.Font("Dialog", 0, 16));
    jMenuItembookqueryzonghe.setText("综合查询");
    jMenuItemorderbookList.setBackground(SystemColor.inactiveCaptionText);
    jMenuItemorderbookList.setFont(new java.awt.Font("Dialog", 0, 16));
    jMenuItemorderbookList.setText("教材预定清单");
    jMenuItembookAdd.setBackground(SystemColor.inactiveCaptionText);
    jMenuItembookAdd.setFont(new java.awt.Font("Dialog", 0, 16));
    jMenuItembookAdd.setText("新教材入库");
    jMenu6.setBackground(SystemColor.inactiveCaption);
    jMenu6.setFont(new java.awt.Font("Dialog", 0, 16));
    jMenu6.setText("联系我们");
    jMenuItemlianxiwomen.setBackground(SystemColor.inactiveCaptionText);
    jMenuItemlianxiwomen.setFont(new java.awt.Font("Dialog", 0, 16));
    jMenuItemlianxiwomen.setText("添加留言");
    jMenuItemchakanliuyan.setBackground(SystemColor.inactiveCaptionText);
    jMenuItemchakanliuyan.setFont(new java.awt.Font("Dialog", 0, 16));
    jMenuItemchakanliuyan.setText("查询留言");
    jMenuSystem.add(jMenuItemLogin);
    jMenuSystem.add(jMenuUserManager);
    jMenuSystem.add(jMenuFileExit);
    jMenuBookManager.add(jMenu2);
    jMenuBookManager.add(jMenuItembookorderAdd);
    jMenuBookManager.add(jMenuItemBookorderUpdate);
    jMenuBookManager.add(jMenuItemorderbookquery);
    jMenuBookManager.add(jMenuItemorderbookList);
    jMenuBookManager.add(jMenuItemorderbookquery);
    jMenuBar.add(jMenuSystem);
    jMenuBar.add(jMenuBookManager);
    jMenuBar.add(jMenuinBook);
    jMenuBar.add(jMenuoutBook);
    jMenuBar.add(jMenubookcost);
    jMenuBar.add(jMenu6);
    jMenuBar.add(jMenu3);
    jMenuUserManager.add(jMenuItemusersearch);
    jMenuUserManager.add(jMenuItemUserAdd);
    jMenuUserManager.add(jMenuItemUserUpdate);
    jMenuUserManager.add(jMenuItemUserDelete);
    jMenuinBook.add(jMenuItembookAdd);
    jMenuinBook.add(jMenuItemBookin);
    jMenuinBook.add(jMenu1);
    jMenubookcost.add(jMenuItemregistationfees);
    jMenubookcost.add(jMenu5);