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:org.obiba.onyx.jade.instrument.topcon.EyeExtractorQueryUtil.java

public static String getLocation(JdbcTemplate jdbc, String storagePathUid) {
    return jdbc.queryForObject("SELECT Location FROM dbo.StoragePaths WHERE StoragePathUid = ?",
            new Object[] { storagePathUid }, String.class);
}

---

From source file:com.rplt.studioMusik.studioMusik.StudioMusikDAO.java

@Override
public String getNamaStudio(String pKode) {
    String namaStudio = "";

    String sql = "SELECT nama_studio FROM studio_musik WHERE kode_studio = ?";

    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    namaStudio = jdbcTemplate.queryForObject(sql, String.class, pKode);
    return namaStudio;
}

---

From source file:com.rplt.studioMusik.pegawai.PegawaiDAO.java

@Override
public String getNamaByUser(String pUsername) {
    String sql = "SELECT nama_pegawai FROM pegawai_studio_musik WHERE username_pegawai = ?";
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    return jdbcTemplate.queryForObject(sql, String.class, pUsername);
}

---

From source file:com.github.lsiu.experiment.eclipselink.TestEclipseLinkEvents.java

@Test
public void testMergeAndVersioning() throws SQLException {
    Restaurant r = em.find(Restaurant.class, TEST_LICENSENO);

    // merge no change, version should not change
    Restaurant merged = mergeChanges(r);
    Assert.assertEquals(merged.getVersion(), (Integer) 1);

    // merge with change, version should increment
    String newName = String.format("Man Lock [name updated %s]", datetimeFormatter.format(new Date()));
    merged.name = newName;/*  ww w .j  a va 2  s  .com*/
    Restaurant merged2 = mergeChanges(merged);

    Assert.assertEquals(merged2.name, newName);
    Assert.assertEquals(merged2.getVersion(), (Integer) 2);

    Restaurant r2 = em.find(Restaurant.class, TEST_LICENSENO);
    log.debug("Re-fetch name: {}, version: {}", r2.name, r2.getVersion());
    Assert.assertEquals(r2.getVersion(), (Integer) 2);

    // check history policy
    JdbcTemplate jdbcTemplate = new JdbcTemplate(ds);
    Integer count = jdbcTemplate.queryForObject("SELECT COUNT(*) FROM RESTAURANT_HIST WHERE LICENSENO = ?",
            Integer.class, TEST_LICENSENO);
    Assert.assertEquals(count, (Integer) 2);

}

---

From source file:eionet.transfer.dao.MetadataServiceJdbc.java

@Override
public Upload getById(String id) {
    String query = "SELECT id, expires, filename, uploader, contenttype, filesize FROM uploads WHERE id = ?";
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);

    Upload uploadRec = jdbcTemplate.queryForObject(query, new Object[] { id }, new RowMapper<Upload>() {

        @Override//  w  ww  .j  a v  a 2 s. c  o m
        public Upload mapRow(ResultSet rs, int rowNum) throws SQLException {
            Upload uploadRec = new Upload();
            uploadRec.setId(rs.getString("id"));
            uploadRec.setFilename(rs.getString("filename"));
            uploadRec.setExpires(rs.getDate("expires"));
            uploadRec.setUploader(rs.getString("uploader"));
            uploadRec.setContentType(rs.getString("contenttype"));
            uploadRec.setSize(rs.getLong("filesize"));
            return uploadRec;
        }
    });

    return uploadRec;
}

---

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

@Override
public Application getByUsername(String username) {
    //get the application that the user requested,criteria : 1: username , 2: application is not online 
    String query = "SELECT app_code,amount,repayTime,buy_type,drivers_license,taxes,tekmiriwsi,status,accepted,username "
            + "FROM Application WHERE username= ? AND isOnline=0 AND status =1 AND accepted=1 LIMIT 1";
    try {/*  ww  w .  j  av a2  s.  c om*/
        //open jdbc connection
        JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
        //get an object with the requested application
        Object queryForObject = jdbcTemplate.queryForObject(query, new Object[] { username },
                new BeanPropertyRowMapper<Application>(Application.class));
        //Create an application object and return it
        Application app = (Application) queryForObject;
        return app;
    } catch (EmptyResultDataAccessException e) {
        //if no results returned , create an empty application and sent it
        Application app = new Application(0, 0, 0, "", "", 0, "", 0, 0, "");
        return app;
    }
}

---

From source file:com.rplt.studioMusik.member.MemberDAO.java

@Override
public int simulateKurangSaldo(String pUsername, int pValue) {
    String sql = "SELECT saldo_member FROM MEMBER_STUDIO_MUSIK WHERE username_member = ?";
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    return jdbcTemplate.queryForObject(sql, Integer.class, pUsername) - pValue;
}

---

From source file:com.rplt.studioMusik.member.MemberDAO.java

@Override
public String getNoTelpByUser(String pUsername) {
    String sql = "SELECT no_telp_member FROM member_studio_musik WHERE username_member = ?";
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    return jdbcTemplate.queryForObject(sql, String.class, pUsername.toUpperCase());
}

---

From source file:com.rplt.studioMusik.member.MemberDAO.java

@Override
public int getSaldo(String pUsername) {
    String sql = "SELECT saldo_member FROM member_studio_musik WHERE username_member = ?";

    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    return jdbcTemplate.queryForObject(sql, Integer.class, pUsername);
}

---

From source file:com.rplt.studioMusik.member.MemberDAO.java

@Override
public String getNamaByUser(String pUsername) {
    String sql = "SELECT nama_member FROM member_studio_musik WHERE username_member = ?";
    JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
    return jdbcTemplate.queryForObject(sql, String.class, pUsername.toUpperCase());

}

---

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