Examples of MapListHandler

com.bleujin.framework.db.bean.handlers.MapListHandler

Title:

Description:

Copyright: Copyright (c) 2003

Company: I-ON Communications
@author bleujin @version 1.0
org.apache.commons.dbutils.handlers.MapListHandler
ResultSetHandler implementation that converts a ResultSet into a List of Maps. This class is thread safe. @see ResultSetHandler @author David Graham

Examples of com.bleujin.framework.db.bean.handlers.MapListHandler

  
  
  public void testMapList() throws Exception {
    Rows rows = dc.getRows(query, 10, 1) ;
    
    List<Map> results = (List<Map>)rows.toHandle(new MapListHandler()) ;
    
    assertEquals(10, results.size()) ;
    Map row = results.get(0);
    
    assertEquals("1", row.get("no1").toString()) ;

View Full Code Here

Examples of org.apache.commons.dbutils.handlers.MapListHandler

   *
   */
  public static void loadParameters() {


      QueryRunner queryRunner = new QueryRunner(DataSourceHandler.getDataSource());
      ResultSetHandler rsh = new MapListHandler();
      String sql = "select * from parameter";
      
      try {
        parameterMap = (Map) queryRunner.query(sql, rsh);
      } catch (SQLException se) {

View Full Code Here

Examples of org.apache.commons.dbutils.handlers.MapListHandler

    String orderClause,
    String whereClause)
    throws ControllerException {


    QueryRunner queryRunner = new QueryRunner(dataSource);
    ResultSetHandler rsh = new MapListHandler();
    String sql = null;


    try {
      sql = "SELECT * FROM " + tableName;

View Full Code Here

Examples of org.apache.commons.dbutils.handlers.MapListHandler

   */
  public List findAllWhere(String tableName, String orderClause, String whereClause) 
  throws ControllerException  {


    QueryRunner queryRunner = new QueryRunner();
    ResultSetHandler rsh = new MapListHandler();
    String sql = null;


    try {
      sql = "SELECT * FROM " + tableName;

View Full Code Here

Examples of org.apache.commons.dbutils.handlers.MapListHandler

   */
  public Map findWhere(String tableName, String whereClause) 
  throws ControllerException, FinderException  {


    QueryRunner queryRunner = new QueryRunner();
    ResultSetHandler rsh = new MapListHandler();
    String sql = null;


    try {
      sql = "SELECT * FROM " + tableName;

View Full Code Here

Examples of org.apache.commons.dbutils.handlers.MapListHandler

    throws ControllerException  {
    
    List resultList = new ArrayList();
    Map titleMap;
    QueryRunner queryRunner = new QueryRunner(dataSource);
    ResultSetHandler rsh = new MapListHandler();
    String sql = null;


    try {
      sql = "select * from contact_detail, contact_type";
      sql += " where (";

View Full Code Here

Examples of org.apache.commons.dbutils.handlers.MapListHandler

   */
  public List findPayments(int invoiceID) 
    throws ControllerException  {
    
    QueryRunner queryRunner = new QueryRunner(dataSource);
    ResultSetHandler rsh = new MapListHandler();
    String sql = null;


    try {
      // Get connection from the connection pool
      sql = "select * from payment, tender";

View Full Code Here

Examples of org.apache.commons.dbutils.handlers.MapListHandler

   */
  public List findInvoices(int clientID) 
      throws ControllerException  {
    
    QueryRunner queryRunner = new QueryRunner(dataSource);
    ResultSetHandler mapListRsh = new MapListHandler();
    ResultSetHandler mapRsh = new MapHandler();
    String sql = null;
  
    try {
      // Get connection from the connection pool

View Full Code Here

Examples of org.apache.commons.dbutils.handlers.MapListHandler

    throws ControllerException  {
    
    List resultList = new ArrayList();
    Map roleMap;
    QueryRunner queryRunner = new QueryRunner(dataSource);
    ResultSetHandler rsh = new MapListHandler();
    String sql = null;


    try {
      // Get connection from the connection pool
      sql = "select * from person_role, role";

View Full Code Here

Examples of org.apache.commons.dbutils.handlers.MapListHandler

    DataSourceHandler.setPassword(passWordInPlainText);
    DataSource dataSource = DataSourceHandler.getDataSource();
    
    QueryRunner queryRunner = new QueryRunner(dataSource);
    ResultSetHandler rshMap = new MapHandler();
    ResultSetHandler rshList = new MapListHandler();


    try {
      String sql =
        "select * from person" + " where (" + " (user_name=?)" + " )";
      personMap = (Map) queryRunner.query(sql, userName, rshMap);

View Full Code Here

0 1

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.