Examples of org.apache.commons.dbutils.QueryRunner.query()

Class org.apache.commons.dbutils.QueryRunner

Examples of org.apache.commons.dbutils.QueryRunner.query()

org.apache.commons.dbutils.QueryRunner.query()
Execute an SQL SELECT query with a single replacement parameter. The caller is responsible for connection cleanup. @param conn The connection to execute the query in. @param sql The query to execute. @param param The replacement parameter. @param rsh The handler that converts the results into an object. @return The object returned by the handler. @throws SQLException

    }


    sql += ")";


    try {
      Map recordMap = (Map) queryRunner.query(sql, rsh);


      if (recordMap == null) {
        return;
      }

View Full Code Here

    QueryRunner runner = new QueryRunner(dataSource);
    ResultSetHandler rsh = new MapHandler();
    String sql = "select * from Client where (ClientID=1)";
    Map clientMap = null;
    try {
      clientMap = (Map) runner.query(sql, null, rsh);
    } catch (SQLException se) {
      System.out.println(se.getMessage());
      return;
    }

View Full Code Here

      System.out.println("Field value = " + clientMap.get(fieldName));
    }
    
    clientMap = null;
    try {
      clientMap = (Map) runner.query(sql, null, rsh);
      DataSourceHandler.closeDataSource();
    } catch (ControllerException ce) {
      System.out.println(ce.getMessage());
      return;
    } catch (SQLException se) {

View Full Code Here

      
      if (orderClause != null) {
        sql += " ORDER BY " + orderClause;
      }
      
      return (List) queryRunner.query(conn, sql, rsh);
    } catch (SQLException se) {
      log.warning("GenericController SQLException: " + se.getMessage());
      throw new ControllerException(se);
    }
  }

View Full Code Here

      
      if (whereClause != null) {
        sql += " WHERE " + whereClause;
      }
      
      List mapList = (List) queryRunner.query(conn, sql, rsh);
      if (mapList.size() == 0l) {
        throw new FinderException();
      }
      
      Iterator iterator = mapList.iterator();

View Full Code Here

    String sql = null;


    try {
      sql = "select * from " + tableName;
      sql += " where (" + primaryKeyName + "=?)";
      Map columnMapTemp = (Map) queryRunner.query(conn, sql, columnMap.get(primaryKeyName), rsh);


      if (columnMapTemp == null) {
        throw new ControllerException("Cannot find record.");
      }

View Full Code Here

      sql += " where (";
      sql += " (contact_detail.contact_type_id=contact_type.contact_type_id)";
      sql += " and (client_id = ?)";
      sql += " ) ORDER BY contact_type";


      return (List) queryRunner.query(sql, new Integer(clientID), rsh);
    } catch (SQLException se) {
      String message = "SpecificController: SQL Exception: " + se.getMessage();
      log.warning(message);
      throw new ControllerException(se);  // wrap SQLException
    }

View Full Code Here

        sql += " where (";
        sql += " (contact_detail.client_id=" + clientID + ")";
        sql += " and (contact_type.is_default=true)";
        sql += " )";


        return (Map) queryRunner.query(sql, rsh);
      } catch (SQLException se) {
        String msg = "SQL error:\n" + se.getMessage();
        log.warning(msg);
        throw new ControllerException(msg);
      }

View Full Code Here

      sql += " where (";
      sql += " (payment.tender_id=tender.tender_id)";
      sql += " and (invoice_id = ?)";
      sql += " ) ORDER BY payment_date DESC";


      return (List) queryRunner.query(sql, new Integer(invoiceID), rsh);
    } catch (SQLException se) {
      String message = "SpecificController: SQL Exception: " + se.getMessage();
      log.warning(message);
      throw new ControllerException(se);  // wrap SQLException
    }

View Full Code Here

      sql = "select * from invoice";
      sql += " where (";
      sql += " (client_id = ?)";
      sql += " ) ORDER BY invoice_date DESC";
  
      List invoiceList = (List) queryRunner.query(sql, new Integer(clientID), mapListRsh);
      Iterator iterator = invoiceList.iterator();
      Map invoiceMap = null;
      Map paymentMap = null;
      BigDecimal balanceDue = null;
      BigDecimal paymentAmount = null;

View Full Code Here

0 1 2 3 4 5 6 7 8

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.