Example usage for org.springframework.jdbc.core BeanPropertyRowMapper newInstance

Introduction

In this page you can find the example usage for org.springframework.jdbc.core BeanPropertyRowMapper newInstance.

Prototype

public static <T> BeanPropertyRowMapper<T> newInstance(Class<T> mappedClass)

Source Link

Document

Static factory method to create a new BeanPropertyRowMapper (with the mapped class specified only once).

Usage

From source file:kniznica.SQLHerec.java

@Override
public List<Herec> dajVsetkych() {
    String sql = "SELECT * FROM herec";
    BeanPropertyRowMapper<Herec> mapper = BeanPropertyRowMapper.newInstance(Herec.class);
    return jdbcTemplate.query(sql, mapper);
}

From source file:kniznica.SQLReziser.java

@Override
public List<Reziser> dajVsetkych() {
    String sql = "SELECT * FROM reziser";
    BeanPropertyRowMapper<Reziser> mapper = BeanPropertyRowMapper.newInstance(Reziser.class);
    return jdbcTemplate.query(sql, mapper);
}

From source file:kniznica.SQLScenarista.java

@Override
public List<Scenarista> dajVsetkych() {
    String sql = "SELECT * FROM scenarista";
    BeanPropertyRowMapper<Scenarista> mapper = BeanPropertyRowMapper.newInstance(Scenarista.class);
    return jdbcTemplate.query(sql, mapper);
}

From source file:kniznica.SQLFilm.java

@Override
public List<Film> dajVsetkych() {
    String sql = "SELECT * FROM filmy";
    BeanPropertyRowMapper<Film> mapper = BeanPropertyRowMapper.newInstance(Film.class);
    return jdbcTemplate.query(sql, mapper);
}

From source file:sk.upjs.ics.autobazar.MySqlInzeratNakladneDao.java

@Override
public List<InzeratNakladne> dajVsetky() {
    String sql = "SELECT * FROM inzeratNakladne";
    BeanPropertyRowMapper<InzeratNakladne> mapper = BeanPropertyRowMapper.newInstance(InzeratNakladne.class);
    return jdbcTemplate.query(sql, mapper);
}

From source file:sk.upjs.ics.autobazar.MySqlInzeratKaravanDao.java

@Override
public List<InzeratKaravan> dajVsetky() {
    String sql = "SELECT * FROM inzeratKaravan";
    BeanPropertyRowMapper<InzeratKaravan> mapper = BeanPropertyRowMapper.newInstance(InzeratKaravan.class);
    return jdbcTemplate.query(sql, mapper);
}

From source file:kniznica.SQLHerec.java

@Override
public Herec podlaID(int id) {
    String sql = "SELECT * FROM herec where id = " + id;
    BeanPropertyRowMapper<Herec> mapper = BeanPropertyRowMapper.newInstance(Herec.class);
    List<Herec> herci = jdbcTemplate.query(sql, mapper);
    Herec vysledny = herci.get(0);//from  ww w. java2  s  .  co m
    return vysledny;
}

From source file:kniznica.SQLReziser.java

@Override
public List<Reziser> dajVsetkychZID(String id) {
    String sql = "SELECT * FROM reziser WHERE id = " + id;
    BeanPropertyRowMapper<Reziser> mapper = BeanPropertyRowMapper.newInstance(Reziser.class);
    return jdbcTemplate.query(sql, mapper);
}

From source file:sk.upjs.ics.autobazar.MySqlInzeratNakladneDao.java

@Override
public List<InzeratNakladne> vyhladaj(String znacka, String model, String odRocnik, String doRocnik) {
    String sql = "SELECT * FROM inzeratNakladne";
    BeanPropertyRowMapper<InzeratNakladne> mapper = BeanPropertyRowMapper.newInstance(InzeratNakladne.class);
    List<InzeratNakladne> pomocna = jdbcTemplate.query(sql, mapper);
    List<InzeratNakladne> pomocna2 = new LinkedList<InzeratNakladne>();
    for (InzeratNakladne a1 : pomocna) {
        if (a1.getZnacka().equals(znacka)) {
            if (a1.getModel().equals(model)) {
                int a = a1.getRocnik().compareTo(odRocnik);
                int b = a1.getRocnik().compareTo(doRocnik);
                if (a >= 0 && b <= 0) {
                    //System.out.println(" ");
                    pomocna2.add(a1);/*from w ww.  j a  v a2 s  .  com*/
                }
            }
        }
    }
    return pomocna2;
}

From source file:kniznica.SQLScenarista.java

@Override
public List<Scenarista> dajVsetkychZID(String id) {
    String sql = "SELECT * FROM scenarista WHERE id = " + id;
    BeanPropertyRowMapper<Scenarista> mapper = BeanPropertyRowMapper.newInstance(Scenarista.class);
    return jdbcTemplate.query(sql, mapper);
}