frame1.java~2~

Java数据库系统项目开发实践源程序第4章.rar

package enterpriseemployeeadministrate;

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

public class Frame1 extends JFrame {
  JToolBar jToolBar1 = new JToolBar();
  JButton jButton1 = new JButton();
  ImageIcon image1;
  ImageIcon image2;
  ImageIcon image3;
  ImageIcon image4;
  ImageIcon image5;
  ImageIcon image6;
  ImageIcon image7;
  ImageIcon image8;
  ImageIcon image9;
  JPanel contentPane;
  Database database1 = new Database();
  QueryDataSet queryDataSet1 = new QueryDataSet();
  JMenuBar jMenuBar1 = new JMenuBar();
  JMenu jMenu1 = new JMenu();
  JMenu jMenu2 = new JMenu();
  JMenu jMenu3 = new JMenu();
  BorderLayout borderLayout1 = new BorderLayout();
  JMenu jMenu4 = new JMenu();
  JMenuItem jMenuItem4 = new JMenuItem();
  JMenuItem jMenuItem5 = new JMenuItem();
  JMenuItem jMenuItem6 = new JMenuItem();
  JMenuItem jMenuItem7 = new JMenuItem();
  JMenuItem jMenuItem8 = new JMenuItem();
  JMenuItem jMenuItem9 = new JMenuItem();
  JMenuItem jMenuItem10 = new JMenuItem();
  JMenuItem jMenuItem12 = new JMenuItem();
  JMenuItem jMenuItem13 = new JMenuItem();
  JMenuItem jMenuItem14 = new JMenuItem();
  JMenu jMenu5 = new JMenu();
  JMenuItem jMenuItem15 = new JMenuItem();
  JMenuItem jMenuItem16 = new JMenuItem();
  JMenuItem jMenuItem17 = new JMenuItem();
  JMenuItem jMenuItem18 = new JMenuItem();
  JMenuItem jMenuItem19 = new JMenuItem();
  JMenuItem jMenuItem20 = new JMenuItem();
  JMenuItem jMenuItem21 = new JMenuItem();
  JMenuItem jMenuItem22 = new JMenuItem();
  JMenuItem jMenuItem23 = new JMenuItem();
  JMenuItem jMenuItem24 = new JMenuItem();
  JMenuItem jMenuItem2 = new JMenuItem();
  JMenuItem jMenuItem25 = new JMenuItem();
  JMenuItem jMenuItem26 = new JMenuItem();
  JMenuItem jMenuItem3 = new JMenuItem();
  JMenuItem jMenuItem11 = new JMenuItem();
  Column column1 = new Column();
  Column column2 = new Column();
  Column column3 = new Column();
  Column column4 = new Column();
  Column column5 = new Column();
  Column column6 = new Column();
  Column column7 = new Column();
  Column column8 = new Column();
  Column column9 = new Column();
  JMenuItem jMenuItem28 = new JMenuItem();
  JMenuItem jMenuItem1 = new JMenuItem();
  JToolBar jToolBar1 = new JToolBar();
  JButton jButton1 = new JButton();
  JButton jButton2 = new JButton();
  JButton jButton3 = new JButton();
  JButton jButton4 = new JButton();
  ImageIcon image1;
  ImageIcon image2;
  ImageIcon image3;
  //Construct the frame
  public Frame1() {
    enableEvents(AWTEvent.WINDOW_EVENT_MASK);
    try {
      jbInit();
    }
    catch (Exception e) {
      e.printStackTrace();
    }
  }

  //Component initialization
  private void jbInit() throws Exception {
    image1 = new ImageIcon(enterpriseemployeeadministrate.Frame1.class.
                           getResource("help.png"));
    image2 = new ImageIcon(enterpriseemployeeadministrate.Frame1.class.
                           getResource("ovalHotspot.png"));
    image3 = new ImageIcon(enterpriseemployeeadministrate.Frame1.class.
                           getResource("media.png"));
    image4 = new ImageIcon(enterpriseemployeeadministrate.Frame1.class.
                           getResource("image.png"));
    image5 = new ImageIcon(enterpriseemployeeadministrate.Frame1.class.
                           getResource("Rollover.png"));
    image6 = new ImageIcon(enterpriseemployeeadministrate.Frame1.class.
                           getResource("Snippets.png"));
    image7 = new ImageIcon(enterpriseemployeeadministrate.Frame1.class.
                           getResource("Image Viewer.png"));
    image8 = new ImageIcon(enterpriseemployeeadministrate.Frame1.class.
                           getResource("Text Field.png"));
    image9 = new ImageIcon(enterpriseemployeeadministrate.Frame1.class.
                           getResource("Image Field.png"));

    contentPane = (JPanel)this.getContentPane();
    database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor(
        "jdbc:odbc:book", "sa", "", false, "sun.jdbc.odbc.JdbcOdbcDriver"));
    database1.setDatabaseName("");
    contentPane.setLayout(borderLayout1);
    this.setFont(new java.awt.Font("SansSerif", 0, 12));
    this.setForeground(Color.white);
    this.setJMenuBar(jMenuBar1);
    this.setSize(new Dimension(400, 300));
    this.setTitle("企业人事管理系统");
    contentPane.setBackground(Color.lightGray);
    contentPane.setForeground(Color.lightGray);
    contentPane.setAlignmentY( (float) 0.5);
    jMenu1.setFont(new java.awt.Font("Dialog", 0, 13));
    jMenu1.setText("员工信息管理");
    jMenu2.setFont(new java.awt.Font("Dialog", 0, 13));
    jMenu2.setText("用户权限管理");
    jMenu3.setFont(new java.awt.Font("Dialog", 0, 13));
    jMenu3.setText("信息处理");
    jMenuBar1.setFont(new java.awt.Font("Dialog", 0, 13));
    jMenuBar1.setForeground(new Color(212, 208, 200));
    jMenuBar1.setRequestFocusEnabled(true);
    jMenuBar1.setToolTipText("");
    jMenuBar1.setInputVerifier(null);
    jMenu4.setFont(new java.awt.Font("Dialog", 0, 13));
    jMenu4.setText("系统使用帮助");
    jMenuItem4.setFont(new java.awt.Font("Dialog", 0, 12));
    jMenuItem4.setText("密码修改");
    jMenuItem5.setFont(new java.awt.Font("Dialog", 0, 12));
    jMenuItem5.setText("增加用户");
    jMenuItem6.setFont(new java.awt.Font("Dialog", 0, 12));
    jMenuItem6.setText("删除用户");
    jMenuItem7.setFont(new java.awt.Font("Dialog", 0, 12));
    jMenuItem7.setText("设置权限");
    jMenuItem8.setFont(new java.awt.Font("Dialog", 0, 12));
    jMenuItem8.setText("关于帮助");
    jMenuItem9.setFont(new java.awt.Font("Dialog", 0, 12));
    jMenuItem9.setText("帮助信息");
    jMenuItem10.setFont(new java.awt.Font("Dialog", 0, 12));
    jMenuItem10.setText("版权信息");
    jMenuItem12.setFont(new java.awt.Font("Dialog", 0, 12));
    jMenuItem12.setText("员工信息备份");
    jMenuItem13.setFont(new java.awt.Font("Dialog", 0, 12));
    jMenuItem13.setText("用户信息备份");
    jMenuItem14.setFont(new java.awt.Font("Dialog", 0, 12));
    jMenuItem14.setText("退出");
    jMenuItem14.addActionListener(new Frame1_jMenuItem14_actionAdapter(this));
    jMenu5.setFont(new java.awt.Font("Dialog", 0, 12));
    jMenu5.setText("员工信息查询 ");
    jMenuItem15.setFont(new java.awt.Font("Dialog", 0, 12));
    jMenuItem15.setText("按职工号");
    jMenuItem16.setFont(new java.awt.Font("Dialog", 0, 12));
    jMenuItem16.setText("按姓名");
    jMenuItem17.setFont(new java.awt.Font("Dialog", 0, 12));
    jMenuItem17.setText("按生日");
    jMenuItem18.setFont(new java.awt.Font("Dialog", 0, 12));
    jMenuItem18.setText("按职务");
    jMenuItem19.setFont(new java.awt.Font("Dialog", 0, 12));
    jMenuItem19.setText("按部门");
    jMenuItem20.setFont(new java.awt.Font("Dialog", 0, 12));
    jMenuItem20.setText("按身份证号");
    jMenuItem21.setFont(new java.awt.Font("Dialog", 0, 12));
    jMenuItem21.setText("按年龄");
    jMenuItem22.setFont(new java.awt.Font("Dialog", 0, 12));
    jMenuItem22.setText("按电话号吗");
    jMenuItem23.setFont(new java.awt.Font("Dialog", 0, 12));
    jMenuItem23.setText("按银行卡号");
    jMenuItem24.setFont(new java.awt.Font("Dialog", 0, 12));
    jMenuItem24.setText("按毕业院校");
    jMenuItem2.setFont(new java.awt.Font("Dialog", 0, 12));
    jMenuItem2.setText("更新员工信息");
    jMenuItem25.setFont(new java.awt.Font("Dialog", 0, 12));
    jMenuItem25.setText("录入员工信息");
    jMenuItem25.addActionListener(new Frame1_jMenuItem25_actionAdapter(this));
    jMenuItem26.setFont(new java.awt.Font("Dialog", 0, 12));
    jMenuItem26.setText("打印员工信息");
    jMenuItem3.setFont(new java.awt.Font("Dialog", 0, 12));
    jMenuItem3.setText("打印生成报表");
    jMenuItem11.setFont(new java.awt.Font("Dialog", 0, 12));
    jMenuItem11.setText("按手机号码");
    queryDataSet1.setMetaDataUpdate(MetaDataUpdate.NONE);
    queryDataSet1.setTableName("bookInfoTable");
    queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(
        database1, "select * from bookInfoTable", null, true, Load.ALL));
//    author2.setRowId(false);
    column1.setColumnName("bookNo");
    column1.setDataType(com.borland.dx.dataset.Variant.INT);
    column1.setDefault("");
    column1.setRowId(true);
    column1.setResolvable(true);
    column1.setServerColumnName("bookNo");
    column1.setSqlType(4);
    column2.setColumnName("bookName");
    column2.setDataType(com.borland.dx.dataset.Variant.STRING);
    column2.setPrecision(50);
    column2.setRowId(true);
    column2.setServerColumnName("bookName");
    column2.setSqlType(12);
    column3.setColumnName("author2");
    column3.setDataType(com.borland.dx.dataset.Variant.STRING);
    column3.setPrecision(50);
    column3.setRowId(false);
    column3.setServerColumnName("author2");
    column3.setSqlType(12);
    column4.setColumnName("reservationflag");
    column4.setDataType(com.borland.dx.dataset.Variant.INT);
    column4.setTableName("bookInfoTable");
    column4.setServerColumnName("reservationflag");
    column4.setSqlType(4);
    column5.setColumnName("loanflag");
    column5.setDataType(com.borland.dx.dataset.Variant.INT);