Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public List<Jugador> getJugadores(String filtro) throws SQLException{
- List<Jugador> lista = new ArrayList<>();
- String query = "SELECT * FROM jugador " +
- "WHERE nombre LIKE '%"+filtro+"%' OR " +
- "pais LIKE '%"+filtro+"%' OR " +
- "posicion LIKE '%"+filtro+"%' OR " +
- "equipo LIKE '%"+filtro+"%' OR " +
- "dorsal LIKE '%"+filtro+"%';";
- ResultSet rs = con.ejecutarSelect(query);
- Jugador j;
- while(rs.next()){
- j = new Jugador();
- j.setId(rs.getInt(1));
- j.setNombre(rs.getString(2));
- j.setPais(rs.getString(3));
- j.setPosicion(rs.getString(4));
- j.setEquipo(rs.getString(5));
- j.setDorsal(rs.getInt(6));
- lista.add(j);
- }
- con.desconectar();
- return lista;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement