Examples of javax.jdo.Query.execute()

javax.jdo.Query.execute()
Execute the query and return the filtered Collection. @return the filtered Collection. @see #executeWithArray(Object[] parameters)

      LOG.debug("Executing listMSecurityPrincipalMembershipRole");
      Query query = pm.newQuery(MRoleMap.class,
          "principalName == t1 && principalType == t2");
      query
          .declareParameters("java.lang.String t1, java.lang.String t2");
      mRoleMemebership = (List<MRoleMap>) query.execute(roleName, principalType.toString());
      LOG
          .debug("Done executing query for listMSecurityPrincipalMembershipRole");
      pm.retrieveAll(mRoleMemebership);
      success = commitTransaction();
      LOG

View Full Code Here

    try {
      openTransaction();
      Query query = pm.newQuery(MRole.class, "roleName == t1");
      query.declareParameters("java.lang.String t1");
      query.setUnique(true);
      mrole = (MRole) query.execute(roleName);
      pm.retrieve(mrole);
      commited = commitTransaction();
    } finally {
      if (!commited) {
        rollbackTransaction();

View Full Code Here

      openTransaction();
      name = name.toLowerCase().trim();
      Query query = pm.newQuery(MDatabase.class, "name == dbname");
      query.declareParameters("java.lang.String dbname");
      query.setUnique(true);
      mdb = (MDatabase) query.execute(name);
      pm.retrieve(mdb);
      commited = commitTransaction();
    } finally {
      if (!commited) {
        rollbackTransaction();

View Full Code Here

      query = query + ")";


      Query q = pm.newQuery(query);
      q.setResult("name");
      q.setOrdering("name ascending");
      Collection names = (Collection) q.execute();
      databases = new ArrayList<String>();
      for (Iterator i = names.iterator(); i.hasNext();) {
        databases.add((String) i.next());
      }
      commited = commitTransaction();

View Full Code Here

  public static Player verifyUsernameAndPassword(String nickname, String password) {
    nickname = removeSpaces(nickname);
    PersistenceManager pm = PMF.get().getPersistenceManager();
    Query query = pm.newQuery("SELECT FROM " + Player.class.getName() + " WHERE nickname == " + nickname);
    @SuppressWarnings("unchecked")
    List<Player> attachedPlayers = (List<Player>)query.execute();
    List<Player> players = detachList(pm, attachedPlayers);
    for (Player p : players) {
      if ((p != null) && (p.getPassword() != null) && p.getPassword().equals(password)) return p;
    }
    pm.close();

View Full Code Here

  
  public static void deletePlayer(String userId) {
    PersistenceManager pm = PMF.get().getPersistenceManager();
    try {
      Query query = pm.newQuery("SELECT FROM " + Player.class.getName());
      List<Player> attached = (List<Player>)query.execute();
      if (attached != null) {
        for (Player player : attached) {
          if (player.getUserId().equals(userId)) pm.deletePersistent(player);
        }
      }

View Full Code Here

  @SuppressWarnings("unchecked")
  public static String[] updateScore(String nickname, Long newScore) {
    nickname = removeSpaces(nickname);
    PersistenceManager pm = PMF.get().getPersistenceManager();
    Query query = pm.newQuery("SELECT FROM " + Player.class.getName());
    List<Player> players = (List<Player>)query.execute();
    for (Player player : players) {
      if (player.getNickname().equals(nickname) && player.getHighscore() < newScore) {
        player.setHighscore(newScore);
        pm.makePersistent(player);
        if (player.getFacebookUser().equals("true")) {

View Full Code Here

  @SuppressWarnings("unchecked")
  public static void updateAccessToken(String nickname, String accessToken) {
    nickname = DatastoreHelper.removeSpaces(nickname);
    PersistenceManager pm = PMF.get().getPersistenceManager();
    Query query = pm.newQuery("SELECT FROM " + Player.class.getName());
    List<Player> players = (List<Player>)query.execute();
    for (Player player : players) {
      if (player.getNickname().equals(nickname)) {
        player.setAccessToken(accessToken);
        pm.makePersistent(player);
      }

View Full Code Here


  public static String[] getScores() {
    PersistenceManager pm = PMF.get().getPersistenceManager();
    Query query = pm.newQuery("SELECT FROM " + Player.class.getName() + " ORDER BY highscore DESC");
    @SuppressWarnings("unchecked")
    List<Player> attachedPlayers = (List<Player>)query.execute();
    List<Player> players = detachList(pm, attachedPlayers);
    if (players != null) {  
      String[] result = new String[players.size()];
      for (int i = 0 ; i < result.length ; i++) {
        Player player = players.get(i);

View Full Code Here

    Query query = pm.newQuery("SELECT FROM " + Player.class.getName() + " WHERE nickname == " + name);
    
    logger.fine("executing query :" + query.toString());
    
    @SuppressWarnings("unchecked")
    List<Player> attachedPlayers = (List<Player>)query.execute();
    
    if (attachedPlayers == null) {
      logger.fine("query returned null!");
      return null;
    }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.