Example usage for org.springframework.jdbc.core JdbcTemplate queryForList

Introduction

In this page you can find the example usage for org.springframework.jdbc.core JdbcTemplate queryForList.

Prototype

@Override
    public List<Map<String, Object>> queryForList(String sql) throws DataAccessException 

Source Link

Usage

From source file:flywayspike.Main.java

/**
 * Runs the sample./*  ww  w.ja va  2 s .c  o  m*/
 *
 * @param args None supported.
 */
public static void main(String[] args) throws Exception {
    DataSource dataSource = new SimpleDriverDataSource(new org.hsqldb.jdbcDriver(),
            "jdbc:hsqldb:file:db/flyway_sample;shutdown=true", "SA", "");
    Flyway flyway = new Flyway();
    flyway.setDataSource(dataSource);
    flyway.setLocations("flywayspike.migration", "abcd");
    flyway.clean();

    System.out.println("Started Migration");
    flyway.migrate();
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    List<Map<String, Object>> results = jdbcTemplate.queryForList("select name from test_user");
    for (Map<String, Object> result : results) {
        System.out.println("Name: " + result.get("NAME"));
    }

    SqlRowSet rowSet = jdbcTemplate.queryForRowSet("select * from schema_version");
    while (rowSet.next()) {
        System.out.print(rowSet.getObject(1));
        System.out.println("  " + rowSet.getObject(2));
    }
}

---

From source file:com.ms.commons.test.tool.ExportDatabaseData.java

private static MemoryTable querySqlToMemoryTable(JdbcTemplate jdbcTemplate, String sql,
        Map<String, Integer> tableMap) {
    System.out.println("Executing: " + sql);

    List<MemoryRow> rowList = new ArrayList<MemoryRow>();

    MutableObject refTableName = new MutableObject();
    MemoryTable mt = new MemoryTable(getSqlTableName(sql, tableMap, refTableName));

    @SuppressWarnings("unchecked")
    List<Map<String, Object>> resultList = jdbcTemplate.queryForList(sql);
    for (Map<String, Object> result : resultList) {
        List<MemoryField> fieldList = new ArrayList<MemoryField>();
        for (String field : result.keySet()) {
            fieldList.add(new MemoryField(field, MemoryFieldType.Unknow,
                    translate(refTableName, field, result.get(field))));
        }//from   w w w  .j  ava 2  s .  c  om
        rowList.add(new MemoryRow(fieldList));
    }
    mt.setRowList(rowList);
    return mt;
}

---

From source file:net.gplatform.spring.social.base.JdbcUsersConnectionRepositoryTableCreator.java

public void createTableIfNotExist() {
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    try {/*from ww  w. ja  va  2  s  . co  m*/
        jdbcTemplate.queryForList("select count(*) from UserConnection");
    } catch (Exception e) {
        LOG.debug("Create table UserConnection");
        try {
            ResourceDatabasePopulator rdp = new ResourceDatabasePopulator();
            rdp.addScript(new ClassPathResource(
                    "/org/springframework/social/connect/jdbc/JdbcUsersConnectionRepository.sql"));
            DatabasePopulatorUtils.execute(rdp, dataSource);
        } catch (Exception e1) {
            LOG.error("Error create table UserConnection", e1);
        }
    }
}

---

From source file:org.smart.migrate.setting.DataSourceTest.java

@Test
public void testDataSource() {
    DBSetting dbs = new DBSetting(DBType.MySQL, "localhost", "3306", "smartData", "root", null);
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName(dbs.getdBType().getDriver());
    dataSource.setUrl(dbs.getConnectUrl());
    dataSource.setUsername(dbs.getUsername());
    dataSource.setPassword(dbs.getPassword());
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    List<Map<String, Object>> dataList = jdbcTemplate.queryForList("select * from gen_fawen");
    for (Map<String, Object> map : dataList) {
        for (Map.Entry<String, Object> entry : map.entrySet()) {
            String string = entry.getKey();
            Object object = entry.getValue();
            System.out.println(string + "," + object);
        }/*from w  w  w .  j a  v a  2  s .  co  m*/
    }

}

---

From source file:me.hengwei.t.javaee.spring.springjndidemo.controller.EmployeeController.java

@RequestMapping(value = "/rest/emps", method = RequestMethod.GET)
public @ResponseBody List<Employee> getAllEmployees() {
    logger.info("Start getAllEmployees.");
    List<Employee> empList = new ArrayList<Employee>();
    //JDBC Code - Start
    String query = "select id, name, role from Employee";
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);

    List<Map<String, Object>> empRows = jdbcTemplate.queryForList(query);

    for (Map<String, Object> empRow : empRows) {
        Employee emp = new Employee();
        emp.setId(Integer.parseInt(String.valueOf(empRow.get("id"))));
        emp.setName(String.valueOf(empRow.get("name")));
        emp.setRole(String.valueOf(empRow.get("role")));
        empList.add(emp);/*from  w  ww.  j  a  v  a2  s  .  com*/
    }

    return empList;
}

---

From source file:se.ivankrizsan.messagecowboy.services.taskconfiguration.JPASchedulableTaskConfigurationRepositoryTest.java

/**
 * Logs the SQL statements used to create the databasetable in the HSQL database.
 * Will always succeed as long as no error occurs.
 *///from  w w w  .ja v a  2s.c o  m
@Test
public void logCreateTablesSqlStatements() {
    final JdbcTemplate theJdbcTemplate = new JdbcTemplate(mTestDBDataSource);

    List<Map<String, Object>> theQueryResult = theJdbcTemplate.queryForList("script");
    for (Map<String, Object> theMap : theQueryResult) {
        for (Entry<String, Object> theEntry : theMap.entrySet()) {
            String theSqlStatement = theEntry.getValue().toString();

            if (theSqlStatement.matches("(?i).*CREATE.*")) {
                theSqlStatement = theSqlStatement.replaceAll(" MEMORY", "");
                System.out.println("\n" + theSqlStatement);
            }
        }
    }
}

---

From source file:com.vladmihalcea.HibernateSQLStatementCountTest.java

@Test
public void test() {

    transactionTemplate.execute(new TransactionCallback<Void>() {
        @Override/*w  ww  . j a va2s.  c  o m*/
        public Void doInTransaction(TransactionStatus transactionStatus) {

            Company company = new Company();
            company.setName("TV Company");
            entityManager.persist(company);

            Product product1 = new Product("tvCode");
            product1.setName("TV");
            product1.setCompany(company);

            WarehouseProductInfo warehouseProductInfo1 = new WarehouseProductInfo();
            warehouseProductInfo1.setQuantity(101);
            product1.addWarehouse(warehouseProductInfo1);

            Product product2 = new Product("cdCode");
            product2.setName("CD");
            product2.setCompany(company);

            WarehouseProductInfo warehouseProductInfo2 = new WarehouseProductInfo();
            warehouseProductInfo2.setQuantity(50);
            product2.addWarehouse(warehouseProductInfo2);

            entityManager.persist(product1);
            entityManager.persist(product2);
            entityManager.flush();

            final JdbcTemplate otherDataSourceJdbcTemplate = new JdbcTemplate(otherDataSource);
            List<Map<String, Object>> versions = otherDataSourceJdbcTemplate
                    .queryForList(" select * from version ");
            assertTrue(versions.isEmpty());
            return null;
        }
    });

    try {
        SQLStatementCountValidator.reset();
        warehouseProductInfoService.findAllWithNPlusOne();
        SQLStatementCountValidator.assertSelectCount(1);
    } catch (SQLSelectCountMismatchException e) {
        assertEquals(3, e.getRecorded());
    }

    SQLStatementCountValidator.reset();
    warehouseProductInfoService.findAllWithFetch();
    SQLStatementCountValidator.assertSelectCount(1);

    SQLStatementCountValidator.reset();
    warehouseProductInfoService.newWarehouseProductInfo();
    SQLStatementCountValidator.assertSelectCount(1);
    SQLStatementCountValidator.assertInsertCount(2);
}

---

From source file:com.pontecultural.flashcards.JdbcFlashcardsDao.java

public String fetchDeckname(int aDeckId) {
    String rc = null;//from   w ww  . j  a  v a 2 s.  com
    StringBuilder sql = new StringBuilder("SELECT name,description FROM decks where _id = ");
    sql.append(aDeckId);
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    List<Map<String, Object>> rows = jdbcTemplate.queryForList(sql.toString());
    assertTrue(rows.size() == 1);
    for (Map<String, Object> r : rows) {
        rc = (String) r.get("name");
    }
    return rc;
}

---

From source file:org.cloudfoundry.identity.uaa.scim.bootstrap.ScimUserBootstrapTests.java

@Test
public void canRemoveAuthorities() throws Exception {
    UaaUser joe = new UaaUser("joe", "password", "joe@test.org", "Joe", "User");
    joe = joe.authorities(AuthorityUtils.commaSeparatedStringToAuthorityList("openid,read"));
    ScimUserBootstrap bootstrap = new ScimUserBootstrap(db, gdb, mdb, Arrays.asList(joe));
    bootstrap.afterPropertiesSet();/*from  w ww.j a v  a 2s  . c o  m*/
    joe = joe.authorities(AuthorityUtils.commaSeparatedStringToAuthorityList("openid"));
    JdbcTemplate jdbcTemplate = new JdbcTemplate(database);
    System.err.println(jdbcTemplate.queryForList("SELECT * FROM group_membership"));
    bootstrap = new ScimUserBootstrap(db, gdb, mdb, Arrays.asList(joe));
    bootstrap.setOverride(true);
    bootstrap.afterPropertiesSet();
    @SuppressWarnings("unchecked")
    Collection<Map<String, Object>> users = (Collection<Map<String, Object>>) userEndpoints
            .findUsers("id", "id pr", "id", "ascending", 1, 100).getResources();
    assertEquals(1, users.size());

    String id = (String) users.iterator().next().get("id");
    ScimUser user = userEndpoints.getUser(id);
    // uaa.user is always added
    assertEquals(2, user.getGroups().size());
}

---

From source file:com.pontecultural.flashcards.JdbcFlashcardsDao.java

public List<Card> fetchAllCards() {
    List<Card> rc = null;/*w  w  w.  ja va  2 s .c o  m*/
    StringBuilder sql = new StringBuilder("SELECT enText,ptText FROM cards where state = ");
    sql.append(STATE.PRESENT);
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    List<Map<String, Object>> rows = jdbcTemplate.queryForList(sql.toString());
    rc = new ArrayList<Card>(rows.size());
    for (Map<String, Object> r : rows) {
        Card c = new Card();
        c.setEnText((String) r.get("enText"));
        c.setPtText((String) r.get("ptText"));
        c.setId((Integer) r.get("deckid"));
        rc.add(c);
    }
    return rc;
}

---

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