frame1.java~183~

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

            {
              query += " where Position LIKE '%"+positionField.getText()+"%' ";
              record = true;
            }
            else
              query += " and Position LIKE '%"+positionField.getText()+"%' ";
          }
          //---------办公室电话
          if ( ! officephoneField.getText().equals( "" ) )
          {
            if ( record != true )
            {
              query += " where Phone LIKE '%"+officephoneField.getText()+"%' ";
              record = true;
            }
            else
              query += " and Phone LIKE '%"+officephoneField.getText()+"%' ";
          }
          //---------手机
          if ( ! mobileField.getText().equals( "13" ) )
          {
            if ( record != true )
            {
              query += " where Mobile LIKE '%"+mobileField.getText()+"%' ";
              record = true;
            }
            else
              query += " and Mobile LIKE '%"+mobileField.getText()+"%' ";
          }
          //---------传真
          if ( ! faxField.getText().equals( "" ) )
          {
            if ( record != true )
            {
              query += " where Fax LIKE '%"+faxField.getText()+"%' ";
              record = true;
            }
            else
              query += " and Fax LIKE '%"+faxField.getText()+"%' ";
          }
          //---------电子邮件
          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()+"%' ";
          }
      }
      else
      {
        query = "SELECT * FROM totaldb";
         //-----------编号
         if ( ! numberField.getText().equals( "" ) )
         {
           if ( record != true )
           {
             query += " where SN LIKE '%"+numberField.getText()+"%' ";
             record = true;
           }
         }
       //----------姓名
         if ( ! nameField.getText().equals( "" ) )
         {
           if ( record != true )
           {
             query += " where Name LIKE '%"+nameField.getText()+"%' ";
             record = true;
           }
           else
             query += " or Name LIKE '%"+nameField.getText()+"%' ";
         }
         //---------单位
         if ( ! companyField.getText().equals( "" ) )
         {
           if ( record != true )
           {
             query += " where Company LIKE '%"+companyField.getText()+"%' ";
             record = true;
           }
           else
             query += " or Company LIKE '%"+companyField.getText()+"%' ";
         }
         //---------职位
         if ( ! positionField.getText().equals( "" ) )
         {
           if ( record != true )
           {
             query += " where Position LIKE '%"+positionField.getText()+"%' ";
             record = true;
           }
           else
             query += " or Position LIKE '%"+positionField.getText()+"%' ";
         }
         //---------办公室电话
         if ( ! officephoneField.getText().equals( "" ) )
         {
           if ( record != true )
           {
             query += " where Phone LIKE '%"+officephoneField.getText()+"%' ";
             record = true;
           }
           else
             query += " and Phone LIKE '%"+officephoneField.getText()+"%' ";
         }
         //---------手机
         if ( ! mobileField.getText().equals( "13" ) )
         {
           if ( record != true )
           {
             query += " where Mobile LIKE '%"+mobileField.getText()+"%' ";
             record = true;
           }
           else
             query += " or Mobile LIKE '%"+mobileField.getText()+"%' ";
         }
         //---------传真
         if ( ! faxField.getText().equals( "" ) )
         {
           if ( record != true )
           {
             query += " where Fax LIKE '%"+faxField.getText()+"%' ";
             record = true;
           }
           else
             query += " or Fax LIKE '%"+faxField.getText()+"%' ";
         }
         //---------电子邮件
         if ( ! emailField.getText().equals( "@" ) )
         {
           if ( record != true )
           {
             query += " where Email LIKE '%"+emailField.getText()+"%' ";
             record = true;
           }
           else
             query += " or Email LIKE '%"+emailField.getText()+"%' ";
         }
         //---------邮政编码
         if( ! postcodeField.getText().equals("") )
         {
           if( record !=true )
           {
             query += " where Postcode LIKE '%"+postcodeField.getText()+"%' ";
             record = true;
           }
           else
             query += " or Postcode LIKE '%"+postcodeField.getText()+"%' ";
         }
         //----------部门
         if( ! departField.getText().equals("") )
         {
           if( record !=true )
           {
             query += " where Department LIKE '%"+departField.getText()+"%' ";
             record = true;
           }
           else
             query += " or Department LIKE '%"+departField.getText()+"%' ";
         }
         //----------寻呼机
         if( ! callField.getText().equals("") )
         {
           if( record !=true )
           {
             query += " where Call LIKE '%"+callField.getText()+"%' ";
             record = true;
           }
           else
             query += " or Call LIKE '%"+callField.getText()+"%' ";
         }
         //---------网址
         if( ! webaddressField.getText().equals("http://") )
         {
          if( record !=true )
          {
            query += " where WebPage LIKE '%"+webaddressField.getText()+"%' ";
            record = true;
          }
          else
            query += " or WebPage LIKE '%"+webaddressField.getText()+"%' ";
         }
         //------地址
         if( ! addressArea.getText().equals("http://") )
         {
          if( record !=true )
          {
            query += " where Address LIKE '%"+addressArea.getText()+"%' ";
            record = true;
          }
          else
            query += " or 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]);