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:com.gs.obevo.dbmetadata.impl.dialects.PostgresqlMetadataDialect.java

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

    // SEQTYPE <> 'I' is for identity columns; we don't want that when pulling user defined sequences
    ImmutableList<Map<String, Object>> maps = ListAdapter.adapt(query.query(conn,
            "select sequence_name as sequence_name\n"
                    + "from information_schema.sequences where sequence_schema = '" + schema.getName() + "'\n",
            new MapListHandler())).toImmutable();

    return maps.collect(new Function<Map<String, Object>, DaSequence>() {
        @Override/*w w  w. j  ava 2s.c  o m*/
        public DaSequence valueOf(Map<String, Object> map) {
            return new DaSequenceImpl((String) map.get("sequence_name"), schema);
        }
    });
}

---

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

@Override
public ImmutableCollection<DaPackage> searchPackages(final DaSchema schema, String procedureName,
        Connection conn) throws SQLException {
    String procedureClause = procedureName == null ? "" : " AND OBJECT_NAME = '" + procedureName + "'";
    final String sql = "SELECT OBJECT_NAME, OBJECT_TYPE FROM ALL_OBJECTS\n"
            + "WHERE OBJECT_TYPE IN ('PACKAGE')\n" + "AND OWNER = '" + schema.getName() + "'\n"
            + procedureClause;//from   ww w  .jav  a2 s .  c om
    LOG.debug("Executing package metadata query SQL: {}", sql);

    ImmutableList<Map<String, Object>> maps = ListAdapter.adapt(jdbc.query(conn, sql, new MapListHandler()))
            .toImmutable();

    if (LOG.isDebugEnabled()) {
        LOG.debug("Results:");
        for (Map<String, Object> map : maps) {
            LOG.debug("ROW: {}", map.toString());
        }
    }

    return maps.collect(new Function<Map<String, Object>, DaPackage>() {
        @Override
        public DaPackage valueOf(Map<String, Object> map) {
            return new DaPackagePojoImpl((String) map.get("OBJECT_NAME"), schema);
        }
    });
}

---

From source file:example.unittest.ExampleDbUnitTest.java

@Test
public void exampleTest() throws Exception {
    // load your data
    loadData(ds);/*from w  w  w  . java2s  .  c  o  m*/

    // Now run your test once the setup is done
    QueryRunner jdbc = new QueryRunner(ds);

    List<Map<String, Object>> tableCResults = jdbc.query("select * from DYN_TABLE_C ORDER BY C_ID",
            new MapListHandler());
    System.out.println("Print DYN_TABLE_C for debug");
    for (Map<String, Object> result : tableCResults) {
        System.out.println("DYN_TABLE_C ROW: " + result);
    }
    assertEquals(5, tableCResults.size());
    assertTableCRow(tableCResults, 0, 1, 1, "row1", null);
    assertTableCRow(tableCResults, 1, 2, 2, "row  2", Timestamp.valueOf("2013-01-02 12:34:56"));
    assertTableCRow(tableCResults, 2, 3, 2, "", Timestamp.valueOf("2013-01-02 12:34:56.1"));
    assertTableCRow(tableCResults, 3, 4, 2, "  row  4  ", Timestamp.valueOf("2013-01-02 12:34:56.234"));
    assertTableCRow(tableCResults, 4, 5, 2, null, Timestamp.valueOf("2013-01-02 12:34:56.567891"));

    List<Map<String, Object>> tableDResults = jdbc.query("select * from DYN_TABLE_D ORDER BY D_ID",
            new MapListHandler());
    System.out.println("Print DYN_TABLE_D for debug");
    for (Map<String, Object> result : tableDResults) {
        System.out.println("DYN_TABLE_D ROW: " + result);
    }
    assertEquals(3, tableDResults.size());
    assertTableDRow(tableDResults, 0, 1);
    assertTableDRow(tableDResults, 1, 2);
    assertTableDRow(tableDResults, 2, 3);
}

---

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

@Override
public ImmutableCollection<DaRoutine> searchExtraRoutines(final DaSchema schema, String procedureName,
        Connection conn) throws SQLException {
    QueryRunner query = new QueryRunner(); // using queryRunner so that we can reuse the connection

    String procedureClause = procedureName == null ? "" : " AND R.ROUTINENAME = '" + procedureName + "'";
    final String sql = "SELECT ROUTINENAME, SPECIFICNAME, TEXT FROM SYSCAT.ROUTINES R WHERE R.ROUTINETYPE = 'F'\n"
            + "AND R.ROUTINESCHEMA = '" + schema.getName() + "'\n" + procedureClause;
    LOG.debug("Executing function metadata query SQL: {}", sql);

    ImmutableList<Map<String, Object>> maps = ListAdapter.adapt(query.query(conn, sql, new MapListHandler()))
            .toImmutable();/*from w  w  w.ja  v a  2s. c  om*/

    if (LOG.isDebugEnabled()) {
        LOG.debug("Results:");
        for (Map<String, Object> map : maps) {
            LOG.debug("ROW: {}", map.toString());
        }
    }

    return maps.collect(new Function<Map<String, Object>, DaRoutine>() {
        @Override
        public DaRoutine valueOf(Map<String, Object> map) {
            return new DaRoutinePojoImpl((String) map.get("ROUTINENAME"), schema, DaRoutineType.function,
                    (String) map.get("SPECIFICNAME"), clobToString((Clob) map.get("TEXT")));
        }
    });
}

---

From source file:framework.retrieval.engine.index.all.database.impl.rdAbstract.DefaultRDatabaseIndexAllImpl.java

/**
 * ?SQL??/*w w w . j a v a  2s .com*/
 * @param limitSql         SQL
 * @param params         SQL?
 * @return
 */
@SuppressWarnings("unchecked")
public List<Map> getResult(String limitSql, Object[] params) {
    Connection conn = getConnection();

    QueryRunner qRunner = new QueryRunner();
    ResultSetHandler rsh = new MapListHandler();
    List<Map> result = null;

    try {
        if (params != null && params.length > 0) {
            result = (List<Map>) qRunner.query(conn, limitSql, rsh, params);
        } else {
            result = (List<Map>) qRunner.query(conn, limitSql, rsh);
        }
    } catch (SQLException e) {
        throw new RetrievalIndexException(e);
    } finally {
        close(conn);
    }

    return result;
}

---

From source file:com.odap.server.scheduler.JobManager.java

public synchronized List<Map<String, String>> refreshJobs() {

    logger.info("Entering refreshJobs()");

    try {/*from  w w w  .j a  v a  2  s  .  c  o  m*/
        QueryRunner qRunner = new QueryRunner();

        List<Map<String, Object>> mapList = (List<Map<String, Object>>) qRunner.query(conn,
                "SELECT jobs.*, servers.account_id,servers.server_name FROM jobs,servers where servers.id = jobs.server_id",
                new MapListHandler());

        processJobs(mapList);

    } catch (Exception e) {
        System.err.println("Cannot connect to database server");
        e.printStackTrace();
    }

    logger.info("Exiting refreshJobs()");
    return null;
}

---

From source file:com.iana.boesc.dao.BOESCDaoImpl.java

@Override
public Map<String, Map<String, Object>> getAllRegisteredUserDetailsMapByTypeId(int userTypeId) {
    Map<String, Map<String, Object>> map = new HashMap<String, Map<String, Object>>();
    QueryRunner run = new QueryRunner(getDataSource());
    try {/*from   w  w w.j a  va 2 s .com*/
        String query = "SELECT C.BOESC_USER_ID,U.SCAC,C.SEG_DELIM, C.ELE_DELIM,C.TRAN_TYPE FROM BOESC_CONFIG C, BOESC_USERS U WHERE  "
                + " C.BOESC_USER_ID = U.BOESC_USER_ID AND C.TRAN_TYPE IN ('" + GlobalVariables.BOESC + "','"
                + GlobalVariables.DVIR + "') AND U.BOESC_USER_TYPE_ID = ?  ";
        List<Map<String, Object>> listUsersDetails = run.query(query, new MapListHandler(), userTypeId);
        //logger.info("List size ::"+listUsersDetails.size());
        //logger.info("List  ::"+listUsersDetails);
        if (listUsersDetails == null || listUsersDetails.size() == 0)
            return map;
        else
            map = populateUserDetailsFromUserType(userTypeId, listUsersDetails);

    } catch (SQLException e) {
        e.printStackTrace();
        logger.error("SQLException occured :", e);
        logger.error("We are unable to load user information from DB due to SQL Exception.");
    } catch (Exception e) {
        e.printStackTrace();
        logger.error("Exception occured :", e);
        logger.error("We are unable to load user information from DB due to Exception.");
    }
    return map;
}

---

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

@Override
public ImmutableSet<DaDirectory> getDirectoriesOptional(Connection conn) throws SQLException {
    final String sql = "SELECT DIRECTORY_NAME, DIRECTORY_PATH FROM DBA_DIRECTORIES";
    LOG.debug("Executing directory metadata query SQL: {}", sql);

    ImmutableList<Map<String, Object>> maps = ListAdapter.adapt(jdbc.query(conn, sql, new MapListHandler()))
            .toImmutable();// ww  w  .j  a v  a2s  . c om

    if (LOG.isDebugEnabled()) {
        LOG.debug("Results:");
        for (Map<String, Object> map : maps) {
            LOG.debug("ROW: {}", map.toString());
        }
    }

    return maps.collect(new Function<Map<String, Object>, DaDirectory>() {
        @Override
        public DaDirectory valueOf(Map<String, Object> map) {
            return (DaDirectory) new DaDirectoryImpl((String) map.get("DIRECTORY_NAME"),
                    (String) map.get("DIRECTORY_PATH"));
        }
    }).toSet().toImmutable();
}

---

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

public List<CartItem> findByUser(String uid) throws SQLException {
    String sql = "select *from t_cartitem c, t_book b where c.bid= b.bid and uid=? order by c.orderBy";
    List<Map<String, Object>> mapList = qr.query(sql, new MapListHandler(), uid);
    return toCartItemList(mapList);

}

---

From source file:dbutils.ExampleJDBC.java

/**
 * MapListHandler ResultSet??ListListMap
 *//*w w  w  .  ja v a  2 s  . com*/
public static void getMapListData() {
    Connection conn = getConnection();
    QueryRunner qr = new QueryRunner();
    try {
        List results = (List) qr.query(conn, "SELECT id, name, gender, age, team_id FROM test_student",
                new MapListHandler());
        for (Object result : results) {
            Map map = (Map) result;
            System.out.println(
                    "id=" + map.get("id") + " name=" + map.get("name") + " gender=" + map.get("gender"));
        }
    } catch (SQLException e) {
        e.printStackTrace();
    } finally {
        DbUtils.closeQuietly(conn);
    }
}

---

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