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()

     */
    public String getUserPassword(Long userId) {
        JdbcTemplate jdbcTemplate =
                new JdbcTemplate(SessionFactoryUtils.getDataSource(getSessionFactory()));
        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

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

        assertEquals("virtualvalue", userTO.getVirtualAttributeMap().get("virtualdata").getValues().get(0));


        try {
            final JdbcTemplate jdbcTemplate = new JdbcTemplate(testDataSource);


            String value = jdbcTemplate.queryForObject(
                    "SELECT USERNAME FROM testsync WHERE ID=?", String.class, userTO.getId());
            assertEquals("virtualvalue", value);
        } catch (EmptyResultDataAccessException e) {
            fail();
        }

View Full Code Here

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

    updateDatabase(DROP_SCHEMA);
  }


  private void checkStoredMessage(String message) {
    JdbcTemplate template=new JdbcTemplate(getDataSource());
    String storedMessage=(String)template.queryForObject(SELECT_FIELD_REQUEST,
        new Object[] {new Integer(FIELD_ID)},
        new int[] {Types.INTEGER},String.class);
    assertEquals(message,storedMessage);
  }

View Full Code Here

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

    updateDatabase(DROP_SCHEMA);
  }


  private void checkStoredMessage(String message) {
    JdbcTemplate template=new JdbcTemplate(getDataSource());
    String storedMessage=(String)template.queryForObject(SELECT_FIELD_REQUEST,
        new Object[] {new Integer(FIELD_ID)},
        new int[] {Types.INTEGER},String.class);
    assertEquals(message,storedMessage);
  }

View Full Code Here

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


        // 6. check that rejected user was not propagated to external resource (SYNCOPE-364)
        JdbcTemplate jdbcTemplate = new JdbcTemplate(testDataSource);
        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-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()

        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 = 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()


        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

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.