Examples of util.SQLHelper.retrieve()

util.SQLHelper.retrieve()
Execute query and retrieve results. Note, this should only be used for internal and sanitized parameters. Else use the version that takes parameters as a separate argument to prevent SQL injection attacks. @param query The query to execute. @return The retrieved result set. May be null. @see SQLHelper#retrieve(String query,Object[] params)

    };


    try {
      sql = new SQLHelper();
      sql.openDB();
      return sql.retrieve(CHECK_CRED_QUERY, params).next();


    } finally {
      sql.closeDB();
    }
  }

View Full Code Here

      query = "select m.id mote_id, m.site_id site_id,s.sitename site, " +
        "case when m.curr_session_id=? then 'controlled' " +
              "when isnull(m.curr_session_id) then 'available' else 'occupied' end mote_usage ";


      select = "select id, name from moteattrtype order by sortseq";
      rs = sql.retrieve(select);
      while (rs.next()) {
        query+=getMoteAttrSubquery(rs.getString("name"),rs.getString("id"));
      }
      select = "select id, name from siteattrtype order by sortseq";
      rs = sql.retrieve(select);

View Full Code Here

      rs = sql.retrieve(select);
      while (rs.next()) {
        query+=getMoteAttrSubquery(rs.getString("name"),rs.getString("id"));
      }
      select = "select id, name from siteattrtype order by sortseq";
      rs = sql.retrieve(select);
      while (rs.next()) {
        query+=getSiteAttrSubquery(rs.getString("name"),rs.getString("id"));
      }
      query+=" from mote m, site s " +
             " where s.id=m.site_id";

View Full Code Here

      while (rs.next()) {
        query+=getSiteAttrSubquery(rs.getString("name"),rs.getString("id"));
      }
      query+=" from mote m, site s " +
             " where s.id=m.site_id";
      rs = sql.retrieve(query, param);
      rs.last();
      int rows = rs.getRow();
      int cols = rs.getMetaData().getColumnCount();
      result = new SimpleTable(rows,cols);
      rs.beforeFirst();

View Full Code Here

    try {
      sql = new SQLHelper();
      sql.openDB();


      /* Check for current privileged session. */
      ResultSet sqlres = sql.retrieve(PRIV_QUERY, priv_params);
      if (sqlres.next()) {
        String privsess = sqlres.getString("priv_session_id");


        access = checkMoteAccess(session_id, privsess, mote_id);
      }

View Full Code Here

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.