List of queryForObject() Examples

Examples of queryForObject()

com.alibaba.druid.support.ibatis.SqlMapClientWrapper.queryForObject()
com.alibaba.druid.support.ibatis.SqlMapExecutorWrapper.queryForObject()
com.ibatis.sqlmap.client.SqlMapClient.queryForObject()
com.ibatis.sqlmap.client.SqlMapSession.queryForObject()
liquibase.executor.Executor.queryForObject()
Read methods
org.g4studio.common.dao.Dao.queryForObject()
查询一条记录 @param SQL语句ID号 @param parameterObject 查询条件对象(map javaBean)
org.g4studio.common.dao.Reader.queryForObject()
查询一条记录 @param SQL语句ID号 @param parameterObject 查询条件对象(map javaBean)
org.springframework.jdbc.core.JdbcOperations.queryForObject()
Execute a query given static SQL, mapping a single result row to a Java object via a RowMapper.
Uses a JDBC Statement, not a PreparedStatement. If you want to execute a static query with a PreparedStatement, use the overloaded queryForObject method with null as argument array. @param sql SQL query to execute @param rowMapper object that will map one object per row @return the single mapped object @throws IncorrectResultSizeDataAccessException if the query does notreturn exactly one row @throws DataAccessException if there is any problem executing the query @see #queryForObject(String,Object[],RowMapper)
org.springframework.jdbc.core.JdbcTemplate.queryForObject()
org.springframework.jdbc.core.namedparam.NamedParameterJdbcOperations.queryForObject()
Query given SQL to create a prepared statement from SQL and a list of arguments to bind to the query, mapping a single result row to a Java object via a RowMapper. @param sql SQL query to execute @param paramSource container of arguments to bind to the query @param rowMapper object that will map one object per row @return the single mapped object @throws org.springframework.dao.IncorrectResultSizeDataAccessException if the query does not return exactly one row, or does not return exactly one column in that row @throws org.springframework.dao.DataAccessException if the query fails
org.springframework.jdbc.core.simple.SimpleJdbcTemplate.queryForObject()

Examples of org.springframework.jdbc.core.JdbcTemplate.queryForObject()

        userTO = restTemplate.postForObject(BASE_URL + "user/create", userTO, UserTO.class);
        assertNotNull(userTO);


        JdbcTemplate jdbcTemplate = new JdbcTemplate(testDataSource);


        String username = jdbcTemplate.queryForObject("SELECT id FROM test WHERE id=?", String.class,
                userTO.getUsername());


        assertEquals(userTO.getUsername(), username);


        UserMod userMod = new UserMod();

View Full Code Here

Examples of org.springframework.jdbc.core.JdbcTemplate.queryForObject()


        userTO = restTemplate.postForObject(BASE_URL + "user/update", userMod, UserTO.class);


        assertTrue(userTO.getResources().isEmpty());


        jdbcTemplate.queryForObject("SELECT id FROM test WHERE id=?", String.class, userTO.getUsername());
    }


    @Test
    public void issue234() {
        UserTO userTO = getSampleTO("issue234@syncope.apache.org");

View Full Code Here

Examples of org.springframework.jdbc.core.JdbcTemplate.queryForObject()

    public void load() {
        JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);


        boolean existingData;
        try {
            existingData = jdbcTemplate.queryForObject("SELECT COUNT(0) FROM " + SyncopeConf.class.getSimpleName(),
                    Integer.class) > 0;
        } catch (DataAccessException e) {
            LOG.error("Could not access to table " + SyncopeConf.class.getSimpleName(), e);
            existingData = true;
        }

View Full Code Here

Examples of org.springframework.jdbc.core.JdbcTemplate.queryForObject()


        assertTrue(userTO.getPropagationStatusTOs().isEmpty());


        Exception exception = null;
        try {
            jdbcTemplate.queryForObject("SELECT id FROM test WHERE id=?",
                    new String[]{userTO.getUsername()}, Integer.class);
        } catch (EmptyResultDataAccessException e) {
            exception = e;
        }
        assertNotNull(exception);

View Full Code Here

Examples of org.springframework.jdbc.core.JdbcTemplate.queryForObject()

        assertEquals("active", userTO.getStatus());
        assertEquals(Collections.singleton(RESOURCE_NAME_TESTDB), userTO.getResources());


        exception = null;
        try {
            final String username = jdbcTemplate.queryForObject("SELECT id FROM test WHERE id=?", String.class,
                    userTO.getUsername());
            assertEquals(userTO.getUsername(), username);
        } catch (EmptyResultDataAccessException e) {
            exception = e;
        }

View Full Code Here

Examples of org.springframework.jdbc.core.JdbcTemplate.queryForObject()

        assertNotNull(userTO);
        assertEquals(1, userTO.getResources().size());


        JdbcTemplate jdbcTemplate = new JdbcTemplate(testDataSource);


        String username = jdbcTemplate.queryForObject("SELECT id FROM test WHERE id=?", String.class,
                userTO.getUsername());


        assertEquals(userTO.getUsername(), username);


        UserMod userMod = new UserMod();

View Full Code Here

Examples of org.springframework.jdbc.core.JdbcTemplate.queryForObject()


        userTO = userService.update(userMod.getId(), userMod);


        assertTrue(userTO.getResources().isEmpty());


        jdbcTemplate.queryForObject("SELECT id FROM test WHERE id=?", String.class, userTO.getUsername());
    }


    @Test
    public void issue234() {
        UserTO inUserTO = getUniqueSampleTO("issue234@syncope.apache.org");

View Full Code Here

Examples of org.springframework.jdbc.core.JdbcTemplate.queryForObject()


        Exception exception = null;
        try {
            final JdbcTemplate jdbcTemplate = new JdbcTemplate(testDataSource);


            String value = jdbcTemplate.queryForObject(
                    "SELECT USERNAME FROM testsync WHERE ID=?", String.class, actual.getId());
            assertEquals("virattrcache", value);


            jdbcTemplate.update("UPDATE testsync set USERNAME='virattrcache2' WHERE ID=?", userTO.getId());

View Full Code Here

Examples of org.springframework.jdbc.core.JdbcTemplate.queryForObject()

                    "SELECT USERNAME FROM testsync WHERE ID=?", String.class, actual.getId());
            assertEquals("virattrcache", value);


            jdbcTemplate.update("UPDATE testsync set USERNAME='virattrcache2' WHERE ID=?", userTO.getId());


            value = jdbcTemplate.queryForObject(
                    "SELECT USERNAME FROM testsync WHERE ID=?", String.class, userTO.getId());
            assertEquals("virattrcache2", value);


        } catch (EmptyResultDataAccessException e) {
            exception = e;

View Full Code Here

Examples of org.springframework.jdbc.core.JdbcTemplate.queryForObject()

     * {@inheritDoc}
     */
    public String getUserPassword(Long userId) {
        JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
        Table table = AnnotationUtils.findAnnotation(User.class, Table.class);
        return jdbcTemplate.queryForObject(
                "select password from " + table.name() + " where id=?", String.class, userId);
    }
}

View Full Code Here

0 1 2 3 4 5

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.