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

List of usage examples for org.springframework.jdbc.core JdbcTemplate queryForList

  1. HOME
  2. Java
  3. org.springframework
  4. org.springframework.jdbc.core.*
  5. JdbcTemplate
  6. 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:org.springframework.integration.jdbc.JdbcMessageStoreTests.java

@Test
@Transactional// ww w  .  ja v a2  s  .  c  o  m
public void testRemoveMessageGroup() throws Exception {
    JdbcTemplate template = new JdbcTemplate(dataSource);
    template.afterPropertiesSet();
    String groupId = "X";

    Message<String> message = MessageBuilder.withPayload("foo").setCorrelationId(groupId).build();
    messageStore.addMessageToGroup(groupId, message);
    messageStore.removeMessageGroup(groupId);
    MessageGroup group = messageStore.getMessageGroup(groupId);
    assertEquals(0, group.size());

    String uuidGroupId = UUIDConverter.getUUID(groupId).toString();
    assertTrue(
            template.queryForList("SELECT * from INT_GROUP_TO_MESSAGE where GROUP_KEY = '" + uuidGroupId + "'")
                    .size() == 0);
}

From source file:org.springframework.jdbc.core.JdbcTemplateQueryTests.java

public void testQueryForList() throws Exception {
    String sql = "SELECT AGE FROM CUSTMR WHERE ID < 3";

    mockResultSetMetaData.getColumnCount();
    ctrlResultSetMetaData.setReturnValue(1, 2);
    mockResultSetMetaData.getColumnLabel(1);
    ctrlResultSetMetaData.setReturnValue("age", 2);

    mockResultSet.getMetaData();//from w ww .  j  av a 2 s. c  o  m
    ctrlResultSet.setReturnValue(mockResultSetMetaData, 2);
    mockResultSet.next();
    ctrlResultSet.setReturnValue(true);
    mockResultSet.getObject(1);
    ctrlResultSet.setReturnValue(new Integer(11));
    mockResultSet.next();
    ctrlResultSet.setReturnValue(true);
    mockResultSet.getObject(1);
    ctrlResultSet.setReturnValue(new Integer(12));
    mockResultSet.next();
    ctrlResultSet.setReturnValue(false);
    mockResultSet.close();
    ctrlResultSet.setVoidCallable();

    mockStatement.executeQuery(sql);
    ctrlStatement.setReturnValue(mockResultSet);
    if (debugEnabled) {
        mockStatement.getWarnings();
        ctrlStatement.setReturnValue(null);
    }
    mockStatement.close();
    ctrlStatement.setVoidCallable();

    mockConnection.createStatement();
    ctrlConnection.setReturnValue(mockStatement);

    replay();

    JdbcTemplate template = new JdbcTemplate(mockDataSource);

    List li = template.queryForList(sql);
    assertEquals("All rows returned", 2, li.size());
    assertEquals("First row is Integer", 11, ((Integer) ((Map) li.get(0)).get("age")).intValue());
    assertEquals("Second row is Integer", 12, ((Integer) ((Map) li.get(1)).get("age")).intValue());
}

From source file:org.springframework.jdbc.core.JdbcTemplateQueryTests.java

public void testQueryForListWithEmptyResult() throws Exception {
    String sql = "SELECT AGE FROM CUSTMR WHERE ID < 3";

    mockResultSet.next();//from w w  w . j  a  va2 s.co m
    ctrlResultSet.setReturnValue(false);
    mockResultSet.close();
    ctrlResultSet.setVoidCallable();

    mockStatement.executeQuery(sql);
    ctrlStatement.setReturnValue(mockResultSet);
    if (debugEnabled) {
        mockStatement.getWarnings();
        ctrlStatement.setReturnValue(null);
    }
    mockStatement.close();
    ctrlStatement.setVoidCallable();

    mockConnection.createStatement();
    ctrlConnection.setReturnValue(mockStatement);

    replay();

    JdbcTemplate template = new JdbcTemplate(mockDataSource);
    List li = template.queryForList(sql);
    assertEquals("All rows returned", 0, li.size());
}

From source file:org.springframework.jdbc.core.JdbcTemplateQueryTests.java

public void testQueryForListWithSingleRowAndColumn() throws Exception {
    String sql = "SELECT AGE FROM CUSTMR WHERE ID < 3";

    mockResultSetMetaData.getColumnCount();
    ctrlResultSetMetaData.setReturnValue(1);
    mockResultSetMetaData.getColumnLabel(1);
    ctrlResultSetMetaData.setReturnValue("age", 1);

    mockResultSet.getMetaData();/*from w  ww .  j  av  a  2 s .  co m*/
    ctrlResultSet.setReturnValue(mockResultSetMetaData);
    mockResultSet.next();
    ctrlResultSet.setReturnValue(true);
    mockResultSet.getObject(1);
    ctrlResultSet.setReturnValue(new Integer(11));
    mockResultSet.next();
    ctrlResultSet.setReturnValue(false);
    mockResultSet.close();
    ctrlResultSet.setVoidCallable();

    mockStatement.executeQuery(sql);
    ctrlStatement.setReturnValue(mockResultSet);
    if (debugEnabled) {
        mockStatement.getWarnings();
        ctrlStatement.setReturnValue(null);
    }
    mockStatement.close();
    ctrlStatement.setVoidCallable();

    mockConnection.createStatement();
    ctrlConnection.setReturnValue(mockStatement);

    replay();

    JdbcTemplate template = new JdbcTemplate(mockDataSource);

    List li = template.queryForList(sql);
    assertEquals("All rows returned", 1, li.size());
    assertEquals("First row is Integer", 11, ((Integer) ((Map) li.get(0)).get("age")).intValue());
}

From source file:org.wso2.appserver.integration.common.artifacts.spring3.restful.jndi.service.controller.StudentController.java

@RequestMapping(method = RequestMethod.GET)
@ResponseBody//  w w w.  j  a  va  2 s  .  c  om
public List<Student> getallStudent() {
    log.info("Retrieve all Student info");
    List<Student> students = new ArrayList<>();
    String query = "SELECT id, first_name, last_name, age from student";
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);

    List<Map<String, Object>> studentRows = jdbcTemplate.queryForList(query);
    for (Map<String, Object> studentRow : studentRows) {
        Student student = new Student();
        student.setId(Integer.parseInt(String.valueOf(studentRow.get("id"))));
        student.setFirstName(String.valueOf(studentRow.get("first_name")));
        student.setLastName(String.valueOf(studentRow.get("last_name")));
        student.setAge(Integer.parseInt(String.valueOf(studentRow.get("age"))));
        students.add(student);
    }
    return students;
}