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
    public <T> T queryForObject(String sql, Class<T> requiredType, @Nullable Object... args)
            throws DataAccessException 

Source Link

Usage

From source file:com.iucosoft.eavertizare.dao.impl.ConfiguratiiDaoImpl.java

@Override
public Configuratii findById(int idConfiguratie) {

    String query = "select * from configuratii_db where id = ?";
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);

    //using RowMapper anonymous class, we can create a separate RowMapper for reuse
    Configuratii configuratii = jdbcTemplate.queryForObject(query, new Object[] { idConfiguratie },
            new RowMapper<Configuratii>() {

                @Override/*from   w ww.  ja v a  2  s.c  om*/
                public Configuratii mapRow(ResultSet rs, int i) throws SQLException {

                    Configuratii configuratie = new Configuratii();
                    configuratie.setId(rs.getInt(1));
                    configuratie.setDriver(rs.getString(2));
                    configuratie.setUrlDb(rs.getString(3));
                    configuratie.setUsername(rs.getString(4));
                    configuratie.setPassword(rs.getString(5));
                    configuratie.setTabelaClienti(rs.getString(6));
                    return configuratie;
                }
            });

    return configuratii;
}

---

From source file:com.rplt.studioMusik.dataPersewaan.PersewaanStudioMusikDAO.java

@Override
public int hitungBiayaSewa(int pDurasi, String pKodeStudio) {
    String sql = "SELECT (? * tarif_per_jam) FROM studio_musik WHERE kode_studio = ?";

    sql = "SELECT (? * `TARIF_PER_JAM`) FROM `studiomusik`.`studio_musik` WHERE `KODE_STUDIO` = ?";

    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    return jdbcTemplate.queryForObject(sql, new Object[] { pDurasi, pKodeStudio }, Integer.class);
}

---

From source file:org.musicrecital.dao.hibernate.UserDaoHibernate.java

/**
 * {@inheritDoc}/*from  w  w  w.  j  a va 2 s.c o  m*/
*/
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);
}

---

From source file:com.rplt.studioMusik.dataPersewaan.PersewaanStudioMusikDAO.java

@Override
public String selesaiSewa(PersewaanStudioMusik pPersewaanStudioMusik) {
    String sql = "SELECT date_format(date_add((STR_TO_DATE(?, '%d-%b-%Y %k:%S')), INTERVAL ? HOUR), '%d-%b-%Y %k:%S')";
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    String selesaiSewa = jdbcTemplate.queryForObject(sql,
            new Object[] { pPersewaanStudioMusik.getmMulaiSewa(), pPersewaanStudioMusik.getmDurasi() },
            String.class);
    return selesaiSewa;
}

---

From source file:net.sourceforge.vulcan.jabber.JdbcScreenNameMapper.java

public Map<String, String> lookupByAuthor(Iterable<Committer> authors) {
    final Map<String, String> screenNames = new HashMap<String, String>();

    try {/*w w w.j av a 2 s .c o  m*/
        final JdbcTemplate template = createJdbcTemplate();

        for (Committer author : authors) {
            try {
                String field = author.getName();
                screenNames.put(author.getName(), (String) template.queryForObject(config.getSql(),
                        new Object[] { field }, String.class));
            } catch (IncorrectResultSizeDataAccessException e) {
                LOG.info("No screen name found for commit author " + author);
            }
        }
    } catch (Exception e) {
        LOG.error("Exception looking up screen names in database", e);
    }

    return screenNames;
}

---

From source file:org.perconsys.dao.implement.UserJdbcTpl.java

@Override
public User getByKey(String key) {
    JdbcTemplate dbtpl = this.getJdbcTemplate();
    String sql = String.format("select * from `%s` WHERE `authKey` = ? LIMIT 0, 1 ;", table);
    return dbtpl.queryForObject(sql, new Object[] { key }, new UserMapper());
}

---

From source file:just.aRest.project.DAO.ApplDAOImpl.java

@Override
public ResponseEntity<String> createApplication(Application app) {
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    String query = "SELECT email FROM Client WHERE username = ? LIMIT 1";
    try {/*from   w  w  w  .j a  v a  2s .  c  om*/
        //before creating the application check if the user exists
        String checker0 = jdbcTemplate.queryForObject(query, new Object[] { app.getUsername() }, String.class);
        int checker = 0;
        if (checker0.equals("") || checker0 == null)
            checker = 0;
        else
            checker = 1;
        if (checker == 1) {
            //Create the application
            query = "INSERT INTO Application VALUES(?,?,?,?,?,?,?,0,0,?,10)";
            checker = jdbcTemplate.update(query, app.getApp_code(), app.getAmount(), app.getRepay_Time(),
                    app.getBuy_type(), app.getDrivers_license(), app.getTaxes(), app.getTekmiriwsi(),
                    app.getUsername());
            //enter empty field for Directors Commentary
            if (checker == 1) {
                query = "INSERT INTO Director VALUES(\"\",?)";
                checker = jdbcTemplate.update(query, app.getApp_code());
                if (checker == 1) {
                    //Return user for successful completion
                    return new ResponseEntity<String>("Opperation completed successfully", HttpStatus.OK);
                } else {
                    //inform him that something went wrong
                    return new ResponseEntity<String>("Very rare issue,contact technical support",
                            HttpStatus.NOT_ACCEPTABLE);
                }
            } else {
                return new ResponseEntity<String>("Fill the form correctly", HttpStatus.NOT_ACCEPTABLE);
            }
        } else {
            return new ResponseEntity<String>("User doesn\'t exist", HttpStatus.NOT_ACCEPTABLE);
        }

    } catch (EmptyResultDataAccessException e) {
        return new ResponseEntity<String>("User doesn\'t exist", HttpStatus.NOT_ACCEPTABLE);
    } catch (NumberFormatException e) {
        return new ResponseEntity<String>("Form filled incorrectly", HttpStatus.NOT_ACCEPTABLE);
    }

}

---

From source file:com.osrdata.etltoolbox.fileloader.FileSpecification.java

private Integer selectAuditFile() {
    JdbcTemplate template = new JdbcTemplate(auditDs);
    Integer fileId;//w  w  w  .  j a v a2  s  .c o  m
    try {
        fileId = template.queryForObject(
                "select file_id from audit_file where source_id = ? and file_name = ? and table_name = ? and etl_type = ? and etl_date = ?",
                new Object[] { sourceId, sourceFile.getName(), targetTable, etlType, etlDate }, Integer.class);
    } catch (EmptyResultDataAccessException e) {
        fileId = null;
    }
    log.debug("\tSelect audit_file returned " + fileId);
    return fileId;
}

---

From source file:org.cloudfoundry.identity.uaa.scim.ScimUserEndpointsTests.java

@Test
public void userGetsADefaultPassword() {
    ScimUser user = new ScimUser(null, "dave", "David", "Syer");
    user.addEmail("dsyer@vmware.com");
    endpoints.setSecurityContextAccessor(mockSecurityContext(user));
    ScimUser created = endpoints.createUser(user);
    createdUsers.add(created);//from  w w w . ja  v a2  s.co  m
    assertNull("A newly created user revealed its password", created.getPassword());
    JdbcTemplate jdbcTemplate = new JdbcTemplate(database);
    String password = jdbcTemplate.queryForObject("select password from users where id=?", String.class,
            created.getId());
    // Generated password...
    assertNotNull(password);
}

---

From source file:org.cloudfoundry.identity.uaa.scim.ScimUserEndpointsTests.java

@Test
public void userCanInitializePassword() {
    ScimUser user = new ScimUser(null, "dave", "David", "Syer");
    user.addEmail("dsyer@vmware.com");
    ReflectionTestUtils.setField(user, "password", "foo");
    endpoints.setSecurityContextAccessor(mockSecurityContext(user));
    ScimUser created = endpoints.createUser(user);
    createdUsers.add(created);//from  w w  w  .  j a v a  2s .  c o  m
    assertNull("A newly created user revealed its password", created.getPassword());
    JdbcTemplate jdbcTemplate = new JdbcTemplate(database);
    String password = jdbcTemplate.queryForObject("select password from users where id=?", String.class,
            created.getId());
    assertEquals("foo", password);
}

---

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