Example usage for org.apache.commons.dbutils.handlers MapListHandler MapListHandler

Introduction

In this page you can find the example usage for org.apache.commons.dbutils.handlers MapListHandler MapListHandler.

Prototype

public MapListHandler() 

Source Link

Document

Creates a new instance of MapListHandler using a BasicRowProcessor for conversion.

Usage

From source file:DbUtilsUseMapMySQL.java

public static void main(String[] args) {
    Connection conn = null;/*w  w w .j a va2s  . c o  m*/
    String jdbcURL = "jdbc:mysql://localhost/octopus";
    String jdbcDriver = "com.mysql.jdbc.Driver";
    String user = "root";
    String password = "root";

    try {
        DbUtils.loadDriver(jdbcDriver);
        conn = DriverManager.getConnection(jdbcURL, user, password);

        QueryRunner qRunner = new QueryRunner();

        List mapList = (List) qRunner.query(conn, "select id, name from animals_table", new MapListHandler());

        for (int i = 0; i < mapList.size(); i++) {
            Map map = (Map) mapList.get(i);
            System.out.println("id=" + map.get("id"));
            System.out.println("name=" + map.get("name"));
            System.out.println("-----------------");
        }

        System.out.println("DbUtils_UseMap_MySQL: end.");

    } catch (SQLException e) {
        // handle the exception
        e.printStackTrace();
    } finally {
        DbUtils.closeQuietly(conn);
    }
}

---

From source file:com.mum.edu.cs472.DbConnection.java

public static String resultSetToJson(String word) {
    try {// w  ww.j  a  va  2s .co m
        //            Thread.sleep(8000);
    } catch (Exception e) {
    }
    Connection connection = getConnection();
    List<Map<String, Object>> listOfMaps = null;
    String query = "SELECT * FROM entries where lower(word)=Lower(?);";
    try {
        QueryRunner queryRunner = new QueryRunner();

        listOfMaps = queryRunner.query(connection, query, word, new MapListHandler());
    } catch (SQLException se) {
        throw new RuntimeException("Couldn't query the database.", se);
    } finally {
        DbUtils.closeQuietly(connection);
    }
    return new Gson().toJson(listOfMaps);
}

---

From source file:TilesMatchingCriteriaQueryCallable.java

public Tile[] call() throws Exception {

    CSLogger.sharedLogger().fine("Running query for tiles matching criteria (\"" + this.sql + "\")");

    // Run query//w  w w . j  av a2 s  .c  om
    List results = (List) (new QueryRunner().query(connection, "SELECT * FROM tiles WHERE " + this.sql + ";",
            new MapListHandler()));

    // Parse & return results
    Tile[] tiles = new Tile[results.size()];
    for (int i = 0; i < results.size(); i++) {
        tiles[i] = new Tile((HashMap) results.get(i));
    }
    return tiles;
}

---

From source file:com.ruihu.easyshop.category.dao.CategoryDao.java

/**
 * return all category/*from  w w  w .jav a2  s .c  om*/
 */

public List<Category> findAll() throws SQLException {
    String sql = "select * from t_category where pid is null";
    List<Map<String, Object>> mapList = qr.query(sql, new MapListHandler());
    List<Category> parents = toCategoryList(mapList);

    for (Category parent : parents) {
        List<Category> children = findByParent(parent.getCid());
        parent.setChildren(children);

    }

    return parents;
}

---

From source file:com.ruihu.easyshop.cart.dao.CartItemDao.java

public List<CartItem> loadCartItems(String cartItemIds) throws SQLException {

    Object[] cartItemIdArray = cartItemIds.split(",");

    String whereSql = toWhereSql(cartItemIdArray.length);

    String sql = "select * from t_cartitem c, t_book b where c.bid=b.bid and " + whereSql;

    return toCartItemList(qr.query(sql, new MapListHandler(), cartItemIdArray));
}

---

From source file:com.ruihu.easyshop.category.dao.CategoryDao.java

/**
 * search secondary category//from ww w  .j av a 2  s  . co m
 * @param pid
 * @return 
 */
public List<Category> findByParent(String pid) throws SQLException {
    String sql = "select * from t_category where pid=?";
    List<Map<String, Object>> mapList = qr.query(sql, new MapListHandler(), pid);
    return toCategoryList(mapList);
}

---

From source file:com.aw.core.dao.AWQueryRunner.java

public List findListOfMaps(Connection con, String sql, Object[] filterKeys) {
    try {/*w ww  .  j a  v a2s .c o m*/
        if (logger.isDebugEnabled())
            logger.debug("Executing:" + buildSQLLog(sql, filterKeys));
        return (List) super.query(con, sql, filterKeys, new MapListHandler());
    } catch (SQLException e) {
        throw AWBusinessException.wrapUnhandledException(logger, e);
    }
}

---

From source file:connectKiosk.Query.java

public void getUsers(Connect conn) {

    query = "Select * FROM users;";

    List result = null;// w  w  w . j a v a  2  s .  c o  m

    try {
        QueryRunner runner = new QueryRunner();
        result = (List) runner.query(conn.returnConn(), query, new MapListHandler());
    } catch (Exception e) {
        e.printStackTrace();
    }

    for (int i = 0; i < result.size(); i++) {
        result = (List) result.get(i);
        System.out.println(result);
    }
}

---

From source file:com.gs.obevo.dbmetadata.impl.dialects.HsqlMetadataDialect.java

@Override
public ImmutableCollection<DaUserType> searchUserTypes(final DaSchema schema, Connection conn)
        throws SQLException {
    QueryRunner query = new QueryRunner();

    ImmutableList<Map<String, Object>> maps = ListAdapter.adapt(query.query(conn,
            "select dom.DOMAIN_NAME AS USER_TYPE_NAME\n" + "from INFORMATION_SCHEMA.DOMAINS dom\n"
                    + "WHERE dom.DOMAIN_SCHEMA = ucase('" + schema.getName() + "')\n",
            new MapListHandler())).toImmutable();

    return maps.collect(new Function<Map<String, Object>, DaUserType>() {
        @Override/*  www  .j  ava2  s.co  m*/
        public DaUserType valueOf(Map<String, Object> map) {
            return new DaUserTypeImpl((String) map.get("USER_TYPE_NAME"), schema);
        }
    });
}

---

From source file:com.odap.server.audit.ConfigHandler.java

public ConfigMessage registerNewServer(ConfigMessage config) throws TException {
    logger.info("Enter registerNewServer()");
    ConfigMessage msg = new ConfigMessage();

    QueryRunner qRunner = new QueryRunner();

    Integer account_id = null;//from w w  w. j  a  v  a 2  s .  c  o m
    Integer server_id = null;
    //Authenticate the user and get the account_id;
    String query = "SELECT * FROM joomla.cloud_users WHERE username = ? AND password = ?";
    {
        String parameters[] = { config.getUsername().replaceAll("[^A-Za-z0-9 ]", ""),
                DigestUtils.md5Hex(config.getPassword().replaceAll("[^A-Za-z0-9 ]", "")) };
        try {
            List<Map<String, Object>> mapList = (List<Map<String, Object>>) qRunner
                    .query(AuditServer.connectionPool.getConnection(), query, new MapListHandler(), parameters);

            if (mapList.size() < 1) {
                logger.warn("Username " + config.getUsername() + " not authenticated");
                return msg;
            }

            account_id = (Integer) mapList.get(0).get("account_id");

        } catch (SQLException e) {
            logger.error("Issue finding user account", e);
            return msg;
        }
    }

    String session_id = nextSessionId();
    {
        try {
            {
                query = "INSERT INTO servers (account_id,server_name,server_software,server_port,server_authentication_token,server_timezone,strip_predicates) VALUES (?,?,?,?,?,?,?)";
                Object parameters[] = { account_id.toString(),
                        config.getServer_name().replaceAll("[^A-Za-z0-9 ]", ""), config.getServer_software(),
                        new Short(config.getPort()), session_id, new Double(config.getTimezone_offset()),
                        config.strip_predicates };
                qRunner.update(AuditServer.connectionPool.getConnection(), query, parameters);
            }
            {
                String parameters[] = { account_id.toString(), config.getServer_name(), session_id };
                query = "SELECT * FROM servers WHERE account_id = ? AND server_name = ? and server_authentication_token = ?";
                List<Map<String, Object>> mapList = (List<Map<String, Object>>) qRunner.query(
                        AuditServer.connectionPool.getConnection(), query, new MapListHandler(), parameters);

                if (mapList.size() < 1) {
                    logger.error("Unable to find server after after registering it");
                    return msg;
                }

                server_id = (Integer) mapList.get(0).get("id");
            }
        } catch (SQLException e) {
            logger.error("Issue registering server", e);
        }
    }

    msg.token = session_id;
    msg.server_id = server_id.shortValue();
    msg.server = "dbauditcloud.com";
    logger.info("Exiting registerNewServer()");
    return msg;
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• »