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

Introduction

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

Prototype

@Override
    @Nullable
    public <T> T queryForObject(String sql, Class<T> requiredType) throws DataAccessException

Source Link

Usage

From source file:com.kaidad.utilities.MBTilesBase64Converter.java

private static void createTempTable(JdbcTemplate c) {
    Integer i = c.queryForObject(
            "select count(*) from sqlite_master WHERE type='table' AND name='images_string'", Integer.class);
    if (i == 0) {
        c.execute("create table images_string (tile_data TEXT, tile_id TEXT)");
    }//from   w w w.  ja  va 2 s .co  m
    System.out.println("Successfully created table images_string 'tile_data_string'");
}

From source file:factory.JdbcTemplateFactoryTest.java

@Test
public void testProjectTemplate() {
    try {/*from w w  w  .j a v  a2  s  .  c om*/
        JdbcTemplate template = JdbcTemplateFactory.getProjectDBTemplate();
        Integer obj = template.queryForObject(TEST_QUERY, Integer.class);
        assertTrue(obj == 1);
    } catch (SQLException e) {
        log.error(e);
    }

}

From source file:edu.jhuapl.openessence.web.util.MapQueryUtil.java

public Timestamp performCurrentTimestampQuery() {
    JdbcTemplate pgdb = new JdbcTemplate(mapDataSource);
    return pgdb.queryForObject("select current_timestamp", Timestamp.class);
}

From source file:factory.JdbcTemplateFactoryTest.java

@Test
public void testCQTemplate() {
    try {/*w  w w . ja  v  a 2  s.c o m*/
        JdbcTemplate cqTemplate = JdbcTemplateFactory.getClearQuestDBTemplate();
        Integer obj = cqTemplate.queryForObject(TEST_QUERY, Integer.class);
        assertTrue(obj == 1);
    } catch (SQLException e) {
        log.error(e);
    }
}

From source file:org.string_db.jdbc.JdbcTemplateTest.java

@org.junit.Test
public void test_jdbcTemplateOpen() throws Exception {
    final JdbcTemplate jdbcTemplate = CachedTestAppContext.ctx.getBean(JdbcTemplate.class);
    final Integer numSpecies = jdbcTemplate.queryForObject("select count(*) from items.species", Integer.class);
    assertTrue("must have some species: " + numSpecies, numSpecies > 0);
    final String name = jdbcTemplate
            .queryForObject("select compact_name from items.species where species_id = 511145", String.class);
    assertEquals("Escherichia coli K12_MG1655", name);
}

From source file:org.awesomeagile.dao.DatabaseIntegrationTest.java

@Test
public void testPostgres() throws Exception {
    JdbcTemplate jdbcTemplate = testDatabase.jdbcTemplate();
    int random = RandomUtils.nextInt(1000);
    Integer integer = jdbcTemplate.queryForObject("select " + random, Integer.class);
    assertEquals(random, integer.intValue());
}

From source file:uk.ac.kcl.it.PostGresTestUtils.java

@Override
public int countRowsInOutputTable() {
    JdbcTemplate jdbcTemplate = new JdbcTemplate(targetDataSource);
    return jdbcTemplate.queryForObject("SELECT COUNT(*) FROM tblOutputDocs", Integer.class);
}

From source file:com.aw.core.db.DbCachedTime.java

protected Date queryDBForSysdate() {
    return (Date) TransactionDecorator.executeQuery(new DBExecuter() {
        public Object execute() {
            JdbcTemplate jt = new JdbcTemplate(dataSource);
            String sql = "select sysdate from dual";
            Date date = (Date) jt.queryForObject(sql, Date.class);
            return date;
        }/*w ww .j a va 2s  . c om*/
    });
}

From source file:com.googlecode.flyway.core.dbsupport.postgresql.PostgreSQLMigrationMediumTest.java

/**
 * Tests clean and migrate for PostgreSQL Stored Procedures.
 *///w ww .ja v  a 2 s. co m
@Test
public void storedProcedure() throws Exception {
    flyway.setBaseDir("migration/dbsupport/postgresql/sql/procedure");
    flyway.migrate();

    JdbcTemplate jdbcTemplate = new JdbcTemplate(migrationDataSource);
    assertEquals("Hello", jdbcTemplate.queryForObject("SELECT value FROM test_data", String.class));

    flyway.clean();

    // Running migrate again on an unclean database, triggers duplicate object exceptions.
    flyway.migrate();
}

From source file:uk.ac.kcl.it.SqlServerTestUtils.java

@Override
public int countRowsInOutputTable() {
    JdbcTemplate jdbcTemplate = new JdbcTemplate(targetDataSource);
    return jdbcTemplate.queryForObject("SELECT COUNT(*) FROM dbo.tblOutputDocs", Integer.class);
}