frame1.java~107~

会议名片管理程序 3/9条形码生成

          }
          //---------电子邮件
          if ( ! emailField.getText().equals( "@" ) )
          {
            if ( record != true )
            {
              query += " where Email LIKE '%"+emailField.getText()+"%' ";
              record = true;
            }
            else
              query += " and Email LIKE '%"+emailField.getText()+"%' ";
          }
          //---------邮政编码
          if( ! postcodeField.getText().equals("") )
          {
            if( record !=true )
            {
              query += " where Postcode LIKE '%"+postcodeField.getText()+"%' ";
              record = true;
            }
            else
              query += " and Postcode LIKE '%"+postcodeField.getText()+"%' ";
          }
          //----------部门
          if( ! departField.getText().equals("") )
          {
            if( record !=true )
            {
              query += " where Department LIKE '%"+departField.getText()+"%' ";
              record = true;
            }
            else
              query += " and Department LIKE '%"+departField.getText()+"%' ";
          }
          //----------寻呼机
          if( ! callField.getText().equals("") )
          {
            if( record !=true )
            {
              query += " where Call LIKE '%"+callField.getText()+"%' ";
              record = true;
            }
            else
              query += " and Call LIKE '%"+callField.getText()+"%' ";
          }
          //---------网址
          if( ! webaddressField.getText().equals("http://") )
          {
           if( record !=true )
           {
             query += " where WebPage LIKE '%"+webaddressField.getText()+"%' ";
             record = true;
           }
           else
             query += " and WebPage LIKE '%"+webaddressField.getText()+"%' ";
          }
          //------地址
          if( ! addressArea.getText().equals("http://") )
          {
           if( record !=true )
           {
             query += " where Address LIKE '%"+addressArea.getText()+"%' ";
             record = true;
           }
           else
             query += " and Address LIKE '%"+addressArea.getText()+"%' ";
          }
      }
      resultSet = statement.executeQuery ( query );

      int i=0;
      while(resultSet.next())
      {
         InitString[i]=resultSet.getString("SN")+" "+resultSet.getString("name");
         i++;
      }
      Object[][] addObject= new Object[1000][1];
      int size=model.getRowCount();
      while(size>0)
      {
         model.removeRow(size-1);
         size--;
      }
     if(i==0)
         JOptionPane.showMessageDialog(null, "对不起!没有任何记录!", "提示", JOptionPane.WARNING_MESSAGE);
     else
         for(int j=0;j<i;j++)
         {
           addObject[j][0]=InitString[j];
           model.insertRow(j,addObject[j]);
          }
     JOptionPane.showMessageDialog(null, "符合条件人数为:"+"\n     "+i,
                                    "汇总", JOptionPane.WARNING_MESSAGE);
      statement.close ( );// 关闭数据库的连接
    }
    catch ( SQLException sqlex )
    {
      sqlex.printStackTrace ( );
    }
  }

  //view || 取得参展人数
  public void jMenuViewSumofRecord_actionPerformed(ActionEvent e)
  {
    try
    {
      statement = connect.createStatement();
      String query = "select * from totaldb";
      resultSet = statement.executeQuery(query);
      int sumofRecord=0;
      while(resultSet.next())
      {
        sumofRecord++;
      }
      JOptionPane.showMessageDialog(null, "参加人数为:"+"\n     "+sumofRecord,
                                    "参加人数", JOptionPane.WARNING_MESSAGE);
     statement.close();	// 关闭数据库的连接
    }
    catch ( SQLException sqlex )
    {
      sqlex.printStackTrace ( );
    }
  }
  //function || 添加一项新纪录
  public void jMenuNewItem_actionPerformed(ActionEvent e)
  {
    String defaultSN= new String();
    String ExistedMaxSN = new String();
    long n;
    try
    {
      statement = connect.createStatement();
      defaultSN="3102104000001";
      if (! nameField.getText().equals( "" )&&
                ! positionField.getText().equals( "" )&&
                ! companyField.getText().equals( "" ))
     {
        String query = "select MAX(SN) from totaldb ";
        resultSet = statement.executeQuery(query);
        while(resultSet.next())
        {
          ExistedMaxSN=resultSet.getString("MAX(SN)");//.getString("SN");
        }
        System.out.println(ExistedMaxSN);
        if(ExistedMaxSN!=null)
        {
          n=Long.parseLong(ExistedMaxSN);
          n++;
        }
        else
          n=Long.parseLong(defaultSN);

        String SN = String.valueOf(n);
        numberField.setText(SN);
        query="INSERT into totaldb(SN,name,company,position)"+
            "values("+"'"+SN+"','"+nameField.getText()+"','"+
            companyField.getText()+"','"+positionField.getText()+"')";
        System.out.println(query);
        statement.executeUpdate(query);
        String stringTable=SN+" "+nameField.getText();
        Object[][] addObject= new Object[1][1];
        addObject[0][0]=stringTable;
        model.addRow(addObject[0]);
        jLabelName1.setText(nameField.getText());
        jLabelCompany1.setText(companyField.getText());
        jLabelPosition1.setText(positionField.getText());
        JOptionPane.showMessageDialog(null, "成功添加一个记录!", "提示", JOptionPane.WARNING_MESSAGE);

        TableItemUpdate();

        code39Bar.setCode39(SN);

        statement.close();
        resultSet.close();
     }
     else
     {
       JOptionPane.showMessageDialog ( null , "个人序号是唯一的，姓名、单位和职位是必须的",
                                "提示",JOptionPane.INFORMATION_MESSAGE );
     }
    }
    catch ( SQLException sqlex )
    {
      sqlex.printStackTrace ( );
    }
  }
  //Function || 删除一项记录
  public void jMenuDelete_actionPerformed(ActionEvent e)
  {
    int option = 0;
    option = JOptionPane.showOptionDialog( null ,
        "确定删除么？","警告",
        JOptionPane.YES_NO_OPTION,
        JOptionPane.WARNING_MESSAGE,null,null,null );
    if ( option == JOptionPane.YES_OPTION )
    {
    try
    {
      statement = connect.createStatement();
      String query="delete from totaldb where SN='"+numberField.getText()+"'";
      String stringTable=numberField.getText()+" "+nameField.getText();
      statement.executeUpdate(query);

      Object[][] addObject= new Object[1][1];
      addObject[0][0]=stringTable;
      int i=model.getRowCount();
      int j=0;
      while(j<i)
      {
        if(model.getValueAt(j,0)==addObject[0][0])
          model.removeRow(j);
        j++;
      }
      TableItemUpdate();

      nameField.setText("");
      companyField.setText("");
      positionField.setText("");
      emailField.setText("");
      officephoneField.setText("");
      mobileField.setText("");
      callField.setText("");
      faxField.setText("");
      webaddressField.setText("");
      jComboBoxSort.setSelectedItem("");
      numberField.setText("");
      departField.setText("");
      postcodeField.setText("");
      addressArea.setText("");
      jLabelName1.setText("");
      jLabelCompany1.setText("");
      jLabelPosition1.setText("");

      code39Bar.setCode39(defaultSN);

      JOptionPane.showMessageDialog(null, "成功删除一个记录!", "提示", JOptionPane.WARNING_MESSAGE);

      statement.close ( );
    }
    catch( SQLException sqlex )
    {
      sqlex.printStackTrace ( );
    }
    }
  }
  //Function || 更新一项记录
  public void jMenuUpdate_actionPerformed(ActionEvent e)
  {
    try
    {
      statement = connect.createStatement();
      String query="UPDATE totaldb set Name='"+nameField.getText()
                   +"',Company='"+companyField.getText()
                   +"',position='"+positionField.getText()
                   +"',email='"+emailField.getText()
                   +"',call='"+callField.getText()
                   +"',phone='"+officephoneField.getText()
                   +"',department='"+departField.getText()
                   +"',webpage='"+webaddressField.getText()
                   +"',sort='"+jComboBoxSort.getSelectedItem()
                   +"',mobile='"+mobileField.getText()
                   +"',fax='"+faxField.getText()
                   +"',postcode='"+postcodeField.getText()
                   +"',address='"+addressArea.getText()
                   +"' where  SN='"+numberField.getText()
                   +"'";
      System.out.println(query);
      statement.executeUpdate(query);
      JOptionPane.showMessageDialog(null, "成功更新一个记录!", "提示", JOptionPane.WARNING_MESSAGE);

      TableItemUpdate();

      statement.close ( );
    }
    catch ( SQLException sqlex )
    {
      sqlex.printStackTrace ( );
    }
  }
  //Function || reset
  public void jMenuReset_actionPerformed(ActionEvent e)
  {
    if(!(nameField.getText().equals("") && companyField.getText().equals("")&&
       positionField.getText().equals("") && officephoneField.getText().equals("")&&
       emailField.getText().equals("") && postcodeField.getText().equals("")&&
       jComboBoxSort.getSelectedItem().equals("") && numberField.getText().equals("")&&
       webaddressField.getText().equals("") &&callField.getText().equals("")&&
       departField.getText().equals("") && faxField.getText().equals("")&&
       mobileField.getText().equals("") && addressArea.getText().equals("")))
    {
      nameField.setText("");
      companyField.setText("");
      positionField.setText("");
      emailField.setText("");
      officephoneField.setText("");
      mobileField.setText("");
      callField.setText("");
      faxField.setText("");
      webaddressField.setText("");
      jComboBoxSort.setSelectedItem("");
      numberField.setText("");
      departField.setText("");
      postcodeField.setText("");
      addressArea.setText("");
      jLabelName1.setText("");
      jLabelCompany1.setText("");
      jLabelPosition1.setText("");
      code39Bar.setCode39(defaultSN);
    }
  }
  //Advanced Function
  public void jMenuPswdSetAd_actionPerformed(ActionEvent e)
  {
    String choices[] = new String[] {"确定","取消"};
    String input2 = "请再输入密码：";
    JPasswordField pswd2 = new JPasswordField(15);	// 密码框
    pswd2.setEchoChar('*');	// 密码框掩码
    String input1 = "请再输入密码：";
    JPasswordField pswd1 = new JPasswordField(15);	// 密码框
    pswd1.setEchoChar('*');	// 密码框掩码
    Object msgs[] = new Object[] {input1,pswd1,input2,pswd2};
    int password = 0;
    password = JOptionPane.showOptionDialog(null,msgs,"修改高级功能权限密码",
        JOptionPane.OK_CANCEL_OPTION,JOptionPane.QUESTION_MESSAGE,null,
        choices,choices[0]);
    if(password==JOptionPane.OK_OPTION)
   {
     if (pswd1.getText().compareToIgnoreCase(pswd2.getText())==0)
     {
       pswdDefaultAd=pswd1.getPassword().toString();
       JOptionPane.showMessageDialog(null, "密码修改成功!", "提示", JOptionPane.WARNING_MESSAGE);
     }
     else
       JOptionPane.showMessageDialog(null, "两次输入密码不一致,请重新设定!", "提示", JOptionPane.WARNING_MESSAGE);
    }
  }
  public void jMenuPswdGetAd_actionPerformed(ActionEvent e)
  {
    //--------密码对话框
   int password1 = 0;
   String choices[] = new String[] {"确定","取消"};
   String input = "请输入密码：";
   JPasswordField pwd = new JPasswordField(15);
   pwd.setEchoChar('*');
   Objec