public List<Veiculo> listarPorPlaca(String placa) { List<Veiculo> listaVeiculos = new ArrayList<Veiculo>(); try { Connection con = DatabaseConnection.getConnection(); StringBuffer sb = new StringBuffer(); sb.append("SELECT * "); sb.append("FROM veiculo WHERE placa like ?"); PreparedStatement st = con.prepareStatement(sb.toString()); st.setString(1, "%" + placa + "%"); ResultSet rs = st.executeQuery(); while (rs.next()) { Veiculo v = new Veiculo(); v.setPlaca(rs.getString("placa")); v.setChassi(rs.getString("chassi")); v.setMarca(rs.getString("marca")); v.setModelo(rs.getString("modelo")); v.setAnoFabricacao(rs.getInt("anofabricacao")); v.setAnoModelo(rs.getInt("anomododelo")); v.setCarroceria(rs.getString("carroceria")); v.setCapacidadeCarga(rs.getInt("cap_carga")); v.setStatus(rs.getString("status")); listaVeiculos.add(v); } con.close(); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } return listaVeiculos; }