1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
public Reference getReference(String idRole,String idUser){ String sql="SELECT * FROM refers WHERE id_role=? AND id_user=?"; Reference ref=(Reference)jdbcTemplate.queryForObject(sql, new Object[]{idRole,idUser},new BeanPropertyRowMapper(Reference.class){ public Reference extractData(ResultSet rs) throws SQLException,DataAccessException{ Reference ref=new Reference(); ref.setId(rs.getInt("id")); ref.setIdRole(rs.getString("id_role")); ref.setIdUser(rs.getString("id_user")); ref.setDescription(rs.getString("description")); return ref; } }); |