frame1.java~3~

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

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



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 {
  JPanel contentPane;
  Database database1 = new Database();
  JMenuBar jMenuBar1 = new JMenuBar();
  JMenu jMenu1 = new JMenu();
  JMenu jMenu2 = new JMenu();
  JMenu jMenu3 = new JMenu();
  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();
 /* ImageIcon image1;
  ImageIcon image2;
  ImageIcon image3;
  ImageIcon image4;
  ImageIcon image5;
  ImageIcon image6;
  ImageIcon image7;
  ImageIcon image8;
  ImageIcon image9;*/
  JMenuItem jMenuItem27 = new JMenuItem();
 /* JToolBar jToolBar1 = new JToolBar();
  JButton jButton1 = new JButton();
  JButton jButton2 = new JButton();
  JButton jButton3 = new JButton();
  JButton jButton4 = new JButton();
  JButton jButton5 = new JButton();
  JButton jButton6 = new JButton();
  JButton jButton7 = new JButton();
  JButton jButton8 = new JButton();
  JButton jButton9 = new JButton();*/
  //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"));
    jButton1.setBackground(Color.cyan);
    jButton1.setToolTipText("help");
    jButton1.setText("");
    jButton1.setIcon(image1);
    jButton2.setText("");
    jButton2.setBackground(Color.cyan);
    jButton2.setToolTipText("print view");
    jButton2.setIcon(image2);
    jButton2.setText("");
    jButton3.setText("");
    jButton3.setBackground(Color.cyan);
    jButton3.setToolTipText("print");
    jButton3.setIcon(image3);
    jButton3.setText("");
    jButton4.setText("");
    jButton4.setBackground(Color.cyan);
    jButton4.setToolTipText("alter infomation");
    jButton4.setIcon(image4);
    jButton4.setText("");
    jButton5.setText("");
    jButton5.setBackground(Color.cyan);
    jButton5.setToolTipText("delete infomation");
    jButton5.setIcon(image5);
    jButton5.setText("");
    jButton6.setText("");
    jButton6.setBackground(Color.cyan);
    jButton6.setToolTipText("add infomation");
    jButton6.setIcon(image6);
    jButton6.setText("");
    jButton7.setText("");
    jButton7.setBackground(Color.cyan);
    jButton7.setToolTipText("select accord to ID");
    jButton7.setIcon(image7);
    jButton7.setText("");
    jButton8.setText("");
    jButton8.setBackground(Color.cyan);
    jButton8.setToolTipText("delete value");
    jButton8.setIcon(image8);
    jButton8.setText("");
    jButton9.setText("");
    jButton9.setBackground(Color.cyan);
    jButton9.setToolTipText("add value");
     jButton9.setIcon(image9);
    jButton9.setText("");*/
    jMenuItem27.addActionListener(new Frame1_jMenuItem27_actionAdapter(this));
    jMenu1.setForeground(Color.black);
    //jToolBar1.setBackground(Color.pink);
    jMenuItem28.addActionListener(new Frame1_jMenuItem28_actionAdapter(this));
    /*jToolBar1.add(jButton9, null);
    jToolBar1.add(jButton8, null);
    jToolBar1.add(jButton7, null);
    jToolBar1.add(jButton6, null);
    jToolBar1.add(jButton5, null);
    jToolBar1.add(jButton4, null);
    jToolBar1.add(jButton3, null);
    jToolBar1.add(jButton2, null);
    jToolBar1.add(jButton1, null);*/

    contentPane = (JPanel) this.getContentPane();
    database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:odbc:person", "", "", false, "sun.jdbc.odbc.JdbcOdbcDriver"));
    database1.setDatabaseName("");
    contentPane.setLayout(xYLayout1);
    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.pink);
    contentPane.setForeground(Color.pink);
    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.setBackground(Color.pink);
    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("按银行卡号");
    jMenuItem23.setArmed(false);
    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("按手机号码");
//    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);
    column5.setTableName("bookInfoTable");
    column5.setServerColumnName("loanflag");
    column5.setSqlType(4);
    column6.setColumnName("press");
    column6.setDataType(com.borland.dx.dataset.Variant.STRING);
    column6.setPrecision(50);
    column6.setTableName("bookInfoTable");
    column6.setServerColumnName("press");
    column6.setSqlType(12);
    column7.setColumnName("author1");
    column7.setDataType(com.borland.dx.dataset.Variant.STRING);
    column7.setPrecision(50);
    column7.setTableName("bookInfoTable");
    column7.setServerColumnName("author1");
    column7.setSqlType(12);
    column8.setColumnName("bookTypeNo");
    column8.setDataType(com.borland.dx.dataset.Variant.INT);
    column8.setTableName("bookInfoTable");
    column8.setServerColumnName("bookTypeNo");
    column8.setSqlType(4);
    column9.setColumnName("remark");
    column9.setDataType(com.borland.dx.dataset.Variant.STRING);
    column9.setPrecision(50);
    column9.setTableName("bookInfoTable");
    column9.setServerColumnName("remark");
    column9.setSqlType(12);
    jMenuItem28.setFont(new java.awt.Font("Dialog", 0, 12));