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

Introduction

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

Prototype

public BeanPropertyRowMapper(Class<T> mappedClass)

Source Link

Document

Create a new BeanPropertyRowMapper , accepting unpopulated properties in the target bean.

Usage

From source file:com.anthony.forumspring.dao.UsersDao.java

@Override
public List<Users> findAll() {
    String sql = "Select * from users";
    return this.jdbcTemplate.query(sql, new BeanPropertyRowMapper(Users.class));

}

From source file:com.anthony.forumspring.dao.CategorieDao.java

@Override
public List<Categorie> findAllC() {
    String sql = "SELECT * FROM CATEGORIE";
    return this.jdbcTemplate.query(sql, new BeanPropertyRowMapper(Categorie.class));

}

From source file:com.practice.web.repository.impl.JdbcPersonRepository.java

public List<Person> getListPerson() {
    return jdbc.query("select * from person order by id", new BeanPropertyRowMapper(Person.class));
}

From source file:com.anthony.forumspring.dao.TopicsDao.java

@Override
public List<Topics> findAllById(int catId) {
    String sql = "SELECT * FROM TOPICS where cat_id = " + catId;
    return jdbcTemplate.query(sql, new BeanPropertyRowMapper(Topics.class));
}

From source file:nbadb.DAO.TeamJDBCTemplate.java

public List<TeamDAO> getGameHeader(int teamid) {
    String SQL = "SELECT * FROM gameheader WHERE HomeTeamID=" + teamid + " OR  AwayTeamId=" + teamid + "";
    List<TeamDAO> gameheader = template.query(SQL, new BeanPropertyRowMapper(GameHeader.class));
    return gameheader;
}

From source file:com.anthony.forumspring.dao.CommentaireDao.java

@Override
public List<Commentaire> findAll() {
    String sql = "Select * from commentaires";
    return this.jdbcTemplate.query(sql, new BeanPropertyRowMapper(Commentaire.class));

}

From source file:Spring.Repaso02.ProductoDAO.java

public ArrayList<Producto> consultaAll(GregorianCalendar fecha) {
    int dia = (7 + fecha.get(Calendar.DAY_OF_WEEK) - Calendar.SUNDAY) % 7;
    String selQuery = "select * from TProductos where Disponible = 0 or Disponible = ?";
    List productos = jdbcTemplate.query(selQuery, new Object[] { dia },
            new BeanPropertyRowMapper(Producto.class));
    return (ArrayList) productos;

}

From source file:com.anthony.forumspring.dao.TopicsDao.java

@Override
public List<Topics> findAll() {
    String sql = "SELECT * FROM TOPICS";
    return jdbcTemplate.query(sql, new BeanPropertyRowMapper(Topics.class));
}

From source file:eu.ibacz.swsc.spring.di.testdependencyinjection.dao.impl.JdbcTemplateCustomerDaoImpl.java

public List<Customer> findAll() {
    List<Customer> customerList = getJdbcTemplate().query("select id, firstname, lastname from customer",
            new BeanPropertyRowMapper<Customer>(Customer.class));
    return customerList;
}

From source file:com.corp.repository.StudentRepository.java

/**
 *
 * @param ids//from   w  w w.  j a va2  s.  c om
 * @return
 */
public List<StudentModel> getUsers(String ids) {
    // System.out.println(ids);
    return jdbc.query("SELECT * FROM student WHERE id in (?)", new String[] { ids },
            new BeanPropertyRowMapper(StudentModel.class));
}