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; } });
Lascia un commento