frame1.java~230~

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

//按工号
  void jMenuItem15_actionPerformed(ActionEvent e) {
       String ID=JOptionPane.showInputDialog(this,"please enter the person's ID:");
      try{
       int no=Integer.parseInt(ID);
       QueryDataSet allInfo = new QueryDataSet();
      allInfo.setMetaDataUpdate(MetaDataUpdate.NONE);
      allInfo.setTableName("bookInfoTable");
      allInfo.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from person_info where ID="+no, null, true, Load.ALL));
      jdbTable1.setDataSet(allInfo);

     }
     catch(NumberFormatException newException){
     JOptionPane.showMessageDialog(null,"please enter right number!!");
     }

  }
//按姓名
  void jMenuItem16_actionPerformed(ActionEvent e) {
    String name=JOptionPane.showInputDialog(this,"please enter the person's name:");
    QueryDataSet allInfo = new QueryDataSet();
   allInfo.setMetaDataUpdate(MetaDataUpdate.NONE);
   allInfo.setTableName("bookInfoTable");
   allInfo.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from person_info where name='"+name+"'", null, true, Load.ALL));
   jdbTable1.setDataSet(allInfo);

  }
//按出生日期
  void jMenuItem17_actionPerformed(ActionEvent e) {
    String birthday=JOptionPane.showInputDialog(this,"please enter the person's birthday:");
    QueryDataSet allInfo = new QueryDataSet();
   allInfo.setMetaDataUpdate(MetaDataUpdate.NONE);
   allInfo.setTableName("bookInfoTable");
   allInfo.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from person_info where birthday='"+birthday+"'", null, true, Load.ALL));
   jdbTable1.setDataSet(allInfo);

  }
//按部门
  void jMenuItem19_actionPerformed(ActionEvent e) {
    String branch=JOptionPane.showInputDialog(this,"please enter the person's branch:");
    QueryDataSet allInfo = new QueryDataSet();
   allInfo.setMetaDataUpdate(MetaDataUpdate.NONE);
   allInfo.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from person_info where branch='"+branch+"'", null, true, Load.ALL));
   jdbTable1.setDataSet(allInfo);

  }
//按职务查询
  void jMenuItem18_actionPerformed(ActionEvent e) {
    String job=JOptionPane.showInputDialog(this,"please enter the person's job:");
    QueryDataSet allInfo = new QueryDataSet();
   allInfo.setMetaDataUpdate(MetaDataUpdate.NONE);
   allInfo.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from person_info where job='"+job+"'", null, true, Load.ALL));
   jdbTable1.setDataSet(allInfo);
  }
//按身份证号
  void jMenuItem20_actionPerformed(ActionEvent e) {
    String IDcard=JOptionPane.showInputDialog(this,"please enter the person's ID crad:");
    QueryDataSet allInfo = new QueryDataSet();
   allInfo.setMetaDataUpdate(MetaDataUpdate.NONE);
   allInfo.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from person_info where ID_card='"+IDcard+"'", null, true, Load.ALL));
   jdbTable1.setDataSet(allInfo);
  }
//按年龄
  void jMenuItem21_actionPerformed(ActionEvent e) {
    String tel=JOptionPane.showInputDialog(this,"please enter the person's ID:");
   try{
    int telno=Integer.parseInt(tel);
    QueryDataSet allInfo = new QueryDataSet();
   allInfo.setMetaDataUpdate(MetaDataUpdate.NONE);
   allInfo.setTableName("bookInfoTable");
   allInfo.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from person_info where tel="+telno, null, true, Load.ALL));
   jdbTable1.setDataSet(allInfo);
  }
  catch(NumberFormatException newException){
  JOptionPane.showMessageDialog(null,"please enter right number!!");
  }
  }
//按电话号码
  void jMenuItem22_actionPerformed(ActionEvent e) {
    String telephone=JOptionPane.showInputDialog(this,"please enter the person's telephone:");
    QueryDataSet allInfo = new QueryDataSet();
   allInfo.setMetaDataUpdate(MetaDataUpdate.NONE);
   allInfo.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from person_info where tel='"+telephone+"'", null, true, Load.ALL));
   jdbTable1.setDataSet(allInfo);

  }
//按手机号
  void jMenuItem11_actionPerformed(ActionEvent e) {
    String mobilephone=JOptionPane.showInputDialog(this,"please enter the person's mobile telephone:");
    QueryDataSet allInfo = new QueryDataSet();
   allInfo.setMetaDataUpdate(MetaDataUpdate.NONE);
   allInfo.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from person_info where mobile='"+mobilephone+"'", null, true, Load.ALL));
   jdbTable1.setDataSet(allInfo);
  }
//按银行卡号
  void jMenuItem23_actionPerformed(ActionEvent e) {
    String bankID=JOptionPane.showInputDialog(this,"please enter the person's bank ID:");
    QueryDataSet allInfo = new QueryDataSet();
   allInfo.setMetaDataUpdate(MetaDataUpdate.NONE);
   allInfo.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from person_info where bankID='"+bankID+"'", null, true, Load.ALL));
   jdbTable1.setDataSet(allInfo);
  }
//按毕业院校
  void jMenuItem24_actionPerformed(ActionEvent e) {
    String school=JOptionPane.showInputDialog(this,"please enter the person's grad-school:");
    QueryDataSet allInfo = new QueryDataSet();
   allInfo.setMetaDataUpdate(MetaDataUpdate.NONE);
   allInfo.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from person_info where school='"+school+"'", null, true, Load.ALL));
   jdbTable1.setDataSet(allInfo);

  }
//调出员工信息管理界面
  void jMenuItem1_actionPerformed(ActionEvent e) {
EmployeeInfomation employee=new EmployeeInfomation();
employee.setVisible(true);
  }
//管理用户信息
  void jMenuItem6_actionPerformed(ActionEvent e) {
    UserInfo user=new UserInfo();
    user.show();
  }
//用户信息管理
  void jMenuItem7_actionPerformed(ActionEvent e) {
    UserInfo user=new UserInfo();
    user.show();
  }
//员工信息管理
  void jMenuItem12_actionPerformed(ActionEvent e) {
    EmployeeInfomation employee=new EmployeeInfomation();
    employee.show();
  }
//关于帮助
  void jMenuItem8_actionPerformed(ActionEvent e) {
JOptionPane.showMessageDialog(this,"this is the work of cao .don't copy,please!!");
  }
//系统管理员管理用户信息
  void jMenuItem13_actionPerformed(ActionEvent e) {
    UserInfoControl userControl=new UserInfoControl();
    userControl.show();
  }
}

class Frame1_jMenuItem14_actionAdapter implements java.awt.event.ActionListener {
  Frame1 adaptee;

  Frame1_jMenuItem14_actionAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jMenuItem14_actionPerformed(e);
  }
}

class Frame1_jdbNavToolBar1_ancestorAdapter implements javax.swing.event.AncestorListener {
  Frame1 adaptee;

  Frame1_jdbNavToolBar1_ancestorAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }
  public void ancestorAdded(AncestorEvent e) {
    //adaptee.jdbNavToolBar1_ancestorAdded(e);
  }
  public void ancestorRemoved(AncestorEvent e) {
  }
  public void ancestorMoved(AncestorEvent e) {
  }
}

class Frame1_jMenuItem27_actionAdapter implements java.awt.event.ActionListener {
  Frame1 adaptee;

  Frame1_jMenuItem27_actionAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jMenuItem27_actionPerformed(e);
  }
}

class Frame1_jMenuItem28_actionAdapter implements java.awt.event.ActionListener {
  Frame1 adaptee;

  Frame1_jMenuItem28_actionAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jMenuItem28_actionPerformed(e);
  }
}



class Frame1_jMenuItem13_actionAdapter implements java.awt.event.ActionListener {
  Frame1 adaptee;

  Frame1_jMenuItem13_actionAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jMenuItem13_actionPerformed(e);

  }
}

class Frame1_jMenuItem15_actionAdapter implements java.awt.event.ActionListener {
  Frame1 adaptee;

  Frame1_jMenuItem15_actionAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jMenuItem15_actionPerformed(e);
  }
}

class Frame1_jMenuItem16_actionAdapter implements java.awt.event.ActionListener {
  Frame1 adaptee;

  Frame1_jMenuItem16_actionAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jMenuItem16_actionPerformed(e);
  }
}

class Frame1_jMenuItem17_actionAdapter implements java.awt.event.ActionListener {
  Frame1 adaptee;

  Frame1_jMenuItem17_actionAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jMenuItem17_actionPerformed(e);
  }
}

class Frame1_jMenuItem18_ancestorAdapter implements javax.swing.event.AncestorListener {
  Frame1 adaptee;

  Frame1_jMenuItem18_ancestorAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }
  public void ancestorAdded(AncestorEvent e) {
  }
  public void ancestorRemoved(AncestorEvent e) {
  }
  public void ancestorMoved(AncestorEvent e) {
  }
}

class Frame1_jMenuItem19_ancestorAdapter implements javax.swing.event.AncestorListener {
  Frame1 adaptee;

  Frame1_jMenuItem19_ancestorAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }
  public void ancestorAdded(AncestorEvent e) {
  }
  public void ancestorRemoved(AncestorEvent e) {
  }
  public void ancestorMoved(AncestorEvent e) {
  }
}

class Frame1_jMenuItem19_actionAdapter implements java.awt.event.ActionListener {
  Frame1 adaptee;

  Frame1_jMenuItem19_actionAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jMenuItem19_actionPerformed(e);
  }
}

class Frame1_jMenuItem18_actionAdapter implements java.awt.event.ActionListener {
  Frame1 adaptee;

  Frame1_jMenuItem18_actionAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jMenuItem18_actionPerformed(e);
  }
}

class Frame1_jMenuItem20_actionAdapter implements java.awt.event.ActionListener {
  Frame1 adaptee;

  Frame1_jMenuItem20_actionAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jMenuItem20_actionPerformed(e);
  }
}

class Frame1_jMenuItem21_actionAdapter implements java.awt.event.ActionListener {
  Frame1 adaptee;

  Frame1_jMenuItem21_actionAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jMenuItem21_actionPerformed(e);
  }
}

class Frame1_jMenuItem22_actionAdapter implements java.awt.event.ActionListener {
  Frame1 adaptee;

  Frame1_jMenuItem22_actionAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jMenuItem22_actionPerformed(e);
  }
}

class Frame1_jMenuItem11_actionAdapter implements java.awt.event.ActionListener {
  Frame1 adaptee;

  Frame1_jMenuItem11_actionAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jMenuItem11_actionPerformed(e);
  }
}

class Frame1_jMenuItem23_actionAdapter implements java.awt.event.ActionListener {
  Frame1 adaptee;

  Frame1_jMenuItem23_actionAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jMenuItem23_actionPerformed(e);
  }
}

class Frame1_jMenuItem24_actionAdapter implements java.awt.event.ActionListener {
  Frame1 adaptee;

  Frame1_jMenuItem24_actionAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jMenuItem24_actionPerformed(e);
  }
}

class Frame1_jMenuItem1_actionAdapter implements java.awt.event.ActionListener {
  Frame1 adaptee;

  Frame1_jMenuItem1_actionAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jMenuItem1_actionPerformed(e);
  }
}

class Frame1_jMenuItem6_actionAdapter implements java.awt.event.ActionListener {
  Frame1 adaptee;

  Frame1_jMenuItem6_actionAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jMenuItem6_actionPerformed(e);
  }
}

class Frame1_jMenuItem7_actionAdapter implements java.awt.event.ActionListener {
  Frame1 adaptee;

  Frame1_jMenuItem7_actionAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jMenuItem7_actionPerformed(e);

  }
}

class Frame1_jMenuItem12_actionAdapter implements java.awt.event.ActionListener {
  Frame1 adaptee;

  Frame1_jMenuItem12_actionAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jMenuItem12_actionPerformed(e);
  }
}

class Frame1_jMenuItem8_actionAdapter implements java.awt.event.ActionListener {
  Frame1 adaptee;

  Frame1_jMenuItem8_actionAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jMenuItem8_actionPerformed(e);
  }
}