コード例 #1
0
  public boolean insertWord(String word, String labels) throws SQLException {

    // treat null case
    //
    if (word == null) return false;

    // perform a stemming
    //
    String stemmedWord = Stemmer.stem(word);

    // check if word exists, by performing a load operation
    //
    if (loadWord(stemmedWord) != null) {

      // word exists
      //
      return false;
    } else {

      // word doesn't exist
      //
      String query = "insert into Word(content,labels) values(?,?)";
      PreparedStatement statement = connection.prepareStatement(query);
      statement.setString(1, stemmedWord);
      statement.setString(2, labels);

      statement.execute();
      statement.close();

      return true;
    }
  }
コード例 #2
0
  // perform a 'bulk' insert of words (at least the ones
  // not found in database)
  //
  public void insertWords(String[] words) throws SQLException {

    // treat null case
    //
    if (words == null) return;

    String query = "insert into Word(content) values(?)";
    PreparedStatement statement = connection.prepareStatement(query);

    for (String w : words) {

      // check if word exists, by performing a load operation
      //
      if (loadWord(w) != null) {
        continue;
      } else {

        // perform a stemming
        //
        String stemmedWord = Stemmer.stem(w);

        statement.setString(1, stemmedWord);
        statement.execute();
      }
    }

    statement.close();
  }
コード例 #3
0
  public Word loadWord(String word) throws SQLException {

    // thread null case
    //
    if (word == null) return null;

    // perform a stemming
    //
    String stemmedWord = Stemmer.stem(word);

    // now prepare the stement
    //
    String query = "select * from Word where content like ?";
    PreparedStatement statement = connection.prepareStatement(query);
    statement.setString(1, stemmedWord);

    ResultSet set = statement.executeQuery();
    if (!set.next()) {

      set.close();
      statement.close();

      // no word was found
      //
      return null;
    } else {

      // load the word, then close the resources used
      //

      Word w = new Word();
      w.setId(set.getInt(1));
      w.setContent(set.getString(2));
      w.setLanguage(null);

      set.close();
      statement.close();

      return w;
    }
  }